Java 1.2 How-To

home *** CD-ROM | disk | FTP | other *** search
/ Java 1.2 How-To / JavaHowTo.iso / 3rdParty / jbuilder / TRIAL / WINCLNT / DATA.Z / employee.gbk < prev next >
Unknown | 1998-03-15 | 71.5 KB
open in:
MacOS 8.1 |
Win98 |
DOS
view JSON data |
view as text

This file was not able to be converted.
This format is not currently supported by dexvert.
Confidence	Program	Detection	Match Type	Support
`10%`	dexvert	Degas High Resolution Picture (PI) `(image/degasHiPI)`	magic	Supported
`100%`	file	Atari DEGAS Elite bitmap 640 x 400 x 2, color palette 0405 0000 0004 0401 0000 ...	default (weak)
`99%`	file	data	default
`100%`	TrID	DEGAS hi-res bitmap	default (weak)
hex view
+--------+-------------------------+-------------------------+--------+--------+
|00000000| 00 02 04 05 00 00 00 04 | 04 01 00 00 00 05 04 01 |........|........|
|00000010| 00 00 00 06 04 00 20 00 | 00 08 04 01 00 00 00 07 |...... .|........|
|00000020| 0c 65 6d 70 6c 6f 79 65 | 65 2e 67 64 62 01 18 57 |.employe|e.gdb..W|
|00000030| 65 64 20 4d 61 72 20 30 | 34 20 31 36 3a 34 36 3a |ed Mar 0|4 16:46:|
|00000040| 33 36 20 31 39 39 38 00 | 0e 05 04 00 04 00 00 08 |36 1998.|........|
|00000050| 04 20 4e 00 00 0c 04 01 | 00 00 00 01 0c 65 6d 70 |. N.....|.....emp|
|00000060| 6c 6f 79 65 65 2e 67 64 | 62 00 01 00 02 01 09 46 |loyee.gd|b......F|
|00000070| 49 52 53 54 4e 41 4d 45 | 05 00 07 00 08 04 25 00 |IRSTNAME|......%.|
|00000080| 00 00 0a 04 0f 00 00 00 | 09 04 00 00 00 00 0b 04 |........|........|
|00000090| 00 00 00 00 29 04 0f 00 | 00 00 2a 04 00 00 00 00 |....)...|..*.....|
|000000a0| 2b 04 00 00 00 00 00 02 | 01 08 4c 41 53 54 4e 41 |+.......|..LASTNA|
|000000b0| 4d 45 05 00 07 00 08 04 | 25 00 00 00 0a 04 14 00 |ME......|%.......|
|000000c0| 00 00 09 04 00 00 00 00 | 0b 04 00 00 00 00 29 04 |........|......).|
|000000d0| 14 00 00 00 2a 04 00 00 | 00 00 2b 04 00 00 00 00 |....*...|..+.....|
|000000e0| 00 02 01 0b 50 48 4f 4e | 45 4e 55 4d 42 45 52 05 |....PHON|ENUMBER.|
|000000f0| 00 07 00 08 04 25 00 00 | 00 0a 04 14 00 00 00 09 |.....%..|........|
|00000100| 04 00 00 00 00 0b 04 00 | 00 00 00 29 04 14 00 00 |........|...)....|
|00000110| 00 2a 04 00 00 00 00 2b | 04 00 00 00 00 00 02 01 |.*.....+|........|
|00000120| 0b 43 4f 55 4e 54 52 59 | 4e 41 4d 45 05 00 07 00 |.COUNTRY|NAME....|
|00000130| 08 04 25 00 00 00 0a 04 | 0f 00 00 00 09 04 00 00 |..%.....|........|
|00000140| 00 00 0b 04 00 00 00 00 | 29 04 0f 00 00 00 2a 04 |........|).....*.|
|00000150| 00 00 00 00 2b 04 00 00 | 00 00 00 02 01 0b 41 44 |....+...|......AD|
|00000160| 44 52 45 53 53 4c 49 4e | 45 05 00 07 00 08 04 25 |DRESSLIN|E......%|
|00000170| 00 00 00 0a 04 1e 00 00 | 00 09 04 00 00 00 00 0b |........|........|
|00000180| 04 00 00 00 00 29 04 1e | 00 00 00 2a 04 00 00 00 |.....)..|...*....|
|00000190| 00 2b 04 00 00 00 00 00 | 02 01 05 45 4d 50 4e 4f |.+......|...EMPNO|
|000001a0| 05 00 07 00 08 04 07 00 | 00 00 0a 04 02 00 00 00 |........|........|
|000001b0| 09 04 00 00 00 00 0b 04 | 00 00 00 00 00 02 01 06 |........|........|
|000001c0| 44 45 50 54 4e 4f 05 00 | 07 00 08 04 0e 00 00 00 |DEPTNO..|........|
|000001d0| 0a 04 03 00 00 00 09 04 | 00 00 00 00 0b 04 00 00 |........|........|
|000001e0| 00 00 14 04 32 00 00 00 | 04 39 39 2f 18 00 00 00 |....2...|.99/....|
|000001f0| 15 0f 7f 00 03 00 30 30 | 30 3a 31 18 00 00 00 15 |......00|0:1.....|
|00000200| 0f 7f 00 01 00 30 34 18 | 00 00 00 15 0f 7f 00 03 |.....04.|........|
|00000210| 00 39 39 39 3d 18 00 00 | 00 4c 24 04 4b 00 00 00 |.999=...|.L$.K...|
|00000220| 43 48 45 43 4b 20 28 56 | 41 4c 55 45 20 3d 20 27 |CHECK (V|ALUE = '|
|00000230| 30 30 30 27 20 4f 52 20 | 28 56 41 4c 55 45 20 3e |000' OR |(VALUE >|
|00000240| 20 27 30 27 20 41 4e 44 | 20 56 41 4c 55 45 20 3c | '0' AND| VALUE <|
|00000250| 3d 20 27 39 39 39 27 29 | 20 4f 52 20 56 41 4c 55 |= '999')| OR VALU|
|00000260| 45 20 49 53 20 4e 55 4c | 4c 29 00 29 04 03 00 00 |E IS NUL|L).)....|
|00000270| 00 2a 04 00 00 00 00 2b | 04 00 00 00 00 00 02 01 |.*.....+|........|
|00000280| 06 50 52 4f 4a 4e 4f 05 | 00 07 00 08 04 0e 00 00 |.PROJNO.|........|
|00000290| 00 0a 04 05 00 00 00 09 | 04 00 00 00 00 0b 04 00 |........|........|
|000002a0| 00 00 00 14 04 0c 00 00 | 00 04 2f 18 00 00 00 67 |........|../....g|
|000002b0| 18 00 00 00 4c 24 04 1e | 00 00 00 43 48 45 43 4b |....L$..|...CHECK|
|000002c0| 20 28 56 41 4c 55 45 20 | 3d 20 55 50 50 45 52 20 | (VALUE |= UPPER |
|000002d0| 28 56 41 4c 55 45 29 29 | 00 29 04 05 00 00 00 2a |(VALUE))|.).....*|
|000002e0| 04 00 00 00 00 2b 04 00 | 00 00 00 00 02 01 06 43 |.....+..|.......C|
|000002f0| 55 53 54 4e 4f 05 00 07 | 00 08 04 08 00 00 00 0a |USTNO...|........|
|00000300| 04 04 00 00 00 09 04 00 | 00 00 00 0b 04 00 00 00 |........|........|
|00000310| 00 14 04 0e 00 00 00 04 | 31 18 00 00 00 15 08 00 |........|1.......|
|00000320| e8 03 00 00 4c 24 04 15 | 00 00 00 43 48 45 43 4b |....L$..|...CHECK|
|00000330| 20 28 56 41 4c 55 45 20 | 3e 20 31 30 30 30 29 00 | (VALUE |> 1000).|
|00000340| 00 02 01 07 4a 4f 42 43 | 4f 44 45 05 00 07 00 08 |....JOBC|ODE.....|
|00000350| 04 25 00 00 00 0a 04 05 | 00 00 00 09 04 00 00 00 |.%......|........|
|00000360| 00 0b 04 00 00 00 00 14 | 04 12 00 00 00 04 31 18 |........|......1.|
|00000370| 00 00 00 15 0f 7f 00 05 | 00 39 39 39 39 39 4c 24 |........|.99999L$|
|00000380| 04 18 00 00 00 43 48 45 | 43 4b 20 28 56 41 4c 55 |.....CHE|CK (VALU|
|00000390| 45 20 3e 20 27 39 39 39 | 39 39 27 29 00 29 04 05 |E > '999|99').)..|
|000003a0| 00 00 00 2a 04 00 00 00 | 00 2b 04 00 00 00 00 00 |...*....|.+......|
|000003b0| 02 01 08 4a 4f 42 47 52 | 41 44 45 05 00 07 00 08 |...JOBGR|ADE.....|
|000003c0| 04 07 00 00 00 0a 04 02 | 00 00 00 09 04 00 00 00 |........|........|
|000003d0| 00 0b 04 00 00 00 00 14 | 04 15 00 00 00 04 38 18 |........|......8.|
|000003e0| 00 00 00 15 08 00 00 00 | 00 00 15 08 00 06 00 00 |........|........|
|000003f0| 00 4c 24 04 1e 00 00 00 | 43 48 45 43 4b 20 28 56 |.L$.....|CHECK (V|
|00000400| 41 4c 55 45 20 42 45 54 | 57 45 45 4e 20 30 20 41 |ALUE BET|WEEN 0 A|
|00000410| 4e 44 20 36 29 00 00 02 | 01 06 53 41 4c 41 52 59 |ND 6)...|..SALARY|
|00000420| 05 00 07 00 08 04 1b 00 | 00 00 0a 04 08 00 00 00 |........|........|
|00000430| 09 04 00 00 00 00 0b 04 | fe ff ff ff 0f 04 09 00 |........|........|
|00000440| 00 00 04 15 08 00 00 00 | 00 00 4c 14 04 0e 00 00 |........|..L.....|
|00000450| 00 04 31 18 00 00 00 15 | 08 00 00 00 00 00 4c 24 |..1.....|......L$|
|00000460| 04 12 00 00 00 43 48 45 | 43 4b 20 28 56 41 4c 55 |.....CHE|CK (VALU|
|00000470| 45 20 3e 20 30 29 00 27 | 04 0a 00 00 00 44 45 46 |E > 0).'|.....DEF|
|00000480| 41 55 4c 54 20 30 00 00 | 02 01 06 42 55 44 47 45 |AULT 0..|...BUDGE|
|00000490| 54 05 00 07 00 08 04 1b | 00 00 00 0a 04 08 00 00 |T.......|........|
|000004a0| 00 09 04 00 00 00 00 0b | 04 fe ff ff ff 0f 04 09 |........|........|
|000004b0| 00 00 00 04 15 08 00 50 | c3 00 00 4c 14 04 1b 00 |.......P|...L....|
|000004c0| 00 00 04 3a 31 18 00 00 | 00 15 08 00 10 27 00 00 |...:1...|.....'..|
|000004d0| 34 18 00 00 00 15 08 00 | 80 84 1e 00 4c 24 04 2b |4.......|....L$.+|
|000004e0| 00 00 00 43 48 45 43 4b | 20 28 56 41 4c 55 45 20 |...CHECK| (VALUE |
|000004f0| 3e 20 31 30 30 30 30 20 | 41 4e 44 20 56 41 4c 55 |> 10000 |AND VALU|
|00000500| 45 20 3c 3d 20 32 30 30 | 30 30 30 30 29 00 27 04 |E <= 200|0000).'.|
|00000510| 0e 00 00 00 44 45 46 41 | 55 4c 54 20 35 30 30 30 |....DEFA|ULT 5000|
|00000520| 30 00 00 02 01 08 50 52 | 4f 44 54 59 50 45 05 00 |0.....PR|ODTYPE..|
|00000530| 07 00 08 04 25 00 00 00 | 0a 04 0c 00 00 00 09 04 |....%...|........|
|00000540| 00 00 00 00 0b 04 00 00 | 00 00 0f 04 10 00 00 00 |........|........|
|00000550| 04 15 0f 7f 00 08 00 73 | 6f 66 74 77 61 72 65 4c |.......s|oftwareL|
|00000560| 14 04 49 00 00 00 04 39 | 39 39 2f 18 00 00 00 15 |..I....9|99/.....|
|00000570| 0f 7f 00 08 00 73 6f 66 | 74 77 61 72 65 2f 18 00 |.....sof|tware/..|
|00000580| 00 00 15 0f 7f 00 08 00 | 68 61 72 64 77 61 72 65 |........|hardware|
|00000590| 2f 18 00 00 00 15 0f 7f | 00 05 00 6f 74 68 65 72 |/.......|...other|
|000005a0| 2f 18 00 00 00 15 0f 7f | 00 03 00 4e 2f 41 4c 24 |/.......|...N/AL$|
|000005b0| 04 3a 00 00 00 43 48 45 | 43 4b 20 28 56 41 4c 55 |.:...CHE|CK (VALU|
|000005c0| 45 20 49 4e 20 28 27 73 | 6f 66 74 77 61 72 65 27 |E IN ('s|oftware'|
|000005d0| 2c 20 27 68 61 72 64 77 | 61 72 65 27 2c 20 27 6f |, 'hardw|are', 'o|
|000005e0| 74 68 65 72 27 2c 20 27 | 4e 2f 41 27 29 29 00 26 |ther', '|N/A')).&|
|000005f0| 04 01 00 00 00 29 04 0c | 00 00 00 27 04 13 00 00 |.....)..|...'....|
|00000600| 00 44 45 46 41 55 4c 54 | 20 27 73 6f 66 74 77 61 |.DEFAULT| 'softwa|
|00000610| 72 65 27 00 2a 04 00 00 | 00 00 2b 04 00 00 00 00 |re'.*...|..+.....|
|00000620| 00 02 01 08 50 4f 4e 55 | 4d 42 45 52 05 00 07 00 |....PONU|MBER....|
|00000630| 08 04 0e 00 00 00 0a 04 | 08 00 00 00 09 04 00 00 |........|........|
|00000640| 00 00 0b 04 00 00 00 00 | 14 04 0e 00 00 00 04 37 |........|.......7|
|00000650| 18 00 00 00 15 0f 7f 00 | 01 00 56 4c 24 04 20 00 |........|..VL$. .|
|00000660| 00 00 43 48 45 43 4b 20 | 28 56 41 4c 55 45 20 53 |..CHECK |(VALUE S|
|00000670| 54 41 52 54 49 4e 47 20 | 57 49 54 48 20 27 56 27 |TARTING |WITH 'V'|
|00000680| 29 00 29 04 08 00 00 00 | 2a 04 00 00 00 00 2b 04 |).).....|*.....+.|
|00000690| 00 00 00 00 00 02 01 05 | 52 44 42 24 31 05 00 07 |........|RDB$1...|
|000006a0| 00 08 04 25 00 00 00 0a | 04 0a 00 00 00 09 04 00 |...%....|........|
|000006b0| 00 00 00 0b 04 00 00 00 | 00 29 04 0a 00 00 00 2a |........|.).....*|
|000006c0| 04 00 00 00 00 00 02 01 | 05 52 44 42 24 32 05 00 |........|.RDB$2..|
|000006d0| 07 00 08 04 25 00 00 00 | 0a 04 19 00 00 00 09 04 |....%...|........|
|000006e0| 00 00 00 00 0b 04 00 00 | 00 00 29 04 19 00 00 00 |........|..).....|
|000006f0| 2a 04 00 00 00 00 00 02 | 01 05 52 44 42 24 33 05 |*.......|..RDB$3.|
|00000700| 00 07 00 08 04 05 01 00 | 00 0a 04 08 00 00 00 09 |........|........|
|00000710| 04 01 00 00 00 0b 04 00 | 00 00 00 0c 04 90 01 00 |........|........|
|00000720| 00 2a 04 00 00 00 00 00 | 02 01 05 52 44 42 24 34 |.*......|...RDB$4|
|00000730| 05 00 07 00 08 04 25 00 | 00 00 0a 04 0f 00 00 00 |......%.|........|
|00000740| 09 04 00 00 00 00 0b 04 | 00 00 00 00 1d 04 01 00 |........|........|
|00000750| 00 00 29 04 0f 00 00 00 | 2a 04 00 00 00 00 00 02 |..).....|*.......|
|00000760| 01 05 52 44 42 24 35 05 | 00 07 00 08 04 25 00 00 |..RDB$5.|.....%..|
|00000770| 00 0a 04 19 00 00 00 09 | 04 00 00 00 00 0b 04 00 |........|........|
|00000780| 00 00 00 29 04 19 00 00 | 00 2a 04 00 00 00 00 00 |...)....|.*......|
|00000790| 02 01 05 52 44 42 24 36 | 05 00 07 00 08 04 25 00 |...RDB$6|......%.|
|000007a0| 00 00 0a 04 0f 00 00 00 | 09 04 00 00 00 00 0b 04 |........|........|
|000007b0| 00 00 00 00 29 04 0f 00 | 00 00 2a 04 00 00 00 00 |....)...|..*.....|
|000007c0| 00 02 01 05 52 44 42 24 | 37 05 00 07 00 08 04 25 |....RDB$|7......%|
|000007d0| 00 00 00 0a 04 04 00 00 | 00 09 04 00 00 00 00 0b |........|........|
|000007e0| 04 00 00 00 00 29 04 04 | 00 00 00 2a 04 00 00 00 |.....)..|...*....|
|000007f0| 00 00 02 01 05 52 44 42 | 24 38 05 00 07 00 08 04 |.....RDB|$8......|
|00000800| 23 00 00 00 0a 04 08 00 | 00 00 09 04 00 00 00 00 |#.......|........|
|00000810| 0b 04 00 00 00 00 00 02 | 01 05 52 44 42 24 39 05 |........|..RDB$9.|
|00000820| 00 07 00 08 04 25 00 00 | 00 0a 04 25 00 00 00 09 |.....%..|...%....|
|00000830| 04 00 00 00 00 0b 04 00 | 00 00 00 12 04 25 00 00 |........|.....%..|
|00000840| 00 04 27 27 17 00 09 4c | 41 53 54 5f 4e 41 4d 45 |..''...L|AST_NAME|
|00000850| 15 0f 7f 00 02 00 2c 20 | 17 00 0a 46 49 52 53 54 |......, |...FIRST|
|00000860| 5f 4e 41 4d 45 4c 25 04 | 22 00 00 00 28 6c 61 73 |_NAMEL%.|"...(las|
|00000870| 74 5f 6e 61 6d 65 20 7c | 7c 20 27 2c 20 27 20 7c |t_name ||| ', ' ||
|00000880| 7c 20 66 69 72 73 74 5f | 6e 61 6d 65 29 00 29 04 || first_|name).).|
|00000890| 00 00 00 00 2a 04 00 00 | 00 00 00 02 01 06 52 44 |....*...|......RD|
|000008a0| 42 24 31 30 05 00 07 00 | 08 04 25 00 00 00 0a 04 |B$10....|..%.....|
|000008b0| 14 00 00 00 09 04 00 00 | 00 00 0b 04 00 00 00 00 |........|........|
|000008c0| 29 04 14 00 00 00 2a 04 | 00 00 00 00 00 02 01 06 |).....*.|........|
|000008d0| 52 44 42 24 31 31 05 00 | 07 00 08 04 05 01 00 00 |RDB$11..|........|
|000008e0| 0a 04 08 00 00 00 09 04 | 01 00 00 00 0b 04 00 00 |........|........|
|000008f0| 00 00 0c 04 20 03 00 00 | 2a 04 00 00 00 00 00 02 |.... ...|*.......|
|00000900| 01 06 52 44 42 24 31 32 | 05 00 07 00 08 04 08 00 |..RDB$12|........|
|00000910| 00 00 0a 04 04 00 00 00 | 09 04 00 00 00 00 0b 04 |........|........|
|00000920| 00 00 00 00 00 02 01 06 | 52 44 42 24 31 33 05 00 |........|RDB$13..|
|00000930| 07 00 08 04 08 00 00 00 | 0a 04 04 00 00 00 09 04 |........|........|
|00000940| 00 00 00 00 0b 04 00 00 | 00 00 1d 04 01 00 00 00 |........|........|
|00000950| 00 02 01 06 52 44 42 24 | 31 34 05 00 07 00 08 04 |....RDB$|14......|
|00000960| 23 00 00 00 0a 04 08 00 | 00 00 09 04 00 00 00 00 |#.......|........|
|00000970| 0b 04 00 00 00 00 00 02 | 01 06 52 44 42 24 31 35 |........|..RDB$15|
|00000980| 05 00 07 00 08 04 25 00 | 00 00 0a 04 14 00 00 00 |......%.|........|
|00000990| 09 04 00 00 00 00 0b 04 | 00 00 00 00 29 04 14 00 |........|....)...|
|000009a0| 00 00 2a 04 00 00 00 00 | 00 02 01 06 52 44 42 24 |..*.....|....RDB$|
|000009b0| 31 36 05 00 07 00 08 04 | 1b 00 00 00 0a 04 08 00 |16......|........|
|000009c0| 00 00 09 04 00 00 00 00 | 0b 04 00 00 00 00 00 02 |........|........|
|000009d0| 01 06 52 44 42 24 31 37 | 05 00 07 00 08 04 1b 00 |..RDB$17|........|
|000009e0| 00 00 0a 04 08 00 00 00 | 09 04 00 00 00 00 0b 04 |........|........|
|000009f0| 00 00 00 00 12 04 37 00 | 00 00 04 22 17 00 0a 4f |......7.|..."...O|
|00000a00| 4c 44 5f 53 41 4c 41 52 | 59 25 24 17 00 0a 4f 4c |LD_SALAR|Y%$...OL|
|00000a10| 44 5f 53 41 4c 41 52 59 | 17 00 0e 50 45 52 43 45 |D_SALARY|...PERCE|
|00000a20| 4e 54 5f 43 48 41 4e 47 | 45 15 08 00 64 00 00 00 |NT_CHANG|E...d...|
|00000a30| 4c 25 04 31 00 00 00 28 | 6f 6c 64 5f 73 61 6c 61 |L%.1...(|old_sala|
|00000a40| 72 79 20 2b 20 6f 6c 64 | 5f 73 61 6c 61 72 79 20 |ry + old|_salary |
|00000a50| 2a 20 70 65 72 63 65 6e | 74 5f 63 68 61 6e 67 65 |* percen|t_change|
|00000a60| 20 2f 20 31 30 30 29 00 | 00 02 01 06 52 44 42 24 | / 100).|....RDB$|
|00000a70| 31 38 05 00 07 00 08 04 | 25 00 00 00 0a 04 19 00 |18......|%.......|
|00000a80| 00 00 09 04 00 00 00 00 | 0b 04 00 00 00 00 29 04 |........|......).|
|00000a90| 19 00 00 00 2a 04 00 00 | 00 00 00 02 01 06 52 44 |....*...|......RD|
|00000aa0| 42 24 31 39 05 00 07 00 | 08 04 25 00 00 00 0a 04 |B$19....|..%.....|
|00000ab0| 19 00 00 00 09 04 00 00 | 00 00 0b 04 00 00 00 00 |........|........|
|00000ac0| 29 04 19 00 00 00 2a 04 | 00 00 00 00 00 02 01 06 |).....*.|........|
|00000ad0| 52 44 42 24 32 30 05 00 | 07 00 08 04 25 00 00 00 |RDB$20..|....%...|
|00000ae0| 0a 04 0f 00 00 00 09 04 | 00 00 00 00 0b 04 00 00 |........|........|
|00000af0| 00 00 29 04 0f 00 00 00 | 2a 04 00 00 00 00 00 02 |..).....|*.......|
|00000b00| 01 06 52 44 42 24 32 31 | 05 00 07 00 08 04 25 00 |..RDB$21|......%.|
|00000b10| 00 00 0a 04 0c 00 00 00 | 09 04 00 00 00 00 0b 04 |........|........|
|00000b20| 00 00 00 00 29 04 0c 00 | 00 00 2a 04 00 00 00 00 |....)...|..*.....|
|00000b30| 00 02 01 06 52 44 42 24 | 32 32 05 00 07 00 08 04 |....RDB$|22......|
|00000b40| 0e 00 00 00 0a 04 01 00 | 00 00 09 04 00 00 00 00 |........|........|
|00000b50| 0b 04 00 00 00 00 29 04 | 01 00 00 00 2a 04 00 00 |......).|....*...|
|00000b60| 00 00 00 02 01 06 52 44 | 42 24 32 33 05 00 07 00 |......RD|B$23....|
|00000b70| 08 04 25 00 00 00 0a 04 | 07 00 00 00 09 04 00 00 |..%.....|........|
|00000b80| 00 00 0b 04 00 00 00 00 | 29 04 07 00 00 00 2a 04 |........|).....*.|
|00000b90| 00 00 00 00 00 02 01 06 | 52 44 42 24 32 34 05 00 |........|RDB$24..|
|00000ba0| 07 00 08 04 23 00 00 00 | 0a 04 08 00 00 00 09 04 |....#...|........|
|00000bb0| 00 00 00 00 0b 04 00 00 | 00 00 00 02 01 06 52 44 |........|......RD|
|00000bc0| 42 24 32 35 05 00 07 00 | 08 04 23 00 00 00 0a 04 |B$25....|..#.....|
|00000bd0| 08 00 00 00 09 04 00 00 | 00 00 0b 04 00 00 00 00 |........|........|
|00000be0| 00 02 01 06 52 44 42 24 | 32 36 05 00 07 00 08 04 |....RDB$|26......|
|00000bf0| 23 00 00 00 0a 04 08 00 | 00 00 09 04 00 00 00 00 |#.......|........|
|00000c00| 0b 04 00 00 00 00 00 02 | 01 06 52 44 42 24 32 37 |........|..RDB$27|
|00000c10| 05 00 07 00 08 04 0e 00 | 00 00 0a 04 01 00 00 00 |........|........|
|00000c20| 09 04 00 00 00 00 0b 04 | 00 00 00 00 29 04 01 00 |........|....)...|
|00000c30| 00 00 2a 04 00 00 00 00 | 00 02 01 06 52 44 42 24 |..*.....|....RDB$|
|00000c40| 32 38 05 00 07 00 08 04 | 08 00 00 00 0a 04 04 00 |28......|........|
|00000c50| 00 00 09 04 00 00 00 00 | 0b 04 00 00 00 00 00 02 |........|........|
|00000c60| 01 06 52 44 42 24 32 39 | 05 00 07 00 08 04 08 00 |..RDB$29|........|
|00000c70| 00 00 0a 04 04 00 00 00 | 09 04 00 00 00 00 0b 04 |........|........|
|00000c80| fe ff ff ff 00 02 01 06 | 52 44 42 24 33 30 05 00 |........|RDB$30..|
|00000c90| 07 00 08 04 0a 00 00 00 | 0a 04 04 00 00 00 09 04 |........|........|
|00000ca0| 00 00 00 00 0b 04 00 00 | 00 00 00 02 01 06 52 44 |........|......RD|
|00000cb0| 42 24 33 31 05 00 07 00 | 08 04 1b 00 00 00 0a 04 |B$31....|........|
|00000cc0| 08 00 00 00 09 04 00 00 | 00 00 0b 04 00 00 00 00 |........|........|
|00000cd0| 12 04 1c 00 00 00 04 23 | 17 00 09 53 48 49 50 5f |.......#|...SHIP_|
|00000ce0| 44 41 54 45 17 00 0a 4f | 52 44 45 52 5f 44 41 54 |DATE...O|RDER_DAT|
|00000cf0| 45 4c 25 04 19 00 00 00 | 28 73 68 69 70 5f 64 61 |EL%.....|(ship_da|
|00000d00| 74 65 20 2d 20 6f 72 64 | 65 72 5f 64 61 74 65 29 |te - ord|er_date)|
|00000d10| 00 00 02 01 06 52 44 42 | 24 33 32 05 00 07 00 08 |.....RDB|$32.....|
|00000d20| 04 07 00 00 00 0a 04 02 | 00 00 00 09 04 00 00 00 |........|........|
|00000d30| 00 0b 04 00 00 00 00 00 | 02 01 06 52 44 42 24 33 |........|...RDB$3|
|00000d40| 33 05 00 07 00 08 04 0e | 00 00 00 0a 04 05 00 00 |3.......|........|
|00000d50| 00 09 04 00 00 00 00 0b | 04 00 00 00 00 29 04 05 |........|.....)..|
|00000d60| 00 00 00 2a 04 00 00 00 | 00 2b 04 00 00 00 00 00 |...*....|.+......|
|00000d70| 02 01 06 52 44 42 24 33 | 34 05 00 07 00 08 04 07 |...RDB$3|4.......|
|00000d80| 00 00 00 0a 04 02 00 00 | 00 09 04 00 00 00 00 0b |........|........|
|00000d90| 04 00 00 00 00 00 02 01 | 06 52 44 42 24 33 35 05 |........|.RDB$35.|
|00000da0| 00 07 00 08 04 0e 00 00 | 00 0a 04 05 00 00 00 09 |........|........|
|00000db0| 04 00 00 00 00 0b 04 00 | 00 00 00 29 04 05 00 00 |........|...)....|
|00000dc0| 00 2a 04 00 00 00 00 2b | 04 00 00 00 00 00 02 01 |.*.....+|........|
|00000dd0| 06 52 44 42 24 33 36 05 | 00 07 00 08 04 0e 00 00 |.RDB$36.|........|
|00000de0| 00 0a 04 03 00 00 00 09 | 04 00 00 00 00 0b 04 00 |........|........|
|00000df0| 00 00 00 29 04 03 00 00 | 00 2a 04 00 00 00 00 2b |...)....|.*.....+|
|00000e00| 04 00 00 00 00 00 02 01 | 06 52 44 42 24 33 37 05 |........|.RDB$37.|
|00000e10| 00 07 00 08 04 1b 00 00 | 00 0a 04 08 00 00 00 09 |........|........|
|00000e20| 04 00 00 00 00 0b 04 fe | ff ff ff 00 02 01 06 52 |........|.......R|
|00000e30| 44 42 24 33 38 05 00 07 | 00 08 04 1b 00 00 00 0a |DB$38...|........|
|00000e40| 04 08 00 00 00 09 04 00 | 00 00 00 0b 04 fe ff ff |........|........|
|00000e50| ff 00 02 01 06 52 44 42 | 24 33 39 05 00 07 00 08 |.....RDB|$39.....|
|00000e60| 04 1b 00 00 00 0a 04 08 | 00 00 00 09 04 00 00 00 |........|........|
|00000e70| 00 0b 04 fe ff ff ff 00 | 02 01 06 52 44 42 24 34 |........|...RDB$4|
|00000e80| 30 05 00 07 00 08 04 1b | 00 00 00 0a 04 08 00 00 |0.......|........|
|00000e90| 00 09 04 00 00 00 00 0b | 04 fe ff ff ff 00 02 01 |........|........|
|00000ea0| 06 52 44 42 24 34 31 05 | 00 07 00 08 04 08 00 00 |.RDB$41.|........|
|00000eb0| 00 0a 04 04 00 00 00 09 | 04 00 00 00 00 0b 04 00 |........|........|
|00000ec0| 00 00 00 00 02 01 06 52 | 44 42 24 34 32 05 00 07 |.......R|DB$42...|
|00000ed0| 00 08 04 0e 00 00 00 0a | 04 03 00 00 00 09 04 00 |........|........|
|00000ee0| 00 00 00 0b 04 00 00 00 | 00 29 04 03 00 00 00 2a |........|.).....*|
|00000ef0| 04 00 00 00 00 2b 04 00 | 00 00 00 00 02 01 06 52 |.....+..|.......R|
|00000f00| 44 42 24 34 33 05 00 07 | 00 08 04 1b 00 00 00 0a |DB$43...|........|
|00000f10| 04 08 00 00 00 09 04 00 | 00 00 00 0b 04 fe ff ff |........|........|
|00000f20| ff 00 02 01 06 52 44 42 | 24 34 34 05 00 07 00 08 |.....RDB|$44.....|
|00000f30| 04 0e 00 00 00 0a 04 19 | 00 00 00 09 04 00 00 00 |........|........|
|00000f40| 00 0b 04 00 00 00 00 29 | 04 19 00 00 00 2a 04 00 |.......)|.....*..|
|00000f50| 00 00 00 2b 04 00 00 00 | 00 00 02 01 06 52 44 42 |...+....|.....RDB|
|00000f60| 24 34 35 05 00 07 00 08 | 04 0e 00 00 00 0a 04 19 |$45.....|........|
|00000f70| 00 00 00 09 04 00 00 00 | 00 0b 04 00 00 00 00 29 |........|.......)|
|00000f80| 04 19 00 00 00 2a 04 00 | 00 00 00 2b 04 00 00 00 |.....*..|...+....|
|00000f90| 00 00 02 01 06 52 44 42 | 24 34 36 05 00 07 00 08 |.....RDB|$46.....|
|00000fa0| 04 0e 00 00 00 0a 04 14 | 00 00 00 09 04 00 00 00 |........|........|
|00000fb0| 00 0b 04 00 00 00 00 29 | 04 14 00 00 00 2a 04 00 |.......)|.....*..|
|00000fc0| 00 00 00 2b 04 00 00 00 | 00 00 02 01 06 52 44 42 |...+....|.....RDB|
|00000fd0| 24 34 37 05 00 07 00 08 | 04 0e 00 00 00 0a 04 05 |$47.....|........|
|00000fe0| 00 00 00 09 04 00 00 00 | 00 0b 04 00 00 00 00 29 |........|.......)|
|00000ff0| 04 05 00 00 00 2a 04 00 | 00 00 00 2b 04 00 00 00 |.....*..|...+....|
|00001000| 00 00 02 01 06 52 44 42 | 24 34 38 05 00 07 00 08 |.....RDB|$48.....|
|00001010| 04 08 00 00 00 0a 04 04 | 00 00 00 09 04 00 00 00 |........|........|
|00001020| 00 0b 04 00 00 00 00 00 | 02 01 06 52 44 42 24 34 |........|...RDB$4|
|00001030| 39 05 00 07 00 08 04 08 | 00 00 00 0a 04 04 00 00 |9.......|........|
|00001040| 00 09 04 00 00 00 00 0b | 04 00 00 00 00 00 02 01 |........|........|
|00001050| 06 52 44 42 24 35 30 05 | 00 07 00 08 04 0e 00 00 |.RDB$50.|........|
|00001060| 00 0a 04 28 00 00 00 09 | 04 00 00 00 00 0b 04 00 |...(....|........|
|00001070| 00 00 00 29 04 28 00 00 | 00 2a 04 00 00 00 00 2b |...).(..|.*.....+|
|00001080| 04 00 00 00 00 00 02 01 | 06 52 44 42 24 35 31 05 |........|.RDB$51.|
|00001090| 00 07 00 08 04 0e 00 00 | 00 0a 04 28 00 00 00 09 |........|...(....|
|000010a0| 04 00 00 00 00 0b 04 00 | 00 00 00 29 04 28 00 00 |........|...).(..|
|000010b0| 00 2a 04 00 00 00 00 2b | 04 00 00 00 00 00 02 01 |.*.....+|........|
|000010c0| 06 52 44 42 24 35 32 05 | 00 07 00 08 04 0e 00 00 |.RDB$52.|........|
|000010d0| 00 0a 04 28 00 00 00 09 | 04 00 00 00 00 0b 04 00 |...(....|........|
|000010e0| 00 00 00 29 04 28 00 00 | 00 2a 04 00 00 00 00 2b |...).(..|.*.....+|
|000010f0| 04 00 00 00 00 00 02 01 | 06 52 44 42 24 35 33 05 |........|.RDB$53.|
|00001100| 00 07 00 08 04 0e 00 00 | 00 0a 04 28 00 00 00 09 |........|...(....|
|00001110| 04 00 00 00 00 0b 04 00 | 00 00 00 29 04 28 00 00 |........|...).(..|
|00001120| 00 2a 04 00 00 00 00 2b | 04 00 00 00 00 00 02 01 |.*.....+|........|
|00001130| 06 52 44 42 24 35 34 05 | 00 07 00 08 04 0e 00 00 |.RDB$54.|........|
|00001140| 00 0a 04 28 00 00 00 09 | 04 00 00 00 00 0b 04 00 |...(....|........|
|00001150| 00 00 00 29 04 28 00 00 | 00 2a 04 00 00 00 00 2b |...).(..|.*.....+|
|00001160| 04 00 00 00 00 00 02 01 | 06 52 44 42 24 35 35 05 |........|.RDB$55.|
|00001170| 00 07 00 08 04 0e 00 00 | 00 0a 04 28 00 00 00 09 |........|...(....|
|00001180| 04 00 00 00 00 0b 04 00 | 00 00 00 29 04 28 00 00 |........|...).(..|
|00001190| 00 2a 04 00 00 00 00 2b | 04 00 00 00 00 00 02 01 |.*.....+|........|
|000011a0| 06 52 44 42 24 35 36 05 | 00 07 00 08 04 0e 00 00 |.RDB$56.|........|
|000011b0| 00 0a 04 08 00 00 00 09 | 04 00 00 00 00 0b 04 00 |........|........|
|000011c0| 00 00 00 29 04 08 00 00 | 00 2a 04 00 00 00 00 2b |...)....|.*.....+|
|000011d0| 04 00 00 00 00 00 02 01 | 06 52 44 42 24 35 37 05 |........|.RDB$57.|
|000011e0| 00 07 00 08 04 25 00 00 | 00 0a 04 05 00 00 00 09 |.....%..|........|
|000011f0| 04 00 00 00 00 0b 04 00 | 00 00 00 29 04 05 00 00 |........|...)....|
|00001200| 00 2a 04 00 00 00 00 2b | 04 00 00 00 00 00 02 01 |.*.....+|........|
|00001210| 06 52 44 42 24 35 38 05 | 00 07 00 08 04 07 00 00 |.RDB$58.|........|
|00001220| 00 0a 04 02 00 00 00 09 | 04 00 00 00 00 0b 04 00 |........|........|
|00001230| 00 00 00 00 02 01 06 52 | 44 42 24 35 39 05 00 07 |.......R|DB$59...|
|00001240| 00 08 04 25 00 00 00 0a | 04 0f 00 00 00 09 04 00 |...%....|........|
|00001250| 00 00 00 0b 04 00 00 00 | 00 29 04 0f 00 00 00 2a |........|.).....*|
|00001260| 04 00 00 00 00 2b 04 00 | 00 00 00 00 02 01 06 52 |.....+..|.......R|
|00001270| 44 42 24 36 30 05 00 07 | 00 08 04 25 00 00 00 0a |DB$60...|...%....|
|00001280| 04 0f 00 00 00 09 04 00 | 00 00 00 0b 04 00 00 00 |........|........|
|00001290| 00 29 04 0f 00 00 00 2a | 04 00 00 00 00 2b 04 00 |.).....*|.....+..|
|000012a0| 00 00 00 00 02 01 06 52 | 44 42 24 36 31 05 00 07 |.......R|DB$61...|
|000012b0| 00 08 04 25 00 00 00 0a | 04 05 00 00 00 09 04 00 |...%....|........|
|000012c0| 00 00 00 0b 04 00 00 00 | 00 29 04 05 00 00 00 2a |........|.).....*|
|000012d0| 04 00 00 00 00 2b 04 00 | 00 00 00 00 02 01 06 52 |.....+..|.......R|
|000012e0| 44 42 24 36 32 05 00 07 | 00 08 04 25 00 00 00 0a |DB$62...|...%....|
|000012f0| 04 05 00 00 00 09 04 00 | 00 00 00 0b 04 00 00 00 |........|........|
|00001300| 00 29 04 05 00 00 00 2a | 04 00 00 00 00 2b 04 00 |.).....*|.....+..|
|00001310| 00 00 00 00 02 01 06 52 | 44 42 24 36 33 05 00 07 |.......R|DB$63...|
|00001320| 00 08 04 25 00 00 00 0a | 04 0f 00 00 00 09 04 00 |...%....|........|
|00001330| 00 00 00 0b 04 00 00 00 | 00 29 04 0f 00 00 00 2a |........|.).....*|
|00001340| 04 00 00 00 00 2b 04 00 | 00 00 00 00 02 01 06 52 |.....+..|.......R|
|00001350| 44 42 24 36 34 05 00 07 | 00 08 04 25 00 00 00 0a |DB$64...|...%....|
|00001360| 04 0f 00 00 00 09 04 00 | 00 00 00 0b 04 00 00 00 |........|........|
|00001370| 00 29 04 0f 00 00 00 2a | 04 00 00 00 00 2b 04 00 |.).....*|.....+..|
|00001380| 00 00 00 00 18 01 05 52 | 44 42 24 34 1d 04 00 00 |.......R|DB$4....|
|00001390| 00 00 20 04 01 00 00 00 | 21 04 05 00 00 00 00 18 |.. .....|!.......|
|000013a0| 01 06 52 44 42 24 31 33 | 1d 04 00 00 00 00 20 04 |..RDB$13|...... .|
|000013b0| 01 00 00 00 21 04 04 00 | 00 00 00 03 01 07 43 4f |....!...|......CO|
|000013c0| 55 4e 54 52 59 10 04 01 | 00 00 00 08 0b 53 51 4c |UNTRY...|.....SQL|
|000013d0| 24 43 4f 55 4e 54 52 59 | 0c 06 53 59 53 44 42 41 |$COUNTRY|..SYSDBA|
|000013e0| 00 04 01 08 43 55 52 52 | 45 4e 43 59 02 05 52 44 |....CURR|ENCY..RD|
|000013f0| 42 24 31 0d 04 01 00 00 | 00 08 04 25 00 00 00 0a |B$1.....|...%....|
|00001400| 04 0a 00 00 00 09 04 00 | 00 00 00 0b 04 00 00 00 |........|........|
|00001410| 00 16 04 02 00 00 00 18 | 04 00 00 00 00 22 04 01 |........|....."..|
|00001420| 00 00 00 26 04 01 00 00 | 00 2a 04 00 00 00 00 2b |...&....|.*.....+|
|00001430| 04 00 00 00 00 00 04 01 | 07 43 4f 55 4e 54 52 59 |........|.COUNTRY|
|00001440| 02 0b 43 4f 55 4e 54 52 | 59 4e 41 4d 45 0d 04 00 |..COUNTR|YNAME...|
|00001450| 00 00 00 08 04 25 00 00 | 00 0a 04 0f 00 00 00 09 |.....%..|........|
|00001460| 04 00 00 00 00 0b 04 00 | 00 00 00 16 04 01 00 00 |........|........|
|00001470| 00 18 04 00 00 00 00 22 | 04 01 00 00 00 26 04 01 |......."|.....&..|
|00001480| 00 00 00 2a 04 00 00 00 | 00 00 09 03 01 03 4a 4f |...*....|......JO|
|00001490| 42 10 04 01 00 00 00 08 | 07 53 51 4c 24 4a 4f 42 |B.......|.SQL$JOB|
|000014a0| 0c 06 53 59 53 44 42 41 | 00 04 01 0f 4a 4f 42 5f |..SYSDBA|....JOB_|
|000014b0| 52 45 51 55 49 52 45 4d | 45 4e 54 02 05 52 44 42 |REQUIREM|ENT..RDB|
|000014c0| 24 33 0d 04 06 00 00 00 | 08 04 05 01 00 00 0a 04 |$3......|........|
|000014d0| 08 00 00 00 09 04 01 00 | 00 00 0b 04 00 00 00 00 |........|........|
|000014e0| 16 04 07 00 00 00 18 04 | 00 00 00 00 22 04 01 00 |........|...."...|
|000014f0| 00 00 2a 04 00 00 00 00 | 00 04 01 0a 4d 41 58 5f |..*.....|....MAX_|
|00001500| 53 41 4c 41 52 59 02 06 | 53 41 4c 41 52 59 0d 04 |SALARY..|SALARY..|
|00001510| 05 00 00 00 08 04 1b 00 | 00 00 0a 04 08 00 00 00 |........|........|
|00001520| 09 04 00 00 00 00 0b 04 | fe ff ff ff 16 04 06 00 |........|........|
|00001530| 00 00 18 04 00 00 00 00 | 22 04 01 00 00 00 26 04 |........|".....&.|
|00001540| 01 00 00 00 00 04 01 0a | 4d 49 4e 5f 53 41 4c 41 |........|MIN_SALA|
|00001550| 52 59 02 06 53 41 4c 41 | 52 59 0d 04 04 00 00 00 |RY..SALA|RY......|
|00001560| 08 04 1b 00 00 00 0a 04 | 08 00 00 00 09 04 00 00 |........|........|
|00001570| 00 00 0b 04 fe ff ff ff | 16 04 05 00 00 00 18 04 |........|........|
|00001580| 00 00 00 00 22 04 01 00 | 00 00 26 04 01 00 00 00 |...."...|..&.....|
|00001590| 00 04 01 09 4a 4f 42 5f | 47 52 41 44 45 02 08 4a |....JOB_|GRADE..J|
|000015a0| 4f 42 47 52 41 44 45 0d | 04 01 00 00 00 08 04 07 |OBGRADE.|........|
|000015b0| 00 00 00 0a 04 02 00 00 | 00 09 04 00 00 00 00 0b |........|........|
|000015c0| 04 00 00 00 00 16 04 02 | 00 00 00 18 04 00 00 00 |........|........|
|000015d0| 00 22 04 01 00 00 00 26 | 04 01 00 00 00 00 04 01 |.".....&|........|
|000015e0| 0c 4c 41 4e 47 55 41 47 | 45 5f 52 45 51 02 05 52 |.LANGUAG|E_REQ..R|
|000015f0| 44 42 24 34 0d 04 07 00 | 00 00 08 04 25 00 00 00 |DB$4....|....%...|
|00001600| 0a 04 0f 00 00 00 09 04 | 00 00 00 00 0b 04 00 00 |........|........|
|00001610| 00 00 16 04 08 00 00 00 | 18 04 00 00 00 00 22 04 |........|......".|
|00001620| 01 00 00 00 2a 04 00 00 | 00 00 2b 04 00 00 00 00 |....*...|..+.....|
|00001630| 1d 04 01 00 00 00 20 04 | 01 00 00 00 21 04 05 00 |...... .|....!...|
|00001640| 00 00 00 04 01 09 4a 4f | 42 5f 54 49 54 4c 45 02 |......JO|B_TITLE.|
|00001650| 05 52 44 42 24 32 0d 04 | 03 00 00 00 08 04 25 00 |.RDB$2..|......%.|
|00001660| 00 00 0a 04 19 00 00 00 | 09 04 00 00 00 00 0b 04 |........|........|
|00001670| 00 00 00 00 16 04 04 00 | 00 00 18 04 00 00 00 00 |........|........|
|00001680| 22 04 01 00 00 00 26 04 | 01 00 00 00 2a 04 00 00 |".....&.|....*...|
|00001690| 00 00 2b 04 00 00 00 00 | 00 04 01 0b 4a 4f 42 5f |..+.....|....JOB_|
|000016a0| 43 4f 55 4e 54 52 59 02 | 0b 43 4f 55 4e 54 52 59 |COUNTRY.|.COUNTRY|
|000016b0| 4e 41 4d 45 0d 04 02 00 | 00 00 08 04 25 00 00 00 |NAME....|....%...|
|000016c0| 0a 04 0f 00 00 00 09 04 | 00 00 00 00 0b 04 00 00 |........|........|
|000016d0| 00 00 16 04 03 00 00 00 | 18 04 00 00 00 00 22 04 |........|......".|
|000016e0| 01 00 00 00 26 04 01 00 | 00 00 2a 04 00 00 00 00 |....&...|..*.....|
|000016f0| 00 04 01 08 4a 4f 42 5f | 43 4f 44 45 02 07 4a 4f |....JOB_|CODE..JO|
|00001700| 42 43 4f 44 45 0d 04 00 | 00 00 00 08 04 25 00 00 |BCODE...|.....%..|
|00001710| 00 0a 04 05 00 00 00 09 | 04 00 00 00 00 0b 04 00 |........|........|
|00001720| 00 00 00 16 04 01 00 00 | 00 18 04 00 00 00 00 22 |........|......."|
|00001730| 04 01 00 00 00 26 04 01 | 00 00 00 2a 04 00 00 00 |.....&..|...*....|
|00001740| 00 00 09 03 01 0a 44 45 | 50 41 52 54 4d 45 4e 54 |......DE|PARTMENT|
|00001750| 10 04 01 00 00 00 08 0e | 53 51 4c 24 44 45 50 41 |........|SQL$DEPA|
|00001760| 52 54 4d 45 4e 54 0c 06 | 53 59 53 44 42 41 00 04 |RTMENT..|SYSDBA..|
|00001770| 01 06 42 55 44 47 45 54 | 02 06 42 55 44 47 45 54 |..BUDGET|..BUDGET|
|00001780| 0d 04 04 00 00 00 08 04 | 1b 00 00 00 0a 04 08 00 |........|........|
|00001790| 00 00 09 04 00 00 00 00 | 0b 04 fe ff ff ff 16 04 |........|........|
|000017a0| 05 00 00 00 18 04 00 00 | 00 00 22 04 01 00 00 00 |........|..".....|
|000017b0| 00 04 01 08 50 48 4f 4e | 45 5f 4e 4f 02 0b 50 48 |....PHON|E_NO..PH|
|000017c0| 4f 4e 45 4e 55 4d 42 45 | 52 0d 04 06 00 00 00 08 |ONENUMBE|R.......|
|000017d0| 04 25 00 00 00 0a 04 14 | 00 00 00 09 04 00 00 00 |.%......|........|
|000017e0| 00 0b 04 00 00 00 00 16 | 04 07 00 00 00 18 04 00 |........|........|
|000017f0| 00 00 00 22 04 01 00 00 | 00 2a 04 00 00 00 00 0f |..."....|.*......|
|00001800| 04 10 00 00 00 04 15 0f | 7f 00 08 00 35 35 35 2d |........|....555-|
|00001810| 31 32 33 34 4c 27 04 14 | 00 00 00 20 44 45 46 41 |1234L'..|... DEFA|
|00001820| 55 4c 54 20 27 35 35 35 | 2d 31 32 33 34 27 00 00 |ULT '555|-1234'..|
|00001830| 04 01 07 4d 4e 47 52 5f | 4e 4f 02 05 45 4d 50 4e |...MNGR_|NO..EMPN|
|00001840| 4f 0d 04 03 00 00 00 08 | 04 07 00 00 00 0a 04 02 |O.......|........|
|00001850| 00 00 00 09 04 00 00 00 | 00 0b 04 00 00 00 00 16 |........|........|
|00001860| 04 04 00 00 00 18 04 00 | 00 00 00 22 04 01 00 00 |........|..."....|
|00001870| 00 00 04 01 08 4c 4f 43 | 41 54 49 4f 4e 02 05 52 |.....LOC|ATION..R|
|00001880| 44 42 24 36 0d 04 05 00 | 00 00 08 04 25 00 00 00 |DB$6....|....%...|
|00001890| 0a 04 0f 00 00 00 09 04 | 00 00 00 00 0b 04 00 00 |........|........|
|000018a0| 00 00 16 04 06 00 00 00 | 18 04 00 00 00 00 22 04 |........|......".|
|000018b0| 01 00 00 00 2a 04 00 00 | 00 00 2b 04 00 00 00 00 |....*...|..+.....|
|000018c0| 00 04 01 09 48 45 41 44 | 5f 44 45 50 54 02 06 44 |....HEAD|_DEPT..D|
|000018d0| 45 50 54 4e 4f 0d 04 02 | 00 00 00 08 04 0e 00 00 |EPTNO...|........|
|000018e0| 00 0a 04 03 00 00 00 09 | 04 00 00 00 00 0b 04 00 |........|........|
|000018f0| 00 00 00 16 04 03 00 00 | 00 18 04 00 00 00 00 22 |........|......."|
|00001900| 04 01 00 00 00 2a 04 00 | 00 00 00 00 04 01 0a 44 |.....*..|.......D|
|00001910| 45 50 41 52 54 4d 45 4e | 54 02 05 52 44 42 24 35 |EPARTMEN|T..RDB$5|
|00001920| 0d 04 01 00 00 00 08 04 | 25 00 00 00 0a 04 19 00 |........|%.......|
|00001930| 00 00 09 04 00 00 00 00 | 0b 04 00 00 00 00 16 04 |........|........|
|00001940| 02 00 00 00 18 04 00 00 | 00 00 22 04 01 00 00 00 |........|..".....|
|00001950| 26 04 01 00 00 00 2a 04 | 00 00 00 00 2b 04 00 00 |&.....*.|....+...|
|00001960| 00 00 00 04 01 07 44 45 | 50 54 5f 4e 4f 02 06 44 |......DE|PT_NO..D|
|00001970| 45 50 54 4e 4f 0d 04 00 | 00 00 00 08 04 0e 00 00 |EPTNO...|........|
|00001980| 00 0a 04 03 00 00 00 09 | 04 00 00 00 00 0b 04 00 |........|........|
|00001990| 00 00 00 16 04 01 00 00 | 00 18 04 00 00 00 00 22 |........|......."|
|000019a0| 04 01 00 00 00 26 04 01 | 00 00 00 2a 04 00 00 00 |.....&..|...*....|
|000019b0| 00 00 09 03 01 08 45 4d | 50 4c 4f 59 45 45 10 04 |......EM|PLOYEE..|
|000019c0| 01 00 00 00 08 0c 53 51 | 4c 24 45 4d 50 4c 4f 59 |......SQ|L$EMPLOY|
|000019d0| 45 45 0c 06 53 59 53 44 | 42 41 00 04 01 06 53 41 |EE..SYSD|BA....SA|
|000019e0| 4c 41 52 59 02 06 53 41 | 4c 41 52 59 0d 04 09 00 |LARY..SA|LARY....|
|000019f0| 00 00 08 04 1b 00 00 00 | 0a 04 08 00 00 00 09 04 |........|........|
|00001a00| 00 00 00 00 0b 04 fe ff | ff ff 16 04 0a 00 00 00 |........|........|
|00001a10| 18 04 00 00 00 00 22 04 | 01 00 00 00 26 04 01 00 |......".|....&...|
|00001a20| 00 00 00 04 01 09 48 49 | 52 45 5f 44 41 54 45 02 |......HI|RE_DATE.|
|00001a30| 05 52 44 42 24 38 0d 04 | 04 00 00 00 08 04 23 00 |.RDB$8..|......#.|
|00001a40| 00 00 0a 04 08 00 00 00 | 09 04 00 00 00 00 0b 04 |........|........|
|00001a50| 00 00 00 00 16 04 05 00 | 00 00 18 04 00 00 00 00 |........|........|
|00001a60| 22 04 01 00 00 00 26 04 | 01 00 00 00 0f 04 0b 00 |".....&.|........|
|00001a70| 00 00 04 15 0f 7f 00 03 | 00 4e 4f 57 4c 27 04 0e |........|.NOWL'..|
|00001a80| 00 00 00 44 45 46 41 55 | 4c 54 20 27 4e 4f 57 27 |...DEFAU|LT 'NOW'|
|00001a90| 00 00 04 01 09 4a 4f 42 | 5f 47 52 41 44 45 02 08 |.....JOB|_GRADE..|
|00001aa0| 4a 4f 42 47 52 41 44 45 | 0d 04 07 00 00 00 08 04 |JOBGRADE|........|
|00001ab0| 07 00 00 00 0a 04 02 00 | 00 00 09 04 00 00 00 00 |........|........|
|00001ac0| 0b 04 00 00 00 00 16 04 | 08 00 00 00 18 04 00 00 |........|........|
|00001ad0| 00 00 22 04 01 00 00 00 | 26 04 01 00 00 00 00 04 |..".....|&.......|
|00001ae0| 01 09 50 48 4f 4e 45 5f | 45 58 54 02 05 52 44 42 |..PHONE_|EXT..RDB|
|00001af0| 24 37 0d 04 03 00 00 00 | 08 04 25 00 00 00 0a 04 |$7......|..%.....|
|00001b00| 04 00 00 00 09 04 00 00 | 00 00 0b 04 00 00 00 00 |........|........|
|00001b10| 16 04 04 00 00 00 18 04 | 00 00 00 00 22 04 01 00 |........|...."...|
|00001b20| 00 00 2a 04 00 00 00 00 | 2b 04 00 00 00 00 00 04 |..*.....|+.......|
|00001b30| 01 09 4c 41 53 54 5f 4e | 41 4d 45 02 08 4c 41 53 |..LAST_N|AME..LAS|
|00001b40| 54 4e 41 4d 45 0d 04 02 | 00 00 00 08 04 25 00 00 |TNAME...|.....%..|
|00001b50| 00 0a 04 14 00 00 00 09 | 04 00 00 00 00 0b 04 00 |........|........|
|00001b60| 00 00 00 16 04 03 00 00 | 00 18 04 00 00 00 00 22 |........|......."|
|00001b70| 04 01 00 00 00 26 04 01 | 00 00 00 2a 04 00 00 00 |.....&..|...*....|
|00001b80| 00 00 04 01 06 45 4d 50 | 5f 4e 4f 02 05 45 4d 50 |.....EMP|_NO..EMP|
|00001b90| 4e 4f 0d 04 00 00 00 00 | 08 04 07 00 00 00 0a 04 |NO......|........|
|00001ba0| 02 00 00 00 09 04 00 00 | 00 00 0b 04 00 00 00 00 |........|........|
|00001bb0| 16 04 01 00 00 00 18 04 | 00 00 00 00 22 04 01 00 |........|...."...|
|00001bc0| 00 00 26 04 01 00 00 00 | 00 04 01 09 46 55 4c 4c |..&.....|....FULL|
|00001bd0| 5f 4e 41 4d 45 02 05 52 | 44 42 24 39 0d 04 0a 00 |_NAME..R|DB$9....|
|00001be0| 00 00 08 04 25 00 00 00 | 0a 04 25 00 00 00 09 04 |....%...|..%.....|
|00001bf0| 00 00 00 00 0b 04 00 00 | 00 00 16 04 0b 00 00 00 |........|........|
|00001c00| 18 04 00 00 00 00 22 04 | 00 00 00 00 2a 04 00 00 |......".|....*...|
|00001c10| 00 00 2b 04 00 00 00 00 | 17 04 01 00 00 00 00 04 |..+.....|........|
|00001c20| 01 0b 4a 4f 42 5f 43 4f | 55 4e 54 52 59 02 0b 43 |..JOB_CO|UNTRY..C|
|00001c30| 4f 55 4e 54 52 59 4e 41 | 4d 45 0d 04 08 00 00 00 |OUNTRYNA|ME......|
|00001c40| 08 04 25 00 00 00 0a 04 | 0f 00 00 00 09 04 00 00 |..%.....|........|
|00001c50| 00 00 0b 04 00 00 00 00 | 16 04 09 00 00 00 18 04 |........|........|
|00001c60| 00 00 00 00 22 04 01 00 | 00 00 26 04 01 00 00 00 |...."...|..&.....|
|00001c70| 2a 04 00 00 00 00 00 04 | 01 08 4a 4f 42 5f 43 4f |*.......|..JOB_CO|
|00001c80| 44 45 02 07 4a 4f 42 43 | 4f 44 45 0d 04 06 00 00 |DE..JOBC|ODE.....|
|00001c90| 00 08 04 25 00 00 00 0a | 04 05 00 00 00 09 04 00 |...%....|........|
|00001ca0| 00 00 00 0b 04 00 00 00 | 00 16 04 07 00 00 00 18 |........|........|
|00001cb0| 04 00 00 00 00 22 04 01 | 00 00 00 26 04 01 00 00 |....."..|...&....|
|00001cc0| 00 2a 04 00 00 00 00 00 | 04 01 07 44 45 50 54 5f |.*......|...DEPT_|
|00001cd0| 4e 4f 02 06 44 45 50 54 | 4e 4f 0d 04 05 00 00 00 |NO..DEPT|NO......|
|00001ce0| 08 04 0e 00 00 00 0a 04 | 03 00 00 00 09 04 00 00 |........|........|
|00001cf0| 00 00 0b 04 00 00 00 00 | 16 04 06 00 00 00 18 04 |........|........|
|00001d00| 00 00 00 00 22 04 01 00 | 00 00 26 04 01 00 00 00 |...."...|..&.....|
|00001d10| 2a 04 00 00 00 00 00 04 | 01 0a 46 49 52 53 54 5f |*.......|..FIRST_|
|00001d20| 4e 41 4d 45 02 09 46 49 | 52 53 54 4e 41 4d 45 0d |NAME..FI|RSTNAME.|
|00001d30| 04 01 00 00 00 08 04 25 | 00 00 00 0a 04 0f 00 00 |.......%|........|
|00001d40| 00 09 04 00 00 00 00 0b | 04 00 00 00 00 16 04 02 |........|........|
|00001d50| 00 00 00 18 04 00 00 00 | 00 22 04 01 00 00 00 26 |........|.".....&|
|00001d60| 04 01 00 00 00 2a 04 00 | 00 00 00 00 09 03 01 07 |.....*..|........|
|00001d70| 50 52 4f 4a 45 43 54 10 | 04 01 00 00 00 08 0b 53 |PROJECT.|.......S|
|00001d80| 51 4c 24 50 52 4f 4a 45 | 43 54 0c 06 53 59 53 44 |QL$PROJE|CT..SYSD|
|00001d90| 42 41 00 04 01 09 50 52 | 4f 4a 5f 44 45 53 43 02 |BA....PR|OJ_DESC.|
|00001da0| 06 52 44 42 24 31 31 0d | 04 02 00 00 00 08 04 05 |.RDB$11.|........|
|00001db0| 01 00 00 0a 04 08 00 00 | 00 09 04 01 00 00 00 0b |........|........|
|00001dc0| 04 00 00 00 00 16 04 03 | 00 00 00 18 04 00 00 00 |........|........|
|00001dd0| 00 22 04 01 00 00 00 2a | 04 00 00 00 00 00 04 01 |.".....*|........|
|00001de0| 07 50 52 4f 44 55 43 54 | 02 08 50 52 4f 44 54 59 |.PRODUCT|..PRODTY|
|00001df0| 50 45 0d 04 04 00 00 00 | 08 04 25 00 00 00 0a 04 |PE......|..%.....|
|00001e00| 0c 00 00 00 09 04 00 00 | 00 00 0b 04 00 00 00 00 |........|........|
|00001e10| 16 04 05 00 00 00 18 04 | 00 00 00 00 22 04 01 00 |........|...."...|
|00001e20| 00 00 2a 04 00 00 00 00 | 00 04 01 0b 54 45 41 4d |..*.....|....TEAM|
|00001e30| 5f 4c 45 41 44 45 52 02 | 05 45 4d 50 4e 4f 0d 04 |_LEADER.|.EMPNO..|
|00001e40| 03 00 00 00 08 04 07 00 | 00 00 0a 04 02 00 00 00 |........|........|
|00001e50| 09 04 00 00 00 00 0b 04 | 00 00 00 00 16 04 04 00 |........|........|
|00001e60| 00 00 18 04 00 00 00 00 | 22 04 01 00 00 00 00 04 |........|".......|
|00001e70| 01 09 50 52 4f 4a 5f 4e | 41 4d 45 02 06 52 44 42 |..PROJ_N|AME..RDB|
|00001e80| 24 31 30 0d 04 01 00 00 | 00 08 04 25 00 00 00 0a |$10.....|...%....|
|00001e90| 04 14 00 00 00 09 04 00 | 00 00 00 0b 04 00 00 00 |........|........|
|00001ea0| 00 16 04 02 00 00 00 18 | 04 00 00 00 00 22 04 01 |........|....."..|
|00001eb0| 00 00 00 26 04 01 00 00 | 00 2a 04 00 00 00 00 2b |...&....|.*.....+|
|00001ec0| 04 00 00 00 00 00 04 01 | 07 50 52 4f 4a 5f 49 44 |........|.PROJ_ID|
|00001ed0| 02 06 50 52 4f 4a 4e 4f | 0d 04 00 00 00 00 08 04 |..PROJNO|........|
|00001ee0| 0e 00 00 00 0a 04 05 00 | 00 00 09 04 00 00 00 00 |........|........|
|00001ef0| 0b 04 00 00 00 00 16 04 | 01 00 00 00 18 04 00 00 |........|........|
|00001f00| 00 00 22 04 01 00 00 00 | 26 04 01 00 00 00 2a 04 |..".....|&.....*.|
|00001f10| 00 00 00 00 00 09 03 01 | 0a 50 48 4f 4e 45 5f 4c |........|.PHONE_L|
|00001f20| 49 53 54 02 04 33 00 00 | 00 04 43 02 4a 08 45 4d |IST..3..|..C.J.EM|
|00001f30| 50 4c 4f 59 45 45 01 4a | 0a 44 45 50 41 52 54 4d |PLOYEE.J|.DEPARTM|
|00001f40| 45 4e 54 02 47 2f 17 01 | 07 44 45 50 54 5f 4e 4f |ENT.G/..|.DEPT_NO|
|00001f50| 17 02 07 44 45 50 54 5f | 4e 4f ff 4c 10 04 01 00 |...DEPT_|NO.L....|
|00001f60| 00 00 08 0e 53 51 4c 24 | 50 48 4f 4e 45 5f 4c 49 |....SQL$|PHONE_LI|
|00001f70| 53 54 0e 04 97 00 00 00 | 20 53 45 4c 45 43 54 0a |ST......| SELECT.|
|00001f80| 20 20 20 20 65 6d 70 5f | 6e 6f 2c 20 66 69 72 73 |    emp_|no, firs|
|00001f90| 74 5f 6e 61 6d 65 2c 20 | 6c 61 73 74 5f 6e 61 6d |t_name, |last_nam|
|00001fa0| 65 2c 20 70 68 6f 6e 65 | 5f 65 78 74 2c 20 6c 6f |e, phone|_ext, lo|
|00001fb0| 63 61 74 69 6f 6e 2c 20 | 70 68 6f 6e 65 5f 6e 6f |cation, |phone_no|
|00001fc0| 0a 20 20 20 20 46 52 4f | 4d 20 65 6d 70 6c 6f 79 |.    FRO|M employ|
|00001fd0| 65 65 2c 20 64 65 70 61 | 72 74 6d 65 6e 74 0a 20 |ee, depa|rtment. |
|00001fe0| 20 20 20 57 48 45 52 45 | 20 65 6d 70 6c 6f 79 65 |   WHERE| employe|
|00001ff0| 65 2e 64 65 70 74 5f 6e | 6f 20 3d 20 64 65 70 61 |e.dept_n|o = depa|
|00002000| 72 74 6d 65 6e 74 2e 64 | 65 70 74 5f 6e 6f 00 0c |rtment.d|ept_no..|
|00002010| 06 53 59 53 44 42 41 00 | 04 01 08 50 48 4f 4e 45 |.SYSDBA.|...PHONE|
|00002020| 5f 4e 4f 02 0b 50 48 4f | 4e 45 4e 55 4d 42 45 52 |_NO..PHO|NENUMBER|
|00002030| 0d 04 05 00 00 00 08 04 | 25 00 00 00 0a 04 14 00 |........|%.......|
|00002040| 00 00 09 04 00 00 00 00 | 0b 04 00 00 00 00 16 04 |........|........|
|00002050| 06 00 00 00 18 04 00 00 | 00 00 22 04 00 00 00 00 |........|..".....|
|00002060| 2a 04 00 00 00 00 04 04 | 02 00 00 00 03 08 50 48 |*.......|......PH|
|00002070| 4f 4e 45 5f 4e 4f 00 04 | 01 09 50 48 4f 4e 45 5f |ONE_NO..|..PHONE_|
|00002080| 45 58 54 02 05 52 44 42 | 24 37 0d 04 03 00 00 00 |EXT..RDB|$7......|
|00002090| 08 04 25 00 00 00 0a 04 | 04 00 00 00 09 04 00 00 |..%.....|........|
|000020a0| 00 00 0b 04 00 00 00 00 | 16 04 04 00 00 00 18 04 |........|........|
|000020b0| 00 00 00 00 22 04 00 00 | 00 00 2a 04 00 00 00 00 |...."...|..*.....|
|000020c0| 04 04 01 00 00 00 03 09 | 50 48 4f 4e 45 5f 45 58 |........|PHONE_EX|
|000020d0| 54 00 04 01 09 4c 41 53 | 54 5f 4e 41 4d 45 02 08 |T....LAS|T_NAME..|
|000020e0| 4c 41 53 54 4e 41 4d 45 | 0d 04 02 00 00 00 08 04 |LASTNAME|........|
|000020f0| 25 00 00 00 0a 04 14 00 | 00 00 09 04 00 00 00 00 |%.......|........|
|00002100| 0b 04 00 00 00 00 16 04 | 03 00 00 00 18 04 00 00 |........|........|
|00002110| 00 00 22 04 00 00 00 00 | 2a 04 00 00 00 00 04 04 |..".....|*.......|
|00002120| 01 00 00 00 03 09 4c 41 | 53 54 5f 4e 41 4d 45 00 |......LA|ST_NAME.|
|00002130| 04 01 06 45 4d 50 5f 4e | 4f 02 05 45 4d 50 4e 4f |...EMP_N|O..EMPNO|
|00002140| 0d 04 00 00 00 00 08 04 | 07 00 00 00 0a 04 02 00 |........|........|
|00002150| 00 00 09 04 00 00 00 00 | 0b 04 00 00 00 00 16 04 |........|........|
|00002160| 01 00 00 00 18 04 00 00 | 00 00 22 04 00 00 00 00 |........|..".....|
|00002170| 04 04 01 00 00 00 03 06 | 45 4d 50 5f 4e 4f 00 04 |........|EMP_NO..|
|00002180| 01 08 4c 4f 43 41 54 49 | 4f 4e 02 05 52 44 42 24 |..LOCATI|ON..RDB$|
|00002190| 36 0d 04 04 00 00 00 08 | 04 25 00 00 00 0a 04 0f |6.......|.%......|
|000021a0| 00 00 00 09 04 00 00 00 | 00 0b 04 00 00 00 00 16 |........|........|
|000021b0| 04 05 00 00 00 18 04 00 | 00 00 00 22 04 00 00 00 |........|..."....|
|000021c0| 00 2a 04 00 00 00 00 04 | 04 02 00 00 00 03 08 4c |.*......|.......L|
|000021d0| 4f 43 41 54 49 4f 4e 00 | 04 01 0a 46 49 52 53 54 |OCATION.|...FIRST|
|000021e0| 5f 4e 41 4d 45 02 09 46 | 49 52 53 54 4e 41 4d 45 |_NAME..F|IRSTNAME|
|000021f0| 0d 04 01 00 00 00 08 04 | 25 00 00 00 0a 04 0f 00 |........|%.......|
|00002200| 00 00 09 04 00 00 00 00 | 0b 04 00 00 00 00 16 04 |........|........|
|00002210| 02 00 00 00 18 04 00 00 | 00 00 22 04 00 00 00 00 |........|..".....|
|00002220| 2a 04 00 00 00 00 04 04 | 01 00 00 00 03 0a 46 49 |*.......|......FI|
|00002230| 52 53 54 5f 4e 41 4d 45 | 00 0b 08 0a 44 45 50 41 |RST_NAME|....DEPA|
|00002240| 52 54 4d 45 4e 54 09 04 | 02 00 00 00 0a 0a 44 45 |RTMENT..|......DE|
|00002250| 50 41 52 54 4d 45 4e 54 | 00 0b 08 08 45 4d 50 4c |PARTMENT|....EMPL|
|00002260| 4f 59 45 45 09 04 01 00 | 00 00 0a 08 45 4d 50 4c |OYEE....|....EMPL|
|00002270| 4f 59 45 45 00 09 03 01 | 10 45 4d 50 4c 4f 59 45 |OYEE....|.EMPLOYE|
|00002280| 45 5f 50 52 4f 4a 45 43 | 54 10 04 01 00 00 00 08 |E_PROJEC|T.......|
|00002290| 14 53 51 4c 24 45 4d 50 | 4c 4f 59 45 45 5f 50 52 |.SQL$EMP|LOYEE_PR|
|000022a0| 4f 4a 45 43 54 0c 06 53 | 59 53 44 42 41 00 04 01 |OJECT..S|YSDBA...|
|000022b0| 06 45 4d 50 5f 4e 4f 02 | 05 45 4d 50 4e 4f 0d 04 |.EMP_NO.|.EMPNO..|
|000022c0| 00 00 00 00 08 04 07 00 | 00 00 0a 04 02 00 00 00 |........|........|
|000022d0| 09 04 00 00 00 00 0b 04 | 00 00 00 00 16 04 01 00 |........|........|
|000022e0| 00 00 18 04 00 00 00 00 | 22 04 01 00 00 00 26 04 |........|".....&.|
|000022f0| 01 00 00 00 00 04 01 07 | 50 52 4f 4a 5f 49 44 02 |........|PROJ_ID.|
|00002300| 06 50 52 4f 4a 4e 4f 0d | 04 01 00 00 00 08 04 0e |.PROJNO.|........|
|00002310| 00 00 00 0a 04 05 00 00 | 00 09 04 00 00 00 00 0b |........|........|
|00002320| 04 00 00 00 00 16 04 02 | 00 00 00 18 04 00 00 00 |........|........|
|00002330| 00 22 04 01 00 00 00 26 | 04 01 00 00 00 2a 04 00 |.".....&|.....*..|
|00002340| 00 00 00 00 09 03 01 08 | 43 55 53 54 4f 4d 45 52 |........|CUSTOMER|
|00002350| 10 04 01 00 00 00 08 0c | 53 51 4c 24 43 55 53 54 |........|SQL$CUST|
|00002360| 4f 4d 45 52 0c 06 53 59 | 53 44 42 41 00 04 01 0d |OMER..SY|SDBA....|
|00002370| 41 44 44 52 45 53 53 5f | 4c 49 4e 45 32 02 0b 41 |ADDRESS_|LINE2..A|
|00002380| 44 44 52 45 53 53 4c 49 | 4e 45 0d 04 06 00 00 00 |DDRESSLI|NE......|
|00002390| 08 04 25 00 00 00 0a 04 | 1e 00 00 00 09 04 00 00 |..%.....|........|
|000023a0| 00 00 0b 04 00 00 00 00 | 16 04 07 00 00 00 18 04 |........|........|
|000023b0| 00 00 00 00 22 04 01 00 | 00 00 2a 04 00 00 00 00 |...."...|..*.....|
|000023c0| 00 04 01 0d 41 44 44 52 | 45 53 53 5f 4c 49 4e 45 |....ADDR|ESS_LINE|
|000023d0| 31 02 0b 41 44 44 52 45 | 53 53 4c 49 4e 45 0d 04 |1..ADDRE|SSLINE..|
|000023e0| 05 00 00 00 08 04 25 00 | 00 00 0a 04 1e 00 00 00 |......%.|........|
|000023f0| 09 04 00 00 00 00 0b 04 | 00 00 00 00 16 04 06 00 |........|........|
|00002400| 00 00 18 04 00 00 00 00 | 22 04 01 00 00 00 2a 04 |........|".....*.|
|00002410| 00 00 00 00 00 04 01 07 | 43 55 53 54 5f 4e 4f 02 |........|CUST_NO.|
|00002420| 06 43 55 53 54 4e 4f 0d | 04 00 00 00 00 08 04 08 |.CUSTNO.|........|
|00002430| 00 00 00 0a 04 04 00 00 | 00 09 04 00 00 00 00 0b |........|........|
|00002440| 04 00 00 00 00 16 04 01 | 00 00 00 18 04 00 00 00 |........|........|
|00002450| 00 22 04 01 00 00 00 26 | 04 01 00 00 00 00 04 01 |.".....&|........|
|00002460| 0b 50 4f 53 54 41 4c 5f | 43 4f 44 45 02 06 52 44 |.POSTAL_|CODE..RD|
|00002470| 42 24 32 31 0d 04 0a 00 | 00 00 08 04 25 00 00 00 |B$21....|....%...|
|00002480| 0a 04 0c 00 00 00 09 04 | 00 00 00 00 0b 04 00 00 |........|........|
|00002490| 00 00 16 04 0b 00 00 00 | 18 04 00 00 00 00 22 04 |........|......".|
|000024a0| 01 00 00 00 2a 04 00 00 | 00 00 2b 04 00 00 00 00 |....*...|..+.....|
|000024b0| 00 04 01 08 50 48 4f 4e | 45 5f 4e 4f 02 0b 50 48 |....PHON|E_NO..PH|
|000024c0| 4f 4e 45 4e 55 4d 42 45 | 52 0d 04 04 00 00 00 08 |ONENUMBE|R.......|
|000024d0| 04 25 00 00 00 0a 04 14 | 00 00 00 09 04 00 00 00 |.%......|........|
|000024e0| 00 0b 04 00 00 00 00 16 | 04 05 00 00 00 18 04 00 |........|........|
|000024f0| 00 00 00 22 04 01 00 00 | 00 2a 04 00 00 00 00 00 |..."....|.*......|
|00002500| 04 01 0c 43 4f 4e 54 41 | 43 54 5f 4c 41 53 54 02 |...CONTA|CT_LAST.|
|00002510| 08 4c 41 53 54 4e 41 4d | 45 0d 04 03 00 00 00 08 |.LASTNAM|E.......|
|00002520| 04 25 00 00 00 0a 04 14 | 00 00 00 09 04 00 00 00 |.%......|........|
|00002530| 00 0b 04 00 00 00 00 16 | 04 04 00 00 00 18 04 00 |........|........|
|00002540| 00 00 00 22 04 01 00 00 | 00 2a 04 00 00 00 00 00 |..."....|.*......|
|00002550| 04 01 07 4f 4e 5f 48 4f | 4c 44 02 06 52 44 42 24 |...ON_HO|LD..RDB$|
|00002560| 32 32 0d 04 0b 00 00 00 | 08 04 0e 00 00 00 0a 04 |22......|........|
|00002570| 01 00 00 00 09 04 00 00 | 00 00 0b 04 00 00 00 00 |........|........|
|00002580| 16 04 0c 00 00 00 18 04 | 00 00 00 00 22 04 01 00 |........|...."...|
|00002590| 00 00 2a 04 00 00 00 00 | 2b 04 00 00 00 00 0f 04 |..*.....|+.......|
|000025a0| 03 00 00 00 04 2d 4c 27 | 04 0d 00 00 00 44 45 46 |.....-L'|.....DEF|
|000025b0| 41 55 4c 54 20 4e 55 4c | 4c 00 00 04 01 07 43 4f |AULT NUL|L.....CO|
|000025c0| 55 4e 54 52 59 02 0b 43 | 4f 55 4e 54 52 59 4e 41 |UNTRY..C|OUNTRYNA|
|000025d0| 4d 45 0d 04 09 00 00 00 | 08 04 25 00 00 00 0a 04 |ME......|..%.....|
|000025e0| 0f 00 00 00 09 04 00 00 | 00 00 0b 04 00 00 00 00 |........|........|
|000025f0| 16 04 0a 00 00 00 18 04 | 00 00 00 00 22 04 01 00 |........|...."...|
|00002600| 00 00 2a 04 00 00 00 00 | 00 04 01 0e 53 54 41 54 |..*.....|....STAT|
|00002610| 45 5f 50 52 4f 56 49 4e | 43 45 02 06 52 44 42 24 |E_PROVIN|CE..RDB$|
|00002620| 32 30 0d 04 08 00 00 00 | 08 04 25 00 00 00 0a 04 |20......|..%.....|
|00002630| 0f 00 00 00 09 04 00 00 | 00 00 0b 04 00 00 00 00 |........|........|
|00002640| 16 04 09 00 00 00 18 04 | 00 00 00 00 22 04 01 00 |........|...."...|
|00002650| 00 00 2a 04 00 00 00 00 | 2b 04 00 00 00 00 00 04 |..*.....|+.......|
|00002660| 01 04 43 49 54 59 02 06 | 52 44 42 24 31 39 0d 04 |..CITY..|RDB$19..|
|00002670| 07 00 00 00 08 04 25 00 | 00 00 0a 04 19 00 00 00 |......%.|........|
|00002680| 09 04 00 00 00 00 0b 04 | 00 00 00 00 16 04 08 00 |........|........|
|00002690| 00 00 18 04 00 00 00 00 | 22 04 01 00 00 00 2a 04 |........|".....*.|
|000026a0| 00 00 00 00 2b 04 00 00 | 00 00 00 04 01 0d 43 4f |....+...|......CO|
|000026b0| 4e 54 41 43 54 5f 46 49 | 52 53 54 02 09 46 49 52 |NTACT_FI|RST..FIR|
|000026c0| 53 54 4e 41 4d 45 0d 04 | 02 00 00 00 08 04 25 00 |STNAME..|......%.|
|000026d0| 00 00 0a 04 0f 00 00 00 | 09 04 00 00 00 00 0b 04 |........|........|
|000026e0| 00 00 00 00 16 04 03 00 | 00 00 18 04 00 00 00 00 |........|........|
|000026f0| 22 04 01 00 00 00 2a 04 | 00 00 00 00 00 04 01 08 |".....*.|........|
|00002700| 43 55 53 54 4f 4d 45 52 | 02 06 52 44 42 24 31 38 |CUSTOMER|..RDB$18|
|00002710| 0d 04 01 00 00 00 08 04 | 25 00 00 00 0a 04 19 00 |........|%.......|
|00002720| 00 00 09 04 00 00 00 00 | 0b 04 00 00 00 00 16 04 |........|........|
|00002730| 02 00 00 00 18 04 00 00 | 00 00 22 04 01 00 00 00 |........|..".....|
|00002740| 26 04 01 00 00 00 2a 04 | 00 00 00 00 2b 04 00 00 |&.....*.|....+...|
|00002750| 00 00 00 09 03 01 05 53 | 41 4c 45 53 10 04 01 00 |.......S|ALES....|
|00002760| 00 00 08 09 53 51 4c 24 | 53 41 4c 45 53 0c 06 53 |....SQL$|SALES..S|
|00002770| 59 53 44 42 41 00 04 01 | 04 41 47 45 44 02 06 52 |YSDBA...|.AGED..R|
|00002780| 44 42 24 33 31 0d 04 0c | 00 00 00 08 04 1b 00 00 |DB$31...|........|
|00002790| 00 0a 04 08 00 00 00 09 | 04 00 00 00 00 0b 04 00 |........|........|
|000027a0| 00 00 00 16 04 0d 00 00 | 00 18 04 00 00 00 00 22 |........|......."|
|000027b0| 04 00 00 00 00 17 04 01 | 00 00 00 00 04 01 0b 44 |........|.......D|
|000027c0| 41 54 45 5f 4e 45 45 44 | 45 44 02 06 52 44 42 24 |ATE_NEED|ED..RDB$|
|000027d0| 32 36 0d 04 06 00 00 00 | 08 04 23 00 00 00 0a 04 |26......|..#.....|
|000027e0| 08 00 00 00 09 04 00 00 | 00 00 0b 04 00 00 00 00 |........|........|
|000027f0| 16 04 07 00 00 00 18 04 | 00 00 00 00 22 04 01 00 |........|...."...|
|00002800| 00 00 00 04 01 09 53 48 | 49 50 5f 44 41 54 45 02 |......SH|IP_DATE.|
|00002810| 06 52 44 42 24 32 35 0d | 04 05 00 00 00 08 04 23 |.RDB$25.|.......#|
|00002820| 00 00 00 0a 04 08 00 00 | 00 09 04 00 00 00 00 0b |........|........|
|00002830| 04 00 00 00 00 16 04 06 | 00 00 00 18 04 00 00 00 |........|........|
|00002840| 00 22 04 01 00 00 00 00 | 04 01 0a 4f 52 44 45 52 |."......|...ORDER|
|00002850| 5f 44 41 54 45 02 06 52 | 44 42 24 32 34 0d 04 04 |_DATE..R|DB$24...|
|00002860| 00 00 00 08 04 23 00 00 | 00 0a 04 08 00 00 00 09 |.....#..|........|
|00002870| 04 00 00 00 00 0b 04 00 | 00 00 00 16 04 05 00 00 |........|........|
|00002880| 00 18 04 00 00 00 00 22 | 04 01 00 00 00 26 04 01 |......."|.....&..|
|00002890| 00 00 00 0f 04 0b 00 00 | 00 04 15 0f 7f 00 03 00 |........|........|
|000028a0| 6e 6f 77 4c 27 04 0e 00 | 00 00 44 45 46 41 55 4c |nowL'...|..DEFAUL|
|000028b0| 54 20 27 6e 6f 77 27 00 | 00 04 01 09 50 4f 5f 4e |T 'now'.|....PO_N|
|000028c0| 55 4d 42 45 52 02 08 50 | 4f 4e 55 4d 42 45 52 0d |UMBER..P|ONUMBER.|
|000028d0| 04 00 00 00 00 08 04 0e | 00 00 00 0a 04 08 00 00 |........|........|
|000028e0| 00 09 04 00 00 00 00 0b | 04 00 00 00 00 16 04 01 |........|........|
|000028f0| 00 00 00 18 04 00 00 00 | 00 22 04 01 00 00 00 26 |........|.".....&|
|00002900| 04 01 00 00 00 2a 04 00 | 00 00 00 00 04 01 08 44 |.....*..|.......D|
|00002910| 49 53 43 4f 55 4e 54 02 | 06 52 44 42 24 33 30 0d |ISCOUNT.|.RDB$30.|
|00002920| 04 0a 00 00 00 08 04 0a | 00 00 00 0a 04 04 00 00 |........|........|
|00002930| 00 09 04 00 00 00 00 0b | 04 00 00 00 00 16 04 0b |........|........|
|00002940| 00 00 00 18 04 00 00 00 | 00 22 04 01 00 00 00 26 |........|.".....&|
|00002950| 04 01 00 00 00 0f 04 09 | 00 00 00 04 15 08 00 00 |........|........|
|00002960| 00 00 00 4c 27 04 0a 00 | 00 00 44 45 46 41 55 4c |...L'...|..DEFAUL|
|00002970| 54 20 30 00 00 04 01 0b | 54 4f 54 41 4c 5f 56 41 |T 0.....|TOTAL_VA|
|00002980| 4c 55 45 02 06 52 44 42 | 24 32 39 0d 04 09 00 00 |LUE..RDB|$29.....|
|00002990| 00 08 04 08 00 00 00 0a | 04 04 00 00 00 09 04 00 |........|........|
|000029a0| 00 00 00 0b 04 fe ff ff | ff 16 04 0a 00 00 00 18 |........|........|
|000029b0| 04 00 00 00 00 22 04 01 | 00 00 00 26 04 01 00 00 |....."..|...&....|
|000029c0| 00 00 04 01 0b 51 54 59 | 5f 4f 52 44 45 52 45 44 |.....QTY|_ORDERED|
|000029d0| 02 06 52 44 42 24 32 38 | 0d 04 08 00 00 00 08 04 |..RDB$28|........|
|000029e0| 08 00 00 00 0a 04 04 00 | 00 00 09 04 00 00 00 00 |........|........|
|000029f0| 0b 04 00 00 00 00 16 04 | 09 00 00 00 18 04 00 00 |........|........|
|00002a00| 00 00 22 04 01 00 00 00 | 26 04 01 00 00 00 0f 04 |..".....|&.......|
|00002a10| 09 00 00 00 04 15 08 00 | 01 00 00 00 4c 27 04 0a |........|....L'..|
|00002a20| 00 00 00 44 45 46 41 55 | 4c 54 20 31 00 00 04 01 |...DEFAU|LT 1....|
|00002a30| 07 43 55 53 54 5f 4e 4f | 02 06 43 55 53 54 4e 4f |.CUST_NO|..CUSTNO|
|00002a40| 0d 04 01 00 00 00 08 04 | 08 00 00 00 0a 04 04 00 |........|........|
|00002a50| 00 00 09 04 00 00 00 00 | 0b 04 00 00 00 00 16 04 |........|........|
|00002a60| 02 00 00 00 18 04 00 00 | 00 00 22 04 01 00 00 00 |........|..".....|
|00002a70| 26 04 01 00 00 00 00 04 | 01 09 49 54 45 4d 5f 54 |&.......|..ITEM_T|
|00002a80| 59 50 45 02 08 50 52 4f | 44 54 59 50 45 0d 04 0b |YPE..PRO|DTYPE...|
|00002a90| 00 00 00 08 04 25 00 00 | 00 0a 04 0c 00 00 00 09 |.....%..|........|
|00002aa0| 04 00 00 00 00 0b 04 00 | 00 00 00 16 04 0c 00 00 |........|........|
|00002ab0| 00 18 04 00 00 00 00 22 | 04 01 00 00 00 2a 04 00 |......."|.....*..|
|00002ac0| 00 00 00 00 04 01 09 53 | 41 4c 45 53 5f 52 45 50 |.......S|ALES_REP|
|00002ad0| 02 05 45 4d 50 4e 4f 0d | 04 02 00 00 00 08 04 07 |..EMPNO.|........|
|00002ae0| 00 00 00 0a 04 02 00 00 | 00 09 04 00 00 00 00 0b |........|........|
|00002af0| 04 00 00 00 00 16 04 03 | 00 00 00 18 04 00 00 00 |........|........|
|00002b00| 00 22 04 01 00 00 00 00 | 04 01 04 50 41 49 44 02 |."......|...PAID.|
|00002b10| 06 52 44 42 24 32 37 0d | 04 07 00 00 00 08 04 0e |.RDB$27.|........|
|00002b20| 00 00 00 0a 04 01 00 00 | 00 09 04 00 00 00 00 0b |........|........|
|00002b30| 04 00 00 00 00 16 04 08 | 00 00 00 18 04 00 00 00 |........|........|
|00002b40| 00 22 04 01 00 00 00 2a | 04 00 00 00 00 2b 04 00 |.".....*|.....+..|
|00002b50| 00 00 00 0f 04 09 00 00 | 00 04 15 0f 7f 00 01 00 |........|........|
|00002b60| 6e 4c 27 04 0c 00 00 00 | 44 45 46 41 55 4c 54 20 |nL'.....|DEFAULT |
|00002b70| 27 6e 27 00 00 04 01 0c | 4f 52 44 45 52 5f 53 54 |'n'.....|ORDER_ST|
|00002b80| 41 54 55 53 02 06 52 44 | 42 24 32 33 0d 04 03 00 |ATUS..RD|B$23....|
|00002b90| 00 00 08 04 25 00 00 00 | 0a 04 07 00 00 00 09 04 |....%...|........|
|00002ba0| 00 00 00 00 0b 04 00 00 | 00 00 16 04 04 00 00 00 |........|........|
|00002bb0| 18 04 00 00 00 00 22 04 | 01 00 00 00 26 04 01 00 |......".|....&...|
|00002bc0| 00 00 2a 04 00 00 00 00 | 2b 04 00 00 00 00 0f 04 |..*.....|+.......|
|00002bd0| 0b 00 00 00 04 15 0f 7f | 00 03 00 6e 65 77 4c 27 |........|...newL'|
|00002be0| 04 0e 00 00 00 44 45 46 | 41 55 4c 54 20 27 6e 65 |.....DEF|AULT 'ne|
|00002bf0| 77 27 00 00 09 03 01 10 | 50 52 4f 4a 5f 44 45 50 |w'......|PROJ_DEP|
|00002c00| 54 5f 42 55 44 47 45 54 | 10 04 01 00 00 00 08 14 |T_BUDGET|........|
|00002c10| 53 51 4c 24 50 52 4f 4a | 5f 44 45 50 54 5f 42 55 |SQL$PROJ|_DEPT_BU|
|00002c20| 44 47 45 54 0c 06 53 59 | 53 44 42 41 00 04 01 10 |DGET..SY|SDBA....|
|00002c30| 50 52 4f 4a 45 43 54 45 | 44 5f 42 55 44 47 45 54 |PROJECTE|D_BUDGET|
|00002c40| 02 06 42 55 44 47 45 54 | 0d 04 04 00 00 00 08 04 |..BUDGET|........|
|00002c50| 1b 00 00 00 0a 04 08 00 | 00 00 09 04 00 00 00 00 |........|........|
|00002c60| 0b 04 fe ff ff ff 16 04 | 05 00 00 00 18 04 00 00 |........|........|
|00002c70| 00 00 22 04 01 00 00 00 | 00 04 01 0e 51 55 41 52 |..".....|....QUAR|
|00002c80| 54 5f 48 45 41 44 5f 43 | 4e 54 02 06 52 44 42 24 |T_HEAD_C|NT..RDB$|
|00002c90| 31 33 0d 04 03 00 00 00 | 08 04 08 00 00 00 0a 04 |13......|........|
|00002ca0| 04 00 00 00 09 04 00 00 | 00 00 0b 04 00 00 00 00 |........|........|
|00002cb0| 16 04 04 00 00 00 18 04 | 00 00 00 00 22 04 01 00 |........|...."...|
|00002cc0| 00 00 1d 04 01 00 00 00 | 20 04 01 00 00 00 21 04 |........| .....!.|
|00002cd0| 04 00 00 00 00 04 01 04 | 59 45 41 52 02 06 52 44 |........|YEAR..RD|
|00002ce0| 42 24 31 32 0d 04 00 00 | 00 00 08 04 08 00 00 00 |B$12....|........|
|00002cf0| 0a 04 04 00 00 00 09 04 | 00 00 00 00 0b 04 00 00 |........|........|
|00002d00| 00 00 16 04 01 00 00 00 | 18 04 00 00 00 00 22 04 |........|......".|
|00002d10| 01 00 00 00 26 04 01 00 | 00 00 00 04 01 07 44 45 |....&...|......DE|
|00002d20| 50 54 5f 4e 4f 02 06 44 | 45 50 54 4e 4f 0d 04 02 |PT_NO..D|EPTNO...|
|00002d30| 00 00 00 08 04 0e 00 00 | 00 0a 04 03 00 00 00 09 |........|........|
|00002d40| 04 00 00 00 00 0b 04 00 | 00 00 00 16 04 03 00 00 |........|........|
|00002d50| 00 18 04 00 00 00 00 22 | 04 01 00 00 00 26 04 01 |......."|.....&..|
|00002d60| 00 00 00 2a 04 00 00 00 | 00 00 04 01 07 50 52 4f |...*....|.....PRO|
|00002d70| 4a 5f 49 44 02 06 50 52 | 4f 4a 4e 4f 0d 04 01 00 |J_ID..PR|OJNO....|
|00002d80| 00 00 08 04 0e 00 00 00 | 0a 04 05 00 00 00 09 04 |........|........|
|00002d90| 00 00 00 00 0b 04 00 00 | 00 00 16 04 02 00 00 00 |........|........|
|00002da0| 18 04 00 00 00 00 22 04 | 01 00 00 00 26 04 01 00 |......".|....&...|
|00002db0| 00 00 2a 04 00 00 00 00 | 00 09 03 01 0e 53 41 4c |..*.....|.....SAL|
|00002dc0| 41 52 59 5f 48 49 53 54 | 4f 52 59 10 04 01 00 00 |ARY_HIST|ORY.....|
|00002dd0| 00 08 12 53 51 4c 24 53 | 41 4c 41 52 59 5f 48 49 |...SQL$S|ALARY_HI|
|00002de0| 53 54 4f 52 59 0c 06 53 | 59 53 44 42 41 00 04 01 |STORY..S|YSDBA...|
|00002df0| 0a 4e 45 57 5f 53 41 4c | 41 52 59 02 06 52 44 42 |.NEW_SAL|ARY..RDB|
|00002e00| 24 31 37 0d 04 05 00 00 | 00 08 04 1b 00 00 00 0a |$17.....|........|
|00002e10| 04 08 00 00 00 09 04 00 | 00 00 00 0b 04 00 00 00 |........|........|
|00002e20| 00 16 04 06 00 00 00 18 | 04 00 00 00 00 22 04 00 |........|....."..|
|00002e30| 00 00 00 17 04 01 00 00 | 00 00 04 01 0e 50 45 52 |........|.....PER|
|00002e40| 43 45 4e 54 5f 43 48 41 | 4e 47 45 02 06 52 44 42 |CENT_CHA|NGE..RDB|
|00002e50| 24 31 36 0d 04 04 00 00 | 00 08 04 1b 00 00 00 0a |$16.....|........|
|00002e60| 04 08 00 00 00 09 04 00 | 00 00 00 0b 04 00 00 00 |........|........|
|00002e70| 00 16 04 05 00 00 00 18 | 04 00 00 00 00 22 04 01 |........|....."..|
|00002e80| 00 00 00 26 04 01 00 00 | 00 0f 04 09 00 00 00 04 |...&....|........|
|00002e90| 15 08 00 00 00 00 00 4c | 27 04 0a 00 00 00 44 45 |.......L|'.....DE|
|00002ea0| 46 41 55 4c 54 20 30 00 | 00 04 01 0a 4f 4c 44 5f |FAULT 0.|....OLD_|
|00002eb0| 53 41 4c 41 52 59 02 06 | 53 41 4c 41 52 59 0d 04 |SALARY..|SALARY..|
|00002ec0| 03 00 00 00 08 04 1b 00 | 00 00 0a 04 08 00 00 00 |........|........|
|00002ed0| 09 04 00 00 00 00 0b 04 | fe ff ff ff 16 04 04 00 |........|........|
|00002ee0| 00 00 18 04 00 00 00 00 | 22 04 01 00 00 00 26 04 |........|".....&.|
|00002ef0| 01 00 00 00 00 04 01 0b | 43 48 41 4e 47 45 5f 44 |........|CHANGE_D|
|00002f00| 41 54 45 02 06 52 44 42 | 24 31 34 0d 04 01 00 00 |ATE..RDB|$14.....|
|00002f10| 00 08 04 23 00 00 00 0a | 04 08 00 00 00 09 04 00 |...#....|........|
|00002f20| 00 00 00 0b 04 00 00 00 | 00 16 04 02 00 00 00 18 |........|........|
|00002f30| 04 00 00 00 00 22 04 01 | 00 00 00 26 04 01 00 00 |....."..|...&....|
|00002f40| 00 0f 04 0b 00 00 00 04 | 15 0f 7f 00 03 00 4e 4f |........|......NO|
|00002f50| 57 4c 27 04 0e 00 00 00 | 44 45 46 41 55 4c 54 20 |WL'.....|DEFAULT |
|00002f60| 27 4e 4f 57 27 00 00 04 | 01 0a 55 50 44 41 54 45 |'NOW'...|..UPDATE|
|00002f70| 52 5f 49 44 02 06 52 44 | 42 24 31 35 0d 04 02 00 |R_ID..RD|B$15....|
|00002f80| 00 00 08 04 25 00 00 00 | 0a 04 14 00 00 00 09 04 |....%...|........|
|00002f90| 00 00 00 00 0b 04 00 00 | 00 00 16 04 03 00 00 00 |........|........|
|00002fa0| 18 04 00 00 00 00 22 04 | 01 00 00 00 26 04 01 00 |......".|....&...|
|00002fb0| 00 00 2a 04 00 00 00 00 | 2b 04 00 00 00 00 00 04 |..*.....|+.......|
|00002fc0| 01 06 45 4d 50 5f 4e 4f | 02 05 45 4d 50 4e 4f 0d |..EMP_NO|..EMPNO.|
|00002fd0| 04 00 00 00 00 08 04 07 | 00 00 00 0a 04 02 00 00 |........|........|
|00002fe0| 00 09 04 00 00 00 00 0b | 04 00 00 00 00 16 04 01 |........|........|
|00002ff0| 00 00 00 18 04 00 00 00 | 00 22 04 01 00 00 00 26 |........|.".....&|
|00003000| 04 01 00 00 00 00 09 1a | 01 0a 45 4d 50 5f 4e 4f |........|..EMP_NO|
|00003010| 5f 47 45 4e 02 04 91 00 | 00 00 00 1a 01 0b 43 55 |_GEN....|......CU|
|00003020| 53 54 5f 4e 4f 5f 47 45 | 4e 02 04 f7 03 00 00 00 |ST_NO_GE|N.......|
|00003030| 1b 01 0c 47 45 54 5f 45 | 4d 50 5f 50 52 4f 4a 02 |...GET_E|MP_PROJ.|
|00003040| 04 01 00 00 00 03 04 01 | 00 00 00 07 04 6f 00 00 |........|.....o..|
|00003050| 00 0a 42 45 47 49 4e 0a | 20 46 4f 52 20 53 45 4c |..BEGIN.| FOR SEL|
|00003060| 45 43 54 20 70 72 6f 6a | 5f 69 64 0a 20 20 46 52 |ECT proj|_id.  FR|
|00003070| 4f 4d 20 65 6d 70 6c 6f | 79 65 65 5f 70 72 6f 6a |OM emplo|yee_proj|
|00003080| 65 63 74 0a 20 20 57 48 | 45 52 45 20 65 6d 70 5f |ect.  WH|ERE emp_|
|00003090| 6e 6f 20 3d 20 3a 65 6d | 70 5f 6e 6f 0a 20 20 49 |no = :em|p_no.  I|
|000030a0| 4e 54 4f 20 3a 70 72 6f | 6a 5f 69 64 0a 20 44 4f |NTO :pro|j_id. DO|
|000030b0| 0a 20 20 53 55 53 50 45 | 4e 44 3b 0a 45 4e 44 00 |.  SUSPE|ND;.END.|
|000030c0| 08 04 9c 00 00 00 04 02 | 04 00 02 00 07 00 07 00 |........|........|
|000030d0| 04 01 03 00 0f 00 00 05 | 00 07 00 07 00 0c 00 02 |........|........|
|000030e0| 03 00 00 0f 00 00 05 00 | 01 2d 1a 00 00 9b 11 00 |........|.-......|
|000030f0| 02 02 07 43 01 4a 10 45 | 4d 50 4c 4f 59 45 45 5f |...C.J.E|MPLOYEE_|
|00003100| 50 52 4f 4a 45 43 54 00 | 47 2f 17 00 06 45 4d 50 |PROJECT.|G/...EMP|
|00003110| 5f 4e 4f 29 00 00 00 01 | 00 ff 02 01 17 00 07 50 |_NO)....|.......P|
|00003120| 52 4f 4a 5f 49 44 1a 00 | 00 02 0e 01 02 01 1a 00 |ROJ_ID..|........|
|00003130| 00 29 01 00 00 01 00 01 | 15 07 00 01 00 19 01 02 |.)......|........|
|00003140| 00 ff 9b ff ff ff ff ff | 0e 01 02 01 1a 00 00 29 |........|.......)|
|00003150| 01 00 00 01 00 01 15 07 | 00 00 00 19 01 02 00 ff |........|........|
|00003160| ff 4c 09 10 53 51 4c 24 | 47 45 54 5f 45 4d 50 5f |.L..SQL$|GET_EMP_|
|00003170| 50 52 4f 4a 0a 06 53 59 | 53 44 42 41 00 1c 01 06 |PROJ..SY|SDBA....|
|00003180| 45 4d 50 5f 4e 4f 02 04 | 00 00 00 00 03 04 00 00 |EMP_NO..|........|
|00003190| 00 00 04 06 52 44 42 24 | 33 32 00 1c 01 07 50 52 |....RDB$|32....PR|
|000031a0| 4f 4a 5f 49 44 02 04 00 | 00 00 00 03 04 01 00 00 |OJ_ID...|........|
|000031b0| 00 04 06 52 44 42 24 33 | 33 00 1d 1b 01 0c 41 44 |...RDB$3|3.....AD|
|000031c0| 44 5f 45 4d 50 5f 50 52 | 4f 4a 02 04 02 00 00 00 |D_EMP_PR|OJ......|
|000031d0| 03 04 00 00 00 00 07 04 | 9f 00 00 00 0a 42 45 47 |........|.....BEG|
|000031e0| 49 4e 0a 20 42 45 47 49 | 4e 0a 20 49 4e 53 45 52 |IN. BEGI|N. INSER|
|000031f0| 54 20 49 4e 54 4f 20 65 | 6d 70 6c 6f 79 65 65 5f |T INTO e|mployee_|
|00003200| 70 72 6f 6a 65 63 74 20 | 28 65 6d 70 5f 6e 6f 2c |project |(emp_no,|
|00003210| 20 70 72 6f 6a 5f 69 64 | 29 20 56 41 4c 55 45 53 | proj_id|) VALUES|
|00003220| 20 28 3a 65 6d 70 5f 6e | 6f 2c 20 3a 70 72 6f 6a | (:emp_n|o, :proj|
|00003230| 5f 69 64 29 3b 0a 20 57 | 48 45 4e 20 53 51 4c 43 |_id);. W|HEN SQLC|
|00003240| 4f 44 45 20 2d 35 33 30 | 20 44 4f 0a 20 20 45 58 |ODE -530| DO.  EX|
|00003250| 43 45 50 54 49 4f 4e 20 | 75 6e 6b 6e 6f 77 6e 5f |CEPTION |unknown_|
|00003260| 65 6d 70 5f 69 64 3b 0a | 20 45 4e 44 0a 20 53 55 |emp_id;.| END. SU|
|00003270| 53 50 45 4e 44 3b 0a 45 | 4e 44 00 08 04 9d 00 00 |SPEND;.E|ND......|
|00003280| 00 04 02 04 00 04 00 07 | 00 07 00 0f 00 00 05 00 |........|........|
|00003290| 07 00 04 01 01 00 07 00 | 0c 00 02 9b 11 00 02 02 |........|........|
|000032a0| 81 02 02 86 0f 4a 10 45 | 4d 50 4c 4f 59 45 45 5f |.....J.E|MPLOYEE_|
|000032b0| 50 52 4f 4a 45 43 54 00 | 02 01 29 00 00 00 01 00 |PROJECT.|..).....|
|000032c0| 17 00 06 45 4d 50 5f 4e | 4f 01 29 00 02 00 03 00 |...EMP_N|O.).....|
|000032d0| 17 00 07 50 52 4f 4a 5f | 49 44 ff 87 ff ff 82 01 |...PROJ_|ID......|
|000032e0| 00 01 ee fd 02 86 80 02 | 0e 55 4e 4b 4e 4f 57 4e |........|.UNKNOWN|
|000032f0| 5f 45 4d 50 5f 49 44 87 | ff ff 02 0e 01 02 01 15 |_EMP_ID.|........|
|00003300| 07 00 01 00 19 01 00 00 | ff 9b ff ff ff ff 0e 01 |........|........|
|00003310| 02 01 15 07 00 00 00 19 | 01 00 00 ff ff 4c 09 10 |........|.....L..|
|00003320| 53 51 4c 24 41 44 44 5f | 45 4d 50 5f 50 52 4f 4a |SQL$ADD_|EMP_PROJ|
|00003330| 0a 06 53 59 53 44 42 41 | 00 1c 01 06 45 4d 50 5f |..SYSDBA|....EMP_|
|00003340| 4e 4f 02 04 00 00 00 00 | 03 04 00 00 00 00 04 06 |NO......|........|
|00003350| 52 44 42 24 33 34 00 1c | 01 07 50 52 4f 4a 5f 49 |RDB$34..|..PROJ_I|
|00003360| 44 02 04 01 00 00 00 03 | 04 00 00 00 00 04 06 52 |D.......|.......R|
|00003370| 44 42 24 33 35 00 1d 1b | 01 0e 53 55 42 5f 54 4f |DB$35...|..SUB_TO|
|00003380| 54 5f 42 55 44 47 45 54 | 02 04 01 00 00 00 03 04 |T_BUDGET|........|
|00003390| 04 00 00 00 07 04 bc 00 | 00 00 0a 42 45 47 49 4e |........|...BEGIN|
|000033a0| 0a 20 53 45 4c 45 43 54 | 20 53 55 4d 28 62 75 64 |. SELECT| SUM(bud|
|000033b0| 67 65 74 29 2c 20 41 56 | 47 28 62 75 64 67 65 74 |get), AV|G(budget|
|000033c0| 29 2c 20 4d 49 4e 28 62 | 75 64 67 65 74 29 2c 20 |), MIN(b|udget), |
|000033d0| 4d 41 58 28 62 75 64 67 | 65 74 29 0a 20 20 46 52 |MAX(budg|et).  FR|
|000033e0| 4f 4d 20 64 65 70 61 72 | 74 6d 65 6e 74 0a 20 20 |OM depar|tment.  |
|000033f0| 57 48 45 52 45 20 68 65 | 61 64 5f 64 65 70 74 20 |WHERE he|ad_dept |
|00003400| 3d 20 3a 68 65 61 64 5f | 64 65 70 74 0a 20 20 49 |= :head_|dept.  I|
|00003410| 4e 54 4f 20 3a 74 6f 74 | 5f 62 75 64 67 65 74 2c |NTO :tot|_budget,|
|00003420| 20 3a 61 76 67 5f 62 75 | 64 67 65 74 2c 20 3a 6d | :avg_bu|dget, :m|
|00003430| 69 6e 5f 62 75 64 67 65 | 74 2c 20 3a 6d 61 78 5f |in_budge|t, :max_|
|00003440| 62 75 64 67 65 74 3b 0a | 20 53 55 53 50 45 4e 44 |budget;.| SUSPEND|
|00003450| 3b 0a 45 4e 44 00 08 04 | 41 01 00 00 04 02 04 00 |;.END...|A.......|
|00003460| 02 00 0f 00 00 03 00 07 | 00 04 01 09 00 1b 07 00 |........|........|
|00003470| 1b 07 00 1b 07 00 1b 07 | 00 07 00 0c 00 02 03 00 |........|........|
|00003480| 00 1b 01 2d 1a 00 00 03 | 01 00 1b 01 2d 1a 01 00 |...-....|....-...|
|00003490| 03 02 00 1b 01 2d 1a 02 | 00 03 03 00 1b 01 2d 1a |.....-..|......-.|
|000034a0| 03 00 9b 11 00 02 02 07 | 7f 43 01 4f 01 43 01 4a |........|.C.O.C.J|
|000034b0| 0a 44 45 50 41 52 54 4d | 45 4e 54 00 47 2f 17 00 |.DEPARTM|ENT.G/..|
|000034c0| 09 48 45 41 44 5f 44 45 | 50 54 29 00 00 00 01 00 |.HEAD_DE|PT).....|
|000034d0| ff 4e 00 4d 04 00 00 00 | 54 17 00 06 42 55 44 47 |.N.M....|T...BUDG|
|000034e0| 45 54 01 00 55 17 00 06 | 42 55 44 47 45 54 02 00 |ET..U...|BUDGET..|
|000034f0| 57 17 00 06 42 55 44 47 | 45 54 03 00 56 17 00 06 |W...BUDG|ET..V...|
|00003500| 42 55 44 47 45 54 ff 02 | 01 18 01 03 00 1a 00 00 |BUDGET..|........|
|00003510| 01 18 01 02 00 1a 01 00 | 01 18 01 01 00 1a 02 00 |........|........|
|00003520| 01 18 01 00 00 1a 03 00 | ff 02 0e 01 02 01 1a 00 |........|........|
|00003530| 00 29 01 00 00 01 00 01 | 1a 01 00 29 01 02 00 03 |.)......|...)....|
|00003540| 00 01 1a 02 00 29 01 04 | 00 05 00 01 1a 03 00 29 |.....)..|.......)|
|00003550| 01 06 00 07 00 01 15 07 | 00 01 00 19 01 08 00 ff |........|........|
|00003560| 9b ff ff ff ff 0e 01 02 | 01 1a 00 00 29 01 00 00 |........|....)...|
|00003570| 01 00 01 1a 01 00 29 01 | 02 00 03 00 01 1a 02 00 |......).|........|
|00003580| 29 01 04 00 05 00 01 1a | 03 00 29 01 06 00 07 00 |).......|..).....|
|00003590| 01 15 07 00 00 00 19 01 | 08 00 ff ff 4c 09 12 53 |........|....L..S|
|000035a0| 51 4c 24 53 55 42 5f 54 | 4f 54 5f 42 55 44 47 45 |QL$SUB_T|OT_BUDGE|
|000035b0| 54 0a 06 53 59 53 44 42 | 41 00 1c 01 09 48 45 41 |T..SYSDB|A....HEA|
|000035c0| 44 5f 44 45 50 54 02 04 | 00 00 00 00 03 04 00 00 |D_DEPT..|........|
|000035d0| 00 00 04 06 52 44 42 24 | 33 36 00 1c 01 0a 54 4f |....RDB$|36....TO|
|000035e0| 54 5f 42 55 44 47 45 54 | 02 04 00 00 00 00 03 04 |T_BUDGET|........|
|000035f0| 01 00 00 00 04 06 52 44 | 42 24 33 37 00 1c 01 0a |......RD|B$37....|
|00003600| 41 56 47 5f 42 55 44 47 | 45 54 02 04 01 00 00 00 |AVG_BUDG|ET......|
|00003610| 03 04 01 00 00 00 04 06 | 52 44 42 24 33 38 00 1c |........|RDB$38..|
|00003620| 01 0a 4d 49 4e 5f 42 55 | 44 47 45 54 02 04 02 00 |..MIN_BU|DGET....|
|00003630| 00 00 03 04 01 00 00 00 | 04 06 52 44 42 24 33 39 |........|..RDB$39|
|00003640| 00 1c 01 0a 4d 41 58 5f | 42 55 44 47 45 54 02 04 |....MAX_|BUDGET..|
|00003650| 03 00 00 00 03 04 01 00 | 00 00 04 06 52 44 42 24 |........|....RDB$|
|00003660| 34 30 00 1d 1b 01 0f 44 | 45 4c 45 54 45 5f 45 4d |40.....D|ELETE_EM|
|00003670| 50 4c 4f 59 45 45 02 04 | 01 00 00 00 03 04 00 00 |PLOYEE..|........|
|00003680| 00 00 07 04 cc 03 00 00 | 0a 20 44 45 43 4c 41 52 |........|. DECLAR|
|00003690| 45 20 56 41 52 49 41 42 | 4c 45 20 61 6e 79 5f 73 |E VARIAB|LE any_s|
|000036a0| 61 6c 65 73 20 49 4e 54 | 45 47 45 52 3b 0a 42 45 |ales INT|EGER;.BE|
|000036b0| 47 49 4e 0a 20 61 6e 79 | 5f 73 61 6c 65 73 20 3d |GIN. any|_sales =|
|000036c0| 20 30 3b 0a 0a 20 2f 2a | 0a 20 20 2a 20 49 66 20 | 0;.. /*|.  * If |
|000036d0| 74 68 65 72 65 20 61 72 | 65 20 61 6e 79 20 73 61 |there ar|e any sa|
|000036e0| 6c 65 73 20 72 65 63 6f | 72 64 73 20 72 65 66 65 |les reco|rds refe|
|000036f0| 72 65 6e 63 69 6e 67 20 | 74 68 69 73 20 65 6d 70 |rencing |this emp|
|00003700| 6c 6f 79 65 65 2c 0a 20 | 20 2a 20 63 61 6e 27 74 |loyee,. | * can't|
|00003710| 20 64 65 6c 65 74 65 20 | 74 68 65 20 65 6d 70 6c | delete |the empl|
|00003720| 6f 79 65 65 20 75 6e 74 | 69 6c 20 74 68 65 20 73 |oyee unt|il the s|
|00003730| 61 6c 65 73 20 61 72 65 | 20 72 65 2d 61 73 73 69 |ales are| re-assi|
|00003740| 67 6e 65 64 0a 20 20 2a | 20 74 6f 20 61 6e 6f 74 |gned.  *| to anot|
|00003750| 68 65 72 20 65 6d 70 6c | 6f 79 65 65 20 6f 72 20 |her empl|oyee or |
|00003760| 63 68 61 6e 67 65 64 20 | 74 6f 20 4e 55 4c 4c 2e |changed |to NULL.|
|00003770| 0a 20 20 2a 2f 0a 20 53 | 45 4c 45 43 54 20 63 6f |.  */. S|ELECT co|
|00003780| 75 6e 74 28 70 6f 5f 6e | 75 6d 62 65 72 29 0a 20 |unt(po_n|umber). |
|00003790| 46 52 4f 4d 20 73 61 6c | 65 73 0a 20 57 48 45 52 |FROM sal|es. WHER|
|000037a0| 45 20 73 61 6c 65 73 5f | 72 65 70 20 3d 20 3a 65 |E sales_|rep = :e|
|000037b0| 6d 70 5f 6e 75 6d 0a 20 | 49 4e 54 4f 20 3a 61 6e |mp_num. |INTO :an|
|000037c0| 79 5f 73 61 6c 65 73 3b | 0a 0a 20 49 46 20 28 61 |y_sales;|.. IF (a|
|000037d0| 6e 79 5f 73 61 6c 65 73 | 20 3e 20 30 29 20 54 48 |ny_sales| > 0) TH|
|000037e0| 45 4e 0a 20 42 45 47 49 | 4e 0a 20 20 45 58 43 45 |EN. BEGI|N.  EXCE|
|000037f0| 50 54 49 4f 4e 20 72 65 | 61 73 73 69 67 6e 5f 73 |PTION re|assign_s|
|00003800| 61 6c 65 73 3b 0a 20 20 | 53 55 53 50 45 4e 44 3b |ales;.  |SUSPEND;|
|00003810| 0a 20 45 4e 44 0a 0a 20 | 2f 2a 0a 20 20 2a 20 49 |. END.. |/*.  * I|
|00003820| 66 20 74 68 65 20 65 6d | 70 6c 6f 79 65 65 20 69 |f the em|ployee i|
|00003830| 73 20 61 20 6d 61 6e 61 | 67 65 72 2c 20 75 70 64 |s a mana|ger, upd|
|00003840| 61 74 65 20 74 68 65 20 | 64 65 70 61 72 74 6d 65 |ate the |departme|
|00003850| 6e 74 2e 0a 20 20 2a 2f | 0a 20 55 50 44 41 54 45 |nt..  */|. UPDATE|
|00003860| 20 64 65 70 61 72 74 6d | 65 6e 74 0a 20 53 45 54 | departm|ent. SET|
|00003870| 20 6d 6e 67 72 5f 6e 6f | 20 3d 20 4e 55 4c 4c 0a | mngr_no| = NULL.|
|00003880| 20 57 48 45 52 45 20 6d | 00 6e 67 72 5f 6e 6f 20 | WHERE m|.ngr_no |
|00003890| 3d 20 3a 65 6d 70 5f 6e | 75 6d 3b 0a 0a 20 2f 2a |= :emp_n|um;.. /*|
|000038a0| 0a 20 20 2a 20 49 66 20 | 74 68 65 20 65 6d 70 6c |.  * If |the empl|
|000038b0| 6f 79 65 65 20 69 73 20 | 61 20 70 72 6f 6a 65 63 |oyee is |a projec|
|000038c0| 74 20 6c 65 61 64 65 72 | 2c 20 75 70 64 61 74 65 |t leader|, update|
|000038d0| 20 70 72 6f 6a 65 63 74 | 2e 0a 20 20 2a 2f 0a 20 | project|..  */. |
|000038e0| 55 50 44 41 54 45 20 70 | 72 6f 6a 65 63 74 0a 20 |UPDATE p|roject. |
|000038f0| 53 45 54 20 74 65 61 6d | 5f 6c 65 61 64 65 72 20 |SET team|_leader |
|00003900| 3d 20 4e 55 4c 4c 0a 20 | 57 48 45 52 45 20 74 65 |= NULL. |WHERE te|
|00003910| 61 6d 5f 6c 65 61 64 65 | 72 20 3d 20 3a 65 6d 70 |am_leade|r = :emp|
|00003920| 5f 6e 75 6d 3b 0a 0a 20 | 2f 2a 0a 20 20 2a 20 44 |_num;.. |/*.  * D|
|00003930| 65 6c 65 74 65 20 74 68 | 65 20 65 6d 70 6c 6f 79 |elete th|e employ|
|00003940| 65 65 20 66 72 6f 6d 20 | 61 6e 79 20 70 72 6f 6a |ee from |any proj|
|00003950| 65 63 74 73 2e 0a 20 20 | 2a 2f 0a 20 44 45 4c 45 |ects..  |*/. DELE|
|00003960| 54 45 20 46 52 4f 4d 20 | 65 6d 70 6c 6f 79 65 65 |TE FROM |employee|
|00003970| 5f 70 72 6f 6a 65 63 74 | 0a 20 57 48 45 52 45 20 |_project|. WHERE |
|00003980| 65 6d 70 5f 6e 6f 20 3d | 20 3a 65 6d 70 5f 6e 75 |emp_no =| :emp_nu|
|00003990| 6d 3b 0a 0a 20 2f 2a 0a | 20 20 2a 20 44 65 6c 65 |m;.. /*.|  * Dele|
|000039a0| 74 65 20 6f 6c 64 20 73 | 61 6c 61 72 79 20 72 65 |te old s|alary re|
|000039b0| 63 6f 72 64 73 2e 0a 20 | 20 2a 2f 0a 20 44 45 4c |cords.. | */. DEL|
|000039c0| 45 54 45 20 46 52 4f 4d | 20 73 61 6c 61 72 79 5f |ETE FROM| salary_|
|000039d0| 68 69 73 74 6f 72 79 0a | 20 57 48 45 52 45 20 65 |history.| WHERE e|
|000039e0| 6d 70 5f 6e 6f 20 3d 20 | 3a 65 6d 70 5f 6e 75 6d |mp_no = |:emp_num|
|000039f0| 3b 0a 0a 20 2f 2a 0a 20 | 20 2a 20 44 65 6c 65 74 |;.. /*. | * Delet|
|00003a00| 65 20 74 68 65 20 65 6d | 70 6c 6f 79 65 65 2e 0a |e the em|ployee..|
|00003a10| 20 20 2a 2f 0a 20 44 45 | 4c 45 54 45 20 46 52 4f |  */. DE|LETE FRO|
|00003a20| 4d 20 65 6d 70 6c 6f 79 | 65 65 0a 20 57 48 45 52 |M employ|ee. WHER|
|00003a30| 45 20 65 6d 70 5f 6e 6f | 20 3d 20 3a 65 6d 70 5f |E emp_no| = :emp_|
|00003a40| 6e 75 6d 3b 0a 0a 20 53 | 55 53 50 45 4e 44 3b 0a |num;.. S|USPEND;.|
|00003a50| 45 4e 44 00 08 04 a9 01 | 00 00 04 02 04 00 02 00 |END.....|........|
|00003a60| 08 00 07 00 04 01 01 00 | 07 00 0c 00 02 03 00 00 |........|........|
|00003a70| 08 00 01 2d 1a 00 00 9b | 11 00 02 02 01 15 08 00 |...-....|........|
|00003a80| 00 00 00 00 1a 00 00 07 | 7f 43 01 4f 01 43 01 4a |........|.C.O.C.J|
|00003a90| 05 53 41 4c 45 53 00 47 | 2f 17 00 09 53 41 4c 45 |.SALES.G|/...SALE|
|00003aa0| 53 5f 52 45 50 29 00 00 | 00 01 00 ff 4e 00 4d 01 |S_REP)..|....N.M.|
|00003ab0| 00 00 00 5d 17 00 09 50 | 4f 5f 4e 55 4d 42 45 52 |...]...P|O_NUMBER|
|00003ac0| ff 02 01 18 01 00 00 1a | 00 00 ff 08 31 1a 00 00 |........|....1...|
|00003ad0| 15 08 00 00 00 00 00 02 | 02 80 02 0e 52 45 41 53 |........|....REAS|
|00003ae0| 53 49 47 4e 5f 53 41 4c | 45 53 02 0e 01 02 01 15 |SIGN_SAL|ES......|
|00003af0| 07 00 01 00 19 01 00 00 | ff 9b ff ff ff ff 07 43 |........|.......C|
|00003b00| 01 4a 0a 44 45 50 41 52 | 54 4d 45 4e 54 02 47 2f |.J.DEPAR|TMENT.G/|
|00003b10| 17 02 07 4d 4e 47 52 5f | 4e 4f 29 00 00 00 01 00 |...MNGR_|NO).....|
|00003b20| ff 0a 02 02 02 01 2d 17 | 02 07 4d 4e 47 52 5f 4e |......-.|..MNGR_N|
|00003b30| 4f ff 07 43 01 4a 07 50 | 52 4f 4a 45 43 54 03 47 |O..C.J.P|ROJECT.G|
|00003b40| 2f 17 03 0b 54 45 41 4d | 5f 4c 45 41 44 45 52 29 |/...TEAM|_LEADER)|
|00003b50| 00 00 00 01 00 ff 0a 03 | 03 02 01 2d 17 03 0b 54 |........|...-...T|
|00003b60| 45 41 4d 5f 4c 45 41 44 | 45 52 ff 07 43 01 4a 10 |EAM_LEAD|ER..C.J.|
|00003b70| 45 4d 50 4c 4f 59 45 45 | 5f 50 52 4f 4a 45 43 54 |EMPLOYEE|_PROJECT|
|00003b80| 04 47 2f 17 04 06 45 4d | 50 5f 4e 4f 29 00 00 00 |.G/...EM|P_NO)...|
|00003b90| 01 00 ff 05 04 07 43 01 | 4a 0e 53 41 4c 41 52 59 |......C.|J.SALARY|
|00003ba0| 5f 48 49 53 54 4f 52 59 | 05 47 2f 17 05 06 45 4d |_HISTORY|.G/...EM|
|00003bb0| 50 5f 4e 4f 29 00 00 00 | 01 00 ff 05 05 07 43 01 |P_NO)...|......C.|
|00003bc0| 4a 08 45 4d 50 4c 4f 59 | 45 45 06 47 2f 17 06 06 |J.EMPLOY|EE.G/...|
|00003bd0| 45 4d 50 5f 4e 4f 29 00 | 00 00 01 00 ff 05 06 02 |EMP_NO).|........|
|00003be0| 0e 01 02 01 15 07 00 01 | 00 19 01 00 00 ff 9b ff |........|........|
|00003bf0| ff ff ff 0e 01 02 01 15 | 07 00 00 00 19 01 00 00 |........|........|
|00003c00| ff ff 4c 09 13 53 51 4c | 24 44 45 4c 45 54 45 5f |..L..SQL|$DELETE_|
|00003c10| 45 4d 50 4c 4f 59 45 45 | 0a 06 53 59 53 44 42 41 |EMPLOYEE|..SYSDBA|
|00003c20| 00 1c 01 07 45 4d 50 5f | 4e 55 4d 02 04 00 00 00 |....EMP_|NUM.....|
|00003c30| 00 03 04 00 00 00 00 04 | 06 52 44 42 24 34 31 00 |........|.RDB$41.|
|00003c40| 1d 1b 01 0b 44 45 50 54 | 5f 42 55 44 47 45 54 02 |....DEPT|_BUDGET.|
|00003c50| 04 01 00 00 00 03 04 01 | 00 00 00 07 04 e1 01 00 |........|........|
|00003c60| 00 0a 20 44 45 43 4c 41 | 52 45 20 56 41 52 49 41 |.. DECLA|RE VARIA|
|00003c70| 42 4c 45 20 73 75 6d 62 | 20 44 45 43 49 4d 41 4c |BLE sumb| DECIMAL|
|00003c80| 28 31 32 2c 20 32 29 3b | 0a 20 44 45 43 4c 41 52 |(12, 2);|. DECLAR|
|00003c90| 45 20 56 41 52 49 41 42 | 4c 45 20 72 64 6e 6f 20 |E VARIAB|LE rdno |
|00003ca0| 43 48 41 52 28 33 29 3b | 0a 20 44 45 43 4c 41 52 |CHAR(3);|. DECLAR|
|00003cb0| 45 20 56 41 52 49 41 42 | 4c 45 20 63 6e 74 20 49 |E VARIAB|LE cnt I|
|00003cc0| 4e 54 45 47 45 52 3b 0a | 42 45 47 49 4e 0a 20 74 |NTEGER;.|BEGIN. t|
|00003cd0| 6f 74 20 3d 20 30 3b 0a | 0a 20 53 45 4c 45 43 54 |ot = 0;.|. SELECT|
|00003ce0| 20 62 75 64 67 65 74 20 | 46 52 4f 4d 20 64 65 70 | budget |FROM dep|
|00003cf0| 61 72 74 6d 65 6e 74 20 | 57 48 45 52 45 20 64 65 |artment |WHERE de|
|00003d00| 70 74 5f 6e 6f 20 3d 20 | 3a 64 6e 6f 20 49 4e 54 |pt_no = |:dno INT|
|00003d10| 4f 20 3a 74 6f 74 3b 0a | 0a 20 53 45 4c 45 43 54 |O :tot;.|. SELECT|
|00003d20| 20 63 6f 75 6e 74 28 62 | 75 64 67 65 74 29 20 46 | count(b|udget) F|
|00003d30| 52 4f 4d 20 64 65 70 61 | 72 74 6d 65 6e 74 20 57 |ROM depa|rtment W|
|00003d40| 48 45 52 45 20 68 65 61 | 64 5f 64 65 70 74 20 3d |HERE hea|d_dept =|
|00003d50| 20 3a 64 6e 6f 20 49 4e | 54 4f 20 3a 63 6e 74 3b | :dno IN|TO :cnt;|
|00003d60| 0a 0a 20 49 46 20 28 63 | 6e 74 20 3d 20 30 29 20 |.. IF (c|nt = 0) |
|00003d70| 54 48 45 4e 0a 20 20 53 | 55 53 50 45 4e 44 3b 0a |THEN.  S|USPEND;.|
|00003d80| 0a 20 46 4f 52 20 53 45 | 4c 45 43 54 20 64 65 70 |. FOR SE|LECT dep|
|00003d90| 74 5f 6e 6f 0a 20 20 46 | 52 4f 4d 20 64 65 70 61 |t_no.  F|ROM depa|
|00003da0| 72 74 6d 65 6e 74 0a 20 | 20 57 48 45 52 45 20 68 |rtment. | WHERE h|
|00003db0| 65 61 64 5f 64 65 70 74 | 20 3d 20 3a 64 6e 6f 0a |ead_dept| = :dno.|
|00003dc0| 20 20 49 4e 54 4f 20 3a | 72 64 6e 6f 0a 20 44 4f |  INTO :|rdno. DO|
|00003dd0| 0a 20 20 42 45 47 49 4e | 0a 20 20 20 45 58 45 43 |.  BEGIN|.   EXEC|
|00003de0| 55 54 45 20 50 52 4f 43 | 45 44 55 52 45 20 64 65 |UTE PROC|EDURE de|
|00003df0| 70 74 5f 62 75 64 67 65 | 74 20 3a 72 64 6e 6f 20 |pt_budge|t :rdno |
|00003e00| 52 45 54 55 52 4e 49 4e | 47 5f 56 41 4c 55 45 53 |RETURNIN|G_VALUES|
|00003e10| 20 3a 73 75 6d 62 3b 0a | 20 20 20 74 6f 74 20 3d | :sumb;.|   tot =|
|00003e20| 20 74 6f 74 20 2b 20 73 | 75 6d 62 3b 0a 20 20 45 | tot + s|umb;.  E|
|00003e30| 4e 44 0a 0a 20 53 55 53 | 50 45 4e 44 3b 0a 45 4e |ND.. SUS|PEND;.EN|
|00003e40| 44 00 08 04 86 01 00 00 | 04 02 04 00 02 00 0f 00 |D.......|........|
|00003e50| 00 03 00 07 00 04 01 03 | 00 1b 07 00 07 00 0c 00 |........|........|
|00003e60| 02 03 00 00 1b 01 2d 1a | 00 00 03 01 00 1b 01 2d |......-.|.......-|
|00003e70| 1a 01 00 03 02 00 0f 00 | 00 03 00 01 2d 1a 02 00 |........|....-...|
|00003e80| 03 03 00 08 00 01 2d 1a | 03 00 9b 11 00 02 02 01 |......-.|........|
|00003e90| 15 08 00 00 00 00 00 1a | 00 00 07 7f 43 01 4a 0a |........|....C.J.|
|00003ea0| 44 45 50 41 52 54 4d 45 | 4e 54 00 47 2f 17 00 07 |DEPARTME|NT.G/...|
|00003eb0| 44 45 50 54 5f 4e 4f 29 | 00 00 00 01 00 ff 02 01 |DEPT_NO)|........|
|00003ec0| 17 00 06 42 55 44 47 45 | 54 1a 00 00 ff 07 7f 43 |...BUDGE|T......C|
|00003ed0| 01 4f 02 43 01 4a 0a 44 | 45 50 41 52 54 4d 45 4e |.O.C.J.D|EPARTMEN|
|00003ee0| 54 01 47 2f 17 01 09 48 | 45 41 44 5f 44 45 50 54 |T.G/...H|EAD_DEPT|
|00003ef0| 29 00 00 00 01 00 ff 4e | 00 4d 01 00 00 00 5d 17 |)......N|.M....].|
|00003f00| 01 06 42 55 44 47 45 54 | ff 02 01 18 02 00 00 1a |..BUDGET|........|
|00003f10| 03 00 ff 08 2f 1a 03 00 | 15 08 00 00 00 00 00 02 |..../...|........|
|00003f20| 0e 01 02 01 1a 00 00 29 | 01 00 00 01 00 01 15 07 |.......)|........|
|00003f30| 00 01 00 19 01 02 00 ff | 9b ff ff 07 43 01 4a 0a |........|....C.J.|
|00003f40| 44 45 50 41 52 54 4d 45 | 4e 54 03 47 2f 17 03 09 |DEPARTME|NT.G/...|
|00003f50| 48 45 41 44 5f 44 45 50 | 54 29 00 00 00 01 00 ff |HEAD_DEP|T)......|
|00003f60| 02 01 17 03 07 44 45 50 | 54 5f 4e 4f 1a 02 00 02 |.....DEP|T_NO....|
|00003f70| 02 78 0b 44 45 50 54 5f | 42 55 44 47 45 54 01 00 |.x.DEPT_|BUDGET..|
|00003f80| 1a 02 00 01 00 1a 01 00 | 01 22 1a 00 00 1a 01 00 |........|."......|
|00003f90| 1a 00 00 ff ff ff 02 0e | 01 02 01 1a 00 00 29 01 |........|......).|
|00003fa0| 00 00 01 00 01 15 07 00 | 01 00 19 01 02 00 ff 9b |........|........|
|00003fb0| ff ff ff ff 0e 01 02 01 | 1a 00 00 29 01 00 00 01 |........|...)....|
|00003fc0| 00 01 15 07 00 00 00 19 | 01 02 00 ff ff 4c 09 0f |........|.....L..|
|00003fd0| 53 51 4c 24 44 45 50 54 | 5f 42 55 44 47 45 54 0a |SQL$DEPT|_BUDGET.|
|00003fe0| 06 53 59 53 44 42 41 00 | 1c 01 03 44 4e 4f 02 04 |.SYSDBA.|...DNO..|
|00003ff0| 00 00 00 00 03 04 00 00 | 00 00 04 06 52 44 42 24 |........|....RDB$|
|00004000| 34 32 00 1c 01 03 54 4f | 54 02 04 00 00 00 00 03 |42....TO|T.......|
|00004010| 04 01 00 00 00 04 06 52 | 44 42 24 34 33 00 1d 1b |.......R|DB$43...|
|00004020| 01 09 4f 52 47 5f 43 48 | 41 52 54 02 04 00 00 00 |..ORG_CH|ART.....|
|00004030| 00 03 04 05 00 00 00 07 | 04 4b 02 00 00 0a 20 44 |........|.K.... D|
|00004040| 45 43 4c 41 52 45 20 56 | 41 52 49 41 42 4c 45 20 |ECLARE V|ARIABLE |
|00004050| 6d 6e 67 72 5f 6e 6f 20 | 49 4e 54 45 47 45 52 3b |mngr_no |INTEGER;|
|00004060| 0a 20 44 45 43 4c 41 52 | 45 20 56 41 52 49 41 42 |. DECLAR|E VARIAB|
|00004070| 4c 45 20 64 6e 6f 20 43 | 48 41 52 28 33 29 3b 0a |LE dno C|HAR(3);.|
|00004080| 42 45 47 49 4e 0a 20 46 | 4f 52 20 53 45 4c 45 43 |BEGIN. F|OR SELEC|
|00004090| 54 20 68 2e 64 65 70 61 | 72 74 6d 65 6e 74 2c 20 |T h.depa|rtment, |
|000040a0| 64 2e 64 65 70 61 72 74 | 6d 65 6e 74 2c 20 64 2e |d.depart|ment, d.|
|000040b0| 6d 6e 67 72 5f 6e 6f 2c | 20 64 2e 64 65 70 74 5f |mngr_no,| d.dept_|
|000040c0| 6e 6f 0a 20 20 46 52 4f | 4d 20 64 65 70 61 72 74 |no.  FRO|M depart|
|000040d0| 6d 65 6e 74 20 64 0a 20 | 20 4c 45 46 54 20 4f 55 |ment d. | LEFT OU|
|000040e0| 54 45 52 20 4a 4f 49 4e | 20 64 65 70 61 72 74 6d |TER JOIN| departm|
|000040f0| 65 6e 74 20 68 20 4f 4e | 20 64 2e 68 65 61 64 5f |ent h ON| d.head_|
|00004100| 64 65 70 74 20 3d 20 68 | 2e 64 65 70 74 5f 6e 6f |dept = h|.dept_no|
|00004110| 0a 20 20 4f 52 44 45 52 | 20 42 59 20 64 2e 64 65 |.  ORDER| BY d.de|
|00004120| 70 74 5f 6e 6f 0a 20 20 | 49 4e 54 4f 20 3a 68 65 |pt_no.  |INTO :he|
|00004130| 61 64 5f 64 65 70 74 2c | 20 3a 64 65 70 61 72 74 |ad_dept,| :depart|
|00004140| 6d 65 6e 74 2c 20 3a 6d | 6e 67 72 5f 6e 6f 2c 20 |ment, :m|ngr_no, |
|00004150| 3a 64 6e 6f 0a 20 44 4f | 0a 20 42 45 47 49 4e 0a |:dno. DO|. BEGIN.|
|00004160| 20 20 49 46 20 28 3a 6d | 6e 67 72 5f 6e 6f 20 49 |  IF (:m|ngr_no I|
|00004170| 53 20 4e 55 4c 4c 29 20 | 54 48 45 4e 0a 20 20 42 |S NULL) |THEN.  B|
|00004180| 45 47 49 4e 0a 20 20 20 | 6d 6e 67 72 5f 6e 61 6d |EGIN.   |mngr_nam|
|00004190| 65 20 3d 20 22 2d 2d 54 | 42 48 2d 2d 22 3b 0a 20 |e = "--T|BH--";. |
|000041a0| 20 20 74 69 74 6c 65 20 | 3d 20 22 22 3b 0a 20 20 |  title |= "";.  |
|000041b0| 45 4e 44 0a 0a 20 20 45 | 4c 53 45 0a 20 20 20 53 |END..  E|LSE.   S|
|000041c0| 45 4c 45 43 54 20 66 75 | 6c 6c 5f 6e 61 6d 65 2c |ELECT fu|ll_name,|
|000041d0| 20 6a 6f 62 5f 63 6f 64 | 65 0a 20 20 20 46 52 4f | job_cod|e.   FRO|
|000041e0| 4d 20 65 6d 70 6c 6f 79 | 65 65 0a 20 20 20 57 48 |M employ|ee.   WH|
|000041f0| 45 52 45 20 65 6d 70 5f | 6e 6f 20 3d 20 3a 6d 6e |ERE emp_|no = :mn|
|00004200| 67 72 5f 6e 6f 0a 20 20 | 20 49 4e 54 4f 20 3a 6d |gr_no.  | INTO :m|
|00004210| 6e 67 72 5f 6e 61 6d 65 | 2c 20 3a 74 69 74 6c 65 |ngr_name|, :title|
|00004220| 3b 0a 0a 20 20 53 45 4c | 45 43 54 20 43 4f 55 4e |;..  SEL|ECT COUN|
|00004230| 54 28 65 6d 70 5f 6e 6f | 29 0a 20 20 46 00 52 4f |T(emp_no|).  F.RO|
|00004240| 4d 20 65 6d 70 6c 6f 79 | 65 65 0a 20 20 57 48 45 |M employ|ee.  WHE|
|00004250| 52 45 20 64 65 70 74 5f | 6e 6f 20 3d 20 3a 64 6e |RE dept_|no = :dn|
|00004260| 6f 0a 20 20 49 4e 54 4f | 20 3a 65 6d 70 5f 63 6e |o.  INTO| :emp_cn|
|00004270| 74 3b 0a 0a 20 20 53 55 | 53 50 45 4e 44 3b 0a 20 |t;..  SU|SPEND;. |
|00004280| 45 4e 44 0a 45 4e 44 00 | 08 04 3d 02 00 00 04 02 |END.END.|..=.....|
|00004290| 04 01 0b 00 0f 00 00 19 | 00 07 00 0f 00 00 19 00 |........|........|
|000042a0| 07 00 0f 00 00 14 00 07 | 00 0f 00 00 05 00 07 00 |........|........|
|000042b0| 08 00 07 00 07 00 02 03 | 00 00 0f 00 00 19 00 01 |........|........|
|000042c0| 2d 1a 00 00 03 01 00 0f | 00 00 19 00 01 2d 1a 01 |-.......|.....-..|
|000042d0| 00 03 02 00 0f 00 00 14 | 00 01 2d 1a 02 00 03 03 |........|..-.....|
|000042e0| 00 0f 00 00 05 00 01 2d | 1a 03 00 03 04 00 08 00 |.......-|........|
|000042f0| 01 2d 1a 04 00 03 05 00 | 08 00 01 2d 1a 05 00 03 |.-......|...-....|
|00004300| 06 00 0f 00 00 03 00 01 | 2d 1a 06 00 9b 11 00 02 |........|-.......|
|00004310| 02 07 43 01 77 02 92 0a | 44 45 50 41 52 54 4d 45 |..C.w...|DEPARTME|
|00004320| 4e 54 01 44 00 92 0a 44 | 45 50 41 52 54 4d 45 4e |NT.D...D|EPARTMEN|
|00004330| 54 01 48 01 50 01 47 2f | 17 00 09 48 45 41 44 5f |T.H.P.G/|...HEAD_|
|00004340| 44 45 50 54 17 01 07 44 | 45 50 54 5f 4e 4f ff 46 |DEPT...D|EPT_NO.F|
|00004350| 01 48 17 00 07 44 45 50 | 54 5f 4e 4f ff 02 01 17 |.H...DEP|T_NO....|
|00004360| 01 0a 44 45 50 41 52 54 | 4d 45 4e 54 1a 00 00 01 |..DEPART|MENT....|
|00004370| 17 00 0a 44 45 50 41 52 | 54 4d 45 4e 54 1a 01 00 |...DEPAR|TMENT...|
|00004380| 01 17 00 07 4d 4e 47 52 | 5f 4e 4f 1a 05 00 01 17 |....MNGR|_NO.....|
|00004390| 00 07 44 45 50 54 5f 4e | 4f 1a 06 00 02 02 08 3d |..DEPT_N|O......=|
|000043a0| 1a 05 00 02 02 01 15 0f | 7f 00 07 00 2d 2d 54 42 |........|....--TB|
|000043b0| 48 2d 2d 1a 02 00 01 15 | 0f 7f 00 00 00 1a 03 00 |H--.....|........|
|000043c0| ff ff 07 7f 43 01 4a 08 | 45 4d 50 4c 4f 59 45 45 |....C.J.|EMPLOYEE|
|000043d0| 02 47 2f 17 02 06 45 4d | 50 5f 4e 4f 1a 05 00 ff |.G/...EM|P_NO....|
|000043e0| 02 01 17 02 09 46 55 4c | 4c 5f 4e 41 4d 45 1a 02 |.....FUL|L_NAME..|
|000043f0| 00 01 17 02 08 4a 4f 42 | 5f 43 4f 44 45 1a 03 00 |.....JOB|_CODE...|
|00004400| ff 07 7f 43 01 4f 04 43 | 01 4a 08 45 4d 50 4c 4f |...C.O.C|.J.EMPLO|
|00004410| 59 45 45 03 47 2f 17 03 | 07 44 45 50 54 5f 4e 4f |YEE.G/..|.DEPT_NO|
|00004420| 1a 06 00 ff 4e 00 4d 01 | 00 00 00 5d 17 03 06 45 |....N.M.|...]...E|
|00004430| 4d 50 5f 4e 4f ff 02 01 | 18 04 00 00 1a 04 00 ff |MP_NO...|........|
|00004440| 02 0e 01 02 01 1a 00 00 | 29 01 00 00 01 00 01 1a |........|).......|
|00004450| 01 00 29 01 02 00 03 00 | 01 1a 02 00 29 01 04 00 |..).....|....)...|
|00004460| 05 00 01 1a 03 00 29 01 | 06 00 07 00 01 1a 04 00 |......).|........|
|00004470| 29 01 08 00 09 00 01 15 | 07 00 01 00 19 01 0a 00 |).......|........|
|00004480| ff 9b ff ff ff ff ff ff | ff 0e 01 02 01 1a 00 00 |........|........|
|00004490| 29 01 00 00 01 00 01 1a | 01 00 29 01 02 00 03 00 |).......|..).....|
|000044a0| 01 1a 02 00 29 01 04 00 | 05 00 01 1a 03 00 29 01 |....)...|......).|
|000044b0| 06 00 07 00 01 1a 04 00 | 29 01 08 00 09 00 01 15 |........|).......|
|000044c0| 07 00 00 00 19 01 0a 00 | ff ff 4c 09 0d 53 51 4c |........|..L..SQL|
|000044d0| 24 4f 52 47 5f 43 48 41 | 52 54 0a 06 53 59 53 44 |$ORG_CHA|RT..SYSD|
|000044e0| 42 41 00 1c 01 09 48 45 | 41 44 5f 44 45 50 54 02 |BA....HE|AD_DEPT.|
|000044f0| 04 00 00 00 00 03 04 01 | 00 00 00 04 06 52 44 42 |........|.....RDB|
|00004500| 24 34 34 00 1c 01 0a 44 | 45 50 41 52 54 4d 45 4e |$44....D|EPARTMEN|
|00004510| 54 02 04 01 00 00 00 03 | 04 01 00 00 00 04 06 52 |T.......|.......R|
|00004520| 44 42 24 34 35 00 1c 01 | 09 4d 4e 47 52 5f 4e 41 |DB$45...|.MNGR_NA|
|00004530| 4d 45 02 04 02 00 00 00 | 03 04 01 00 00 00 04 06 |ME......|........|
|00004540| 52 44 42 24 34 36 00 1c | 01 05 54 49 54 4c 45 02 |RDB$46..|..TITLE.|
|00004550| 04 03 00 00 00 03 04 01 | 00 00 00 04 06 52 44 42 |........|.....RDB|
|00004560| 24 34 37 00 1c 01 07 45 | 4d 50 5f 43 4e 54 02 04 |$47....E|MP_CNT..|
|00004570| 04 00 00 00 03 04 01 00 | 00 00 04 06 52 44 42 24 |........|....RDB$|
|00004580| 34 38 00 1d 1b 01 0a 4d | 41 49 4c 5f 4c 41 42 45 |48.....M|AIL_LABE|
|00004590| 4c 02 04 01 00 00 00 03 | 04 06 00 00 00 07 04 f8 |L.......|........|
|000045a0| 04 00 00 0a 20 44 45 43 | 4c 41 52 45 20 56 41 52 |.... DEC|LARE VAR|
|000045b0| 49 41 42 4c 45 20 63 75 | 73 74 6f 6d 65 72 20 56 |IABLE cu|stomer V|
|000045c0| 41 52 43 48 41 52 28 32 | 35 29 3b 0a 20 44 45 43 |ARCHAR(2|5);. DEC|
|000045d0| 4c 41 52 45 20 56 41 52 | 49 41 42 4c 45 20 66 69 |LARE VAR|IABLE fi|
|000045e0| 72 73 74 20 20 56 41 52 | 43 48 41 52 28 31 35 29 |rst  VAR|CHAR(15)|
|000045f0| 3b 0a 20 44 45 43 4c 41 | 52 45 20 56 41 52 49 41 |;. DECLA|RE VARIA|
|00004600| 42 4c 45 20 6c 61 73 74 | 20 20 56 41 52 43 48 41 |BLE last|  VARCHA|
|00004610| 52 28 32 30 29 3b 0a 20 | 44 45 43 4c 41 52 45 20 |R(20);. |DECLARE |
|00004620| 56 41 52 49 41 42 4c 45 | 20 61 64 64 72 31 20 20 |VARIABLE| addr1  |
|00004630| 56 41 52 43 48 41 52 28 | 33 30 29 3b 0a 20 44 45 |VARCHAR(|30);. DE|
|00004640| 43 4c 41 52 45 20 56 41 | 52 49 41 42 4c 45 20 61 |CLARE VA|RIABLE a|
|00004650| 64 64 72 32 20 20 56 41 | 52 43 48 41 52 28 33 30 |ddr2  VA|RCHAR(30|
|00004660| 29 3b 0a 20 44 45 43 4c | 41 52 45 20 56 41 52 49 |);. DECL|ARE VARI|
|00004670| 41 42 4c 45 20 63 69 74 | 79 20 20 56 41 52 43 48 |ABLE cit|y  VARCH|
|00004680| 41 52 28 32 35 29 3b 0a | 20 44 45 43 4c 41 52 45 |AR(25);.| DECLARE|
|00004690| 20 56 41 52 49 41 42 4c | 45 20 73 74 61 74 65 20 | VARIABL|E state |
|000046a0| 20 56 41 52 43 48 41 52 | 28 31 35 29 3b 0a 20 44 | VARCHAR|(15);. D|
|000046b0| 45 43 4c 41 52 45 20 56 | 41 52 49 41 42 4c 45 20 |ECLARE V|ARIABLE |
|000046c0| 63 6f 75 6e 74 72 79 20 | 56 41 52 43 48 41 52 28 |country |VARCHAR(|
|000046d0| 31 35 29 3b 0a 20 44 45 | 43 4c 41 52 45 20 56 41 |15);. DE|CLARE VA|
|000046e0| 52 49 41 42 4c 45 20 70 | 6f 73 74 63 6f 64 65 20 |RIABLE p|ostcode |
|000046f0| 56 41 52 43 48 41 52 28 | 31 32 29 3b 0a 20 44 45 |VARCHAR(|12);. DE|
|00004700| 43 4c 41 52 45 20 56 41 | 52 49 41 42 4c 45 20 63 |CLARE VA|RIABLE c|
|00004710| 6e 74 20 20 49 4e 54 45 | 47 45 52 3b 0a 42 45 47 |nt  INTE|GER;.BEG|
|00004720| 49 4e 0a 20 6c 69 6e 65 | 31 20 3d 20 22 22 3b 0a |IN. line|1 = "";.|
|00004730| 20 6c 69 6e 65 32 20 3d | 20 22 22 3b 0a 20 6c 69 | line2 =| "";. li|
|00004740| 6e 65 33 20 3d 20 22 22 | 3b 0a 20 6c 69 6e 65 34 |ne3 = ""|;. line4|
|00004750| 20 3d 20 22 22 3b 0a 20 | 6c 69 6e 65 35 20 3d 20 | = "";. |line5 = |
|00004760| 22 22 3b 0a 20 6c 69 6e | 65 36 20 3d 20 22 22 3b |"";. lin|e6 = "";|
|00004770| 0a 0a 20 53 45 4c 45 43 | 54 20 63 75 73 74 6f 6d |.. SELEC|T custom|
|00004780| 65 72 2c 20 63 6f 6e 74 | 61 63 74 5f 66 69 72 73 |er, cont|act_firs|
|00004790| 74 2c 20 63 6f 6e 74 61 | 63 74 5f 6c 61 73 74 2c |t, conta|ct_last,|
|000047a0| 20 61 64 00 64 72 65 73 | 73 5f 6c 69 6e 65 31 2c | ad.dres|s_line1,|
|000047b0| 0a 20 20 61 64 64 72 65 | 73 73 5f 6c 69 6e 65 32 |.  addre|ss_line2|
|000047c0| 2c 20 63 69 74 79 2c 20 | 73 74 61 74 65 5f 70 72 |, city, |state_pr|
|000047d0| 6f 76 69 6e 63 65 2c 20 | 63 6f 75 6e 74 72 79 2c |ovince, |country,|
|000047e0| 20 70 6f 73 74 61 6c 5f | 63 6f 64 65 0a 20 46 52 | postal_|code. FR|
|000047f0| 4f 4d 20 43 55 53 54 4f | 4d 45 52 0a 20 57 48 45 |OM CUSTO|MER. WHE|
|00004800| 52 45 20 63 75 73 74 5f | 6e 6f 20 3d 20 3a 63 75 |RE cust_|no = :cu|
|00004810| 73 74 5f 6e 6f 0a 20 49 | 4e 54 4f 20 3a 63 75 73 |st_no. I|NTO :cus|
|00004820| 74 6f 6d 65 72 2c 20 3a | 66 69 72 73 74 2c 20 3a |tomer, :|first, :|
|00004830| 6c 61 73 74 2c 20 3a 61 | 64 64 72 31 2c 20 3a 61 |last, :a|ddr1, :a|
|00004840| 64 64 72 32 2c 0a 20 20 | 3a 63 69 74 79 2c 20 3a |ddr2,.  |:city, :|
|00004850| 73 74 61 74 65 2c 20 3a | 63 6f 75 6e 74 72 79 2c |state, :|country,|
|00004860| 20 3a 70 6f 73 74 63 6f | 64 65 3b 0a 0a 20 49 46 | :postco|de;.. IF|
|00004870| 20 28 63 75 73 74 6f 6d | 65 72 20 49 53 20 4e 4f | (custom|er IS NO|
|00004880| 54 20 4e 55 4c 4c 29 20 | 54 48 45 4e 0a 20 20 6c |T NULL) |THEN.  l|
|00004890| 69 6e 65 31 20 3d 20 63 | 75 73 74 6f 6d 65 72 3b |ine1 = c|ustomer;|
|000048a0| 0a 20 49 46 20 28 66 69 | 72 73 74 20 49 53 20 4e |. IF (fi|rst IS N|
|000048b0| 4f 54 20 4e 55 4c 4c 29 | 20 54 48 45 4e 0a 20 20 |OT NULL)| THEN.  |
|000048c0| 6c 69 6e 65 32 20 3d 20 | 66 69 72 73 74 20 7c 7c |line2 = |first |||
|000048d0| 20 22 20 22 20 7c 7c 20 | 6c 61 73 74 3b 0a 20 45 | " " || |last;. E|
|000048e0| 4c 53 45 0a 20 20 6c 69 | 6e 65 32 20 3d 20 6c 61 |LSE.  li|ne2 = la|
|000048f0| 73 74 3b 0a 20 49 46 20 | 28 61 64 64 72 31 20 49 |st;. IF |(addr1 I|
|00004900| 53 20 4e 4f 54 20 4e 55 | 4c 4c 29 20 54 48 45 4e |S NOT NU|LL) THEN|
|00004910| 0a 20 20 6c 69 6e 65 33 | 20 3d 20 61 64 64 72 31 |.  line3| = addr1|
|00004920| 3b 0a 20 49 46 20 28 61 | 64 64 72 32 20 49 53 20 |;. IF (a|ddr2 IS |
|00004930| 4e 4f 54 20 4e 55 4c 4c | 29 20 54 48 45 4e 0a 20 |NOT NULL|) THEN. |
|00004940| 20 6c 69 6e 65 34 20 3d | 20 61 64 64 72 32 3b 0a | line4 =| addr2;.|
|00004950| 0a 20 49 46 20 28 63 6f | 75 6e 74 72 79 20 3d 20 |. IF (co|untry = |
|00004960| 22 55 53 41 22 29 20 54 | 48 45 4e 0a 20 42 45 47 |"USA") T|HEN. BEG|
|00004970| 49 4e 0a 20 20 49 46 20 | 28 63 69 74 79 20 49 53 |IN.  IF |(city IS|
|00004980| 20 4e 4f 54 20 4e 55 4c | 4c 29 20 54 48 45 4e 0a | NOT NUL|L) THEN.|
|00004990| 20 20 20 6c 69 6e 65 35 | 20 3d 20 63 69 74 79 20 |   line5| = city |
|000049a0| 7c 7c 20 22 00 2c 20 22 | 20 7c 7c 20 73 74 61 74 ||| "., "| || stat|
|000049b0| 65 20 7c 7c 20 22 20 20 | 22 20 7c 7c 20 70 6f 73 |e || "  |" || pos|
|000049c0| 74 63 6f 64 65 3b 0a 20 | 20 45 4c 53 45 0a 20 20 |tcode;. | ELSE.  |
|000049d0| 20 6c 69 6e 65 35 20 3d | 20 73 74 61 74 65 20 7c | line5 =| state ||
|000049e0| 7c 20 22 20 20 22 20 7c | 7c 20 70 6f 73 74 63 6f || "  " ||| postco|
|000049f0| 64 65 3b 0a 20 45 4e 44 | 0a 20 45 4c 53 45 0a 20 |de;. END|. ELSE. |
|00004a00| 42 45 47 49 4e 0a 20 20 | 49 46 20 28 63 69 74 79 |BEGIN.  |IF (city|
|00004a10| 20 49 53 20 4e 4f 54 20 | 4e 55 4c 4c 29 20 54 48 | IS NOT |NULL) TH|
|00004a20| 45 4e 0a 20 20 20 6c 69 | 6e 65 35 20 3d 20 63 69 |EN.   li|ne5 = ci|
|00004a30| 74 79 20 7c 7c 20 22 2c | 20 22 20 7c 7c 20 73 74 |ty || ",| " || st|
|00004a40| 61 74 65 3b 0a 20 20 45 | 4c 53 45 0a 20 20 20 6c |ate;.  E|LSE.   l|
|00004a50| 69 6e 65 35 20 3d 20 73 | 74 61 74 65 3b 0a 20 20 |ine5 = s|tate;.  |
|00004a60| 6c 69 6e 65 36 20 3d 20 | 63 6f 75 6e 74 72 79 20 |line6 = |country |
|00004a70| 7c 7c 20 22 20 20 20 20 | 22 20 7c 7c 20 70 6f 73 ||| "    |" || pos|
|00004a80| 74 63 6f 64 65 3b 0a 20 | 45 4e 44 0a 0a 20 53 55 |tcode;. |END.. SU|
|00004a90| 53 50 45 4e 44 3b 0a 45 | 4e 44 00 08 04 7b 03 00 |SPEND;.E|ND...{..|
|00004aa0| 00 04 02 04 00 02 00 08 | 00 07 00 04 01 0d 00 0f |........|........|
|00004ab0| 00 00 28 00 07 00 0f 00 | 00 28 00 07 00 0f 00 00 |..(.....|.(......|
|00004ac0| 28 00 07 00 0f 00 00 28 | 00 07 00 0f 00 00 28 00 |(......(|......(.|
|00004ad0| 07 00 0f 00 00 28 00 07 | 00 07 00 0c 00 02 03 00 |.....(..|........|
|00004ae0| 00 0f 00 00 28 00 01 2d | 1a 00 00 03 01 00 0f 00 |....(..-|........|
|00004af0| 00 28 00 01 2d 1a 01 00 | 03 02 00 0f 00 00 28 00 |.(..-...|......(.|
|00004b00| 01 2d 1a 02 00 03 03 00 | 0f 00 00 28 00 01 2d 1a |.-......|...(..-.|
|00004b10| 03 00 03 04 00 0f 00 00 | 28 00 01 2d 1a 04 00 03 |........|(..-....|
|00004b20| 05 00 0f 00 00 28 00 01 | 2d 1a 05 00 03 06 00 26 |.....(..|-......&|
|00004b30| 00 00 19 00 01 2d 1a 06 | 00 03 07 00 26 00 00 0f |.....-..|....&...|
|00004b40| 00 01 2d 1a 07 00 03 08 | 00 26 00 00 14 00 01 2d |..-.....|.&.....-|
|00004b50| 1a 08 00 03 09 00 26 00 | 00 1e 00 01 2d 1a 09 00 |......&.|....-...|
|00004b60| 03 0a 00 26 00 00 1e 00 | 01 2d 1a 0a 00 03 0b 00 |...&....|.-......|
|00004b70| 26 00 00 19 00 01 2d 1a | 0b 00 03 0c 00 26 00 00 |&.....-.|.....&..|
|00004b80| 0f 00 01 2d 1a 0c 00 03 | 0d 00 26 00 00 0f 00 01 |...-....|..&.....|
|00004b90| 2d 1a 0d 00 03 0e 00 26 | 00 00 0c 00 01 2d 1a 0e |-......&|.....-..|
|00004ba0| 00 03 0f 00 08 00 01 2d | 1a 0f 00 9b 11 00 02 02 |.......-|........|
|00004bb0| 01 15 0f 7f 00 00 00 1a | 00 00 01 15 0f 7f 00 00 |........|........|
|00004bc0| 00 1a 01 00 01 15 0f 7f | 00 00 00 1a 02 00 01 15 |........|........|
|00004bd0| 0f 7f 00 00 00 1a 03 00 | 01 15 0f 7f 00 00 00 1a |........|........|
|00004be0| 04 00 01 15 0f 7f 00 00 | 00 1a 05 00 07 7f 43 01 |........|......C.|
|00004bf0| 4a 08 43 55 53 54 4f 4d | 45 52 00 47 2f 17 00 07 |J.CUSTOM|ER.G/...|
|00004c00| 43 55 53 54 5f 4e 4f 29 | 00 00 00 01 00 ff 02 01 |CUST_NO)|........|
|00004c10| 17 00 08 43 55 53 54 4f | 4d 45 52 1a 06 00 01 17 |...CUSTO|MER.....|
|00004c20| 00 0d 43 4f 4e 54 41 43 | 54 5f 46 49 52 53 54 1a |..CONTAC|T_FIRST.|
|00004c30| 07 00 01 17 00 0c 43 4f | 4e 54 41 43 54 5f 4c 41 |......CO|NTACT_LA|
|00004c40| 53 54 1a 08 00 01 17 00 | 0d 41 44 44 52 45 53 53 |ST......|.ADDRESS|
|00004c50| 5f 4c 49 4e 45 31 1a 09 | 00 01 17 00 0d 41 44 44 |_LINE1..|.....ADD|
|00004c60| 52 45 53 53 5f 4c 49 4e | 45 32 1a 0a 00 01 17 00 |RESS_LIN|E2......|
|00004c70| 04 43 49 54 59 1a 0b 00 | 01 17 00 0e 53 54 41 54 |.CITY...|....STAT|
|00004c80| 45 5f 50 52 4f 56 49 4e | 43 45 1a 0c 00 01 17 00 |E_PROVIN|CE......|
|00004c90| 07 43 4f 55 4e 54 52 59 | 1a 0d 00 01 17 00 0b 50 |.COUNTRY|.......P|
|00004ca0| 4f 53 54 41 4c 5f 43 4f | 44 45 1a 0e 00 ff 08 3b |OSTAL_CO|DE.....;|
|00004cb0| 3d 1a 06 00 01 1a 06 00 | 1a 00 00 ff 08 3b 3d 1a |=.......|.....;=.|
|00004cc0| 07 00 01 27 27 1a 07 00 | 15 0f 7f 00 01 00 20 1a |...''...|...... .|
|00004cd0| 08 00 1a 01 00 01 1a 08 | 00 1a 01 00 08 3b 3d 1a |........|.....;=.|
|00004ce0| 09 00 01 1a 09 00 1a 02 | 00 ff 08 3b 3d 1a 0a 00 |........|...;=...|
|00004cf0| 01 1a 0a 00 1a 03 00 ff | 08 2f 1a 0d 00 15 0f 7f |........|./......|
|00004d00| 00 03 00 55 53 41 02 02 | 08 3b 3d 1a 0b 00 01 27 |...USA..|.;=....'|
|00004d10| 27 27 27 1a 0b 00 15 0f | 7f 00 02 00 2c 20 1a 0c |'''.....|...., ..|
|00004d20| 00 15 0f 7f 00 02 00 20 | 20 1a 0e 00 1a 04 00 01 |....... | .......|
|00004d30| 27 27 1a 0c 00 15 0f 7f | 00 02 00 20 20 1a 0e 00 |''......|...  ...|
|00004d40| 1a 04 00 ff ff 02 02 08 | 3b 3d 1a 0b 00 01 27 27 |........|;=....''|
|00004d50| 1a 0b 00 15 0f 7f 00 02 | 00 2c 20 1a 0c 00 1a 04 |........|., .....|
|00004d60| 00 01 1a 0c 00 1a 04 00 | 01 27 27 1a 0d 00 15 0f |........|.''.....|
|00004d70| 7f 00 04 00 20 20 20 20 | 1a 0e 00 1a 05 00 ff ff |....    |........|
|00004d80| 02 0e 01 02 01 1a 00 00 | 29 01 00 00 01 00 01 1a |........|).......|
|00004d90| 01 00 29 01 02 00 03 00 | 01 1a 02 00 29 01 04 00 |..).....|....)...|
|00004da0| 05 00 01 1a 03 00 29 01 | 06 00 07 00 01 1a 04 00 |......).|........|
|00004db0| 29 01 08 00 09 00 01 1a | 05 00 29 01 0a 00 0b 00 |).......|..).....|
|00004dc0| 01 15 07 00 01 00 19 01 | 0c 00 ff 9b ff ff ff ff |........|........|
|00004dd0| 0e 01 02 01 1a 00 00 29 | 01 00 00 01 00 01 1a 01 |.......)|........|
|00004de0| 00 29 01 02 00 03 00 01 | 1a 02 00 29 01 04 00 05 |.)......|...)....|
|00004df0| 00 01 1a 03 00 29 01 06 | 00 07 00 01 1a 04 00 29 |.....)..|.......)|
|00004e00| 01 08 00 09 00 01 1a 05 | 00 29 01 0a 00 0b 00 01 |........|.)......|
|00004e10| 15 07 00 00 00 19 01 0c | 00 ff ff 4c 09 0e 53 51 |........|...L..SQ|
|00004e20| 4c 24 4d 41 49 4c 5f 4c | 41 42 45 4c 0a 06 53 59 |L$MAIL_L|ABEL..SY|
|00004e30| 53 44 42 41 00 1c 01 07 | 43 55 53 54 5f 4e 4f 02 |SDBA....|CUST_NO.|
|00004e40| 04 00 00 00 00 03 04 00 | 00 00 00 04 06 52 44 42 |........|.....RDB|
|00004e50| 24 34 39 00 1c 01 05 4c | 49 4e 45 31 02 04 00 00 |$49....L|INE1....|
|00004e60| 00 00 03 04 01 00 00 00 | 04 06 52 44 42 24 35 30 |........|..RDB$50|
|00004e70| 00 1c 01 05 4c 49 4e 45 | 32 02 04 01 00 00 00 03 |....LINE|2.......|
|00004e80| 04 01 00 00 00 04 06 52 | 44 42 24 35 31 00 1c 01 |.......R|DB$51...|
|00004e90| 05 4c 49 4e 45 33 02 04 | 02 00 00 00 03 04 01 00 |.LINE3..|........|
|00004ea0| 00 00 04 06 52 44 42 24 | 35 32 00 1c 01 05 4c 49 |....RDB$|52....LI|
|00004eb0| 4e 45 34 02 04 03 00 00 | 00 03 04 01 00 00 00 04 |NE4.....|........|
|00004ec0| 06 52 44 42 24 35 33 00 | 1c 01 05 4c 49 4e 45 35 |.RDB$53.|...LINE5|
|00004ed0| 02 04 04 00 00 00 03 04 | 01 00 00 00 04 06 52 44 |........|......RD|
|00004ee0| 42 24 35 34 00 1c 01 05 | 4c 49 4e 45 36 02 04 05 |B$54....|LINE6...|
|00004ef0| 00 00 00 03 04 01 00 00 | 00 04 06 52 44 42 24 35 |........|...RDB$5|
|00004f00| 35 00 1d 1b 01 0a 53 48 | 49 50 5f 4f 52 44 45 52 |5.....SH|IP_ORDER|
|00004f10| 02 04 01 00 00 00 03 04 | 00 00 00 00 07 04 49 04 |........|......I.|
|00004f20| 00 00 0a 20 44 45 43 4c | 41 52 45 20 56 41 52 49 |... DECL|ARE VARI|
|00004f30| 41 42 4c 45 20 6f 72 64 | 5f 73 74 61 74 20 43 48 |ABLE ord|_stat CH|
|00004f40| 41 52 28 37 29 3b 0a 20 | 44 45 43 4c 41 52 45 20 |AR(7);. |DECLARE |
|00004f50| 56 41 52 49 41 42 4c 45 | 20 68 6f 6c 64 5f 73 74 |VARIABLE| hold_st|
|00004f60| 61 74 20 43 48 41 52 28 | 31 29 3b 0a 20 44 45 43 |at CHAR(|1);. DEC|
|00004f70| 4c 41 52 45 20 56 41 52 | 49 41 42 4c 45 20 63 75 |LARE VAR|IABLE cu|
|00004f80| 73 74 5f 6e 6f 20 49 4e | 54 45 47 45 52 3b 0a 20 |st_no IN|TEGER;. |
|00004f90| 44 45 43 4c 41 52 45 20 | 56 41 52 49 41 42 4c 45 |DECLARE |VARIABLE|
|00004fa0| 20 61 6e 79 5f 70 6f 20 | 43 48 41 52 28 38 29 3b | any_po |CHAR(8);|
|00004fb0| 0a 42 45 47 49 4e 0a 20 | 53 45 4c 45 43 54 20 73 |.BEGIN. |SELECT s|
|00004fc0| 2e 6f 72 64 65 72 5f 73 | 74 61 74 75 73 2c 20 63 |.order_s|tatus, c|
|00004fd0| 2e 6f 6e 5f 68 6f 6c 64 | 2c 20 63 2e 63 75 73 74 |.on_hold|, c.cust|
|00004fe0| 5f 6e 6f 0a 20 46 52 4f | 4d 20 73 61 6c 65 73 20 |_no. FRO|M sales |
|00004ff0| 73 2c 20 63 75 73 74 6f | 6d 65 72 20 63 0a 20 57 |s, custo|mer c. W|
|00005000| 48 45 52 45 20 70 6f 5f | 6e 75 6d 62 65 72 20 3d |HERE po_|number =|
|00005010| 20 3a 70 6f 5f 6e 75 6d | 0a 20 41 4e 44 20 73 2e | :po_num|. AND s.|
|00005020| 63 75 73 74 5f 6e 6f 20 | 3d 20 63 2e 63 75 73 74 |cust_no |= c.cust|
|00005030| 5f 6e 6f 0a 20 49 4e 54 | 4f 20 3a 6f 72 64 5f 73 |_no. INT|O :ord_s|
|00005040| 74 61 74 2c 20 3a 68 6f | 6c 64 5f 73 74 61 74 2c |tat, :ho|ld_stat,|
|00005050| 20 3a 63 75 73 74 5f 6e | 6f 3b 0a 0a 20 2f 2a 20 | :cust_n|o;.. /* |
|00005060| 54 68 69 73 20 70 75 72 | 63 68 61 73 65 20 6f 72 |This pur|chase or|
|00005070| 64 65 72 20 68 61 73 20 | 62 65 65 6e 20 61 6c 72 |der has |been alr|
|00005080| 65 61 64 79 20 73 68 69 | 70 70 65 64 2e 20 2a 2f |eady shi|pped. */|
|00005090| 0a 20 49 46 20 28 6f 72 | 64 5f 73 74 61 74 20 3d |. IF (or|d_stat =|
|000050a0| 20 22 73 68 69 70 70 65 | 64 22 29 20 54 48 45 4e | "shippe|d") THEN|
|000050b0| 0a 20 42 45 47 49 4e 0a | 20 20 45 58 43 45 50 54 |. BEGIN.|  EXCEPT|
|000050c0| 49 4f 4e 20 6f 72 64 65 | 72 5f 61 6c 72 65 61 64 |ION orde|r_alread|
|000050d0| 79 5f 73 68 69 70 70 65 | 64 3b 0a 20 20 53 55 53 |y_shippe|d;.  SUS|
|000050e0| 50 45 4e 44 3b 0a 20 45 | 4e 44 0a 0a 20 2f 2a 20 |PEND;. E|ND.. /* |
|000050f0| 43 75 73 74 6f 6d 65 72 | 20 69 73 20 6f 6e 20 68 |Customer| is on h|
|00005100| 6f 6c 64 2e 20 2a 2f 0a | 20 45 4c 53 45 20 49 46 |old. */.| ELSE IF|
|00005110| 20 28 68 6f 6c 64 5f 73 | 74 61 74 20 3d 20 22 2a | (hold_s|tat = "*|
|00005120| 22 29 00 20 54 48 45 4e | 0a 20 42 45 47 49 4e 0a |"). THEN|. BEGIN.|
|00005130| 20 20 45 58 43 45 50 54 | 49 4f 4e 20 63 75 73 74 |  EXCEPT|ION cust|
|00005140| 6f 6d 65 72 5f 6f 6e 5f | 68 6f 6c 64 3b 0a 20 20 |omer_on_|hold;.  |
|00005150| 53 55 53 50 45 4e 44 3b | 0a 20 45 4e 44 0a 0a 20 |SUSPEND;|. END.. |
|00005160| 2f 2a 0a 20 20 2a 20 49 | 66 20 74 68 65 72 65 20 |/*.  * I|f there |
|00005170| 69 73 20 61 6e 20 75 6e | 70 61 69 64 20 62 61 6c |is an un|paid bal|
|00005180| 61 6e 63 65 20 6f 6e 20 | 6f 72 64 65 72 73 20 73 |ance on |orders s|
|00005190| 68 69 70 70 65 64 20 6f | 76 65 72 20 32 20 6d 6f |hipped o|ver 2 mo|
|000051a0| 6e 74 68 73 20 61 67 6f | 2c 0a 20 20 2a 20 70 75 |nths ago|,.  * pu|
|000051b0| 74 20 74 68 65 20 63 75 | 73 74 6f 6d 65 72 20 6f |t the cu|stomer o|
|000051c0| 6e 20 68 6f 6c 64 2e 0a | 20 20 2a 2f 0a 20 46 4f |n hold..|  */. FO|
|000051d0| 52 20 53 45 4c 45 43 54 | 20 70 6f 5f 6e 75 6d 62 |R SELECT| po_numb|
|000051e0| 65 72 0a 20 20 46 52 4f | 4d 20 73 61 6c 65 73 0a |er.  FRO|M sales.|
|000051f0| 20 20 57 48 45 52 45 20 | 63 75 73 74 5f 6e 6f 20 |  WHERE |cust_no |
|00005200| 3d 20 3a 63 75 73 74 5f | 6e 6f 0a 20 20 41 4e 44 |= :cust_|no.  AND|
|00005210| 20 6f 72 64 65 72 5f 73 | 74 61 74 75 73 20 3d 20 | order_s|tatus = |
|00005220| 22 73 68 69 70 70 65 64 | 22 0a 20 20 41 4e 44 20 |"shipped|".  AND |
|00005230| 70 61 69 64 20 3d 20 22 | 6e 22 0a 20 20 41 4e 44 |paid = "|n".  AND|
|00005240| 20 73 68 69 70 5f 64 61 | 74 65 20 3c 20 27 4e 4f | ship_da|te < 'NO|
|00005250| 57 27 20 2d 20 36 30 0a | 20 20 49 4e 54 4f 20 3a |W' - 60.|  INTO :|
|00005260| 61 6e 79 5f 70 6f 0a 20 | 44 4f 0a 20 42 45 47 49 |any_po. |DO. BEGI|
|00005270| 4e 0a 20 20 45 58 43 45 | 50 54 49 4f 4e 20 63 75 |N.  EXCE|PTION cu|
|00005280| 73 74 6f 6d 65 72 5f 63 | 68 65 63 6b 3b 0a 0a 20 |stomer_c|heck;.. |
|00005290| 20 55 50 44 41 54 45 20 | 63 75 73 74 6f 6d 65 72 | UPDATE |customer|
|000052a0| 0a 20 20 53 45 54 20 6f | 6e 5f 68 6f 6c 64 20 3d |.  SET o|n_hold =|
|000052b0| 20 22 2a 22 0a 20 20 57 | 48 45 52 45 20 63 75 73 | "*".  W|HERE cus|
|000052c0| 74 5f 6e 6f 20 3d 20 3a | 63 75 73 74 5f 6e 6f 3b |t_no = :|cust_no;|
|000052d0| 0a 0a 20 20 53 55 53 50 | 45 4e 44 3b 0a 20 45 4e |..  SUSP|END;. EN|
|000052e0| 44 0a 0a 20 2f 2a 0a 20 | 20 2a 20 53 68 69 70 20 |D.. /*. | * Ship |
|000052f0| 74 68 65 20 6f 72 64 65 | 72 2e 0a 20 20 2a 2f 0a |the orde|r..  */.|
|00005300| 20 55 50 44 41 54 45 20 | 73 61 6c 65 73 0a 20 53 | UPDATE |sales. S|
|00005310| 45 54 20 6f 72 64 65 72 | 5f 73 74 61 74 75 73 20 |ET order|_status |
|00005320| 3d 20 22 00 73 68 69 70 | 70 65 64 22 2c 20 73 68 |= ".ship|ped", sh|
|00005330| 69 70 5f 64 61 74 65 20 | 3d 20 27 4e 4f 57 27 0a |ip_date |= 'NOW'.|
|00005340| 20 57 48 45 52 45 20 70 | 6f 5f 6e 75 6d 62 65 72 | WHERE p|o_number|
|00005350| 20 3d 20 3a 70 6f 5f 6e | 75 6d 3b 0a 0a 20 53 55 | = :po_n|um;.. SU|
|00005360| 53 50 45 4e 44 3b 0a 45 | 4e 44 00 08 04 88 02 00 |SPEND;.E|ND......|
|00005370| 00 04 02 04 00 02 00 0f | 00 00 08 00 07 00 04 01 |........|........|
|00005380| 01 00 07 00 0c 00 02 03 | 00 00 0f 00 00 07 00 01 |........|........|
|00005390| 2d 1a 00 00 03 01 00 0f | 00 00 01 00 01 2d 1a 01 |-.......|.....-..|
|000053a0| 00 03 02 00 08 00 01 2d | 1a 02 00 03 03 00 0f 00 |.......-|........|
|000053b0| 00 08 00 01 2d 1a 03 00 | 9b 11 00 02 02 07 7f 43 |....-...|.......C|
|000053c0| 02 92 05 53 41 4c 45 53 | 01 53 00 92 08 43 55 53 |...SALES|.S...CUS|
|000053d0| 54 4f 4d 45 52 01 43 01 | 47 3a 2f 17 00 09 50 4f |TOMER.C.|G:/...PO|
|000053e0| 5f 4e 55 4d 42 45 52 29 | 00 00 00 01 00 2f 17 00 |_NUMBER)|...../..|
|000053f0| 07 43 55 53 54 5f 4e 4f | 17 01 07 43 55 53 54 5f |.CUST_NO|...CUST_|
|00005400| 4e 4f ff 02 01 17 00 0c | 4f 52 44 45 52 5f 53 54 |NO......|ORDER_ST|
|00005410| 41 54 55 53 1a 00 00 01 | 17 01 07 4f 4e 5f 48 4f |ATUS....|...ON_HO|
|00005420| 4c 44 1a 01 00 01 17 01 | 07 43 55 53 54 5f 4e 4f |LD......|.CUST_NO|
|00005430| 1a 02 00 ff 08 2f 1a 00 | 00 15 0f 7f 00 07 00 73 |...../..|.......s|
|00005440| 68 69 70 70 65 64 02 02 | 80 02 15 4f 52 44 45 52 |hipped..|...ORDER|
|00005450| 5f 41 4c 52 45 41 44 59 | 5f 53 48 49 50 50 45 44 |_ALREADY|_SHIPPED|
|00005460| 02 0e 01 02 01 15 07 00 | 01 00 19 01 00 00 ff 9b |........|........|
|00005470| ff ff ff 08 2f 1a 01 00 | 15 0f 7f 00 01 00 2a 02 |..../...|......*.|
|00005480| 02 80 02 10 43 55 53 54 | 4f 4d 45 52 5f 4f 4e 5f |....CUST|OMER_ON_|
|00005490| 48 4f 4c 44 02 0e 01 02 | 01 15 07 00 01 00 19 01 |HOLD....|........|
|000054a0| 00 00 ff 9b ff ff ff ff | 07 43 01 4a 05 53 41 4c |........|.C.J.SAL|
|000054b0| 45 53 02 47 3a 3a 3a 2f | 17 02 07 43 55 53 54 5f |ES.G:::/|...CUST_|
|000054c0| 4e 4f 1a 02 00 2f 17 02 | 0c 4f 52 44 45 52 5f 53 |NO.../..|.ORDER_S|
|000054d0| 54 41 54 55 53 15 0f 7f | 00 07 00 73 68 69 70 70 |TATUS...|...shipp|
|000054e0| 65 64 2f 17 02 04 50 41 | 49 44 15 0f 7f 00 01 00 |ed/...PA|ID......|
|000054f0| 6e 33 17 02 09 53 48 49 | 50 5f 44 41 54 45 23 15 |n3...SHI|P_DATE#.|
|00005500| 0f 7f 00 03 00 4e 4f 57 | 15 08 00 3c 00 00 00 ff |.....NOW|...<....|
|00005510| 02 01 17 02 09 50 4f 5f | 4e 55 4d 42 45 52 1a 03 |.....PO_|NUMBER..|
|00005520| 00 02 02 80 02 0e 43 55 | 53 54 4f 4d 45 52 5f 43 |......CU|STOMER_C|
|00005530| 48 45 43 4b 07 43 01 4a | 08 43 55 53 54 4f 4d 45 |HECK.C.J|.CUSTOME|
|00005540| 52 03 47 2f 17 03 07 43 | 55 53 54 5f 4e 4f 1a 02 |R.G/...C|UST_NO..|
|00005550| 00 ff 0a 03 03 02 01 15 | 0f 7f 00 01 00 2a 17 03 |........|.....*..|
|00005560| 07 4f 4e 5f 48 4f 4c 44 | ff 02 0e 01 02 01 15 07 |.ON_HOLD|........|
|00005570| 00 01 00 19 01 00 00 ff | 9b ff ff ff ff 07 43 01 |........|......C.|
|00005580| 4a 05 53 41 4c 45 53 04 | 47 2f 17 04 09 50 4f 5f |J.SALES.|G/...PO_|
|00005590| 4e 55 4d 42 45 52 29 00 | 00 00 01 00 ff 0a 04 04 |NUMBER).|........|
|000055a0| 02 01 15 0f 7f 00 07 00 | 73 68 69 70 70 65 64 17 |........|shipped.|
|000055b0| 04 0c 4f 52 44 45 52 5f | 53 54 41 54 55 53 01 15 |..ORDER_|STATUS..|
|000055c0| 0f 7f 00 03 00 4e 4f 57 | 17 04 09 53 48 49 50 5f |.....NOW|...SHIP_|
|000055d0| 44 41 54 45 ff 02 0e 01 | 02 01 15 07 00 01 00 19 |DATE....|........|
|000055e0| 01 00 00 ff 9b ff ff ff | ff 0e 01 02 01 15 07 00 |........|........|
|000055f0| 00 00 19 01 00 00 ff ff | 4c 09 0e 53 51 4c 24 53 |........|L..SQL$S|
|00005600| 48 49 50 5f 4f 52 44 45 | 52 0a 06 53 59 53 44 42 |HIP_ORDE|R..SYSDB|
|00005610| 41 00 1c 01 06 50 4f 5f | 4e 55 4d 02 04 00 00 00 |A....PO_|NUM.....|
|00005620| 00 03 04 00 00 00 00 04 | 06 52 44 42 24 35 36 00 |........|.RDB$56.|
|00005630| 1d 1b 01 0a 53 48 4f 57 | 5f 4c 41 4e 47 53 02 04 |....SHOW|_LANGS..|
|00005640| 03 00 00 00 03 04 01 00 | 00 00 07 04 8b 01 00 00 |........|........|
|00005650| 0a 44 45 43 4c 41 52 45 | 20 56 41 52 49 41 42 4c |.DECLARE| VARIABL|
|00005660| 45 20 69 20 49 4e 54 45 | 47 45 52 3b 0a 42 45 47 |E i INTE|GER;.BEG|
|00005670| 49 4e 0a 20 20 69 20 3d | 20 31 3b 0a 20 20 57 48 |IN.  i =| 1;.  WH|
|00005680| 49 4c 45 20 28 69 20 3c | 3d 20 35 29 20 44 4f 0a |ILE (i <|= 5) DO.|
|00005690| 20 20 42 45 47 49 4e 0a | 20 20 20 20 53 45 4c 45 |  BEGIN.|    SELE|
|000056a0| 43 54 20 6c 61 6e 67 75 | 61 67 65 5f 72 65 71 5b |CT langu|age_req[|
|000056b0| 3a 69 5d 20 46 52 4f 4d | 20 6a 6f 42 0a 20 20 20 |:i] FROM| joB.   |
|000056c0| 20 57 48 45 52 45 20 28 | 28 6a 6f 62 5f 63 6f 64 | WHERE (|(job_cod|
|000056d0| 65 20 3d 20 3a 63 6f 64 | 65 29 20 41 4e 44 20 28 |e = :cod|e) AND (|
|000056e0| 6a 6f 62 5f 67 72 61 64 | 65 20 3d 20 3a 67 72 61 |job_grad|e = :gra|
|000056f0| 64 65 29 20 41 4e 44 20 | 28 6a 6f 62 5f 63 6f 75 |de) AND |(job_cou|
|00005700| 6e 74 72 79 20 3d 20 3a | 63 74 79 29 0a 20 20 20 |ntry = :|cty).   |
|00005710| 20 20 20 20 20 20 20 20 | 41 4e 44 20 28 6c 61 6e |        |AND (lan|
|00005720| 67 75 61 67 65 5f 72 65 | 71 20 49 53 20 4e 4f 54 |guage_re|q IS NOT|
|00005730| 20 4e 55 4c 4c 29 29 0a | 20 20 20 20 49 4e 54 4f | NULL)).|    INTO|
|00005740| 20 3a 6c 61 6e 67 75 61 | 67 65 73 3b 0a 20 20 20 | :langua|ges;.   |
|00005750| 20 49 46 20 28 6c 61 6e | 67 75 61 67 65 73 20 3d | IF (lan|guages =|
|00005760| 20 22 20 22 29 20 54 48 | 45 4e 20 20 2f 2a 20 50 | " ") TH|EN  /* P|
|00005770| 72 69 6e 74 73 20 22 4e | 55 4c 4c 22 20 69 6e 73 |rints "N|ULL" ins|
|00005780| 74 65 61 64 20 6f 66 20 | 62 6c 61 6e 6b 73 20 2a |tead of |blanks *|
|00005790| 2f 0a 20 20 20 20 20 20 | 20 6c 61 6e 67 75 61 67 |/.      | languag|
|000057a0| 65 73 20 3d 20 22 4e 55 | 4c 4c 22 3b 20 20 20 20 |es = "NU|LL";    |
|000057b0| 20 20 20 20 20 0a 20 20 | 20 20 69 20 3d 20 69 20 |     .  |  i = i |
|000057c0| 2b 31 3b 0a 20 20 20 20 | 53 55 53 50 45 4e 44 3b |+1;.    |SUSPEND;|
|000057d0| 0a 20 20 45 4e 44 0a 45 | 4e 44 00 08 04 3c 01 00 |.  END.E|ND...<..|
|000057e0| 00 04 02 04 00 06 00 26 | 00 00 05 00 07 00 07 00 |.......&|........|
|000057f0| 07 00 26 00 00 0f 00 07 | 00 04 01 03 00 26 00 00 |..&.....|.....&..|
|00005800| 0f 00 07 00 07 00 0c 00 | 02 03 00 00 26 00 00 0f |........|....&...|
|00005810| 00 01 2d 1a 00 00 03 01 | 00 08 00 01 2d 1a 01 00 |..-.....|....-...|
|00005820| 9b 11 00 02 02 01 15 08 | 00 01 00 00 00 1a 01 00 |........|........|
|00005830| 11 01 09 02 08 34 1a 01 | 00 15 08 00 05 00 00 00 |.....4..|........|
|00005840| 02 02 07 7f 43 01 4a 03 | 4a 4f 42 00 47 3a 3a 3a |....C.J.|JOB.G:::|
|00005850| 2f 17 00 08 4a 4f 42 5f | 43 4f 44 45 29 00 00 00 |/...JOB_|CODE)...|
|00005860| 01 00 2f 17 00 09 4a 4f | 42 5f 47 52 41 44 45 29 |../...JO|B_GRADE)|
|00005870| 00 02 00 03 00 2f 17 00 | 0b 4a 4f 42 5f 43 4f 55 |...../..|.JOB_COU|
|00005880| 4e 54 52 59 29 00 04 00 | 05 00 3b 3d 17 00 0c 4c |NTRY)...|..;=...L|
|00005890| 41 4e 47 55 41 47 45 5f | 52 45 51 ff 02 01 6b 17 |ANGUAGE_|REQ...k.|
|000058a0| 00 0c 4c 41 4e 47 55 41 | 47 45 5f 52 45 51 01 1a |..LANGUA|GE_REQ..|
|000058b0| 01 00 1a 00 00 ff 08 2f | 1a 00 00 15 0f 7f 00 01 |......./|........|
|000058c0| 00 20 01 15 0f 7f 00 04 | 00 4e 55 4c 4c 1a 00 00 |. ......|.NULL...|
|000058d0| ff 01 22 1a 01 00 15 08 | 00 01 00 00 00 1a 01 00 |..".....|........|
|000058e0| 02 0e 01 02 01 1a 00 00 | 29 01 00 00 01 00 01 15 |........|).......|
|000058f0| 07 00 01 00 19 01 02 00 | ff 9b ff ff ff 12 01 ff |........|........|
|00005900| ff ff ff 0e 01 02 01 1a | 00 00 29 01 00 00 01 00 |........|..).....|
|00005910| 01 15 07 00 00 00 19 01 | 02 00 ff ff 4c 09 0e 53 |........|....L..S|
|00005920| 51 4c 24 53 48 4f 57 5f | 4c 41 4e 47 53 0a 06 53 |QL$SHOW_|LANGS..S|
|00005930| 59 53 44 42 41 00 1c 01 | 04 43 4f 44 45 02 04 00 |YSDBA...|.CODE...|
|00005940| 00 00 00 03 04 00 00 00 | 00 04 06 52 44 42 24 35 |........|...RDB$5|
|00005950| 37 00 1c 01 05 47 52 41 | 44 45 02 04 01 00 00 00 |7....GRA|DE......|
|00005960| 03 04 00 00 00 00 04 06 | 52 44 42 24 35 38 00 1c |........|RDB$58..|
|00005970| 01 03 43 54 59 02 04 02 | 00 00 00 03 04 00 00 00 |..CTY...|........|
|00005980| 00 04 06 52 44 42 24 35 | 39 00 1c 01 09 4c 41 4e |...RDB$5|9....LAN|
|00005990| 47 55 41 47 45 53 02 04 | 00 00 00 00 03 04 01 00 |GUAGES..|........|
|000059a0| 00 00 04 06 52 44 42 24 | 36 30 00 1d 1b 01 09 41 |....RDB$|60.....A|
|000059b0| 4c 4c 5f 4c 41 4e 47 53 | 02 04 00 00 00 00 03 04 |LL_LANGS|........|
|000059c0| 04 00 00 00 07 04 8b 01 | 00 00 0a 20 20 20 20 42 |........|...    B|
|000059d0| 45 47 49 4e 0a 20 46 4f | 52 20 53 45 4c 45 43 54 |EGIN. FO|R SELECT|
|000059e0| 20 6a 6f 62 5f 63 6f 64 | 65 2c 20 6a 6f 62 5f 67 | job_cod|e, job_g|
|000059f0| 72 61 64 65 2c 20 6a 6f | 62 5f 63 6f 75 6e 74 72 |rade, jo|b_countr|
|00005a00| 79 20 46 52 4f 4d 20 6a | 6f 62 20 0a 20 20 49 4e |y FROM j|ob .  IN|
|00005a10| 54 4f 20 3a 63 6f 64 65 | 2c 20 3a 67 72 61 64 65 |TO :code|, :grade|
|00005a20| 2c 20 3a 63 6f 75 6e 74 | 72 79 0a 0a 20 44 4f 0a |, :count|ry.. DO.|
|00005a30| 20 42 45 47 49 4e 0a 20 | 20 20 20 20 46 4f 52 20 | BEGIN. |    FOR |
|00005a40| 53 45 4c 45 43 54 20 6c | 61 6e 67 75 61 67 65 73 |SELECT l|anguages|
|00005a50| 20 46 52 4f 4d 20 73 68 | 6f 77 5f 6c 61 6e 67 73 | FROM sh|ow_langs|
|00005a60| 20 0a 20 20 20 20 20 20 | 20 28 3a 63 6f 64 65 2c | .      | (:code,|
|00005a70| 20 3a 67 72 61 64 65 2c | 20 3a 63 6f 75 6e 74 72 | :grade,| :countr|
|00005a80| 79 29 20 49 4e 54 4f 20 | 3a 6c 61 6e 67 20 44 4f |y) INTO |:lang DO|
|00005a90| 0a 20 20 20 20 20 20 20 | 20 20 53 55 53 50 45 4e |.       |  SUSPEN|
|00005aa0| 44 3b 0a 20 20 20 20 20 | 2f 2a 20 50 75 74 20 6e |D;.     |/* Put n|
|00005ab0| 69 63 65 20 73 65 70 61 | 72 61 74 6f 72 73 20 62 |ice sepa|rators b|
|00005ac0| 65 74 77 65 65 6e 20 72 | 6f 77 73 20 2a 2f 0a 20 |etween r|ows */. |
|00005ad0| 20 20 20 20 63 6f 64 65 | 20 3d 20 22 3d 3d 3d 3d |    code| = "====|
|00005ae0| 3d 22 3b 0a 20 20 20 20 | 20 67 72 61 64 65 20 3d |=";.    | grade =|
|00005af0| 20 22 3d 3d 3d 3d 3d 22 | 3b 0a 20 20 20 20 20 63 | "====="|;.     c|
|00005b00| 6f 75 6e 74 72 79 20 3d | 20 22 3d 3d 3d 3d 3d 3d |ountry =| "======|
|00005b10| 3d 3d 3d 3d 3d 3d 3d 3d | 3d 22 3b 0a 20 20 20 20 |========|=";.    |
|00005b20| 20 6c 61 6e 67 20 3d 20 | 22 3d 3d 3d 3d 3d 3d 3d | lang = |"=======|
|00005b30| 3d 3d 3d 3d 3d 3d 3d 22 | 3b 0a 20 20 20 20 20 53 |======="|;.     S|
|00005b40| 55 53 50 45 4e 44 3b 0a | 20 45 4e 44 0a 20 20 20 |USPEND;.| END.   |
|00005b50| 20 45 4e 44 00 08 04 c9 | 01 00 00 04 02 04 01 09 | END....|........|
|00005b60| 00 26 00 00 05 00 07 00 | 26 00 00 05 00 07 00 26 |.&......|&......&|
|00005b70| 00 00 0f 00 07 00 26 00 | 00 0f 00 07 00 07 00 02 |......&.|........|
|00005b80| 03 00 00 26 00 00 05 00 | 01 2d 1a 00 00 03 01 00 |...&....|.-......|
|00005b90| 26 00 00 05 00 01 2d 1a | 01 00 03 02 00 26 00 00 |&.....-.|.....&..|
|00005ba0| 0f 00 01 2d 1a 02 00 03 | 03 00 26 00 00 0f 00 01 |...-....|..&.....|
|00005bb0| 2d 1a 03 00 9b 11 00 02 | 02 07 43 01 4a 03 4a 4f |-.......|..C.J.JO|
|00005bc0| 42 00 ff 02 01 17 00 08 | 4a 4f 42 5f 43 4f 44 45 |B.......|JOB_CODE|
|00005bd0| 1a 00 00 01 17 00 09 4a | 4f 42 5f 47 52 41 44 45 |.......J|OB_GRADE|
|00005be0| 1a 01 00 01 17 00 0b 4a | 4f 42 5f 43 4f 55 4e 54 |.......J|OB_COUNT|
|00005bf0| 52 59 1a 02 00 02 02 07 | 43 01 7c 0a 53 48 4f 57 |RY......|C.|.SHOW|
|00005c00| 5f 4c 41 4e 47 53 01 03 | 00 1a 00 00 1a 01 00 1a |_LANGS..|........|
|00005c10| 02 00 ff 02 01 17 01 09 | 4c 41 4e 47 55 41 47 45 |........|LANGUAGE|
|00005c20| 53 1a 03 00 02 0e 01 02 | 01 1a 00 00 29 01 00 00 |S.......|....)...|
|00005c30| 01 00 01 1a 01 00 29 01 | 02 00 03 00 01 1a 02 00 |......).|........|
|00005c40| 29 01 04 00 05 00 01 1a | 03 00 29 01 06 00 07 00 |).......|..).....|
|00005c50| 01 15 07 00 01 00 19 01 | 08 00 ff 9b ff ff 01 15 |........|........|
|00005c60| 0f 7f 00 05 00 3d 3d 3d | 3d 3d 1a 00 00 01 15 0f |.....===|==......|
|00005c70| 7f 00 05 00 3d 3d 3d 3d | 3d 1a 01 00 01 15 0f 7f |....====|=.......|
|00005c80| 00 0f 00 3d 3d 3d 3d 3d | 3d 3d 3d 3d 3d 3d 3d 3d |...=====|========|
|00005c90| 3d 3d 1a 02 00 01 15 0f | 7f 00 0e 00 3d 3d 3d 3d |==......|....====|
|00005ca0| 3d 3d 3d 3d 3d 3d 3d 3d | 3d 3d 1a 03 00 02 0e 01 |========|==......|
|00005cb0| 02 01 1a 00 00 29 01 00 | 00 01 00 01 1a 01 00 29 |.....)..|.......)|
|00005cc0| 01 02 00 03 00 01 1a 02 | 00 29 01 04 00 05 00 01 |........|.)......|
|00005cd0| 1a 03 00 29 01 06 00 07 | 00 01 15 07 00 01 00 19 |...)....|........|
|00005ce0| 01 08 00 ff 9b ff ff ff | ff ff ff ff 0e 01 02 01 |........|........|
|00005cf0| 1a 00 00 29 01 00 00 01 | 00 01 1a 01 00 29 01 02 |...)....|.....)..|
|00005d00| 00 03 00 01 1a 02 00 29 | 01 04 00 05 00 01 1a 03 |.......)|........|
|00005d10| 00 29 01 06 00 07 00 01 | 15 07 00 00 00 19 01 08 |.)......|........|
|00005d20| 00 ff ff 4c 09 0d 53 51 | 4c 24 41 4c 4c 5f 4c 41 |...L..SQ|L$ALL_LA|
|00005d30| 4e 47 53 0a 06 53 59 53 | 44 42 41 00 1c 01 04 43 |NGS..SYS|DBA....C|
|00005d40| 4f 44 45 02 04 00 00 00 | 00 03 04 01 00 00 00 04 |ODE.....|........|
|00005d50| 06 52 44 42 24 36 31 00 | 1c 01 05 47 52 41 44 45 |.RDB$61.|...GRADE|
|00005d60| 02 04 01 00 00 00 03 04 | 01 00 00 00 04 06 52 44 |........|......RD|
|00005d70| 42 24 36 32 00 1c 01 07 | 43 4f 55 4e 54 52 59 02 |B$62....|COUNTRY.|
|00005d80| 04 02 00 00 00 03 04 01 | 00 00 00 04 06 52 44 42 |........|.....RDB|
|00005d90| 24 36 33 00 1c 01 04 4c | 41 4e 47 02 04 03 00 00 |$63....L|ANG.....|
|00005da0| 00 03 04 01 00 00 00 04 | 06 52 44 42 24 36 34 00 |........|.RDB$64.|
|00005db0| 1d 1e 01 0e 55 4e 4b 4e | 4f 57 4e 5f 45 4d 50 5f |....UNKN|OWN_EMP_|
|00005dc0| 49 44 02 26 49 6e 76 61 | 6c 69 64 20 65 6d 70 6c |ID.&Inva|lid empl|
|00005dd0| 6f 79 65 65 20 6e 75 6d | 62 65 72 20 6f 72 20 70 |oyee num|ber or p|
|00005de0| 72 6f 6a 65 63 74 20 69 | 64 2e 00 1e 01 0e 52 45 |roject i|d.....RE|
|00005df0| 41 53 53 49 47 4e 5f 53 | 41 4c 45 53 02 39 52 65 |ASSIGN_S|ALES.9Re|
|00005e00| 61 73 73 69 67 6e 20 74 | 68 65 20 73 61 6c 65 73 |assign t|he sales|
|00005e10| 20 72 65 63 6f 72 64 73 | 20 62 65 66 6f 72 65 20 | records| before |
|00005e20| 64 65 6c 65 74 69 6e 67 | 20 74 68 69 73 20 65 6d |deleting| this em|
|00005e30| 70 6c 6f 79 65 65 2e 00 | 1e 01 15 4f 52 44 45 52 |ployee..|...ORDER|
|00005e40| 5f 41 4c 52 45 41 44 59 | 5f 53 48 49 50 50 45 44 |_ALREADY|_SHIPPED|
|00005e50| 02 1a 4f 72 64 65 72 20 | 73 74 61 74 75 73 20 69 |..Order |status i|
|00005e60| 73 20 27 73 68 69 70 70 | 65 64 2e 27 00 1e 01 10 |s 'shipp|ed.'....|
|00005e70| 43 55 53 54 4f 4d 45 52 | 5f 4f 4e 5f 48 4f 4c 44 |CUSTOMER|_ON_HOLD|
|00005e80| 02 19 54 68 69 73 20 63 | 75 73 74 6f 6d 65 72 20 |..This c|ustomer |
|00005e90| 69 73 20 6f 6e 20 68 6f | 6c 64 2e 00 1e 01 0e 43 |is on ho|ld.....C|
|00005ea0| 55 53 54 4f 4d 45 52 5f | 43 48 45 43 4b 02 1e 4f |USTOMER_|CHECK..O|
|00005eb0| 76 65 72 64 75 65 20 62 | 61 6c 61 6e 63 65 20 2d |verdue b|alance -|
|00005ec0| 2d 20 63 61 6e 27 74 20 | 73 68 69 70 2e 00 08 01 |- can't |ship....|
|00005ed0| 0e 53 41 4c 41 52 59 5f | 48 49 53 54 4f 52 59 00 |.SALARY_|HISTORY.|
|00005ee0| 05 01 0d 52 44 42 24 50 | 52 49 4d 41 52 59 32 30 |...RDB$P|RIMARY20|
|00005ef0| 02 04 03 00 00 00 03 04 | 00 00 00 00 04 04 01 00 |........|........|
|00005f00| 00 00 05 06 45 4d 50 5f | 4e 4f 05 0b 43 48 41 4e |....EMP_|NO..CHAN|
|00005f10| 47 45 5f 44 41 54 45 05 | 0a 55 50 44 41 54 45 52 |GE_DATE.|.UPDATER|
|00005f20| 5f 49 44 07 04 00 00 00 | 00 00 05 01 0d 52 44 42 |_ID.....|.....RDB|
|00005f30| 24 46 4f 52 45 49 47 4e | 32 31 02 04 01 00 00 00 |$FOREIGN|21......|
|00005f40| 03 04 00 00 00 00 04 04 | 00 00 00 00 05 06 45 4d |........|......EM|
|00005f50| 50 5f 4e 4f 07 04 00 00 | 00 00 08 0c 52 44 42 24 |P_NO....|....RDB$|
|00005f60| 50 52 49 4d 41 52 59 37 | 00 05 01 08 55 50 44 41 |PRIMARY7|....UPDA|
|00005f70| 54 45 52 58 02 04 01 00 | 00 00 03 04 00 00 00 00 |TERX....|........|
|00005f80| 04 04 00 00 00 00 05 0a | 55 50 44 41 54 45 52 5f |........|UPDATER_|
|00005f90| 49 44 07 04 00 00 00 00 | 00 05 01 07 43 48 41 4e |ID......|....CHAN|
|00005fa0| 47 45 58 02 04 01 00 00 | 00 03 04 00 00 00 00 04 |GEX.....|........|
|00005fb0| 04 00 00 00 00 05 0b 43 | 48 41 4e 47 45 5f 44 41 |.......C|HANGE_DA|
|00005fc0| 54 45 07 04 01 00 00 00 | 00 06 01 04 3a 00 00 00 |TE......|....:...|
|00005fd0| 11 04 3c 00 00 00 02 02 | 40 24 fa 00 03 40 d3 88 |..<.....|@$...@..|
|00005fe0| f9 00 02 bf 4b f9 00 09 | 06 61 64 6d 69 6e 32 60 |....K...|.admin2`|
|00005ff0| a7 fd 00 01 1c ec 00 06 | 01 04 3c 00 00 00 11 04 |........|..<.....|
|00006000| 3c 00 00 00 02 0b 40 20 | 1f 58 d0 fa c6 88 40 f7 |<.....@ |.X....@.|
|00006010| ed f9 00 02 bf 4b f9 00 | 09 06 61 64 6d 69 6e 32 |.....K..|..admin2|
|00006020| 60 a7 fd 00 01 02 ec 00 | 06 01 04 3c 00 00 00 11 |`.......|...<....|
|00006030| 04 3c 00 00 00 02 02 40 | 20 fb aa 04 ab 40 f5 f9 |.<.....@| ....@..|
|00006040| f9 00 02 bf 4b f9 00 09 | 06 61 64 6d 69 6e 32 60 |....K...|.admin2`|
|00006050| a7 fd 00 01 04 ec 00 06 | 01 04 3c 00 00 00 11 04 |........|..<.....|
|00006060| 3c 00 00 00 02 0c 40 20 | 50 d7 94 35 e5 0d 40 f7 |<.....@ |P..5..@.|
|00006070| 31 80 fa 00 02 bf 4b f9 | 00 09 06 61 64 6d 69 6e |1.....K.|...admin|
|00006080| 32 60 a7 fd 00 01 05 ec | 00 06 01 04 3c 00 00 00 |2`......|....<...|
|00006090| 11 04 3c 00 00 00 02 02 | 40 1e fa 00 03 40 f1 17 |..<.....|@....@..|
|000060a0| f9 00 02 bf 4b f9 00 09 | 06 61 64 6d 69 6e 32 60 |....K...|.admin2`|
|000060b0| a7 fd 00 01 0b ec 00 06 | 01 04 3c 00 00 00 11 04 |........|..<.....|
|000060c0| 3c 00 00 00 02 02 40 1e | fa 00 03 40 e7 70 f9 00 |<.....@.|...@.p..|
|000060d0| 02 bf 4b f9 00 09 06 61 | 64 6d 69 6e 32 60 a7 fd |..K....a|dmin2`..|
|000060e0| 00 01 0c ec 00 06 01 04 | 3c 00 00 00 11 04 3c 00 |........|<.....<.|
|000060f0| 00 00 02 02 40 1e fa 00 | 03 40 ee 46 f9 00 02 bf |....@...|.@.F....|
|00006100| 4b f9 00 09 06 61 64 6d | 69 6e 32 60 a7 fd 00 01 |K....adm|in2`....|
|00006110| 0e ec 00 06 01 04 3c 00 | 00 00 11 04 3c 00 00 00 |......<.|....<...|
|00006120| 02 02 40 1e fa 00 03 40 | ed 4c f9 00 02 bf 4b f9 |..@....@|.L....K.|
|00006130| 00 09 06 61 64 6d 69 6e | 32 60 a7 fd 00 01 0f ec |...admin|2`......|
|00006140| 00 06 01 04 3c 00 00 00 | 11 04 3c 00 00 00 02 02 |....<...|..<.....|
|00006150| 40 1e fa 00 03 40 f3 88 | f9 00 02 bf 4b f9 00 09 |@....@..|....K...|
|00006160| 06 61 64 6d 69 6e 32 60 | a7 fd 00 01 14 ec 00 06 |.admin2`|........|
|00006170| 01 04 3c 00 00 00 11 04 | 3c 00 00 00 02 02 40 1e |..<.....|<.....@.|
|00006180| fa 00 04 40 f1 d2 80 fa | 00 02 bf 4b f9 00 09 06 |...@....|...K....|
|00006190| 61 64 6d 69 6e 32 60 a7 | fd 00 01 18 ec 00 06 01 |admin2`.|........|
|000061a0| 04 3c 00 00 00 11 04 3c | 00 00 00 02 02 40 1e fa |.<.....<|.....@..|
|000061b0| 00 03 40 ee 46 f9 00 02 | bf 4b f9 00 09 06 61 64 |..@.F...|.K....ad|
|000061c0| 6d 69 6e 32 60 a7 fd 00 | 01 1d ec 00 06 01 04 3c |min2`...|.......<|
|000061d0| 00 00 00 11 04 3c 00 00 | 00 02 02 40 1e fa 00 03 |.....<..|...@....|
|000061e0| 40 ea db f9 00 02 bf 4b | f9 00 09 06 61 64 6d 69 |@......K|....admi|
|000061f0| 6e 32 60 a7 fd 00 01 22 | ec 00 06 01 04 3c 00 00 |n2`...."|.....<..|
|00006200| 00 11 04 3c 00 00 00 02 | 02 40 1e fa 00 03 40 dd |...<....|.@....@.|
|00006210| 4c f9 00 02 bf 4b f9 00 | 09 06 61 64 6d 69 6e 32 |L....K..|..admin2|
|00006220| 60 a7 fd 00 01 24 ec 00 | 06 01 04 3c 00 00 00 11 |`....$..|...<....|
|00006230| 04 3c 00 00 00 02 02 40 | 1e fa 00 03 40 e1 17 f9 |.<.....@|....@...|
|00006240| 00 02 bf 4b f9 00 09 06 | 61 64 6d 69 6e 32 60 a7 |...K....|admin2`.|
|00006250| fd 00 01 25 ec 00 06 01 | 04 3c 00 00 00 11 04 3c |...%....|.<.....<|
|00006260| 00 00 00 02 02 40 1e fa | 00 03 40 e8 6a f9 00 02 |.....@..|..@.j...|
|00006270| bf 4b f9 00 09 06 61 64 | 6d 69 6e 32 60 a7 fd 00 |.K....ad|min2`...|
|00006280| 01 2c ec 00 06 01 04 3c | 00 00 00 11 04 3c 00 00 |.,.....<|.....<..|
|00006290| 00 02 02 40 1e fa 00 03 | 40 f1 94 f9 00 02 bf 4b |...@....|@......K|
|000062a0| f9 00 09 06 61 64 6d 69 | 6e 32 60 a7 fd 00 01 2d |....admi|n2`....-|
|000062b0| ec 00 06 01 04 3c 00 00 | 00 11 04 3c 00 00 00 02 |.....<..|...<....|
|000062c0| 02 40 11 fa 00 03 40 ee | 46 f9 00 02 c0 56 f9 00 |.@....@.|F....V..|
|000062d0| 09 06 65 6c 61 69 6e 65 | 60 a7 fd 00 01 08 ec 00 |..elaine|`.......|
|000062e0| 06 01 04 3c 00 00 00 11 | 04 3c 00 00 00 02 02 40 |...<....|.<.....@|
|000062f0| 11 fa 00 03 40 f1 94 f9 | 00 02 c0 56 f9 00 09 06 |....@...|...V....|
|00006300| 65 6c 61 69 6e 65 60 a7 | fd 00 01 09 ec 00 06 01 |elaine`.|........|
|00006310| 04 3c 00 00 00 11 04 3c | 00 00 00 02 02 40 11 fa |.<.....<|.....@..|
|00006320| 00 04 40 f2 5f 20 fa 00 | 02 c0 56 f9 00 09 06 65 |..@._ ..|..V....e|
|00006330| 6c 61 69 6e 65 60 a7 fd | 00 01 0b ec 00 06 01 04 |laine`..|........|
|00006340| 3c 00 00 00 11 04 3c 00 | 00 00 02 02 40 11 fa 00 |<.....<.|....@...|
|00006350| 03 40 e9 32 f9 00 02 c0 | 56 f9 00 09 06 65 6c 61 |.@.2....|V....ela|
|00006360| 69 6e 65 60 a7 fd 00 01 | 0c ec 00 06 01 04 3c 00 |ine`....|......<.|
|00006370| 00 00 11 04 3c 00 00 00 | 02 02 40 11 fa 00 04 40 |....<...|..@....@|
|00006380| f0 45 a0 fa 00 02 c0 56 | f9 00 09 06 65 6c 61 69 |.E.....V|....elai|
|00006390| 6e 65 60 a7 fd 00 01 0e | ec 00 06 01 04 3c 00 00 |ne`.....|.....<..|
|000063a0| 00 11 04 3c 00 00 00 02 | 02 40 11 fa 00 04 40 ef |...<....|.@....@.|
|000063b0| 7e 80 fa 00 02 c0 56 f9 | 00 09 06 65 6c 61 69 6e |~.....V.|...elain|
|000063c0| 65 60 a7 fd 00 01 0f ec | 00 06 01 04 3c 00 00 00 |e`......|....<...|
|000063d0| 11 04 3c 00 00 00 02 02 | 40 11 fa 00 03 40 f4 ff |..<.....|@....@..|
|000063e0| f9 00 02 c0 56 f9 00 09 | 06 65 6c 61 69 6e 65 60 |....V...|.elaine`|
|000063f0| a7 fd 00 01 14 ec 00 06 | 01 04 3c 00 00 00 11 04 |........|..<.....|
+--------+-------------------------+-------------------------+--------+--------+
Only 25.0 KB of data is shown above.