PreviousNext
Help > Development > Extended info > File Level Properties
File Level Properties

 

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).