PreviousNext
Help > Development > ASProperty > Alias file
Alias file

 

Alias files were used in WinDev 5.5 to identify AS/400 files. It is a text file located in the directory where the Hyperfile file is located.

 

[FILENAME]

$FILE=BIBLIO/FILE or FILE

CLE1=BIBLIO/LOGIC1

CLE2=BIBLIO/LOGIC2

...

$JNAL=TRUE // if the file is journalized

$READONLY=TRUE // readonly opening

 

$FILE is now theĀ  MAIN parameter in the extended information of the file.

The logical files associated with the keys are in the field extended information under the parameter LFSYSNAME.

$JNAL is now the JOURNALED parameter in the extended information of the file.

$READONLY is now applied bu opening the WinDev connection with the read-only mode (HOpenConnection).

 

Notes:

1.     If an alias file is used, the modification of the LIBL of the job will not be taken into account (ADDLIBLE).

2.     To use an alias file with HExecuteSQLQuery, use hQueryDefault

HExecuteSQLQuery (MYQUERY, MaConnexionpower8, hQueryDefault, sString)

 

Example of alias file: SP_CUST._as

 

 [SP_CUST]

$FILE=EASYCOMXM2/SP_CUST

CUST_ID=EASYCOMXM2/SP_CUST_CU

FIRSTNAME=EASYCOMXM2/SP_CUST_NA

STATE=EASYCOMXM2/SP_CUST_ST