DSNT417I SQLWARNn-n SQL WARNINGS
Explanation
At least one of the 11 warning
values is not the expected value (a blank). A nonblank value in one
of the 11 warning fields has the following meaning:
- SQLWARN0
- Any other warning code is set.
- SQLWARN1
- String truncation.
- SQLWARN2
- Null value(s) eliminated.
- SQLWARN3
- Number of host variables provided did not equal degree of the table.
- SQLWARN4
- No WHERE clause on UPDATE or DELETE.
- SQLWARN5
- Not a Db2 SQL statement.
- SQLWARN6
- Date or timestamp value adjusted.
- SQLWARN7
- Conversion of decimal number from precision 31 to precision 15 caused truncation of fractional digits.
- SQLWARN8
- Character that does not exist on the target code page was replaced with a substitution character.
- SQLWARN9
- Arithmetic exceptions have been ignored during processing of COUNT DISTINCT.
- SQLWARNA
- At least one character field of the SQLCA is invalid due to a string conversion error.
User response
The SQL warning information may be of help in diagnosing an error or in indicating the results of successful execution. If this warning should occur, correct the error and rerun the program or SQL statement.