JR59539: SUPPORT FOR OPTIONAL FROM CLAUSE IN TERADATA VIEWS WITH SIMPLE SELECT REQUEST.

APAR status

• Closed as program error.

Error description

• A FROM clause is mandatory for SELECT requests in the ANSI
  SQL:2008 standard. The optional FROM clause in Teradata SQL is
  a Teradata extension.
  
  Suppoert is required for rhe basic from of this construct.
  

Local fix

• Recode view to include FROM clause.
  

Problem summary

• *********************************************
  APAR Users Affected:
  *********************************************
  Users using Teradata queries with no FROM clause. Parsing of
  those queries failed and therefore lineage was not displayed.
  
  *********************************************
  APAR Problem Description:
  *********************************************
  Parsing of Teradata queries with no FROM clause failed. We
  improve SQL parser so this case is covered and as a result
  lineage for such a views is properly generated.
  
  *********************************************
  APAR Recommendation:
  *********************************************
  Apply the fix for JR59539
  
  *********************************************
  

Problem conclusion

•  Apply the fix for JR59539
  

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

  IS GOVCATLOG

• Fixed component ID

  5724Q36GC

Applicable component levels