Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

How to call store procedure sql in QlikView

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,

1 Solution

Accepted Solutions
Employee
Employee

Re: How to call store procedure sql in QlikView

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.

2 Replies
Employee
Employee

Re: How to call store procedure sql in QlikView

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.

Not applicable

Re: How to call store procedure sql in QlikView

Thanks Josh,

Community Browser