PK16420: SQLCODE -254,-253,+252 IN DSNXRINSEXPECT A STATEMENT IN THE MES SAGE TEXT

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• -254   A  NON-ATOMIC statement STATEMENT  ATTEMPTED TO PROCESS
  MULTIPLE ROWS OF DATA, BUT ERRORS OCCURRED
    -253   A  NON-ATOMIC statement STATEMENT  SUCCESSFULLY
  COMPLETED  FOR SOME OF THE REQUESTED ROWS, POSSIBLY WITH WARNI
  NGS, AND ONE OR MORE ERRORS
    +252   A NON-ATOMIC statement STATEMENT SUCCESSFULLY
  PROCESSED ALL
  
    -254   A  NON-ATOMIC statement STATEMENT  ATTEMPTED TO
  PROCESS
  MULTIPLE ROWS OF DATA, BUT ERRORS OCCURRED
    -253   A  NON-ATOMIC statement STATEMENT  SUCCESSFULLY
  COMPLETED  FOR SOME OF THE REQUESTED ROWS, POSSIBLY WITH WARNI
  NGS, AND ONE OR MORE ERRORS
    +252   A NON-ATOMIC statement STATEMENT SUCCESSFULLY
  PROCESSED ALL
    The above SQLCODEs expect a statement in the message text. We
   need to create a DIAG PARM saying INSERT for these in DSNXRINS
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: All DB2 v8 users.                            *
  *                                                              *
  *                                                              *
  ****************************************************************
  * PROBLEM DESCRIPTION: An incorrect message is displayed for   *
  *                      -254, -253, +252 SQLCODES.              *
  *                                                              *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  An incorrect message is displayed for -254, -253, +252 SQLCODES.
  This message occurs in multi-row insert statements where an
  error or warning is encountered.  When the following SQL is
  is executed an error or warning may occur.
  
  CREATE TABLE T1 (COL1 CHAR(5));
  
  DCL A1(3) CHAR(15);
  A1(1) = 'ABCDEF';
  A1(2) = 'HELLO WORLD';
  
  STMT = 'INSERT INTO T1 VALUES(?) FOR 2 ROWS';
  ATT = 'FOR MULTIPLE ROWS NOT ATOMIC CONTINUE ON SQLEXCEPTION';
  EXEC SQL PREPARE INS ATTRIBUTES :ATT FROM :STMT;
  EXEC SQL EXECUTE INS USING :A1;
  
  In this example, the column definition is of size 5 while
  the input char size is greater than 5, causing an error.
  The result from these statements will be a -254 SQLCODE with
  the following message:
      A NON-ATOMIC   STATEMENT ATTEMPTED TO PROCESS MULTIPLE
      ROWS OF DATA, BUT ERRORS OCCURRED
  
  The correct message should be
      A NON-ATOMIC <statement> STATEMENT ATTEMPTED TO PROCESS
      MULTIPLE ROWS OF DATA, BUT ERRORS OCCURRED
  where <statement> is substituted with INSERT for this case.
  
  -253 and +252 correct messages are as follows and follow the
  same format as above
      A NON-ATOMIC <statement> STATEMENT SUCCESSFULLY COMPLETE FOR
      SOME OF THE REQUESTED ROWS, POSSIBLE WITH WARNINGS, AND ONE
      OR MORE ERRORS
  
      A NON-ATOMIC <statement> STATEMENT SUCCESSFULLY PROCESSED
      ALL REQUESTED ROWS, WITH ONE OR MORE WARNING CONDITIONS
  where <statement> is substituted with INSERT for this case.
  

Problem conclusion

• The messages were corrected to show the appropriate statement.
  
  ADDITIONAL KEYWORDS: SQLMULTIROW SQLINSERT SQLCODE254
                       SQLCODE253 SQLCODE252
  

Temporary fix

Comments

APAR Information

• APAR is sysrouted FROM one or more of the following:

• APAR is sysrouted TO one or more of the following:

  UK12386

Modules/Macros

• DSNXRINS
  

Fix information

• Fixed component name

  5740 IBM DATABA

• Fixed component ID

  5740XYR00

Applicable component levels

• R810 PSY UK12386

     UP06/03/23 P F603

Fix is available

• Select the PTF appropriate for your component level. You will be required to sign in. Distribution on physical media is not available in all countries.