Starting the Small Client Processes

When you start an ESQL small client, ensure that any precompiled r-code files are in the PROPATH of the OID that runs them.

Specifying the Small Client Command

As a minimum, use the startup parameters on the following command line to start a remote ESQL small client with precompiled r-code using TCP/IP:

SYNTAX
client-name -SV -S service-name -H host-name  

client-name

Your ESQL application filename.

service-name and host-name

The name of the OIB (or manually started OID) started for the small client and of the remote host. You define both names in the TCP/IP services and hosts files of the OIB/OID machine.

If your application has precompiled r-code files that are not in the PROPATH of the OID, use the -pp parameter to identify the pathname of the files. You can also specify other common ESQL, OID connection, and database connection parameters that your application requires.

Specifying Databases at Startup

The ESQL small client also specifies the database(s) to which its OID connects and the connection parameters. To specify databases from the command line, you can start a small client as follows:

inventory -db db1 -SV -S sqlsv1 -H db1machine 

In this example, a small client, inventory, accesses the db1.db database through an OID that the OIB, sqlsv1, starts. The OID runs on the database server machine, db1machine, accessing the database directly:

inventory -db db1 -S db1sv -H db1machine -SV -S sqlsv1 -H sqlmachine 

In this example, the OID runs on sqlmachine accessing the database remotely through the database broker/server, db1sv, on db1machine. The small client is started on a third machine, which is why it specifies a host name for both the OIB/OID and the database broker/server. Although not a recommended configuration, this example shows how to start a small client in a three-tier, remote configuration with the small client, OID, and database broker/server running on separate machines in a network.


Copyright © 2004 Progress Software Corporation
www.progress.com
Voice: (781) 280-4000
Fax: (781) 280-4095