ODXSQL Commands

USE

USE filename [WHERE criteria] [WITH options]

ODXSQL ONLY.

Execute a USE file. Commands in a USE file are executed in order as they appear in the file. Therefore, commands must be in the proper logical order. For example, a connect must occur sometime before a disconnect.

To prevent ODXSQL from halting execution when an error occurs, set the ERRORS set option to CONTINUE either before issuing the USE command or at the beginning of the USE file.

Syntax

USE filename [WHERE criteria] [WITH options]

USE

Required

filename

Required. The filespec of the USE file.

WHERE

Optional. A WHERE clause can instruct ODXSQL to execute only a certain block of commands in the USE file.

WITH options

Optional. This is a comma separated list of valid options.

Example

>USE updates.txt with restore_settings

Options

NOECHO -- Prevents screen display of commands as they are processed.

SILENT -- Executes the use file without displaying output or error messages.

RESTORE_SETTINGS -- Restores the ODXSQL settings when finished processing the use file.

top