PI48357: DB2 ADMIN TOOL CCSID 500 VIEW WITH CONCAT OPERATOR ]] (RIGHT BRAKET) COULD NOT BE PARSED

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• With CCSID 500, a view with concat operator ]] (right
  bracket, '5A5A'X) could not be parsed, returned:
  
  ADB2PA5.TOKENIZE
  O i=0000931 st=00 Char=¨ BB Sym#=10 N st=00 Act=77
    Typ=07 Ts=0000930 P=0000931 C=0000000
  i=000000931L(sql_stmt)=000001104L(sql_stmt_caps)=000001103
  Syntax error during statement scan.
         Text=! '-01-01' ) ) AND (C.DEBCTR
  
  ADB2PA5: The following statement could not be parsed :
  
     CREATE VIEW WV.ADCVIEW ...
     AS SELECT ...
     FROM      ...
     WHERE     ...
     AND (C.DEDATE >= DATE(CHAR(CHAR(YEAR(CURRENT_DATE -1 MONTH)
          -  1), 4)  ]] '-01-01' ) ) AND  (C.DEBCTR  <= ...
  
  Processing Table/View/Alias WV.WV.ADCVIEW
  ADB1848W Unformatted DDL will be generated for the following
           view because it could not be parsed.
  Please verify the DDL.
  
              Reason code = 28
              WV.WV.ADCVIEW
  

Local fix

• n/a
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the DB2 Administration Tool         *
  *                 for z/OS who use the Generate (GEN)          *
  *                 function to generate a VIEW which            *
  *                 contains the concatenation operator          *
  *                 (right bracket, '5A5A'X,) when using         *
  *                 CCSID=500.                                   *
  ****************************************************************
  * PROBLEM DESCRIPTION: When using GEN to generate a VIEW       *
  *                      which contains the concatenation        *
  *                      operator    (right bracket, '5A5A'X,)   *
  *                      when using CCSID=500, the job           *
  *                      failed with warning message             *
  *                      ADB1848W / msgadb1848w:                 *
  *                                                              *
  *                      ADB2PA5: The following statement        *
  *                      could not be parsed :                   *
  *                                                              *
  *                       CREATE VIEW >schema<.>view_name< ...   *
  *                       AS SELECT ...                          *
  *                                                              *
  *                      Processing Table/View/Alias             *
  *                      >schema<.>view_name<                    *
  *                      ADB1848W Unformatted DDL will           *
  *                      be generated for the following view     *
  *                      because it could not be parsed.         *
  *                      Please verify the DDL.                  *
  *                                                              *
  *                           Reason code = 28                   *
  *                      . .                                     *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  When performing GEN on the VIEW which contains the
  concatenation operator    (right bracket, '5A5A'X,)
  the job failed when CCSID=500.
  

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:

  UI35234 UI35235 UI35236

Modules/Macros

•    ADB2PA5
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RA20 PSY UI35234

     UP16/02/11 P F602

• RB10 PSY UI35235

     UP16/02/11 P F602

• RB20 PSY UI35236

     UP16/02/11 P F602

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.