TRANSACTION ROLLBACK } ::= { ANY DDL STATEMENT | item> [{OR item>} ...] } item> ::= CREATE TABLE | ALTER TABLE | DROP TABLE | CREATE PROCEDURE | ALTER db_event Событие соединения или транзакции. ddl_events Список событий изменения метаданных. ddl_event_item Одно из событий изменения метаданных. Операторы DDL 155 Параметр Описание number Порядок срабатывания OBJECT_TYPE – тип объекта (TABLE, VIEW и д.р.) • DDL_EVENT – имя события (item>), где item> = EVENT_TYPE || ' ' || OBJECT_TYPE • OBJECT_NAME – имя объекта метаданных • OLD_OBJECT_NAME

zone, can be different for each database attachment. It can be set explicitly in the DPB with the item isc_dpb_session_time_zone; otherwise, by default, it uses the same time zone as the operating system Quantifiers A question mark (‘?’) immediately following a character or class indicates that the preceding item may occur 0 or 1 times in order to match: 'Hallon' similar to 'Hal?on' -- false -- true An asterisk (‘*’) immediately following a character or class indicates that the preceding item may occur 0 or more times in order to match: 'Icaque' similar to 'Ica*que' -- true

Quantifiers A question mark (‘?’) immediately following a character or class indicates that the preceding item may occur 0 or 1 times in order to match: 'Hallon' similar to 'Hal?on' -- false -- true An asterisk (‘*’) immediately following a character or class indicates that the preceding item may Chapter 4. Common Language Elements 70 occur 0 or more times in order to match: 'Icaque' similar -- false A plus sign (‘+’) immediately following a character or class indicates that the preceding item must occur 1 or more times in order to match: 'Jujube' similar to 'Ju_+' --

procname [TRANSACTION transaction] [item> [, item> ...]] [RETURNING_VALUES item> [, item> …]] item> ::= [] item> ::= [] ::= выражение отдельности, а не к набору данных в целом. Синтаксис: SELECT ... FROM ... GROUP BY <item> [, <item> ...] … <item> ::= column-name [COLLATE collation-name] | column-alias | column-position | expression таблицах. ORDER BY Синтаксис: SELECT ... FROM ... ... ORDER BY item> [, item> …] item> ::= {col-name | col-alias | col-position | expression} [COLLATE collation-name]

| COMMIT | ROLLBACK} ::= ANY DDL STATEMENT | item> [{OR item>} ...] item> ::= {CREATE | ALTER | DROP} TABLE | {CREATE | ALTER | DROP} PROCEDURE Verbindungs- oder Transaktionsereignis ddl_event Liste der Metadatenänderungsereignisse ddl_event_item Eines der Metadatenänderungsereignisse Die Anweisung CREATE TRIGGER wird verwendet, um einen neuen deklarieren Verfügbar in DSQL Syntax CREATE PACKAGE package_name AS BEGIN [ item> ... ] END item> ::= ; | ; ::= FUNCTION funcname

information of this type available for object specified -901 335544341 infunk Unknown information item -901 335544342 integ_fail Action cancelled by trigger () to preserve data integrity -901 reconnect to a transaction in database -901 335741036 gfix_trn_unknown Transaction description item unknown -901 335741038 gfix_mode_req "read_only" or "read_write" required -901 336068796 dyn_role_does_not_exist 336330772 gbak_blob_info_failed Gds_$blob_info failed -901 336330773 gbak_unk_blob_item Do not understand BLOB INFO item -901 336330774 gbak_get_seg_failed Gds_$get_segment failed -901 336330775

gsec_err_modify Modify record error -901 335544341 infunk Unknown information item -901 336330773 gbak_unk_blob_item Do not understand BLOB INFO item %ld -901 336723989 gsec_err_find_mod Find/modify record error 335544428 badmsgnum Undefined message number -901 335741036 gfix_trn_unknown Transaction description item unknown -901 335741038 gfix_mode_req "read_only" or "read_write" required -901 335544431 blocking_signal is currently in use by another process.Try again later. -902 335544795 unexp_spb_form Unexpected item in service parameter block, expected %s -902 335544809 extern_func_dir_error Function %s is in %s

infunk Unknown information item -901 336723989 gsec_err_find_mod Find/modify record error Firebird 2.1 Error Codes -901 336330773 gbak_unk_blob_item Do not understand BLOB INFO item @1 -901 335544342 integ_fail 335544428 badmsgnum Undefined message number -901 335741036 gfix_trn_unknown Transaction description item unknown -901 335741038 gfix_mode_req "read_only" or "read_write" required -901 335544431 blocking_signal is currently in use by another process.Try again later. -902 335544795 unexp_spb_form Unexpected item in service parameter block, expected @1 -902 335544809 extern_func_dir_error Function @1 is in @2

Expressions involving NULL In SQL, NULL is not a value. It is a condition, or state, of a data item, in which its value is unknown. Because it is unknown, NULL cannot behave like a value. When you try Start 35 Security section: moved last paragraph of the “Protect databases...” lis- titem into a new item on Classic local mode. Connection strings: improved and extended introductory paragraph; added a subsection connection examples. Updated/cor- rected note on the use of quote characters. Edited first “Important” item in “The CREATE DATABASE state- ment”. Updated the warning about concatenation of long strings. Extended

concern, not yours. If you don’t want or need this relaxation, follow the instructions in the next item. Disable embedded connections If you don’t want any type of direct access, you may disable embedded and management 23 Providers = Engine13,Loopback } The first line defines the alias (see next item), and everything between the curly brackets are parameters for that specific database. You’ll find 3. Expressions involving NULL In SQL, NULL is not a value. It is a condition, or state, of a data item, in which its value is unknown. Because it is unknown, NULL cannot behave like a value. When you