Executing T-SQL statements in Qlik Sense

[Aditya_Chitale]

Hi All,

I have been provided with T-SQL statements which is to be run in Qlik Sense environment.

The sql statements upload daily data into the database (not uploaded from QlikSense).

SQL code looks something like this:

BEGIN
      MYVIEW_DATA.REFRESH_CALL('XYZ');
END;

Executing this code in QS, gives me below error:

QlikSense code format Used for SQL statement execution:

Any help in resolving this would be appreciated.

Regards,

Aditya

[WaltShpuntoff]

I am not sure if this would work since it is driver dependent.

Try this:

sql

Exec MYVIEWDATA.REFRESH_CALL('XYZ');

Are you expecting this to return data?

-ws

[Aditya_Chitale]

Tried this as well. Not expecting to return data. I am using this to push data into the database. same way in which a regular stored procedure can be run in Qlik sense to insert data into database tables.

regards,

Aditya

[WaltShpuntoff · Accepted solution]

I do not believe that what you are trying to do will work.

QlikSense is looking for you to load data.

If you were to modify your SQL call to return some value like # records impacted, then you can try loading the return value. You can drop the Qlik table afterwards since you don't really care about that.

-ws