Discussion Board for collaboration on QlikView Scripting.
Has anyone connected to IDAA as a source for a QlikView datasource? How have you set the special registry to verify you are hitting the IDAA and not the underlying DB2 table?
I guess you can try Qlik custom ODBC connector.
Or contact Qlik support team
You just need to include a separate line which I believe modifies the special register:
SQL SET CURRENT QUERY ACCELERATION ALL;
ODBC CONNECT TO DBNAME(XUserId is UserId, XPassword is XPassword);
SET CURRENT QUERY ACCELERATION ALL;
SQL Select *
WHERE FIELD= 'VALUE'