You can specify these options for open statements.
-
cursor_name
- Name of the cursor to be opened.
- USING
- Variables used as input to the SQL statement by cursor_name.
- The USING clause is valid only for result set cursors.
- See
Teradata Vantage™ - SQL Stored Procedures and Embedded SQL
, B035-1148
for details.
-
SQL_identifier
-
parameter_reference
- Set of variables to be supplied as input to the prepared SQL request.
- The maximum length of a database object name is either 30 LATIN characters or 128 Unicode characters. For details about object name length limits, see
Teradata Vantage™ - SQL Fundamentals, B035-1141.
-
SQL_identifier or parameter_reference must be a valid SQL variable and must be declared prior to the OPEN statement.