08-02-2005
3,216,
33
Join Date: Mar 2005
Last Activity: 4 September 2020, 7:11 AM EDT
Location: classification algos
Posts: 3,216
Thanks Given: 19
Thanked 33 Times in 30 Posts
multiple updates
Hi all,
I would like to perform multiple updates within a single database open and close.
Box: solaris
dB: informix
This is how i do perform for single update
dbaccess <dbname> -<<EOF
update table1 set col1=1 where col2=1
EOF
i have the col1 values in a file (some 1000 values)
now how do i proceed with an update of 100 values at a time and give a commit. The above sample is time consuming as it has to open and close the database for each and every update done.
And between the dbaccess and EOF i cannot read from the file as within them only database operations are allowed and no file manipulation, storing in variables are allowed.
Any help would be greatly appreciated.
Thanks.