. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 247 6.4.2. Example of UPDATE OR INSERT . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . values are stored as 64-bit integers, a Dialect 1 client request, SELECT GEN_ID (MyGen, 1), for example, will return the generator value truncated to 32 bits. • Dialect 2 is available only on the Firebird comments start with a pair of hyphen characters, -- and continue up to the end of the current line. Example CREATE PROCEDURE P(APARAM INT) RETURNS (B INT) AS BEGIN /* This text will be ignored during

. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 329 6.4.2. Example of UPDATE OR INSERT . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . values are stored as 64-bit integers, a Dialect 1 client request, SELECT GEN_ID (MyGen, 1), for example, will return the generator value truncated to 32 bits. • Dialect 2 is available only on the Firebird characters, -- and continue up to the end of the current line. Chapter 2. SQL Language Structure 24 Example CREATE PROCEDURE P(APARAM INT) RETURNS (B INT) AS BEGIN /* This text will be ignored during

file to perform database functions.  Because other applications in the Linux environment, for example, MySQL, also use isql as a utility name, you are advised to run the Firebird utility from its own distributions. In addition, not all distributions install Firebird to the same location. OpenSuse, for example, installs just about everything to /opt/firebird/n.n but Ubuntu and derivatives install it to a the bin is on your path, you may start it by typing isql regardless of your operating system. Example: $ isql Use CONNECT or CREATE DATABASE to specify a database SQL> CONNECT "C:\DATABASES\FIREBIRD\MY_EMPLOYEE

name — the gfix -⁠? output uses parentheses instead — then these are the optional characters. For example, the command -⁠validate is shown as -⁠v[alidate] and so can be specified as -⁠v, -⁠va, -⁠val and some commands will not work unless you supply -⁠u[ser] and -⁠pa[ssword] on the command line. For example: linux> gfix -validate my_employee linux> Unable to perform operation. You must be either SYSDBA following (contrived) example, shows what happens when the database loses a shadow file, and an attempt is made to connect to that database. There are two sessions in the following example, one is connected

minimum — the part before the opening '[' — you can use as much of what follows as you wish. For example, to use the -b[ackup_database] switch the minimum you must supply on the command line is -b but directly to a gbak restore operation to clone a database without needing an intermediate dump file. An example is given later in this manual. When carrying out a backup of a database, the following switches to create a backup then you can only restore the backup on a similar platform. You cannot, for example, take a dump file from Linux over to a Windows server. -OL[D_DESCRIPTIONS] This switch is unlikely

. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 24 8.3. A Worked Example. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . to the end of the database file(s) as and when the user creates new tables and/or indices. For example, a brand-new database, created on a 32-bit Linux system, with a 4Kb page size allocates a total The format of this word is the ODS major version ANDed with the Firebird flag of 0x8000. In the example below, the value is 0x800b for ODS version 11. The minor ODS version is held elsewhere in the header

systems — is a quick and easy way to see if you can connect to a server machine via the network. For example, if your server’s IP address in the domain that is visible to your client is 192.13.14.1, go to a command shell on the client machine and type the command ping 192.13.14.1 substituting this example IP address with the IP address that your server is broadcasting. If you are on a managed network immediately. Fire up isql or another Firebird client and connect to a database. In this example, the “employee” example database is used, because its alias is always present in a freshly installed Firebird

network. For example, if your server's IP address in the domain that is visible to your client is 192.13.14.1, go to a command shell and type the command ping 192.13.14.1 substituting this example IP address path. Its format is as follows: • For a Linux server: servername:/filesystem-path/database-file Example on a Linux or other Posix server named serverxyz: Firebird 1.0 Quick Start Guide 13 serverxyz ee.gdb • For a Windows server: servername:DriveLetter:\filesystem-path\database-file Windows example: serverxyz:C:\Program Files\Firebird\examples\employee.gdb The CONNECT statement Connecting to

systems – is a quick and easy way to see if you can connect to a server machine via the network. For example, if your server's IP address in the domain that is visible to your client is 192.13.14.1, go to a a command shell on the client machine and type the command ping 192.13.14.1 substituting this example IP address with the IP address that your server is broadcasting. If you are on a managed network to the Firebird bin subdirectory and issue the following command to change the password to (as an example) icuryy4me: gsec -user sysdba -pass masterkey -mo sysdba -pw icuryy4me Notice that you specify

not null select * from Pupils where not ( PhoneNumber is null ) /* does the same as the previous example */ Chapter 2. NULL support in Firebird SQL 6 update Numbers set Total = A + B + C where A + B index may be active even if it has not been created explicitly, namely if a key is defined on A. Example: Table TA has a column A with values { 3, 8 }. Table TB has a column B containing { 2, 8, 1, NULL you got it. So despite his 30 cows, our friend Fred won’t make it into the result set. As a last example, we shall rewrite the previous statement so that it will return any farm which has at least one