Re: Problems with LOAD

> This is because of the SERIAL column. You MUSt insert SOMETHING into > the SERIAL column. If you want the automatic next value inserted you > must insert a zero. By no loading the column you are inserting a NULL > which is not allowed. Try using dbload instead of the dbaccess LOAD > verb. Create a dbload command file like this: > > FILE 'path/file' delimiter '<ctrl-i>' N; #where N is the # columns in > the file > INSERT INTO testtable( col1, col2, col3, col4, col5, col6, ...) > VALUES (0, f1, f2, f3, f4, f5, ...);> > Then: > > dbload -c commandfile -d database -l errlog -e maxerrs -n commitcount -r Basically I just would like to know is it really possible to add fewer lines from your ascii file to table? It seem to bee so sometimes, but now usually. What are the preconditions for this kind of action?. Sent via Deja.com http://www.deja.com/ Share what you know. Learn what you don't.