Properties

Values & Description

AUTOJOURNAL

TRUE / FALSE
During file description import, property "Journaled" is set to value "true" at file level. in the analysis.
File will be journalized when open.

CODEPAGEFILE

Set the codepage file to use to convert to and from EBCDIC character set.
Example:
CODEPAGEFILE=

CONNECTION TIMEOUT

Delay in seconds before returning an error, if connection fail.

COMMAND TIMEOUT

Maximum Delay in seconds when waiting for an answer from the AS/400 system on a read operation for example.

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.

DRVOPTIMISTIC

When set to TRUE, every record update (HModify)

•     Locks the record,

•     Reads data,

•     Write new data if no change were made by another job since record was read.

DUPPATH

Set this property to TRUE, to authorize Easycom to duplicate open paths when a filter with conditions is applied on a key, while the file is already filtered on the same key in another HyperFile Context.

EIM_LOOKUP_INFO

This is the lookup information to use when performing an EIM connection. That EIM connection can come from a certificate authentication (SSL) or from a Kerberos authentication.

This Lookup information is used to resolve ambiguous mappings: from one authentication it can go to different OS/400 users depending on the lookup information value. See EIM configuration for more details.

EXTRAIDX

Allows Easycom to use composite key as index on the first field of the composite key.

The column witch is the first field of the composite key will become a sort criteria in a Table control, and the magnifier icon will be displayed.

FIELDNAMES_MUST_MATCH

0 / 1

When = 1 fieldnames must be identical both on iseries and in the analysis (if not the HOpen fails with an error message)

When = 0 the fieldnames may be different but must be in the same physical order.

FORCELIBL

0 / 1

When set to 1, library names presents in extended info, at file or field level, will be ignored.
All files will be searched in the LIBL, even if it is qualified.

HFMAXKEY

When the highest character in the AS/400 is not FF(hexa), you need to give it by property HFMAXKEY, in order to handle correctly HValMax.

IGNORE_EMPTY_EXTINFO

If no extended info is given for a file, Easycom will assume that the AS/400 physical file name is equal to the the WinDev file name, logical file name are equal to the key field names in the analysis.

IMPORT_DFT

0 / 1

When=1 the iseries default values are imported into the analysis.

IMPORT_SELOMIT

By default, Easycom does not use logical files with omissions or selections, as indexes.

By setting this property to 1, you allow Easycom to consider all logical files as indexes during file description import.

Warning! Logical files with selections or omissions do not contain all the data from the physical files !

INITLIBL

List the library names you want to add on top of the library list. Library names are separated by a semicolon (;).
Example:
INITLIBL=

LITERALCASE

Controls the way file and field names are built.

See Controling Character Case for file and field names .

JOBNAME

Name to set to the client job on AS/400.
Default job name is the workstation name.

LEADINGSPACES

WinDev 5.5 compatibility.
When this option is set to True, all character field values are padded with blanks, up to the size of the database field on AS/400, on read operations.

ONLYSHORTFILEDNAMES

0 / 1
When a file description is imported, only short field names are used when this property is set.

PGMNAME

This option defines what is the EASYCOM program name. Default is EASYCOM. Example of value: EASYCOMT/EASYCOM.

SQLNAMING

SYS / SQL
With value SYS, character slash (/) is used to separate library and file names.
With value SQL, a point (.) is used.

SHOWDIALOGS

O / 1

Disable / Enable Easycom dialog boxes.

It is important to disable dialog boxes for web applications, or for applications running on servers. When dialog boxes are disabled, in case of error, error message is sent to the application without any intermediate message box.

SSL

True/False/Mandatory/Undefined
Forces SSL mode. If true, the SSL connection will be attempted. If mandatory SSL connection will be attempted, and if the connection could not use SSL, it is aborted.

SSLINTF

Windows/OpenSSL
SSL interface to use.

SSLCAFILE

In OpenSSL, the CA file to verify server certificate.

SSLCAPATH

In OpenSSL, the CA path in which searching for authority certificates. This is to verify the server cerficicate.

TCP_VERSION

This option is used to force the TCP/IP version. By default the tcp/ip version is automatically selected from the DNS. Possible values are 4 for IPv4 or 6 for IPv6.

USER_CERT_FILE

Client certificate file. This is for client certificate authentication, when OpenSSL is used. The certificate file must be in PEM format. When using Windows interface the option is not needed: the certificate is automatically selected.

USER_CERT_PKEY_FILE

Client certificate private key file. This is the file path for the OpenSSL private key file. When using Windows interface the option is not needed: the certificate and private key is automatically selected.

USER_CERT_PASSPHRASE

Passphrase to be able to read the private key file. This is used in OpenSSL only.

STRICTIDENTICAL

0/1 When a hidentical search is performed, use strict behaviour. This uses really full key equal search (not greater equal), and the current position is unchanged in case of record not found condition

SQLFULLPRECISION

0 / 1

When this property is set to 1, long decimal values resulting from SQL functions are converted to character string, when the precision exceed the precision of WinDev "currency" data type.

SQLHPOS

0 / 1

When true, the table with direct link to data (file or query) generates more actions on the iseries to reflect intuitive behaviour (mostly scrollbar position)

SQLIDX

When set to True, this options allows to use any column of an SQL result set like an index. The user will be able to change the order of the records displayed in a table.

This option can affect the performances; Use it carefully.

SQLLIVE

Possible values are:

0 (default) : It is not possible to update a record from an SQL result set.

1 : Only files having "SQLUPDATABLE=1" extended info, can be updated out of an SQL result set.

3 : All files can be updates out of an SQL result set, except files having "SQLUPDATABLE=0" extended info.
Field level extended info "SQLUPDATABLE=0" can also be set to deny modification of field values.

Note:
All the field names must appear in the "SELECT statement". You cannot use *.

TCPIP_FATAL

0 / 1

By default, TCP/IP error is fatal, end stop the application.
By setting this property to 0, you can manage TCP/IP errors, and for example, restart your application in case of error.

TIMEOUTNOTIF

TRUE / FALSE

WinDev Mobile only.
When an execution time is supposed to be long because Wi-Fi connection was lost, a message is shown to the user, when this property is set to TRUE.

UNLOCK

This option is connected Easycom "Program Level Security" Exit program.
It sets the password value to pass to EACP003 Exit program to unlock Easycom server, and authorize databases and program access.

USER_CERT_FILE

Client certificate file. This is for client certificate authentication, when OpenSSL is used. The certificate file must be in PEM format. When using Windows interface the option is not needed: the certificate is automatically selected.

USER_CERT_PKEY_FILE

Client certificate private key file. This is the file path for the OpenSSL private key file. When using Windows interface the option is not needed: the certificate and private key is automatically selected.

USER_CERT_PASSPHRASE

Passphrase to be able to read the private key file. This is used in OpenSSL only.