DSNU1197I SQLWARNn-n SQL WARNINGS
Explanation
At least one of the eleven (11) warning values
is not the expected value (a blank). A nonblank value in one of the
11 warning fields has one of the following meanings:
- SQLWARN0
- Any other warning code is set.
- SQLWARN1
- String truncation.
- SQLWARN2
- Null values 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
- Untranslatable character replaced with substitute.
- 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 translation error.
System action
Utility processing continues.
User response
The SQL warning information might 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.
Severity
0 (informational)