Varable Value not loaded correctly into INLINE table

[sreenivaskollur]

Hi,

I'm new to QlikView development, could someone help me to fix this issue?

I'm using the below script to capture the error details if the hive connection is failed.

Sample script,

ODBC CONNECT TO [HIVE-DB];

LET vCapturedError=ScriptErrorDetails;

TRACE $(vCapturedError);

LOAD * INLINE [

    DB, Connection_Status, Error

    HIVE-DB, Failed, '$(vCapturedError)'

];

If I trace a variable vCapturedError, it shows the output as below, which the actual error:

SQL##f - SqlState: IM002, ErrorCode: 0, ErrorMsg: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified

But when I read the same variable value in LOAD * INLINE table, it is just loading a piece of it as:

'SQL##f - SqlState: IM002

Please help to fix it?

Your help is much appreciated, thank you!

[sreenivaskollur]

Thank you Sunny. This works.

[sreenivaskollur]

Thank you Vishwanath. I tried both the ways that Sunny and you had suggested. Both are working great.