On Sat, 19 Oct 2002, allenkb_at_nbnet.nb.ca wrote:
> 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)
Whats the ddl for PRIMARY_MEMBER and how bout the first 15 rows in the
file?
--
Galen deForest Boyer
Sweet dreams and flying machines in pieces on the ground.
Received on Fri Oct 18 2002 - 22:29:06 CDT
