FirebirdSQL logo

EXIT

EXIT

The exit command will commit any uncommitted work and exit from isql.

QUIT

QUIT

The quit command will roll back any uncommitted work and exit from isql.

BLOBVIEW

BLOBVIEW blob_id

This command is similar to [isql-command-blobdump] above, but only requires the blob id parameter as the BLOB data will be displayed in an editor.

SQL> blobview 85:10;

The contents of the selected BLOB are displayed in an external editor.When the editor is closed, control returns to isql.You cannot use isql while the editor is open.

Note

BLOBVIEW may return an “Invalid transaction handle” error after you close the editor.This is a known bug.To correct the situation, start a transaction manually, with SET TRANSACTION;

EDIT

EDIT [filename]

This command allows you to edit an existing file.This may be a file of SQL commands to be used by the isql input command (see below) or any other text file.The file must, however, already exist.

If no filename is supplied, a history of all your previous commands will be displayed for editing.Please note that when you exit from the editor in this case, the commands left in the buffer at the end of the edit will be executed as a script file.