How to execute/load store procedure

[bsbernabe]

Hello There,

I'm trying to load my store proc. in Qlikview but just happen not working when i try using sql editor apply this script:

Execute Procedure P_BRANCH_INVENTORY ('user') was good

but when i try to apply this in Qlikview not working can you guide me how to load or execute StoreProc in qlikview

i also try SQL EXEC P_BRANCH_INVENTORY but still not working.

Best Regards,

Bing

[qlikviewwizard]

Hi Check these threads.

Stored Procedure

Stored procedure execution help

Re: Table not found in Stored Proc

[bsbernabe]

Hello There,

This is my setup

ODBC CONNECT TO [AWS BIMS] (XUserId is DSXcHZFMQbcKN, XPassword is NDVfFZFMQbcCDZMGMH)

SQL execute procedure P_BRANCH_INVENTORY ('USER')   when i run this still not working

[Peter_Cammaert]

What is not working? Do you get an error message? Do you get no data while you should? Do you get the wrong data?

[bsbernabe]

When i execute this:

SQL execute procedure P_BRANCH_INVENTORY ('USER') not working cannot execute so I change my script to:

ODBC CONNECT TO [AWS BIMS] (XUserId is DSXcHZFMQbcKN, XPassword is NDVfFZFMQbcCDZMGMH);

SQL EXECUTE P_BRANCH_INVENTORY;

can connect but i having error in my script:

I got this ERROR:

SQL##f - SqlState: HY000, ErrorCode: 4294967192, ErrorMsg: [ODBC Firebird Driver][Firebird]Dynamic SQL Error

SQL error code = -104

Token unknown - line 1, column 9

P_BRANCH_INVENTORY

SQL EXECUTE P_BRANCH_INVENTORY

[Peter_Cammaert]

The bottom error is probably because EXECUTE must be followed by either PROCEDURE or BLOCK.

On the other hand, you're still not telling what is happening when you try to execute the full statement, listed at the top. It "doesn't work" and "cannot execute" are not very helpful. Can you supply some more details?

[Peter_Cammaert]

Just for fun, try the first statement again but now without parentheses. They're optional anyway...

[bsbernabe]

Thank you for your support Peter i found another way for this Store Procedure also can do that by

selection.

SQL SELECT * FROM P_BRANCH_INVENTORY ('user name')  now is working.

Thank You Guys