Re: database.execute & LWirePro

Patrick wrote: > > Cannot perform the following function from a Javascript program: > > database.execute("load from source insert into temp"); > > is the load function supported?? I'm trying to load in delimted data > from a flat file into an informix database. > > taa, > & TIA > > Patrick The LOAD command is implemented by the front end and not by the database engine. Not all Informix tools support it: isql and 4GL do, ESQL/C doesn't (unless it's been added to later versions). It seems very unlikely that there would be a way to support it directly in Java. You would need to provide a class to read the file line by line and execute SQL to INSERT it. Ian