====== 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