ODXSQL

Special Characters

Continuation Character | Comment Character | Execute Previous Command

Continuation Character

For readability, the \ (back slash) continuation character can be used to continue a single statement on multiple lines. It can be used interactively or in use files.

Select prospects.acct, \
prospects.state \
from prospects \
where prospects.state = 'CA' and \
prospects.acct > 50

Comment Character

The ; (semi-colon) is a comment character that informs OdxSql that the rest of the current line will contain a comment, which is ignored. Directives can also be placed on the same line as a comment character, to control the state of OdxSQL.

The ; character is generally used in USE files but is also supported at the OdxSql command prompt.

; The text on this line is ignored. It is a comment.
; The text on the next line is a directive.
; <common>
...
; <end_common>

top

Execute the Previous Command

To re-execute the last command executed in OdxSql, enter a . (period) at the OdxSql command prompt and hit enter.

The help command is executed, displaying the help text about the Execute Previous Command special character:

>help .

.
Execute last command
Syntax:
< . | command number>

Next the help command is re-executed using the Execute Previous Command special character:

>.

.
Execute last command
Syntax:
< . | command number>

>

Another way to execute a previously executed command is to display a list of previously executed commands from the history file:

>history
1)help connect
2)help .
3)help .

Then enter the line number of the command you want to re-execute:

>2

.
Execute last command
Syntax:
< . | command number>

top