User Tools

Site Tools


Sidebar

**HPL/SQL is included to Apache Hive since version 2.0** * [[home|Home]]\\ * [[why|Why HPL/SQL]]\\ * [[features|Key Features]]\\ * [[start|Get Started]]\\ * [[doc|HPL/SQL Reference]]\\ * [[download|Download]]\\ * [[new|What's New]]\\ * [[about|About]]

associate-locator

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 statement to assign a cursor for the locator and fetch data.

Syntax:

ASSOCIATE [RESULT SET] LOCATOR | LOCATORS (loc [, locN, ...]) 
  WITH PROCEDURE procedure_name

For examples, see ALLOCATE CURSOR statement.

Compatibility: IBM DB2

Version: HPL/SQL 0.3.11