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

. . . . . . . . . . . . . . . . . . . . . 9 4.2.5. Deleting stored procedure and trigger source code . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 9 5. Embedded Firebird Server procedure and trigger source code When you write and define a stored procedure or trigger for a Firebird database, the server stores an almost complete copy of the procedure source code along with a “compiled” is executed by the server, the source code is not used. Some developers attempt to protect at least some of their database metadata by deleting the source code from the database before distributing

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 header. Various page types have an additional header that follows on from the standard one. The C code representation of the standard header is: struct pag { SCHAR pag_type; UCHAR pag_flags; and so on. If the database is multi-file, then each file will have a header page of its own. The C code representation of the database header page is: struct header_page { pag hdr_header; USHORT

or false, never NULL or something else. With earlier Firebird versions, you have to write special code to obtain the same information. This will be discussed later. 2.5. The NULL literal The ability SKIP This new Firebird 2 directive returns an empty set if any argument is NULL: • ROWS In new code, use ROWS, not FIRST and SKIP. Chapter 4. Internal functions and directives 13 Chapter 5. Predicates statements about objects that return a boolean result: true, false or unknown (= NULL). In computer code you typically find predicates in places where a yes/no type of decision has to be taken. For Firebird

defined -204 335544511 prcnotdef Procedure is not defined -204 335544515 codnotdef Status code unknown -204 335544516 xcpnotdef Exception not defined -204 335544532 ref_cnstrnt_notfound the execution of a blob filter. -901 335544768 exception_access_violation Access violation. The code attempted to access a virtual address without privilege to do so. -901 335544769 exception_datatype_missalignment on a memory boundary. -901 335544770 exception_array_bounds_exceeded Array bounds exceeded. The code attempted to access an array element that is out of bounds. -901 335544771 exception_float_denormal_operand