I have a JDB table (650K records, 12 fields) on a remote server that I
need to update.
There are ~40K records where I need to update one field. My first
thought was to create the update statements then loop through them one
at a time.
When I tested this on smaller sets of about 200-300 records it worked
fine, but when I went to do the bulk update of 40K records I received
the following message:
|JDB command failed:
|allocation error: commit
| deleted =:deleted,Tran,.Tdelete{tranid
: checkrc
| jdb__a(>(recnum{uprec))
I am guessing that the mapped files did not have enough space to handle
all of the updates, therefore the allocation error. My question is what
would be the best method to do bulk updates like this in JDB?
Thanks,
Ken
----------------------------------------------------------------------
For information about J forums see http://www.jsoftware.com/forums.htm
