nonsql_security_fld Column has non-SQL security class defined -84 335544668 dsql_procedure_use_err Procedure <string> does not return any values -85 335544747 usrname_too_long The username entered is too long. Maximum invalid_blr Invalid request BLR at offset -104 335544390 syntaxerr BLR syntax error: expected <string> at offset , encountered -104 335544425 ctxinuse Context already in use (BLR error) release -104 335544743 token_too_long Token size exceeds limit -104 335544763 invalid_string_constant A string constant is delimited by double quotes -104 335544764 transitional_date DATE must be changed

. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 326 8.3. String Functions . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . DATE implementation. ◦ Double quotes may be used as an alternative to apostrophes for delimiting string data. This is contrary to the SQL standard — double quotes are reserved for a distinct syntactic 2.3.2. Rules for Delimited Object Identifiers • Length cannot exceed 31 characters • The entire string must be enclosed in double-quotes, e.g. "anIdentifier" • It may contain characters from any Latin

. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 431 8.3. String and Binary Functions . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . DATE implementation. ◦ Double quotes may be used as an alternative to apostrophes for delimiting string data. This is contrary to the SQL standard — double quotes are reserved for a distinct syntactic UTF8, which means characters outside the ASCII range are stored using 2 to 4 bytes. • The entire string must be enclosed in double-quotes, e.g. "anIdentifier" Chapter 2. SQL Language Structure 22 •

. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 418 8.3. String-Funktionen . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . gespeichert, dh Zeichen außerhalb des ASCII-Bereichs werden mit 2 oder 3 Byte gespeichert. • Der gesamte String muss in doppelte Anführungszeichen eingeschlossen werden, z.B. "anIdentifier" • Es kann jedes -34, 45, 0X080000000; fixed-point - 0.0, -3.14 floating-point - 3.23e-23; string - 'text', 'don''t!'; binary string - x'48656C6C6F20776F726C64' date - DATE '2018-01-19'; time

ltrim mod *nullif *nvl pi rand right round, i64round rpad rtrim sdow sign sin sinh sqrt srand sright string2blob strlen substr substrlen tan tanh truncate, i64truncate Приложение А: Примечания Набор символов PRIVILEGES | AS USER user | PASSWORD password | ROLE role | ON EXTERNAL [DATA SOURCE] string> string> ::= [] путь к БД или алиас ::= | сложные операторы PSQL ВНИМАНИЕ: paramless-stmt, , user, password, role и string> - строковые выражения. При явном задании этих аргументов (т.е. в виде символьных строк)

The following screen shows the output of top, restricted by grep to show only lines containing the string firebird: paul@fili ~ $ top -b -n1 | grep [f]irebird 7169 firebird 20 0 29668 992 560 Chapter 5. Server configuration and management 19 a valid SQL identifier, the value a non-NULL string of at most 255 bytes. Only SYSDBA and co-admins can use all these commands. Ordinary users can change making sure that the Engine13 provider doesn’t kick in. This is easily achieved with a connection string like xnet://local-path-or-alias. To give just one administrator — or indeed any user — full SYSDBA

. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 9 3.1. Mathematical and string operations . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . kind of “nothing” that won’t do any harm if you add it to a number or stick it to the back of a string. In reality, performing such operations will render the entire expression NULL. This guide explores indicating that an item’s value is unknown or nonexistent. It is not zero or blank or an “empty string” and it does not behave like any of these values. Few things in SQL lead to more confusion than

комментариев. Синтаксис: ::= <string operator> | | | <string operator> ::= {||} string literal> ::= { q | Q } [ { }... ] result: abc{def}ghi SELECT Q'{abc{def}ghi}' FROM rdb$database; -- result: That's a string SELECT Q'!That's a string!' FROM rdb$database; Динамическая сборка

supply, amongst other things, a connection string to the client application (or, if you are a programmer, to the routines you are calling). A connection string uniquely identifies the location of the database computer, local network, or even the Internet. Local connection strings An explicit local connection string consists of the path + filename specification in the native format of the filesystem used on the you thought you were connected to may be disastrous. Instead of a file path, the local connection string may also be a database alias that is defined in aliases. conf, as mentioned earlier. The format of

............................................................................................. 17 String delimiter symbol ............................................................................... same rule applies to any databases that you create. There are two elements to a TCP/IP connection string: the server name and the disk/filesystem path. Its format is as follows: • For a Linux server: sym- bols were used with the database path string in the above example. This is sometimes necessary with some of the command-line utilities where the path string contains spaces. Single quotes should work