Generating field reference detail on CREATE TABLE AS
Impact Analysis tools use reference field information to identify tables and programs that need to be modified. Before this enhancement, SQL tables did not propagate reference information.
- CREATE TABLE AS is enhanced to store the originating column and table as the reference information in the file object.
- When using LIKE to copy columns from another table, REFFLD information will be copied for each column that has a REFFLD in the original table.
- When using AS to define a new column, any column that directly references a table or view (not used in an expression) will have a REFFLD defined that refers to that column.
- A simple CAST will also generate REFFLD information (i.e. CAST (PARTNAME as varchar(50)) )
Improved field reference example
Was this topic helpful?
11 April 2021