2.26 Extended statement name

Organization of this section
(1) Overview
(2) Format
(3) Explanation
(4) Rules

(1) Overview

The extended statement name, when specified in a PREPARE statement, identifies the SQL statement that is prepared by the PREPARE statement. When specified in any of the following SQL statements, the extended statement name permits operations on the SQL statement that is identified by it:

(2) Format

extended-statement-name::= scope-option : embedded-variable
scope-option ::= GLOBAL

(3) Explanation

(4) Rules

  1. Values must be specified in embedded-variable according to the specification method applicable to SQL statement identifiers. For details about SQL statement identifier specification methods, see 1.1.7 Specification of names.
  2. Valid extended statement names having the same value are identified as the same extended statement name.
  3. If the value of an extended statement name is the same as an SQL statement identifier directly specified in an SQL statement, both are distinguished as identifying different SQL statements.