Controls
options of transfer of AS/400 file on PC.
It is mandatory to use it before using a DBFXFER
command.
Default DBFXFER command creates an ASCII file with the following properties :
• field separator : semicolon ";"
• record separator (line break)
• all fields in double quotes, column headers on first line
Syntax
CHGVAR VAR(&CMD)VALUE('DBXPROP')
CHGVAR VAR(&PARM1)VALUE('Property')
CHGVAR VAR(&PARM2)VALUE('Value')
CALL PGM(LNCCMD) PARM(&HANDLE &CMD &OPT &PARM1 +
&PARM2 &RESULT)
Parameters
|
Property (PARM1) |
Value (PARM2) |
Default |
Description |
|
FLDSEP |
character or string |
; |
Defines fields separator |
|
COLHDG |
OFF SNAME LNAME COLHDG |
SNAME |
OFF = no column headers. SNAME = short zone name used as column name. LNAME = long zone name, or alias, used as column name. COLHDG = zone "Column Heading" is used. |
|
NUMPREFSUF |
ON/OFF |
OFF |
No double quotes for digital values. |
|
FLDPREF |
character or string |
" |
Field beginning character. |
|
FLDSUF |
character or string |
" |
Field ending character. |
|
DESCFILE |
ON/OFF |
ON |
Generates a description file (*.lfd). |
|
UNICODE |
ON/OFF |
OFF |
Creates an UNICODE format text file. |
|
DBLQUOTE |
ON/OFF |
ON |
ON : Double quotes may be doubled in zone values. OFF : no doubling. |
Example
CHGVAR VAR(&CMD) VALUE('DBXPROP')
CHGVAR VAR(&PARM1) VALUE('DESCFILE')
CHGVAR VAR(&PARM2) VALUE('OFF')
The next DBFXFER will only create the data text file and not the description file (*.lfd).
Other example
Disable Unicode transfer:
LNCCMD CMD(DBXPROP) PARM1('UNICODE') PARM2('OFF')
See also
• DBFXFER