This shows you the differences between two versions of the page.
associate-locator [2015/09/23 20:26] |
associate-locator [2015/09/23 20:26] (current) |
||
---|---|---|---|
Line 1: | Line 1: | ||
+ | ====== ASSOCIATE LOCATOR Statement ====== | ||
+ | ASSOCIATE LOCATOR statement allows you to associate locator variable with a result set returned from a stored procedure. | ||
+ | |||
+ | Then you can use [[allocate-cursor|ALLOCATE CURSOR]] statement to assign a cursor for the locator and fetch data. | ||
+ | |||
+ | **Syntax**: | ||
+ | |||
+ | <code language=sql> | ||
+ | ASSOCIATE [RESULT SET] LOCATOR | LOCATORS (loc [, locN, ...]) | ||
+ | WITH PROCEDURE procedure_name | ||
+ | </code> | ||
+ | |||
+ | For examples, see [[allocate-cursor|ALLOCATE CURSOR]] statement. | ||
+ | |||
+ | **Compatibility:** IBM DB2 | ||
+ | |||
+ | **Version:** HPL/SQL 0.3.11 |