PK17275: QMF COLUMN NAMES NOT RENAMED TO COL1, COL2 WHEN THEY EXCEED MAX LENGTH ALLOWED FOR CURRENT DATABASE CONNECTION.

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• In SAVE DATA processing, when the addition of a 1 to a non-
  unique column name causes the name to exceed the maximum
  length allowed by the database connection, the column name
  should be renamed to COL1, as it was in previous QMF versions.
  In V8, when this condition is encountered, the error message
  DSQ20848 is issued indicating the column is too long.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: All QMF for TSO and CICS V8.1 users.         *
  ****************************************************************
  * PROBLEM DESCRIPTION: In SAVE DATA processing, when the       *
  *                      addition of a 1 to a non-unique column  *
  *                      name causes the name to exceed the      *
  *                      maximum length allowed by the database  *
  *                      connection, the column name should be   *
  *                      renamed to COL1.                        *
  *                      In QMF V8, when this condition is       *
  *                      encountered, rather than renaming the   *
  *                      column to COL1, the error message       *
  *                      DSQ20848 is issued indicating the       *
  *                      column is too long.                     *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  In V8, code was added to DSQDSAVX to check whether a column name
  exceeds the maximum allowed for the DB connection.  The check
  was added before an existing call to DSQCDCOL was made to rename
  columns to COL1, COL2 if the maximum is exceeded. Thus, the
  check to determine whether the column names need to be renamed
  did not occur before the SAVE DATA operation was terminated.
  

Problem conclusion

• The call to DSQCDCOL will be made before the length is checked
  for the too-long column name error condition.
  

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:

  UK10508

Modules/Macros

• DSQDSAVX
  

Fix information

• Fixed component name

  QMF-QUERY MGMT

• Fixed component ID

  566872101

Applicable component levels

• R810 PSY UK10508

     UP06/01/05 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.