Kbase P22188: SQL tool for unix?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
29/04/2003 |
|
Status: Unverified
GOAL:
Is there a SQL tool for progress on UNIX?
FIX:
Yes, The Progress SQLExplorer is available in character mode on UNIX. To
launch SQLExplorer use the sqlexp command found in $DLC/bin.
Command Syntax and Parameters
Usage: sqlexp [-connectoptions] [-generaloptions]
where connect options include:
-user <user> Optional argument. Default is current user.
-password <passwd> Optional argument. User password.
--- Either ---
-url <url> Mandatory argument. Format is:
jdbc:jdbcprogress:T:<host>:<service|port>:<database>
The -url option may be specified in place of
the -db, -S, and -H options.
----- or -----
-db <database> Mandatory argument. -db option need not preceed
the database specification.
-S <service|port> Mandatory argument. Service name or port number
may be specified as an argument to the -S option.
-H <host> Optional argument. Default is localhost.
where general options include:
-infile <infile> Optional argument. Character mode only.
The SQL Explorer executes the commands in the
input file then terminates.
-outfile <outfile> Optional argument. Character mode only.
Redirects SQL command output from standard
output to named file.
-command <command> Optional argument. Character mode only.
The SQL Explorer executes the specified SQL
command then terminates.
-sqlverbose Optional argument. Character mode only.
Beginning and ending time stamps
are printed along with number of rows and columns
fetched, and the fetch limit.