SQL0901. returned in SQL trace when accessing DB2/400

Resolving The Problem

This is an ODBC errors that can be caused by a corrupt driver, an incorrectly installed driver, or a driver that needs to be updated.

Also check the following:

1. For some specific versions of this driver - Journalling needs to be turned on - Please contact the vendor for more detailed information.
2. Confirm the Library names in the ODBC driver are correct.
3. Confirm the AS/400 is not low on space.
4. Reinstall the driver.
5. Run an ODBC trace to trap any preceding errors and assist in identifying the call that is causing the error.
6. Perform a SQLTrace and look up the error code returned in the call to SQLErrorW in the trace. For example:

SQL0901

This error corresponds to:

SQLSTATE 58004

Cause: An SQL system error has occurred. The current SQL statement cannot be completed successfully. The error will not prevent other SQL statements from being processed. Previous messages may indicate that there is a problem with the SQL statement and SQL did not correctly diagnose the error. If precompiling, processing will not continue beyond this statement.

Recovery: See the previous messages to determine if there is a problem with the SQL statement. To view the messages, use the DSPJOBLOG command if running interactively, or the WRKJOB command to view the output of a precompile. An application program receiving this return code may attempt further SQL statements. Correct any errors and try the request again. The SQLCODE is -901 and the associated message is SQL0901.

7. Check the datasource vendor for information, for IBM: http://www.as400.ibm.com/tstudio/DB2_400/CLI/sqlmsg/allhtml.htm