1.4 Interpreting SQLCODEs

If an SQLCODE is output, you need to see the corresponding message and take actions as shown in the following table.

Table 1‒2: Messages corresponding to SQLCODEs
No.	Format of the output SQLCODE	Corresponding message (message to be checked)
1	`nnn`	`KFAA32nnn` Example: If `100` is indicated for the SQLCODE The corresponding message is the `KFAA32100-I` message. See the `KFAA32100-I` message.
2	`-nnn`	`KFAA30nnn` Example: If `-204` is indicated for the SQLCODE The corresponding message is the `KFAA30204-E` message. See the `KFAA30204-E` message.
3	`-1nnn`	`KFAA31nnn` Example: If `-1301` is indicated for the SQLCODE The corresponding message is the `KFAA31301-E` message. See the `KFAA31301-E` message.
4	`-4nnn`	`KFAA34nnn` Example: If `-4003` is indicated for the SQLCODE The corresponding message is the `KFAA34003-E` message. See the `KFAA34003-E` message.
5	`-1071nnn`	`KFAA71nnn` Example: If `-1071680` is indicated for the SQLCODE The corresponding message is the `KFAA71680-E` message. See the `KFAA71680-E` message.
6	`0`	`KFAA32000-I` Example: If `0` is indicated for the SQLCODE The corresponding message is the `KFAA32000-I` message. See the `KFAA32000-I` message.