RE: RE: AIX recommendations

2001-05-09 Thread Paul DuBois
At 9:11 AM -0400 5/9/01, Terry Shipclark wrote: >database,sql,query > >Why does this statement not work Because you're either not reading the manual or ignoring what it says? > >LOAD DATA INFILE 'intervext.txt' into table intvext >(intid,priphone,cellphone,pager,bdmonth,bdday,datehired,Notes

RE: RE: AIX recommendations

2001-05-09 Thread Terry Shipclark
database,sql,query Why does this statement not work LOAD DATA INFILE 'intervext.txt' into table intvext (intid,priphone,cellphone,pager,bdmonth,bdday,datehired,Notes) FIELDS TERMINATED BY ';' ENCLOSED BY '"' LINES TERMINATED BY '\n'; I also tried it like this LOA