. . . . . . . 36 10. Index B-Tree Page — Type 0x07 — YOU ARE HERE.. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 41 10.1. B-Tree Header . . . . . . . . . . . . 0x06 Index Root Page. Similar to a type 4 Pointer Page, but applies to 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 descending) that the default is ascending. Chapter 9. Index Root Page — Type 0x06 40 Chapter 10. Index B-Tree Page — Type 0x07 — YOU ARE HERE. As described above for the Index Root Page (type 0x06) each index

can also pull them out of a Firebird tar.gz kit. Everything you need is located in the /opt/firebird tree within the buildroot.tar.gz archive that's packed inside the kit. Server configuration and management http://sourceforge.net/projects/firebird/. At that Firebird 2.0 and 2.1 Quick Start 32 site are the source code tree, the download packages and a number of technical files related to the development and testing of the Appendix A: Document History The exact file history is recorded in the manual module in our CVS tree; see http://firebird.cvs.sourceforge.net/ viewvc/firebird/manual/src/docs/firebirddocs/quickstartguide-2

is available in a chapter of its own in the accompanying Release Notes and also in Firebird's CVS tree in /doc/sql.extentions/README.keywords. You must ensure that your DSQL statements and procedure/trigger was packed, since many parts of an embedded setup rely on finding one another within that directory tree. Installing on Windows 27 Registry Any Firebird Registry entries are ignored. The root directory In that case, you need to modify your firebird.conf and set RootDirectory to the Firebird directory tree that is parent to the Firebird files. Example c:\my_app\app.exe c:\my_app\gds32.dll c:\my_app\ib_util

DEPT_NO, SUM(PROJECTED_BUDGET) BUDGET FROM PROJ_DEPT_BUDGET GROUP BY FISCAL_YEAR, DEPT_NO ), DEPT_TREE AS ( SELECT DEPT_NO, HEAD_DEPT, DEPARTMENT, CAST('' AS VARCHAR(255)) AS INDENT FROM DEPARTMENT DEPARTMENT D JOIN DEPT_TREE H ON H.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

project's address there is http://source- forge.net/projects/firebird. At that site are the source code tree, the bug tracker and a number of tech- nical files which can be downloaded for various purposes related Appendix A: Document History The exact file history is recorded in the manual module in our CVS tree; see http://sourceforge.net/ cvs/?group_id=9028 Revision History 0.0 2002 IBP Published as Chapter

also pull them out of a Firebird tar.gz kit. Everything you need is located in the /opt/firebird tree within the buildroot.tar.gz archive that’s packed inside the kit. Chapter 3. Installing Firebird tracker are hosted on GitHub: https://github.com/FirebirdSQL/firebird. At that site are the source code tree, the download packages and a number of technical files related to the development and testing of

Appendix B: Document history The exact file history is recorded in the manual module in our CVS tree; see http://sourceforge.net/cvs/?group_ id=9028 Revision History 0.1 10 Nov 2003 BW First publication

SUM(PROJECTED_BUDGET) BUDGET FROM PROJ_DEPT_BUDGET GROUP BY FISCAL_YEAR, DEPT_NO ), DEPT_TREE AS ( SELECT DEPT_NO, HEAD_DEPT, DEPARTMENT, CAST('' AS VARCHAR(255)) AS JOIN DEPT_TREE H ON H.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

SUM(PROJECTED_BUDGET) BUDGET FROM PROJ_DEPT_BUDGET GROUP BY FISCAL_YEAR, DEPT_NO ), DEPT_TREE AS ( SELECT DEPT_NO, HEAD_DEPT, DEPARTMENT, CAST('' AS VARCHAR(255)) AS JOIN DEPT_TREE H ON H.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 Updated the file history link at the top of this chapter to reflect the migration of the Doc source tree to Github. Typos fixed/updates by M. Rotteveel Dec. 2017/Jan. 2018 • 14.12.2017 psql.xml line 544

fichier. • Si vous utilisez Classic Serveur sous Windows, vous devez specifier un nom d'hôte (qui peut êtree local- host) plus un chemin complet, ou la connexion échouera. Note Bien que les symboles simples