SQL/DDL Implementation › Extended SQL Naming › YLVLCHK Model Value

YLVLCHK Model Value

The Generate IDX with LVLCHK(*YES) (YLVLCHK) model value specifies whether an Index (SQL or DDL), when generated with the RCDFMT keyword in it, is created with LVLCHK(*YES). The possible values are *NO and *YES. The shipped default is *NO.

If YLVLCHK is specified as *NO, then existing defaults around LVLCHK are retained when an SQL or DDL index is generated and created. The existing defaults for the LVLCHK attribute in the case of SQL and DDL are as follows.

• When a table or view is generated and created, it is generated with LVLCHK(*YES), irrespective of the existence of the RCDFMT keyword.
• When an index (SQL or DDL) is generated and created without the RCDFMT keyword, it is created with LVLCHK(*YES).
• When an index (SQL or DDL) is generated and created with the RCDFMT keyword, it is created with LVLCHK(*NO).

If YLVLCHK is specified as *YES (in addition to YSQLFMT set as *YES), upon subsequent generation and creation of an index (SQL or DDL), the index is created with LVLCHK(*YES).

Note: If YLVLCHK is set to *YES (along with YSQLFMT set to *YES), upon re-generation of the access path, an additional line "Y* CHGLF LVLCHK(*YES)" is generated into the header portion. This informs YEXCSQL to create the corresponding index with LVLCHK(*YES). For any other combination of YLVLCHK and YSQLFMT, there is no change to the existing processing.