SAS/IntrNet 9.1: htmSQL |
The following exercises illustrate the steps that your organization must follow to install htmSQL and run htmSQL applications. The first exercise requires no data source definition file and does not require that you modify the TCP/IP SERVICES file on your Web server machine.
Notes:
Our exercises assign each step to either the Webmaster or the programmer. However, depending on the way your organization is set up, you may have other people performing the tasks.
Additional htmSQL samples are provided in the samples directory that is created when you install htmSQL.
In the samples directory, we provide an example htmSQL input file (retail1.hsql) that you can modify and use. This exercise shows how to customize and run the example file.
Note: You do not need to save the example htmSQL input file that is shown in this documentation. All of the example files in these exercises are supplied in the samples directory.
Webmaster: Install htmSQL by following the instructions in the README file that is in the download package.
Webmaster: Define your SAS/SHARE server in the TCP/IP SERVICES file on the SAS/SHARE server machine.
Webmaster: Ensure that a SAS/SHARE server is running. The
following SAS commands can be used to start a SAS/SHARE server.
Our exercise uses an example value of shr10
for the server ID; replace shr10
with
the service name that you defined in step 2.
options comamid=tcp; proc server id=shr10; run;
Programmer: Edit the {query}
directive
in the
example input file that is in the samples
directory:
Change sampnode.pc.sas.com
to the IP name
of the SAS/SHARE server machine.
Change 5000
to the port number that is
assigned to the service name that you defined in step 2.
In our exercise, the SAS/SHARE server, shr10
, is running on
sampnode.pc.sas.com
. Service
shr10
is assigned to port 5000.
Programmer: Invoke htmSQL to process the example input file. To run our example from the command line, change to the samples directory and issue the following command:
htmSQL retail1.hsql param=1992
In the samples directory, we also provide two files that demonstrate how to use a data source definition with htmSQL. This example htmSQL input file (retail2.hsql) and example data source definition file (retail.datasrc for UNIX and z/OS and retail.dsf for Windows) perform the same task as the input file in exercise 1 but give you the ability to centralize the definition of your data.
Note: You do not need to save the example htmSQL input file and data source definition file that are shown in this documentation. All of the example files in these exercises are supplied in the samples directory.
Webmaster: Install htmSQL by following the instructions in the README file that is in the download package.
Webmaster: Define your SAS/SHARE server in the TCP/IP SERVICES file on both the SAS/SHARE server machine and on the Web server machine.
Webmaster: Ensure that a SAS/SHARE server is running. The
following SAS commands can be used to start a SAS/SHARE server.
Our exercise uses an example value of shr10
for the server ID; replace shr10
with
the service name that you defined in step 2.
options comamid=tcp; proc server id=shr10; run;
Webmaster: Modify the example data source definition file that is in the samples directory (you can use a text editor to make these changes):
Change sampnode.pc.sas.com
to the IP name
of the SAS/SHARE server machine.
Change all occurrences of sampnode.shr10
to node.service where
In our exercise, the SAS/SHARE server, shr10
, is
running on sampnode.pc.sas.com.
Programmer: Invoke htmSQL to process the example input file. To run our example from the command line, change to the samples directory and issue one of the following commands:
For UNIX and z/OS:
htmSQL retail2.hsql param=1992 -dsf retail.datasrc
For Windows:
htmSQL retail2.hsql param=1992 -dsf retail.dsf
Note: z/OS is the successor to the OS/390 and MVS operating systems. SAS/IntrNet 9.1 for z/OS is supported on the MVS, OS/390, and z/OS operating systems and, throughout this document, any reference to z/OS also applies to OS/390 and MVS, unless otherwise stated.
SAS/IntrNet 9.1: htmSQL |