The Pass-Through Facility for Relational Databases CONNECTION TO Component 235
Useful Statements to Include in EXECUTE Statements
You can pass the following statements to the DBMS by using the Pass-Through
Facility’s EXECUTE statement.
CREATE
creates a DBMS table, view, index, or other DBMS object, depending on how the
statement is specified.
DELETE
deletes rows from a DBMS table.
DROP
deletes a DBMS table, view, or other DBMS object, depending on how the
statement is specified.
GRANT
gives users the authority to access or modify objects such as tables or views.
INSERT
adds rows to a DBMS table.
REVOKE
revokes the access or modification privileges that were given to users by the
GRANT statement.
UPDATE
modifies the data in one column of a row in a DBMS table.
For more information and restrictions on these and other SQL statements, see the
SQL documentation for your DBMS.
CONNECTION TO Component
Retrieves and uses DBMS data in a PROC SQL query or view
Valid in: PROC SQL step SELECT statements (when accessing DBMS data using
SAS/ACCESS software)
Syntax
CONNECTION TO dbms-name | alias (dbms-query)
The CONNECTION TO component specifies the DBMS connection that you want to
use or that you want to create (if you have omitted the CONNECT statement).
CONNECTION TO then enables you to retrieve DBMS data directly through a PROC
SQL query.
You use the CONNECTION TO component in the FROM clause of a PROC SQL
SELECT statement:
PROC SQL;
SELECT column-list
FROM CONNECTION TO dbms-name (dbms-query)
other optional PROC SQL clauses
QUIT;
