topic Re: Stored Procedure Parameters SQL in QlikView

Stored Procedure Parameters SQL

Thu, 19 Sep 2013 12:55:22 GMT

Hello

I used stored procedures to bring my qlikview data, and it always works, now I need to pass a parameter which is the name of the user and the domain

but does not work, you can be wrong?

Thanks, regards

Cesar Estrada

vUserx = OSUser();

OLEDB CONNECT TO [Provider=SQLNCLI10.1;Integrated Security="";Persist Security Info=...............................................];

sql exec ('[SERVER\XXX].[DBASE].[dbo].[gtStep1O] vUserx ' ) ;

Re: Stored Procedure Parameters SQL

pgrenier — Thu, 19 Sep 2013 12:58:56 GMT

If you would like QlikView to send the contents of the variable through the SQL EXEC statement, you might want to add $() around the variable name, such as:

sql exec ('[SERVER\XXX].[DBASE].[dbo].[gtStep1O] $(vUserx) ' ) ;

Cheers,

Philippe

Re: Stored Procedure Parameters SQL

Thu, 19 Sep 2013 13:11:50 GMT

Hi Philippe:

when execute the script return this error

ErrorSource: Microsoft SQL Server Native Client 10.0, ErrorMsg: Incorrect syntax near '\'.

sql exec ('[SERVER\XXX].[DBASE].[dbo].[gtpaso1O] DOMAIN\cestrada ' )

Thanks!

César

Re: Stored Procedure Parameters SQL

Thu, 19 Sep 2013 13:21:32 GMT

sql exec ('[SERVER\XXX].[DBASE].[dbo].[gtStep1O] "$(vUserx)" ' )

Now Work Perfect!!

Thanks Philippe!!

Regards

César

Re: Stored Procedure Parameters SQL

pgrenier — Thu, 19 Sep 2013 13:28:35 GMT

Good catch César