Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

Launch application_info before sql Query

Hello everyone,

i have a script that need to execute this piece of sql code before performing the select via odbc to the database:

BEGIN

dbms_application_info.set_client_info (151);

END;

if this operation is not performed the select wont pick all the data in the table. I searched the community but could not find any information related to this kind of issue.

Thank you in advance,

Juan Pedro

2 Replies

Re: Launch application_info before sql Query

Perhaps like this:

SQL EXECUTE dbms_application_info.set_client_info (151);

SQL SELECT ... FROM etc...';


But I don't really know, so perhaps you need to ask your local friendly DBA to create a proper stored procedure for you that you can call.


talk is cheap, supply exceeds demand
Not applicable

Re: Launch application_info before sql Query

Hello and thanks for the fast reply.

I tried what you suggested and inserted the sql execute before the select statement.

The execute statement throws this error.

app_info_error.jpg

The query is still executed correctly.

will check if is it a true syntax error

Community Browser