This category contains the following instructions:
When an entity is used by one of these instructions, all its logical properties are automatically included in the data environment, and can then be used in the program in the same way as any global work variable.
After any of these instructions have been run (with the exception of the LOADING, CURSOR and TEMP_TABLE declaration instructions), it is possible to test the SQL return code with the *SQLCODE reserved word.
Possible return code values:
0 |
Operation completed successfully. |
100 |
The end of a cursor was reached (READ_NX_SQL_C) or no line was selected (CHAIN_SQL, UPD_SQL, DELETE_SQL). |
Any other value |
Operation failed. |
For exact details of the causes of errors whose return codes are either negative or higher than 31, consult your database manager documentation.
Return codes from 1 to 31 indicate errors generated by the Adelia API.