You specify DBMS SQL syntax instead of SAS SQL syntax when you use the Pass-Through Facility. You can use Pass-Through Facility statements in a PROC SQL query or store them in a PROC SQL view. The ...

For example, upon successfully issuing a CREATE TABLE statement, the DBMS populates the metadata for the table into tables named SYSTABLES and SYSCOLUMNS (or something similar). The same is true for ...

specifies the query that you are sending to the DBMS. The query can use any DBMS-specific SQL statement or syntax that is valid for the DBMS. However, the query cannot contain a semicolon because to ...

For example, MySQL allows users to choose between the XA-compliant ... After the install, the physical DBMS schema choice should be hidden from the administrators who manage database schemas, as well ...