topic How to call store procedure sql in QlikView in QlikView

How to call store procedure sql in QlikView

Fri, 28 Sep 2012 22:11:49 GMT

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,

Re: How to call store procedure sql in QlikView

Josh_Good — Fri, 28 Sep 2012 22:17:51 GMT

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.

Re: How to call store procedure sql in QlikView

Wed, 14 Nov 2012 15:13:02 GMT

Thanks Josh,