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