SQL Pass-Through Facility Specifics for Yellowbrick

Key Information

For general information about this feature, see SQL Pass-Through Facility.

Here are the SQL pass-through facility specifics for the Yellowbrick interface.

• The dbms-name is YBRICK.
• The CONNECT statement is required.
• PROC SQL supports multiple connections to Yellowbrick. If you use multiple simultaneous connections, you must use the alias argument to identify the different connections. If you do not specify an alias, the default YBRICK alias is used.
• The CONNECT statement database-connection-arguments are identical to its LIBNAME connection options.
• To execute UPDATE and DELETE statements in PROC SQL, the DBIDIRECTEXEC system option must be enabled. (This is the default value for this option.)

CONNECT Statement Example for Yellowbrick

This example connects to Yellowbrick and then disconnects from it.

proc sql noerrorstop;
   connect to ybrick as x1(server=mysrv1 port=5432 
      user=mysur1 password='mypwd1' database=mydb1);
disconnect from x1;
quit;