The following syntax is supported for the EXEC command:

EXEC rfc_name
[{value | @variable [OUTPUT]}][,...n]
[@parameter = {value | @variable [OUTPUT]}][,...n] [;]

The following table lists the syntax elements.

The following examples show the syntax for EXEC statements.

The following EXEC statement executes a BAPI that has no input parameters.

EXEC BAPI_COMPANYCODE_GETLIST

The following EXEC statement executes an RFC that has one input parameter. The parameter specifies a name and a value.

EXEC RFC_CUSTOMER_GET @NAME1='Contoso'

The following EXEC statement executes an RFC that has an input parameter. No name is specified, only a value is used.

EXEC RFC_CUSTOMER_GET '1001'

The following EXEC statement executes an RFC that has an input parameter specified in a variable.

To execute this statement, you must create a SAPParameter object with name @var, set its value to 1001, and add it to the SAPCommand object corresponding to the query. The value of the variable must be 1001, because the first parameter for RFCRFC_CUSTOMER_GET corresponds to KUNNR.

EXEC RFC_CUSTOMER_GET @var

The following EXEC statement executes an RFC that uses two parameters. The value of the first parameter, KUNNR, is set to *, to indicate all customer numbers, and the second parameter, NAME1, is set to the value of the variable, @var1.

To execute this statement, you must create a SAPParameter object with the name @var1, specify its value, and add the new object to the SAPCommand object corresponding to the query. The direction of the SAPParameter object must be input.

RFC_CUSTOMER_GET @KUNNR='*',@NAME1=@var1

The following EXEC statement executes a BAPI that returns company names and information about each company.

To execute this statement, you must create a SAPParameter with the name @tableVar, specify its value, and add the SAPParameter to the SAPCommand object corresponding to the query. The direction of the SAPParameter object created must be inputoutput.

EXEC BAPI_COMPANYCODE_GETLIST @COMPANYCODE_LIST=@tableVar OUTPUT

The supported syntax for the SELECT command follows:

SELECT [TOP n] {ColumnName [AS Alias] | TableName.* | *}[1,..n]
[INTO FILE FileName [DELIMITED]]
FROM TableName [AS Alias]
[WHERE search_conditions] [OPTION 'no_conversion'] [;]

The following table lists the clauses that the SELECT syntax supports.

To learn more about the SELECT clauses, see Parts of a SELECT Statement.

The following table lists the logical and comparison operators that the SELECT syntax supports.

The following examples show the syntax for SELECT statements.

The following SELECT statement returns all the columns in the SPFLI table.

SELECT * FROM SPFLI

The following SELECT statement writes the data from the SPFLI table to the file, flight.txt, located in the Extracts folder on the SAPSERVER computer.

SELECT * INTO FILE '\\SAPServer\Extracts\flight.txt' FROM SPFLI

The following SELECT statement returns all the columns in the SPFLI table for flights that fly from New York to San Francisco.

SELECT* FROM SPFLI WHERE cityfrom='NEW YORK’ AND cityto=’SAN FRANCISCO’

The following SELECT statement returns all the columns in the SPFLI table for the flights from New York whose identifier is between 1000 and 5000.

SELECT * FROM SPFLI where cityfrom=’NEW YORK' AND (connid BETWEEN 1000 and 5000)

You can use the following statement to return the same result set.

SELECT * FROM SPFLI where cityfrom='NEW YORK' AND (connid>1000 AND connid<5000)

The following SELECT statement returns all the columns in the SPFLI table for flights from New York to a city that is specified by the value of a variable.

To execute this statement, you must create a SAPParameter with the name @variable, specify its value, and add the SAPParameter to the SAPCommand object corresponding to the query.

SELECT * FROM SPFLI WHERE cityfrom='NEW YORK' AND cityto=@variable