After upgrade, make sure that there is only the one copy of HQbird is running! If there are 2 copies, stop them (service hqbird stop for the first and kill for the second instances) and start it again.
At the first launch FBDataGuard will check computer for installed Firebird servers.FBDataGuard for Windows search registry for Firebird records, FBDataGuard for Linux checks default locations of Firebird installations.
Using configuration dialog, you can specify check period and thresholds for free space.The first reached threshold will be alerted.To set threshold only in % of disk space, you need to set explicit space in bytes to 0.
On the left side of the page, you will see two buttons: "Properties" and "Databases". The first one opens a context menu for selecting counters that will be displayed on the charts. The second, opens the context menu in which you can select the database for which these counters are displayed. The database must be registered for monitoring with DataGuard.
The first thing we have to say about the structure of Firebird database is that it represents a set of pages of strictly defined size: 4096, 8192, 16384 (previous versions of Firebird supported page sizes 1024 and 2048).
To use the UDR lkJSON library, you need to register it in your database.To do this, run one of the scriptsplugin/UDR/udrJSON.sql or plugin/UDR/udrJSON-utf8.sql, depending on the encoding of your database(the first will work for any single-byte encoding).
The Field function returns a pointer to an object field. The first parameter is a pointer to the object,the second is the field name. If the field does not exist, then the function will return a null pointer(This is not NULL, but x'0000000000000000').
The ReadableText function returns JSON as a human-readable string of type BLOB SUB_TYPE TEXT.The Level parameter sets the number of indents for the first level.This is required if the generated string is part of another JSON. If TRUE is passed in the Conv parameter,then the text returned by this function will be converted to UTF8.
The initialize() function initializes the nanodbc UDR. It is recommended to call this function in the ON CONNECT trigger.It must be called before the first call to any other function from the nanodbc UDR.
This Firebird SQL Language Reference is the first comprehensive manual to cover all aspects of the query language used by developers to communicate, through their applications, with the Firebird relational database management system.It has a long history.
Once the DocBook source appears in CVS, we hope the trusty translators will start making versions in German, Japanese, Italian, French, Portuguese, Spanish, Czech.Certainly, we never have enough translators so please, you Firebirders who have English as a second language, do consider translating some sections into your first language.
The first full language reference manual for Firebird would not have eventuated without the funding that finally brought it to fruition.We acknowledge these contributions with gratitude and thank you all for stepping up.
After the call to isc_dsql_describe_bind(), the SQLTYPE of the second and fourth parameters will be set to SQL_NULL.Firebird has no knowledge of their special relation with the first and third parameters: that responsibility lies entirely on the application side.
The bool_expr expression is one that gives a ternary logical result: TRUE, FALSE or NULL.The first expression to return TRUE determines the result.If no expressions return TRUE, defaultresult from the optional ELSE clause is returned as the result.If no expressions return TRUE and there is no ELSE clause, the result will be NULL.
If the braces contain two numbers separated by a comma, the second number not smaller than the first, then the item must be repeated at least the first number and at most the second number of times in order to match:
Use the ADD CONSTRAINT CHECK clause to add a CHECK constraint to the domain.If the domain already has a CHECK constraint, it will have to be deleted first, using an ALTER DOMAIN statement that includes a DROP CONSTRAINT clause.
A file that is defined as an external table must be located on a storage device that is physically present on the machine where the Firebird server runs and, if the parameter ExternalFileAccess in the firebird.conf configuration file is Restrict, it must be in one of the directories listed there as the argument for Restrict.If the file does not exist yet, Firebird will create it on first access.
Creating the SALARY_HISTORY table with two computed fields.The first one is declared according to the SQL:2003 standard, while the second one is declared according to the traditional declaration of computed fields in Firebird.
Notice that whereas the first query used a column aliases list for the derived table, the second adds aliases internally where needed.Both methods work, as long as every column is guaranteed to have a name.
Unions take their column names from the first select query.If you want to alias union columns, do so in the column list of the topmost SELECT.Aliases in other participating selects are allowed and may even be useful, but will not propagate to the union level.
Sorting the set obtained by a UNION of two queries.Results are sorted in descending order for the values in the second column, with NULLs at the end of the set;and in ascending order for the values of the first column with NULLs at the beginning.
The final item in the header (or the first item in the body, depending on your opinion of where the border lies) is one or more declarations of any local variables and/or named cursors that your procedure might require. 2b1af7f3a8