IBM Support

SQL0901 - SQL system error

Troubleshooting


Problem

Error [81][IBM][Client Access ODBC Driver (32-bit)][DB2/400 SQL]SQL0901 - SQL system error When running a query containing a SELECT DISTINCT. This is from an excerpt from an ODBCSpy trace file: SQLExecDirect 0x01010001 [64]select distinct T257."ACCT_ID" "c1" from "QCIMPROM"."ACCT" T257 SQL_NTS SQL_ERROR SQLError NULL NULL 0x01010001 [5]S100 901 [81][IBM][Client Access ODBC Driver (32-bit)][DB2/400 SQL]SQL0901 - SQL system error. 512 81 SQL_SUCCESS This is an example of a job log generated with the error message. Job 009789/QUSER/QZDASOINIT started on 02/01/99 at 14:46:29 in subsystem QSERVER in QSYS. Job entered system on 02/01/99 at 14:46:29. ACGDTA for 009789/QUSER/QZDASOINIT not journaled; reason 1. Servicing user profile QCIMPROM. Pointer not set for location referenced. Function check. MCH3601 unmonitored by QQQVAP at statement *N, instruction X'0ABB'. Internal failure occurred in query processor. Dump output directed to spooled file 2. Function check. CPF4204 unmonitored by QQQQUERY at statement *N, instruction X'23D6'. SQL system error. Data mapping error on member ABC_C00001. Data mapping error on member ABC_C00001. Data mapping error on member ABC_C00001. Data mapping error on member ABC_C00001. Data mapping error on member ABC_C00001. Data mapping error on member ABC_C00001. Data mapping error on member ABC_C00001. Data mapping error on member ABC_C00001. Data mapping error on member ABC_C00001. Data mapping error on member ABC_C00001. Data mapping error on member ABC_C00001. Data mapping error on member ABC_C00001. DB2/400 V4R3M0 (with all of the PTFs on the cumulative tape for C8349430, as well as SF52733) Client Access V3R2M0 (with client patches Sf51617 and Sf53300 applied)are being used.

[{"Product":{"code":"SSTQPQ","label":"IBM Cognos Series 7 PowerPlay"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Component":"Impromptu","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"Impromptu 5.0;Impromptu 7.3","Edition":"","Line of Business":{"code":"LOB76","label":"Data Platform"}}]

Log InLog in to view more of this document

This document has the abstract of a technical article that is available to authorized users once you have logged on. Please use Log in button above to access the full document. After log in, if you do not have the right authorization for this document, there will be instructions on what to do next.

Historical Number

71507

Document Information

Modified date:
09 May 2025

UID

swg21348666