The SQL Naming Length (YSQLLEN) model value is a numeric value that controls the length of the extended SQL name. Its maximum value is 25. This model value is used only when YSQLVNM is *SQL.
YSQLLEN lets you trim the SQL name so that it conforms to the parameters of the version of i OS or a third party RDBMS; for example, SQL as supported by i OS permits extended names up to 10 characters prior to V3R1 and supports 30 characters under V3R1 and beyond.
Note: If you are running i OS V3R1 or beyond and set YSQLLEN to a value greater than 10, you also need the QDBRTVSN IBM API in order to successfully submit IBM i physical file access paths for generation and compilation. This API is used to retrieve the ten-byte character name from the long SQL name. If the API is not present, the submission will fail.
The Generate SQL Collection/Library Name (YSQLCOL) model value specifies whether a hard coded SQL Collection/Library name should be generated for tables, indexes and views. The possible values are *YES and *NO. The shipped default is *YES.
If YSQLCOL is specified as *YES, the SQL Collection/Library specified for the YSQLLIB model value is generated into the tables, indexes and views, by default, as is the case now. Subsequently when YEXCSQL is executed to create tables, indexes and views, they are created into the hard coded SQL Collection/Library. If YSQLCOL is specified as *NO, the SQL Collection/Library specified for the YSQLLIB model value is not generated into the tables, indexes and views. However, when YEXCSQL is executed subsequently, the tables, indexes and views are generated into the SQL Collection/Library specified for the YSQLLIB model value.
Note: If YSQLCOL is set to *NO and the access paths are generated, another change that can seen in the source, apart from the absence of hard coded SQL collection/Library name is, the previously generated Z* line "Z* YEXCSQL NAMING(*SQL)" is now generated as "Z* YEXCSQL NAMING(*SYS)".
|
Copyright © 2014 CA.
All rights reserved.
|
|