Home

Getting Started

Utilities

Indexing

Omnidex

Development

Tutorials

Quick Links

 

ODXSQL

Commands

Syntax

Options

Example

 

Execute A Previous Command

SAVE HISTORY

SET HISTORY n

 

ODXSQL

Special Characters

USE Files

Commands

HISTORY

A history stack of OdxSQL commands is tracked in an external file. The HISTORY command displays a numbered listing of these commands to the screen.

These commands can be re-executed by typing the command history number, or edited by running the EDIT command with the command history number.

By default, 100 commands are tracked. This number can be changed by using the SET HISTORY n command where n is the number of commands to be tracked. Set this number to 0 to prevent OdxSQL from keeping a command history.

The history list is created in a file named .odxsql_history in the current working directory and remains on the operating system after the OdxSQL session ends. However, it is overwritten with a blank history at the beginning of the next OdxSQL session. To save a particular history listing, use the SAVE HISTORY command to save the history listing to another file before ending the OdxSQL session.

 

Syntax

HISTORY

 

Options

N/A

 

Example

>connect orders.env

>select company, contact from customers where state='co'
...

>pwd
c:\Omnidex\Demodata

>history
1) connect orders.env
2) select company, contact from customers where state='co'
3) pwd

>

Top