Re: perl: load from filename insert into ... doesn't work

In article <38D705A7.CCF55FE4@earthlink.net>, Jonathan Leffler <jleffler@earthlink.net> writes >Dirk Reckeweg wrote: > >> I have a problem when trying to load data from a file into a table. I >> use (example) >> dbh->do("load from xyz insert into abc") >> but I get a syntaxerror -201. With dbaccess this statement works. >> >> Isn't it possible to use this statement with perl DBD? > >No, it isn't. And it probably should be a FAQ. > >DB-Access (and ISQL and I4GL and D4GL and ... anything else that >implements >LOAD or UNLOAD) implements LOAD and UNLOAD via subroutine library calls. >The subroutines are not even the same in each product -- ISQL and I4GL >share the code, but the others are separate. > >It is not actually an SQL statement. You cannot use either LOAD or >UNLOAD >in any ESQL/C program as a simple ESQL/C statement. A close scrutiny of >the manual marks it as DB-Access only. > > Added to pending list for the FAQ! -- David Williams