Load using BTEQ

Use a comma seperated file (ABC.txt) and this will work to load the file into the given

.LOGON demotdat/XYZ_user,*****;
.IMPORT VARTEXT ‘,’ FILE=C:TDdataABC.TXT;
.REPEAT *
USING
emp_no (VARCHAR(6)),
emp_name (VARCHAR(25)),
emp_street (VARCHAR(25)),
emp_city (VARCHAR(25))

INSERT INTO my_db.emp
values
(
:emp_no,
:emp_name,
:emp_street,
:emp_city
);

.QUIT;

Leave a Reply

Your email address will not be published. Required fields are marked *