Using SQL C API to Access SPD Server Tables

Read this section if you do not have Base SAS software on the network client, but you want to access SPD Server tables using SQL query methods. In addition, you must have SPD Server tables available for use somewhere on the network, SPD Server and SPD Server SNET server running, and network client machines capable of running C and C++ programs.

Why Use SQL C API?

You have SPD Server tables available on your network, and one or more of the following is true:
  • You do not have Base SAS software running on the network client to process the data sets.
  • You want to distribute the information across your corporate intranet.
  • The clients on your network are varied. You have UNIX, Windows PCs, and workstations. The clients might have the ability to run C and C++ programs.
  • Your developers are familiar with SQL and C and C++.
SAS Scalable Performance Data (SPD) Server SQL Access Library API Reference contains additional information about SQL C API.