. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 264 7.4. PSQL Blocks . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 506 MON$MEMORY_USAGE . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 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 this

. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 350 7.4. PSQL Blocks . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 757 MON$MEMORY_USAGE . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 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 of Firebird

. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 681 MON$MEMORY_USAGE . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . Manipulation-Statements (DML) 328 6.8. EXECUTE BLOCK Verwendet für Erstellen eines "anonymen" Blocks von PSQL-Code in DSQL zur sofortigen Ausführung Verfügbar in DSQL Syntax EXECUTE BLOCK [()] Data Manipulation-Statements (DML) 330 6.8.2. Eingabe- und Ausgabeparameter Die Ausführung eines Blocks ohne Eingabeparameter sollte mit jedem Firebird-Client möglich sein, der es dem Benutzer erlaubt

expressions that contain NULL or may resolve to NULL. If you only need a quick reference to refresh your memory, go to the summary at the end of the guide. So — what is it? In SQL, NULL is not a value. It is NULL — not “true”. As a consequence, inverting the test expression and swapping the THEN and ELSE blocks may change the behaviour of the IF statement. In binary logic, where only true and false can occur statements like above. Also, refactoring by inverting the test expression and swapping the THEN and ELSE blocks will always preserve the functionality, regardless of the complexity of the expressions — as long

Int32 Number of per-message error blocks (message number in batch and status vector of an error processing it) Int32 Number of simplified per-message error blocks (message number in batch without status Number of such pairs is equal to "Number of per-message error blocks" field in packet. Chapter 8. Batches 28 Buffer Simplified error blocks (for each error server sends number of message (Int32) w/o status too many errors took place. Number of elements is equal to "Number of simplified per-message error blocks" field in packet. Otherwise: Generic response 8.4. Release batch Client Int32 Operation code

-219 335544395 relnotdef Table is not defined -239 335544691 cache_too_small Insufficient memory to allocate page buffer cache -260 335544690 cache_redef Cache redefined -281 335544637 no_stream_plan lignment Datatype misalignment. The attempted to read or write a value that was not stored on a memory boundary. -901 335544770 exception_array_bounds_exceeded Array bounds exceeded. The code attempted requirements of the runtime stack have exceeded the memory available to it. -901 335544782 exception_sigsegv Segmentation Fault. The code attempted to access memory without priviledges. -901 335544783 exception_sigill

logb_small Log block too small at offset %ld in log file %s -239 335544691 cache_too_small Insufficient memory to allocate page buffer cache -239 335544693 log_too_small Log size too small -239 335544694 partition_too_small -901 336723998 gsec_op_specified Operation already specified -901 336920607 gstat_sysmemex System memory exhausted -901 336330783 gbak_db_info_failed gds_$database_info failed -901 336723999 gsec_pw_specified Firebird 2.0 Error Codes SQLCODE GDSCODE SYMBOL TEXT -901 335740993 gfix_mem_exhausted Virtual memory exhausted -901 336330818 gbak_open_error Cannot open status and error output file %s -901 335740994

logb_small Log block too small at offset @1 in log file @2 -239 335544691 cache_too_small Insufficient memory to allocate page buffer cache -239 335544693 log_too_small Log size too small -239 335544694 partition_too_small -901 336723998 gsec_op_specified Operation already specified -901 336920607 gstat_sysmemex System memory exhausted -901 336330783 gbak_db_info_failed gds_$database_info failed -901 336723999 gsec_pw_specified maximum size -901 335740992 gfix_corrupt_pool Corrupt pool -901 335740993 gfix_mem_exhausted Virtual memory exhausted -901 336330817 gbak_open_bkup_error Cannot open backup file @1 -901 335740994 gfix_bad_pool

........................................................................................ 696 MON$MEMORY_USAGE .......................................................................................... Класс ошибок HY (условия CLI- specific) HY000 CLI-specific condition Условия CLI-specific HY001 Memory allocation error Ошибка выделения памяти HY003 Invalid data type in application descriptor установлен сейчас HY012 Invalid transaction operation code Неверный код транзакции операции HY013 Memory management error Ошибка управления памятью HY014 Limit on the number of handles exceeded Достигнут

allocated to store (cache) database pages in memory to help improve the efficiency of the database performance. It is far quicker to read data from memory that it is to have to physically read the data Database Write Mode Many operating systems employ a disk cache mechanism. This uses an area of memory (which may be part of your server’s overall RAM or may be built into the disk hardware) to buffer