|
|
|
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 PTF numbers for the QDBRTVSN API are:
| Copyright © 2011 CA. All rights reserved. | Tell Technical Publications how we can improve this information |