Technote (troubleshooting)
Problem(Abstract)
CSQ45STB use the DSNTEP2 program to execute select SQL statement dynamically. In specific case, the CSQ45STB rc is 04.
--------------
DSNT400I SQLCODE = 000, SUCCESSFUL EXECUTION
DSNT418I SQLSTATE = 01004 SQLSTATE RETURN CODE
DSNT416I SQLERRD = 0 0 0 -1 0 0 SQL DIAGNOSTIC INFORMATION DSNT416I SQLERRD = X'00000000' X'00000000' X'00000000' X'FFFFFFFF'X'000 INFORMATION
DSNT417I SQLWARN0-5 = W,W,,,, SQL WARNINGS
---------------- SQLWARN1 SQLSTATE 01004 means the value of a string column was truncated when assigned to a host variable. The program that has the host variable is DSNTEP2.
Cause
It occurs as DSNTEP2 has a maximum of 120 characters when displaying a character column, after which truncation of the character data occurs.
Resolving the problem
In order to see all of the data in these columns, you can use SPUFI (setting MAX CHAR FIELD appropriated, e.g. to 14336).
Historical Number
91556
180
000
Product Alias/Synonym
WMQ MQ
Rate this page:
Copyright and trademark information
IBM, the IBM logo and ibm.com are trademarks of International Business Machines Corp., registered in many jurisdictions worldwide. Other product and service names might be trademarks of IBM or other companies. A current list of IBM trademarks is available on the Web at "Copyright and trademark information" at www.ibm.com/legal/copytrade.shtml.