Long Name Scenarios

SQL/DDL Implementation › Extended SQL Naming › Understanding Extended SQL Naming › Long Name Scenarios

Long Name Scenarios

The following chart depicts the way tables get generated in 2E based on the following three factors and the corresponding impact on the functions.

YSQLVNM model values
Whether the model file name being generated is a valid system name
Whether the file level option “Enhance SQL Naming” flag is set to Y or N

Enhance SQL Name?	YSQLVNM Value	Model File Name	Table name	Table Implementation Name	Implementation name available for the table?	Table Name used by RLA function	Table Name used by SQL function	Function re-compilation required after enhanced table name?
Y	*LNG	Product	Product_TABLE	UUA2REP	Y	UUA2REP	UUA2REP	N
N	*LNG	Product	Product	UUA2REP	N	UUA2REP	UUA2REP	N/A (*)
Y	*LNG	Purchased_Products	Purchased_Products	UUB2REP	Y	UUB2REP	UUB2REP	N
N	*LNG	Purchased_Products	Purchased_Products	UUB2REP	Y	UUB2REP	UUB2REP	N
Y/N	*SQL	Product	Product	UUA2REP	N	UUA2REP	Product	N
Y/N	*SQL	Purchased_Products	Purchased_Products	N/A	N	UUA2REP	Purchased_Products	N
Y/N	*DDS	Product	N/A	UUA2REP	Y	UUA2REP	UUA2REP	N
Y/N	*LNF	Product	UUA2REP	UUA2REP	Y	UUA2REP	UUA2REP	N
Y/N	*LNF	Purchased_Products	UUB2REP	UUB2REP	Y	UUB2REP	UUB2REP	N
Y	*LNT	Product	Product_TABLE	UUA2REP	Y	UUA2REP	UUA2REP	N
N	*LNT	Product	Product	UUA2REP	N	UUA2REP	UUA2REP	N/A (*)
Y/N	*LNT	Purchased_Products	Purchased_Products	UUB2REP	Y	UUB2REP	UUB2REP	N

(*) E* line generated in the ACP source

Example:

When the YSQLVNM Model value is set to *LNG or *LNT and the model file name is “Product” and the file level option, Enhance SQL naming flag is set to Y, then the table is generated with a suffix “_TABLE” (that is, the table is generated with the name “Product_TABLE”). This table is also accessible using its implementation name, UUA2REP. The functions built over the access paths (Table, views and so on) use the implementation name of the table/views and need not be recompiled when the Enhance SQL Naming flag is switched from N to Y.