Hello all,
I am writing a script which loops through the following nearly 300,000 times, putting rows into a database. However, each time it puts in a row, it displays "1 row(s) inserted"
This display is killing the time it takes to put in that massive amount of rows. I tried piping it to /dev/null but it won't work. even when i pipe the entire script to a file, it still displays the inserted comment every time a row is inserted. Any help with this?
echo "
insert into itemfile_tbl
values ('$CTITEMNUMBER','$CTPRICE')
" | dbaccess
Thanks a million!
- Jason
2006-12-15
04:36:26
·
1 answers
·
asked by
Jason
2