Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
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
Josh_Good
Employee
Employee

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.

View solution in original post

2 Replies
Josh_Good
Employee
Employee

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
Author

Thanks Josh,