Batch Import Examples

Restriction: This topic applies to Windows environments only.

The following Batch Import command file contains examples of Batch Import transactions for the more common file formats. The [FREE ASCII] import transaction shows an example of error logging. In this example, all of the transactions are grouped into a single Batch Import file.

[DSNTIAUL]
TABLE = TUTORIAL.TUTORIAL.EMPLOYEE;
FILENAME = C:\XDBWIN\TUTORIAL\EMPLOYEE.DSN;
FORMAT = DSNTIAUL;
FIELDS = e_no,lname,fname,street,city,st,zip,dept,payrate,com;
TYPES = si,ch(10),ch(10),ch(20),ch(15),ch(2),ch(5),
  ch(4),dc(15,2),dc(2,2);
NULL_PERM = n,n,n,y,y,y,y,y,y,y;
USE_PIC = na,na,na,na,na,na,na,na,y,y;
INS_NULL = n,n,n,y,y,y,y,y,y,y;
EBCDIC_TO_ACSII = y,y,y,y,y,y,y,y,y,y;
REPLACE = y;
INSERT_MODE = normal;
[FREE ASCII]
TABLE = TUTORIAL.TUTORIAL.EMPLOYEE;
FILENAME = C:\XDBWIN\TUTORIAL\EMPLOYEE.FRE;
FORMAT = FREASC;
FIELDS = e_no,lname,fname,street,city,st,zip,dept,payrate,com;
TYPES = si,ch(10),ch(10),ch(20),ch(15),ch(2),ch(5),ch(4),
  dc(15,2),dc(2,2);
NULL_PERM = n,n,n,y,y,y,y,y,y,y;
USE_PIC = na,na,na,na,na,na,na,na,y,y;
INS_NULL = n,n,n,y,y,y,y,y,y,y;
HEADING = y;
QUOTES = y;
FLD_DELIMITER = "@";
REC_DELIMITER = "<013><010>";
REPLACE = y;
INSERT_MODE = normal;
ERR_LOG_FILE = c:\xdbwin\tutorial\errors.log;
APPEND_ERR_FILE = y;
BAD_REC_FILE = c:\xdbwin\tutorial\freerecs.log;
APPEND_REC_FILE = n;
[Fixed ASCII]
TABLE = TUTORIAL.TUTORIAL.EMPLOYEE;
FILENAME = C:\XDBWIN\TUTORIAL\EMPLOYEE.FIX;
FORMAT = FIXASC;
FIELDS = e_no,lname,fname,street,city,st,zip,dept,payrate,com;
TYPES = si,ch(10),ch(10),ch(20),ch(15),ch(2),ch(5),ch(4),
  dc(15,2),dc(2,2);
NULL_PERM = n,n,n,y,y,y,y,y,y,y;
USE_PIC = na,na,na,na,na,na,na,na,y,y;
INS_NULL = n,n,n,y,y,y,y,y,y,y;
HEADING = y;
SPACES = 2;
OFFSETS = 1,11,23,35,57,74,78,85,91,114;
SRC_LENS = 8,10,10,20,15,2,5,4,21,4;
REPLACE = y;
INSERT_MODE = normal;