sqlerrd[2] meaning - Host Array Updates
edward17Jul 16 2003 — edited Jul 23 2003I am updating a table using a host array.
Updating with arrays' in Chapter 8 of the PROC Programmers Guide states 'The cumulative number of rows updated can be found in sqlerrd[2]'
Earlier in the chapter it states:
'sqlerrd[2] is also useful when an error occurs during an array operation. Processing stops at the row that caused the error'
If I have an array of 100 items, and the 15th element is updating a row that does not exist, will sqlerrd[2] return 15, indicating processing stopped after updating 14 rows, or 99, indicating 99 of 100 rows were updated?
I am trying to capture any row that does not update, so I can write it out to a file. I also want to continue so that the other 65 elements can be updated.
Is there a standard solution for this challenge?
Ed