Last updated on MARCH 24, 2017
Applies to:Oracle Database Provider for DRDA - Version 22.214.171.124 and later
User session gets -901 SQLCODE on AS400 when selecting from large table, and setup is working fine when selecting data from other tables.
Connection is from DB2 on AS400 iSeries v7.2, through "Oracle Database Provider for DRDA" (DP4DRDA) 126.96.36.199 running on Linux x86-64,
to Oracle 188.8.131.52.160119 Database (w/ Jan 2016 DB PSU patch 21948354) on Linux x86-64.
After they granted privilege for Collection "QSQL400" to user TESTAR last month, they were then able to BIND the AS400 packages named QSQCLIPx,
per Solution A in Doc ID 2179330.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms