Much of the information in this manual has been extracted from the Firebird source code — mainly on the ODS related code and headers — and from some (partially out of date) documents on the Research part the standard one. The C code representation of the standard header is: struct pag { SCHAR pag_type; UCHAR pag_flags; USHORT pag_checksum; ULONG pag_generation; ULONG pag_scn; the page header will probably have a new name and function. pag_generation Four bytes, unsigned. Bytes 0x04 - 0x07. The page generation number. Increments each time the page is written back to disc.

том числе при непредвиденных сбоях. СУБД Firebird использует многовер- сионную архитектуру (multi-generation architect, MGA) для создания копии (версии) записи «на месте», если это необходимо (например, при PROCEDURE get_state_name ( state_code char(2) ) RETURNS ( state_name varchar(64) ) AS BEGIN IF (state_code = 'CA') THEN state_name = 'California'; ELSE IF (state_code = 'UT') THEN state_name = 'Utah';

underlying table), the operation was done twice: once executing the view's trigger code and again executing the table's trigger code. This situation caused performance problems or exceptions, particularly if blobs DML operation will take place in that table Known Compatibility Issues 4 Important Some existing code may depend on the assumption that requesting a DML operation on an updatable view with triggers defined to a log table en route to the “real” update. Now, it will be necessary to adjust your view trigger code in order to make the update happen at all. New Reserved Words (Keywords) A number of new reserved

variables. In addition, the above command line has been split over two lines to allow the pdf generation of this manual to work. In reality, the command must be typed on a single line. It is unfortunate variables. In addition, the above command line has been split over two lines to allow the pdf generation of this manual to work. In reality, the command must be typed on a single line.  The spelling stdin create_norman.fdb  The above command line has been split over two lines to allow the pdf generation of this manual to work. In reality, the command must be typed on a single line. If you have a

the Firebird wire protocol. Most of the information was obtained by studying the Firebird source code and implementing the wire protocol in the Firebird .NET provider and Jaybird (Firebird JDBC driver) content depend on the operation that initiated the response. 2.1. Generic response Int32 Operation code If operation equals op_response: Int32 Object handle Int64 Object ID Buffer Data (meaning depends Operation code If operation equals op_sql_response: Int32 Message count Buffer Response data (meaning depends on the operation). 2.3. Fetch response Chapter 2. Responses 4 Int32 Operation code If

. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 355 7.7. Writing the Body Code . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . procedural SQL (PSQL) — for stored procedures, stored functions, triggers, and dynamically-executable code blocks. These are the areas addressed in this volume. This document does not cover configuration statements and PSQL modules. A comment can be any text specified by the code writer, usually used to document how particular parts of the code work. The parser ignores the text of comments. Firebird supports

. . . . . . . . . . . . . . . . . . . . . . . . 269 Table of Contents 6 7.6. Writing the Body Code . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . procedural language — procedural SQL (PSQL) — for stored procedures, triggers and dynamically-executable code blocks. These are the areas addressed in this volume. 1.2. Authorship The material for assembling conglomerate was warmly welcomed. However, it came without rights to existing documentation. Once the code base had been forked by its owners for private, commercial development, it became clear that the

Prozedursprache — procedural SQL (PSQL) — für gespeicherte Prozeduren, Trigger und dynamisch ausführbare Code Blöcke. Dies sind die Themen, die in diesem Dokument behandelt werden. 1.2. Urheberschaft Für die SQL-Anweisungen und PSQL-Modulen vorhanden sein. Ein Kommentar kann ein beliebiger Text sein, der vom Code-Autor angegeben wird und normalerweise verwendet wird, um zu dokumentieren, wie bestimmte Teile des angibt. Normalerweise ist dies nichts anderes als eine Sortierung basierend auf dem numerischen Code der Zeichen und eine grundlegende Zuordnung von Groß- und Kleinbuchstaben. Wenn für Strings ein Verhalten

возможности работы с массивами. Ниже приведён её текст: CREATE OR ALTER PROCEDURE SHOW_LANGS ( CODE VARCHAR(5), GRADE SMALLINT, CTY VARCHAR(15)) RETURNS ( LANGUAGES VARCHAR(15)) AS DECLARE VARIABLE BEGIN I = 1; WHILE (I <= 5) DO BEGIN SELECT LANGUAGE_REQ[:I] FROM JOB WHERE (JOB_CODE = :CODE) AND (JOB_GRADE = :GRADE) AND (JOB_COUNTRY = :CTY) AND (LANGUAGE_REQ IS NOT Пример 4.35. Таблица с полем массивом CREATE TABLE JOB ( JOB_CODE JOBCODE NOT NULL, JOB_GRADE JOBGRADE NOT NULL, JOB_COUNTRY COUNTRYNAME

utility to bail on error, but only when used in a non-interactive mode. The switch returns an error code to the Operating System. This switch was added to prevent isql from executing scripts after an error error has been detected. No further statements will be executed and isql will return an error code to the OS. Users still need to use the -e(cho) switch to echo commands to an output file, to isolate other than a semicolon. To change the terminator character to a tilde (‘~’) enter the following code: SQL> SET TERM ~ ; You must terminate this command with the current terminator of course! Changing