Setting Default Options for Your Functions › Model Values Used in Building Functions › YSQLLCK

YSQLLCK

The SQL Locking (YSQLLCK) model value specifies whether a row to be updated is locked at the time it is read or at the time it is updated. The default is *UPD, lock rows at time of update.

YSQLVNM

The SQL Naming (YSQLVNM) model value specifies whether to use the extended SQL naming capability. The valid values are:

*DDS

Use DDS names. The shipped default.

*SQL

Use the names of the CA 2E objects in the model.

*LNG

Use the long names of the CA 2E objects in the model along with the DDS or implementation names.

*LNF

Use the long field names of the CA 2E objects in the model along with the DDS or implementation names.

*LNT

Use the long table names of the CA 2E objects in the model along with the DDS or implementation names.

Note:

If a table that has a valid system name (less than or equal to 10 bytes in length), is generated with YSQLVNM model value set as *LNG or *LNT, and when you set the Enhance SQL Naming option on the Edit File Details panel to Y and then generate the source, the table is created with (underscores) "_"s and "TABLE" as suffix, so that the name of the table becomes more than 10 char long.

Examples:

• CUSTOMER is generated as CUSTOMER_TABLE along with its 2E implementation name.
• CUST is generated as CUST__TABLE along with its 2E implementation name.
• C is generated as C_____TABLE along with its 2E implementation name.
• To generate or regenerate a function with RLA code for DDL database, set the YSQLVNM model value to *DDS or *LNG or *LNT, or *LNF and set the YDDLDBA model value to *RLA.