WebSphere MQ (WMQ) job CSQ45STB uses the DSNTEP2 program to execute select SQL statements dynamically. In this specific case, the CSQ45STB return code 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.
This problem 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 appropriately, for example to 14336).
91556 180 000