PK41474: FF720 GOC GOC2DTC DOES NOT SUPPORT LOWER CASE DDL FAILS RC16 WITH FUNCTION DOES NOT SUPPORT COMMENT STATEMENT FFPK37547

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• The DB2 Object Comparision Tool module GOC2DTC issues a message
  "Function does not support COMMENT statement - execution is
  terminated." and ends RC=16 when the DDL is in lower case.
  Additional symptoms:
  "COMMENT on .......;" Invalid token after COMMENT statement
  expected keyword ON
  "GRANT select .....;" Unknown GRANT priviledge: select.
  "grand select .....;" Function does not support GRANT statement
  f/f for r710 PK37547 ffPK37547 ff720
  

Local fix

• NA
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of DB2 Admin Tool.                     *
  ****************************************************************
  * PROBLEM DESCRIPTION: Customer  reported that their GOC job   *
  *                      ends  RC=16 and the  message "GOC2DTC   *
  *                      - Function  does  not support COMMENT   *
  *                      statement -  execution is terminated"   *
  *                      is issued when the DDL contains lower   *
  *                      case statements.                        *
  ****************************************************************
  * RECOMMENDATION: Apply the PTF.                               *
  ****************************************************************
  Some statements are reported as unsupported if keywords are
  lowercase.  Additional  fixed problem: the Gen line command
  against view fails with "Unresolved symbol. " error message
  when the view is saved in sysibm.sysviews in mixed or lower
  case.
  

Problem conclusion

• Fixed in Admin V7.2 and OC V7.2.
  

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

•    ADBCDTS  ADB2PA   ADB2PA3
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• R720 PSY UK26807

     UP07/08/10 P F708

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.