space
Previous Page | Next Page

SAS/IntrNet 9.2: htmSQL

retail2.hsql Sample Input File

*---------------------------------------------------------------
*
*  Notes about this sample htmSQL data source file.
*
*  o  You do not need to save this file from your Web browser. 
*     This file is available in the htmSQL "samples" subdirectory.
*
*  o  This data source definition file specifies one data source 
*     named 'retail'.
*
*  o  The retail data source specifies the SAS/SHARE server 
*     'sampnode.shr10'.
*
*  o  The server name is derived as follows:
*
*     The SAS/SHARE server is running on sampnode.pc.sas.com 
*     (machine name). The id (which is also the TCP/IP service name) 
*     is shr10.  The following job is running on    
*     sampnode.pc.sas.com:
*
*          options comamid=tcp;
*          proc server id=shr10;  
*          run;
*
*  o  A data source definition file can include one or more 
*     libraries. However, because the library we are using, 
*     SASHELP, is already predefined to the server, you do 
*     not need to define it in the data source file.  
*
*  o  Note that the 'retail' data source is referenced in
*     the associated 'retail.hsql' file.  Similarly, the 'sashelp'
*     library is also referenced in 'retail.hsql'.
*
*---------------------------------------------------------------


* --------------------------------------------------------------
*  Identify Data Sources
*
*  In this example, the data source is named 'retail'.
*
* --------------------------------------------------------------

Data Source Name:retail=sas

* --------------------------------------------------------------
* Define Method
* --------------------------------------------------------------

Method tcp:COMMEXE=wqetcp
Methods:tcp=

* --------------------------------------------------------------
* Define Server
*
* In this example, the server is called 'sampnode.shr10'.
*
* --------------------------------------------------------------

Server sampnode.shr10:AM=tcp
Server sampnode.shr10:SASSHARE=yes
Server sampnode.shr10:Server Version=6
Server sampnode.shr10:ServerAddress=sampnode.pc.sas.com
Server sampnode.shr10:TraceFlags=0
Servers:sampnode.shr10=

* --------------------------------------------------------------
* Define Data Sources
*
* In this example, the data source is named 'retail'.
* Note that this data source is identified under the
* 'Identify Data Sources' section of this file.
*
* --------------------------------------------------------------

retail:Description=Retail Data Source
retail:Server=sampnode.shr10
retail:UndoRequired=y

Previous Page | Next Page | Top of Page