SAS Scalable Performance Data Server 4.5, Administrator'S Manual, Page: 108 / 271

Limitations of Using JDBC with the SPD Server
JDBC Used with SAS Versus JDBC Used with the SPD Server
SPD Server is treated as a foreign database. SPD Server clients can't query the JDBC
metadata class for available tables and other metadata. Users must write their own queries
to do this.
Example JDBC Query for Getting a List of Tables
(JDBC Used with the SPD Server )
SELECT '' AS qual,
LIBNAME AS owner,
MEMNAME AS name,
MEMTYPE AS type,
MEMNAME AS remarks FROM dictionary.tables AS tbl
WHERE ( memtype = 'DATA' OR memtype = 'VIEW' OR memtype = 'SYSTEM TABLE' OR
memtype = 'ALIAS' OR memtype = 'SYNONYM')
AND (tbl.libname NE 'MAPS' AND tbl.libname NE 'SASUSER' AND tbl.libname NE 'SASHELP')
ORDER BY type, qual, owner, name
Example JDBC Query for Getting Metadata about a Specific Table
(Your data file)
SELECT '' AS qual,
LIBNAME AS owner,
MEMNAME AS tname, name,
length AS datatype,
type || ' ',
length AS prec,length,
length AS scale, length AS radix, length AS nullable,label,
FORMAT FROM dictionary.columns AS tbl
WHERE memname = 'your data file'
AND (tbl.libname NE 'MAPS'
AND tbl.libname NE 'SASUSER'
AND tbl.libname NE 'SASHELP')
Using htmSQL to Access SPD Server Tables
Read this section if you do not have Base SAS software on the network client, but you want
to use the point-and-click convenience of a Web page to query SPD Server tables from any
browser-enabled client on the network. You must have SPD Server tables available for use,
htmSQL loaded and configured on a UNIX or Windows operating system, and Scalable
Performance Data Servers and SPD SNET servers running.
Why Would I Want to Use htmSQL?
You might want to use htmSQL if 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 on the network client to process the data sets.
102
Chapter 9 • Using SPD Server With Other Clients