Progress
SQL-92
Guide and Reference


Starting SQL Explorer in Character Mode

Use the following syntax to start SQL Explorer from a Windows or a UNIX command line:

SYNTAX
SQLEXP   [-char]
 { -S { service_name | port_number }
  [ -H host_name ] [ -db ] database_name } |  { -url dbURL }

 [ -command command_string ]
 [ -infile input_file ] [ -outfile output_file ]
 [ -user username ] [ -password password ]
 [ -sqlverbose ] [ -help ] 

-char

Starts the character version. The default mode for SQL Explorer is GUI on Windows. On UNIX platforms, the -char option is the default.

-S service_name | port_number

The port number or service name to use for a network connection to a database server on the same machine or on a remote host.

-H host_name

Specifies the name of the remote host on which the database server is running. The default value is “localhost.”

-db database_name

Specifies the physical file name of the database to which you want to connect. The -db argument is optional; you can specify the database name without the argument.

-url dbURL

Identifies the database to which you want to connect. The URL string has the following components:

SYNTAX
jdbc:jdbcprogress:T:host_name:service_name | port_number:database_name 

jdbc:jdbcprogress:T

An identifying subprotocol string for the JDBC Driver.

host_name

The name of the system where the Progress SQL-92 JDBC data source resides.

service_name | port_number

Port number or service name to use for the connection.

database_name

The physical file name of the Progress database.

-command command_string

Specifies a SQL command to execute after startup and before displaying an interactive prompt.

-infile input_file

Specifies a file that contains SQL statements to be executed in batch mode after startup.

-outfile output_file

Specifies a file where SQL Explorer is to write SQL-92 statement output. When this option is omitted SQL-92 statement output is sent to standard output.

-user username

Specifies a username other than the current user login for connecting to the database.

-password password

Specifies the password for connecting to the database when password protection has been established. By default, no password is required.

-sqlverbose

Optionally displays statistics for the process.

-help

Optionally displays SQL Explorer command syntax with help text.


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