subsets in Firebird’s language implementation are: • Dynamic SQL (DSQL) • Procedural SQL (PSQL) • Embedded SQL (ESQL) • Interactive SQL (ISQL) Dynamic SQL is the major part of the language which corresponds through the public Firebird API and processed by the database engine. Procedural SQL augments Dynamic SQL to allow compound statements containing local variables, assignments, conditions, loops and stored modules (procedures and triggers) only, but in more recent releases they were surfaced in Dynamic SQL as well (see EXECUTE BLOCK). Embedded SQL defines the DSQL subset supported by Firebird gpre

subsets in Firebird’s language implementation are: • Dynamic SQL (DSQL) • Procedural SQL (PSQL) • Embedded SQL (ESQL) • Interactive SQL (ISQL) Dynamic SQL is the major part of the language which corresponds through the public Firebird API and processed by the database engine. Procedural SQL augments Dynamic SQL to allow compound statements containing local variables, assignments, conditions, loops and stored modules (procedures and triggers) only, but in more recent releases they were surfaced in Dynamic SQL as well (see EXECUTE BLOCK). Embedded SQL defines the DSQL subset supported by Firebird gpre

четыре подмножества SQL, используемых в различных областях применения: • Динамический SQL (DSQL, Dynamic SQL) • Процедурный SQL (PSQL, Procedural SQL) • Встроенный SQL (ESQL, Embedded SQL) • Интерактивный rows affected Данные не обнаружены или не затронуты строки SQLCLASS 07 (Dynamic SQL error) Класс ошибок 07 (Ошибки DSQL) 7000 Dynamic SQL error Ошибка DSQL 7001 Wrong number of input parameters Неверное cannot be executed Определение курсора не может быть выполнено 7004 USING clause required for dynamic parameters Для динамического параметра требуется предложение USING 7005 Prepared statement not

hosts file or Domain Name Services. -901 335544711 unprepared_stmt Attempt to execute an unprepared dynamic SQL statement. -901 335544716 svc_in_use Service is currently busy: -901 335544731 tra_must_sweep shutdown -902 335544557 shutfail Database shutdown unsuccessful -902 335544569 dsql_error Dynamic SQL Error -902 335544653 psw_attach Cannot attach to password database -902 335544654 psw_start_trans

Teilmengen in Firebirds Sprachimplementation sind: • Dynamic SQL (DSQL) • Procedural SQL (PSQL) • Embedded SQL (ESQL) • Interactive SQL (ISQL) Dynamic SQL macht den Hauptteil der Sprache aus, der in Abschnitt Anwendungen über die Firebird API durch die Datenbank verarbeitet werden. Procedural SQL erweitert Dynamic SQL, um zusammengesetzte Anweisungen zu ermöglichen, die lokale Variablen, Zuweisungen, Bedingungen gespeicherten Modulen (Prozeduren und Trigger) verfügbar, aber in neueren Versionen wurden sie auch in Dynamic SQL aufgetaucht (siehe EXECUTE BLOCK). Embedded SQL definiert die DSQL-Untermenge, die von Firebird

file or Domain Name Services. -901 335544711 unprepared_stmt Attempt to execute an unprepared dynamic SQL statement. -901 335544716 svc_in_use Service is currently busy: %s -901 335544731 tra_must_sweep Database %s shutdown -902 335544557 shutfail Database shutdown unsuccessful -902 335544569 dsql_error Dynamic SQL Error -902 335544653 psw_attach Cannot attach to password database -902 335544654 psw_start_trans

hosts file or Domain Name Services. -901 335544711 unprepared_stmt Attempt to execute an unprepared dynamic SQL statement. -901 335544716 svc_in_use Service is currently busy: @1 -901 335544731 tra_must_sweep Database @1 shutdown -902 335544557 shutfail Database shutdown unsuccessful -902 335544569 dsql_error Dynamic SQL Error -902 335544653 psw_attach Cannot attach to password database -902 335544654 psw_start_trans

my_employee Database: my_employee SQL> create table test(stuff integer); Statement failed, SQLCODE = -902 Dynamic SQL Error -attempted update on read-only database SQL> quit; Chapter 8. Changing The Database Mode database /home/norman/firebird/my_employee.fdb shutdown in progress Statement failed, SQLCODE = -901 Dynamic SQL Error -SQL error code = -901 -invalid transaction handle (expecting explicit transaction start)

installation directory Windows Embedded The embedded server is a fully functional server linked as a dynamic library that is distributed with the name fbembed.dll. It has exactly the same features as the usual Microsoft MSVC8 compiler in Visual Studio 2005. Because all the Firebird binaries are built to use dynamic linking, they all require run-time libraries. To avoid the dll-hell issue Microsoft introduced new

командой "delete from rdb $pages". —Jim Starkey Использование транзакций В СУБД Firebird в DSQL (dynamic SQL) транзакции «напрямую» не используются. Именованные тран- закции в этом случае недоступны совсем