Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I am trying to query an AS400 database but the challenge am having is that the file am opening has data under a different member.
On AS400 if we want to query this file we have to override the member so that when I do the SQL query from AS400 I see the information I need.
How can I do that in Qlikview loading script? or is that not even possible?
No QlikView will only allow you to set the options that the OLEDB or ODBC driver allows. None of them seem to handle member selection in any way. This post seems to list the options you have which has to be done at the AS/400 / iSeries side:
https://www.brightersoftware.net/using-sql-on-file-with-multiple-members
We ended up creating a different table/file in AS400 (Logical) that Qlikview could access under the default member.
That solved the issue.
I also contacted Qlik support and the feedback I got was that it wasn't possible to query under a different member under the load script itself. The data would have to be massaged either on an SQL database prior to being loaded into Qlikview.