topic Re: Launch application_info before sql Query in QlikView

Launch application_info before sql Query

Fri, 08 Apr 2016 09:22:01 GMT

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

Re: Launch application_info before sql Query

Gysbert_Wassenaar — Fri, 08 Apr 2016 09:29:37 GMT

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.

Re: Launch application_info before sql Query

Fri, 08 Apr 2016 09:58:59 GMT

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.

The query is still executed correctly.

will check if is it a true syntax error