Re: dbload problems

Careful though if its a large file and you are only loading certain columns. dbload is much faster when all column values are provided and you use the form: FILE "xxxx.yyy" DELIMITER "|" 3; INSERT INTO tablename; I usually dummy up the missing columns before running dbload. Mark D. Stock <marks@west.co.za> wrote in article <334DF7CC.44A3@west.co.za>... > devis wrote: > > > > I want importing a file ascii into a table. devis's request removed to preserve network bandwidth. > Create a command file like so: > > FILE "filename" DELIMITER "|" 3; > INSERT INTO tablename(colname1, colname2, colname3);> > Then run dbload as follows: > > dbload -d databasename -c commandfilename -l logfilename> remainder of Mark's reply removed for the same reason.