Execution of customized WMQ Job CSQ45STB shows the SQL 01004 SQLSTATE RETURN CODE

Technote (troubleshooting)


Problem(Abstract)

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.

Cause

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).

Historical Number

91556 180 000

Product Alias/Synonym

WMQ MQ

Rate this page:

(0 users)Average rating

Add comments

Document information


More support for:

WebSphere MQ
Configuration

Software version:

6.0, 7.0, 7.0.1, 7.1

Operating system(s):

z/OS

Reference #:

1591488

Modified date:

2013-06-12

Translate my page

Machine Translation

Content navigation