. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 39 3.4.4. Session Time Zone . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 625 14.4. Session Timeouts . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 626 14.4.1. SET SESSION IDLE TIMEOUT 632 14.6. Reset Session State . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 632 14.6.1. ALTER SESSION RESET . . . .

Starting An Isql Session . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 10 6. Ending an Isql Session . . . . . . . The isql utility can be used in three modes: as an interactive session; directly from the command line; and as a non-interactive session, using a shell script or batch file. Different tasks may be performed the modes, as illustrated below: • An interactive session can be invoked from the command line of the operating system shell, and lasts until the session is terminated, using a QUIT or EXIT command. Isql

rdb$get_context('DDL_TRIGGER', 'SQL_TEXT'), 'N') RETURNING id INTO id; rdb$set_context('USER_SESSION', 'trig_ddl_log_id', id); END END! -- Примечание: -- созданный выше триггер будет запущен для AUTONOMOUS TRANSACTION DO UPDATE ddl_log SET ok = 'Y' WHERE id = rdb$get_context('USER_SESSION', 'trig_ddl_log_id'); END! COMMIT! SET TERM ;! -- Удаляем запись о создании trig_ddl_log_after RDB$GET_CONTEXT('USER_SESSION', 'DATEBEGIN'); END -- Возвращает дату окончания периода FUNCTION GET_DATEEND() RETURNS DATE DETERMINISTIC AS BEGIN RETURN RDB$GET_CONTEXT('USER_SESSION', 'DATEEND');

имен - SYSTEM, USER_SESSION или USER_TRANSACTION. Тип результата: VARCHAR(255) Синтаксис: RDB$GET_CONTEXT ('', '') ::= SYSTEM | USER_SESSION | USER_TRANSACTION ::= регистрочувтвительная строка с максимальной длиной 80 символов Пространство имён: USER_SESSION и USER_TRANSACTION изначально пусты. Пользователь может создать и установить значение переменных CURRENT_USER Глобальная переменная CURRENT_USER CURRENT_ROLE Глобальная переменная CURRENT_ROLE SESSION_ID Глобальная переменная CURRENT_CONNECTION TRANSACTION_ID Глобальная переменная CURRENT_TRANSACTION

TRIGGER', 'SQL_TEXT'), 'N') returning id into id; rdb$set_context('USER_SESSION', 'trig_ddl_log_id', id); end end! Der obige Trigger wird für diesen DDL-Befehl ausgelöst. Es autonomous transaction do update ddl_log set ok = 'Y' where id = rdb$get_context('USER_SESSION', 'trig_ddl_log_id'); end! Chapter 5. Anweisungen der Datendefinitionssprache (DDL) 169 commit RDB$GET_CONTEXT('USER_SESSION', 'DATEBEGIN'); END - Gibt das Enddatum des Zeitraums zurück FUNCTION GET_DATEEND() RETURNS DATE DETERMINISTIC AS BEGIN RETURN RDB$GET_CONTEXT('USER_SESSION', 'DATEEND');

a “database trigger” — can be specified to fire in association with the start or end of a user session (connection) or a user transaction. 5.7.1. CREATE TRIGGER Used for Creating a new trigger Available upon “database events”, which really refers to a mixture of events that act across the scope of a session (connection) and events that act across the scope of an individual transaction: • CONNECT • DISCONNECT available in ESQL Syntax RDB$GET_CONTEXT ('', ) ::= SYSTEM | USER_SESSION | USER_TRANSACTION ::= A case-sensitive quoted string of max. 80 characters Table 97

C:\> set ISC_PASSWORD=masterkey  This is very insecure as it allows anyone who can access your session the ability to perform DBA functions that you might not want to allow. -role role Supplies the command line prompts shows which of the two sessions we are using at the time. First, the initial session is connected to the database and can see that there are two shadow files attached: linux_1>isql shd1" manual Shadow 2: "/home/norman/firebird/shadow/my_employee.shd2" manual ... In the second session, we delete one of the shadow files, and then try to connect to the database linux_2> rm /home/n

correctement, vous ne devriez rien avoir à faire jusqu’ à la fin de l’ installation. Alors ouvrez une session et allez-y! Plates-formes Windows L'utilitaire d'installation de Firebird vous laisse le choix si l'adresse IP de votre serveur dans le domaine visible du client est 192.13.14.1, démarrez une session command shell et tapez la commande Firebird 1.5 Guide de démarrage 9 ping 192.13.14.1 remplacez

0 Finally, it is possible - and probably most useful - to determine the statistics for your own session. You can find your attachment id from CURRENT_CONNECTION and use that in a query that joins with

only) help displaying version number: z (interactive only) quit interactive session: quit (interactive only) available parameters: -pw -uid