Consultor Eletrônico



Kbase P89293: How to script the Character version of SQL Explorer
Autor   Progress Software Corporation - Progress
Acesso   Público
Publicação   10/12/2007
Status: Verified

GOAL:

How to script the Character version of SQL Explorer

GOAL:

Where can you get help information for SQL explorer character interface?

GOAL:

How do I get help information for SQL explorer command line interface?


GOAL:

How to get help information on sqlexp?

FIX:

Use the character mode version of the SQL Explorer with the option -infile (and -outfile if you wish to have anything written to a file)

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 ]

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