Table Of Contents
From InterBase
- About InterBase
- What's New in InterBase 2020
- What's New in InterBase 2020 Update 1
- What's New in InterBase 2020 Update 2
- What's New in InterBase 2020 Update 3
- What's New in InterBase 2020 Update 4
- Release Notes for InterBase 2020
- Release Notes for InterBase 2020 Update 1
- Release Notes for InterBase 2020 Update 2
- Release Notes for InterBase 2020 Update 3
- Release Notes for InterBase 2020 Update 4
- InterBase Editions
- Installation, Registration, and Licensing Information
- User Guides
- Operations Guide
- Introduction to Operations
- Licensing (Operations Guide)
- Server Configuration
- Configuring Server Properties
- Multi-Instance
- SMP Support
- Hyper-threading Support on Intel Processors
- Using InterBase Manager to Start and Stop InterBase
- Starting and Stopping the InterBase Server on UNIX
- The Attachment Governor
- Using Environment Variables
- Managing Temporary Files
- Configuring Parameters in ibconfig
- Viewing the Server Log File
- Network Configuration
- Database User Management
- Security Model
- The InterBase Security Database
- Implementing Stronger Password Protection
- Enabling Embedded User Authentication
- System Table Security
- SQL Privileges
- Groups of Users
- Other Security Measures
- User Administration with IBConsole
- User Administration With the InterBase API
- Using gsec to Manage Security
- Using gsec to Manage Database Alias
- gsec Error Messages
- Database Configuration and Maintenance
- Database Files
- On-disk Structure (ODS)
- Read-write and Read-only Databases
- Creating Databases
- Dropping Databases
- Backup File Properties
- Removing Database Backup Files
- Shadowing
- Setting Database Properties
- Sweep Interval and Automated Housekeeping
- Configuring the Database Cache
- Forced Writes vs. Buffered Writes
- Validation and Repair
- Shutting Down and Restarting Databases
- Limbo Transactions
- Viewing the Administration Log
- gfix Command-line Tool
- gfix Error Messages
- gfix Fixing a database
- Database Backup and Restore
- About InterBase backup and restore options
- Performing backups and restores using the gbak command
- Performing backups and restores using IBConsole
- Journaling and Disaster Recovery
- Database Statistics and Connection Monitoring
- Interactive Query
- Managing isql Temporary Files
- Executing SQL Statements
- Using Batch Updates to Submit Multiple Statements
- Inspecting Database Objects
- Command-line isql Tool
- isql Command Reference
- BLOBDUMP
- EDIT
- EXIT
- HELP
- INPUT
- OUTPUT
- QUIT
- SET TERM
- SET AUTODDL
- SET BLOBDISPLAY
- SET COUNT
- SET ECHO
- SET LIST
- SET NAMES
- SET PLAN
- SET STATS
- SET TIME
- SHELL
- SHOW CHECK
- SHOW DATABASE
- SHOW DOMAINS
- SHOW EXCEPTIONS
- SHOW FILTERS
- SHOW FUNCTIONS
- SHOW GENERATORS
- SHOW GRANT
- SHOW INDEX
- SHOW PROCEDURES
- SHOW ROLES
- SHOW SYSTEM
- SHOW TABLES
- SHOW TRIGGERS
- SHOW VERSION
- SHOW VIEWS
- Using SQL Scripts
- Database and Server Performance
- Migrating to InterBase
- Migration Process
- Migration Issues
- Setting SQL Dialects
- Features and Dialects
- Migrating Servers and Databases
- Migrating Databases to Dialect 3
- Migrating Clients
- Migrating Data from Other DBMS Products
- InterBase Limits
- Data Definition Guide
- Using the Data Definition Guide
- Designing Databases
- Overview of Design Issues
- Design Framework
- Analyzing Requirements
- Collecting and Analyzing Data
- Identifying Entities and Attributes
- Designing Tables
- Determining Unique Attributes (Designing Databases)
- Developing a Set of Rules (Designing Databases)
- Establishing Relationships between Objects
- Planning Security (Designing Databases)
- Naming Objects
- Creating Databases
- Specifying Data Types
- Working with Domains
- Working with Tables
- Working with Indexes
- Working with Views
- Working with Change Views
- Working with Stored Procedures
- Overview of Stored Procedures
- Working with Procedures
- Creating Procedures
- CREATE PROCEDURE syntax
- Procedure and Trigger Language
- The Procedure Header
- The Procedure Body
- BEGIN ... END statements
- Using Variables
- Using Assignment Statements
- Using SELECT Statements
- Using FOR SELECT … DO Statements
- Using WHILE … DO Statements
- Using IF … THEN … ELSE Statements
- Using Event Alerters
- Adding Comments
- Creating Nested and Recursive Procedures
- Using SUSPEND, EXIT, and END With Procedures
- Altering and Dropping Stored Procedures
- Using Stored Procedures
- Stored Procedure Exceptions
- Handling Errors
- Working with Triggers
- Working with Generators
- Planning Security
- Overview of SQL Access Privileges
- Granting Privileges
- Multiple Privileges and Multiple Grantees
- Using Roles to Grant Privileges
- Granting Users the Right to Grant Privileges
- Granting Privileges to Execute Stored Procedures
- Granting Access to Views
- Revoking User Access
- Using Views to Restrict Data Access
- Encrypting Your Data
- About InterBase Encryption
- Using isql to Enable and Implement Encryption
- Encrypting a Database with IBConsole
- Encrypting Backup Files
- Character Sets and Collation Orders
- Developer's Guide
- Using the InterBase Developer’s Guide
- Client/Server Concepts
- Programming Applications with Delphi or C++Builder
- Programming with JDBC
- Installing InterClient Classes into JBuilder
- Programming with InterClient
- Developing InterClient Programs
- Troubleshooting InterClient Programs
- Deploying InterClient Programs
- InterClient/JDBC Compliance Specifications
- InterClient Extensions to the JDBC API
- JDBC Features Not Implemented in InterClient
- InterClient Implementation of JDBC Features
- InterBase Features Not Available through InterClient or JDBC
- Java SQL Data Type Support
- SQL-to-Java Type Conversions
- Java-to-SQL Type Conversion
- InterClient Class References
- InterClient Data Source Properties for InterBase
- InterClient Scrollability
- Batch Updates
- Implementation of Blob, Clob, and Other Related API's
- Programming Applications with ODBC
- Working with UDFs and Blob Filters
- Designing Database Applications
- Building Multi-tiered Applications
- Introduction to IBX
- Connecting to Databases
- Importing and Exporting Data
- Working with InterBase Services
- Overview of the InterBase Service Components
- Setting Database Properties Using InterBase Services
- Bringing a Database Online
- Shutting Down a Database Using InterBase Services
- Setting the Sweep Interval Using InterBase Services
- Setting the Async Mode
- Setting the Page Buffers
- Setting the Access Mode
- Setting the Database Reserve Space
- Activating the Database Shadow
- Adding and Removing Journal Files
- Backing up and Restoring Databases
- Performing Database Maintenance
- Requesting Database and Server Status Reports
- Using the Log Service
- Configuring Users
- Displaying Server Properties
- Programming with Database Events
- Working with Cached Updates
- Deciding When to Use Cached Updates
- Using Cached Updates
- Using Update Objects to Update a Dataset
- Updating a Read-only Dataset
- Controlling the Update Process
- Handling Cached Update Errors
- Understanding Datasets
- Working with Queries
- Queries for desktop developers
- Queries for server developers
- When to use TIBDataSet, TIBQuery, and TIBSQL
- Using a query component: an overview
- Specifying the SQL statement to execute
- Setting parameters
- Executing a query
- Preparing a query
- Unpreparing a query to release resources
- Improving query performance
- Working with result sets
- Working with Tables
- Using table components
- Setting up a table component
- Controlling read/write access to a table
- Searching for records
- Sorting records
- Specifying fields with IndexFieldNames
- Working with a subset of data
- Deleting all records in a table
- Deleting a table
- Renaming a table
- Creating a table
- Synchronizing tables linked to the same database table
- Creating master/detail forms
- Working with Stored Procedures
- Debugging with SQL Monitor
- Writing Installation Wizards
- API Guide
- Using the API Guide
- Application Requirements
- Programming with the InterBase API
- Working with Databases
- Working with Transactions
- Working with Dynamic SQL
- Overview of the DSQL Programming Process
- DSQL API Limitations
- Writing an API Application to Process SQL Statements
- Understanding the XSQLDA
- Change View API Support (API Guide)
- DSQL Programming Methods
- Determining an Unknown Statement Type at Runtime
- Working with Blob Data
- What is a Blob?
- Blob Descriptors
- Populating a Blob Descriptor
- Blob Data Operations
- Requesting Information About an Open Blob
- Filtering Blob Data
- Working with Array Data
- Introduction to Arrays
- Accessing Array Data
- Reading Data from an Array
- Creating the SELECT Statement to Read from an Array
- Preparing the Output XSQLDA to Read Data from an Array
- Preparing the SELECT Statement to Read Data from an Array for Execution
- Executing the Statement to Read Data from an Array
- Populating the Array Descriptor
- Fetching Array Data from Selected Rows
- Reading and Processing the Array Data
- Writing Data to an Array
- Deleting an Array
- Reading Data from an Array
- Working with Conversions
- Handling Error Conditions
- Working with Events
- Working with Services
- Overview of the Services API
- Invoking Service Tasks with isc_service_start( )
- Using Request Buffers
- Overview of Task Identifiers
- Generic Services API Parameters
- Backing Up and Restoring Databases Using isc_action_svc_backup
- Dumping Databases
- Journal Archives
- Setting Database Properties Using the Services API
- Invoking Database Maintenance Using the Services API
- Requesting Database and Server Status Reports Using the Services API
- Configuring Users Using the Services API
- Administering Software Activation Certificates
- Querying the Services Manager
- Using the Services API with RAD Studio
- Exporting XML
- API Function Reference
- Function Categories
- Using Function Definitions
- Alphabetic Function List
- isc_rollback_transaction()
- isc_start_multiple()
- isc_install_execute()
- isc_install_set_option()
- isc_blob_gen_bpb2()
- isc_dsql_fetch()
- isc_decode_sql_date()
- isc_service_query()
- isc_open_blob2()
- isc_get_client_major_version()
- isc_dsql_allocate_statement()
- isc_install_precheck()
- isc_blob_default_desc()
- isc_dsql_free_statement()
- isc_license_remove()
- isc_add_user()
- isc_service_start()
- isc_que_events()
- isc_drop_database()
- isc_dsql_xml_fetch_all()
- isc_blob_lookup_desc2()
- isc_uninstall_precheck()
- isc_blob_lookup_desc()
- isc_blob_gen_bpb()
- isc_cancel_events()
- isc_dsql_describe_bind()
- isc_dsql_xml_fetch()
- Isc_dsql_batch_execute_immed
- isc_encode_sql_date()
- isc_dsql_execute()
- isc_install_load_external_text()
- isc_start_transaction()
- isc_rollback_retaining()
- isc_expand_dpb()
- isc_dsql_set_cursor_name()
- isc_array_set_desc2()
- isc_interprete()
- isc_array_lookup_bounds()
- isc_portable_integer()
- isc_transaction_info()
- isc_database_info()
- isc_create_blob2()
- isc_dsql_xml_buffer_fetch()
- isc_array_get_slice()
- isc_version()
- isc_encode_timestamp()
- isc_prepare_transaction2()
- isc_wait_for_event()
- isc_uninstall_execute()
- isc_dsql_execute2()
- isc_install_get_info()
- isc_sqlcode()
- isc_print_status()
- isc_sql_interprete()
- isc_print_sqlerror()
- isc_license_display()
- isc_blob_default_desc2()
- isc_array_put_slice2()
- isc_encode_sql_time()
- isc_delete_user()
- isc_get_segment()
- isc_license_check()
- isc_cancel_blob()
- isc_decode_sql_time()
- isc_array_lookup_desc()
- isc_array_get_slice2()
- isc_dsql_describe()
- isc_dsql_prepare()
- isc_array_put_slice()
- isc_install_unset_option()
- isc_dsql_batch_execute()
- isc_decode_timestamp()
- isc_array_lookup_bounds2()
- isc_get_client_version()
- isc_install_get_message()
- isc_close_blob()
- isc_get_client_minor_version()
- isc_vax_integer()
- isc_blob_set_desc()
- isc_detach_database()
- isc_event_block()
- isc_service_attach()
- isc_prepare_transaction()
- isc_modify_user()
- isc_array_set_desc()
- isc_commit_retaining()
- isc_attach_database()
- isc_license_get_msg()
- isc_blob_info()
- isc_commit_transaction()
- isc_dsql_exec_immed2()
- isc_service_detach()
- isc_dsql_execute_immediate()
- isc_license_add()
- isc_blob_set_desc2()
- isc_array_lookup_desc2()
- isc_dsql_alloc_statement2()
- isc_install_clear_options()
- isc_event_counts()
- isc_put_segment()
- isc_dsql_sql_info()
- isc_create_database()
- Embedded SQL Guide
- Using the Embedded SQL Guide
- Application Requirements
- Working with Databases
- Working with Transactions
- Starting the Default Transaction
- Starting a Named Transaction
- Naming Transactions
- Specifying SET TRANSACTION Behavior
- Access Mode
- Isolation Level
- Comparing SNAPSHOT, READ COMMITTED, and SNAPSHOT TABLE STABILITY
- Choosing Between SNAPSHOT and READ COMMITTED
- Starting a Transaction with SNAPSHOT Isolation Level
- Starting a transaction with READ COMMITTED isolation level
- Starting a transaction with SNAPSHOT TABLE STABILITY isolation level
- Isolation level interactions
- Lock Resolution
- RESERVING Clause
- USING Clause
- Using Transaction Names in Data Statements
- Ending a Transaction
- Working with Multiple Transactions
- Working with Multiple Transactions in DSQL
- Working with Data Definition Statements
- Working with Data
- Supported Data Types
- Understanding SQL Expressions
- Understanding Data Retrieval with SELECT
- Listing Columns to Retrieve with SELECT
- Specifying Transaction Names When Using Select
- Specifying Host Variables with INTO
- Listing Tables to Search with FROM
- Restricting Row Retrieval with WHERE
- Sorting Rows with ORDER BY
- Grouping Rows with GROUP BY
- Restricting Grouped Rows with HAVING
- Limiting Result Sets with ROWS
- Appending Tables with UNION
- Specifying a Query Plan with PLAN
- Selecting a Single Row
- Selecting Multiple Rows
- Selecting Multiple Rows in DSQL
- Joining Tables
- Using Subqueries
- Inserting Data
- Updating Data
- Deleting Data
- Working with Dates and Times
- Querying the Database for Current Date and Time Information
- Selecting Dates and Times
- Formatting Dates for Input
- Inserting Dates and Times
- Updating Dates and Times
- Using CAST( ) to Convert Dates and Times
- Using Date Literals
- Adding and Subtracting Date and Time Data Types
- Comparing Dates and Times
- Using Date and Time Data Types with Aggregate Functions
- Working with Blob Data
- Using Arrays
- Working with Stored Procedures
- Working with Events
- Error Handling and Recovery
- Using Dynamic SQL
- Overview of the DSQL Programming Process
- DSQL Limitations
- Writing a DSQL Application
- Understanding the XSQLDA
- XSQLDA Field Descriptions (Embedded SQL Guide)
- XSQLVAR Field Descriptions (Embedded SQL Guide)
- Input Descriptors (Embedded SQL Guide)
- Output Descriptors (Embedded SQL Guide)
- Using the XSQLDA_LENGTH Macro (Embedded SQL Guide)
- SQL Data Type Macro Constants (Embedded SQL Guide)
- Handling Varying String Data Types (Embedded SQL Guide)
- NUMERIC and DECIMAL Data Types
- Coercing Data Types (Embedded SQL Guide)
- Aligning Numerical Data (Embedded SQL Guide)
- DSQL Programming Methods
- Preprocessing, Compiling, and Linking
- Language Reference Guide
- Using the InterBase Language Reference
- SQL Statement and Function Reference
- SQL Flavors
- SQL Dialects
- Database Object Naming Conventions (Language Reference Guide)
- Statement List
- Function List (Language Reference Guide)
- Data Types (Language Reference Guide)
- Exact Numerics (Language Reference Guide)
- Error Handling
- Statement and Function Reference (Language Reference Guide)
- ALTER DATABASE
- ALTER DOMAIN
- ALTER EXCEPTION
- ALTER INDEX
- ALTER PROCEDURE
- ALTER TABLE
- ALTER TRIGGER
- ALTER USER
- AVG( )
- BASED ON
- BEGIN DECLARE SECTION
- CASE
- CAST( )
- CLOSE
- CLOSE (BLOB)
- COALESCE( )
- COMMIT
- CONNECT
- COUNT( )
- CREATE DATABASE
- CREATE DOMAIN
- CREATE ENCRYPTION
- CREATE EXCEPTION
- CREATE GENERATOR
- CREATE INDEX
- CREATE JOURNAL
- CREATE JOURNAL ARCHIVE
- CREATE PROCEDURE
- CREATE ROLE
- CREATE SHADOW
- CREATE SUBSCRIPTION
- CREATE TABLE
- CREATE TRIGGER
- CREATE USER
- CREATE VIEW
- DECLARE CURSOR
- DECLARE CURSOR (BLOB)
- DECLARE EXTERNAL FUNCTION
- DECLARE FILTER
- DECLARE STATEMENT
- DECLARE TABLE
- DELETE
- DESCRIBE
- DISCONNECT
- DROP DATABASE
- DROP DOMAIN
- DROP ENCRYPTION
- DROP EXCEPTION
- DROP EXTERNAL FUNCTION
- DROP FILTER
- DROP GENERATOR
- DROP INDEX
- DROP JOURNAL
- DROP JOURNAL ARCHIVE
- DROP PROCEDURE
- DROP ROLE
- DROP SHADOW
- DROP SUBSCRIPTION
- DROP TABLE
- DROP TRIGGER
- DROP USER
- DROP VIEW
- END DECLARE SECTION
- EVENT INIT
- EVENT WAIT
- EXECUTE
- EXECUTE IMMEDIATE
- EXECUTE PROCEDURE
- EXTRACT( )
- FETCH
- FETCH (BLOB)
- GEN_ID( )
- GRANT
- GRANT SUBSCRIBE
- GRANT TEMPORARY SUBSCRIBE
- INSERT
- INSERT CURSOR (BLOB)
- MAX( )
- MIN( )
- NULLIF( )
- OPEN
- OPEN (BLOB)
- PREPARE
- RELEASE SAVEPOINT
- REVOKE
- ROLLBACK
- SAVEPOINT
- SELECT
- SET DATABASE
- SET GENERATOR
- SET NAMES (Reference)
- SET SQL DIALECT
- SET STATISTICS
- SET SUBSCRIPTION
- SET TRANSACTION
- SHOW SQL DIALECT
- SHOW SUBSCRIPTION
- SUM( )
- TRUNCATE TABLE
- UPDATE
- UPPER( )
- WHENEVER
- RECONNECT
- Procedures and Triggers
- Creating Triggers and Stored Procedures
- Statement Types Not Supported
- Nomenclature Conventions
- Assignment Statement
- BEGIN ... END
- Comment
- DECLARE VARIABLE
- EXCEPTION
- EXECUTE PROCEDURE (Procedures)
- EXECUTE STATEMENT
- FOR SELECT…DO
- IF...THEN ... ELSE
- Input Parameters (Procedures)
- NEW Context Variables
- OLD Context Variables
- Output Parameters (Procedures)
- POST_EVENT
- SELECT (Procedures)
- SUSPEND
- WHEN...DO
- WHILE ... DO
- Keywords
- Error Codes and Messages
- System Tables, Temporary Tables, and Views
- Overview of System Tables, Temporary Tables, and Views
- System Tables
- RDB$CHARACTER_SETS
- RDB$JOURNAL_ARCHIVES
- RDB$CHECK_CONSTRAINTS
- RDB$COLLATIONS
- RDB$PAGES
- RDB$DATABASE
- RDB$PROCEDURE_PARAMETERS
- RDB$DEPENDENCIES
- RDB$PROCEDURES
- RDB$ENCRYPTIONS
- RDB$REF_CONSTRAINTS
- RDB$EXCEPTIONS
- RDB$RELATION_CONSTRAINTS
- RDB$FIELD_DIMENSIONS
- RDB$RELATION_FIELDS
- RDB$FIELDS
- RDB$RELATIONS
- RDB$FILES
- RDB$ROLES
- RDB$FILTERS
- RDB$SECURITY_CLASSES
- RDB$FORMATS
- RDB$TRANSACTIONS
- RDB$FUNCTION_ARGUMENTS
- RDB$TRIGGER_MESSAGES
- RDB$FUNCTIONS
- RDB$TRIGGERS
- RDB$GENERATORS
- RDB$TYPES
- RDB$INDEX_SEGMENTS
- RDB$USER_PRIVILEGES
- RDB$INDICES
- RDB$USERS
- RDB$VIEW_RELATIONS
- RDB$SUBSCRIPTIONS
- RDB$SUBSCRIBERS
- System Temporary Tables
- System Views
- Change Views (Reference)
- Character Sets and Collation Orders
- Operations Guide
- IBConsole
- IBConsole Interface
- IBConsole Menus and Dialogs Index
- IBConsole Menus and Toolbar
- IBConsole Dialogs
- Windows Menu
- Add Certificate
- Add Database and Connect
- Communication Diagnostics
- Create Database
- Create Journal
- Database Aliases
- Database Backup
- Database Connect
- Database Connections
- Database Copy
- Database Properties
- Database Restore
- Database Shutdown
- Database Statistics
- Database Validation
- Incremental Backup
- Item Editor
- Preferences
- Server Login
- Server Properties
- Supply Database Credentials
- Syntax Editor Options
- Tools
- User Information
- IBConsole Wizards
- IBConsole Windows and Tools
- IBConsole - Glossary
- IBConsole - Performance Guidelines
- InterBase Quick Start
- Introduction
- Part I - Getting Started
- Part II - Data Definition
- Part III - Populating the Database
- Part IV - Retrieving Data
- Part V - Advanced Topics
- Change Views Quick Start
- ToGo Quick Start
- Getting Started
- Comparing IBLite, ToGo, and InterBase Server Edition
- Using InterBase ToGo and IBLite
- ToGo System Requirements and Constraints
- ToGo Edition Users
- ToGo Edition Platforms
- Using the ToGo Edition
- Installing ToGo
- Linux Platform
- iOS Application
- Android Application
- InterBase ToGo Trial Licenses
- Windows Platforms
- macOS Platform
- Deploying InterBase with your applications on iOS
- Setup OTW/SSL and InterBase
- InterBase VAR License Portal
- ADO.NET Driver
- InterBase with RAD Studio
- InterBase Videos and Webinars
- What's New in InterBase 2017 Update 2
- What's New in InterBase 2017 Update 1
- InterBase 2017 Update 3 Readme
- Release Notes for InterBase 2020 Update 4
- What's New in InterBase XE7
- Using previous installers
- InterBase 2017 Update 2 Readme
- Resolved Defects
- InterBase 2017 Update 1 Readme
- Additional Resources
- What's New in InterBase 2017 Update 3
- Connecting to InterBase from Visual Studio
- InterBase Readme
- Readme InterBase 2020 Update 1
- InterBase What's New
- What's New in InterBase 2017
- Offline Docs