|
Properties |
Values & Description |
|
LF |
Logical File name for a key field. File name can be qualified with a library name: • LIBRARY/LFILE Or without library name, to use *LIBL (Preferred): • LFILE
|
|
SYSNAME |
Short field name, when the field has a long name, and when the field is not a multi member key field. |
|
LFSYSNAME |
File short name, when logical file has a long name. |
|
SQLUPDATABLE |
See SQLLIVE connection property. |
|
NATIVETYPE |
This property is automatically set for some data types,
when file description is imported. See AS/400 Native Data Types for the possible values. |
LF
Chemin d'accès du fichier logique correspondant à une clé.
LF=Library name/Short name of the logical file
SYSNAME
Short name (system) for a non-key field, unique key and key with duplicate
SYSNAME=Short name of the field (10 caractères maxi)
LFSYSNAME
Nom court (système) pour le fichier logique associé à une rubrique clé composée
LFSYSNAME=Nom court du Fichier Logique (10 characters max)
SQLUPDATABLE
To be able to modify the result of a SQL query, the extended infos of the Connection must contain the SQLLIVE option with a value of 1 or 3.
If SQLLIVE = 1, the files that can be modified must contain the option SQLUPDATABLE = 1.
If SQLLIVE = 3, all the files are modifiable by default, but it is possible to exclude a particular file (to prevent any update from a request), with the option SQLUPDATABLE to 0.
NATIVETYPE
This option is automatically inserted when a Date or Time field is associated with another format. See the possible values in the DATETYPE / TIMETYPE option of the extended information of the connection.
For example, if a Date field is associated with a CHAR field (on 8 characters) we will have:
NATIVETYPE=0