topic Re: Variable error in QlikView

Variable error

NavinReddy — Mon, 11 Jun 2018 09:13:53 GMT

Hi All,

i have assigned one connection string to variable, i am using that variable in qlikview.

when im running qlikview script im not able to connect to the Oracle database.

without using variable im able to connecto to the database.

kindly suggest me

Thanks in Advance,

Niranjan

Re: Variable error

saimahasan — Mon, 11 Jun 2018 10:34:31 GMT

Can you check the value of the variable Vname in your qlikview application???

Re: Variable error

mayankraoka — Mon, 11 Jun 2018 11:14:18 GMT

Just wanted to check have you written that variable or call that variable in script?

Regards,

Mayank

Re: Variable error

sunny_talwar — Mon, 11 Jun 2018 11:20:08 GMT

I think you forgot to use the variable before you pull from the database query

CONNECT TO $(Vname);

DIM1:

LOAD "FCT_TMPLT_ID",

"TMPLT_NM",

"TMPLT_STS_CD",

"TMPLT_EFF_DT",

"TMPLT_TERM_DT",

"TMPLT_CRE_USR_ID",

"TMPLT_CRE_TS",

"TMPLT_UPDT_USR_ID",

"TMPLT_UPDT_TS",

"BYPASS_IN",

"RAG_CMNT_CD",

"RAG_UPLD_IN";

SQL SELECT FCT_TMPLT_ID, TMPLT_NM, TMPLT_STS_CD, TMPLT_EFF_DT, TMPLT_TERM_DT, TMPLT_CRE_USR_ID, TMPLT_CRE_TS, TMPLT_UPDT_USR_ID, TMPLT_UPDT_TS, BYPASS_IN, RAG_CMNT_CD, RAG_UPLD_IN

FROM "OMP_MASTER"."MVW_TMPLT_FCTSETUP_CCB"

;

Re: Variable error

NavinReddy — Mon, 11 Jun 2018 13:05:37 GMT

Thanks for your response its working

when its connecting to the database its asking user namd password,

connection string it self already has user name and passowrd.

Please suggest

Re: Variable error

sunny_talwar — Mon, 11 Jun 2018 13:09:47 GMT

If you don't create a variable, you don't see this behavior?