(Open Database Connectivity), драйвера OLE DB (он также используется для доступа в технологии ActiveX Data Objects, ADO), и др. Использование низкоуровневого API на языке C позволяет создавать переносимый Enterprise Manager IBExpert (free/commercial) Enterprise Manager DataBase Workbench (commercial) Import and Export Data - Performance Monitor InterBase Heartbeat (commercial) Profiler InterBase Observer SQL

◦ Create, update, query, and drop data or metadata. ◦ Input a script file containing a batch of SQL statements in sequence without prompting. ◦ Add and modify data. ◦ Grant user permissions. ◦ Perform remains uncharged. Using -ex(tract) The command line switch -ex(tract) can be used to extract meta data from the database. It can be used in conjunction with the -o(utput) switch to extract the information select MON$DATABASE_NAME from mon$database; MON$DATABASE_NAME ================================= /data/databases/firebird/test.fdb Chapter 8. Connecting To A Database 17 Chapter 9. Creating A Database

Note in V.2.1 Metadata Need to be Upgraded If your databases contain text BLOBs storing non-ASCII data then the backup/restore cycle is not enough to upgrade them to ODS 11.1. Please pay attention to the (V.2.1) Malformed UTF8 strings and text blobs are no longer allowed. This affects not just user data but also the metadata stored in the system tables. There is a metadata script to enable you to upgrade allow Firebird to use indexes. Indexes Involving Data Type Coercion May Be Ignored (V.2.1) In cases where an indexed field and an argument have different data types and the implicit conversion cannot be performed

a single file database is simply the database name and for multi-file databases, it is the first data file added. Coming up in the remainder of this manual, we will discuss the following: • Command password as environment variables on a Linux system: Chapter 3. Gfix Commands 5 linux> export ISC_USER=sysdba linux> export ISC_PASSWORD=masterkey Alternatively, on Windows: C:\> set ISC_USER=sysdba C:\> This makes the shadow file the new database file, and the users are able to continue processing data as normal and without loss. In the event that your main database file(s) become corrupted or unreadable

. . 24 3. Data Types and Subtypes . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 26 3.1. Integer Data Types . . . Floating-Point Data Types. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 30 3.2.1. Approximate Floating-Point Data Types . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 32 3.3. Fixed-Point Data Types . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .

sistema operativo. En una ventana de comandos DOS/ Windows, escriba set CVS_RSH=ssh. En Linux/bash: export CVS_RSH=ssh. Ud. puede querer hacer permanente esta variable de entorno, de tal manera que pueda bajo Windows con set JAVA_HOME=C:\Archivos de programa\Java\j2re1.4.2_01 o bajo Li- nux/bash con export JAVA_HOME=/usr/lib/java/jre (nota: estas rutas son sólo ejemplos; pueden o no ser iguales a las suyas)

. . 22 3. Data Types and Subtypes . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 23 3.1. Integer Data Types . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 26 3.2. Floating-Point Data Types. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 27 3.3. Fixed-Point Data Types . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .

. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 18 8. Data Page — Type 0x05 . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 22 8.2. Record Data . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 8.4. Examining The Data. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 28 8.4.1. Compressed Data. . . . . . . . . .

onwards. -M[ETA_DATA] This switch causes your data to be ignored and not backed up or restored. In a backup, only the database meta data are backed up. When used in a restore, any data in the dump file creating database clones which are required to contain only the tables, indices etc but none of the data. -PAS[SWORD] Supplies the password for the username specified above. This need not be file -CO[NVERT] backup external files as tables -E[XPAND] no data compression -FA[CTOR] blocking factor -G[ARBAGE_COLLECT) inhibit garbage

. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 30 8.9. Stream of BLOB data . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . Reading row data . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 36 Appendix A: External Data Representation . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 37 Appendix B: Data types. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .