. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 349 7.3. Stored Functions. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . Built-in Scalar Functions . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 410 8.1. Context Functions. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 414 8.2. Mathematical Functions . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .

11 4. Internal functions and directives. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 13 4.1. Internal functions. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 24 8. Aggregate functions. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 37 13. User-Defined Functions (UDFs). . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .

. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 264 7.3. Stored Functions. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . Built-in Functions. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 309 8.1. Context Functions. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 311 8.2. Mathematical Functions . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .

. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 61 19.9. SHOW FUNCtions . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . prompting. ◦ Add and modify data. ◦ Grant user permissions. ◦ Perform database administrative functions. • Directly from the command line, with individual options and without starting an interactive In a non-interactive session, the user employs a shell script or batch file to perform database functions.  Because other applications in the Linux environment, for example, MySQL, also use isql as

..................................................................................... 664 RDB$FUNCTIONS ............................................................................................... Приложение A: Дополнительные статьи Поле RDB$VALID_BLR В системных таблицах RDB$PROCEDURES, RDB$FUNCTIONS и RDB$TRIGGERS присутствует поле RDB$VALID_BLR. Оно предназначено для сигнализации о возможной 'Function', RDB$FUNCTION_NAME, RDB$VALID_BLR FROM RDB$FUNCTIONS WHERE RDB$FUNCTIONS.RDB$PACKAGE_NAME IS NULL UNION ALL SELECT 'Package', RDB$PACKAGE_NAME

Since Firebird 2.1, Windows domain administrators have had full access to the user management functions. This meant that when an admin user connected to the server and then used gsec, they had the ability cause all Windows Administrator accounts to automatically have full access to the user management functions. The automatic mapping can be revoked as follows: SQL> SQL> alter role rdb$admin drop auto admin Since Firebird 2.1, Windows domain administrators have had full access to the user management functions. This meant that when an admin user connected to the server and then used gsec, they had the ability

function nor a part of the GROUP BY clause) -104 335544826 dsql_agg_nested_err Nested aggregate functions are not allowed -104 336003075 dsql_transitional_numeric Precision 10 to 18 changed from DOUBLE 335544512 prcmismat Parameter mismatch for procedure -170 335544619 extern_func_err External functions cannot have more than 10 parameters Firebird 1.5 Error Codes Updated 04/30/04 p. 4 -171 335544439 extern_func_dir_error Function is in , which is not in a permitted directory for external functions. -902 335544819 io_32bit_exceeded_err File exceeded maximum size of 2GB. Add another database file

function nor a part of the GROUP BY clause) -104 335544826 dsql_agg_nested_err Nested aggregate functions are not allowed -104 335544849 malformed_string Malformed string -104 335544851 command_end_err2 335544512 prcmismat Input parameter mismatch for procedure %s -170 335544619 extern_func_err External functions cannot have more than 10 parameters -170 335544850 prc_out_param_mismatch Output parameter mismatch extern_func_dir_error Function %s is in %s, which is not in a permitted directory for external functions. -902 335544819 io_32bit_exceeded_err File exceeded maximum size of 2GB.Add another database file

function nor a part of the GROUP BY clause) -104 335544826 dsql_agg_nested_err Nested aggregate functions are not allowed -104 335544849 malformed_string Malformed string -104 335544851 command_end_err2 335544512 prcmismat Input parameter mismatch for procedure @1 -170 335544619 extern_func_err External functions cannot have more than 10 Firebird 2.1 Error Codes parameters -170 335544850 prc_out_param_mismatch extern_func_dir_error Function @1 is in @2, which is not in a permitted directory for external functions. -902 335544819 io_32bit_exceeded_err File exceeded maximum size of 2GB.Add another database file

. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 449 8.7. UUID Functions. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 650 RDB$FUNCTIONS . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . mit CREATE FUNCTION … EXTERNAL … erstellt wurden, sollten nicht mit älteren UDFs (User Defined Functions) verwechselt werden, die mit DECLARE EXTERNAL FUNCTION deklariert wurden. UDFs sind veraltet und