SAS/IntrNet 9.2: htmSQL

Getting Started Exercises

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 might have other people performing the tasks.
For more htmSQL samples, see your htmSQL administrator for the URL of the samples that are installed with the htmSQL software. The default URL is
```
  http://yourserver/sasweb/IntrNet9/htmSQL/samples.html
```
where yourserver is your Web server host name.

Exercise 1: The Basics

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
```

Exercise 2: Something More Advanced

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
  - node is the node name of the server machine
  - service is the service name that is specified in the TCP/IP SERVICES file in step 2 (which is also the value for the ID= option of the PROC SERVER statement in step 3).
  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.

Top of Page