PI37750: DB2 ADMIN TOOL DDL LINE COMMAND DOES NOT FORMAT VIEW WITH NESTED CAST CLAUSE

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• Using DDL Line command on a view with nested CAST clause
  returns:
     CAST <expression> not followed by AS
  
     ADB2PA: The following statement could not be parsed :
  
     CREATE VIEW ... (complete View DDL);
  
     Token number =    326, Token = (
     ***
  
  then pressing enter shows the unformatted DDL in an ISPF edit
  session.
  

Local fix

• n/a
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the DB2 Administration Tool for     *
  *                 z/OS who use the DDL or GEN command to       *
  *                 generate SQL from the DB2 catalog for        *
  *                 a VIEW.                                      *
  ****************************************************************
  * PROBLEM DESCRIPTION: When the CREATE SQL statement for a     *
  *                      VIEW contains the TRIM function         *
  *                      and the user performs the DDL           *
  *                      or GEN command to generate SQL          *
  *                      from the DB2 catalog for a VIEW,        *
  *                      DB2 Admin fails.                        *
  *                                                              *
  *                      For example, if the CREATE VIEW         *
  *                      statement contains the following:       *
  *                                                              *
  *                      CAST (DIGITS(aaa1). ||                  *
  *                      RIGHT('0000000000' ||                   *
  *                      TRIM(BOTH FROM aaaaa),10)               *
  *                      AS CHAR(19))                            *
  *                                                              *
  *                      the error message below is              *
  *                      displayed:                              *
  *                                                              *
  *                      CAST >expression< not followed by       *
  *                      AS                                      *
  *                      ADB2PA: The following statement could   *
  *                      not be parsed                           *
  *                      :                                       *
  *                      CREATE VIEW >view_name< AS SELECT       *
  *                      *** printing the whole DDL ****         *
  *                      Token number =    326, Token = ..       *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  When the CREATE SQL statement for a VIEW contains the TRIM
  function and the user performs the DDL or GEN command to
  generate SQL from the DB2 catalog for a VIEW, DB2 Admin fails.
  
  For example, if the CREATE VIEW statement contains the
  following:
  
  CAST (DIGITS(aaa1). || RIGHT('0000000000' || TRIM(BOTH FROM
  aaaaa),10) AS CHAR(19))
  
  the error message below is displayed:
  
  CAST <expression> not followed by AS
  ADB2PA: The following statement could not be parsed
  :
  CREATE VIEW >view_name< AS SELECT
  *** printing the whole DDL ****
  Token number =    nnn, Token = ..
  
  and upon pressing the Enter key shows the unformatted DDL
  in an ISPF edit session.
  

Problem conclusion

• Problem has been resolved.
  

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:

  UI30639 UI30640

Modules/Macros

•    ADB2PA
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RA20 PSY UI30639

     UP15/08/29 P F508

• RB10 PSY UI30640

     UP15/08/29 P F508

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.