topic Re: How to execute/load store procedure in QlikView

How to execute/load store procedure

bsbernabe — Wed, 25 Nov 2020 16:16:04 GMT

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

Re: How to execute/load store procedure

qlikviewwizard — Tue, 26 Jun 2018 03:21:13 GMT

Hi Check these threads.

Stored Procedure

Stored procedure execution help

Re: Table not found in Stored Proc

Re: How to execute/load store procedure

bsbernabe — Tue, 26 Jun 2018 06:10:26 GMT

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

Re: How to execute/load store procedure

Peter_Cammaert — Tue, 26 Jun 2018 07:09:32 GMT

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

Re: How to execute/load store procedure

bsbernabe — Tue, 26 Jun 2018 07:16:21 GMT

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

Re: How to execute/load store procedure

Peter_Cammaert — Tue, 26 Jun 2018 07:25:47 GMT

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?

Re: How to execute/load store procedure

Peter_Cammaert — Tue, 26 Jun 2018 07:29:41 GMT

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

Re: How to execute/load store procedure

bsbernabe — Tue, 26 Jun 2018 07:53:03 GMT

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