topic execute stored procedure error in QlikView

execute stored procedure error

alec1982 — Thu, 16 Jan 2014 05:30:31 GMT

Hi guys,

I am trying to execute the following stored procedure but i am getting errors... any advice?

EXECUTE sdobj.GETSTNGROSSAMOUNT (#coson) from sddta.cusord where #coson=800300

I have never used stored procedures before so I am not sure if the above script is correct..

Thxs,

Alec

Re: execute stored procedure error

Siva_Sankar — Thu, 16 Jan 2014 05:39:34 GMT

First step is that you have to create a variable for each parameter you need to pass to the Store Procedure. In this example, let's suppose you just have a single date parameter:

let vDate = '2013-01-01' //here is important to use the same format that is used in the database

Store_Procedure_table:

Load * ;

SQL EXECUTE DB.OWNER.STORE_PROCEDURE '$(vDate)'; //with the last part you're passing the needed parameter

If you had several parameters you can separate them with commas and alwas with the $-expansion and between single quotes,

Regards.

Siva

Re: execute stored procedure error

jagan — Thu, 16 Jan 2014 05:49:23 GMT

Hi,

Try like this

LET coson = 'StoredProcedureParameterValue';

TableName:

SQL EXECUTE sdobj.GETSTNGROSSAMOUNT ($(StoredProcedureParameterValue)) ;

Where your stored procedure in the database should have the following code

CREATE PROCEDURE sdobj.GETSTNGROSSAMOUNT

(

value INT

)

BEGIN

SELECT * from sddta.cusord where #coson=value

END

Hope this helps you.

Regards,

Jagan.

Re: execute stored procedure error

Thu, 16 Jan 2014 06:18:27 GMT

Hi,

Please try the following code:

SQL
EXEC ProcedureName
@Parameter1='Data',
@Parameter2='Data'
;
SQL SELECT *
FROM TemptableName;

In this TemptableName is the table in which the procedure stores the output.

Hope this helps.

-Shruti

Re: execute stored procedure error

alec1982 — Fri, 17 Jan 2014 02:26:02 GMT

Hi guys,

Thank you for the details however none of them helped..

Anybody can help and give me how my script should look like to query the stored procedure giving the above details?

As I said I'm not an expert when it comes to stored procedures.

Thxs for your help.

Alec

Re: execute stored procedure error

jagan — Fri, 17 Jan 2014 02:38:16 GMT

Hi,

Do you have stored procedure in the stored procedure in the database? If not then you have to create it in database, or else if it is a query you can just directly execute that query like

TableName:

SQL SELECT * from sddta.cusord where #coson=800300;

Hope this helps you.

Regards,

Jagan.

Re: execute stored procedure error

alec1982 — Fri, 17 Jan 2014 02:43:52 GMT

Hello,

Thank you for your help but SQL SELECT * from sddta.cusord where #coson=800300; doesn't bring what I am looking for and yes there is a stored procedure in the database..

Thxs,

Alec

Re: execute stored procedure error

iktrayanov — Fri, 17 Jan 2014 03:03:47 GMT

The first thing i wold try is to execute the SQL statement on the server to make sure it works.

So try

SELECT * from sddta.cusord where #coson=800300

on your SQL server

Re: execute stored procedure error

jagan — Fri, 17 Jan 2014 03:09:05 GMT

Hi,

Check this

Stored Procedure Parameters SQL

Regards,

Jagan.