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

org документ доступен по адресу https://www.firebirdsql.org/ file/documentation/reference_manuals/firebird-language-reference-30-rus.pdf Кроме того, данный документ выложен в различных форматах на сайте Значение NULL не допустимо 22005 Error in assignment Ошибка присваивания 22006 Null value in field reference Значение NULL в поле ссылки 22007 Invalid datetime format Неверный формат даты/времени 22008 Datetime time zone displacement value Неверная временная зона, неверное значение 2200A Null value in reference target Значение NULL в целевой ссылке 2200B Escape character conflict Конфликт символа управления

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

внешние функции). Полная документация по Firebird 2.5 SQL включает в себя: • InterBase 6.0 beta SQL Reference (LangRef.pdf и/или SQLRef.html); • Данный документ. Вопросы, не связанные с SQL, не рассматриваются использовать его умолчательное значение. Это было введено ещё в InterBase 6, но в его Language Reference упоминается только контекстная переменная USER. Пример: CREATE DOMAIN DDATE AS DATE DEFAULT домена возможно с помощью предложения TO. Введено в InterBase 6, но не описано в его Language Reference. Пример: ALTER DOMAIN DDATE TO D_DATE • Предложение TO может использоваться совместно с другими

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

gemischt werden, die nur eine Datei hinzufügen. Die Anweisung wurde in der alten InterBase 6 Language Reference falsch dokumentiert. Chapter 5. Anweisungen der Datendefinitionssprache (DDL) 99 Tabelle 21. Zeichen ist als Abschlusszeichen für PSQL- Anweisungen gültig.  In der Firebird 2.5 Language Reference wurde die Deklaration lokaler Variablen und Cursor als Teil des Modulheaders betrachtet. Mit der 22006 Null value in field reference 22007 Invalid datetime format 22008 Datetime field overflow 22009 Invalid time zone displacement value 2200A Null value in reference target 2200B Escape character

. . . . . . . . . . . 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 the full syntax of CREATE DATABASE, refer to the Language Reference of your Firebird version. For example, the Firebird 4.0 Language Reference section on CREATE DATABASE.  In the CREATE DATABASE statement transactions is beyond the scope of this manual. For more information see the Firebird Language Reference for your Firebird version, or The Firebird Book by Helen Borrie. 18.23. SET WARNINGS or SET WNG

companion volume, the Firebird Reference Guide. Both books ship on the IBPhoenix CD as e-books in PDF format. They are fully cross-referenced. • Read the Firebird Reference Guide, chapter 10: Resources Fire- bird information. Using the books by IBPhoenix Publications Using Firebird and the Firebird Reference Guide have been designed for easy use and access during your development work. A button at the top and your network, refer to the early chapters of Using Firebird. Chapter 7 is a troubleshooting reference. The ensuing chapters deal in turn with design, lan- guage and development issues and provided detailed