I am accessing an AS400 database using the IBM iSeries Driver. It has worked for every table I need. However, now I am trying to access a table and it is giving me this error:
"The Operation Failed. There are too many indexes on table 'PWRDTA_HHHORDHP'. Delete some of the indexes on the table and try the operation again."
Since this is our 3rd party POS software, I have no ability to edit the # of indexes. So I needed to look for a solution. I found Pass Through Queries. http://www.kb.blackbaud.co.uk/articles/Article/52445
However, I cannot figure out how to do the connection String for the AS400. I keep getting this error for the Pass through query:
"ODBC--call failed. [IBM][System i Access ODBC Driver][DB2 for i5/OSJSQL0104 - Token ; was not valid tokens: <END-OF-STATEMENT>. (#-104).
What do I need to do to get the pass through working with the AS400?
"The Operation Failed. There are too many indexes on table 'PWRDTA_HHHORDHP'. Delete some of the indexes on the table and try the operation again."
Since this is our 3rd party POS software, I have no ability to edit the # of indexes. So I needed to look for a solution. I found Pass Through Queries. http://www.kb.blackbaud.co.uk/articles/Article/52445
However, I cannot figure out how to do the connection String for the AS400. I keep getting this error for the Pass through query:
"ODBC--call failed. [IBM][System i Access ODBC Driver][DB2 for i5/OSJSQL0104 - Token ; was not valid tokens: <END-OF-STATEMENT>. (#-104).
What do I need to do to get the pass through working with the AS400?