. . 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 . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .

. . 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 . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .

. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 237 6. Data Manipulation-Statements (DML) . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . gespeichert als INTEGER (exact data) DECIMAL(4,2) INTEGER (data * 102) DECIMAL(10,4) (Dialekt 1) DOUBLE PRECISION (Dialekt 3) BIGINT (data * 104) 3.4. Datentypen für Datum Typen "DATE", "TIME" und "TIMESTAMP". Der SQL-Standard ruft diese Datetime- Literale auf. Syntax <data_type> 'date_literal_string' Beispiel -- 1 UPDATE PEOPLE SET AGECAT = 'SENIOR' WHERE BIRTHDATE

генераторов. Операторы DDL (Data Definition Language — язык определения данных): CREATE GENERATOR name; SET GENERATOR name TO value; DROP GENERATOR name; Операторы DML (Data Manipulation Language — язык манипуляции

just “happened to be” on the calculated spot was returned. If it was written to, it would overwrite data. This could sometimes lead to an immediate error, but most of the time it would just silently corrupt Use of generator statements. DDL (Data Definition Language) statements: CREATE GENERATOR name; SET GENERATOR name TO value; DROP GENERATOR name; DML (Data Manipulation Language) statements in client SQL: application other than the row IDs discussed above. When you have an application that is transferring data to some other system, you can use generators to safely identify a single transfer by labeling it

Generator-Befehle beschrieben. DDL (Data Definition Language) — Befehle: CREATE GENERATOR name; SET GENERATOR name TO value; DROP GENERATOR name; DML (Data Manipulation Language) Befehle in Client-seitigem

. . . . . . 22 Table of Contents 1 Chapter 1. Introduction Gsec is the security database manipulation utility. It allows the SYSDBA (or any privileged user) the ability to maintain user accounts Firebird version) • /opt/firebird for Linux and other Unix systems. The gsec utility manipulates data in the table(s) in the security database, and by doing so, allows users to be added, amended and

◦ 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

Улучшенная производительность WITH {AUTONOMOUS|COMMON} TRANSACTION WITH CALLER PRIVILEGES ON EXTERNAL [DATA SOURCE] AS USER, PASSWORD и ROLE Параметризованные операторы Предостережения для оператора EXECUTE Зарезервированные слова; • Типы и подтипы данных; • Операторы DDL (Data Definition Language - язык создания данных); • Операторы DML (Data Manipulation Language - язык обращения с данными); • Операторы управления (2.5.1). • Новые не зарезервированные слова: AUTONOMOUS, BIN_NOT, CALLER, CHAR_TO_UUID, COMMON, DATA, FIRSTNAME, GRANTED, LASTNAME, MAPPING, MIDDLENAME, OS_NAME, SOURCE, TWO_PHASE и UUID_TO_CHAR

............................................................................... 366 ON EXTERNAL [DATA SOURCE] ........................................................................ 366 Особенности ключевые слова; • Типы и подтипы данных; • Операторы DDL (Data Definition Language — язык создания данных); • Операторы DML (Data Manipulation Language — язык обращения с данными); • Операторы управления NUMERIC(4) SMALLINT NUMERIC(4,2) SMALLINT (data * 102) NUMERIC(10,4) DOUBLE PRECISION в 1-ом диалекте BIGINT в 3-ем диалекте (data * 104) Внимание Всегда надо помнить