Help with AS400 database query - Qlik Community

Anonymous · ‎2018-08-16

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?

petter · ‎2018-08-16

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

Anonymous · ‎2018-08-27

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.