FirebirdSQL logo

SET KEEP_TRAN_params

Added in

Firebird 3.0.6 / 4.0

SET KEEP_TRAN_params [ON | OFF]

This command configures whether isql remembers the transaction configuration of the last SET TRANSACTION and applies it for implicitly started transactions.The default is ON in Firebird 4.0 and higher, and OFF in Firebird 3.0 (introduced in 3.0.6).If no parameter is supplied to the command, it toggles the current state of keep transaction parameters.

When set to ON, isql keeps the complete SQL text of the last successful SET TRANSACTION statement.New transactions are started — when started implicitly — using the same SQL text (instead of the default CONCURRENCY WAIT mode).When set to OFF, isql starts new transactions as usual.The name KEEP_TRAN can be used as a shorthand for KEEP_TRAN_PARAMS.

SET LIST

SET LIST [ON | OFF]

This command controls how the data returned by a select statement is displayed.The default setting is to display the data in tabular form with optional column headings at the top of each 'page'.Setting the list mode to ON results in a different format where each column heading is displayed on the left and the column data on the right.This repeats for each and every row returned by the query.

As with other commands, not providing a value to the command results in a toggle of the current setting.

SQL> set list off;

SQL> select emp_no, first_name, last_name, salary
CON> from employee;

 EMP_NO FIRST_NAME      LAST_NAME                           SALARY
======= =============== ==================== =====================
      2 Robert          Nelson                           105900.00
      4 Bruce           Young                             97500.00
      5 Kim             Lambert                          102750.00
      8 Leslie          Johnson                           64635.00
...

SQL> set list on;

SQL> select emp_no, first_name, last_name, salary
CON> from employee;

EMP_NO                          2
FIRST_NAME                      Robert
LAST_NAME                       Nelson
SALARY                          105900.00

EMP_NO                          4
FIRST_NAME                      Bruce
LAST_NAME                       Young
SALARY                          97500.00
...

SET LOCAL_TIMEOUT

Added in

Firebird 4.0

SET LOCAL_TIMEOUT timeout_value

The SET LOCAL_TIMEOUT configures a one-off statement timeout in milliseconds for the first statement executed after this SET LOCAL_TIMEOUT.

After statement execution, the timeout is automatically reset to zero.

Note

SET LOCAL_TIMEOUT is only available in isql for Firebird 4 or higher, and only when connecting to a Firebird 4 or higher database.

SET NAMES

SET NAMES [character_set]

This command defines the character set of subsequent database connections.If the default database character set is not NONE, then in situations where the client uses a different character set to the database, it is possible to suffer from data corruption as some character sets cannot convert some characters to a suitable character in another character set.

If you don’t pass a character set, the default will be to use the NONE character set.

You can determine a list of the valid character sets to use with the following query:

SQL> set width RDB$CHARACTER_SET_NAME 30;

SQL> select RDB$CHARACTER_SET_NAME
CON> from RDB$CHARACTER_SETS
CON> order by 1;

RDB$CHARACTER_SET_NAME
==============================
ASCII
...
WIN1258