Firebird Documentation Index
Firebird Home Firebird Home Firebird Documentation Index

Firebird Command Line Utilities


Table of Contents

Firebird Password File Utility
Introduction
Command Line Options
Gsec Commands
Interactive Mode
Batch Mode
Running Gsec Remotely
Gsec caveats
Firebird Database Housekeeping Utility
Introduction
Command Line Options
Gfix Commands
Shadow Files
Set Database Page Buffers
Limbo Transaction Management
Cache Manager
Changing The Database Mode
Setting The Database Dialect
Database Housekeeping And Garbage Collection
Database Startup and Shutdown
Database Page Space Utilisation
Database Validation and Recovery
Database Write Mode
Version Number
Caveats
Firebird Backup File Splitting Filter
Introduction
Gsplit Command line Options
Gsplit Command Parameters
Splitting Backups
Joining Backup Files
Firebird Backup & Restore Utility
Introduction
Command-line Options
Backup Mode
Restore Mode
Security Of Backups
Backup & Restore Recipes
Gbak Caveats
Firebird Database Statistics Reporting Tool
Introduction
Command-line Switches
Gstat Examples And Interpretation
Gstat Caveats
Firebird Superserver Manager
Introduction.
Fbmgr on Linux Systems.
Fguard on Linux Systems.
Windows Systems.
Fbmgr Caveats
Firebird Shell Scripts
Introduction
ChangeDBAPassword
CreateAliasDB
Fb_config
ChangeRunUser
RestoreRootRunUser
ChangeGDSLibraryCompatibleLink
Isql - Firebird Interactive SQL Utility
Introduction
Overview
Invoking isql
Starting an isql Session
Connecting to a database
Creating a database
Setting the ISC_USER and ISC_PASSWORD environment variables
Dialects
Terminator Character
Error Handling and Exception Support
Transaction Handling
Script Handling
Using isql interactively
Command-line Switches
Ending an isql Session

List of Tables

1. SQL Dialects
2. ISQL error codes and messages
3. INPUT arguments
4. OUTPUT arguments
5. SHELL arguments
6. BLOBDUMP arguments
7. BLOBDVIEW arguments
8. EDIT arguments
9. SHOW DOMAIN[S] arguments
10. SHOW GENERATOR[S] arguments
11. SHOW CHECK arguments
12. SHOW EXCEPTION[S] arguments
13. SHOW FUNCTION[S] arguments
14. SHOW GRANT arguments
15. SHOW INDEX| INDICES arguments
16. SHOW PROCEDURE[S] arguments
17. SHOW VIEW[S]
18. SET AUTODDL arguments
19. SET BLOBDISPLAY arguments
20. SET COUNT arguments
21. SET ECHO arguments
22. SET NAMES arguments
23. SET PLAN arguments
24. SET SQL DIALECT arguments
25. SET STATS arguments
26. SET TERM arguments
27. SET TIME arguments
28. SET WARNINGS arguments
29. ISQL COMMAND-LINE SWITCHES
Firebird Documentation Index
Firebird Documentation Index