Sends a DBMS-specific SQL statement to a DBMS that a SAS/ACCESS interface supports.
Requirement: | SAS/ACCESS software is required. For more information about this statement, see your SAS/ACCESS documentation. |
See: | Connecting to a DBMS by Using the SQL Procedure Pass-Through Facility |
SQL documentation for your DBMS |
specifies an optional alias that is defined in the CONNECT statement. Note that alias must be preceded by the keyword BY.
identifies the DBMS to which you want to direct the DBMS statement (for example, ORACLE or DB2).
is any DBMS-specific SQL statement, except the SELECT statement, which can be executed by the DBMS-specific dynamic SQL. The SQL statement can contain a semicolon. The SQL statement can be case-sensitive, depending on your data source, and it is passed to the data source exactly as you enter it.
proc sql; execute(drop table ' My Invoice ') by db; execute(create table ' My Invoice '( ' Invoice Number ' LONG not null, ' Billed To ' VARCHAR(20), ' Amount ' CURRENCY, ' BILLED ON ' DATETIME)) by db; execute(insert into ' My Invoice ' values( 12345, 'John Doe', 123.45, #11/22/2003#)) by db; quit;