Firebird 4.0 Language Reference Dmitry Filippov, Alexander Karpeykin, Alexey Kovyazin, Dmitry Kuzmenko, Denis Simonov, Paul Vinkenoog, Dmitry Yemanov, Mark Rotteveel Version 2.10, 15 December 2023 The source of much copied reference material: Paul Vinkenoog Copyright © 2017-2023 Firebird Project and all contributing authors, under the Public Documentation License Version 1.0. Please refer to with the necessary changes. Preface 1 Table of Contents 1. About the Firebird 4.0 Language Reference . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .

Firebird 2.5 Language Reference Dmitry Filippov, Alexander Karpeykin, Alexey Kovyazin, Dmitry Kuzmenko, Denis Simonov, Paul Vinkenoog, Dmitry Yemanov Version 1.16, 15 December 2023 The source of much much copied reference material: Paul Vinkenoog Copyright © 2017-2023 Firebird Project and all contributing authors, under the Public Documentation License Version 1.0. Please refer to the License Notice Russian-speaking community of Firebird developers and users. In 2014, it culminated in a language reference manual, in Russian. At the instigation of Alexey Kovyazin, a campaign was launched amongst Firebird

....................................................................................... 399 ROW_COUNT ................................................................................................. ............................................................................................ 459 COUNT ................................................................................................. ...................................................................................... 472 REGR_COUNT .................................................................................................

. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 41 18.5. SET COUNT. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 75 Table of Contents 3 Chapter 1. Introduction This manual provides reference material for the Firebird Interactive SQL Utility (isql), and instructions on how to use it to BLOBS of subtype or ALL SET BLOB -- turn off BLOB display SET COUNT -- toggle count of selected rows on/off SET MAXROWS [] -- limit select stmt to rows

dialect 3 -104 336003077 sql_db_dialect_dtype_unsupport Database SQL dialect @1 does not support reference to @2 datatype -104 336003087 dsql_invalid_label Label @1 @2 in the current scope -104 336003088 335544591 dsql_tran_err Unknown transaction option -104 335544592 dsql_invalid_array Invalid array reference -104 335544608 command_end_err Unexpected end of command -104 335544612 token_err Token unknown dsql_token_unk_err Token unknown- line @1, column @2 -104 335544709 dsql_agg_ref_err Invalid aggregate reference -104 335544714 invalid_array_id Invalid blob id -104 335544730 cse_not_supported Client/Server

dialect 3 -104 336003077 sql_db_dialect_dtype_unsupport Database SQL dialect %d does not support reference to %s datatype -104 336003087 dsql_invalid_label Label %s %s in the current scope -104 336003088 335544591 dsql_tran_err Unknown transaction option -104 335544592 dsql_invalid_array Invalid array reference -104 335544608 command_end_err Unexpected end of command -104 335544612 token_err Token unknown dsql_token_unk_err Token unknown- line %ld, column %ld -104 335544709 dsql_agg_ref_err Invalid aggregate reference -104 335544714 invalid_array_id Invalid blob id -104 335544730 cse_not_supported Client/Server

335544591 dsql_tran_err Unknown transaction option -104 335544592 dsql_invalid_array Invalid array reference -104 335544608 command_end_err Unexpected end of command -104 335544612 token_err Token unknown Token unknown- line , char -104 335544709 dsql_agg_ref_err Invalid aggregate reference -104 335544714 invalid_array_id Invalid blob id -104 335544730 cse_not_supported Client/Server TIMESTAMP -104 335544796 sql_dialect_datatype_unsupport Client SQL dialect does not support reference to datatype -104 335544798 depend_on_uncommitted_rel You created an indirect dependency

- or owner of the database  The line that starts with 'Unable to perform' above, has had to be split to fit on the page of the PDF file. In reality, it is a single line. However, passing the username are in use if we use gstat as follows: linux> gstat -header my_employee | grep -i shadow Shadow count 2  Sometimes, it takes gstat a while to figure out that there are shadow files for the database active shadows in the output from gstat: linux> gstat -header my_employee | grep -i shadow Shadow count 2 Attributes active shadow, multi-user maintenance  The DBA can set up the database to automatically

Interbase 5.0 which allows the output file from the gbak utility (when backing up a database) to be split into a number of chunks, or a number of chunks to be joined together and used to restore a database required as gbak allows large files to be split directly. The details for gsplit given here are for reference only and you are advised to use gbak to split large backup files even if gsplit is supplied not supplied with the Linux version. Linux doesn’t require a separate utility as it can split files using the split command as well as using gbak.  In testing with Firebird 1.5 and Firebird 2.0 on Windows

CURRENT_TIMESTAMP CURRENT_TRANSACTION CURRENT_USER DELETING GDSCODE INSERTING NEW 'NOW' OLD ROW_COUNT SQLCODE SQLSTATE UPDATING 12. Операторы и предикаты Разрешено использование NULL как операнда внешние функции). Полная документация по Firebird 2.5 SQL включает в себя: • InterBase 6.0 beta SQL Reference (LangRef.pdf и/или SQLRef.html); • Данный документ. Вопросы, не связанные с SQL, не рассматриваются FETCH GLOBAL INSENSITIVE LEADING LOWER 18 Руководство по языку SQL OPEN RECREATE RECURSIVE ROW_COUNT ROWS SAVEPOINT SENSITIVE SIMILAR SQLSTATE (2.5.1) START TRAILING TRIM Новые не зарезервированные