PM34549: HPU GENERATES INVALID LOAD STATEMENT WHEN VARCHAR DATA IS TO BE UNLOADED AS FIXED LENGTH FIELD

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• An invalid LOAD statement is generated where a varchar data is
  to be unloaded as a fixed-length field by specifying the
  LENGTHBYTE NO option along with the USER format.
  
  The typical error is the lack of the data type name in the field
  specification such as in the following example where DBNAME is a
  VARCHAR(24) column converted into a fixed-length field by
  requesting FORMAT USER(COL DBNAME LENGTH MAX PADDING ' ').
  
  In such a case, the LOAD statement contains:
  DBNAME
       POSITION (     2  )          (    24 )
  
  instead of the expected following field specification:
  DBNAME
       POSITION (     2  )     CHAR (    24 )
  
  PB11097
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of DB2 High Performance Unload.        *
  ****************************************************************
  * PROBLEM DESCRIPTION: An invalid LOAD statement is generated  *
  *                      where a varchar data is to be unloaded  *
  *                      as a fixed-length field by specifying   *
  *                      the LENGTHBYTE NO option along with     *
  *                      the USER format. The typical error is   *
  *                      the lack of the data type name in the   *
  *                      field specification such as in the      *
  *                      following example where DBNAME is a     *
  *                      VARCHAR(24) column converted into a     *
  *                      fixed-length field by requesting        *
  *                      FORMAT USER(COL DBNAME LENGTH MAX       *
  *                      PADDING ' '). In such a case, the       *
  *                      LOAD statement contains:                *
  *                      DBNAME                                  *
  *                          POSITION (     2  )                 *
  *                      (    24 )                               *
  *                      instead of the expected following       *
  *                      field specification:                    *
  *                      DBNAME                                  *
  *                          POSITION (     2  )     CHAR        *
  *                      (    24 )                               *
  *                      Local fix : Add the TYPE CHAR           *
  *                      specification to get the correct LOAD   *
  *                      statement. In the above example,        *
  *                      replace FORMAT USER(COL DBNAME LENGTH   *
  *                      MAX PADDING ' ') by FORMAT USER(COL     *
  *                      DBNAME TYPE CHAR LENGTH MAX PADDING     *
  *                      ' ').                                   *
  *                      PB 11097                                *
  ****************************************************************
  * RECOMMENDATION: APPLY the PTF.                               *
  ****************************************************************
  The inzrload  module was changed to correctly handle the case
  where an implicit casting from varchar to char data is
  requested.
  

Problem conclusion

• APPLY the PTF.
  

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:

Modules/Macros

•    INZADBSK INZUTILK
  

Fix information

• Fixed component name

  DB2 HI PERF UNL

• Fixed component ID

  5697F4400

Applicable component levels

• R320 PSY UK73227

     UP11/11/02 P F111

• R410 PSY UK73228

     UP11/11/02 P F111

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.