PK95351: IMPORT OF AN IXF FORMATED DB2 TABLE GETS THE MESSAGE: WIDTH OF IMPORTED DATA COLUMN 12 IS NOT IN THE ALLOWED RANGE.

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• The user is doing an EXPORT of an IXF formated DB2 table. The
  EXPORT runs OK but the IMPORT gets the message:
  Width of imported data column 12 is not in the allowed range.
  This occurs for QMF 810 and QMF 910, only on a DB2 V9 system.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: All QMF for TSO/CICS V810 and V910           *
  *                 users who export and import tables           *
  *                 and data.                                    *
  ****************************************************************
  * PROBLEM DESCRIPTION: IMPORT of tables or data that contain   *
  *                      VARCHAR or LONG VARCHAR can fail        *
  *                      with message DSQ50477.  The error       *
  *                      occurs for any LONG VARCHAR columns     *
  *                      or a VARCHAR column that was defined    *
  *                      with a length greater than 255 if the   *
  *                      table or data was exported while        *
  *                      connected to a DB2 V9 system.           *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  In DB2 V8 and lower, LONG VARCHAR and VARCHAR(256) and
  longer were given the SQLTYPE of 456, which is documented as
  the SQLTYPE for LONG VARCHAR.  In DB2 V9, all VARCHAR
  and LONG VARCHAR data is given the SQLTYPE of 448, the
  SQLTYPE for VARCHAR, regardless of the length of the data.
  
  DB2 added this text to the V9 SQL Reference Manual:
  456/457 long varying-length character string
          SQLTYPE values 448/449 are returned instead of 456/457
          for statements that are bound in Version 9 or later.
  
  QMF IMPORT code expected all values with data type (SQLTYPE)
  448 to be VARCHAR with a maximum length of 255.  When DB2 V9
  returned SQLTYPE 448 for VARCHAR >255 and for LONG VARCHAR, the
  length restriction caused IMPORT to fail.
  

Problem conclusion

• The check for a maximum allowed length for SQLTYPE 448 has been
  removed.
  

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:

  UK50162 UK50163

Modules/Macros

• DSQCFIDC
  

Fix information

• Fixed component name

  QMF-QUERY MGMT

• Fixed component ID

  566872101

Applicable component levels

• R810 PSY UK50162

     UP09/09/18 P F909

• R910 PSY UK50163

     UP09/09/18 P F909

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.