topic Re: LOAD a store procedures in a table in QlikView

LOAD a store procedures in a table

Thu, 09 May 2013 16:07:19 GMT

HI Again;

Thanks for your helps i executed a store procedures from Qlikview this way;

ODBC

CONNECT TO mgtmexbaan6 (XUserId is PeCUMcRNTLbIXcVK, XPassword is KAJINZVMBDZcJ);

SQL EXEC dbo.rmmMtyBom010Fill;

IT IS POSSIBLE TO LOAD the result of this store procedures in a table of Qlik View????

can you help???

calvindk — Thu, 09 May 2013 16:10:16 GMT

Depending on how the Sproc works, these options are available

If it just returns a data set then:

ODBC

CONNECT TO mgtmexbaan6 (XUserId is PeCUMcRNTLbIXcVK, XPassword is KAJINZVMBDZcJ);

QVTableName:
SQL EXEC dbo.rmmMtyBom010Fill;

Disconnect;

If it creates tables then:

ODBC

CONNECT TO mgtmexbaan6 (XUserId is PeCUMcRNTLbIXcVK, XPassword is KAJINZVMBDZcJ);

SQL EXEC dbo.rmmMtyBom010Fill;

TableName:

Selec * FROM OoutputTableName;

TableName2:

Select * FROM OoutputTableName2;

Disconnect;

Thu, 09 May 2013 16:19:27 GMT

ok perfect thanks for your help !!!!