db2 - delete in batches
Hi, We have a requirement to do a mass delete on huge tables (One of tables has ~ 4 rows). We need to clear out data older than a particular date. Deleting the rows at one shot does not work, the operation is rolled back. Any pointers as to how to perform the delete in batches would be helpful. Would it be possible to delete the rows without logging? Will that allow huge mass deletes? Thanks!! Ramya -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to [EMAIL PROTECTED] with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html
SORT help - to split by delimiters
Hi, I have a requirement which states like this: Given records like 1~ABC~99.99~12345 123~AB~9.99~567 34~c~1.99~345 where there are 4 fields in each record, each separated by a '~'. The third field is the price field, which i need to sum up. I wont know the starting position / length of the fields. Is there any way that i can sum up the price, using Sort or DYL, without having to write a COBOL program using UNSTRING? Thanks in advance, Ramya -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to [EMAIL PROTECTED] with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html