SQL Pass-Through Facility Specifics for SAP ASE

Key Information

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

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

• The dbms-name is SAPASE.
• The CONNECT statement is optional. If you omit the CONNECT statement, an implicit connection is made using the default values for all connection options.
• The interface can connect multiple times to one or more servers.
• The database-connection-arguments for the CONNECT statement are identical to its LIBNAME connection options.
• These LIBNAME options are also available with the CONNECT statement.
  • DBMAX_TEXT=
  • MAX_CONNECTS=
  • READBUFF=
  • PACKETSIZE=

SQL Example for SAP ASE

This example retrieves a subset of rows from the SAP ASE INVOICE table. Because the WHERE clause is specified in the DBMS query (the inner SELECT statement), the DBMS processes the WHERE expression and returns a subset of rows to SAS.

proc sql;
connect to sapase(server=MYSRV1 database=INVENTORY
        user=myusr1 password=mypwd1);
%put &sqlxmsg;

select * from connection to sapase
   (select * from INVOICE where BILLEDBY=457232);
%put &sqlxmsg;

The SELECT statement that is enclosed in parentheses is sent directly to the database and therefore must be specified using valid database variable names and syntax.