PI58390: THE INZI012E IN UNLOAD PLUS SYNTAX WITH TWO SELECT STATEMENT THAT BOTH REQUIRE THE FORMAT CSV TERMINATEDBY ','

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• The INZI012E message is unduly issued when an UNLOAD using the
  UNLOAD PLUS syntax specifies two SELECT statement that both
  require the FORMAT CSV TERMINATEDBY ',' option as in the example
  below:
  UNLOAD
  UNLOADDN SYSRC
  CNTLCARDS DB2LOAD
  LIMIT 0
  SHRLEVEL REFERENCE
  ORDER NO
  ENUMROWS 0
  SORTNUM 2
  MAXSORTS 4
  FIXEDVARCHAR NO
  INTERVAL 0
  FORMAT CSV TERMINATEDBY ',' ENCLOSEDBY X'7D'
  SELECT TRIM(CHAR(A.NAME)) AS COL1, RTRIM(CHAR(A.CREATOR)) AS
  COL2
  FROM SYSIBM.SYSSTOGROUP A
  WITH UR;
  
  PB44640 msgINZI012E
  

Local fix

• None but the fact the undue message is issued does not prevent
  the unload to complete successfully.
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of DB2 High Performance Unload z/OS.   *
  ****************************************************************
  * PROBLEM DESCRIPTION: The INZI012E message is unduly issued   *
  *                      when an UNLOAD using the UNLOAD PLUS    *
  *                      syntax specifies two SELECT statement   *
  *                      that both require the FORMAT CSV        *
  *                      TERMINATEDBY ',' option as in the       *
  *                      example below:                          *
  *                                                              *
  *                      UNLOAD                                  *
  *                      UNLOADDN SYSRC                          *
  *                      CNTLCARDS DB2LOAD                       *
  *                      LIMIT 0                                 *
  *                      SHRLEVEL REFERENCE                      *
  *                      ORDER NO                                *
  *                      ENUMROWS 0                              *
  *                      SORTNUM 2                               *
  *                      MAXSORTS 4                              *
  *                      FIXEDVARCHAR NO                         *
  *                      INTERVAL 0                              *
  *                      FORMAT CSV TERMINATEDBY ',' ENCLOSEDBY  *
  *                       X'7D'                                  *
  *                      SELECT TRIM(CHAR(A.NAME)) AS COL1,      *
  *                       RTRIM(CHAR(A.CREATOR)) AS COL2         *
  *                      FROM SYSIBM.SYSSTOGROUP A               *
  *                      WITH UR;                                *
  *                      FORMAT CSV TERMINATEDBY ',' ENCLOSEDBY  *
  *                       X'7D'                                  *
  *                      SELECT CHAR('TRAILER') AS COL1          *
  *                      FROM SYSIBM.SYSDUMMY1                   *
  *                      WITH UR;                                *
  ****************************************************************
  * RECOMMENDATION: APPLY the PTF.                               *
  ****************************************************************
  The inztopt, inztopt, inztyacc, inzmsgs and inzctrlp
  modules were changed.
  

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

•    INZUTILK
  

Fix information

• Fixed component name

  DB2 HI PERF UNL

• Fixed component ID

  5697F4400

Applicable component levels

• R420 PSY UI37984

     UP16/05/24 P F605

• R430 PSY UI37985

     UP16/05/24 P F605

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.