SAS Safety Scalable Performance Data Server 4.5 Manual Do Utilizador

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.

(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

(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')

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.

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.