-⁠ac[tivate]. This makes the shadow file the new database file, and the users are able to continue processing data as normal and without loss. In the event that your main database file(s) become corrupted shadow becomes unusable for some reason, the database will stop accepting new connections until such time as the DBA kills the faulty shadow and, ideally, creates a new shadow to replace the broken one. connect to the database. The command line prompts shows which of the two sessions we are using at the time. First, the initial session is connected to the database and can see that there are two shadow files

. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 30 3.4.2. TIME . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 31 3.4.4. Operations Using Date and Time Values . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 31 . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 344 8.4. Date and Time Functions . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .

of calling gbak will make a backup of the database. If your database is large, this can take some time to complete and the backup file specified will be overwritten if it already exists. Beware.  The -NT Non-Transportable backup file format -O[NE_AT_A_TIME] restore one table at a time -OL[D_DESCRIPTIONS] save old style metadata descriptions -P[AGE_SIZE] -N(O_VALIDITY) do not restore database validity conditions -O(NE_AT_A_TIME) restore one table at a time -P(AGE_SIZE) override default page size -USE_(ALL_SPACE)

. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 38 3.4.2. TIME . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 39 3.4.4. Session Time Zone . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 40 3.4.5. Time Zone Format. . . . . . 2 3.4.6. Operations Using Date and Time Values . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 40 3.4.7. Supplemental Time Zone Features . . . . . . . . . . .

. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 51 18.20. SET TIME. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . sql dialect to SET STATs -- toggle display of performance statistics SET TIME -- toggle display of timestamp with DATE values SET TERM -- change each client and database server. These SQL dialects are differentiated in the context of the date-time format, and the precision of a numerical data type. The dialects serve to instruct the Firebird server

written to, it would overwrite data. This could sometimes lead to an immediate error, but most of the time it would just silently corrupt your database. 2.6. Generators and transactions As said, generators “rollback” generators inside a transaction. There may be other transactions executing at the same time that change the value while your transaction runs. So once you have requested a generator value, rollback, I can just do GEN_ID(mygen,-1) afterwards to set it back to 4”. This may work most of the time, but is unsafe because other concurrent transactions may have changed the value in between. For the

defined in that database to provide fine-grained access control to objects in that database. At no time does the user connecting to the database require direct access to the database file itself. All access escape from your server via a sophisticated data access interface and spending the considerable extra time it takes to develop an application using a less sophisticated access library. 4.1.2. “Leaking” by No encryption is used (usually), all steps of the code are there to be analysed by anyone with the time and knowledge and, indeed, there are decompilers available to assist with this process. Once a person

. . . . . . . . . . . . . . . . . . . . . . 66 Table of Contents 3 Chapter 1. What is NULL? Time and again, support questions pop up on the Firebird mailing lists about “strange things” happening many of us have found out to our chagrin, NULL is contagious: use it in a numerical, string or date/time operation, and the result will invariably be NULL. With boolean operators, the outcome depends on Number column, the result of the expression (and therefore your program flow) may still vary over time according to the absence or presence of NULLs in the column. Hours of debugging fun! Of course you

dyn_no_grant_admin_opt User %s has no grant admin option on SQL role %s -901 335544510 lock_timeout Lock time-out on wait transaction -901 336068798 dyn_user_not_role_member User %s is not a member of SQL role identifier_too_long BLR syntax error. Identifier %s... is too long -901 335544859 invalid_time_precision Time precision exceeds allowed range (0-%d) -901 336397211 dsql_too_many_values Too many values TEXT -902 335544724 net_event_connect_err Failed to establish a secondary connection for event processing. -902 335544725 net_event_listen_err Error while listening for an incoming event connection request

dyn_no_grant_admin_opt User @1 has no grant admin option on SQL role @2 -901 335544510 lock_timeout Lock time-out on wait transaction -901 336068798 dyn_user_not_role_member User @1 is not a member of SQL role identifier_too_long BLR syntax error. Identifier @1... is too long -901 335544859 invalid_time_precision Time precision exceeds allowed range (0-@1) -901 335544866 met_wrong_gtt_scope @1 cannot depend connection. -902 335544724 net_event_connect_err Failed to establish a secondary connection for event processing. -902 335544725 net_event_listen_err Error while listening for an incoming event connection request