Re: dbaccess load & unload ?

Matt Brickley <mbrickley@InfoAve.Net> wrote in article <3324623F.62F7@InfoAve.Net>... > I am on SE 5.0 > > I am doing some testing and want to be able to quickly reload test data > into a table. > My Administrator's Guide says that the best way to load and unload > a single table is to use the the dbaccess LOAD & UNLOAD statements. > My DB-Access manual has no reference to these commands and not much > on any command line operations. > > Am I missing something(or a manual)? > > If anyone can, please provide me the command line syntax for the LOAD, > UNLOAD statements. UNLOAD TO <filename>SELECT <colnames> FROM <tabname> WHERE <condition>; LOAD FROM <filename>INSERT INTO <tabname>; eg unload to item.unl select * from item; load from item.unl insert into item; The unload file goes into the current working directory if a path is not specifed.