. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 36 17.9. SET. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 37 18. Isql Set Commands . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 39 18.1. SET. . . . . . . . . Contents 1 18.2. SET AUTOddl. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 40 18.3. SET BAIL. . . . .

. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 44 3.5.2. Client Character Set . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 161 5.5.4. SET STATISTICS . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 237 5.14.6. SET GENERATOR. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .

. . . . . . . . . . . . . . . . . . . . . . . 32 Table of Contents 2 3.5.2. Client Character Set . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 128 5.5.4. SET STATISTICS . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 168 5.11.3. SET GENERATOR. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .

. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 19 5.9. Set cursor name . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 29 8.7. Set default blob parameters. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . of the response. Chapter 1. Introduction 3 Chapter 2. Responses The wire protocol has a limited set of responses. Some operations have a specific response, which is described together with the operation

. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 17 5.2.1. Result values . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . elements are purposely designed to give an unambiguous result with NULL (unambiguous in the sense that some specific action is taken and/or a non-NULL result is returned). They are discussed in the following does the same as the previous example */ Chapter 2. NULL support in Firebird SQL 6 update Numbers set Total = A + B + C where A + B + C is not null delete from Phonebook where PhoneNum is null Do not

............................................................................................ 142 SET STATISTICS ....................................................................................... ............................................................................................ 225 SET GENERATOR ........................................................................................ ............. 235 CHARACTER SET ................................................................................................................. 235 ALTER CHARACTER SET .............................

сортировках Юникод сортировки для всех наборов символов 6. Операторы DDL CHARACTER SET ALTER CHARACTER SET COLLATION CREATE COLLATION DROP COLLATION COMMENT DATABASE CREATE DATABASE ALTER RECREATE PROCEDURE SEQUENCE или GENERATOR CREATE SEQUENCE CREATE GENERATOR ALTER SEQUENCE SET GENERATOR DROP SEQUENCE DROP GENERATOR TABLE 3 Руководство по языку SQL CREATE TABLE ALTER недоступным использование полного имени таблицы ROWS UNION WITH LOCK UPDATE Изменение семантики SET Использование COLLATE для столбцов с текстовым BLOB ORDER BY PLAN Использование COLLATE для

. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 148 5.5.4. SET STATISTICS . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 224 5.14.6. SET GENERATOR. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 17. CHARACTER SET. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 236 5.17.1. ALTER CHARACTER SET . . . . . .

ping 127.0.0.1 If you have a simple network of two machines linked by a crossover cable, you can set up your server with any IP address you like except 127.0.0.1 (which is reserved for a local loopback) with: Database: localhost:employee, User: SYSDBA Now alter the sysdba password: alter user sysdba set password 'Zis4_viZuna83YoYo';  Instead of USER SYSDBA you can also use CURRENT USER, which always ...] [TAGS ( [, ...]] [CREATE OR] ALTER {USER username | CURRENT USER} [SET] [ [ ...]] [TAGS ( [, ...]] DROP USER username)

. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 8 5. Set Database Page Buffers . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . for database usage -at(tach) shutdown new database attachments -b(uffers) set page buffers -co(mmit) commit transaction -ca(che) shutdown force database shutdown -fe(tch_password) fetch password from file -h(ousekeeping) set sweep interval -i(gnore) ignore checksum errors -icu fix database