Software BV (Netherlands) Mitaro Business Solutions (Liechtenstein) Other Donors Listed below are the names of companies and individuals whose cash contributions covered the costs for translation into English available. ◦ Double quotes are reserved for delimiting non-regular identifiers, enabling object names that are case-sensitive or that do not meet the requirements for regular identifiers in other ways Some keywords are reserved, meaning their usage as identifiers for database objects, parameter names or variables is prohibited in some or all contexts. Non-reserved keywords can be used as identifiers

available. ◦ Double quotes are reserved for delimiting non-regular identifiers, enabling object names that are case-sensitive or that do not meet the requirements for regular identifiers in other ways Some keywords are reserved, meaning their usage as identifiers for database objects, parameter names or variables is prohibited in some or all contexts. Non-reserved keywords can be used as identifiers and Keywords. Chapter 2. SQL Language Structure 21 2.3. Identifiers All database objects have names, often called identifiers. The maximum identifier length is 63 characters character set UTF8 (252

::= | class> | % | ( и не эквивалентный (если задан) class> ::= '_' | '[' ... ']' | class> ::= - class> ::= '[:' class name> ':]' class name> ::= ALPHA | UPPER | LOWER | DIGIT

LOCK Синтаксис и поведение Как сервер работает с WITH LOCK Опциональное предложение “OF names>” Предостережения при использовании WITH LOCK 10 Руководство по языку SQL Примеры использования GEN_ID, GENERATOR, IF, INACTIVE, INPUT_TYPE, ISOLATION, KEY, LENGTH, LEVEL, MANUAL, MODULE_NAME, NAMES, OPTION, OUTPUT_TYPE, OVERFLOW, PAGE, PAGE_SIZE, PAGES, PASSWORD, PRIVILEGES, PROTECTED, READ FILE FREE_IT GEN_ID GENERATOR IF INACTIVE INPUT_TYPE ISOLATION KEY LENGTH LEVEL MANUAL MODULE_NAME NAMES OPTION OUTPUT_TYPE OVERFLOW PAGE PAGE_SIZE PAGES PASSWORD PRIVILEGES PROTECTED 22 Руководство по

. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 47 18.14. SET NAMES. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . -c(ache) number of cache buffers -ch(arset) connection charset (set names) -d(atabase) database name to put in script creation -e(cho) of query column titles SET LIST -- toggle column or table display format SET NAMES -- set name of runtime character set Chapter 7. Getting Help 12 SET PLAN

unsigned int, mit <= wenn beide vorhanden ::= | class> | % | () ::= | ist und nicht gleich (wenn definiert)_ class> ::= '' | '[' ... ']' | '[^' ... ']' Chapter 4. Allgemeine Sprachelemente ::= | | class> ::= - class> ::= '[:' class name> ':]' class name> ::= ALPHA | UPPER | LOWER | DIGIT

335544554 nonsql_security_rel Table/procedure has non-SQL security class defined -84 335544555 nonsql_security_fld Column has non-SQL security class defined -84 335544668 dsql_procedure_use_err Procedure dsql_sqlda_value_err Incorrect values within SQLDA structure -806 335544600 col_name_err Only simple column names permitted for VIEW WITH CHECK OPTION -807 335544601 where_err No WHERE clause for VIEW WITH CHECK 336330762 gbak_filename_missing Requires both input and output filenames -901 336330763 gbak_dup_inout_names Input and output have the same name. Disallowed. -901 336330764 gbak_inv_page_size Expected page

335544554 nonsql_security_rel Table/procedure has non-SQL security class defined -84 335544555 nonsql_security_fld Column has non-SQL security class defined -84 335544668 dsql_procedure_use_err Procedure %s dsql_too_old_ods ODS versions before ODS%d are not supported -806 335544600 col_name_err Only simple column names permitted for VIEW WITH CHECK OPTION -807 335544601 where_err No WHERE clause for VIEW WITH CHECK 335544331 bad_tpb_form Invalid format for transaction parameter block -901 336330763 gbak_dup_inout_names Input and output have the same name.Disallowed. -901 335544332 bad_trans_handle Invalid transaction

YourVar, HisVar) ) then ... The list can also be generated by a one-column subquery: select ID, Name, Class from Students where ID in (select distinct LentTo from LibraryBooks) 5.1.1. With an empty list EXISTS (SELECT * FROM Landowners WHERE Landowners.Name = Farms.Farmer) This query returns the names of all farmers who also figure in the Landowners table. The EXISTS predicate returns true if the is how you would use COALESCE to construct a person’s full name from the first, middle and last names, assuming that some middle name fields may be NULL: select FirstName || coalesce( ' ' || MiddleName

335544554 nonsql_security_rel Table/procedure has non-SQL security class defined -84 335544555 nonsql_security_fld Column has non-SQL security class defined -84 335544668 dsql_procedure_use_err Procedure @1 dsql_too_old_ods ODS versions before ODS@1 are not supported -806 335544600 col_name_err Only simple column names permitted for VIEW WITH CHECK OPTION -807 335544601 where_err No WHERE clause for VIEW WITH CHECK Invalid format for transaction parameter block Firebird 2.1 Error Codes -901 336330763 gbak_dup_inout_names Input and output have the same name.Disallowed. -901 335740940 gfix_full_req "full" or "reserve"