Home

Getting Started

Utilities

Indexing

Omnidex

Development

Tutorials

Quick Links

 

sectionpage

ODXSQL - Commands

Syntax

Options

Example

 

ODXSQL

Special Characters

System Commands

Getting Help

Commands

USE

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. A comma separated list of options to apply to this command.

 

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.

 

Example

>USE updates.txt with restore_settings

Top