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;