PI55693: DB2 ADMIN TOOL ADB2PA: THE FOLLOWING STATEMENT COULD NOT BE PARSED: CREATE FUNCTION ... TOKEN = (

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• Using DB2 Administration Tool version 11.1 to retrieve DDL of
  DB2 function, after putting 'ddl' line command in DB2 Function
  the following message is received:
     Unexpected SELECT command
     ADB2PA: The following statement could not be parsed :
     CREATE FUNCTION <funcname> (TS VARCHAR(32)) RETURNS
        TIMESTAMP WITH TIME ZONE
      LANGUAGE SQL
      CONTAINS SQL
        NO EXTERNAL
      ACTION DETERMINISTIC
      RETURN (TIMESTAMP_TZ
      (
        TIMESTAMP(TIMESTAMP_TZ(TS) - EXTRACT(TIMEZONE_HOUR FROM
        TIMESTAMP_TZ(TS)) HOUR),'+0:00')
      )
  
     Token number =     27, Token = (
  

Local fix

• n/a
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the DB2 Administration Tool         *
  *                 for z/OS.                                    *
  ****************************************************************
  * PROBLEM DESCRIPTION: When using the DDL line command on a    *
  *                      function which is created with the      *
  *                      TIMEZONE_HOUR keyword, DB2 Admin        *
  *                      issues the following error:             *
  *                                                              *
  *                      Unexpected SELECT command               *
  *                                                              *
  *                      ADB2PA: The following statement could   *
  *                      not be parsed :                         *
  *                                                              *
  *                      CREATE FUNCTION >function_name<         *
  *                      (TS VARCHAR(32)) RETURNS                *
  *                          TIMESTAMP WITH TIME ZONE            *
  *                        LANGUAGE SQL                          *
  *                        CONTAINS SQL                          *
  *                         NO EXTERNAL                          *
  *                        ACTION DETERMINISTIC                  *
  *                        RETURN (TIMESTAMP_TZ                  *
  *                        (                                     *
  *                          TIMESTAMP(TIMESTAMP_TZ(TS) -        *
  *                      EXTRACT(TIMEZONE_HOUR FROM              *
  *                          TIMESTAMP_TZ(TS)) HOUR),'+0:00')    *
  *                        )                                     *
  *                                                              *
  *                      Token number =     27, Token = ..       *
  *                      ***                                     *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  A parser error is observed when using the DDL line command on
  a function which is created with the TIMEZONE_HOUR keyword.
  

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:

  UI37476 UI37477

Modules/Macros

•    ADB2PA
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RB10 PSY UI37476

     UP16/05/05 P F605

• RB20 PSY UI37477

     UP16/05/05 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.