SQL/MP Messages Manual

File-System Messages
HP NonStop SQL/MP Messages Manual—427720-006
16-11
SQL 1042
Cause. The INSERT statement did not supply values for all columns. One of the
omitted values was for a column that had no default value defined.
Effect. The insert operation fails.
Recovery. Correct the INSERT statement by adding a value for the column that has
no defined default value. Then preprocess (SQL COBOL programs only), host-
language compile, SQL compile, and run the program again.
SQL 1043
Cause. SQL internal error.
Effect. The operation fails.
Recovery. None. Report the entire message to your service provider.
SQL 1044
Cause. Unable to use the UNLOCK TABLE statement on a nonaudited table while
cursors holding locks on the table were open.
Effect. The UNLOCK TABLE statement fails.
Recovery. Correct the program to close cursors on the table with either a FREE
RESOURCES statement or a CLOSE statement before issuing an UNLOCK TABLE
statement. Then preprocess (SQL COBOL programs only), host-language compile,
SQL compile, and run the program again.
SQL 1045
Cause. SQL internal error.
Effect. The SQL operation fails.
Recovery. None. Report the entire message to your service provider.
1042 The operation required a default value for a column that
was defined as NO DEFAULT.
1043 SQL internal error.
1044 The operation is not allowed while an SQL cursor is
open.
1045 SQL internal error.