PH28277: SET CURRENT PATH STATEMENT TRUNCATED IN OC CHG FILE

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• SET CURRENT PATH statement truncated in OC CHG file
  Compare cuts off the PATH statement in the CHG file for stored
  procedures when the schema name is long (should pass onto the
  next line).
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the Db2 Object Comparison Tool for  *
  *                 z/OS who create stored procedures or user    *
  *                 defined functions with long schema names.    *
  ****************************************************************
  * PROBLEM DESCRIPTION: Object Compare might truncate the       *
  *                      schema of the path name for a stored    *
  *                      procedure or user defined function.     *
  ****************************************************************
  In the change file that is generated by Object Compare,
  the SET CURRENT PATH statement might be truncated for long
  schema names.
  
  For example:
  
  SET CURRENT PATH =
  "SYSIBM","SYSFUN","SYSPROC","SYSIBMADM","LONGERSCHE
  instead of
  SET CURRENT PATH =
  "SYSIBM","SYSFUN","SYSPROC","SYSIBMADM","LONGSCHEMA
  1234567" `
  
  When applying
  the change with this truncated statement the following error
  occurs:
  
  ADB7955E ADBTEP2 SQL error:
  ADB7955E ADBTEP2 DSNT408I SQLCODE = -010, ERROR: THE STRING
  ADB7955E ADBTEP2 CONSTANT BEGINNING <truncated schema> IS
  ADB7955E ADBTEP2 NOT TERMINATED
  

Problem conclusion

• The problem has been resolved.
  
  Search keywords: SQLCODE010N
  

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:

  UI71172

Modules/Macros

• ADB2CM2
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RC10 PSY UI71172

     UP20/09/01 P F008

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.