Skip to Content
0
Former Member
Apr 30, 2008 at 08:09 AM

Select/Read/Update in packages

64 Views

Hello Masters.

I'm having a problem with a report that is supposed to update a field in a table.

This table has 3.4 million lines and I have to update all of the lines, because of a new field I've just appended.

The program is giving me an error of lack of space to increase my local table (TSV_TNEW_PAGE_ALLOC_FAILED

) and the only way I'm seeing to solve this problem is to read this table in smaller packages; after I have all these smaller packages I can go on with the rest of the updating.

I'm I thinking right? What do you advise me to do? How can I do several selects to pick up all the data in the end? Is there a way to do a select for the first 200 thousand and then the next 200 thousand or something like that? How can I know if I'm already at the end of the major table?

Thank you in advance for your help.

Regards.

Jorge Ferreira