. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 43 11. Blob Data Page — Type 0x08 — TODO . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . indexes only. 0x07 Index B-Tree Page. 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 number. Increments each time the page is written back to disc. pag_scn Four bytes, unsigned. Bytes 0x08 - 0x0b. Originally used as the sequence number in the Write Ahead Log, but WAL is no longer used.

PROJ_DEPT_BUDGET GROUP BY FISCAL_YEAR, DEPT_NO ) SELECT D.DEPT_NO, D.DEPARTMENT, DYB_2008.BUDGET BUDGET_08, DYB_2009.BUDGET AS BUDGET_09 FROM DEPARTMENT D LEFT JOIN DEPT_YEAR_BUDGET DYB_2008 ON D.DEPT_NO HEAD_DEPT = D.DEPT_NO ) SELECT D.DEPT_NO, D.INDENT || D.DEPARTMENT DEPARTMENT, DYB_2008.BUDGET AS BUDGET_08, DYB_2009.BUDGET AS BUDGET_09 FROM DEPT_TREE D LEFT JOIN DEPT_YEAR_BUDGET DYB_2008 ON (D.DEPT_NO CURRENT_TIMESTAMP FROM RDB$DATABASE -- возвращает, например 2008-08-13 14:20:19.6170 SELECT CURRENT_TIMESTAMP(2) FROM RDB$DATABASE -- возвращает, например 2008-08-13 14:20:23.1200 Примечания: • Точность по умолчанию

group by fiscal_year, dept_no ) select d.dept_no, d.department, dyb_2008.budget as budget_08, dyb_2009.budget as budget_09 from department d left join dept_year_budget dyb_2008 314 SELECT D.DEPT_NO, D.INDENT || D.DEPARTMENT DEPARTMENT, DYB_2008.BUDGET AS BUDGET_08, DYB_2009.BUDGET AS BUDGET_09 FROM DEPT_TREE D LEFT JOIN DEPT_YEAR_BUDGET DYB_2008 ON current_timestamp from rdb$database -- returns e.g. 2008-08-13 14:20:19.6170 select current_timestamp(2) from rdb$database -- returns e.g. 2008-08-13 14:20:23.1200 See also CURRENT_TIME, LOCALTIME, LOCALTIMESTAMP

group by fiscal_year, dept_no ) select d.dept_no, d.department, dyb_2008.budget as budget_08, dyb_2009.budget as budget_09 from department d left join dept_year_budget dyb_2008 DEPT_NO ) SELECT D.DEPT_NO, D.INDENT || D.DEPARTMENT DEPARTMENT, DYB_2008.BUDGET AS BUDGET_08, DYB_2009.BUDGET AS BUDGET_09 FROM DEPT_TREE D LEFT JOIN DEPT_YEAR_BUDGET DYB_2008 ON current_timestamp from rdb$database -- returns e.g. 2008-08-13 14:20:19.6170 select current_timestamp(2) from rdb$database -- returns e.g. 2008-08-13 14:20:23.1200 Notes • The default precision of CURRENT_TIME

group by fiscal_year, dept_no ) select d.dept_no, d.department, dyb_2008.budget as budget_08, dyb_2009.budget as budget_09 from department d left join dept_year_budget dyb_2008 DEPT_NO ) SELECT D.DEPT_NO, D.INDENT || D.DEPARTMENT DEPARTMENT, DYB_2008.BUDGET AS BUDGET_08, DYB_2009.BUDGET AS BUDGET_09 FROM DEPT_TREE D LEFT JOIN DEPT_YEAR_BUDGET DYB_2008 ON current_timestamp from rdb$database -- Ergebnis z.B. 2008-08-13 14:20:19.6170 select current_timestamp(2) from rdb$database -- Ergebnis z.B. 2008-08-13 14:20:23.1200 Siehe auch CURRENT_TIME, LOCALTIME,

GROUP BY FISCAL_YEAR, DEPT_NO ) SELECT D.DEPT_NO, D.DEPARTMENT, DYB_2008.BUDGET BUDGET_08, DYB_2009.BUDGET AS BUDGET_09 FROM DEPARTMENT D LEFT JOIN DEPT_YEAR_BUDGET DYB_2008 ON DEPT_NO ) SELECT D.DEPT_NO, D.INDENT || D.DEPARTMENT DEPARTMENT, DYB_2008.BUDGET AS BUDGET_08, DYB_2009.BUDGET AS BUDGET_09 FROM DEPT_TREE D LEFT JOIN DEPT_YEAR_BUDGET DYB_2008 ON дескрипторов 7009 Invalid descriptor index Неверный индекс дескриптора SQLCLASS 08 (Connection Exception) Класс ошибок 08 (Исключения коннекта) Обработка ошибок, коды и сообщения 551 Код SQLSTATE Связанное

Firebird Datei- und Metadatensicherheit Geoff Worboys;Daniel Albuschat;Martin Köditz Version 0.6-de, 08. Juli 2020 Table of Contents 1. Einleitung . . . . . . . . . . . . . . . . . . . . . . . . . . .

employee.fbk -y employee.log -v tux> ls -l employee.log -rw-r--r-- 1 firebird firebird 21610 2010-08-04 10:22 employee.log tux> gbak -backup employee.fdb employee.fbk -y employee.log -v gbak:cannot open

git repository; see https://github.com/FirebirdSQL/firebird-documentation Revision History 0.2 08 Nov 2023 M R Remove mention that ServerMode is per-database configurable (it’s not) 0.1 07 Nov

• Updated example output of most commands with output of Firebird 4.0 • General copy-editing 0.7 08 May 2021 M R Documented SET LOCAL_TIMEOUT 0.6 20 Jun 2020 M R Conversion to AsciiDoc, minor