. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 336 6.6.2. Examples of MERGE. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 340 6.7.2. Examples of EXECUTE PROCEDURE . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 341 6.8.1. Examples. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .

. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 255 6.7.2. Examples of EXECUTE PROCEDURE . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 269 Table of Contents 6 7.6. Writing the Body Code . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . procedural language — procedural SQL (PSQL) — for stored procedures, triggers and dynamically-executable code blocks. These are the areas addressed in this volume. 1.2. Authorship The material for assembling

License) and the IDPL (Initial Developer's Public License). The first one covers the parts of the source code that were inherited from InterBase; the second applies to the additions and improvements made by the notices included with Firebird must remain intact. • You may modify and recompile the Firebird source code or parts of it. You may distribute such modified versions, but if you do so, you must document your make them publicly available, at no cost, under the same license as the original code. • You may include Firebird source code (modified or not) in a larger work and distribute that larger work, in source

License) and the IDPL (Initial Developer’s Public License). The first one covers the parts of the source code that were inherited from InterBase; the second applies to the additions and improvements made by notices included with Firebird must remain intact. • You may modify and recompile the Firebird source code or parts of it. You may distribute such modified versions, but if you do so, you must document your them publicly available, at no cost, under the same license as the original code. • You may include Firebird source code (modified or not) in a larger work and distribute that larger work, in source

illogical results you can get with NULL will practically explain themselves.  A few sentences and examples in this guide were taken from the Firebird Quick Start Guide, first published by IBPhoenix, now variable, field or other expression is NULL, use the following syntax: IS [NOT] NULL Examples: if ( MyField is null ) then YourString = 'Dunno' select * from Pupils where PhoneNumber is not or false, never NULL or something else. With earlier Firebird versions, you have to write special code to obtain the same information. This will be discussed later. 2.5. The NULL literal The ability

utility to bail on error, but only when used in a non-interactive mode. The switch returns an error code to the Operating System. This switch was added to prevent isql from executing scripts after an error error has been detected. No further statements will be executed and isql will return an error code to the OS. Users still need to use the -e(cho) switch to echo commands to an output file, to isolate 13 Chapter 8. Connecting To A Database A sample database named employee.fdb is located in the examples/empbuild subdirectory of your Firebird installation. Users can use this database to experiment

be "suppress_output" rather than "suppress". This is an error in the documentation as the source code for gbak shows that the switch must be "suppress".  The log file must not exist. If it does, the the current version of gbak, and after displaying a couple of error messages, exits with an error code of 1 as shown above by the echo command. This method does not attempt to backup any databases and environment variables ISC_USER and ISC_PASSWORD. This version of the command will exit with a error code of zero.  This method of calling gbak will make a backup of the database. If your database is

les emplacements disque par défaut pour les composants sous Windows et Linux. Avec la révision de code importante commencée avec la version 1.5, les anciens liens vers les équivalents InterBase® ont été gbak.exe, gfix.exe, gstat.exe, etc. \bin Base example employee.fdb \ examples Bibliothèques utilisateurs (UDF) ib_udf.dll & fbudf. dll \UDF 32-bit et 64-bit Windows de com- mande gbak, gfix, gstat, etc. /bin Base example employee.fdb / examples Bibliothèques utilisateurs (UDF) ib_udf.so, fbudf.so /UDF Linux et autres UNIX Client

Windows client to access a Linux server and vice-versa. Connecting to the sample database In the examples subdirectory of your Firebird installation is a sample database named employ- ee.gdb. You can use serverxyz:/opt/interbase/examples/employee.gdb • For a Windows server: servername:DriveLetter:\filesystem-path\database-file Windows example: serverxyz:C:\Program Files\Firebird\examples\employee.gdb The ql# Use CONNECT or CREATE DATABASE to specify a database SQL>CONNECT "C:\Program Files\Firebird\examples\employee.gdb"# CON>user 'SYSDBA' password 'masterkey';# Important • In isql, every SQL statement

.................................................................... 27 Installation Structure Examples ............................................................................................. 28 underlying table), the operation was done twice: once executing the view's trigger code and again executing the table's trigger code. This situation caused performance problems or exceptions, particularly if blobs DML operation will take place in that table Known Compatibility Issues 4 Important Some existing code may depend on the assumption that requesting a DML operation on an updatable view with triggers defined