JR39236: FAILED TO PARSE CERTAIN NON-ANSI CONSTRUCTS AND COMMENTS IN VIEWS

APAR status

• Closed as program error.

Error description

• The following non-ANSI clauses fail SQL parsing. They need to be
  removed or suitably replaced before feeding the SQL to the ANSI
  SQL parser
  that is used by WB stitching:
     1. USING clause before INSERT
     2. SEL as abbreviation for SELECT
     3. A space char between a colon and its identifier
        case when :Agmnt_Ind = 0 Then COALESCE (:Src_Rfrnc_Map_Nm,
         : Src_Val) Else :Short_Desc End,
     4. TITLE clause
        REPLACE VIEW EDWPRDE_VW10.T99063_ACTVY_PARTY_RLTD AS
  LOCKING ROW FOR
        ACCESS
        select
            Actvy_Id (TITLE 'Activity Id'),
            Actvy_Party_Id (TITLE 'Activity Party Id')
        (...)
     5. Type cast sizes (we handle them already on cast to various
  var...
     types (varchar, vargraphics, ...), but here, there is a cast
  to time(0).
        CAST(T01010.Party_Rltnp_Start_Dttm AS  TIME(0))
     6. Type casts "AS DATE FORMAT ..."
        WHERE
            CAST('2010-11-23' AS DATE FORMAT 'YYYY-MM-DD') BETWEEN
        pblcn_start_dt AND pblcn_end_dt;
     7. Fails parsing views whose SQL contains comments introduced
  using
     '--' (two dashes).
  

Local fix

• Fix available in 8.1.2 Fix Pack 5
  

Problem summary

• Failing to parse NON ANSI SQL constructs and comments in the
  views when running the Automated services.
  

Problem conclusion

• Patch includes the following:
  JR38963 - 2 NPEs in stitching and OOM in lineage caused by
  reject links.
  JR38849 - support stitching of job with 2 stages.
  JR39236 - parsing Non-Ansi constructs and views.
  And also fix for Stitching to arbitrary stages when some fields
  are empty (DB2 Enterprise Stage and Aggregate Stage) and parsing
  issues found by Avery.
  

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:

Fix information

• Fixed component name

  METADATA WORKBE

• Fixed component ID

  5724S4100

Applicable component levels

• R812 PSY

     UP