IBConsole Documentation Roadmap
Go Up to IBConsole
This is a guide to the online documentation resources available in InterBase XE7.
InterBase Books Online
You can access the full InterBase XE7 documentation set online. All six books are available as Adobe Acrobat PDF documents in a subdirectory of your InterBase installation location.
| Book | Description |
|---|---|
| API Guide | The API Guide provides information on developing InterBase applications using the InterBase API interface; programming with the InterBase API; working with databases, transactions, dynamic SQL, blob data, arrays, conversions, and service; installing/licensing APIs; exporting XML; handling error conditions; and the InterBase API function reference. |
| Data Definition | The Data Definition Guide covers how to design and build InterBase databases including: specifying data types; working with domains, tables, and indexes; working with procedures, triggers, and generators; encrypting databases and columns; and character sets and collation orders. |
| Developer's Guide | The Developer’s Guide includes information on how to develop InterBase database applications using Embarcadero development tools, JDBC, and ODBC including: connecting to databases; understanding datasets; working with tables, queries, stored procedures, cached updated and events; working with UDF and Blob filters; importing and exporting data; working with InterBase Services; and writing install wizards. |
| Embeded SQL | The Embedded SQL Guide gives instructions on developing InterBase applications using embedded SQL including: application requirements, working with databases, transactions, data definition statements, data, dates and times, arrays, stored procedures and events; error handling; dynamic SQL; and preprocessing, compiling, and linking. |
| Language Reference | The Language Reference Guide discusses each of the InterBase elements including: the SQL statement and function reference; procedures and triggers; keywords; error codes and messages; system tables, temporary tables, and views; and character sets and collation orders. |
| Operations Guide | The Operations Guide gives detailed instructions on working with InterBase databases including: using IBConsole; configuring and operating the InterBase server; network configuration; performing backups and restores; using journaling and journal archiving; database security; and interactive queries. |
When the Version 5.x client in this kit runs against a 5.0 InterBase server, all InterBase 5.0 features are available. When this client runs against the InterBase 4.2.x server or any other pre-5.0 server, it must not reference features any of the 5.0 features, including:
- SQL Roles (CREATE ROLE, GRANT ROLE TO, and GRANT TO ROLE)
- Cascaded declarative referential integrity (ON UPDATE and ON DELETE)
- References to isc_lock_print, iblockpr, or gstat command-line utilities
In addition, you cannot back up a 5.0 database and restore it as a 4.2.x database. Only backups created from 4.2.x databases can be restored as 4.2.x databases.
InterBase Tools
You can use Windows Help to view documentation for using the graphical InterBase tools.
| Tool | Description |
|---|---|
| Windows ISQL | Query and database definition tool. |
| Server Manager | Database and server configuration and maintenance environment. |
| ComDiag | Communication diagnostics tool. |
InterBase Tutorials
Introductory lessons in using InterBase to create databases are available in Windows Help format.
| Tutorial | Description |
|---|---|
| Introduction | Concepts and definitions of database objects. |
| Database design | Designing database structure before you start creating metadata. |
| Database creation | Creating and deleting databases. |
| Data Definition | Using the Windows ISQL tool to create your database metadata. |
| Glossary | Glossary of terms. |