topic Re: Scripting code re-use in QlikView

Scripting code re-use

Wed, 15 Oct 2014 09:37:42 GMT

Hi,

I have 2 db connections, in each connection I have to repeat same code (i.e. I have read same data fields/tables)

How do i implement code re-use functionality? is below logic correct? OR anyone have better idea?

DB Connection 1.

$(Include=test code.txt);

DB Connection 2.

$(Include=test code.txt);

My test code.txt file will contain all my load statements.

Is that correct?

Thanks.

Re: Scripting code re-use

Wed, 15 Oct 2014 09:41:14 GMT

Hi,

I f u have 2 db connections from one database they it is fine.

but if u have 2 db connections from 2 different databases then you can do like this

DB Connection 1.

$(Include=test code.txt);

disconnect;

DB Connection 2.

$(Include=test code.txt);

at a time QV wn't connect to 2 DB's so u need to do Disconnect a 1 db then connect to another db.

Re: Scripting code re-use

jagan — Wed, 15 Oct 2014 09:42:02 GMT

Hi,

This is the best method, if there is a change in Query you can just change query in text file one time no need to change twice.

Regards,

Jagan.

Re: Scripting code re-use

alexandros17 — Wed, 15 Oct 2014 09:42:11 GMT

I should write a sub ... end sub and use it with a call so you write the code once and call it as if it was a function ...

Let me know

Re: Scripting code re-use

MK_QSL — Wed, 15 Oct 2014 09:42:31 GMT

Open you script editor...

FILE -- Export to Script File

Save to any place as per your choice

Open the Script Editor where you want to re-use

Insert

Include Statement

Select that file...

Re: Scripting code re-use

ashfaq_haseeb — Wed, 15 Oct 2014 09:44:52 GMT

hi make sure even schema is same.

Then this is best approach.

Regards

ASHFAQ

Re: Scripting code re-use

Wed, 15 Oct 2014 09:46:38 GMT

Hi All Thanks for reply.

I will follow.

DB Connection 1.

$(Include=test code.txt);

disconnect;

DB Connection 2.

$(Include=test code.txt);

@ Alessandro, I didn't get your point. Do you have any sample doc which will help to understand more?

Thanks.

Re: Scripting code re-use

alexandros17 — Wed, 15 Oct 2014 10:07:20 GMT

Sub MySubName

load * from ...

End Sub

Odbc connect to DB1;

CALL MySubName;

Odbc Connect to DB2;

CALL MySubName;