PI89273: ENCLOSEDBY SUB-OPTION OF CSV FORMAT ONLY TAKEN INTO ACCOUNT FOR THE FIRST SELECT OF A SAME UNLOAD STATEMEN 17/12/08 PTF PECHANGE

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• This APAR addresses both the following.
  
  The output fields of an UNLOAD PLUS compatible unload
  command are not enclosed as requested by the specified
  ENCLOSEDBY sub-option of the CSV format option.
  
  This affects the case where the UNLOAD statement has more
  than one SELECT statement. The output records for the first
  SELECT statement are correctly enclosed.
  
  PB50399
  
  And SQLCODE -805 running the HPU CLIST.
  PTF UI51195 was packaged incorrectly, missing code for DBRM
  INZQUERY.
  The HPU online CLIST will fail with messages like the following.
  
  DSNT408I SQLCODE = -805, ERROR:  DBRM OR PACKAGE NAME
  DB0BLOC1..INZQUERY.1A3CD-
           26009D209D4 NOT FOUND IN PLAN HINZ430. REASON 03
  DSNT418I SQLSTATE   = 51002 SQLSTATE RETURN CODE
  DSNT415I SQLERRP    = DSNXEPM SQL PROCEDURE DETECTING ERROR
  DSNT416I SQLERRD    = -251  0  0  -1  0  0 SQL DIAGNOSTIC
  INFORMATION
  DSNT416I SQLERRD    = X'FFFFFF05'  X'00000000'  X'00000000'
  X'FFFFFFFF'
           X'00000000'  X'00000000' SQL DIAGNOSTIC INFORMATION
  INZI146E ERROR WHEN SUBMITING A SQL QUERY TO DB2 ON PLAN HINZ430
  
  PB50804
  

Local fix

• split the UNLOAD statement into several UNLOAD statements with
  only one SELECT statement per UNLOAD statement.
  

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * Users of the High Performance Unload                         *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * The output fields of an UNLOAD PLUS compatible unload        *
  * command are not enclosed as requested by the specified       *
  * ENCLOSEDBY sub-option of the CSV format option.              *
  *                                                              *
  * This affects the case where the UNLOAD statement has more    *
  * than one SELECT statement. The output records for the first  *
  * SELECT statement are correctly enclosed.                     *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  Code has been changed to fix this problem
  

Problem conclusion

• Apply the PTF for problem resolution
  

Temporary fix

• split the UNLOAD statement into several UNLOAD statements with
  only one SELECT statement per UNLOAD statement.
  

Comments

APAR Information

• APAR is sysrouted FROM one or more of the following:

  PI87440

• APAR is sysrouted TO one or more of the following:

  UI51690

Modules/Macros

• INZUTILK
  

Fix information

• Fixed component name

  DB2 HI PERF UNL

• Fixed component ID

  5697F4400

Applicable component levels

• R510 PSY UI51690

     UP17/11/14 P F711 {

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.