The SQL Procedure

EXECUTE Statement

Sends a DBMS-specific SQL statement to a DBMS that is supported by a SAS/ACCESS interface.

Requirement: SAS/ACCESS software is required. For more information on this statement, refer to your SAS/ACCESS documentation.

See also: Connecting to a DBMS Using the SQL Procedure Pass-Through Facility and the SQL documentation for your DBMS.

EXECUTE (dbms-SQL-statement)
BY dbms-name|alias;

alias: specifies an optional alias that is defined in the CONNECT statement. Note that alias must be preceded by the keyword BY.
dbms-name: identifies the DBMS to which you want to direct the DBMS statement (for example, ORACLE or DB2).
dbms-SQL-statement: is any DBMS-specific SQL statement, except the SELECT statement, that can be executed by the DBMS-specific dynamic SQL.

If your DBMS supports multiple connections, you can use the alias that is defined in the CONNECT statement. This alias directs the EXECUTE statements to a specific DBMS connection.
Any return code or message that is generated by the DBMS is available in the macro variables SQLXRC and SQLXMSG after the statement completes.

Requirement:	SAS/ACCESS software is required. For more information on this statement, refer to your SAS/ACCESS documentation.
See also:	Connecting to a DBMS Using the SQL Procedure Pass-Through Facility and the SQL documentation for your DBMS.