Data Transformation Engine Resource Adapter Reference Guide

Appendix A - Return Codes and Error Messages Database-specific Adapter Messages
Resource Adapters Reference Guide
90
Database-specific Adapter Messages
After database adapter activity completes, messages display indicating the results.
These messages may also be recorded in the appropriate files as specified, which
may include audit logs, trace files, and execution summary. These codes and
messages can be returned for the following database adapters:
♦ DB2 (MVS (CLI))
♦ DB2 (MVS)
♦ DB2 (Windows/UNIX)
♦ Informix
♦ Microsoft SQL Server
♦ ODBC
♦ OLE DB
♦ Oracle
♦ SQL/MP
♦ SQL/MX
♦ Sybase SQL Server
The following is a listing of all the codes and messages that can be returned as a
result of using the database adapters for sources or targets.
Note Adapter return codes with positive numbers are warning codes that indicate a
successful operation. Adapter return codes with negative numbers are error codes
that indicate a failed operation.
Return Code Message
0 Success
12 Database -b argument is required with arguments
mdqfile -m and query -q
1001 One or more records could not be processed
1002 No data found
-1001 Memory allocation error
-1002 Failed to allocate ODBC environment
-1003 Failed to allocate ODBC statement
-1004 Failed to allocate ODBC connection