395 10.1.6. Internal Savepoints . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 396 10.1.7. Savepoints and PSQL . . . . . . . rdb$set_context('USER_SESSION', 'RecordsFound', RecCounter); select rdb$set_context('USER_TRANSACTION', 'Savepoints', 'Yes') from rdb$database Notes • The maximum number of variables in any single context is variables set with RDB$SET_CONTEXT() remain unchanged. • Any savepoints that were created after the one named are destroyed. Savepoints earlier than the one named are preserved, along with the named

567 12.1.6. Internal Savepoints . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 568 12.1.7. Savepoints and PSQL . . . . . . . rdb$set_context('USER_SESSION', 'RecordsFound', RecCounter); select rdb$set_context('USER_TRANSACTION', 'Savepoints', 'Yes') from rdb$database See also RDB$GET_CONTEXT() 8.2. Mathematical Functions 8.2.1. variables set with RDB$SET_CONTEXT() remain unchanged. • Any savepoints that were created after the one named are destroyed. Savepoints earlier than the one named are preserved, along with the named

. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 522 12.1.7. Savepoints und PSQL. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . rdb$set_context('USER_SESSION', 'RecordsFound', RecCounter); select rdb$set_context('USER_TRANSACTION', 'Savepoints', 'Yes') from rdb$database Siehe auch RDB$GET_CONTEXT() 8.2. Mathematische Funktionen 8.2 unverändert. • Alle Sicherungspunkte, die nach dem benannten erstellt wurden, werden zerstört. Savepoints vor dem benannten werden zusammen mit dem benannten Savepoint selbst beibehalten. Wiederholte

RDB$SET_CONTEXT('USER_SESSION', 'RECORDSFOUND', RECCOUNTER); SELECT RDB$SET_CONTEXT('USER_TRANSACTION', 'SAVEPOINTS', 'YES') FROM RDB$DATABASE Примечания: • Максимальное число переменных в рамках одного соединения

RECCOUNTER); Встроенные функции и переменные 410 SELECT RDB$SET_CONTEXT ('USER_TRANSACTION', 'SAVEPOINTS', 'YES') FROM RDB$DATABASE; Пример 7.26. Использование функций