Running FedSQL Programs

You can submit FedSQL programs in one of the following ways:
  • From the Base SAS language interface by using the FEDSQL procedure. See Base SAS Procedures Guide.
  • From a JDBC, ODBC, or OLE DB client by using SAS Federation Server. See SAS Federation Server: Administrator’s Guide.
  • From a Base SAS language interface by using SAS Federation Server LIBNAME engine and the PROC SQL pass-through facility. You can specify FedSQL statements in the EXECUTE statement in the same way that you execute DBMS-specific SQL statements. See SAS LIBNAME Engine for SAS Federation Server: User's Guide.
  • From the SPD Server by using the SQL pass-through facility or through an ODBC or JDBC client. See SAS Scalable Performance Data Server: User's Guide