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