CONDITIONAL CONTAINING CSTRING DATABASE DESC DESCENDING DESCRIPTOR DO DOMAIN ENTRY_POINT EXCEPTION EXIT FILE FREE_IT GEN_ID GENERATOR IF INACTIVE INPUT_TYPE ISOLATION KEY LENGTH LEVEL MANUAL MODULE_NAME NAMES OPTION значение из нескольких возможных. Есть два синтаксических варианта: • Простой CASE, сравнимый с Pascal case или C switch; • Поисковый CASE, который работает как серия операторов “if ... else if ... else [ [, ...]] RETURNS { | PARAMETER 1-based_pos} [FREE_IT] ENTRY_POINT 'function_name' MODULE_NAME 'library_name' ::= sqltype [BY DESCRIPTOR]

которое позволяет вам внедрять SQL конструкции в ваш непосредственный язык программирования (C, C++, Pascal, Cobol и так далее) и производить обработку этих внедрённых конструкций в правильные вызовы Firebird значение из нескольких возможных. Есть два синтаксических варианта: • Простой CASE, сравнимый с Pascal case или C switch; • Поисковый CASE, который работает как серия операторов if ... else if ... else ]] RETURNS { sqltype [BY {DESCRIPTOR | VALUE}] | CSTRING(length) | PARAMETER param_num } [FREE_IT] ENTRY_POINT 'entry_point' MODULE_NAME 'library_name'; ::= sqltype [{BY DESCRIPTOR}

оператора CASE. Оператор CASE используется аналогично оператору switch языка C или оператору case языка Pascal для замены одного значения на другое. Обычно в СУБД Firebird 1.0 эту операцию можно эмулировать хранимой правильность с помощью isql или других утилит. Enterprise Manager IBOConsole Enterprise Manager IBExpert (free/commercial) Enterprise Manager DataBase Workbench (commercial) Import and Export Data - Performance

left-hand side expression is NULL than to evaluate each and every comparison result. But do feel free to skip them, or to skip just the second. Do not, however, skip the first question and start with when then ... [else ] end This one works more or less like a Pascal case or a C switch construct: is compared to , etc., until a match is question, e.g. like this: declare external function ltrim cstring(255) null returns cstring(255) free_it entry_point 'IB_UDF_ltrim' module_name 'ib_udf'; This requirement ensures that existing databases

application which allows you to embed SQL constructs into your host programming language (C, C++, Pascal, Cobol, etc.) and preprocess those embedded constructs into the proper Firebird API calls.  Only ones. Two syntactic variants are supported: • The simple CASE, comparable to a case construct in Pascal or a switch in C • The searched CASE, which works like a series of “if … else if … else if” clauses experience with regular expressions (or with highly formal, rather long top-down definitions). Feel free to skip it and read the next section, Building Regular Expressions, which uses a bottom-up approach

application which allows you to embed SQL constructs into your host programming language (C, C++, Pascal, Cobol, etc.) and preprocess those embedded constructs into the proper Firebird API calls.  Only values. Two syntactic variants are supported: • The simple CASE, comparable to a case construct in Pascal or a switch in C • The searched CASE, which works like a series of “if … else if … else if” clauses experience with regular expressions (or with highly formal, rather long top-down definitions). Feel free to skip it and read the next section, Building Regular Expressions, which uses a bottom-up approach

unterstützt wird, der Anwendung, mit der Sie SQL-Konstrukte in Ihre Host-Programmiersprache (C, C++, Pascal, Cobol usw.) einbetten und diese eingebetteten Konstrukte in die richtigen Firebird-API-Aufrufe syntaktische Varianten werden unterstützt: • Das einfache CASE, vergleichbar zu einem CASE-Konstrukt in Pascal oder einem Switch in C • Das gesuchte CASE, welches wie eine Reihe aus “if … else if … else if”-Klauseln ::= { | PARAMETER param_num } [{ BY VALUE | BY DESCRIPTOR [FREE_IT] | FREE_IT }] Tabelle 46. DECLARE EXTERNAL FUNCTION-Anweisungsparameter Parameter Beschreibung funcname

Inventory Page or PIP (page type 0x02) which details which pages in the database are in use and which are free. Up until Firebird 3.0, the next page is a Write Ahead Log page (page type 0x0a) but this page is The Page Inventory Page (PIP). This page keeps track of allocated and free pages using a bitmap where a 1 means the page is free, and a 0 (zero) shows a used page. There may be more than one PIP in a currently free for use. pip_bits Bytes 0x14 onwards. The remainder of the page, is an array of single bits where each bit represents a page in the database. If the bit is set (1) then that page is free for

Firebird 2.0 and 2.1 Quick Start 4 The Firebird licenses Firebird is a free, open-source database management system, but “free” does not mean that everything is per- mitted. The use of Firebird is governed Project. Both licenses offer similar rights and restrictions. In short: • Use of the software is free, even for commercial purposes. You may also redistribute the software, separately or with a product History 0.0 2002 IBP Published as Chapter One of Using Firebird. 1.0 2003 IBP Published separately as a free Quick Start Guide. 1.x June 2004 IBP Donated to Firebird Project by IBPhoenix. 2.0 27 Aug 2004 PV

. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 15 5.2. Free . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . can only be sent together with a Prepare operation. 5.2. Free Frees resources held by the statement. Client Int32 Operation code (op_free_statement) Int32 Statement handle Int32 Option Description