Error messages

 

When an error occurs, the ODBC Driver in iSeries™ Access for Linux^® returns the SQLSTATE (an ODBC error code) and an error message. The driver obtains this information both from errors that are detected by the driver and from errors that are returned by the iSeries server.

For errors that occur in the data source, the ODBC Driver in iSeries Access for Linux maps the returned native error to the appropriate SQLSTATE. When both the driver and the driver manager detect an error, they generate the appropriate SQLSTATE. The ODBC Driver in iSeries Access for Linux returns an error message based on the message returned by the iSeries server.

For errors that are detected within the ODBC Driver, the driver returns an error message based on the text associated with the SQLSTATE. These error messages are translated messages. Error message files and the help text for error messages found in the underlying components of the iSeries Access product are shipped in the /opt/ibm/iSeriesAccess/doc directory.

 

Error message format

Error messages have the following format:

[vendor][ODBC-component][data-source]

error-message

The prefixes in brackets ([ ]) identify the source of the error. When the error occurs in the data source, the [vendor] and [ODBC-component] prefixes identify the vendor and name of the ODBC component that received the error from the data source. The following table shows the values of these prefixes returned by iSeries ODBC Driver for Linux:

Error Source	Value
Driver Manager	[unixODBC] [Driver Manager]
ODBC Driver in iSeries Access for Linux	unixODBC] [IBM] [iSeries Access ODBC Driver]
NLS messages	[unixODBC] [IBM] [iSeries Access ODBC Driver] Column #: NLS error message number NLS error message text See the message prefix table below to find second level help text.
Communication and Security	unixODBC] [IBM] [iSeries Access ODBC Driver] Communications link failure. comm rc=xxxx - (message text) xxxx is the error number in decimal, not hexadecimal, format. Message text describing the nature of your error appears with the error number. See the message prefix table below to find second level help text.
DB2® UDB for iSeries	[unixODBC] [IBM] [iSeries Access ODBC Driver] [DB2 UDB] Server error message To view error message text for DB2 UDB for iSeries errors:
	For errors that begin with:	Use this OS/400® command
	SQL	DSPMSGD RANGE(SQLxxxx) MSGF(QSQLMSG)
	IWS or PWS	DSPMSGD RANGE(ZZZxxxx) MSGF(QIWS/QIWSMSG) ZZZ is either IWS or PWS

For other prefixes that may be seen through the ODBC Driver in iSeries Access for Linux, see the following table:

Message Prefix	Message File	Description
CWB####	cwber.html	Base error messages
CWBCO####	cwbcoer.html	Communication error messages
CWBNL####	cwbnler.html	Conversion error messages
CWBSY####	cwbsyer.html	Security error messages
CWBRC####	cwbrcer.html	Remote Command error messages
CWBLM####	cwblmer.html	License error messages

 

Parent topic:

Troubleshoot an iSeries Access for Linux ODBC