topic Stored Procedure in QlikView

Stored Procedure

Tue, 22 Jun 2010 10:53:15 GMT

I am executing a Stored Procedure named CreateTable in QlikView which is executing successfully.

My Stored Procedure takes 15 minuets to execute, soon after the execution of Stored Procedure by QlikView I want QlikView to Load statements. How is this possible.

Edit Script:

ODBC CONNECT TO NEW (XUserId is HEAeQZFMKD, XPassword is aYNIUQJMDLMETZEK);

SQL exec CreateTable;

Stored Procedure

Miguel_Angel_Baeyens — Tue, 22 Jun 2010 11:24:16 GMT

Hello Khalid,

As far as I understand, you want first execute that stored procedure and later load one table from the same ODBC in the same script.

If so, your script should look like

ODBC CONNECT TO NEW ();SQL EXEC CreateTable; Table:LOAD Field1, Field2; SQL SELECT Field1, Field2 FROM SQLDATABASE_TABLE;

Hope it helps.

Stored Procedure

Tue, 22 Jun 2010 11:38:43 GMT

Dear Miguel,

This is great, but my stored procedure takes 15 minutes for a single table and in between it starts loading so i get an incomplete data. How is it possible that whole stored procedure should run first and after the completion of the stored procedure my QlikView load statements should start executing. Is there any delay function for this purpose?

Many thanks

Khalid

Stored Procedure

Miguel_Angel_Baeyens — Tue, 22 Jun 2010 12:01:32 GMT

Khalid,

I missed that you were executing. Try using SLEEP n; before the LOAD statement, where n are milliseconds. That should wait time enough to the stored procedure to be executed. I'm not sure if there is a better way to do it.

Stored Procedure

Tue, 22 Jun 2010 12:23:12 GMT

Dear, I am trying to use SLEEP now.

Regards,

Khalid