SAS/IntrNet htmSQL

htmSQL Data Sources Drill-Down Sample Setup

1. Use the dsdef utility (in the /sasweb/IntrNet9/tools directory under the Web server root document directory) to define a data source called htmSQL that specifies your SAS/SHARE server. Your dsdef session might look like:

   C:\> dsdef -config C:\InetPub\scripts\htmSQL.dsf (Windows)
> dsdef -config /<Web-server-root>/cgi-bin/htmSQL.datasrc (UNIX)
Configure data sources for htmSQL
=================================

Use this program to create or modify the definition of one or more data
sources for htmSQL.

A data source specifies exactly one SAS/SHARE server and may also specify
one or more SAS data libraries or an external DBMS to be accessed through
the server.

Data source names can be any length and can contain any character except a
double quote ("), colon (:), or equals sign (=). They are case-sensitive
and must be entered in an htmSQL input file exactly as they are defined.

In the dialog that follows, default or previously specified values are shown
in square brackets ([]); to accept such a value, press return or enter.
The only required values in a data source definition are the data source
name and server name. You can omit all other values by pressing return or
enter when you are prompted for them.

When you have finished defining data sources, you can save your changes
by pressing return or enter at the 'Enter a Data Source Name' prompt.
You can cancel your changes by entering a 'c' instead.


Enter a Data Source Name to configure: htmSQL

Enter information for: htmSQL

Description: htmSQL samples
SAS/SHARE server name (host.service): shortname.5002
Require SAS SQL processor to undo partial updates? (usually NO): [enter]
DBMS to pass SQL to (omit for SAS data): [enter]
Options to pass when connecting to DBMS: [enter]

Enter information for: Server shortname.5002

SAS/SHARE server host IP name (fully qualified) or address [shortname]: full.server.name.com
Userid for SAS/SHARE server host: [enter]
Password for specified userid: [enter]
SAS/SHARE server user access password: [enter]

Enter a library in data source "htmSQL" to configure: [enter]

Enter a Data Source Name to configure: [enter]



2. Edit the htmSQL.cfg file in your cgi-bin or scripts directory. Uncomment the DATASRCFILE directive and verify that it points to the data source file you created above.

3. Copy the datasrc.sas from the /sasweb/IntrNet9/htmSQL/data_sources directory on your Web server to a working directory on your SAS/SHARE server system.

4. Your htmSQL data source definition (htmSQL.dsf or htmSQL.datasrc) must be visible to or copied to your SAS/SHARE server system. Customize the INFILE statement in the datasrc.sas program to point to the htmSQL data source definition file.

5. Start a SAS session and run the datasrc.sas program to create a DATA step view of your htmSQL data source definition file:

   %inc '<your-working-directory>/datasrc.sas';

6. Define the SAS library that contains the new DATA step view to a SAS/SHARE server using the libref htmSQL. You can test this in an interactive SAS session by submitting:

   libname htmSQL '!SASROOT\intrnet\sample'; (Windows)
libname htmSQL '!SASROOT/samples/intrnet'; (UNIX)
proc server id=__5002 authenticate=optional;
run

   where 5002 is the TCP port to be used by the SAS/SHARE server. Be sure that the port you choose is not in use by another application on your system.

7. Try out the Show Data Sources sample.