. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 255 6.8. EXECUTE BLOCK. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . language. Firebird conforms closely with international standards for SQL, from data type support, data storage structures, referential integrity mechanisms, to data manipulation capabilities and access privileges triggers) only, but in more recent releases they were surfaced in Dynamic SQL as well (see EXECUTE BLOCK). Embedded SQL defines the DSQL subset supported by Firebird gpre, the application which allows

. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 340 6.8. EXECUTE BLOCK. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . language. Firebird conforms closely with international standards for SQL, from data type support, data storage structures, referential integrity mechanisms, to data manipulation capabilities and access privileges triggers) only, but in more recent releases they were surfaced in Dynamic SQL as well (see EXECUTE BLOCK). Embedded SQL defines the DSQL subset supported by Firebird gpre, the application which allows

хранимые процедуры ....................................................................... 319 EXECUTE BLOCK ................................................................................................. и триггерах), но сравнительно недавно они стали также доступны в Динамическом SQL (смотри EXECUTE BLOCK). Встроенный SQL определяет подмножество DSQL, поддерживаемое средством Firebird GPRE. GPRE — пр типа комментариев: блочные и однострочные. Синтаксис: ::= <block comment> | <block comment> ::= Структура языка 27 /*[ …]*/

. . . . . . . . . . . . . . . . . . . . . . . . . . . 328 Inhaltsverzeichnis 6 6.8. EXECUTE BLOCK. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . Trigger) verfügbar, aber in neueren Versionen wurden sie auch in Dynamic SQL aufgetaucht (siehe EXECUTE BLOCK). Embedded SQL definiert die DSQL-Untermenge, die von Firebird gpre unterstützt wird, der Anwendung unterstützt zwei Arten von Kommentaren: block und in-line. Chapter 2. SQL Sprachstruktur 22 Syntax ::= <block comment> | <block comment> ::= /* [

logr_header_small Log record header too small at offset @1 in log file @2 -239 335544496 logb_small Log block too small at offset @1 in log file @2 -239 335544691 cache_too_small Insufficient memory to allocate for output is not specified -901 336986116 fbsvcmgr_info_err Unknown tag (@1) in info_svr_db_info block after isc_svc_query() -901 335740933 gfix_replay_req Replay log pathname required -901 336330757 tag (@1) in isc_svc_query() results -901 335544326 bad_dpb_form Unrecognized database parameter block -901 335740934 gfix_pgbuf_req Number of page buffers for cache required -901 336986118 fbsvcmgr_switch_unknown

Использование алиаса делает недоступным использование полного имени таблицы RETURNING ROWS EXECUTE BLOCK COLLATE в объявлениях переменных и параметров NOT NULL в объявлениях переменных и параметров ASCII_CHAR ASCII_VAL ASIN ATAN ATAN2 AUTONOMOUS BACKUP BIN_AND BIN_OR BIN_NOT BIN_SHL BIN_SHR BIN_XOR BLOCK BREAK CALLER CEIL CEILING CHAR_TO_UUID COALESCE 19 Руководство по языку SQL COLLATION COMMENT модуль, который может быть выполнен на клиенте, вызван из другой ХП, выполнимого блока (executable block) или триггера. Хранимые процедуры, выполнимые блоки и триггера пишутся на процедурном языке SQL (PSQL)

logr_header_small Log record header too small at offset %ld in log file %s -239 335544496 logb_small Log block too small at offset %ld in log file %s -239 335544691 cache_too_small Insufficient memory to allocate gfix_replay_req Replay log pathname required -901 335544326 bad_dpb_form Unrecognized database parameter block -901 336330758 gbak_unknown_device Device type %s not known -901 335740934 gfix_pgbuf_req Number transaction parameter block -901 336330762 gbak_filename_missing Requires both input and output filenames -901 335544331 bad_tpb_form Invalid format for transaction parameter block -901 336330763 gbak_dup_inout_names

parameter block -901 335544328 bad_segstr_handle Invalid BLOB handle -901 335544329 bad_segstr_id Invalid BLOB ID -901 335544330 bad_tpb_content Invalid parameter in transaction parameter block -901 335544331 335544331 bad_tpb_form Invalid format for transaction parameter block -901 335544332 bad_trans_handle Invalid transaction handle (expecting explicit transaction start) -901 335544337 excess_trans Attempt handle -901 335544561 wrospbver Wrong version of service parameter block -901 335544562 bad_spb_form Unrecognized service parameter block -901 335544563 svcnotdef Service is not defined -901 335544609

Similar to the type 5 Data Page, but applies to indexes only. 0x08 Blob Page. Blobs have their own storage within the database. Very large blobs will require a sequence of pages and the type 8 page holds records, it will be stored in full in both. The same applies to fields in the same record — all storage compression is done within each individual field and previously compressed fields have no effect Null The final record inserted into the table is the one with no data, it is NULL. The internal storage is as follows: Data[0005].offset: 3896 Data[0005].length: 22 Data[0005].header

yields NULL if at least one of them is NULL. With a NULL test expression, the THEN block is skipped and the ELSE block executed. • Not equals (‘<>’) if (a <> b) then MyVariable = 'Not equal'; else watch out with inversion using NOT: a condition like while ( Counter > 12 ) do will skip the loop block if Counter is NULL, which is probably what you want, but: while ( not Counter > 12 ) do will also statements and loops 31 for into do block> and they will keep executing the code block until all the rows from the result set have been retrieved, unless an exception