Properties |
Values & Description |
MAIN |
Set the main AS/400 file name associated with the WinDev file. File name can be qualified with a library name: • LIBRARY/FILE Or without library name, to use *LIBL (Preferred): • FILE A member name can be specified after the file name: • MYFILE(MEMBER_A)
|
JOURNALED |
Tell Easycom that the filed is journalized and must be opened under commitment control. This property is automatically set when file description is imported. See also AUTOJOURNAL connection level property. |
PFSYSNAME |
File short name, when file has a long name. |
SQLUPDATABLE |
See SQLLIVE connection property. |
DATETYPE |
Set the AS/400 default data type for Date fields. See AS/400 Native Data Types for the possible values. |
TIMETYPE |
Set the AS/400 default data type for Time fields. See AS/400 Native Data Types for the possible values. |
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.
DATETYPE / TIMETYPE
This option associates all the date and time fields of the file with another type of format for an automatic query formatting in HRequĂȘteDĂ©faut mode. It can also be defined at the connection level (see detail) or at the heading level by the NATIVETYPE option (see below).