should see a process named fbguard. This is the Guardian process. Further, there will be one main and zero or more child processes named fbserver. The following screen shows the output of top, restricted masterkey and your server is exposed to the Internet at all – or even to a local network, unless you trust every user with the SYSDBA password – you should change it immediately using the gsec command-line divisor, or both. For example, the calculation above could be modified thus in order to produce a non-zero result: 1.000 / 3 = 0.333 Things to know about strings String delimiter symbol Strings in Firebird

masterkey and your server is exposed to the Internet at all — or even to a local network, unless you trust every user with the SYSDBA password — you should change it immediately. Fire up isql or another Firebird dividend, divisor, or both. For example, the calculation above could be modified thus to produce a non-zero result: 1.000 / 3 = 0.333 Chapter 6. Working with databases 35 6.4.2. Things to know about strings with values in other expressions, the result of the operation will almost always be NULL. It is not zero or blank or an “empty string”, and it does not behave like any of these values. Below are some examples

'YESTERDAY' and 'TOMORROW' automatically get a zero time part. If, for some reason, it is important to you to store a Dialect 1 timestamp literal with an explicit zero time-part, the engine will accept a literal a date value or date-part of a timestamp is represented as the number of days elapsed since “date zero” — November 17, 1898 — whilst a time value or the time- part of a timestamp is represented as the space: it depends on the character set. For example, the pad character for the OCTETS character set is zero. The full name of this data type is CHARACTER, but there is no requirement to use full names and

'YESTERDAY' and 'TOMORROW' automatically get a zero time part. If, for some reason, it is important to you to store a Dialect 1 timestamp literal with an explicit zero time-part, the engine will accept a literal a date value or date-part of a timestamp is represented as the number of days elapsed since “date zero” — November 17, 1898 — whilst a time value or the time- part of a timestamp is represented as the specification is assumed to be for untyped data and the default SUB_TYPE 0 is applied. The alias for subtype zero is BINARY. This is the subtype to specify when the data are any form of binary file or stream: images

all the information in the database — both data and metadata. In such cases the developer may not trust the users at these remote sites to keep the intellectual property represented by the database confidential decryption process. But again this would need to be in possession of the client, and if we don’t trust the client we can’t stop them from using it to gain access to the database from another server where their own data (in appropriate formats) in order to be able to move to alternative systems. Can you trust the users to respect your intellectual property while you are still in business and available? Provide

keeps track of allocated and free pages using a bitmap where a 1 means the page is free, and a 0 (zero) shows a used page. There may be more than one PIP in a database, but the first PIP is always page Write Ahead Log page. These pages are no longer used. The page will remain blank (filled with binary zero) as it is never used. This page has a standard header like all others. pag_flags One byte, unsigned field set to zero. hdr_next_page Four bytes, unsigned. Bytes 0x18 - 0x1b on the page. The page number of the header page in the next file of the database — if this is a multi-file database. Zero otherwise

335544697 precision_err Precision must be from 1 to 18 -842 335544698 scale_nogt Scale must be between zero and precision -842 335544699 expec_short Short integer expected -842 335544700 expec_long Long integer gfix_unexp_eoi Unexpected end of input -901 335544407 dbbnotzer Database handle not zero -901 335544408 tranotzer Transaction handle not zero -901 335741018 gfix_recon_fail Failed to reconnect to a transaction in 335544431 blocking_signal Blocking signal has been received -901 335741042 gfix_pzval_req Positive or zero numeric value required -901 335544442 noargacc_read Database system cannot read argument @1 -901

335544697 precision_err Precision must be from 1 to 18 -842 335544698 scale_nogt Scale must be between zero and precision -842 335544699 expec_short Short integer expected -842 335544700 expec_long Long integer 335544392 bdbincon Internal error -901 335544407 dbbnotzer Database handle not zero -901 335544408 tranotzer Transaction handle not zero -901 335544418 trainlim Transaction in limbo -901 335544419 notinlim float value. -901 335544772 exception_float_divide_by_zero Floating-point divide by zero. The code attempted to divide a floating- point value by zero. -901 335544773 exception_float_inexact_result Floating-point

335544697 precision_err Precision must be from 1 to 18 -842 335544698 scale_nogt Scale must be between zero and precision -842 335544699 expec_short Short integer expected -842 335544700 expec_long Long integer gfix_unexp_eoi Unexpected end of input -901 335544407 dbbnotzer Database handle not zero -901 335544408 tranotzer Transaction handle not zero -901 335741018 gfix_recon_fail Failed to reconnect to a transaction in 335544431 blocking_signal Blocking signal has been received -901 335741042 gfix_pzval_req Positive or zero numeric value required -901 335544442 noargacc_read Database system cannot read argument %ld -901

. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 39 18.2. Response Codes Are Usually Zero. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . However, see the caveats section below for details because it looks like the response code is always zero — at least up until Firebird 2.0.  When logging into a database on a remote server, you will always file, gstat now shows that the shadow count has gone up to three when it should have gone down to zero! Chapter 4. Shadow Files 9 Chapter 5. Set Database Page Buffers The database cache is an area