Entering content frame

Background documentation USING Clause Locate the document in its SAP Library structure

Use the USING clause for dynamic SQL statements with parameters to assign values to the parameters in EXECUTE or OPEN CURSOR statements.

Prerequisites

·        You have used the PREPARE statement to prepare the SQL statement for execution.

·        If you are using a descriptor, you have initialized it with the DESCRIBE statement.

Syntax

<using_clause> ::=
  USING <parameter_list>
| USING DESCRIPTOR [<descriptor_name>]
| INTO <parameter_list>
| INTO DESCRIPTOR [<descriptor_name>]

·        If you do not specify <descriptor_name>, the standard structure sqlda is used.

·        Here, INTO has the same meaning as specifying USING. It guarantees compatibility with other database systems.

 

Leaving content frame