After the HOLD LOCATOR statement is executed, each locator variable in the variable list has the hold property.
The variable must currently have a locator assigned to it. That is, a locator must have been assigned during this unit of work (by a CALL, FETCH, SELECT INTO, SET variable, or VALUES INTO statement) and must not subsequently have been freed (by a FREE LOCATOR statement); otherwise, an error is raised.
If more than one variable is specified in the HOLD LOCATOR statement and an error occurs on one of the locators, no locators will be held.
(C) Copyright IBM Corporation 1992, 2006. All Rights Reserved.