Contents SAS/IntrNet 9.1: htmSQL Previous Next

Invoking htmSQL

You can invoke htmSQL


From the Web

From your Web browser, you can either use an HTML form or specify a URL to invoke htmSQL.

Creating an HTML form

The HTML form must use the URL for your Web page as the value of the ACTION attribute of the HTML FORM element. You can also use the optional METHOD attribute to specify the CGI method to use for sending form data:

<form action="http://yourserver/dir/executable_file/input-file" [method=get|post]>

On the form, use HTML INPUT elements to collect variable values. For the NAME attribute of the INPUT element, use the same variable names that you use for your variable references. When the form is submitted, the browser automatically generates the query string

var1=value1&var2=value2&...varN=valueN

from the form input and appends it to the URL that is specified by the ACTION attribute (for the GET method) or sends it in the body of the HTTP request (for the POST method).

Note: Some Web servers can be configured to recognize an input file by its file extension and to automatically call the appropriate CGI program to process the file. If your Web server can be configured this way, you can omit the path to htmSQL when you specify the URL (that is, you can omit the dir and executable_file values). Consult your Web server documentation for details on whether and how your server can be so configured.

Specifying a URL for your Web page

Specify the URL either on an existing Web page or on your Web browser command line. A URL for htmSQL must include the pathname for an input file and must be of the form:

http://yourserver/dir/executable_file/input-file[?query-string]

The following example shows a URL that is used to invoke htmSQL:

http://support.sas.com/cgi_bin/htmSQL/empdata.hsql?first=fname&last=lname&middle=mi

Note: Some Web servers can be configured to recognize an input file by its file extension and to automatically call the appropriate CGI program to process the file. If your Web server can be configured this way, you can omit the path to htmSQL when you specify the URL (that is, you can omit the dir and executable_file values). Consult your Web server documentation for details on whether and how your server can be so configured.


From the command line prompt

The output that htmSQL generates is sent to stdout (usually your terminal display). You can capture the generated output by redirecting stdout to a file. Use this method of invocation to test an htmSQL input file or to produce a static page that contains SAS data.

The following is the syntax for the htmSQL command (parameters that are within square brackets ([]) are optional):

htmSQL input-file ["query-string"] [-rc config-file] [-dsf datasrc-file]

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.


Contents SAS/IntrNet 9.1: htmSQL Previous Next