PI55231: INSERT DOESN'T FAIL WHEN THE NUMBER OF VALUES ASSIGNED IS NOT SAME AS THE NUMBER OF SPECIFIED COLUMNS

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• When the user issues an INSERT query, in which the number of
  values assigned is not same as the number of specified columns,
  the program generates incorrect and inconsistent output:
  1- The error message is incorrect for the error.
  2- Not all INSERT statements with non-matched number of values
  and columns failed. Some of them did generate some output.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * All IMS V14 Native SQL users                                 *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * When the user issues an INSERT query, in which the number of *
  * values assigned is not same as the number of specified       *
  * columns, the program generates incorrect and inconsistent    *
  * output:                                                      *
  * 1- The error message is incorrect for the error.             *
  * 2- Not all INSERT statements with non-matched number of      *
  * values and columns failed. Some of them did generate some    *
  * output.                                                      *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * INSTALL CORRECTIVE SERVICE FOR APAR/PTF                      *
  ****************************************************************
  When the user issues an INSERT query, in which the number of
  values assigned is not same as the number of specified columns,
  the program generates incorrect and inconsistent output:
  1- The error message is incorrect for the error.
  2- Not all INSERT statements with non-matched number of values
  and columns failed. Some of them did generate some output.
  

Problem conclusion

• A new function, VerifyColValCounts(), is added to module
  DFSSQL10 to fix this issue. This function examines the number of
  values and the number of columns specified in the INSERT
  statement and returns error if they are not the same. Function
  VerifyColValCounts() is called before the INSERT statement is
  processed; therefore, when the number of values does not equal
  the number of columns, the statement will fail and not add rows
  to the database.
  

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:

  UI34658

Modules/Macros

• DFSSQL10
  

Fix information

• Fixed component name

  IMS V14

• Fixed component ID

  5635A0500

Applicable component levels

• R400 PSY UI34658

     UP16/01/23 P F601

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.