im trying to bring some text delimeted data into a table the folowing is
waht i use for a ctrl file. when i run the sqllder it bring in only 3
records, there are 650 in the text file, and the records it brings in are
the 1, 7 , 10 can anyone help me??
load data
INFILE 'C:\primarymember.txt'
INTO TABLE PRIMARY_MEMBER
APPEND
FIELDS TERMINATED BY ','
(PRIMEM,PRILASTNAME,PRIFIRSTNAME,PRIADDRESS1,PRIADDRESS2,PRICITY,PRIPOSTAL,
PRIPHONE,PRISECINST,PRISECADDRESS1,PRISECADDRESS2,PRISECCITY,PRISECPOSTAL,
PRISECPHONE,PRIMEMYEAR,PRIDENT,PRIMEMTYPE,PRIBIRTHDATE,PRINOTES,PRISHARE,PRI
YEAR)
Received on Fri Oct 18 2002 - 20:37:52 CDT
