Stored Procedure

[#1]

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;

[Miguel_Angel_Baeyens · Accepted solution]

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.

[#3]

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

[Miguel_Angel_Baeyens]

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.

[#5]

Dear, I am trying to use SLEEP now.

Regards,

Khalid