ошибок, коды и сообщения 556 Код SQLSTATE Связанное сообщение Примечание SQLCLASS 3D (Invalid Catalog Name) Класс ошибок 3D (неверное имя каталога) 3D000 Invalid catalog name Неверное имя каталога 3D001 (значение 0). MON$RESERVE_SPACE SMALLINT Флаг, указывающий на резервирование пространства. MON$CREATION_DATE TIMESTAMP Дата и время создания базы данных. MON$PAGES BIGINT Количество страниц, выделенных

on-line as PDF books. 1.2.1. Language Reference Updates The Data Definition Guide, covering the creation and maintenance of metadata for databases, was “good enough” for several years: the data definition domain that can take the values 'Yes' and 'No' in the default character set specified during the creation of the database. CREATE DOMAIN D_BOOLEAN AS CHAR(3) CHECK (VALUE IN ('Yes', 'No')); 3. Creating specified, the character set specified during the creation of the database will be used by default. If no character set was specified during the creation of the database, the NONE character set is applied

domain that can take the values 'Yes' and 'No' in the default character set specified during the creation of the database. CREATE DOMAIN D_BOOLEAN AS CHAR(3) CHECK (VALUE IN ('Yes', 'No')); 3. Creating the character set is not specified, the default character set of the database - at time of the creation of the column - will be used. If the database has no default character set, the NONE character sequence is specified, the default collation sequence for the specified character set - at time of the creation of the column - is applied. Setting a DEFAULT Value The optional DEFAULT clause allows you to

3B000 Invalid save point SQLCLASS 3C (Ambiguous Cursor Name) 3C000 Ambiguous cursor name SQLCLASS 3D (Invalid Catalog Name) 3D000 Invalid catalog name 3D001 Catalog name not found Anhang B: Fehlercodes reserve_space (Wert 1) oder use_all_space (Wert 0) zum Füllen der Datenbankseiten verwendet wird. MON$CREATION_DATE TIMESTAMP Datum und Zeit zu der die Datenbank erstellt oder wiederhergestellt wurde. MON$PAGES

forums where the developers hang out. Much hex dumping of database files was undertaken in the creation of this document, but no Firebird databases were harmed during this process. All databases mentioned hdr_oldest_active; SLONG hdr_next_transaction; USHORT hdr_sequence; USHORT hdr_flags; SLONG hdr_creation_date[2]; SLONG hdr_attachment_id; SLONG hdr_shadow_count; SSHORT hdr_implementation; single-user maintenance mode. Only one SYSDBA or database owner connection is permitted. hdr_creation_date Eight bytes, signed. Bytes 0x2c - 0x33 on the page. The date and time (in Firebird’s own internal

a stored procedure or trigger, its value is undefined and its state is NULL from the moment of creation until some value is assigned to it. The same is true for output parameters in stored procedures when a unique index is created the table may not contain any NULLs or duplicate values, or the creation will fail. Once the index is in place, insertion of NULLs or duplicate values is no longer possible 'Amst%' ) ...will reject NULL input in Firebird 1.5, but let it pass in Firebird 2. Existing database creation scripts will have to be carefully examined before being used under Firebird 2. If a domain or column

Firebird user names, passwords are case-sensitive. Adding Firebird user accounts Firebird allows the creation of many different user accounts. Each of them can own databases and also have various types of access statement. • If you run Classic Server on Linux and you don't start the database path with a hostname, creation of the database file is attempted with your Linux login as the owner. This may or may not be what statement on SS thread usage in Classic-vs-Superserver ta- ble. Fixed broken link. 3.0 21 May 2006 PV Creation of 2.0 Quick Start Guide, still equal to previous revision ex- cept for some version numbers, XML

maximum password length to 8 characters. 5.1.2. Adding Firebird user accounts Firebird allows the creation of many different user accounts. Each of them can own databases and also have various types of regular (unquoted) identifier. • If the connection string doesn’t start with a host or protocol name, creation of the database file is attempted with your OS login as the owner. This may or may not be what

connection charset (set names) -d(atabase) database name to put in script creation -e(cho) echo commands (set echo on) -ex(tract) extract The resultant information can be used to view all the changes made to the database since its creation. Before making any more changes, create a new database with identical schema definitions or new

-meta_data The -m[eta_data] switch can be used on either a backup or a restore to facilitate the creation of a clone database (or overwrite an existing one) with no actual data. 6.4. Splitting The Backup