associate-locator

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

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