Batch Export Examples

Restriction: This topic applies to Windows environments only.

The following Batch Export file contains examples of transactions for each file type. All the transactions are contained into a single file.

[FREE ASCII]
TABLE = SYSTEM.TUTORIAL.QMT_STAFF;
WHERE = "YEARS <= 3";
FILENAME = C:\XDBWIN\SYSTEM\QMT_STAFF.FRE;
FORMAT = FREASC;
REPLACE = y;
FIELDS = EMPID,LNAME,FNAME,DEPARTMENT,JOB,YEARS;
HEADING = y;
QUOTES = y;
FLD_DELIMITER = ",";
REC_DELIMITER = "<013><010>";
ON_ERROR = CONTINUE;
ERR_LOG_FILE = c:\xdbwin\tutorial\errors.log;
APPEND_ERR_FILE = y;
[FIXED ASCII]
TABLE = SYSTEM.TUTORIAL.QMT_STAFF;
WHERE = "YEARS <= 3";
FILENAME = C:\XDBWIN\SYSTEM\QMT_STAFF.FIX;
FORMAT = FIXASC;
REPLACE = y;
FIELDS = EMPID,LNAME,FNAME,DEPARTMENT,JOB,YEARS;
HEADING = y;
SPACES = 2;
ON_ERROR = CONTINUE;
ERR_LOG_FILE = c:\xdbwin\tutorial\errors.log;
APPEND_ERR_FILE = y;
[DSNTIAUL]
TABLE = SYSTEM.TUTORIAL.QMT_STAFF;
WHERE = "YEARS <= 3";
FILENAME = C:\XDBWIN\SYSTEM\QMT_STAFF.DSN;
FORMAT = DSNTIAUL;
REPLACE = y;
FIELDS = EMPID,LNAME,FNAME,DEPARTMENT,JOB,YEARS;
[SQL Statement]
TABLE = SYSTEM.TUTORIAL.QMT_STAFF;
WHERE = "YEARS <= 3";
FILENAME = C:\XDBWIN\SYSTEM\QMT_STAFF.SQL;
FORMAT = SQL;
REPLACE = y;
FIELDS = EMPID,LNAME,FNAME,DEPARTMENT,JOB,YEARS;
SQL_OPTS = INSERT,CHECK,COMMENT;