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.