Using the 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 provide your network client machines with the capability of accessing SPD Server tables, using SQL query methods. You must have SPD Server tables available for use, SPD Servers and SPD SNET servers running, and Network client machines capable of running C/C++ programs.

Requirements and Considerations for using the SQL C API

To use the SQL C API, you must have SPD Server tables available on your network. You must also have SPD Servers and SPD SNET Servers running, and network client machines that can run C/C++ programs. If you are working in such an environment, you might want to use the SQL C API if one or more of the following criterion are true:

You do not have Base SAS software 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: UNIX boxes, Windows PCs, workstations. One thing they might have in common is the ability to run C/C++ programs.
Your developers are familiar with SQL and C/C++.

For additional information about SQL C API, see SAS Scalable Performance Data (SPD) Server SQL Access Library API Reference in SAS Scalable Performance Data Server: User's Guide