Firebird Documentation IndexFirebird 2.5 Release NotesCommand-line Utilities → isql
Firebird Home Firebird Home Prev: nBackupFirebird Documentation IndexUp: Command-line UtilitiesNext: gpre (Precompiler)

isql

SQLSTATE instead of SQLCODE
Improvement for Exponential Number Output
SHOW COLLATIONS in isql Help
SET ROWCOUNT Statement Added

Some changes to the isql interactive query tool have been implemented.

SQLSTATE instead of SQLCODE

Claudio Valderrama

isql now returns the SQLSTATE completion code in diagnostics, instead of the now deprecated SQLCODE. For more information, see the topic Support for SQLSTATE Completion Codes in the chapter Changes to the Firebird API and ODS.

Improvement for Exponential Number Output

Claudio Valderrama

Tracker reference CORE-1171.

isql has always output different formatting of numbers on Windows and POSIX for two-digit exponents. The default behaviour of Microsoft and Intel compilers is to zero-pad the exponent to three digits regardless. For example,

  select cast ('-2.488355210669293e+39' as double precision)
    from rdb$database;
      
  • On POSIX, the result is -2.488355210669293e+39

  • On Windows, the result was -2.488355210669293e+039

The isql output has been modified so that the Windows output now conforms with that on other platforms.

SHOW COLLATIONS in isql Help

Help for SHOW COLLATIONS has been added to the command-line help for isql. (Tracker reference CORE-2432, A. dos Santos Fernandes).

SET ROWCOUNT Statement Added

Mark O'Donohue

Added mainly to assist testers, this command enables a limit to be set on the number of rows a query returns to the interactive isql shell.

Example of Use

The following isql statement will stop returning rows after the 10,000th row has been output:

  SQL>set rowcount 10000;
      
Prev: nBackupFirebird Documentation IndexUp: Command-line UtilitiesNext: gpre (Precompiler)
Firebird Documentation IndexFirebird 2.5 Release NotesCommand-line Utilities → isql