Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi , I need to call a store procedure de sql in QlikView.
Buenas Tardes alquien me podra ayudar con un detalle deseo cargar un Store Procedure de SQL desde QlikView
Thanks,
If you are using an OLE DB connection then you need to use write mode in the connection string (see this post for more info http://community.qlik.com/thread/3223). I find it easier to just use an ODBC connection.
Once connected the format is:
Load
Field1
Field2
...
;
Sql Exec StoredProcedureName 'Variable1', 'Variable2'
;
Hope that helps.
If you are using an OLE DB connection then you need to use write mode in the connection string (see this post for more info http://community.qlik.com/thread/3223). I find it easier to just use an ODBC connection.
Once connected the format is:
Load
Field1
Field2
...
;
Sql Exec StoredProcedureName 'Variable1', 'Variable2'
;
Hope that helps.
Thanks Josh,