Progress
SQL-92
Guide and Reference


Running SQL-92 Statements from an Input File

In both the character and Windows versions of SQL Explorer you can run SQL-92 statements from an input file. Comment lines, identified by the line beginning with the pound sign ( # ) or two dashes (- -) are valid in input files.

Character Mode

Executes the file in batch mode. SQL Explorer terminates after executing all the commands in the file. When you run SQL-92 statements from an input file the output displays to standard output. Use the -outfile startup parameter to redirect the output to a named file.

Use the following syntax to connect to a database and execute SQL-92 statements from an input file:

SYNTAX
SQLEXP -char -url jdbc:progress:T:host_name:
  service_name | port_number:database_name -infile input_file 

Windows

Follow the steps to execute SQL statement from an input file:

  1. Choose File Run File from the SQL Explorer menu. The Windows Open File dialog box appears.
  2. Navigate to the directory containing the input file, select the file and click OK. The statement and its results are displayed in the bottom pane.

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