PC Format Collection 48

home *** CD-ROM | disk | FTP | other *** search
/ PC Format Collection 48 / SENT14D.ISO / tech / delphi / disk14 / ibexampl.pak / INTLEMP.GBK < prev next >
Unknown | 1995-08-24 | 79.0 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 0404 0000 0004 0401 0000 ...	default (weak)
`99%`	file	data	default
`100%`	TrID	DEGAS hi-res bitmap	default (weak)
hex view
+--------+-------------------------+-------------------------+--------+--------+
|00000000| 00 02 04 04 00 00 00 04 | 04 01 00 00 00 05 04 01 |........|........|
|00000010| 00 00 00 06 04 00 02 00 | 00 08 04 01 00 00 00 07 |........|........|
|00000020| 17 2e 2e 5c 65 78 61 6d | 70 6c 65 34 5c 69 6e 74 |...\exam|ple4\int|
|00000030| 6c 65 6d 70 2e 67 64 62 | 01 18 54 75 65 20 46 65 |lemp.gdb|..Tue Fe|
|00000040| 62 20 30 37 20 32 33 3a | 30 38 3a 34 35 20 31 39 |b 07 23:|08:45 19|
|00000050| 39 35 00 0e 05 04 00 04 | 00 00 08 04 20 4e 00 00 |95......|.... N..|
|00000060| 01 17 2e 2e 5c 65 78 61 | 6d 70 6c 65 34 5c 69 6e |....\exa|mple4\in|
|00000070| 74 6c 65 6d 70 2e 67 64 | 62 00 01 0b 09 49 53 4f |tlemp.gd|b....ISO|
|00000080| 38 38 35 39 5f 31 00 02 | 01 09 46 49 52 53 54 4e |8859_1..|..FIRSTN|
|00000090| 41 4d 45 05 00 07 00 08 | 04 25 00 00 00 0a 04 0f |AME.....|.%......|
|000000a0| 00 00 00 09 04 00 00 00 | 00 0b 04 00 00 00 00 29 |........|.......)|
|000000b0| 04 0f 00 00 00 2a 04 15 | 00 00 00 2b 04 04 00 00 |.....*..|...+....|
|000000c0| 00 00 02 01 08 4c 41 53 | 54 4e 41 4d 45 05 00 07 |.....LAS|TNAME...|
|000000d0| 00 08 04 25 00 00 00 0a | 04 19 00 00 00 09 04 00 |...%....|........|
|000000e0| 00 00 00 0b 04 00 00 00 | 00 29 04 19 00 00 00 2a |........|.).....*|
|000000f0| 04 15 00 00 00 2b 04 04 | 00 00 00 00 02 01 0b 50 |.....+..|.......P|
|00000100| 48 4f 4e 45 4e 55 4d 42 | 45 52 05 00 07 00 08 04 |HONENUMB|ER......|
|00000110| 25 00 00 00 0a 04 14 00 | 00 00 09 04 00 00 00 00 |%.......|........|
|00000120| 0b 04 00 00 00 00 29 04 | 14 00 00 00 2a 04 15 00 |......).|....*...|
|00000130| 00 00 2b 04 00 00 00 00 | 00 02 01 0b 43 4f 55 4e |..+.....|....COUN|
|00000140| 54 52 59 4e 41 4d 45 05 | 00 07 00 08 04 25 00 00 |TRYNAME.|.....%..|
|00000150| 00 0a 04 0f 00 00 00 09 | 04 00 00 00 00 0b 04 00 |........|........|
|00000160| 00 00 00 29 04 0f 00 00 | 00 2a 04 15 00 00 00 2b |...)....|.*.....+|
|00000170| 04 00 00 00 00 00 02 01 | 0b 41 44 44 52 45 53 53 |........|.ADDRESS|
|00000180| 4c 49 4e 45 05 00 07 00 | 08 04 25 00 00 00 0a 04 |LINE....|..%.....|
|00000190| 28 00 00 00 09 04 00 00 | 00 00 0b 04 00 00 00 00 |(.......|........|
|000001a0| 29 04 28 00 00 00 2a 04 | 15 00 00 00 2b 04 00 00 |).(...*.|....+...|
|000001b0| 00 00 00 02 01 05 45 4d | 50 4e 4f 05 00 07 00 08 |......EM|PNO.....|
|000001c0| 04 07 00 00 00 0a 04 02 | 00 00 00 09 04 00 00 00 |........|........|
|000001d0| 00 0b 04 00 00 00 00 00 | 02 01 06 44 45 50 54 4e |........|...DEPTN|
|000001e0| 4f 05 00 07 00 08 04 0e | 00 00 00 0a 04 03 00 00 |O.......|........|
|000001f0| 00 09 04 00 00 00 00 0b | 04 00 00 00 00 14 04 32 |........|.......2|
|00000200| 00 00 00 04 39 39 2f 18 | 00 00 00 15 0f 7f 00 03 |....99/.|........|
|00000210| 00 30 30 30 3a 31 18 00 | 00 00 15 0f 7f 00 01 00 |.000:1..|........|
|00000220| 30 34 18 00 00 00 15 0f | 7f 00 03 00 39 39 39 3d |04......|....999=|
|00000230| 18 00 00 00 4c 24 04 4b | 00 00 00 43 48 45 43 4b |....L$.K|...CHECK|
|00000240| 20 28 56 41 4c 55 45 20 | 3d 20 27 30 30 30 27 20 | (VALUE |= '000' |
|00000250| 4f 52 20 28 56 41 4c 55 | 45 20 3e 20 27 30 27 20 |OR (VALU|E > '0' |
|00000260| 41 4e 44 20 56 41 4c 55 | 45 20 3c 3d 20 27 39 39 |AND VALU|E <= '99|
|00000270| 39 27 29 20 4f 52 20 56 | 41 4c 55 45 20 49 53 20 |9') OR V|ALUE IS |
|00000280| 4e 55 4c 4c 29 00 29 04 | 03 00 00 00 2a 04 02 00 |NULL).).|....*...|
|00000290| 00 00 2b 04 00 00 00 00 | 00 02 01 06 50 52 4f 4a |..+.....|....PROJ|
|000002a0| 4e 4f 05 00 07 00 08 04 | 0e 00 00 00 0a 04 05 00 |NO......|........|
|000002b0| 00 00 09 04 00 00 00 00 | 0b 04 00 00 00 00 14 04 |........|........|
|000002c0| 0c 00 00 00 04 2f 18 00 | 00 00 67 18 00 00 00 4c |...../..|..g....L|
|000002d0| 24 04 1e 00 00 00 43 48 | 45 43 4b 20 28 56 41 4c |$.....CH|ECK (VAL|
|000002e0| 55 45 20 3d 20 55 50 50 | 45 52 20 28 56 41 4c 55 |UE = UPP|ER (VALU|
|000002f0| 45 29 29 00 29 04 05 00 | 00 00 2a 04 02 00 00 00 |E)).)...|..*.....|
|00000300| 2b 04 00 00 00 00 00 02 | 01 06 43 55 53 54 4e 4f |+.......|..CUSTNO|
|00000310| 05 00 07 00 08 04 08 00 | 00 00 0a 04 04 00 00 00 |........|........|
|00000320| 09 04 00 00 00 00 0b 04 | 00 00 00 00 14 04 0e 00 |........|........|
|00000330| 00 00 04 31 18 00 00 00 | 15 08 00 e8 03 00 00 4c |...1....|.......L|
|00000340| 24 04 15 00 00 00 43 48 | 45 43 4b 20 28 56 41 4c |$.....CH|ECK (VAL|
|00000350| 55 45 20 3e 20 31 30 30 | 30 29 00 00 02 01 07 4a |UE > 100|0).....J|
|00000360| 4f 42 43 4f 44 45 05 00 | 07 00 08 04 25 00 00 00 |OBCODE..|....%...|
|00000370| 0a 04 05 00 00 00 09 04 | 00 00 00 00 0b 04 00 00 |........|........|
|00000380| 00 00 14 04 12 00 00 00 | 04 31 18 00 00 00 15 0f |........|.1......|
|00000390| 7f 00 05 00 39 39 39 39 | 39 4c 24 04 18 00 00 00 |....9999|9L$.....|
|000003a0| 43 48 45 43 4b 20 28 56 | 41 4c 55 45 20 3e 20 27 |CHECK (V|ALUE > '|
|000003b0| 39 39 39 39 39 27 29 00 | 29 04 05 00 00 00 2a 04 |99999').|).....*.|
|000003c0| 02 00 00 00 2b 04 00 00 | 00 00 00 02 01 08 4a 4f |....+...|......JO|
|000003d0| 42 47 52 41 44 45 05 00 | 07 00 08 04 07 00 00 00 |BGRADE..|........|
|000003e0| 0a 04 02 00 00 00 09 04 | 00 00 00 00 0b 04 00 00 |........|........|
|000003f0| 00 00 14 04 15 00 00 00 | 04 38 18 00 00 00 15 08 |........|.8......|
|00000400| 00 00 00 00 00 15 08 00 | 06 00 00 00 4c 24 04 1e |........|....L$..|
|00000410| 00 00 00 43 48 45 43 4b | 20 28 56 41 4c 55 45 20 |...CHECK| (VALUE |
|00000420| 42 45 54 57 45 45 4e 20 | 30 20 41 4e 44 20 36 29 |BETWEEN |0 AND 6)|
|00000430| 00 00 02 01 06 53 41 4c | 41 52 59 05 00 07 00 08 |.....SAL|ARY.....|
|00000440| 04 1b 00 00 00 0a 04 08 | 00 00 00 09 04 00 00 00 |........|........|
|00000450| 00 0b 04 fe ff ff ff 0f | 04 09 00 00 00 04 15 08 |........|........|
|00000460| 00 00 00 00 00 4c 14 04 | 0e 00 00 00 04 31 18 00 |.....L..|.....1..|
|00000470| 00 00 15 08 00 00 00 00 | 00 4c 24 04 12 00 00 00 |........|.L$.....|
|00000480| 43 48 45 43 4b 20 28 56 | 41 4c 55 45 20 3e 20 30 |CHECK (V|ALUE > 0|
|00000490| 29 00 27 04 0a 00 00 00 | 44 45 46 41 55 4c 54 20 |).'.....|DEFAULT |
|000004a0| 30 00 00 02 01 06 42 55 | 44 47 45 54 05 00 07 00 |0.....BU|DGET....|
|000004b0| 08 04 1b 00 00 00 0a 04 | 08 00 00 00 09 04 00 00 |........|........|
|000004c0| 00 00 0b 04 fe ff ff ff | 0f 04 09 00 00 00 04 15 |........|........|
|000004d0| 08 00 50 c3 00 00 4c 14 | 04 1b 00 00 00 04 3a 31 |..P...L.|......:1|
|000004e0| 18 00 00 00 15 08 00 10 | 27 00 00 34 18 00 00 00 |........|'..4....|
|000004f0| 15 08 00 80 84 1e 00 4c | 24 04 2b 00 00 00 43 48 |.......L|$.+...CH|
|00000500| 45 43 4b 20 28 56 41 4c | 55 45 20 3e 20 31 30 30 |ECK (VAL|UE > 100|
|00000510| 30 30 20 41 4e 44 20 56 | 41 4c 55 45 20 3c 3d 20 |00 AND V|ALUE <= |
|00000520| 32 30 30 30 30 30 30 29 | 00 27 04 0e 00 00 00 44 |2000000)|.'.....D|
|00000530| 45 46 41 55 4c 54 20 35 | 30 30 30 30 00 00 02 01 |EFAULT 5|0000....|
|00000540| 08 50 52 4f 44 54 59 50 | 45 05 00 07 00 08 04 25 |.PRODTYP|E......%|
|00000550| 00 00 00 0a 04 0c 00 00 | 00 09 04 00 00 00 00 0b |........|........|
|00000560| 04 00 00 00 00 0f 04 10 | 00 00 00 04 15 0f 7f 00 |........|........|
|00000570| 08 00 73 6f 66 74 77 61 | 72 65 4c 14 04 49 00 00 |..softwa|reL..I..|
|00000580| 00 04 39 39 39 2f 18 00 | 00 00 15 0f 7f 00 08 00 |..999/..|........|
|00000590| 73 6f 66 74 77 61 72 65 | 2f 18 00 00 00 15 0f 7f |software|/.......|
|000005a0| 00 08 00 68 61 72 64 77 | 61 72 65 2f 18 00 00 00 |...hardw|are/....|
|000005b0| 15 0f 7f 00 05 00 6f 74 | 68 65 72 2f 18 00 00 00 |......ot|her/....|
|000005c0| 15 0f 7f 00 03 00 4e 2f | 41 4c 24 04 3a 00 00 00 |......N/|AL$.:...|
|000005d0| 43 48 45 43 4b 20 28 56 | 41 4c 55 45 20 49 4e 20 |CHECK (V|ALUE IN |
|000005e0| 28 27 73 6f 66 74 77 61 | 72 65 27 2c 20 27 68 61 |('softwa|re', 'ha|
|000005f0| 72 64 77 61 72 65 27 2c | 20 27 6f 74 68 65 72 27 |rdware',| 'other'|
|00000600| 2c 20 27 4e 2f 41 27 29 | 29 00 26 04 01 00 00 00 |, 'N/A')|).&.....|
|00000610| 29 04 0c 00 00 00 27 04 | 13 00 00 00 44 45 46 41 |).....'.|....DEFA|
|00000620| 55 4c 54 20 27 73 6f 66 | 74 77 61 72 65 27 00 2a |ULT 'sof|tware'.*|
|00000630| 04 15 00 00 00 2b 04 00 | 00 00 00 00 02 01 08 50 |.....+..|.......P|
|00000640| 4f 4e 55 4d 42 45 52 05 | 00 07 00 08 04 0e 00 00 |ONUMBER.|........|
|00000650| 00 0a 04 08 00 00 00 09 | 04 00 00 00 00 0b 04 00 |........|........|
|00000660| 00 00 00 14 04 0e 00 00 | 00 04 37 18 00 00 00 15 |........|..7.....|
|00000670| 0f 7f 00 01 00 56 4c 24 | 04 20 00 00 00 43 48 45 |.....VL$|. ...CHE|
|00000680| 43 4b 20 28 56 41 4c 55 | 45 20 53 54 41 52 54 49 |CK (VALU|E STARTI|
|00000690| 4e 47 20 57 49 54 48 20 | 27 56 27 29 00 29 04 08 |NG WITH |'V').)..|
|000006a0| 00 00 00 2a 04 15 00 00 | 00 2b 04 00 00 00 00 00 |...*....|.+......|
|000006b0| 02 01 05 52 44 42 24 31 | 05 00 07 00 08 04 25 00 |...RDB$1|......%.|
|000006c0| 00 00 0a 04 0a 00 00 00 | 09 04 00 00 00 00 0b 04 |........|........|
|000006d0| 00 00 00 00 29 04 0a 00 | 00 00 2a 04 15 00 00 00 |....)...|..*.....|
|000006e0| 00 02 01 05 52 44 42 24 | 32 05 00 07 00 08 04 25 |....RDB$|2......%|
|000006f0| 00 00 00 0a 04 19 00 00 | 00 09 04 00 00 00 00 0b |........|........|
|00000700| 04 00 00 00 00 29 04 19 | 00 00 00 2a 04 15 00 00 |.....)..|...*....|
|00000710| 00 00 02 01 05 52 44 42 | 24 33 05 00 07 00 08 04 |.....RDB|$3......|
|00000720| 05 01 00 00 0a 04 08 00 | 00 00 09 04 01 00 00 00 |........|........|
|00000730| 0b 04 00 00 00 00 0c 04 | 90 01 00 00 2a 04 15 00 |........|....*...|
|00000740| 00 00 00 02 01 05 52 44 | 42 24 34 05 00 07 00 08 |......RD|B$4.....|
|00000750| 04 25 00 00 00 0a 04 0f | 00 00 00 09 04 00 00 00 |.%......|........|
|00000760| 00 0b 04 00 00 00 00 1d | 04 01 00 00 00 29 04 0f |........|.....)..|
|00000770| 00 00 00 2a 04 15 00 00 | 00 00 02 01 05 52 44 42 |...*....|.....RDB|
|00000780| 24 35 05 00 07 00 08 04 | 25 00 00 00 0a 04 19 00 |$5......|%.......|
|00000790| 00 00 09 04 00 00 00 00 | 0b 04 00 00 00 00 29 04 |........|......).|
|000007a0| 19 00 00 00 2a 04 15 00 | 00 00 00 02 01 05 52 44 |....*...|......RD|
|000007b0| 42 24 36 05 00 07 00 08 | 04 25 00 00 00 0a 04 0f |B$6.....|.%......|
|000007c0| 00 00 00 09 04 00 00 00 | 00 0b 04 00 00 00 00 29 |........|.......)|
|000007d0| 04 0f 00 00 00 2a 04 15 | 00 00 00 00 02 01 05 52 |.....*..|.......R|
|000007e0| 44 42 24 37 05 00 07 00 | 08 04 25 00 00 00 0a 04 |DB$7....|..%.....|
|000007f0| 04 00 00 00 09 04 00 00 | 00 00 0b 04 00 00 00 00 |........|........|
|00000800| 29 04 04 00 00 00 2a 04 | 15 00 00 00 00 02 01 05 |).....*.|........|
|00000810| 52 44 42 24 38 05 00 07 | 00 08 04 23 00 00 00 0a |RDB$8...|...#....|
|00000820| 04 08 00 00 00 09 04 00 | 00 00 00 0b 04 00 00 00 |........|........|
|00000830| 00 00 02 01 05 52 44 42 | 24 39 05 00 07 00 08 04 |.....RDB|$9......|
|00000840| 25 00 00 00 0a 04 2a 00 | 00 00 09 04 00 00 00 00 |%.....*.|........|
|00000850| 0b 04 00 00 00 00 12 04 | 25 00 00 00 04 27 27 17 |........|%....''.|
|00000860| 00 09 4c 41 53 54 5f 4e | 41 4d 45 15 0f 7f 00 02 |..LAST_N|AME.....|
|00000870| 00 2c 20 17 00 0a 46 49 | 52 53 54 5f 4e 41 4d 45 |., ...FI|RST_NAME|
|00000880| 4c 25 04 22 00 00 00 28 | 6c 61 73 74 5f 6e 61 6d |L%."...(|last_nam|
|00000890| 65 20 7c 7c 20 27 2c 20 | 27 20 7c 7c 20 66 69 72 |e || ', |' || fir|
|000008a0| 73 74 5f 6e 61 6d 65 29 | 00 29 04 00 00 00 00 2a |st_name)|.).....*|
|000008b0| 04 15 00 00 00 00 02 01 | 06 52 44 42 24 31 30 05 |........|.RDB$10.|
|000008c0| 00 07 00 08 04 25 00 00 | 00 0a 04 14 00 00 00 09 |.....%..|........|
|000008d0| 04 00 00 00 00 0b 04 00 | 00 00 00 29 04 14 00 00 |........|...)....|
|000008e0| 00 2a 04 15 00 00 00 00 | 02 01 06 52 44 42 24 31 |.*......|...RDB$1|
|000008f0| 31 05 00 07 00 08 04 05 | 01 00 00 0a 04 08 00 00 |1.......|........|
|00000900| 00 09 04 01 00 00 00 0b | 04 00 00 00 00 0c 04 20 |........|....... |
|00000910| 03 00 00 2a 04 15 00 00 | 00 00 02 01 06 52 44 42 |...*....|.....RDB|
|00000920| 24 31 32 05 00 07 00 08 | 04 08 00 00 00 0a 04 04 |$12.....|........|
|00000930| 00 00 00 09 04 00 00 00 | 00 0b 04 00 00 00 00 00 |........|........|
|00000940| 02 01 06 52 44 42 24 31 | 33 05 00 07 00 08 04 08 |...RDB$1|3.......|
|00000950| 00 00 00 0a 04 04 00 00 | 00 09 04 00 00 00 00 0b |........|........|
|00000960| 04 00 00 00 00 1d 04 01 | 00 00 00 00 02 01 06 52 |........|.......R|
|00000970| 44 42 24 31 34 05 00 07 | 00 08 04 23 00 00 00 0a |DB$14...|...#....|
|00000980| 04 08 00 00 00 09 04 00 | 00 00 00 0b 04 00 00 00 |........|........|
|00000990| 00 00 02 01 06 52 44 42 | 24 31 35 05 00 07 00 08 |.....RDB|$15.....|
|000009a0| 04 25 00 00 00 0a 04 14 | 00 00 00 09 04 00 00 00 |.%......|........|
|000009b0| 00 0b 04 00 00 00 00 29 | 04 14 00 00 00 2a 04 15 |.......)|.....*..|
|000009c0| 00 00 00 00 02 01 06 52 | 44 42 24 31 36 05 00 07 |.......R|DB$16...|
|000009d0| 00 08 04 1b 00 00 00 0a | 04 08 00 00 00 09 04 00 |........|........|
|000009e0| 00 00 00 0b 04 00 00 00 | 00 00 02 01 06 52 44 42 |........|.....RDB|
|000009f0| 24 31 37 05 00 07 00 08 | 04 1b 00 00 00 0a 04 08 |$17.....|........|
|00000a00| 00 00 00 09 04 00 00 00 | 00 0b 04 00 00 00 00 12 |........|........|
|00000a10| 04 37 00 00 00 04 22 17 | 00 0a 4f 4c 44 5f 53 41 |.7....".|..OLD_SA|
|00000a20| 4c 41 52 59 25 24 17 00 | 0a 4f 4c 44 5f 53 41 4c |LARY%$..|.OLD_SAL|
|00000a30| 41 52 59 17 00 0e 50 45 | 52 43 45 4e 54 5f 43 48 |ARY...PE|RCENT_CH|
|00000a40| 41 4e 47 45 15 08 00 64 | 00 00 00 4c 25 04 31 00 |ANGE...d|...L%.1.|
|00000a50| 00 00 28 6f 6c 64 5f 73 | 61 6c 61 72 79 20 2b 20 |..(old_s|alary + |
|00000a60| 6f 6c 64 5f 73 61 6c 61 | 72 79 20 2a 20 70 65 72 |old_sala|ry * per|
|00000a70| 63 65 6e 74 5f 63 68 61 | 6e 67 65 20 2f 20 31 30 |cent_cha|nge / 10|
|00000a80| 30 29 00 00 02 01 06 52 | 44 42 24 31 38 05 00 07 |0).....R|DB$18...|
|00000a90| 00 08 04 25 00 00 00 0a | 04 23 00 00 00 09 04 00 |...%....|.#......|
|00000aa0| 00 00 00 0b 04 00 00 00 | 00 29 04 23 00 00 00 2a |........|.).#...*|
|00000ab0| 04 15 00 00 00 00 02 01 | 06 52 44 42 24 31 39 05 |........|.RDB$19.|
|00000ac0| 00 07 00 08 04 25 00 00 | 00 0a 04 19 00 00 00 09 |.....%..|........|
|00000ad0| 04 00 00 00 00 0b 04 00 | 00 00 00 29 04 19 00 00 |........|...)....|
|00000ae0| 00 2a 04 15 00 00 00 00 | 02 01 06 52 44 42 24 32 |.*......|...RDB$2|
|00000af0| 30 05 00 07 00 08 04 25 | 00 00 00 0a 04 0f 00 00 |0......%|........|
|00000b00| 00 09 04 00 00 00 00 0b | 04 00 00 00 00 29 04 0f |........|.....)..|
|00000b10| 00 00 00 2a 04 15 00 00 | 00 00 02 01 06 52 44 42 |...*....|.....RDB|
|00000b20| 24 32 31 05 00 07 00 08 | 04 25 00 00 00 0a 04 0c |$21.....|.%......|
|00000b30| 00 00 00 09 04 00 00 00 | 00 0b 04 00 00 00 00 29 |........|.......)|
|00000b40| 04 0c 00 00 00 2a 04 15 | 00 00 00 00 02 01 06 52 |.....*..|.......R|
|00000b50| 44 42 24 32 32 05 00 07 | 00 08 04 0e 00 00 00 0a |DB$22...|........|
|00000b60| 04 01 00 00 00 09 04 00 | 00 00 00 0b 04 00 00 00 |........|........|
|00000b70| 00 29 04 01 00 00 00 2a | 04 15 00 00 00 00 02 01 |.).....*|........|
|00000b80| 06 52 44 42 24 32 33 05 | 00 07 00 08 04 25 00 00 |.RDB$23.|.....%..|
|00000b90| 00 0a 04 07 00 00 00 09 | 04 00 00 00 00 0b 04 00 |........|........|
|00000ba0| 00 00 00 29 04 07 00 00 | 00 2a 04 15 00 00 00 00 |...)....|.*......|
|00000bb0| 02 01 06 52 44 42 24 32 | 34 05 00 07 00 08 04 23 |...RDB$2|4......#|
|00000bc0| 00 00 00 0a 04 08 00 00 | 00 09 04 00 00 00 00 0b |........|........|
|00000bd0| 04 00 00 00 00 00 02 01 | 06 52 44 42 24 32 35 05 |........|.RDB$25.|
|00000be0| 00 07 00 08 04 23 00 00 | 00 0a 04 08 00 00 00 09 |.....#..|........|
|00000bf0| 04 00 00 00 00 0b 04 00 | 00 00 00 00 02 01 06 52 |........|.......R|
|00000c00| 44 42 24 32 36 05 00 07 | 00 08 04 23 00 00 00 0a |DB$26...|...#....|
|00000c10| 04 08 00 00 00 09 04 00 | 00 00 00 0b 04 00 00 00 |........|........|
|00000c20| 00 00 02 01 06 52 44 42 | 24 32 37 05 00 07 00 08 |.....RDB|$27.....|
|00000c30| 04 0e 00 00 00 0a 04 01 | 00 00 00 09 04 00 00 00 |........|........|
|00000c40| 00 0b 04 00 00 00 00 29 | 04 01 00 00 00 2a 04 15 |.......)|.....*..|
|00000c50| 00 00 00 00 02 01 06 52 | 44 42 24 32 38 05 00 07 |.......R|DB$28...|
|00000c60| 00 08 04 08 00 00 00 0a | 04 04 00 00 00 09 04 00 |........|........|
|00000c70| 00 00 00 0b 04 00 00 00 | 00 00 02 01 06 52 44 42 |........|.....RDB|
|00000c80| 24 32 39 05 00 07 00 08 | 04 08 00 00 00 0a 04 04 |$29.....|........|
|00000c90| 00 00 00 09 04 00 00 00 | 00 0b 04 fe ff ff ff 00 |........|........|
|00000ca0| 02 01 06 52 44 42 24 33 | 30 05 00 07 00 08 04 0a |...RDB$3|0.......|
|00000cb0| 00 00 00 0a 04 04 00 00 | 00 09 04 00 00 00 00 0b |........|........|
|00000cc0| 04 00 00 00 00 00 02 01 | 06 52 44 42 24 33 31 05 |........|.RDB$31.|
|00000cd0| 00 07 00 08 04 1b 00 00 | 00 0a 04 08 00 00 00 09 |........|........|
|00000ce0| 04 00 00 00 00 0b 04 00 | 00 00 00 12 04 1c 00 00 |........|........|
|00000cf0| 00 04 23 17 00 09 53 48 | 49 50 5f 44 41 54 45 17 |..#...SH|IP_DATE.|
|00000d00| 00 0a 4f 52 44 45 52 5f | 44 41 54 45 4c 25 04 19 |..ORDER_|DATEL%..|
|00000d10| 00 00 00 28 73 68 69 70 | 5f 64 61 74 65 20 2d 20 |...(ship|_date - |
|00000d20| 6f 72 64 65 72 5f 64 61 | 74 65 29 00 00 02 01 06 |order_da|te).....|
|00000d30| 52 44 42 24 33 32 05 00 | 07 00 08 04 07 00 00 00 |RDB$32..|........|
|00000d40| 0a 04 02 00 00 00 09 04 | 00 00 00 00 0b 04 00 00 |........|........|
|00000d50| 00 00 00 02 01 06 52 44 | 42 24 33 33 05 00 07 00 |......RD|B$33....|
|00000d60| 08 04 0e 00 00 00 0a 04 | 05 00 00 00 09 04 00 00 |........|........|
|00000d70| 00 00 0b 04 00 00 00 00 | 29 04 05 00 00 00 2a 04 |........|).....*.|
|00000d80| 15 00 00 00 2b 04 00 00 | 00 00 00 02 01 06 52 44 |....+...|......RD|
|00000d90| 42 24 33 34 05 00 07 00 | 08 04 07 00 00 00 0a 04 |B$34....|........|
|00000da0| 02 00 00 00 09 04 00 00 | 00 00 0b 04 00 00 00 00 |........|........|
|00000db0| 00 02 01 06 52 44 42 24 | 33 35 05 00 07 00 08 04 |....RDB$|35......|
|00000dc0| 0e 00 00 00 0a 04 05 00 | 00 00 09 04 00 00 00 00 |........|........|
|00000dd0| 0b 04 00 00 00 00 29 04 | 05 00 00 00 2a 04 15 00 |......).|....*...|
|00000de0| 00 00 2b 04 00 00 00 00 | 00 02 01 06 52 44 42 24 |..+.....|....RDB$|
|00000df0| 33 36 05 00 07 00 08 04 | 0e 00 00 00 0a 04 03 00 |36......|........|
|00000e00| 00 00 09 04 00 00 00 00 | 0b 04 00 00 00 00 29 04 |........|......).|
|00000e10| 03 00 00 00 2a 04 15 00 | 00 00 2b 04 00 00 00 00 |....*...|..+.....|
|00000e20| 00 02 01 06 52 44 42 24 | 33 37 05 00 07 00 08 04 |....RDB$|37......|
|00000e30| 1b 00 00 00 0a 04 08 00 | 00 00 09 04 00 00 00 00 |........|........|
|00000e40| 0b 04 fe ff ff ff 00 02 | 01 06 52 44 42 24 33 38 |........|..RDB$38|
|00000e50| 05 00 07 00 08 04 1b 00 | 00 00 0a 04 08 00 00 00 |........|........|
|00000e60| 09 04 00 00 00 00 0b 04 | fe ff ff ff 00 02 01 06 |........|........|
|00000e70| 52 44 42 24 33 39 05 00 | 07 00 08 04 1b 00 00 00 |RDB$39..|........|
|00000e80| 0a 04 08 00 00 00 09 04 | 00 00 00 00 0b 04 fe ff |........|........|
|00000e90| ff ff 00 02 01 06 52 44 | 42 24 34 30 05 00 07 00 |......RD|B$40....|
|00000ea0| 08 04 1b 00 00 00 0a 04 | 08 00 00 00 09 04 00 00 |........|........|
|00000eb0| 00 00 0b 04 fe ff ff ff | 00 02 01 06 52 44 42 24 |........|....RDB$|
|00000ec0| 34 31 05 00 07 00 08 04 | 08 00 00 00 0a 04 04 00 |41......|........|
|00000ed0| 00 00 09 04 00 00 00 00 | 0b 04 00 00 00 00 00 02 |........|........|
|00000ee0| 01 06 52 44 42 24 34 32 | 05 00 07 00 08 04 0e 00 |..RDB$42|........|
|00000ef0| 00 00 0a 04 03 00 00 00 | 09 04 00 00 00 00 0b 04 |........|........|
|00000f00| 00 00 00 00 29 04 03 00 | 00 00 2a 04 15 00 00 00 |....)...|..*.....|
|00000f10| 2b 04 00 00 00 00 00 02 | 01 06 52 44 42 24 34 33 |+.......|..RDB$43|
|00000f20| 05 00 07 00 08 04 1b 00 | 00 00 0a 04 08 00 00 00 |........|........|
|00000f30| 09 04 00 00 00 00 0b 04 | fe ff ff ff 00 02 01 06 |........|........|
|00000f40| 52 44 42 24 34 34 05 00 | 07 00 08 04 0e 00 00 00 |RDB$44..|........|
|00000f50| 0a 04 19 00 00 00 09 04 | 00 00 00 00 0b 04 00 00 |........|........|
|00000f60| 00 00 29 04 19 00 00 00 | 2a 04 15 00 00 00 2b 04 |..).....|*.....+.|
|00000f70| 00 00 00 00 00 02 01 06 | 52 44 42 24 34 35 05 00 |........|RDB$45..|
|00000f80| 07 00 08 04 0e 00 00 00 | 0a 04 19 00 00 00 09 04 |........|........|
|00000f90| 00 00 00 00 0b 04 00 00 | 00 00 29 04 19 00 00 00 |........|..).....|
|00000fa0| 2a 04 15 00 00 00 2b 04 | 00 00 00 00 00 02 01 06 |*.....+.|........|
|00000fb0| 52 44 42 24 34 36 05 00 | 07 00 08 04 0e 00 00 00 |RDB$46..|........|
|00000fc0| 0a 04 14 00 00 00 09 04 | 00 00 00 00 0b 04 00 00 |........|........|
|00000fd0| 00 00 29 04 14 00 00 00 | 2a 04 15 00 00 00 2b 04 |..).....|*.....+.|
|00000fe0| 00 00 00 00 00 02 01 06 | 52 44 42 24 34 37 05 00 |........|RDB$47..|
|00000ff0| 07 00 08 04 0e 00 00 00 | 0a 04 05 00 00 00 09 04 |........|........|
|00001000| 00 00 00 00 0b 04 00 00 | 00 00 29 04 05 00 00 00 |........|..).....|
|00001010| 2a 04 15 00 00 00 2b 04 | 00 00 00 00 00 02 01 06 |*.....+.|........|
|00001020| 52 44 42 24 34 38 05 00 | 07 00 08 04 08 00 00 00 |RDB$48..|........|
|00001030| 0a 04 04 00 00 00 09 04 | 00 00 00 00 0b 04 00 00 |........|........|
|00001040| 00 00 00 02 01 06 52 44 | 42 24 34 39 05 00 07 00 |......RD|B$49....|
|00001050| 08 04 08 00 00 00 0a 04 | 04 00 00 00 09 04 00 00 |........|........|
|00001060| 00 00 0b 04 00 00 00 00 | 00 02 01 06 52 44 42 24 |........|....RDB$|
|00001070| 35 30 05 00 07 00 08 04 | 0e 00 00 00 0a 04 28 00 |50......|......(.|
|00001080| 00 00 09 04 00 00 00 00 | 0b 04 00 00 00 00 29 04 |........|......).|
|00001090| 28 00 00 00 2a 04 15 00 | 00 00 2b 04 00 00 00 00 |(...*...|..+.....|
|000010a0| 00 02 01 06 52 44 42 24 | 35 31 05 00 07 00 08 04 |....RDB$|51......|
|000010b0| 0e 00 00 00 0a 04 28 00 | 00 00 09 04 00 00 00 00 |......(.|........|
|000010c0| 0b 04 00 00 00 00 29 04 | 28 00 00 00 2a 04 15 00 |......).|(...*...|
|000010d0| 00 00 2b 04 00 00 00 00 | 00 02 01 06 52 44 42 24 |..+.....|....RDB$|
|000010e0| 35 32 05 00 07 00 08 04 | 0e 00 00 00 0a 04 28 00 |52......|......(.|
|000010f0| 00 00 09 04 00 00 00 00 | 0b 04 00 00 00 00 29 04 |........|......).|
|00001100| 28 00 00 00 2a 04 15 00 | 00 00 2b 04 00 00 00 00 |(...*...|..+.....|
|00001110| 00 02 01 06 52 44 42 24 | 35 33 05 00 07 00 08 04 |....RDB$|53......|
|00001120| 0e 00 00 00 0a 04 28 00 | 00 00 09 04 00 00 00 00 |......(.|........|
|00001130| 0b 04 00 00 00 00 29 04 | 28 00 00 00 2a 04 15 00 |......).|(...*...|
|00001140| 00 00 2b 04 00 00 00 00 | 00 02 01 06 52 44 42 24 |..+.....|....RDB$|
|00001150| 35 34 05 00 07 00 08 04 | 0e 00 00 00 0a 04 28 00 |54......|......(.|
|00001160| 00 00 09 04 00 00 00 00 | 0b 04 00 00 00 00 29 04 |........|......).|
|00001170| 28 00 00 00 2a 04 15 00 | 00 00 2b 04 00 00 00 00 |(...*...|..+.....|
|00001180| 00 02 01 06 52 44 42 24 | 35 35 05 00 07 00 08 04 |....RDB$|55......|
|00001190| 0e 00 00 00 0a 04 28 00 | 00 00 09 04 00 00 00 00 |......(.|........|
|000011a0| 0b 04 00 00 00 00 29 04 | 28 00 00 00 2a 04 15 00 |......).|(...*...|
|000011b0| 00 00 2b 04 00 00 00 00 | 00 02 01 06 52 44 42 24 |..+.....|....RDB$|
|000011c0| 35 36 05 00 07 00 08 04 | 0e 00 00 00 0a 04 08 00 |56......|........|
|000011d0| 00 00 09 04 00 00 00 00 | 0b 04 00 00 00 00 29 04 |........|......).|
|000011e0| 08 00 00 00 2a 04 15 00 | 00 00 2b 04 00 00 00 00 |....*...|..+.....|
|000011f0| 00 02 01 06 52 44 42 24 | 35 37 05 00 07 00 08 04 |....RDB$|57......|
|00001200| 25 00 00 00 0a 04 05 00 | 00 00 09 04 00 00 00 00 |%.......|........|
|00001210| 0b 04 00 00 00 00 29 04 | 05 00 00 00 2a 04 15 00 |......).|....*...|
|00001220| 00 00 2b 04 00 00 00 00 | 00 02 01 06 52 44 42 24 |..+.....|....RDB$|
|00001230| 35 38 05 00 07 00 08 04 | 07 00 00 00 0a 04 02 00 |58......|........|
|00001240| 00 00 09 04 00 00 00 00 | 0b 04 00 00 00 00 00 02 |........|........|
|00001250| 01 06 52 44 42 24 35 39 | 05 00 07 00 08 04 25 00 |..RDB$59|......%.|
|00001260| 00 00 0a 04 0f 00 00 00 | 09 04 00 00 00 00 0b 04 |........|........|
|00001270| 00 00 00 00 29 04 0f 00 | 00 00 2a 04 15 00 00 00 |....)...|..*.....|
|00001280| 2b 04 00 00 00 00 00 02 | 01 06 52 44 42 24 36 30 |+.......|..RDB$60|
|00001290| 05 00 07 00 08 04 25 00 | 00 00 0a 04 0f 00 00 00 |......%.|........|
|000012a0| 09 04 00 00 00 00 0b 04 | 00 00 00 00 29 04 0f 00 |........|....)...|
|000012b0| 00 00 2a 04 15 00 00 00 | 2b 04 00 00 00 00 00 02 |..*.....|+.......|
|000012c0| 01 06 52 44 42 24 36 31 | 05 00 07 00 08 04 25 00 |..RDB$61|......%.|
|000012d0| 00 00 0a 04 05 00 00 00 | 09 04 00 00 00 00 0b 04 |........|........|
|000012e0| 00 00 00 00 29 04 05 00 | 00 00 2a 04 15 00 00 00 |....)...|..*.....|
|000012f0| 2b 04 00 00 00 00 00 02 | 01 06 52 44 42 24 36 32 |+.......|..RDB$62|
|00001300| 05 00 07 00 08 04 25 00 | 00 00 0a 04 05 00 00 00 |......%.|........|
|00001310| 09 04 00 00 00 00 0b 04 | 00 00 00 00 29 04 05 00 |........|....)...|
|00001320| 00 00 2a 04 15 00 00 00 | 2b 04 00 00 00 00 00 02 |..*.....|+.......|
|00001330| 01 06 52 44 42 24 36 33 | 05 00 07 00 08 04 25 00 |..RDB$63|......%.|
|00001340| 00 00 0a 04 0f 00 00 00 | 09 04 00 00 00 00 0b 04 |........|........|
|00001350| 00 00 00 00 29 04 0f 00 | 00 00 2a 04 15 00 00 00 |....)...|..*.....|
|00001360| 2b 04 00 00 00 00 00 02 | 01 06 52 44 42 24 36 34 |+.......|..RDB$64|
|00001370| 05 00 07 00 08 04 25 00 | 00 00 0a 04 0f 00 00 00 |......%.|........|
|00001380| 09 04 00 00 00 00 0b 04 | 00 00 00 00 29 04 0f 00 |........|....)...|
|00001390| 00 00 2a 04 15 00 00 00 | 2b 04 00 00 00 00 00 02 |..*.....|+.......|
|000013a0| 01 06 52 44 42 24 36 35 | 05 00 07 00 08 04 25 00 |..RDB$65|......%.|
|000013b0| 00 00 0a 04 28 00 00 00 | 09 04 00 00 00 00 0b 04 |....(...|........|
|000013c0| 00 00 00 00 29 04 28 00 | 00 00 2a 04 15 00 00 00 |....).(.|..*.....|
|000013d0| 2b 04 00 00 00 00 00 02 | 01 06 52 44 42 24 36 36 |+.......|..RDB$66|
|000013e0| 05 00 07 00 08 04 25 00 | 00 00 0a 04 19 00 00 00 |......%.|........|
|000013f0| 09 04 00 00 00 00 0b 04 | 00 00 00 00 29 04 19 00 |........|....)...|
|00001400| 00 00 2a 04 15 00 00 00 | 2b 04 00 00 00 00 00 02 |..*.....|+.......|
|00001410| 01 06 52 44 42 24 36 37 | 05 00 07 00 08 04 25 00 |..RDB$67|......%.|
|00001420| 00 00 0a 04 0f 00 00 00 | 09 04 00 00 00 00 0b 04 |........|........|
|00001430| 00 00 00 00 29 04 0f 00 | 00 00 2a 04 15 00 00 00 |....)...|..*.....|
|00001440| 2b 04 00 00 00 00 00 02 | 01 06 52 44 42 24 36 38 |+.......|..RDB$68|
|00001450| 05 00 07 00 08 04 25 00 | 00 00 0a 04 28 00 00 00 |......%.|....(...|
|00001460| 09 04 00 00 00 00 0b 04 | 00 00 00 00 29 04 28 00 |........|....).(.|
|00001470| 00 00 2a 04 15 00 00 00 | 2b 04 00 00 00 00 00 02 |..*.....|+.......|
|00001480| 01 06 52 44 42 24 36 39 | 05 00 07 00 08 04 25 00 |..RDB$69|......%.|
|00001490| 00 00 0a 04 19 00 00 00 | 09 04 00 00 00 00 0b 04 |........|........|
|000014a0| 00 00 00 00 29 04 19 00 | 00 00 2a 04 15 00 00 00 |....)...|..*.....|
|000014b0| 2b 04 00 00 00 00 00 02 | 01 06 52 44 42 24 37 30 |+.......|..RDB$70|
|000014c0| 05 00 07 00 08 04 25 00 | 00 00 0a 04 0f 00 00 00 |......%.|........|
|000014d0| 09 04 00 00 00 00 0b 04 | 00 00 00 00 29 04 0f 00 |........|....)...|
|000014e0| 00 00 2a 04 15 00 00 00 | 2b 04 00 00 00 00 00 02 |..*.....|+.......|
|000014f0| 01 06 52 44 42 24 37 31 | 05 00 07 00 08 04 25 00 |..RDB$71|......%.|
|00001500| 00 00 0a 04 28 00 00 00 | 09 04 00 00 00 00 0b 04 |....(...|........|
|00001510| 00 00 00 00 29 04 28 00 | 00 00 2a 04 15 00 00 00 |....).(.|..*.....|
|00001520| 2b 04 00 00 00 00 00 02 | 01 06 52 44 42 24 37 32 |+.......|..RDB$72|
|00001530| 05 00 07 00 08 04 25 00 | 00 00 0a 04 19 00 00 00 |......%.|........|
|00001540| 09 04 00 00 00 00 0b 04 | 00 00 00 00 29 04 19 00 |........|....)...|
|00001550| 00 00 2a 04 15 00 00 00 | 2b 04 00 00 00 00 00 02 |..*.....|+.......|
|00001560| 01 06 52 44 42 24 37 33 | 05 00 07 00 08 04 25 00 |..RDB$73|......%.|
|00001570| 00 00 0a 04 0f 00 00 00 | 09 04 00 00 00 00 0b 04 |........|........|
|00001580| 00 00 00 00 29 04 0f 00 | 00 00 2a 04 15 00 00 00 |....)...|..*.....|
|00001590| 2b 04 00 00 00 00 00 18 | 01 05 52 44 42 24 34 1d |+.......|..RDB$4.|
|000015a0| 04 00 00 00 00 20 04 01 | 00 00 00 21 04 05 00 00 |..... ..|...!....|
|000015b0| 00 00 18 01 06 52 44 42 | 24 31 33 1d 04 00 00 00 |.....RDB|$13.....|
|000015c0| 00 20 04 01 00 00 00 21 | 04 04 00 00 00 00 03 01 |. .....!|........|
|000015d0| 07 43 4f 55 4e 54 52 59 | 10 04 01 00 00 00 08 0b |.COUNTRY|........|
|000015e0| 53 51 4c 24 43 4f 55 4e | 54 52 59 0c 06 53 59 53 |SQL$COUN|TRY..SYS|
|000015f0| 44 42 41 00 04 01 08 43 | 55 52 52 45 4e 43 59 02 |DBA....C|URRENCY.|
|00001600| 05 52 44 42 24 31 0d 04 | 01 00 00 00 08 04 25 00 |.RDB$1..|......%.|
|00001610| 00 00 0a 04 0a 00 00 00 | 09 04 00 00 00 00 0b 04 |........|........|
|00001620| 00 00 00 00 16 04 02 00 | 00 00 18 04 00 00 00 00 |........|........|
|00001630| 22 04 01 00 00 00 26 04 | 01 00 00 00 2a 04 15 00 |".....&.|....*...|
|00001640| 00 00 2b 04 00 00 00 00 | 00 04 01 07 43 4f 55 4e |..+.....|....COUN|
|00001650| 54 52 59 02 0b 43 4f 55 | 4e 54 52 59 4e 41 4d 45 |TRY..COU|NTRYNAME|
|00001660| 0d 04 00 00 00 00 08 04 | 25 00 00 00 0a 04 0f 00 |........|%.......|
|00001670| 00 00 09 04 00 00 00 00 | 0b 04 00 00 00 00 16 04 |........|........|
|00001680| 01 00 00 00 18 04 00 00 | 00 00 22 04 01 00 00 00 |........|..".....|
|00001690| 26 04 01 00 00 00 2a 04 | 15 00 00 00 00 09 03 01 |&.....*.|........|
|000016a0| 03 4a 4f 42 10 04 01 00 | 00 00 08 07 53 51 4c 24 |.JOB....|....SQL$|
|000016b0| 4a 4f 42 0c 06 53 59 53 | 44 42 41 00 04 01 0f 4a |JOB..SYS|DBA....J|
|000016c0| 4f 42 5f 52 45 51 55 49 | 52 45 4d 45 4e 54 02 05 |OB_REQUI|REMENT..|
|000016d0| 52 44 42 24 33 0d 04 06 | 00 00 00 08 04 05 01 00 |RDB$3...|........|
|000016e0| 00 0a 04 08 00 00 00 09 | 04 01 00 00 00 0b 04 00 |........|........|
|000016f0| 00 00 00 16 04 07 00 00 | 00 18 04 00 00 00 00 22 |........|......."|
|00001700| 04 01 00 00 00 2a 04 15 | 00 00 00 00 04 01 0a 4d |.....*..|.......M|
|00001710| 41 58 5f 53 41 4c 41 52 | 59 02 06 53 41 4c 41 52 |AX_SALAR|Y..SALAR|
|00001720| 59 0d 04 05 00 00 00 08 | 04 1b 00 00 00 0a 04 08 |Y.......|........|
|00001730| 00 00 00 09 04 00 00 00 | 00 0b 04 fe ff ff ff 16 |........|........|
|00001740| 04 06 00 00 00 18 04 00 | 00 00 00 22 04 01 00 00 |........|..."....|
|00001750| 00 26 04 01 00 00 00 00 | 04 01 0a 4d 49 4e 5f 53 |.&......|...MIN_S|
|00001760| 41 4c 41 52 59 02 06 53 | 41 4c 41 52 59 0d 04 04 |ALARY..S|ALARY...|
|00001770| 00 00 00 08 04 1b 00 00 | 00 0a 04 08 00 00 00 09 |........|........|
|00001780| 04 00 00 00 00 0b 04 fe | ff ff ff 16 04 05 00 00 |........|........|
|00001790| 00 18 04 00 00 00 00 22 | 04 01 00 00 00 26 04 01 |......."|.....&..|
|000017a0| 00 00 00 00 04 01 09 4a | 4f 42 5f 47 52 41 44 45 |.......J|OB_GRADE|
|000017b0| 02 08 4a 4f 42 47 52 41 | 44 45 0d 04 01 00 00 00 |..JOBGRA|DE......|
|000017c0| 08 04 07 00 00 00 0a 04 | 02 00 00 00 09 04 00 00 |........|........|
|000017d0| 00 00 0b 04 00 00 00 00 | 16 04 02 00 00 00 18 04 |........|........|
|000017e0| 00 00 00 00 22 04 01 00 | 00 00 26 04 01 00 00 00 |...."...|..&.....|
|000017f0| 00 04 01 0c 4c 41 4e 47 | 55 41 47 45 5f 52 45 51 |....LANG|UAGE_REQ|
|00001800| 02 05 52 44 42 24 34 0d | 04 07 00 00 00 08 04 25 |..RDB$4.|.......%|
|00001810| 00 00 00 0a 04 0f 00 00 | 00 09 04 00 00 00 00 0b |........|........|
|00001820| 04 00 00 00 00 16 04 08 | 00 00 00 18 04 00 00 00 |........|........|
|00001830| 00 22 04 01 00 00 00 2a | 04 15 00 00 00 2b 04 00 |.".....*|.....+..|
|00001840| 00 00 00 1d 04 01 00 00 | 00 20 04 01 00 00 00 21 |........|. .....!|
|00001850| 04 05 00 00 00 00 04 01 | 09 4a 4f 42 5f 54 49 54 |........|.JOB_TIT|
|00001860| 4c 45 02 05 52 44 42 24 | 32 0d 04 03 00 00 00 08 |LE..RDB$|2.......|
|00001870| 04 25 00 00 00 0a 04 19 | 00 00 00 09 04 00 00 00 |.%......|........|
|00001880| 00 0b 04 00 00 00 00 16 | 04 04 00 00 00 18 04 00 |........|........|
|00001890| 00 00 00 22 04 01 00 00 | 00 26 04 01 00 00 00 2a |..."....|.&.....*|
|000018a0| 04 15 00 00 00 2b 04 00 | 00 00 00 00 04 01 0b 4a |.....+..|.......J|
|000018b0| 4f 42 5f 43 4f 55 4e 54 | 52 59 02 0b 43 4f 55 4e |OB_COUNT|RY..COUN|
|000018c0| 54 52 59 4e 41 4d 45 0d | 04 02 00 00 00 08 04 25 |TRYNAME.|.......%|
|000018d0| 00 00 00 0a 04 0f 00 00 | 00 09 04 00 00 00 00 0b |........|........|
|000018e0| 04 00 00 00 00 16 04 03 | 00 00 00 18 04 00 00 00 |........|........|
|000018f0| 00 22 04 01 00 00 00 26 | 04 01 00 00 00 2a 04 15 |.".....&|.....*..|
|00001900| 00 00 00 00 04 01 08 4a | 4f 42 5f 43 4f 44 45 02 |.......J|OB_CODE.|
|00001910| 07 4a 4f 42 43 4f 44 45 | 0d 04 00 00 00 00 08 04 |.JOBCODE|........|
|00001920| 25 00 00 00 0a 04 05 00 | 00 00 09 04 00 00 00 00 |%.......|........|
|00001930| 0b 04 00 00 00 00 16 04 | 01 00 00 00 18 04 00 00 |........|........|
|00001940| 00 00 22 04 01 00 00 00 | 26 04 01 00 00 00 2a 04 |..".....|&.....*.|
|00001950| 02 00 00 00 00 09 03 01 | 0a 44 45 50 41 52 54 4d |........|.DEPARTM|
|00001960| 45 4e 54 10 04 01 00 00 | 00 08 0e 53 51 4c 24 44 |ENT.....|...SQL$D|
|00001970| 45 50 41 52 54 4d 45 4e | 54 0c 06 53 59 53 44 42 |EPARTMEN|T..SYSDB|
|00001980| 41 00 04 01 06 42 55 44 | 47 45 54 02 06 42 55 44 |A....BUD|GET..BUD|
|00001990| 47 45 54 0d 04 04 00 00 | 00 08 04 1b 00 00 00 0a |GET.....|........|
|000019a0| 04 08 00 00 00 09 04 00 | 00 00 00 0b 04 fe ff ff |........|........|
|000019b0| ff 16 04 05 00 00 00 18 | 04 00 00 00 00 22 04 01 |........|....."..|
|000019c0| 00 00 00 00 04 01 08 50 | 48 4f 4e 45 5f 4e 4f 02 |.......P|HONE_NO.|
|000019d0| 0b 50 48 4f 4e 45 4e 55 | 4d 42 45 52 0d 04 06 00 |.PHONENU|MBER....|
|000019e0| 00 00 08 04 25 00 00 00 | 0a 04 14 00 00 00 09 04 |....%...|........|
|000019f0| 00 00 00 00 0b 04 00 00 | 00 00 16 04 07 00 00 00 |........|........|
|00001a00| 18 04 00 00 00 00 22 04 | 01 00 00 00 2a 04 15 00 |......".|....*...|
|00001a10| 00 00 0f 04 10 00 00 00 | 04 15 0f 7f 00 08 00 35 |........|.......5|
|00001a20| 35 35 2d 31 32 33 34 4c | 27 04 14 00 00 00 20 44 |55-1234L|'..... D|
|00001a30| 45 46 41 55 4c 54 20 27 | 35 35 35 2d 31 32 33 34 |EFAULT '|555-1234|
|00001a40| 27 00 00 04 01 07 4d 4e | 47 52 5f 4e 4f 02 05 45 |'.....MN|GR_NO..E|
|00001a50| 4d 50 4e 4f 0d 04 03 00 | 00 00 08 04 07 00 00 00 |MPNO....|........|
|00001a60| 0a 04 02 00 00 00 09 04 | 00 00 00 00 0b 04 00 00 |........|........|
|00001a70| 00 00 16 04 04 00 00 00 | 18 04 00 00 00 00 22 04 |........|......".|
|00001a80| 01 00 00 00 00 04 01 08 | 4c 4f 43 41 54 49 4f 4e |........|LOCATION|
|00001a90| 02 05 52 44 42 24 36 0d | 04 05 00 00 00 08 04 25 |..RDB$6.|.......%|
|00001aa0| 00 00 00 0a 04 0f 00 00 | 00 09 04 00 00 00 00 0b |........|........|
|00001ab0| 04 00 00 00 00 16 04 06 | 00 00 00 18 04 00 00 00 |........|........|
|00001ac0| 00 22 04 01 00 00 00 2a | 04 15 00 00 00 2b 04 00 |.".....*|.....+..|
|00001ad0| 00 00 00 00 04 01 09 48 | 45 41 44 5f 44 45 50 54 |.......H|EAD_DEPT|
|00001ae0| 02 06 44 45 50 54 4e 4f | 0d 04 02 00 00 00 08 04 |..DEPTNO|........|
|00001af0| 0e 00 00 00 0a 04 03 00 | 00 00 09 04 00 00 00 00 |........|........|
|00001b00| 0b 04 00 00 00 00 16 04 | 03 00 00 00 18 04 00 00 |........|........|
|00001b10| 00 00 22 04 01 00 00 00 | 2a 04 02 00 00 00 00 04 |..".....|*.......|
|00001b20| 01 0a 44 45 50 41 52 54 | 4d 45 4e 54 02 05 52 44 |..DEPART|MENT..RD|
|00001b30| 42 24 35 0d 04 01 00 00 | 00 08 04 25 00 00 00 0a |B$5.....|...%....|
|00001b40| 04 19 00 00 00 09 04 00 | 00 00 00 0b 04 00 00 00 |........|........|
|00001b50| 00 16 04 02 00 00 00 18 | 04 00 00 00 00 22 04 01 |........|....."..|
|00001b60| 00 00 00 26 04 01 00 00 | 00 2a 04 15 00 00 00 2b |...&....|.*.....+|
|00001b70| 04 00 00 00 00 00 04 01 | 07 44 45 50 54 5f 4e 4f |........|.DEPT_NO|
|00001b80| 02 06 44 45 50 54 4e 4f | 0d 04 00 00 00 00 08 04 |..DEPTNO|........|
|00001b90| 0e 00 00 00 0a 04 03 00 | 00 00 09 04 00 00 00 00 |........|........|
|00001ba0| 0b 04 00 00 00 00 16 04 | 01 00 00 00 18 04 00 00 |........|........|
|00001bb0| 00 00 22 04 01 00 00 00 | 26 04 01 00 00 00 2a 04 |..".....|&.....*.|
|00001bc0| 02 00 00 00 00 09 03 01 | 08 45 4d 50 4c 4f 59 45 |........|.EMPLOYE|
|00001bd0| 45 10 04 01 00 00 00 08 | 0c 53 51 4c 24 45 4d 50 |E.......|.SQL$EMP|
|00001be0| 4c 4f 59 45 45 0c 06 53 | 59 53 44 42 41 00 04 01 |LOYEE..S|YSDBA...|
|00001bf0| 06 53 41 4c 41 52 59 02 | 06 53 41 4c 41 52 59 0d |.SALARY.|.SALARY.|
|00001c00| 04 09 00 00 00 08 04 1b | 00 00 00 0a 04 08 00 00 |........|........|
|00001c10| 00 09 04 00 00 00 00 0b | 04 fe ff ff ff 16 04 0a |........|........|
|00001c20| 00 00 00 18 04 00 00 00 | 00 22 04 01 00 00 00 26 |........|.".....&|
|00001c30| 04 01 00 00 00 00 04 01 | 09 48 49 52 45 5f 44 41 |........|.HIRE_DA|
|00001c40| 54 45 02 05 52 44 42 24 | 38 0d 04 04 00 00 00 08 |TE..RDB$|8.......|
|00001c50| 04 23 00 00 00 0a 04 08 | 00 00 00 09 04 00 00 00 |.#......|........|
|00001c60| 00 0b 04 00 00 00 00 16 | 04 05 00 00 00 18 04 00 |........|........|
|00001c70| 00 00 00 22 04 01 00 00 | 00 26 04 01 00 00 00 0f |..."....|.&......|
|00001c80| 04 0b 00 00 00 04 15 0f | 7f 00 03 00 4e 4f 57 4c |........|....NOWL|
|00001c90| 27 04 0e 00 00 00 44 45 | 46 41 55 4c 54 20 27 4e |'.....DE|FAULT 'N|
|00001ca0| 4f 57 27 00 00 04 01 09 | 46 55 4c 4c 5f 4e 41 4d |OW'.....|FULL_NAM|
|00001cb0| 45 02 05 52 44 42 24 39 | 0d 04 0a 00 00 00 08 04 |E..RDB$9|........|
|00001cc0| 25 00 00 00 0a 04 2a 00 | 00 00 09 04 00 00 00 00 |%.....*.|........|
|00001cd0| 0b 04 00 00 00 00 16 04 | 0b 00 00 00 18 04 00 00 |........|........|
|00001ce0| 00 00 22 04 00 00 00 00 | 2a 04 15 00 00 00 2b 04 |..".....|*.....+.|
|00001cf0| 00 00 00 00 17 04 01 00 | 00 00 00 04 01 09 4a 4f |........|......JO|
|00001d00| 42 5f 47 52 41 44 45 02 | 08 4a 4f 42 47 52 41 44 |B_GRADE.|.JOBGRAD|
|00001d10| 45 0d 04 07 00 00 00 08 | 04 07 00 00 00 0a 04 02 |E.......|........|
|00001d20| 00 00 00 09 04 00 00 00 | 00 0b 04 00 00 00 00 16 |........|........|
|00001d30| 04 08 00 00 00 18 04 00 | 00 00 00 22 04 01 00 00 |........|..."....|
|00001d40| 00 26 04 01 00 00 00 00 | 04 01 09 50 48 4f 4e 45 |.&......|...PHONE|
|00001d50| 5f 45 58 54 02 05 52 44 | 42 24 37 0d 04 03 00 00 |_EXT..RD|B$7.....|
|00001d60| 00 08 04 25 00 00 00 0a | 04 04 00 00 00 09 04 00 |...%....|........|
|00001d70| 00 00 00 0b 04 00 00 00 | 00 16 04 04 00 00 00 18 |........|........|
|00001d80| 04 00 00 00 00 22 04 01 | 00 00 00 2a 04 15 00 00 |....."..|...*....|
|00001d90| 00 2b 04 00 00 00 00 00 | 04 01 06 45 4d 50 5f 4e |.+......|...EMP_N|
|00001da0| 4f 02 05 45 4d 50 4e 4f | 0d 04 00 00 00 00 08 04 |O..EMPNO|........|
|00001db0| 07 00 00 00 0a 04 02 00 | 00 00 09 04 00 00 00 00 |........|........|
|00001dc0| 0b 04 00 00 00 00 16 04 | 01 00 00 00 18 04 00 00 |........|........|
|00001dd0| 00 00 22 04 01 00 00 00 | 26 04 01 00 00 00 00 04 |..".....|&.......|
|00001de0| 01 0b 4a 4f 42 5f 43 4f | 55 4e 54 52 59 02 0b 43 |..JOB_CO|UNTRY..C|
|00001df0| 4f 55 4e 54 52 59 4e 41 | 4d 45 0d 04 08 00 00 00 |OUNTRYNA|ME......|
|00001e00| 08 04 25 00 00 00 0a 04 | 0f 00 00 00 09 04 00 00 |..%.....|........|
|00001e10| 00 00 0b 04 00 00 00 00 | 16 04 09 00 00 00 18 04 |........|........|
|00001e20| 00 00 00 00 22 04 01 00 | 00 00 26 04 01 00 00 00 |...."...|..&.....|
|00001e30| 2a 04 15 00 00 00 00 04 | 01 08 4a 4f 42 5f 43 4f |*.......|..JOB_CO|
|00001e40| 44 45 02 07 4a 4f 42 43 | 4f 44 45 0d 04 06 00 00 |DE..JOBC|ODE.....|
|00001e50| 00 08 04 25 00 00 00 0a | 04 05 00 00 00 09 04 00 |...%....|........|
|00001e60| 00 00 00 0b 04 00 00 00 | 00 16 04 07 00 00 00 18 |........|........|
|00001e70| 04 00 00 00 00 22 04 01 | 00 00 00 26 04 01 00 00 |....."..|...&....|
|00001e80| 00 2a 04 02 00 00 00 00 | 04 01 07 44 45 50 54 5f |.*......|...DEPT_|
|00001e90| 4e 4f 02 06 44 45 50 54 | 4e 4f 0d 04 05 00 00 00 |NO..DEPT|NO......|
|00001ea0| 08 04 0e 00 00 00 0a 04 | 03 00 00 00 09 04 00 00 |........|........|
|00001eb0| 00 00 0b 04 00 00 00 00 | 16 04 06 00 00 00 18 04 |........|........|
|00001ec0| 00 00 00 00 22 04 01 00 | 00 00 26 04 01 00 00 00 |...."...|..&.....|
|00001ed0| 2a 04 02 00 00 00 00 04 | 01 09 4c 41 53 54 5f 4e |*.......|..LAST_N|
|00001ee0| 41 4d 45 02 08 4c 41 53 | 54 4e 41 4d 45 0d 04 02 |AME..LAS|TNAME...|
|00001ef0| 00 00 00 08 04 25 00 00 | 00 0a 04 19 00 00 00 09 |.....%..|........|
|00001f00| 04 00 00 00 00 0b 04 00 | 00 00 00 16 04 03 00 00 |........|........|
|00001f10| 00 18 04 00 00 00 00 22 | 04 01 00 00 00 26 04 01 |......."|.....&..|
|00001f20| 00 00 00 2a 04 15 00 00 | 00 00 04 01 0a 46 49 52 |...*....|.....FIR|
|00001f30| 53 54 5f 4e 41 4d 45 02 | 09 46 49 52 53 54 4e 41 |ST_NAME.|.FIRSTNA|
|00001f40| 4d 45 0d 04 01 00 00 00 | 08 04 25 00 00 00 0a 04 |ME......|..%.....|
|00001f50| 0f 00 00 00 09 04 00 00 | 00 00 0b 04 00 00 00 00 |........|........|
|00001f60| 16 04 02 00 00 00 18 04 | 00 00 00 00 22 04 01 00 |........|...."...|
|00001f70| 00 00 26 04 01 00 00 00 | 2a 04 15 00 00 00 00 09 |..&.....|*.......|
|00001f80| 03 01 0a 50 48 4f 4e 45 | 5f 4c 49 53 54 02 04 33 |...PHONE|_LIST..3|
|00001f90| 00 00 00 04 43 02 4a 08 | 45 4d 50 4c 4f 59 45 45 |....C.J.|EMPLOYEE|
|00001fa0| 01 4a 0a 44 45 50 41 52 | 54 4d 45 4e 54 02 47 2f |.J.DEPAR|TMENT.G/|
|00001fb0| 17 01 07 44 45 50 54 5f | 4e 4f 17 02 07 44 45 50 |...DEPT_|NO...DEP|
|00001fc0| 54 5f 4e 4f ff 4c 10 04 | 01 00 00 00 08 0e 53 51 |T_NO.L..|......SQ|
|00001fd0| 4c 24 50 48 4f 4e 45 5f | 4c 49 53 54 0e 04 97 00 |L$PHONE_|LIST....|
|00001fe0| 00 00 20 53 45 4c 45 43 | 54 0a 20 20 20 20 65 6d |.. SELEC|T.    em|
|00001ff0| 70 5f 6e 6f 2c 20 66 69 | 72 73 74 5f 6e 61 6d 65 |p_no, fi|rst_name|
|00002000| 2c 20 6c 61 73 74 5f 6e | 61 6d 65 2c 20 70 68 6f |, last_n|ame, pho|
|00002010| 6e 65 5f 65 78 74 2c 20 | 6c 6f 63 61 74 69 6f 6e |ne_ext, |location|
|00002020| 2c 20 70 68 6f 6e 65 5f | 6e 6f 0a 20 20 20 20 46 |, phone_|no.    F|
|00002030| 52 4f 4d 20 65 6d 70 6c | 6f 79 65 65 2c 20 64 65 |ROM empl|oyee, de|
|00002040| 70 61 72 74 6d 65 6e 74 | 0a 20 20 20 20 57 48 45 |partment|.    WHE|
|00002050| 52 45 20 65 6d 70 6c 6f | 79 65 65 2e 64 65 70 74 |RE emplo|yee.dept|
|00002060| 5f 6e 6f 20 3d 20 64 65 | 70 61 72 74 6d 65 6e 74 |_no = de|partment|
|00002070| 2e 64 65 70 74 5f 6e 6f | 00 0c 06 53 59 53 44 42 |.dept_no|...SYSDB|
|00002080| 41 00 04 01 08 50 48 4f | 4e 45 5f 4e 4f 02 0b 50 |A....PHO|NE_NO..P|
|00002090| 48 4f 4e 45 4e 55 4d 42 | 45 52 0d 04 05 00 00 00 |HONENUMB|ER......|
|000020a0| 08 04 25 00 00 00 0a 04 | 14 00 00 00 09 04 00 00 |..%.....|........|
|000020b0| 00 00 0b 04 00 00 00 00 | 16 04 06 00 00 00 18 04 |........|........|
|000020c0| 00 00 00 00 22 04 00 00 | 00 00 2a 04 15 00 00 00 |...."...|..*.....|
|000020d0| 04 04 02 00 00 00 03 08 | 50 48 4f 4e 45 5f 4e 4f |........|PHONE_NO|
|000020e0| 00 04 01 09 50 48 4f 4e | 45 5f 45 58 54 02 05 52 |....PHON|E_EXT..R|
|000020f0| 44 42 24 37 0d 04 03 00 | 00 00 08 04 25 00 00 00 |DB$7....|....%...|
|00002100| 0a 04 04 00 00 00 09 04 | 00 00 00 00 0b 04 00 00 |........|........|
|00002110| 00 00 16 04 04 00 00 00 | 18 04 00 00 00 00 22 04 |........|......".|
|00002120| 00 00 00 00 2a 04 15 00 | 00 00 04 04 01 00 00 00 |....*...|........|
|00002130| 03 09 50 48 4f 4e 45 5f | 45 58 54 00 04 01 06 45 |..PHONE_|EXT....E|
|00002140| 4d 50 5f 4e 4f 02 05 45 | 4d 50 4e 4f 0d 04 00 00 |MP_NO..E|MPNO....|
|00002150| 00 00 08 04 07 00 00 00 | 0a 04 02 00 00 00 09 04 |........|........|
|00002160| 00 00 00 00 0b 04 00 00 | 00 00 16 04 01 00 00 00 |........|........|
|00002170| 18 04 00 00 00 00 22 04 | 00 00 00 00 04 04 01 00 |......".|........|
|00002180| 00 00 03 06 45 4d 50 5f | 4e 4f 00 04 01 08 4c 4f |....EMP_|NO....LO|
|00002190| 43 41 54 49 4f 4e 02 05 | 52 44 42 24 36 0d 04 04 |CATION..|RDB$6...|
|000021a0| 00 00 00 08 04 25 00 00 | 00 0a 04 0f 00 00 00 09 |.....%..|........|
|000021b0| 04 00 00 00 00 0b 04 00 | 00 00 00 16 04 05 00 00 |........|........|
|000021c0| 00 18 04 00 00 00 00 22 | 04 00 00 00 00 2a 04 15 |......."|.....*..|
|000021d0| 00 00 00 04 04 02 00 00 | 00 03 08 4c 4f 43 41 54 |........|...LOCAT|
|000021e0| 49 4f 4e 00 04 01 09 4c | 41 53 54 5f 4e 41 4d 45 |ION....L|AST_NAME|
|000021f0| 02 08 4c 41 53 54 4e 41 | 4d 45 0d 04 02 00 00 00 |..LASTNA|ME......|
|00002200| 08 04 25 00 00 00 0a 04 | 19 00 00 00 09 04 00 00 |..%.....|........|
|00002210| 00 00 0b 04 00 00 00 00 | 16 04 03 00 00 00 18 04 |........|........|
|00002220| 00 00 00 00 22 04 00 00 | 00 00 2a 04 15 00 00 00 |...."...|..*.....|
|00002230| 04 04 01 00 00 00 03 09 | 4c 41 53 54 5f 4e 41 4d |........|LAST_NAM|
|00002240| 45 00 04 01 0a 46 49 52 | 53 54 5f 4e 41 4d 45 02 |E....FIR|ST_NAME.|
|00002250| 09 46 49 52 53 54 4e 41 | 4d 45 0d 04 01 00 00 00 |.FIRSTNA|ME......|
|00002260| 08 04 25 00 00 00 0a 04 | 0f 00 00 00 09 04 00 00 |..%.....|........|
|00002270| 00 00 0b 04 00 00 00 00 | 16 04 02 00 00 00 18 04 |........|........|
|00002280| 00 00 00 00 22 04 00 00 | 00 00 2a 04 15 00 00 00 |...."...|..*.....|
|00002290| 04 04 01 00 00 00 03 0a | 46 49 52 53 54 5f 4e 41 |........|FIRST_NA|
|000022a0| 4d 45 00 0b 08 0a 44 45 | 50 41 52 54 4d 45 4e 54 |ME....DE|PARTMENT|
|000022b0| 09 04 02 00 00 00 0a 0a | 44 45 50 41 52 54 4d 45 |........|DEPARTME|
|000022c0| 4e 54 00 0b 08 08 45 4d | 50 4c 4f 59 45 45 09 04 |NT....EM|PLOYEE..|
|000022d0| 01 00 00 00 0a 08 45 4d | 50 4c 4f 59 45 45 00 09 |......EM|PLOYEE..|
|000022e0| 03 01 07 50 52 4f 4a 45 | 43 54 10 04 01 00 00 00 |...PROJE|CT......|
|000022f0| 08 0b 53 51 4c 24 50 52 | 4f 4a 45 43 54 0c 06 53 |..SQL$PR|OJECT..S|
|00002300| 59 53 44 42 41 00 04 01 | 09 50 52 4f 4a 5f 44 45 |YSDBA...|.PROJ_DE|
|00002310| 53 43 02 06 52 44 42 24 | 31 31 0d 04 02 00 00 00 |SC..RDB$|11......|
|00002320| 08 04 05 01 00 00 0a 04 | 08 00 00 00 09 04 01 00 |........|........|
|00002330| 00 00 0b 04 00 00 00 00 | 16 04 03 00 00 00 18 04 |........|........|
|00002340| 00 00 00 00 22 04 01 00 | 00 00 2a 04 15 00 00 00 |...."...|..*.....|
|00002350| 00 04 01 07 50 52 4f 44 | 55 43 54 02 08 50 52 4f |....PROD|UCT..PRO|
|00002360| 44 54 59 50 45 0d 04 04 | 00 00 00 08 04 25 00 00 |DTYPE...|.....%..|
|00002370| 00 0a 04 0c 00 00 00 09 | 04 00 00 00 00 0b 04 00 |........|........|
|00002380| 00 00 00 16 04 05 00 00 | 00 18 04 00 00 00 00 22 |........|......."|
|00002390| 04 01 00 00 00 2a 04 15 | 00 00 00 00 04 01 0b 54 |.....*..|.......T|
|000023a0| 45 41 4d 5f 4c 45 41 44 | 45 52 02 05 45 4d 50 4e |EAM_LEAD|ER..EMPN|
|000023b0| 4f 0d 04 03 00 00 00 08 | 04 07 00 00 00 0a 04 02 |O.......|........|
|000023c0| 00 00 00 09 04 00 00 00 | 00 0b 04 00 00 00 00 16 |........|........|
|000023d0| 04 04 00 00 00 18 04 00 | 00 00 00 22 04 01 00 00 |........|..."....|
|000023e0| 00 00 04 01 09 50 52 4f | 4a 5f 4e 41 4d 45 02 06 |.....PRO|J_NAME..|
|000023f0| 52 44 42 24 31 30 0d 04 | 01 00 00 00 08 04 25 00 |RDB$10..|......%.|
|00002400| 00 00 0a 04 14 00 00 00 | 09 04 00 00 00 00 0b 04 |........|........|
|00002410| 00 00 00 00 16 04 02 00 | 00 00 18 04 00 00 00 00 |........|........|
|00002420| 22 04 01 00 00 00 26 04 | 01 00 00 00 2a 04 15 00 |".....&.|....*...|
|00002430| 00 00 2b 04 00 00 00 00 | 00 04 01 07 50 52 4f 4a |..+.....|....PROJ|
|00002440| 5f 49 44 02 06 50 52 4f | 4a 4e 4f 0d 04 00 00 00 |_ID..PRO|JNO.....|
|00002450| 00 08 04 0e 00 00 00 0a | 04 05 00 00 00 09 04 00 |........|........|
|00002460| 00 00 00 0b 04 00 00 00 | 00 16 04 01 00 00 00 18 |........|........|
|00002470| 04 00 00 00 00 22 04 01 | 00 00 00 26 04 01 00 00 |....."..|...&....|
|00002480| 00 2a 04 02 00 00 00 00 | 09 03 01 08 43 55 53 54 |.*......|....CUST|
|00002490| 4f 4d 45 52 10 04 01 00 | 00 00 08 0c 53 51 4c 24 |OMER....|....SQL$|
|000024a0| 43 55 53 54 4f 4d 45 52 | 0c 06 53 59 53 44 42 41 |CUSTOMER|..SYSDBA|
|000024b0| 00 04 01 07 43 55 53 54 | 5f 4e 4f 02 06 43 55 53 |....CUST|_NO..CUS|
|000024c0| 54 4e 4f 0d 04 00 00 00 | 00 08 04 08 00 00 00 0a |TNO.....|........|
|000024d0| 04 04 00 00 00 09 04 00 | 00 00 00 0b 04 00 00 00 |........|........|
|000024e0| 00 16 04 01 00 00 00 18 | 04 00 00 00 00 22 04 01 |........|....."..|
|000024f0| 00 00 00 26 04 01 00 00 | 00 00 04 01 0b 50 4f 53 |...&....|.....POS|
|00002500| 54 41 4c 5f 43 4f 44 45 | 02 06 52 44 42 24 32 31 |TAL_CODE|..RDB$21|
|00002510| 0d 04 0a 00 00 00 08 04 | 25 00 00 00 0a 04 0c 00 |........|%.......|
|00002520| 00 00 09 04 00 00 00 00 | 0b 04 00 00 00 00 16 04 |........|........|
|00002530| 0b 00 00 00 18 04 00 00 | 00 00 22 04 01 00 00 00 |........|..".....|
|00002540| 2a 04 15 00 00 00 2b 04 | 00 00 00 00 00 04 01 0d |*.....+.|........|
|00002550| 41 44 44 52 45 53 53 5f | 4c 49 4e 45 32 02 0b 41 |ADDRESS_|LINE2..A|
|00002560| 44 44 52 45 53 53 4c 49 | 4e 45 0d 04 06 00 00 00 |DDRESSLI|NE......|
|00002570| 08 04 25 00 00 00 0a 04 | 28 00 00 00 09 04 00 00 |..%.....|(.......|
|00002580| 00 00 0b 04 00 00 00 00 | 16 04 07 00 00 00 18 04 |........|........|
|00002590| 00 00 00 00 22 04 01 00 | 00 00 2a 04 15 00 00 00 |...."...|..*.....|
|000025a0| 00 04 01 0d 41 44 44 52 | 45 53 53 5f 4c 49 4e 45 |....ADDR|ESS_LINE|
|000025b0| 31 02 0b 41 44 44 52 45 | 53 53 4c 49 4e 45 0d 04 |1..ADDRE|SSLINE..|
|000025c0| 05 00 00 00 08 04 25 00 | 00 00 0a 04 28 00 00 00 |......%.|....(...|
|000025d0| 09 04 00 00 00 00 0b 04 | 00 00 00 00 16 04 06 00 |........|........|
|000025e0| 00 00 18 04 00 00 00 00 | 22 04 01 00 00 00 2a 04 |........|".....*.|
|000025f0| 15 00 00 00 00 04 01 08 | 50 48 4f 4e 45 5f 4e 4f |........|PHONE_NO|
|00002600| 02 0b 50 48 4f 4e 45 4e | 55 4d 42 45 52 0d 04 04 |..PHONEN|UMBER...|
|00002610| 00 00 00 08 04 25 00 00 | 00 0a 04 14 00 00 00 09 |.....%..|........|
|00002620| 04 00 00 00 00 0b 04 00 | 00 00 00 16 04 05 00 00 |........|........|
|00002630| 00 18 04 00 00 00 00 22 | 04 01 00 00 00 2a 04 15 |......."|.....*..|
|00002640| 00 00 00 00 04 01 07 4f | 4e 5f 48 4f 4c 44 02 06 |.......O|N_HOLD..|
|00002650| 52 44 42 24 32 32 0d 04 | 0b 00 00 00 08 04 0e 00 |RDB$22..|........|
|00002660| 00 00 0a 04 01 00 00 00 | 09 04 00 00 00 00 0b 04 |........|........|
|00002670| 00 00 00 00 16 04 0c 00 | 00 00 18 04 00 00 00 00 |........|........|
|00002680| 22 04 01 00 00 00 2a 04 | 15 00 00 00 2b 04 00 00 |".....*.|....+...|
|00002690| 00 00 0f 04 03 00 00 00 | 04 2d 4c 27 04 0d 00 00 |........|.-L'....|
|000026a0| 00 44 45 46 41 55 4c 54 | 20 4e 55 4c 4c 00 00 04 |.DEFAULT| NULL...|
|000026b0| 01 07 43 4f 55 4e 54 52 | 59 02 0b 43 4f 55 4e 54 |..COUNTR|Y..COUNT|
|000026c0| 52 59 4e 41 4d 45 0d 04 | 09 00 00 00 08 04 25 00 |RYNAME..|......%.|
|000026d0| 00 00 0a 04 0f 00 00 00 | 09 04 00 00 00 00 0b 04 |........|........|
|000026e0| 00 00 00 00 16 04 0a 00 | 00 00 18 04 00 00 00 00 |........|........|
|000026f0| 22 04 01 00 00 00 2a 04 | 15 00 00 00 00 04 01 0e |".....*.|........|
|00002700| 53 54 41 54 45 5f 50 52 | 4f 56 49 4e 43 45 02 06 |STATE_PR|OVINCE..|
|00002710| 52 44 42 24 32 30 0d 04 | 08 00 00 00 08 04 25 00 |RDB$20..|......%.|
|00002720| 00 00 0a 04 0f 00 00 00 | 09 04 00 00 00 00 0b 04 |........|........|
|00002730| 00 00 00 00 16 04 09 00 | 00 00 18 04 00 00 00 00 |........|........|
|00002740| 22 04 01 00 00 00 2a 04 | 15 00 00 00 2b 04 00 00 |".....*.|....+...|
|00002750| 00 00 00 04 01 04 43 49 | 54 59 02 06 52 44 42 24 |......CI|TY..RDB$|
|00002760| 31 39 0d 04 07 00 00 00 | 08 04 25 00 00 00 0a 04 |19......|..%.....|
|00002770| 19 00 00 00 09 04 00 00 | 00 00 0b 04 00 00 00 00 |........|........|
|00002780| 16 04 08 00 00 00 18 04 | 00 00 00 00 22 04 01 00 |........|...."...|
|00002790| 00 00 2a 04 15 00 00 00 | 2b 04 00 00 00 00 00 04 |..*.....|+.......|
|000027a0| 01 0c 43 4f 4e 54 41 43 | 54 5f 4c 41 53 54 02 08 |..CONTAC|T_LAST..|
|000027b0| 4c 41 53 54 4e 41 4d 45 | 0d 04 03 00 00 00 08 04 |LASTNAME|........|
|000027c0| 25 00 00 00 0a 04 19 00 | 00 00 09 04 00 00 00 00 |%.......|........|
|000027d0| 0b 04 00 00 00 00 16 04 | 04 00 00 00 18 04 00 00 |........|........|
|000027e0| 00 00 22 04 01 00 00 00 | 2a 04 15 00 00 00 00 04 |..".....|*.......|
|000027f0| 01 0d 43 4f 4e 54 41 43 | 54 5f 46 49 52 53 54 02 |..CONTAC|T_FIRST.|
|00002800| 09 46 49 52 53 54 4e 41 | 4d 45 0d 04 02 00 00 00 |.FIRSTNA|ME......|
|00002810| 08 04 25 00 00 00 0a 04 | 0f 00 00 00 09 04 00 00 |..%.....|........|
|00002820| 00 00 0b 04 00 00 00 00 | 16 04 03 00 00 00 18 04 |........|........|
|00002830| 00 00 00 00 22 04 01 00 | 00 00 2a 04 15 00 00 00 |...."...|..*.....|
|00002840| 00 04 01 08 43 55 53 54 | 4f 4d 45 52 02 06 52 44 |....CUST|OMER..RD|
|00002850| 42 24 31 38 0d 04 01 00 | 00 00 08 04 25 00 00 00 |B$18....|....%...|
|00002860| 0a 04 23 00 00 00 09 04 | 00 00 00 00 0b 04 00 00 |..#.....|........|
|00002870| 00 00 16 04 02 00 00 00 | 18 04 00 00 00 00 22 04 |........|......".|
|00002880| 01 00 00 00 26 04 01 00 | 00 00 2a 04 15 00 00 00 |....&...|..*.....|
|00002890| 2b 04 04 00 00 00 00 09 | 03 01 05 53 41 4c 45 53 |+.......|...SALES|
|000028a0| 10 04 01 00 00 00 08 09 | 53 51 4c 24 53 41 4c 45 |........|SQL$SALE|
|000028b0| 53 0c 06 53 59 53 44 42 | 41 00 04 01 04 41 47 45 |S..SYSDB|A....AGE|
|000028c0| 44 02 06 52 44 42 24 33 | 31 0d 04 0c 00 00 00 08 |D..RDB$3|1.......|
|000028d0| 04 1b 00 00 00 0a 04 08 | 00 00 00 09 04 00 00 00 |........|........|
|000028e0| 00 0b 04 00 00 00 00 16 | 04 0d 00 00 00 18 04 00 |........|........|
|000028f0| 00 00 00 22 04 00 00 00 | 00 17 04 01 00 00 00 00 |..."....|........|
|00002900| 04 01 0b 44 41 54 45 5f | 4e 45 45 44 45 44 02 06 |...DATE_|NEEDED..|
|00002910| 52 44 42 24 32 36 0d 04 | 06 00 00 00 08 04 23 00 |RDB$26..|......#.|
|00002920| 00 00 0a 04 08 00 00 00 | 09 04 00 00 00 00 0b 04 |........|........|
|00002930| 00 00 00 00 16 04 07 00 | 00 00 18 04 00 00 00 00 |........|........|
|00002940| 22 04 01 00 00 00 00 04 | 01 09 53 48 49 50 5f 44 |".......|..SHIP_D|
|00002950| 41 54 45 02 06 52 44 42 | 24 32 35 0d 04 05 00 00 |ATE..RDB|$25.....|
|00002960| 00 08 04 23 00 00 00 0a | 04 08 00 00 00 09 04 00 |...#....|........|
|00002970| 00 00 00 0b 04 00 00 00 | 00 16 04 06 00 00 00 18 |........|........|
|00002980| 04 00 00 00 00 22 04 01 | 00 00 00 00 04 01 0a 4f |....."..|.......O|
|00002990| 52 44 45 52 5f 44 41 54 | 45 02 06 52 44 42 24 32 |RDER_DAT|E..RDB$2|
|000029a0| 34 0d 04 04 00 00 00 08 | 04 23 00 00 00 0a 04 08 |4.......|.#......|
|000029b0| 00 00 00 09 04 00 00 00 | 00 0b 04 00 00 00 00 16 |........|........|
|000029c0| 04 05 00 00 00 18 04 00 | 00 00 00 22 04 01 00 00 |........|..."....|
|000029d0| 00 26 04 01 00 00 00 0f | 04 0b 00 00 00 04 15 0f |.&......|........|
|000029e0| 7f 00 03 00 6e 6f 77 4c | 27 04 0e 00 00 00 44 45 |....nowL|'.....DE|
|000029f0| 46 41 55 4c 54 20 27 6e | 6f 77 27 00 00 04 01 09 |FAULT 'n|ow'.....|
|00002a00| 50 4f 5f 4e 55 4d 42 45 | 52 02 08 50 4f 4e 55 4d |PO_NUMBE|R..PONUM|
|00002a10| 42 45 52 0d 04 00 00 00 | 00 08 04 0e 00 00 00 0a |BER.....|........|
|00002a20| 04 08 00 00 00 09 04 00 | 00 00 00 0b 04 00 00 00 |........|........|
|00002a30| 00 16 04 01 00 00 00 18 | 04 00 00 00 00 22 04 01 |........|....."..|
|00002a40| 00 00 00 26 04 01 00 00 | 00 2a 04 15 00 00 00 00 |...&....|.*......|
|00002a50| 04 01 08 44 49 53 43 4f | 55 4e 54 02 06 52 44 42 |...DISCO|UNT..RDB|
|00002a60| 24 33 30 0d 04 0a 00 00 | 00 08 04 0a 00 00 00 0a |$30.....|........|
|00002a70| 04 04 00 00 00 09 04 00 | 00 00 00 0b 04 00 00 00 |........|........|
|00002a80| 00 16 04 0b 00 00 00 18 | 04 00 00 00 00 22 04 01 |........|....."..|
|00002a90| 00 00 00 26 04 01 00 00 | 00 0f 04 09 00 00 00 04 |...&....|........|
|00002aa0| 15 08 00 00 00 00 00 4c | 27 04 0a 00 00 00 44 45 |.......L|'.....DE|
|00002ab0| 46 41 55 4c 54 20 30 00 | 00 04 01 0b 54 4f 54 41 |FAULT 0.|....TOTA|
|00002ac0| 4c 5f 56 41 4c 55 45 02 | 06 52 44 42 24 32 39 0d |L_VALUE.|.RDB$29.|
|00002ad0| 04 09 00 00 00 08 04 08 | 00 00 00 0a 04 04 00 00 |........|........|
|00002ae0| 00 09 04 00 00 00 00 0b | 04 fe ff ff ff 16 04 0a |........|........|
|00002af0| 00 00 00 18 04 00 00 00 | 00 22 04 01 00 00 00 26 |........|.".....&|
|00002b00| 04 01 00 00 00 00 04 01 | 0b 51 54 59 5f 4f 52 44 |........|.QTY_ORD|
|00002b10| 45 52 45 44 02 06 52 44 | 42 24 32 38 0d 04 08 00 |ERED..RD|B$28....|
|00002b20| 00 00 08 04 08 00 00 00 | 0a 04 04 00 00 00 09 04 |........|........|
|00002b30| 00 00 00 00 0b 04 00 00 | 00 00 16 04 09 00 00 00 |........|........|
|00002b40| 18 04 00 00 00 00 22 04 | 01 00 00 00 26 04 01 00 |......".|....&...|
|00002b50| 00 00 0f 04 09 00 00 00 | 04 15 08 00 01 00 00 00 |........|........|
|00002b60| 4c 27 04 0a 00 00 00 44 | 45 46 41 55 4c 54 20 31 |L'.....D|EFAULT 1|
|00002b70| 00 00 04 01 07 43 55 53 | 54 5f 4e 4f 02 06 43 55 |.....CUS|T_NO..CU|
|00002b80| 53 54 4e 4f 0d 04 01 00 | 00 00 08 04 08 00 00 00 |STNO....|........|
|00002b90| 0a 04 04 00 00 00 09 04 | 00 00 00 00 0b 04 00 00 |........|........|
|00002ba0| 00 00 16 04 02 00 00 00 | 18 04 00 00 00 00 22 04 |........|......".|
|00002bb0| 01 00 00 00 26 04 01 00 | 00 00 00 04 01 09 49 54 |....&...|......IT|
|00002bc0| 45 4d 5f 54 59 50 45 02 | 08 50 52 4f 44 54 59 50 |EM_TYPE.|.PRODTYP|
|00002bd0| 45 0d 04 0b 00 00 00 08 | 04 25 00 00 00 0a 04 0c |E.......|.%......|
|00002be0| 00 00 00 09 04 00 00 00 | 00 0b 04 00 00 00 00 16 |........|........|
|00002bf0| 04 0c 00 00 00 18 04 00 | 00 00 00 22 04 01 00 00 |........|..."....|
|00002c00| 00 2a 04 15 00 00 00 00 | 04 01 09 53 41 4c 45 53 |.*......|...SALES|
|00002c10| 5f 52 45 50 02 05 45 4d | 50 4e 4f 0d 04 02 00 00 |_REP..EM|PNO.....|
|00002c20| 00 08 04 07 00 00 00 0a | 04 02 00 00 00 09 04 00 |........|........|
|00002c30| 00 00 00 0b 04 00 00 00 | 00 16 04 03 00 00 00 18 |........|........|
|00002c40| 04 00 00 00 00 22 04 01 | 00 00 00 00 04 01 04 50 |....."..|.......P|
|00002c50| 41 49 44 02 06 52 44 42 | 24 32 37 0d 04 07 00 00 |AID..RDB|$27.....|
|00002c60| 00 08 04 0e 00 00 00 0a | 04 01 00 00 00 09 04 00 |........|........|
|00002c70| 00 00 00 0b 04 00 00 00 | 00 16 04 08 00 00 00 18 |........|........|
|00002c80| 04 00 00 00 00 22 04 01 | 00 00 00 2a 04 15 00 00 |....."..|...*....|
|00002c90| 00 2b 04 00 00 00 00 0f | 04 09 00 00 00 04 15 0f |.+......|........|
|00002ca0| 7f 00 01 00 6e 4c 27 04 | 0c 00 00 00 44 45 46 41 |....nL'.|....DEFA|
|00002cb0| 55 4c 54 20 27 6e 27 00 | 00 04 01 0c 4f 52 44 45 |ULT 'n'.|....ORDE|
|00002cc0| 52 5f 53 54 41 54 55 53 | 02 06 52 44 42 24 32 33 |R_STATUS|..RDB$23|
|00002cd0| 0d 04 03 00 00 00 08 04 | 25 00 00 00 0a 04 07 00 |........|%.......|
|00002ce0| 00 00 09 04 00 00 00 00 | 0b 04 00 00 00 00 16 04 |........|........|
|00002cf0| 04 00 00 00 18 04 00 00 | 00 00 22 04 01 00 00 00 |........|..".....|
|00002d00| 26 04 01 00 00 00 2a 04 | 15 00 00 00 2b 04 00 00 |&.....*.|....+...|
|00002d10| 00 00 0f 04 0b 00 00 00 | 04 15 0f 7f 00 03 00 6e |........|.......n|
|00002d20| 65 77 4c 27 04 0e 00 00 | 00 44 45 46 41 55 4c 54 |ewL'....|.DEFAULT|
|00002d30| 20 27 6e 65 77 27 00 00 | 09 03 01 10 45 4d 50 4c | 'new'..|....EMPL|
|00002d40| 4f 59 45 45 5f 50 52 4f | 4a 45 43 54 10 04 01 00 |OYEE_PRO|JECT....|
|00002d50| 00 00 08 14 53 51 4c 24 | 45 4d 50 4c 4f 59 45 45 |....SQL$|EMPLOYEE|
|00002d60| 5f 50 52 4f 4a 45 43 54 | 0c 06 53 59 53 44 42 41 |_PROJECT|..SYSDBA|
|00002d70| 00 04 01 06 45 4d 50 5f | 4e 4f 02 05 45 4d 50 4e |....EMP_|NO..EMPN|
|00002d80| 4f 0d 04 00 00 00 00 08 | 04 07 00 00 00 0a 04 02 |O.......|........|
|00002d90| 00 00 00 09 04 00 00 00 | 00 0b 04 00 00 00 00 16 |........|........|
|00002da0| 04 01 00 00 00 18 04 00 | 00 00 00 22 04 01 00 00 |........|..."....|
|00002db0| 00 26 04 01 00 00 00 00 | 04 01 07 50 52 4f 4a 5f |.&......|...PROJ_|
|00002dc0| 49 44 02 06 50 52 4f 4a | 4e 4f 0d 04 01 00 00 00 |ID..PROJ|NO......|
|00002dd0| 08 04 0e 00 00 00 0a 04 | 05 00 00 00 09 04 00 00 |........|........|
|00002de0| 00 00 0b 04 00 00 00 00 | 16 04 02 00 00 00 18 04 |........|........|
|00002df0| 00 00 00 00 22 04 01 00 | 00 00 26 04 01 00 00 00 |...."...|..&.....|
|00002e00| 2a 04 02 00 00 00 00 09 | 03 01 10 50 52 4f 4a 5f |*.......|...PROJ_|
|00002e10| 44 45 50 54 5f 42 55 44 | 47 45 54 10 04 01 00 00 |DEPT_BUD|GET.....|
|00002e20| 00 08 14 53 51 4c 24 50 | 52 4f 4a 5f 44 45 50 54 |...SQL$P|ROJ_DEPT|
|00002e30| 5f 42 55 44 47 45 54 0c | 06 53 59 53 44 42 41 00 |_BUDGET.|.SYSDBA.|
|00002e40| 04 01 10 50 52 4f 4a 45 | 43 54 45 44 5f 42 55 44 |...PROJE|CTED_BUD|
|00002e50| 47 45 54 02 06 42 55 44 | 47 45 54 0d 04 04 00 00 |GET..BUD|GET.....|
|00002e60| 00 08 04 1b 00 00 00 0a | 04 08 00 00 00 09 04 00 |........|........|
|00002e70| 00 00 00 0b 04 fe ff ff | ff 16 04 05 00 00 00 18 |........|........|
|00002e80| 04 00 00 00 00 22 04 01 | 00 00 00 00 04 01 0e 51 |....."..|.......Q|
|00002e90| 55 41 52 54 5f 48 45 41 | 44 5f 43 4e 54 02 06 52 |UART_HEA|D_CNT..R|
|00002ea0| 44 42 24 31 33 0d 04 03 | 00 00 00 08 04 08 00 00 |DB$13...|........|
|00002eb0| 00 0a 04 04 00 00 00 09 | 04 00 00 00 00 0b 04 00 |........|........|
|00002ec0| 00 00 00 16 04 04 00 00 | 00 18 04 00 00 00 00 22 |........|......."|
|00002ed0| 04 01 00 00 00 1d 04 01 | 00 00 00 20 04 01 00 00 |........|... ....|
|00002ee0| 00 21 04 04 00 00 00 00 | 04 01 04 59 45 41 52 02 |.!......|...YEAR.|
|00002ef0| 06 52 44 42 24 31 32 0d | 04 00 00 00 00 08 04 08 |.RDB$12.|........|
|00002f00| 00 00 00 0a 04 04 00 00 | 00 09 04 00 00 00 00 0b |........|........|
|00002f10| 04 00 00 00 00 16 04 01 | 00 00 00 18 04 00 00 00 |........|........|
|00002f20| 00 22 04 01 00 00 00 26 | 04 01 00 00 00 00 04 01 |.".....&|........|
|00002f30| 07 44 45 50 54 5f 4e 4f | 02 06 44 45 50 54 4e 4f |.DEPT_NO|..DEPTNO|
|00002f40| 0d 04 02 00 00 00 08 04 | 0e 00 00 00 0a 04 03 00 |........|........|
|00002f50| 00 00 09 04 00 00 00 00 | 0b 04 00 00 00 00 16 04 |........|........|
|00002f60| 03 00 00 00 18 04 00 00 | 00 00 22 04 01 00 00 00 |........|..".....|
|00002f70| 26 04 01 00 00 00 2a 04 | 02 00 00 00 00 04 01 07 |&.....*.|........|
|00002f80| 50 52 4f 4a 5f 49 44 02 | 06 50 52 4f 4a 4e 4f 0d |PROJ_ID.|.PROJNO.|
|00002f90| 04 01 00 00 00 08 04 0e | 00 00 00 0a 04 05 00 00 |........|........|
|00002fa0| 00 09 04 00 00 00 00 0b | 04 00 00 00 00 16 04 02 |........|........|
|00002fb0| 00 00 00 18 04 00 00 00 | 00 22 04 01 00 00 00 26 |........|.".....&|
|00002fc0| 04 01 00 00 00 2a 04 02 | 00 00 00 00 09 03 01 0e |.....*..|........|
|00002fd0| 53 41 4c 41 52 59 5f 48 | 49 53 54 4f 52 59 10 04 |SALARY_H|ISTORY..|
|00002fe0| 01 00 00 00 08 12 53 51 | 4c 24 53 41 4c 41 52 59 |......SQ|L$SALARY|
|00002ff0| 5f 48 49 53 54 4f 52 59 | 0c 06 53 59 53 44 42 41 |_HISTORY|..SYSDBA|
|00003000| 00 04 01 0a 4e 45 57 5f | 53 41 4c 41 52 59 02 06 |....NEW_|SALARY..|
|00003010| 52 44 42 24 31 37 0d 04 | 05 00 00 00 08 04 1b 00 |RDB$17..|........|
|00003020| 00 00 0a 04 08 00 00 00 | 09 04 00 00 00 00 0b 04 |........|........|
|00003030| 00 00 00 00 16 04 06 00 | 00 00 18 04 00 00 00 00 |........|........|
|00003040| 22 04 00 00 00 00 17 04 | 01 00 00 00 00 04 01 0e |".......|........|
|00003050| 50 45 52 43 45 4e 54 5f | 43 48 41 4e 47 45 02 06 |PERCENT_|CHANGE..|
|00003060| 52 44 42 24 31 36 0d 04 | 04 00 00 00 08 04 1b 00 |RDB$16..|........|
|00003070| 00 00 0a 04 08 00 00 00 | 09 04 00 00 00 00 0b 04 |........|........|
|00003080| 00 00 00 00 16 04 05 00 | 00 00 18 04 00 00 00 00 |........|........|
|00003090| 22 04 01 00 00 00 26 04 | 01 00 00 00 0f 04 09 00 |".....&.|........|
|000030a0| 00 00 04 15 08 00 00 00 | 00 00 4c 27 04 0a 00 00 |........|..L'....|
|000030b0| 00 44 45 46 41 55 4c 54 | 20 30 00 00 04 01 0a 4f |.DEFAULT| 0.....O|
|000030c0| 4c 44 5f 53 41 4c 41 52 | 59 02 06 53 41 4c 41 52 |LD_SALAR|Y..SALAR|
|000030d0| 59 0d 04 03 00 00 00 08 | 04 1b 00 00 00 0a 04 08 |Y.......|........|
|000030e0| 00 00 00 09 04 00 00 00 | 00 0b 04 fe ff ff ff 16 |........|........|
|000030f0| 04 04 00 00 00 18 04 00 | 00 00 00 22 04 01 00 00 |........|..."....|
|00003100| 00 26 04 01 00 00 00 00 | 04 01 0b 43 48 41 4e 47 |.&......|...CHANG|
|00003110| 45 5f 44 41 54 45 02 06 | 52 44 42 24 31 34 0d 04 |E_DATE..|RDB$14..|
|00003120| 01 00 00 00 08 04 23 00 | 00 00 0a 04 08 00 00 00 |......#.|........|
|00003130| 09 04 00 00 00 00 0b 04 | 00 00 00 00 16 04 02 00 |........|........|
|00003140| 00 00 18 04 00 00 00 00 | 22 04 01 00 00 00 26 04 |........|".....&.|
|00003150| 01 00 00 00 0f 04 0b 00 | 00 00 04 15 0f 7f 00 03 |........|........|
|00003160| 00 4e 4f 57 4c 27 04 0e | 00 00 00 44 45 46 41 55 |.NOWL'..|...DEFAU|
|00003170| 4c 54 20 27 4e 4f 57 27 | 00 00 04 01 0a 55 50 44 |LT 'NOW'|.....UPD|
|00003180| 41 54 45 52 5f 49 44 02 | 06 52 44 42 24 31 35 0d |ATER_ID.|.RDB$15.|
|00003190| 04 02 00 00 00 08 04 25 | 00 00 00 0a 04 14 00 00 |.......%|........|
|000031a0| 00 09 04 00 00 00 00 0b | 04 00 00 00 00 16 04 03 |........|........|
|000031b0| 00 00 00 18 04 00 00 00 | 00 22 04 01 00 00 00 26 |........|.".....&|
|000031c0| 04 01 00 00 00 2a 04 15 | 00 00 00 2b 04 00 00 00 |.....*..|...+....|
|000031d0| 00 00 04 01 06 45 4d 50 | 5f 4e 4f 02 05 45 4d 50 |.....EMP|_NO..EMP|
|000031e0| 4e 4f 0d 04 00 00 00 00 | 08 04 07 00 00 00 0a 04 |NO......|........|
|000031f0| 02 00 00 00 09 04 00 00 | 00 00 0b 04 00 00 00 00 |........|........|
|00003200| 16 04 01 00 00 00 18 04 | 00 00 00 00 22 04 01 00 |........|...."...|
|00003210| 00 00 26 04 01 00 00 00 | 00 09 1a 01 0a 45 4d 50 |..&.....|.....EMP|
|00003220| 5f 4e 4f 5f 47 45 4e 02 | 04 91 00 00 00 00 1a 01 |_NO_GEN.|........|
|00003230| 0b 43 55 53 54 5f 4e 4f | 5f 47 45 4e 02 04 f7 03 |.CUST_NO|_GEN....|
|00003240| 00 00 00 1b 01 0c 47 45 | 54 5f 45 4d 50 5f 50 52 |......GE|T_EMP_PR|
|00003250| 4f 4a 02 04 01 00 00 00 | 03 04 01 00 00 00 07 04 |OJ......|........|
|00003260| 6f 00 00 00 0a 42 45 47 | 49 4e 0a 20 46 4f 52 20 |o....BEG|IN. FOR |
|00003270| 53 45 4c 45 43 54 20 70 | 72 6f 6a 5f 69 64 0a 20 |SELECT p|roj_id. |
|00003280| 20 46 52 4f 4d 20 65 6d | 70 6c 6f 79 65 65 5f 70 | FROM em|ployee_p|
|00003290| 72 6f 6a 65 63 74 0a 20 | 20 57 48 45 52 45 20 65 |roject. | WHERE e|
|000032a0| 6d 70 5f 6e 6f 20 3d 20 | 3a 65 6d 70 5f 6e 6f 0a |mp_no = |:emp_no.|
|000032b0| 20 20 49 4e 54 4f 20 3a | 70 72 6f 6a 5f 69 64 0a |  INTO :|proj_id.|
|000032c0| 20 44 4f 0a 20 20 53 55 | 53 50 45 4e 44 3b 0a 45 | DO.  SU|SPEND;.E|
|000032d0| 4e 44 00 08 04 9c 00 00 | 00 04 02 04 00 02 00 07 |ND......|........|
|000032e0| 00 07 00 04 01 03 00 0f | 15 00 05 00 07 00 07 00 |........|........|
|000032f0| 0c 00 02 03 00 00 0f 15 | 00 05 00 01 2d 1a 00 00 |........|....-...|
|00003300| 9b 11 00 02 02 07 43 01 | 4a 10 45 4d 50 4c 4f 59 |......C.|J.EMPLOY|
|00003310| 45 45 5f 50 52 4f 4a 45 | 43 54 00 47 2f 17 00 06 |EE_PROJE|CT.G/...|
|00003320| 45 4d 50 5f 4e 4f 29 00 | 00 00 01 00 ff 02 01 17 |EMP_NO).|........|
|00003330| 00 07 50 52 4f 4a 5f 49 | 44 1a 00 00 02 0e 01 02 |..PROJ_I|D.......|
|00003340| 01 1a 00 00 29 01 00 00 | 01 00 01 15 07 00 01 00 |....)...|........|
|00003350| 19 01 02 00 ff 9b ff ff | ff ff ff 0e 01 02 01 1a |........|........|
|00003360| 00 00 29 01 00 00 01 00 | 01 15 07 00 00 00 19 01 |..).....|........|
|00003370| 02 00 ff ff 4c 09 10 53 | 51 4c 24 47 45 54 5f 45 |....L..S|QL$GET_E|
|00003380| 4d 50 5f 50 52 4f 4a 0a | 06 53 59 53 44 42 41 00 |MP_PROJ.|.SYSDBA.|
|00003390| 1c 01 06 45 4d 50 5f 4e | 4f 02 04 00 00 00 00 03 |...EMP_N|O.......|
|000033a0| 04 00 00 00 00 04 06 52 | 44 42 24 33 32 00 1c 01 |.......R|DB$32...|
|000033b0| 07 50 52 4f 4a 5f 49 44 | 02 04 00 00 00 00 03 04 |.PROJ_ID|........|
|000033c0| 01 00 00 00 04 06 52 44 | 42 24 33 33 00 1d 1b 01 |......RD|B$33....|
|000033d0| 0c 41 44 44 5f 45 4d 50 | 5f 50 52 4f 4a 02 04 02 |.ADD_EMP|_PROJ...|
|000033e0| 00 00 00 03 04 00 00 00 | 00 07 04 9f 00 00 00 0a |........|........|
|000033f0| 42 45 47 49 4e 0a 20 42 | 45 47 49 4e 0a 20 49 4e |BEGIN. B|EGIN. IN|
|00003400| 53 45 52 54 20 49 4e 54 | 4f 20 65 6d 70 6c 6f 79 |SERT INT|O employ|
|00003410| 65 65 5f 70 72 6f 6a 65 | 63 74 20 28 65 6d 70 5f |ee_proje|ct (emp_|
|00003420| 6e 6f 2c 20 70 72 6f 6a | 5f 69 64 29 20 56 41 4c |no, proj|_id) VAL|
|00003430| 55 45 53 20 28 3a 65 6d | 70 5f 6e 6f 2c 20 3a 70 |UES (:em|p_no, :p|
|00003440| 72 6f 6a 5f 69 64 29 3b | 0a 20 57 48 45 4e 20 53 |roj_id);|. WHEN S|
|00003450| 51 4c 43 4f 44 45 20 2d | 35 33 30 20 44 4f 0a 20 |QLCODE -|530 DO. |
|00003460| 20 45 58 43 45 50 54 49 | 4f 4e 20 75 6e 6b 6e 6f | EXCEPTI|ON unkno|
|00003470| 77 6e 5f 65 6d 70 5f 69 | 64 3b 0a 20 45 4e 44 0a |wn_emp_i|d;. END.|
|00003480| 20 53 55 53 50 45 4e 44 | 3b 0a 45 4e 44 00 08 04 | SUSPEND|;.END...|
|00003490| 9d 00 00 00 04 02 04 00 | 04 00 07 00 07 00 0f 15 |........|........|
|000034a0| 00 05 00 07 00 04 01 01 | 00 07 00 0c 00 02 9b 11 |........|........|
|000034b0| 00 02 02 81 02 02 86 0f | 4a 10 45 4d 50 4c 4f 59 |........|J.EMPLOY|
|000034c0| 45 45 5f 50 52 4f 4a 45 | 43 54 00 02 01 29 00 00 |EE_PROJE|CT...)..|
|000034d0| 00 01 00 17 00 06 45 4d | 50 5f 4e 4f 01 29 00 02 |......EM|P_NO.)..|
|000034e0| 00 03 00 17 00 07 50 52 | 4f 4a 5f 49 44 ff 87 ff |......PR|OJ_ID...|
|000034f0| ff 82 01 00 01 ee fd 02 | 86 80 02 0e 55 4e 4b 4e |........|....UNKN|
|00003500| 4f 57 4e 5f 45 4d 50 5f | 49 44 87 ff ff 02 0e 01 |OWN_EMP_|ID......|
|00003510| 02 01 15 07 00 01 00 19 | 01 00 00 ff 9b ff ff ff |........|........|
|00003520| ff 0e 01 02 01 15 07 00 | 00 00 19 01 00 00 ff ff |........|........|
|00003530| 4c 09 10 53 51 4c 24 41 | 44 44 5f 45 4d 50 5f 50 |L..SQL$A|DD_EMP_P|
|00003540| 52 4f 4a 0a 06 53 59 53 | 44 42 41 00 1c 01 06 45 |ROJ..SYS|DBA....E|
|00003550| 4d 50 5f 4e 4f 02 04 00 | 00 00 00 03 04 00 00 00 |MP_NO...|........|
|00003560| 00 04 06 52 44 42 24 33 | 34 00 1c 01 07 50 52 4f |...RDB$3|4....PRO|
|00003570| 4a 5f 49 44 02 04 01 00 | 00 00 03 04 00 00 00 00 |J_ID....|........|
|00003580| 04 06 52 44 42 24 33 35 | 00 1d 1b 01 0e 53 55 42 |..RDB$35|.....SUB|
|00003590| 5f 54 4f 54 5f 42 55 44 | 47 45 54 02 04 01 00 00 |_TOT_BUD|GET.....|
|000035a0| 00 03 04 04 00 00 00 07 | 04 bc 00 00 00 0a 42 45 |........|......BE|
|000035b0| 47 49 4e 0a 20 53 45 4c | 45 43 54 20 53 55 4d 28 |GIN. SEL|ECT SUM(|
|000035c0| 62 75 64 67 65 74 29 2c | 20 41 56 47 28 62 75 64 |budget),| AVG(bud|
|000035d0| 67 65 74 29 2c 20 4d 49 | 4e 28 62 75 64 67 65 74 |get), MI|N(budget|
|000035e0| 29 2c 20 4d 41 58 28 62 | 75 64 67 65 74 29 0a 20 |), MAX(b|udget). |
|000035f0| 20 46 52 4f 4d 20 64 65 | 70 61 72 74 6d 65 6e 74 | FROM de|partment|
|00003600| 0a 20 20 57 48 45 52 45 | 20 68 65 61 64 5f 64 65 |.  WHERE| head_de|
|00003610| 70 74 20 3d 20 3a 68 65 | 61 64 5f 64 65 70 74 0a |pt = :he|ad_dept.|
|00003620| 20 20 49 4e 54 4f 20 3a | 74 6f 74 5f 62 75 64 67 |  INTO :|tot_budg|
|00003630| 65 74 2c 20 3a 61 76 67 | 5f 62 75 64 67 65 74 2c |et, :avg|_budget,|
|00003640| 20 3a 6d 69 6e 5f 62 75 | 64 67 65 74 2c 20 3a 6d | :min_bu|dget, :m|
|00003650| 61 78 5f 62 75 64 67 65 | 74 3b 0a 20 53 55 53 50 |ax_budge|t;. SUSP|
|00003660| 45 4e 44 3b 0a 45 4e 44 | 00 08 04 41 01 00 00 04 |END;.END|...A....|
|00003670| 02 04 00 02 00 0f 15 00 | 03 00 07 00 04 01 09 00 |........|........|
|00003680| 1b 07 00 1b 07 00 1b 07 | 00 1b 07 00 07 00 0c 00 |........|........|
|00003690| 02 03 00 00 1b 01 2d 1a | 00 00 03 01 00 1b 01 2d |......-.|.......-|
|000036a0| 1a 01 00 03 02 00 1b 01 | 2d 1a 02 00 03 03 00 1b |........|-.......|
|000036b0| 01 2d 1a 03 00 9b 11 00 | 02 02 07 7f 43 01 4f 01 |.-......|....C.O.|
|000036c0| 43 01 4a 0a 44 45 50 41 | 52 54 4d 45 4e 54 00 47 |C.J.DEPA|RTMENT.G|
|000036d0| 2f 17 00 09 48 45 41 44 | 5f 44 45 50 54 29 00 00 |/...HEAD|_DEPT)..|
|000036e0| 00 01 00 ff 4e 00 4d 04 | 00 00 00 54 17 00 06 42 |....N.M.|...T...B|
|000036f0| 55 44 47 45 54 01 00 55 | 17 00 06 42 55 44 47 45 |UDGET..U|...BUDGE|
|00003700| 54 02 00 57 17 00 06 42 | 55 44 47 45 54 03 00 56 |T..W...B|UDGET..V|
|00003710| 17 00 06 42 55 44 47 45 | 54 ff 02 01 18 01 03 00 |...BUDGE|T.......|
|00003720| 1a 00 00 01 18 01 02 00 | 1a 01 00 01 18 01 01 00 |........|........|
|00003730| 1a 02 00 01 18 01 00 00 | 1a 03 00 ff 02 0e 01 02 |........|........|
|00003740| 01 1a 00 00 29 01 00 00 | 01 00 01 1a 01 00 29 01 |....)...|......).|
|00003750| 02 00 03 00 01 1a 02 00 | 29 01 04 00 05 00 01 1a |........|).......|
|00003760| 03 00 29 01 06 00 07 00 | 01 15 07 00 01 00 19 01 |..).....|........|
|00003770| 08 00 ff 9b ff ff ff ff | 0e 01 02 01 1a 00 00 29 |........|.......)|
|00003780| 01 00 00 01 00 01 1a 01 | 00 29 01 02 00 03 00 01 |........|.)......|
|00003790| 1a 02 00 29 01 04 00 05 | 00 01 1a 03 00 29 01 06 |...)....|.....)..|
|000037a0| 00 07 00 01 15 07 00 00 | 00 19 01 08 00 ff ff 4c |........|.......L|
|000037b0| 09 12 53 51 4c 24 53 55 | 42 5f 54 4f 54 5f 42 55 |..SQL$SU|B_TOT_BU|
|000037c0| 44 47 45 54 0a 06 53 59 | 53 44 42 41 00 1c 01 09 |DGET..SY|SDBA....|
|000037d0| 48 45 41 44 5f 44 45 50 | 54 02 04 00 00 00 00 03 |HEAD_DEP|T.......|
|000037e0| 04 00 00 00 00 04 06 52 | 44 42 24 33 36 00 1c 01 |.......R|DB$36...|
|000037f0| 0a 54 4f 54 5f 42 55 44 | 47 45 54 02 04 00 00 00 |.TOT_BUD|GET.....|
|00003800| 00 03 04 01 00 00 00 04 | 06 52 44 42 24 33 37 00 |........|.RDB$37.|
|00003810| 1c 01 0a 41 56 47 5f 42 | 55 44 47 45 54 02 04 01 |...AVG_B|UDGET...|
|00003820| 00 00 00 03 04 01 00 00 | 00 04 06 52 44 42 24 33 |........|...RDB$3|
|00003830| 38 00 1c 01 0a 4d 49 4e | 5f 42 55 44 47 45 54 02 |8....MIN|_BUDGET.|
|00003840| 04 02 00 00 00 03 04 01 | 00 00 00 04 06 52 44 42 |........|.....RDB|
|00003850| 24 33 39 00 1c 01 0a 4d | 41 58 5f 42 55 44 47 45 |$39....M|AX_BUDGE|
|00003860| 54 02 04 03 00 00 00 03 | 04 01 00 00 00 04 06 52 |T.......|.......R|
|00003870| 44 42 24 34 30 00 1d 1b | 01 0f 44 45 4c 45 54 45 |DB$40...|..DELETE|
|00003880| 5f 45 4d 50 4c 4f 59 45 | 45 02 04 01 00 00 00 03 |_EMPLOYE|E.......|
|00003890| 04 00 00 00 00 07 04 cc | 03 00 00 0a 20 44 45 43 |........|.... DEC|
|000038a0| 4c 41 52 45 20 56 41 52 | 49 41 42 4c 45 20 61 6e |LARE VAR|IABLE an|
|000038b0| 79 5f 73 61 6c 65 73 20 | 49 4e 54 45 47 45 52 3b |y_sales |INTEGER;|
|000038c0| 0a 42 45 47 49 4e 0a 20 | 61 6e 79 5f 73 61 6c 65 |.BEGIN. |any_sale|
|000038d0| 73 20 3d 20 30 3b 0a 0a | 20 2f 2a 0a 20 20 2a 20 |s = 0;..| /*.  * |
|000038e0| 49 66 20 74 68 65 72 65 | 20 61 72 65 20 61 6e 79 |If there| are any|
|000038f0| 20 73 61 6c 65 73 20 72 | 65 63 6f 72 64 73 20 72 | sales r|ecords r|
|00003900| 65 66 65 72 65 6e 63 69 | 6e 67 20 74 68 69 73 20 |eferenci|ng this |
|00003910| 65 6d 70 6c 6f 79 65 65 | 2c 0a 20 20 2a 20 63 61 |employee|,.  * ca|
|00003920| 6e 27 74 20 64 65 6c 65 | 74 65 20 74 68 65 20 65 |n't dele|te the e|
|00003930| 6d 70 6c 6f 79 65 65 20 | 75 6e 74 69 6c 20 74 68 |mployee |until th|
|00003940| 65 20 73 61 6c 65 73 20 | 61 72 65 20 72 65 2d 61 |e sales |are re-a|
|00003950| 73 73 69 67 6e 65 64 0a | 20 20 2a 20 74 6f 20 61 |ssigned.|  * to a|
|00003960| 6e 6f 74 68 65 72 20 65 | 6d 70 6c 6f 79 65 65 20 |nother e|mployee |
|00003970| 6f 72 20 63 68 61 6e 67 | 65 64 20 74 6f 20 4e 55 |or chang|ed to NU|
|00003980| 4c 4c 2e 0a 20 20 2a 2f | 0a 20 53 45 4c 45 43 54 |LL..  */|. SELECT|
|00003990| 20 63 6f 75 6e 74 28 70 | 6f 5f 6e 75 6d 62 65 72 | count(p|o_number|
|000039a0| 29 0a 20 46 52 4f 4d 20 | 73 61 6c 65 73 0a 20 57 |). FROM |sales. W|
|000039b0| 48 45 52 45 20 73 61 6c | 65 73 5f 72 65 70 20 3d |HERE sal|es_rep =|
|000039c0| 20 3a 65 6d 70 5f 6e 75 | 6d 0a 20 49 4e 54 4f 20 | :emp_nu|m. INTO |
|000039d0| 3a 61 6e 79 5f 73 61 6c | 65 73 3b 0a 0a 20 49 46 |:any_sal|es;.. IF|
|000039e0| 20 28 61 6e 79 5f 73 61 | 6c 65 73 20 3e 20 30 29 | (any_sa|les > 0)|
|000039f0| 20 54 48 45 4e 0a 20 42 | 45 47 49 4e 0a 20 20 45 | THEN. B|EGIN.  E|
|00003a00| 58 43 45 50 54 49 4f 4e | 20 72 65 61 73 73 69 67 |XCEPTION| reassig|
|00003a10| 6e 5f 73 61 6c 65 73 3b | 0a 20 20 53 55 53 50 45 |n_sales;|.  SUSPE|
|00003a20| 4e 44 3b 0a 20 45 4e 44 | 0a 0a 20 2f 2a 0a 20 20 |ND;. END|.. /*.  |
|00003a30| 2a 20 49 66 20 74 68 65 | 20 65 6d 70 6c 6f 79 65 |* If the| employe|
|00003a40| 65 20 69 73 20 61 20 6d | 61 6e 61 67 65 72 2c 20 |e is a m|anager, |
|00003a50| 75 70 64 61 74 65 20 74 | 68 65 20 64 65 70 61 72 |update t|he depar|
|00003a60| 74 6d 65 6e 74 2e 0a 20 | 20 2a 2f 0a 20 55 50 44 |tment.. | */. UPD|
|00003a70| 41 54 45 20 64 65 70 61 | 72 74 6d 65 6e 74 0a 20 |ATE depa|rtment. |
|00003a80| 53 45 54 20 6d 6e 67 72 | 5f 6e 6f 20 3d 20 4e 55 |SET mngr|_no = NU|
|00003a90| 4c 4c 0a 20 57 48 45 52 | 45 20 6d 00 6e 67 72 5f |LL. WHER|E m.ngr_|
|00003aa0| 6e 6f 20 3d 20 3a 65 6d | 70 5f 6e 75 6d 3b 0a 0a |no = :em|p_num;..|
|00003ab0| 20 2f 2a 0a 20 20 2a 20 | 49 66 20 74 68 65 20 65 | /*.  * |If the e|
|00003ac0| 6d 70 6c 6f 79 65 65 20 | 69 73 20 61 20 70 72 6f |mployee |is a pro|
|00003ad0| 6a 65 63 74 20 6c 65 61 | 64 65 72 2c 20 75 70 64 |ject lea|der, upd|
|00003ae0| 61 74 65 20 70 72 6f 6a | 65 63 74 2e 0a 20 20 2a |ate proj|ect..  *|
|00003af0| 2f 0a 20 55 50 44 41 54 | 45 20 70 72 6f 6a 65 63 |/. UPDAT|E projec|
|00003b00| 74 0a 20 53 45 54 20 74 | 65 61 6d 5f 6c 65 61 64 |t. SET t|eam_lead|
|00003b10| 65 72 20 3d 20 4e 55 4c | 4c 0a 20 57 48 45 52 45 |er = NUL|L. WHERE|
|00003b20| 20 74 65 61 6d 5f 6c 65 | 61 64 65 72 20 3d 20 3a | team_le|ader = :|
|00003b30| 65 6d 70 5f 6e 75 6d 3b | 0a 0a 20 2f 2a 0a 20 20 |emp_num;|.. /*.  |
|00003b40| 2a 20 44 65 6c 65 74 65 | 20 74 68 65 20 65 6d 70 |* Delete| the emp|
|00003b50| 6c 6f 79 65 65 20 66 72 | 6f 6d 20 61 6e 79 20 70 |loyee fr|om any p|
|00003b60| 72 6f 6a 65 63 74 73 2e | 0a 20 20 2a 2f 0a 20 44 |rojects.|.  */. D|
|00003b70| 45 4c 45 54 45 20 46 52 | 4f 4d 20 65 6d 70 6c 6f |ELETE FR|OM emplo|
|00003b80| 79 65 65 5f 70 72 6f 6a | 65 63 74 0a 20 57 48 45 |yee_proj|ect. WHE|
|00003b90| 52 45 20 65 6d 70 5f 6e | 6f 20 3d 20 3a 65 6d 70 |RE emp_n|o = :emp|
|00003ba0| 5f 6e 75 6d 3b 0a 0a 20 | 2f 2a 0a 20 20 2a 20 44 |_num;.. |/*.  * D|
|00003bb0| 65 6c 65 74 65 20 6f 6c | 64 20 73 61 6c 61 72 79 |elete ol|d salary|
|00003bc0| 20 72 65 63 6f 72 64 73 | 2e 0a 20 20 2a 2f 0a 20 | records|..  */. |
|00003bd0| 44 45 4c 45 54 45 20 46 | 52 4f 4d 20 73 61 6c 61 |DELETE F|ROM sala|
|00003be0| 72 79 5f 68 69 73 74 6f | 72 79 0a 20 57 48 45 52 |ry_histo|ry. WHER|
|00003bf0| 45 20 65 6d 70 5f 6e 6f | 20 3d 20 3a 65 6d 70 5f |E emp_no| = :emp_|
|00003c00| 6e 75 6d 3b 0a 0a 20 2f | 2a 0a 20 20 2a 20 44 65 |num;.. /|*.  * De|
|00003c10| 6c 65 74 65 20 74 68 65 | 20 65 6d 70 6c 6f 79 65 |lete the| employe|
|00003c20| 65 2e 0a 20 20 2a 2f 0a | 20 44 45 4c 45 54 45 20 |e..  */.| DELETE |
|00003c30| 46 52 4f 4d 20 65 6d 70 | 6c 6f 79 65 65 0a 20 57 |FROM emp|loyee. W|
|00003c40| 48 45 52 45 20 65 6d 70 | 5f 6e 6f 20 3d 20 3a 65 |HERE emp|_no = :e|
|00003c50| 6d 70 5f 6e 75 6d 3b 0a | 0a 20 53 55 53 50 45 4e |mp_num;.|. SUSPEN|
|00003c60| 44 3b 0a 45 4e 44 00 08 | 04 a9 01 00 00 04 02 04 |D;.END..|........|
|00003c70| 00 02 00 08 00 07 00 04 | 01 01 00 07 00 0c 00 02 |........|........|
|00003c80| 03 00 00 08 00 01 2d 1a | 00 00 9b 11 00 02 02 01 |......-.|........|
|00003c90| 15 08 00 00 00 00 00 1a | 00 00 07 7f 43 01 4f 01 |........|....C.O.|
|00003ca0| 43 01 4a 05 53 41 4c 45 | 53 00 47 2f 17 00 09 53 |C.J.SALE|S.G/...S|
|00003cb0| 41 4c 45 53 5f 52 45 50 | 29 00 00 00 01 00 ff 4e |ALES_REP|)......N|
|00003cc0| 00 4d 01 00 00 00 5d 17 | 00 09 50 4f 5f 4e 55 4d |.M....].|..PO_NUM|
|00003cd0| 42 45 52 ff 02 01 18 01 | 00 00 1a 00 00 ff 08 31 |BER.....|.......1|
|00003ce0| 1a 00 00 15 08 00 00 00 | 00 00 02 02 80 02 0e 52 |........|.......R|
|00003cf0| 45 41 53 53 49 47 4e 5f | 53 41 4c 45 53 02 0e 01 |EASSIGN_|SALES...|
|00003d00| 02 01 15 07 00 01 00 19 | 01 00 00 ff 9b ff ff ff |........|........|
|00003d10| ff 07 43 01 4a 0a 44 45 | 50 41 52 54 4d 45 4e 54 |..C.J.DE|PARTMENT|
|00003d20| 02 47 2f 17 02 07 4d 4e | 47 52 5f 4e 4f 29 00 00 |.G/...MN|GR_NO)..|
|00003d30| 00 01 00 ff 0a 02 02 02 | 01 2d 17 02 07 4d 4e 47 |........|.-...MNG|
|00003d40| 52 5f 4e 4f ff 07 43 01 | 4a 07 50 52 4f 4a 45 43 |R_NO..C.|J.PROJEC|
|00003d50| 54 03 47 2f 17 03 0b 54 | 45 41 4d 5f 4c 45 41 44 |T.G/...T|EAM_LEAD|
|00003d60| 45 52 29 00 00 00 01 00 | ff 0a 03 03 02 01 2d 17 |ER).....|......-.|
|00003d70| 03 0b 54 45 41 4d 5f 4c | 45 41 44 45 52 ff 07 43 |..TEAM_L|EADER..C|
|00003d80| 01 4a 10 45 4d 50 4c 4f | 59 45 45 5f 50 52 4f 4a |.J.EMPLO|YEE_PROJ|
|00003d90| 45 43 54 04 47 2f 17 04 | 06 45 4d 50 5f 4e 4f 29 |ECT.G/..|.EMP_NO)|
|00003da0| 00 00 00 01 00 ff 05 04 | 07 43 01 4a 0e 53 41 4c |........|.C.J.SAL|
|00003db0| 41 52 59 5f 48 49 53 54 | 4f 52 59 05 47 2f 17 05 |ARY_HIST|ORY.G/..|
|00003dc0| 06 45 4d 50 5f 4e 4f 29 | 00 00 00 01 00 ff 05 05 |.EMP_NO)|........|
|00003dd0| 07 43 01 4a 08 45 4d 50 | 4c 4f 59 45 45 06 47 2f |.C.J.EMP|LOYEE.G/|
|00003de0| 17 06 06 45 4d 50 5f 4e | 4f 29 00 00 00 01 00 ff |...EMP_N|O)......|
|00003df0| 05 06 02 0e 01 02 01 15 | 07 00 01 00 19 01 00 00 |........|........|
|00003e00| ff 9b ff ff ff ff 0e 01 | 02 01 15 07 00 00 00 19 |........|........|
|00003e10| 01 00 00 ff ff 4c 09 13 | 53 51 4c 24 44 45 4c 45 |.....L..|SQL$DELE|
|00003e20| 54 45 5f 45 4d 50 4c 4f | 59 45 45 0a 06 53 59 53 |TE_EMPLO|YEE..SYS|
|00003e30| 44 42 41 00 1c 01 07 45 | 4d 50 5f 4e 55 4d 02 04 |DBA....E|MP_NUM..|
|00003e40| 00 00 00 00 03 04 00 00 | 00 00 04 06 52 44 42 24 |........|....RDB$|
|00003e50| 34 31 00 1d 1b 01 0b 44 | 45 50 54 5f 42 55 44 47 |41.....D|EPT_BUDG|
|00003e60| 45 54 02 04 01 00 00 00 | 03 04 01 00 00 00 07 04 |ET......|........|
|00003e70| e1 01 00 00 0a 20 44 45 | 43 4c 41 52 45 20 56 41 |..... DE|CLARE VA|
|00003e80| 52 49 41 42 4c 45 20 73 | 75 6d 62 20 44 45 43 49 |RIABLE s|umb DECI|
|00003e90| 4d 41 4c 28 31 32 2c 20 | 32 29 3b 0a 20 44 45 43 |MAL(12, |2);. DEC|
|00003ea0| 4c 41 52 45 20 56 41 52 | 49 41 42 4c 45 20 72 64 |LARE VAR|IABLE rd|
|00003eb0| 6e 6f 20 43 48 41 52 28 | 33 29 3b 0a 20 44 45 43 |no CHAR(|3);. DEC|
|00003ec0| 4c 41 52 45 20 56 41 52 | 49 41 42 4c 45 20 63 6e |LARE VAR|IABLE cn|
|00003ed0| 74 20 49 4e 54 45 47 45 | 52 3b 0a 42 45 47 49 4e |t INTEGE|R;.BEGIN|
|00003ee0| 0a 20 74 6f 74 20 3d 20 | 30 3b 0a 0a 20 53 45 4c |. tot = |0;.. SEL|
|00003ef0| 45 43 54 20 62 75 64 67 | 65 74 20 46 52 4f 4d 20 |ECT budg|et FROM |
|00003f00| 64 65 70 61 72 74 6d 65 | 6e 74 20 57 48 45 52 45 |departme|nt WHERE|
|00003f10| 20 64 65 70 74 5f 6e 6f | 20 3d 20 3a 64 6e 6f 20 | dept_no| = :dno |
|00003f20| 49 4e 54 4f 20 3a 74 6f | 74 3b 0a 0a 20 53 45 4c |INTO :to|t;.. SEL|
|00003f30| 45 43 54 20 63 6f 75 6e | 74 28 62 75 64 67 65 74 |ECT coun|t(budget|
|00003f40| 29 20 46 52 4f 4d 20 64 | 65 70 61 72 74 6d 65 6e |) FROM d|epartmen|
|00003f50| 74 20 57 48 45 52 45 20 | 68 65 61 64 5f 64 65 70 |t WHERE |head_dep|
|00003f60| 74 20 3d 20 3a 64 6e 6f | 20 49 4e 54 4f 20 3a 63 |t = :dno| INTO :c|
|00003f70| 6e 74 3b 0a 0a 20 49 46 | 20 28 63 6e 74 20 3d 20 |nt;.. IF| (cnt = |
|00003f80| 30 29 20 54 48 45 4e 0a | 20 20 53 55 53 50 45 4e |0) THEN.|  SUSPEN|
|00003f90| 44 3b 0a 0a 20 46 4f 52 | 20 53 45 4c 45 43 54 20 |D;.. FOR| SELECT |
|00003fa0| 64 65 70 74 5f 6e 6f 0a | 20 20 46 52 4f 4d 20 64 |dept_no.|  FROM d|
|00003fb0| 65 70 61 72 74 6d 65 6e | 74 0a 20 20 57 48 45 52 |epartmen|t.  WHER|
|00003fc0| 45 20 68 65 61 64 5f 64 | 65 70 74 20 3d 20 3a 64 |E head_d|ept = :d|
|00003fd0| 6e 6f 0a 20 20 49 4e 54 | 4f 20 3a 72 64 6e 6f 0a |no.  INT|O :rdno.|
|00003fe0| 20 44 4f 0a 20 20 42 45 | 47 49 4e 0a 20 20 20 45 | DO.  BE|GIN.   E|
|00003ff0| 58 45 43 55 54 45 20 50 | 52 4f 43 45 44 55 52 45 |XECUTE P|ROCEDURE|
|00004000| 20 64 65 70 74 5f 62 75 | 64 67 65 74 20 3a 72 64 | dept_bu|dget :rd|
|00004010| 6e 6f 20 52 45 54 55 52 | 4e 49 4e 47 5f 56 41 4c |no RETUR|NING_VAL|
|00004020| 55 45 53 20 3a 73 75 6d | 62 3b 0a 20 20 20 74 6f |UES :sum|b;.   to|
|00004030| 74 20 3d 20 74 6f 74 20 | 2b 20 73 75 6d 62 3b 0a |t = tot |+ sumb;.|
|00004040| 20 20 45 4e 44 0a 0a 20 | 53 55 53 50 45 4e 44 3b |  END.. |SUSPEND;|
|00004050| 0a 45 4e 44 00 08 04 86 | 01 00 00 04 02 04 00 02 |.END....|........|
|00004060| 00 0f 15 00 03 00 07 00 | 04 01 03 00 1b 07 00 07 |........|........|
|00004070| 00 0c 00 02 03 00 00 1b | 01 2d 1a 00 00 03 01 00 |........|.-......|
|00004080| 1b 01 2d 1a 01 00 03 02 | 00 0f 15 00 03 00 01 2d |..-.....|.......-|
|00004090| 1a 02 00 03 03 00 08 00 | 01 2d 1a 03 00 9b 11 00 |........|.-......|
|000040a0| 02 02 01 15 08 00 00 00 | 00 00 1a 00 00 07 7f 43 |........|.......C|
|000040b0| 01 4a 0a 44 45 50 41 52 | 54 4d 45 4e 54 00 47 2f |.J.DEPAR|TMENT.G/|
|000040c0| 17 00 07 44 45 50 54 5f | 4e 4f 29 00 00 00 01 00 |...DEPT_|NO).....|
|000040d0| ff 02 01 17 00 06 42 55 | 44 47 45 54 1a 00 00 ff |......BU|DGET....|
|000040e0| 07 7f 43 01 4f 02 43 01 | 4a 0a 44 45 50 41 52 54 |..C.O.C.|J.DEPART|
|000040f0| 4d 45 4e 54 01 47 2f 17 | 01 09 48 45 41 44 5f 44 |MENT.G/.|..HEAD_D|
|00004100| 45 50 54 29 00 00 00 01 | 00 ff 4e 00 4d 01 00 00 |EPT)....|..N.M...|
|00004110| 00 5d 17 01 06 42 55 44 | 47 45 54 ff 02 01 18 02 |.]...BUD|GET.....|
|00004120| 00 00 1a 03 00 ff 08 2f | 1a 03 00 15 08 00 00 00 |......./|........|
|00004130| 00 00 02 0e 01 02 01 1a | 00 00 29 01 00 00 01 00 |........|..).....|
|00004140| 01 15 07 00 01 00 19 01 | 02 00 ff 9b ff ff 07 43 |........|.......C|
|00004150| 01 4a 0a 44 45 50 41 52 | 54 4d 45 4e 54 03 47 2f |.J.DEPAR|TMENT.G/|
|00004160| 17 03 09 48 45 41 44 5f | 44 45 50 54 29 00 00 00 |...HEAD_|DEPT)...|
|00004170| 01 00 ff 02 01 17 03 07 | 44 45 50 54 5f 4e 4f 1a |........|DEPT_NO.|
|00004180| 02 00 02 02 78 0b 44 45 | 50 54 5f 42 55 44 47 45 |....x.DE|PT_BUDGE|
|00004190| 54 01 00 1a 02 00 01 00 | 1a 01 00 01 22 1a 00 00 |T.......|...."...|
|000041a0| 1a 01 00 1a 00 00 ff ff | ff 02 0e 01 02 01 1a 00 |........|........|
|000041b0| 00 29 01 00 00 01 00 01 | 15 07 00 01 00 19 01 02 |.)......|........|
|000041c0| 00 ff 9b ff ff ff ff 0e | 01 02 01 1a 00 00 29 01 |........|......).|
|000041d0| 00 00 01 00 01 15 07 00 | 00 00 19 01 02 00 ff ff |........|........|
|000041e0| 4c 09 0f 53 51 4c 24 44 | 45 50 54 5f 42 55 44 47 |L..SQL$D|EPT_BUDG|
|000041f0| 45 54 0a 06 53 59 53 44 | 42 41 00 1c 01 03 44 4e |ET..SYSD|BA....DN|
|00004200| 4f 02 04 00 00 00 00 03 | 04 00 00 00 00 04 06 52 |O.......|.......R|
|00004210| 44 42 24 34 32 00 1c 01 | 03 54 4f 54 02 04 00 00 |DB$42...|.TOT....|
|00004220| 00 00 03 04 01 00 00 00 | 04 06 52 44 42 24 34 33 |........|..RDB$43|
|00004230| 00 1d 1b 01 09 4f 52 47 | 5f 43 48 41 52 54 02 04 |.....ORG|_CHART..|
|00004240| 00 00 00 00 03 04 05 00 | 00 00 07 04 4b 02 00 00 |........|....K...|
|00004250| 0a 20 44 45 43 4c 41 52 | 45 20 56 41 52 49 41 42 |. DECLAR|E VARIAB|
|00004260| 4c 45 20 6d 6e 67 72 5f | 6e 6f 20 49 4e 54 45 47 |LE mngr_|no INTEG|
|00004270| 45 52 3b 0a 20 44 45 43 | 4c 41 52 45 20 56 41 52 |ER;. DEC|LARE VAR|
|00004280| 49 41 42 4c 45 20 64 6e | 6f 20 43 48 41 52 28 33 |IABLE dn|o CHAR(3|
|00004290| 29 3b 0a 42 45 47 49 4e | 0a 20 46 4f 52 20 53 45 |);.BEGIN|. FOR SE|
|000042a0| 4c 45 43 54 20 68 2e 64 | 65 70 61 72 74 6d 65 6e |LECT h.d|epartmen|
|000042b0| 74 2c 20 64 2e 64 65 70 | 61 72 74 6d 65 6e 74 2c |t, d.dep|artment,|
|000042c0| 20 64 2e 6d 6e 67 72 5f | 6e 6f 2c 20 64 2e 64 65 | d.mngr_|no, d.de|
|000042d0| 70 74 5f 6e 6f 0a 20 20 | 46 52 4f 4d 20 64 65 70 |pt_no.  |FROM dep|
|000042e0| 61 72 74 6d 65 6e 74 20 | 64 0a 20 20 4c 45 46 54 |artment |d.  LEFT|
|000042f0| 20 4f 55 54 45 52 20 4a | 4f 49 4e 20 64 65 70 61 | OUTER J|OIN depa|
|00004300| 72 74 6d 65 6e 74 20 68 | 20 4f 4e 20 64 2e 68 65 |rtment h| ON d.he|
|00004310| 61 64 5f 64 65 70 74 20 | 3d 20 68 2e 64 65 70 74 |ad_dept |= h.dept|
|00004320| 5f 6e 6f 0a 20 20 4f 52 | 44 45 52 20 42 59 20 64 |_no.  OR|DER BY d|
|00004330| 2e 64 65 70 74 5f 6e 6f | 0a 20 20 49 4e 54 4f 20 |.dept_no|.  INTO |
|00004340| 3a 68 65 61 64 5f 64 65 | 70 74 2c 20 3a 64 65 70 |:head_de|pt, :dep|
|00004350| 61 72 74 6d 65 6e 74 2c | 20 3a 6d 6e 67 72 5f 6e |artment,| :mngr_n|
|00004360| 6f 2c 20 3a 64 6e 6f 0a | 20 44 4f 0a 20 42 45 47 |o, :dno.| DO. BEG|
|00004370| 49 4e 0a 20 20 49 46 20 | 28 3a 6d 6e 67 72 5f 6e |IN.  IF |(:mngr_n|
|00004380| 6f 20 49 53 20 4e 55 4c | 4c 29 20 54 48 45 4e 0a |o IS NUL|L) THEN.|
|00004390| 20 20 42 45 47 49 4e 0a | 20 20 20 6d 6e 67 72 5f |  BEGIN.|   mngr_|
|000043a0| 6e 61 6d 65 20 3d 20 22 | 2d 2d 54 42 48 2d 2d 22 |name = "|--TBH--"|
|000043b0| 3b 0a 20 20 20 74 69 74 | 6c 65 20 3d 20 22 22 3b |;.   tit|le = "";|
|000043c0| 0a 20 20 45 4e 44 0a 0a | 20 20 45 4c 53 45 0a 20 |.  END..|  ELSE. |
|000043d0| 20 20 53 45 4c 45 43 54 | 20 66 75 6c 6c 5f 6e 61 |  SELECT| full_na|
|000043e0| 6d 65 2c 20 6a 6f 62 5f | 63 6f 64 65 0a 20 20 20 |me, job_|code.   |
|000043f0| 46 52 4f 4d 20 65 6d 70 | 6c 6f 79 65 65 0a 20 20 |FROM emp|loyee.  |
|00004400| 20 57 48 45 52 45 20 65 | 6d 70 5f 6e 6f 20 3d 20 | WHERE e|mp_no = |
|00004410| 3a 6d 6e 67 72 5f 6e 6f | 0a 20 20 20 49 4e 54 4f |:mngr_no|.   INTO|
|00004420| 20 3a 6d 6e 67 72 5f 6e | 61 6d 65 2c 20 3a 74 69 | :mngr_n|ame, :ti|
|00004430| 74 6c 65 3b 0a 0a 20 20 | 53 45 4c 45 43 54 20 43 |tle;..  |SELECT C|
|00004440| 4f 55 4e 54 28 65 6d 70 | 5f 6e 6f 29 0a 20 20 46 |OUNT(emp|_no).  F|
|00004450| 00 52 4f 4d 20 65 6d 70 | 6c 6f 79 65 65 0a 20 20 |.ROM emp|loyee.  |
|00004460| 57 48 45 52 45 20 64 65 | 70 74 5f 6e 6f 20 3d 20 |WHERE de|pt_no = |
|00004470| 3a 64 6e 6f 0a 20 20 49 | 4e 54 4f 20 3a 65 6d 70 |:dno.  I|NTO :emp|
|00004480| 5f 63 6e 74 3b 0a 0a 20 | 20 53 55 53 50 45 4e 44 |_cnt;.. | SUSPEND|
|00004490| 3b 0a 20 45 4e 44 0a 45 | 4e 44 00 08 04 3d 02 00 |;. END.E|ND...=..|
|000044a0| 00 04 02 04 01 0b 00 0f | 15 00 19 00 07 00 0f 15 |........|........|
|000044b0| 00 19 00 07 00 0f 15 00 | 14 00 07 00 0f 15 00 05 |........|........|
|000044c0| 00 07 00 08 00 07 00 07 | 00 02 03 00 00 0f 15 00 |........|........|
|000044d0| 19 00 01 2d 1a 00 00 03 | 01 00 0f 15 00 19 00 01 |...-....|........|
|000044e0| 2d 1a 01 00 03 02 00 0f | 15 00 14 00 01 2d 1a 02 |-.......|.....-..|
|000044f0| 00 03 03 00 0f 15 00 05 | 00 01 2d 1a 03 00 03 04 |........|..-.....|
|00004500| 00 08 00 01 2d 1a 04 00 | 03 05 00 08 00 01 2d 1a |....-...|......-.|
|00004510| 05 00 03 06 00 0f 15 00 | 03 00 01 2d 1a 06 00 9b |........|...-....|
|00004520| 11 00 02 02 07 43 01 77 | 02 92 0a 44 45 50 41 52 |.....C.w|...DEPAR|
|00004530| 54 4d 45 4e 54 01 44 00 | 92 0a 44 45 50 41 52 54 |TMENT.D.|..DEPART|
|00004540| 4d 45 4e 54 01 48 01 50 | 01 47 2f 17 00 09 48 45 |MENT.H.P|.G/...HE|
|00004550| 41 44 5f 44 45 50 54 17 | 01 07 44 45 50 54 5f 4e |AD_DEPT.|..DEPT_N|
|00004560| 4f ff 46 01 48 17 00 07 | 44 45 50 54 5f 4e 4f ff |O.F.H...|DEPT_NO.|
|00004570| 02 01 17 01 0a 44 45 50 | 41 52 54 4d 45 4e 54 1a |.....DEP|ARTMENT.|
|00004580| 00 00 01 17 00 0a 44 45 | 50 41 52 54 4d 45 4e 54 |......DE|PARTMENT|
|00004590| 1a 01 00 01 17 00 07 4d | 4e 47 52 5f 4e 4f 1a 05 |.......M|NGR_NO..|
|000045a0| 00 01 17 00 07 44 45 50 | 54 5f 4e 4f 1a 06 00 02 |.....DEP|T_NO....|
|000045b0| 02 08 3d 1a 05 00 02 02 | 01 15 0f 7f 00 07 00 2d |..=.....|.......-|
|000045c0| 2d 54 42 48 2d 2d 1a 02 | 00 01 15 0f 7f 00 00 00 |-TBH--..|........|
|000045d0| 1a 03 00 ff ff 07 7f 43 | 01 4a 08 45 4d 50 4c 4f |.......C|.J.EMPLO|
|000045e0| 59 45 45 02 47 2f 17 02 | 06 45 4d 50 5f 4e 4f 1a |YEE.G/..|.EMP_NO.|
|000045f0| 05 00 ff 02 01 17 02 09 | 46 55 4c 4c 5f 4e 41 4d |........|FULL_NAM|
|00004600| 45 1a 02 00 01 17 02 08 | 4a 4f 42 5f 43 4f 44 45 |E.......|JOB_CODE|
|00004610| 1a 03 00 ff 07 7f 43 01 | 4f 04 43 01 4a 08 45 4d |......C.|O.C.J.EM|
|00004620| 50 4c 4f 59 45 45 03 47 | 2f 17 03 07 44 45 50 54 |PLOYEE.G|/...DEPT|
|00004630| 5f 4e 4f 1a 06 00 ff 4e | 00 4d 01 00 00 00 5d 17 |_NO....N|.M....].|
|00004640| 03 06 45 4d 50 5f 4e 4f | ff 02 01 18 04 00 00 1a |..EMP_NO|........|
|00004650| 04 00 ff 02 0e 01 02 01 | 1a 00 00 29 01 00 00 01 |........|...)....|
|00004660| 00 01 1a 01 00 29 01 02 | 00 03 00 01 1a 02 00 29 |.....)..|.......)|
|00004670| 01 04 00 05 00 01 1a 03 | 00 29 01 06 00 07 00 01 |........|.)......|
|00004680| 1a 04 00 29 01 08 00 09 | 00 01 15 07 00 01 00 19 |...)....|........|
|00004690| 01 0a 00 ff 9b ff ff ff | ff ff ff ff 0e 01 02 01 |........|........|
|000046a0| 1a 00 00 29 01 00 00 01 | 00 01 1a 01 00 29 01 02 |...)....|.....)..|
|000046b0| 00 03 00 01 1a 02 00 29 | 01 04 00 05 00 01 1a 03 |.......)|........|
|000046c0| 00 29 01 06 00 07 00 01 | 1a 04 00 29 01 08 00 09 |.)......|...)....|
|000046d0| 00 01 15 07 00 00 00 19 | 01 0a 00 ff ff 4c 09 0d |........|.....L..|
|000046e0| 53 51 4c 24 4f 52 47 5f | 43 48 41 52 54 0a 06 53 |SQL$ORG_|CHART..S|
|000046f0| 59 53 44 42 41 00 1c 01 | 09 48 45 41 44 5f 44 45 |YSDBA...|.HEAD_DE|
|00004700| 50 54 02 04 00 00 00 00 | 03 04 01 00 00 00 04 06 |PT......|........|
|00004710| 52 44 42 24 34 34 00 1c | 01 0a 44 45 50 41 52 54 |RDB$44..|..DEPART|
|00004720| 4d 45 4e 54 02 04 01 00 | 00 00 03 04 01 00 00 00 |MENT....|........|
|00004730| 04 06 52 44 42 24 34 35 | 00 1c 01 09 4d 4e 47 52 |..RDB$45|....MNGR|
|00004740| 5f 4e 41 4d 45 02 04 02 | 00 00 00 03 04 01 00 00 |_NAME...|........|
|00004750| 00 04 06 52 44 42 24 34 | 36 00 1c 01 05 54 49 54 |...RDB$4|6....TIT|
|00004760| 4c 45 02 04 03 00 00 00 | 03 04 01 00 00 00 04 06 |LE......|........|
|00004770| 52 44 42 24 34 37 00 1c | 01 07 45 4d 50 5f 43 4e |RDB$47..|..EMP_CN|
|00004780| 54 02 04 04 00 00 00 03 | 04 01 00 00 00 04 06 52 |T.......|.......R|
|00004790| 44 42 24 34 38 00 1d 1b | 01 0a 4d 41 49 4c 5f 4c |DB$48...|..MAIL_L|
|000047a0| 41 42 45 4c 02 04 01 00 | 00 00 03 04 06 00 00 00 |ABEL....|........|
|000047b0| 07 04 f8 04 00 00 0a 20 | 44 45 43 4c 41 52 45 20 |....... |DECLARE |
|000047c0| 56 41 52 49 41 42 4c 45 | 20 63 75 73 74 6f 6d 65 |VARIABLE| custome|
|000047d0| 72 20 56 41 52 43 48 41 | 52 28 32 35 29 3b 0a 20 |r VARCHA|R(25);. |
|000047e0| 44 45 43 4c 41 52 45 20 | 56 41 52 49 41 42 4c 45 |DECLARE |VARIABLE|
|000047f0| 20 66 69 72 73 74 20 20 | 56 41 52 43 48 41 52 28 | first  |VARCHAR(|
|00004800| 31 35 29 3b 0a 20 44 45 | 43 4c 41 52 45 20 56 41 |15);. DE|CLARE VA|
|00004810| 52 49 41 42 4c 45 20 6c | 61 73 74 20 20 56 41 52 |RIABLE l|ast  VAR|
|00004820| 43 48 41 52 28 32 30 29 | 3b 0a 20 44 45 43 4c 41 |CHAR(20)|;. DECLA|
|00004830| 52 45 20 56 41 52 49 41 | 42 4c 45 20 61 64 64 72 |RE VARIA|BLE addr|
|00004840| 31 20 20 56 41 52 43 48 | 41 52 28 33 30 29 3b 0a |1  VARCH|AR(30);.|
|00004850| 20 44 45 43 4c 41 52 45 | 20 56 41 52 49 41 42 4c | DECLARE| VARIABL|
|00004860| 45 20 61 64 64 72 32 20 | 20 56 41 52 43 48 41 52 |E addr2 | VARCHAR|
|00004870| 28 33 30 29 3b 0a 20 44 | 45 43 4c 41 52 45 20 56 |(30);. D|ECLARE V|
|00004880| 41 52 49 41 42 4c 45 20 | 63 69 74 79 20 20 56 41 |ARIABLE |city  VA|
|00004890| 52 43 48 41 52 28 32 35 | 29 3b 0a 20 44 45 43 4c |RCHAR(25|);. DECL|
|000048a0| 41 52 45 20 56 41 52 49 | 41 42 4c 45 20 73 74 61 |ARE VARI|ABLE sta|
|000048b0| 74 65 20 20 56 41 52 43 | 48 41 52 28 31 35 29 3b |te  VARC|HAR(15);|
|000048c0| 0a 20 44 45 43 4c 41 52 | 45 20 56 41 52 49 41 42 |. DECLAR|E VARIAB|
|000048d0| 4c 45 20 63 6f 75 6e 74 | 72 79 20 56 41 52 43 48 |LE count|ry VARCH|
|000048e0| 41 52 28 31 35 29 3b 0a | 20 44 45 43 4c 41 52 45 |AR(15);.| DECLARE|
|000048f0| 20 56 41 52 49 41 42 4c | 45 20 70 6f 73 74 63 6f | VARIABL|E postco|
|00004900| 64 65 20 56 41 52 43 48 | 41 52 28 31 32 29 3b 0a |de VARCH|AR(12);.|
|00004910| 20 44 45 43 4c 41 52 45 | 20 56 41 52 49 41 42 4c | DECLARE| VARIABL|
|00004920| 45 20 63 6e 74 20 20 49 | 4e 54 45 47 45 52 3b 0a |E cnt  I|NTEGER;.|
|00004930| 42 45 47 49 4e 0a 20 6c | 69 6e 65 31 20 3d 20 22 |BEGIN. l|ine1 = "|
|00004940| 22 3b 0a 20 6c 69 6e 65 | 32 20 3d 20 22 22 3b 0a |";. line|2 = "";.|
|00004950| 20 6c 69 6e 65 33 20 3d | 20 22 22 3b 0a 20 6c 69 | line3 =| "";. li|
|00004960| 6e 65 34 20 3d 20 22 22 | 3b 0a 20 6c 69 6e 65 35 |ne4 = ""|;. line5|
|00004970| 20 3d 20 22 22 3b 0a 20 | 6c 69 6e 65 36 20 3d 20 | = "";. |line6 = |
|00004980| 22 22 3b 0a 0a 20 53 45 | 4c 45 43 54 20 63 75 73 |"";.. SE|LECT cus|
|00004990| 74 6f 6d 65 72 2c 20 63 | 6f 6e 74 61 63 74 5f 66 |tomer, c|ontact_f|
|000049a0| 69 72 73 74 2c 20 63 6f | 6e 74 61 63 74 5f 6c 61 |irst, co|ntact_la|
|000049b0| 73 74 2c 20 61 64 00 64 | 72 65 73 73 5f 6c 69 6e |st, ad.d|ress_lin|
|000049c0| 65 31 2c 0a 20 20 61 64 | 64 72 65 73 73 5f 6c 69 |e1,.  ad|dress_li|
|000049d0| 6e 65 32 2c 20 63 69 74 | 79 2c 20 73 74 61 74 65 |ne2, cit|y, state|
|000049e0| 5f 70 72 6f 76 69 6e 63 | 65 2c 20 63 6f 75 6e 74 |_provinc|e, count|
|000049f0| 72 79 2c 20 70 6f 73 74 | 61 6c 5f 63 6f 64 65 0a |ry, post|al_code.|
|00004a00| 20 46 52 4f 4d 20 43 55 | 53 54 4f 4d 45 52 0a 20 | FROM CU|STOMER. |
|00004a10| 57 48 45 52 45 20 63 75 | 73 74 5f 6e 6f 20 3d 20 |WHERE cu|st_no = |
|00004a20| 3a 63 75 73 74 5f 6e 6f | 0a 20 49 4e 54 4f 20 3a |:cust_no|. INTO :|
|00004a30| 63 75 73 74 6f 6d 65 72 | 2c 20 3a 66 69 72 73 74 |customer|, :first|
|00004a40| 2c 20 3a 6c 61 73 74 2c | 20 3a 61 64 64 72 31 2c |, :last,| :addr1,|
|00004a50| 20 3a 61 64 64 72 32 2c | 0a 20 20 3a 63 69 74 79 | :addr2,|.  :city|
|00004a60| 2c 20 3a 73 74 61 74 65 | 2c 20 3a 63 6f 75 6e 74 |, :state|, :count|
|00004a70| 72 79 2c 20 3a 70 6f 73 | 74 63 6f 64 65 3b 0a 0a |ry, :pos|tcode;..|
|00004a80| 20 49 46 20 28 63 75 73 | 74 6f 6d 65 72 20 49 53 | IF (cus|tomer IS|
|00004a90| 20 4e 4f 54 20 4e 55 4c | 4c 29 20 54 48 45 4e 0a | NOT NUL|L) THEN.|
|00004aa0| 20 20 6c 69 6e 65 31 20 | 3d 20 63 75 73 74 6f 6d |  line1 |= custom|
|00004ab0| 65 72 3b 0a 20 49 46 20 | 28 66 69 72 73 74 20 49 |er;. IF |(first I|
|00004ac0| 53 20 4e 4f 54 20 4e 55 | 4c 4c 29 20 54 48 45 4e |S NOT NU|LL) THEN|
|00004ad0| 0a 20 20 6c 69 6e 65 32 | 20 3d 20 66 69 72 73 74 |.  line2| = first|
|00004ae0| 20 7c 7c 20 22 20 22 20 | 7c 7c 20 6c 61 73 74 3b | || " " ||| last;|
|00004af0| 0a 20 45 4c 53 45 0a 20 | 20 6c 69 6e 65 32 20 3d |. ELSE. | line2 =|
|00004b00| 20 6c 61 73 74 3b 0a 20 | 49 46 20 28 61 64 64 72 | last;. |IF (addr|
|00004b10| 31 20 49 53 20 4e 4f 54 | 20 4e 55 4c 4c 29 20 54 |1 IS NOT| NULL) T|
|00004b20| 48 45 4e 0a 20 20 6c 69 | 6e 65 33 20 3d 20 61 64 |HEN.  li|ne3 = ad|
|00004b30| 64 72 31 3b 0a 20 49 46 | 20 28 61 64 64 72 32 20 |dr1;. IF| (addr2 |
|00004b40| 49 53 20 4e 4f 54 20 4e | 55 4c 4c 29 20 54 48 45 |IS NOT N|ULL) THE|
|00004b50| 4e 0a 20 20 6c 69 6e 65 | 34 20 3d 20 61 64 64 72 |N.  line|4 = addr|
|00004b60| 32 3b 0a 0a 20 49 46 20 | 28 63 6f 75 6e 74 72 79 |2;.. IF |(country|
|00004b70| 20 3d 20 22 55 53 41 22 | 29 20 54 48 45 4e 0a 20 | = "USA"|) THEN. |
|00004b80| 42 45 47 49 4e 0a 20 20 | 49 46 20 28 63 69 74 79 |BEGIN.  |IF (city|
|00004b90| 20 49 53 20 4e 4f 54 20 | 4e 55 4c 4c 29 20 54 48 | IS NOT |NULL) TH|
|00004ba0| 45 4e 0a 20 20 20 6c 69 | 6e 65 35 20 3d 20 63 69 |EN.   li|ne5 = ci|
|00004bb0| 74 79 20 7c 7c 20 22 00 | 2c 20 22 20 7c 7c 20 73 |ty || ".|, " || s|
|00004bc0| 74 61 74 65 20 7c 7c 20 | 22 20 20 22 20 7c 7c 20 |tate || |"  " || |
|00004bd0| 70 6f 73 74 63 6f 64 65 | 3b 0a 20 20 45 4c 53 45 |postcode|;.  ELSE|
|00004be0| 0a 20 20 20 6c 69 6e 65 | 35 20 3d 20 73 74 61 74 |.   line|5 = stat|
|00004bf0| 65 20 7c 7c 20 22 20 20 | 22 20 7c 7c 20 70 6f 73 |e || "  |" || pos|
|00004c00| 74 63 6f 64 65 3b 0a 20 | 45 4e 44 0a 20 45 4c 53 |tcode;. |END. ELS|
|00004c10| 45 0a 20 42 45 47 49 4e | 0a 20 20 49 46 20 28 63 |E. BEGIN|.  IF (c|
|00004c20| 69 74 79 20 49 53 20 4e | 4f 54 20 4e 55 4c 4c 29 |ity IS N|OT NULL)|
|00004c30| 20 54 48 45 4e 0a 20 20 | 20 6c 69 6e 65 35 20 3d | THEN.  | line5 =|
|00004c40| 20 63 69 74 79 20 7c 7c | 20 22 2c 20 22 20 7c 7c | city ||| ", " |||
|00004c50| 20 73 74 61 74 65 3b 0a | 20 20 45 4c 53 45 0a 20 | state;.|  ELSE. |
|00004c60| 20 20 6c 69 6e 65 35 20 | 3d 20 73 74 61 74 65 3b |  line5 |= state;|
|00004c70| 0a 20 20 6c 69 6e 65 36 | 20 3d 20 63 6f 75 6e 74 |.  line6| = count|
|00004c80| 72 79 20 7c 7c 20 22 20 | 20 20 20 22 20 7c 7c 20 |ry || " |   " || |
|00004c90| 70 6f 73 74 63 6f 64 65 | 3b 0a 20 45 4e 44 0a 0a |postcode|;. END..|
|00004ca0| 20 53 55 53 50 45 4e 44 | 3b 0a 45 4e 44 00 08 04 | SUSPEND|;.END...|
|00004cb0| 7b 03 00 00 04 02 04 00 | 02 00 08 00 07 00 04 01 |{.......|........|
|00004cc0| 0d 00 0f 15 00 28 00 07 | 00 0f 15 00 28 00 07 00 |.....(..|....(...|
|00004cd0| 0f 15 00 28 00 07 00 0f | 15 00 28 00 07 00 0f 15 |...(....|..(.....|
|00004ce0| 00 28 00 07 00 0f 15 00 | 28 00 07 00 07 00 0c 00 |.(......|(.......|
|00004cf0| 02 03 00 00 0f 15 00 28 | 00 01 2d 1a 00 00 03 01 |.......(|..-.....|
|00004d00| 00 0f 15 00 28 00 01 2d | 1a 01 00 03 02 00 0f 15 |....(..-|........|
|00004d10| 00 28 00 01 2d 1a 02 00 | 03 03 00 0f 15 00 28 00 |.(..-...|......(.|
|00004d20| 01 2d 1a 03 00 03 04 00 | 0f 15 00 28 00 01 2d 1a |.-......|...(..-.|
|00004d30| 04 00 03 05 00 0f 15 00 | 28 00 01 2d 1a 05 00 03 |........|(..-....|
|00004d40| 06 00 26 15 00 19 00 01 | 2d 1a 06 00 03 07 00 26 |..&.....|-......&|
|00004d50| 15 00 0f 00 01 2d 1a 07 | 00 03 08 00 26 15 00 14 |.....-..|....&...|
|00004d60| 00 01 2d 1a 08 00 03 09 | 00 26 15 00 1e 00 01 2d |..-.....|.&.....-|
|00004d70| 1a 09 00 03 0a 00 26 15 | 00 1e 00 01 2d 1a 0a 00 |......&.|....-...|
|00004d80| 03 0b 00 26 15 00 19 00 | 01 2d 1a 0b 00 03 0c 00 |...&....|.-......|
|00004d90| 26 15 00 0f 00 01 2d 1a | 0c 00 03 0d 00 26 15 00 |&.....-.|.....&..|
|00004da0| 0f 00 01 2d 1a 0d 00 03 | 0e 00 26 15 00 0c 00 01 |...-....|..&.....|
|00004db0| 2d 1a 0e 00 03 0f 00 08 | 00 01 2d 1a 0f 00 9b 11 |-.......|..-.....|
|00004dc0| 00 02 02 01 15 0f 7f 00 | 00 00 1a 00 00 01 15 0f |........|........|
|00004dd0| 7f 00 00 00 1a 01 00 01 | 15 0f 7f 00 00 00 1a 02 |........|........|
|00004de0| 00 01 15 0f 7f 00 00 00 | 1a 03 00 01 15 0f 7f 00 |........|........|
|00004df0| 00 00 1a 04 00 01 15 0f | 7f 00 00 00 1a 05 00 07 |........|........|
|00004e00| 7f 43 01 4a 08 43 55 53 | 54 4f 4d 45 52 00 47 2f |.C.J.CUS|TOMER.G/|
|00004e10| 17 00 07 43 55 53 54 5f | 4e 4f 29 00 00 00 01 00 |...CUST_|NO).....|
|00004e20| ff 02 01 17 00 08 43 55 | 53 54 4f 4d 45 52 1a 06 |......CU|STOMER..|
|00004e30| 00 01 17 00 0d 43 4f 4e | 54 41 43 54 5f 46 49 52 |.....CON|TACT_FIR|
|00004e40| 53 54 1a 07 00 01 17 00 | 0c 43 4f 4e 54 41 43 54 |ST......|.CONTACT|
|00004e50| 5f 4c 41 53 54 1a 08 00 | 01 17 00 0d 41 44 44 52 |_LAST...|....ADDR|
|00004e60| 45 53 53 5f 4c 49 4e 45 | 31 1a 09 00 01 17 00 0d |ESS_LINE|1.......|
|00004e70| 41 44 44 52 45 53 53 5f | 4c 49 4e 45 32 1a 0a 00 |ADDRESS_|LINE2...|
|00004e80| 01 17 00 04 43 49 54 59 | 1a 0b 00 01 17 00 0e 53 |....CITY|.......S|
|00004e90| 54 41 54 45 5f 50 52 4f | 56 49 4e 43 45 1a 0c 00 |TATE_PRO|VINCE...|
|00004ea0| 01 17 00 07 43 4f 55 4e | 54 52 59 1a 0d 00 01 17 |....COUN|TRY.....|
|00004eb0| 00 0b 50 4f 53 54 41 4c | 5f 43 4f 44 45 1a 0e 00 |..POSTAL|_CODE...|
|00004ec0| ff 08 3b 3d 1a 06 00 01 | 1a 06 00 1a 00 00 ff 08 |..;=....|........|
|00004ed0| 3b 3d 1a 07 00 01 27 27 | 1a 07 00 15 0f 7f 00 01 |;=....''|........|
|00004ee0| 00 20 1a 08 00 1a 01 00 | 01 1a 08 00 1a 01 00 08 |. ......|........|
|00004ef0| 3b 3d 1a 09 00 01 1a 09 | 00 1a 02 00 ff 08 3b 3d |;=......|......;=|
|00004f00| 1a 0a 00 01 1a 0a 00 1a | 03 00 ff 08 2f 1a 0d 00 |........|..../...|
|00004f10| 15 0f 7f 00 03 00 55 53 | 41 02 02 08 3b 3d 1a 0b |......US|A...;=..|
|00004f20| 00 01 27 27 27 27 1a 0b | 00 15 0f 7f 00 02 00 2c |..''''..|.......,|
|00004f30| 20 1a 0c 00 15 0f 7f 00 | 02 00 20 20 1a 0e 00 1a | .......|..  ....|
|00004f40| 04 00 01 27 27 1a 0c 00 | 15 0f 7f 00 02 00 20 20 |...''...|......  |
|00004f50| 1a 0e 00 1a 04 00 ff ff | 02 02 08 3b 3d 1a 0b 00 |........|...;=...|
|00004f60| 01 27 27 1a 0b 00 15 0f | 7f 00 02 00 2c 20 1a 0c |.''.....|...., ..|
|00004f70| 00 1a 04 00 01 1a 0c 00 | 1a 04 00 01 27 27 1a 0d |........|....''..|
|00004f80| 00 15 0f 7f 00 04 00 20 | 20 20 20 1a 0e 00 1a 05 |....... |   .....|
|00004f90| 00 ff ff 02 0e 01 02 01 | 1a 00 00 29 01 00 00 01 |........|...)....|
|00004fa0| 00 01 1a 01 00 29 01 02 | 00 03 00 01 1a 02 00 29 |.....)..|.......)|
|00004fb0| 01 04 00 05 00 01 1a 03 | 00 29 01 06 00 07 00 01 |........|.)......|
|00004fc0| 1a 04 00 29 01 08 00 09 | 00 01 1a 05 00 29 01 0a |...)....|.....)..|
|00004fd0| 00 0b 00 01 15 07 00 01 | 00 19 01 0c 00 ff 9b ff |........|........|
|00004fe0| ff ff ff 0e 01 02 01 1a | 00 00 29 01 00 00 01 00 |........|..).....|
|00004ff0| 01 1a 01 00 29 01 02 00 | 03 00 01 1a 02 00 29 01 |....)...|......).|
|00005000| 04 00 05 00 01 1a 03 00 | 29 01 06 00 07 00 01 1a |........|).......|
|00005010| 04 00 29 01 08 00 09 00 | 01 1a 05 00 29 01 0a 00 |..).....|....)...|
|00005020| 0b 00 01 15 07 00 00 00 | 19 01 0c 00 ff ff 4c 09 |........|......L.|
|00005030| 0e 53 51 4c 24 4d 41 49 | 4c 5f 4c 41 42 45 4c 0a |.SQL$MAI|L_LABEL.|
|00005040| 06 53 59 53 44 42 41 00 | 1c 01 07 43 55 53 54 5f |.SYSDBA.|...CUST_|
|00005050| 4e 4f 02 04 00 00 00 00 | 03 04 00 00 00 00 04 06 |NO......|........|
|00005060| 52 44 42 24 34 39 00 1c | 01 05 4c 49 4e 45 31 02 |RDB$49..|..LINE1.|
|00005070| 04 00 00 00 00 03 04 01 | 00 00 00 04 06 52 44 42 |........|.....RDB|
|00005080| 24 35 30 00 1c 01 05 4c | 49 4e 45 32 02 04 01 00 |$50....L|INE2....|
|00005090| 00 00 03 04 01 00 00 00 | 04 06 52 44 42 24 35 31 |........|..RDB$51|
|000050a0| 00 1c 01 05 4c 49 4e 45 | 33 02 04 02 00 00 00 03 |....LINE|3.......|
|000050b0| 04 01 00 00 00 04 06 52 | 44 42 24 35 32 00 1c 01 |.......R|DB$52...|
|000050c0| 05 4c 49 4e 45 34 02 04 | 03 00 00 00 03 04 01 00 |.LINE4..|........|
|000050d0| 00 00 04 06 52 44 42 24 | 35 33 00 1c 01 05 4c 49 |....RDB$|53....LI|
|000050e0| 4e 45 35 02 04 04 00 00 | 00 03 04 01 00 00 00 04 |NE5.....|........|
|000050f0| 06 52 44 42 24 35 34 00 | 1c 01 05 4c 49 4e 45 36 |.RDB$54.|...LINE6|
|00005100| 02 04 05 00 00 00 03 04 | 01 00 00 00 04 06 52 44 |........|......RD|
|00005110| 42 24 35 35 00 1d 1b 01 | 0a 53 48 49 50 5f 4f 52 |B$55....|.SHIP_OR|
|00005120| 44 45 52 02 04 01 00 00 | 00 03 04 00 00 00 00 07 |DER.....|........|
|00005130| 04 49 04 00 00 0a 20 44 | 45 43 4c 41 52 45 20 56 |.I.... D|ECLARE V|
|00005140| 41 52 49 41 42 4c 45 20 | 6f 72 64 5f 73 74 61 74 |ARIABLE |ord_stat|
|00005150| 20 43 48 41 52 28 37 29 | 3b 0a 20 44 45 43 4c 41 | CHAR(7)|;. DECLA|
|00005160| 52 45 20 56 41 52 49 41 | 42 4c 45 20 68 6f 6c 64 |RE VARIA|BLE hold|
|00005170| 5f 73 74 61 74 20 43 48 | 41 52 28 31 29 3b 0a 20 |_stat CH|AR(1);. |
|00005180| 44 45 43 4c 41 52 45 20 | 56 41 52 49 41 42 4c 45 |DECLARE |VARIABLE|
|00005190| 20 63 75 73 74 5f 6e 6f | 20 49 4e 54 45 47 45 52 | cust_no| INTEGER|
|000051a0| 3b 0a 20 44 45 43 4c 41 | 52 45 20 56 41 52 49 41 |;. DECLA|RE VARIA|
|000051b0| 42 4c 45 20 61 6e 79 5f | 70 6f 20 43 48 41 52 28 |BLE any_|po CHAR(|
|000051c0| 38 29 3b 0a 42 45 47 49 | 4e 0a 20 53 45 4c 45 43 |8);.BEGI|N. SELEC|
|000051d0| 54 20 73 2e 6f 72 64 65 | 72 5f 73 74 61 74 75 73 |T s.orde|r_status|
|000051e0| 2c 20 63 2e 6f 6e 5f 68 | 6f 6c 64 2c 20 63 2e 63 |, c.on_h|old, c.c|
|000051f0| 75 73 74 5f 6e 6f 0a 20 | 46 52 4f 4d 20 73 61 6c |ust_no. |FROM sal|
|00005200| 65 73 20 73 2c 20 63 75 | 73 74 6f 6d 65 72 20 63 |es s, cu|stomer c|
|00005210| 0a 20 57 48 45 52 45 20 | 70 6f 5f 6e 75 6d 62 65 |. WHERE |po_numbe|
|00005220| 72 20 3d 20 3a 70 6f 5f | 6e 75 6d 0a 20 41 4e 44 |r = :po_|num. AND|
|00005230| 20 73 2e 63 75 73 74 5f | 6e 6f 20 3d 20 63 2e 63 | s.cust_|no = c.c|
|00005240| 75 73 74 5f 6e 6f 0a 20 | 49 4e 54 4f 20 3a 6f 72 |ust_no. |INTO :or|
|00005250| 64 5f 73 74 61 74 2c 20 | 3a 68 6f 6c 64 5f 73 74 |d_stat, |:hold_st|
|00005260| 61 74 2c 20 3a 63 75 73 | 74 5f 6e 6f 3b 0a 0a 20 |at, :cus|t_no;.. |
|00005270| 2f 2a 20 54 68 69 73 20 | 70 75 72 63 68 61 73 65 |/* This |purchase|
|00005280| 20 6f 72 64 65 72 20 68 | 61 73 20 62 65 65 6e 20 | order h|as been |
|00005290| 61 6c 72 65 61 64 79 20 | 73 68 69 70 70 65 64 2e |already |shipped.|
|000052a0| 20 2a 2f 0a 20 49 46 20 | 28 6f 72 64 5f 73 74 61 | */. IF |(ord_sta|
|000052b0| 74 20 3d 20 22 73 68 69 | 70 70 65 64 22 29 20 54 |t = "shi|pped") T|
|000052c0| 48 45 4e 0a 20 42 45 47 | 49 4e 0a 20 20 45 58 43 |HEN. BEG|IN.  EXC|
|000052d0| 45 50 54 49 4f 4e 20 6f | 72 64 65 72 5f 61 6c 72 |EPTION o|rder_alr|
|000052e0| 65 61 64 79 5f 73 68 69 | 70 70 65 64 3b 0a 20 20 |eady_shi|pped;.  |
|000052f0| 53 55 53 50 45 4e 44 3b | 0a 20 45 4e 44 0a 0a 20 |SUSPEND;|. END.. |
|00005300| 2f 2a 20 43 75 73 74 6f | 6d 65 72 20 69 73 20 6f |/* Custo|mer is o|
|00005310| 6e 20 68 6f 6c 64 2e 20 | 2a 2f 0a 20 45 4c 53 45 |n hold. |*/. ELSE|
|00005320| 20 49 46 20 28 68 6f 6c | 64 5f 73 74 61 74 20 3d | IF (hol|d_stat =|
|00005330| 20 22 2a 22 29 00 20 54 | 48 45 4e 0a 20 42 45 47 | "*"). T|HEN. BEG|
|00005340| 49 4e 0a 20 20 45 58 43 | 45 50 54 49 4f 4e 20 63 |IN.  EXC|EPTION c|
|00005350| 75 73 74 6f 6d 65 72 5f | 6f 6e 5f 68 6f 6c 64 3b |ustomer_|on_hold;|
|00005360| 0a 20 20 53 55 53 50 45 | 4e 44 3b 0a 20 45 4e 44 |.  SUSPE|ND;. END|
|00005370| 0a 0a 20 2f 2a 0a 20 20 | 2a 20 49 66 20 74 68 65 |.. /*.  |* If the|
|00005380| 72 65 20 69 73 20 61 6e | 20 75 6e 70 61 69 64 20 |re is an| unpaid |
|00005390| 62 61 6c 61 6e 63 65 20 | 6f 6e 20 6f 72 64 65 72 |balance |on order|
|000053a0| 73 20 73 68 69 70 70 65 | 64 20 6f 76 65 72 20 32 |s shippe|d over 2|
|000053b0| 20 6d 6f 6e 74 68 73 20 | 61 67 6f 2c 0a 20 20 2a | months |ago,.  *|
|000053c0| 20 70 75 74 20 74 68 65 | 20 63 75 73 74 6f 6d 65 | put the| custome|
|000053d0| 72 20 6f 6e 20 68 6f 6c | 64 2e 0a 20 20 2a 2f 0a |r on hol|d..  */.|
|000053e0| 20 46 4f 52 20 53 45 4c | 45 43 54 20 70 6f 5f 6e | FOR SEL|ECT po_n|
|000053f0| 75 6d 62 65 72 0a 20 20 | 46 52 4f 4d 20 73 61 6c |umber.  |FROM sal|
|00005400| 65 73 0a 20 20 57 48 45 | 52 45 20 63 75 73 74 5f |es.  WHE|RE cust_|
|00005410| 6e 6f 20 3d 20 3a 63 75 | 73 74 5f 6e 6f 0a 20 20 |no = :cu|st_no.  |
|00005420| 41 4e 44 20 6f 72 64 65 | 72 5f 73 74 61 74 75 73 |AND orde|r_status|
|00005430| 20 3d 20 22 73 68 69 70 | 70 65 64 22 0a 20 20 41 | = "ship|ped".  A|
|00005440| 4e 44 20 70 61 69 64 20 | 3d 20 22 6e 22 0a 20 20 |ND paid |= "n".  |
|00005450| 41 4e 44 20 73 68 69 70 | 5f 64 61 74 65 20 3c 20 |AND ship|_date < |
|00005460| 27 4e 4f 57 27 20 2d 20 | 36 30 0a 20 20 49 4e 54 |'NOW' - |60.  INT|
|00005470| 4f 20 3a 61 6e 79 5f 70 | 6f 0a 20 44 4f 0a 20 42 |O :any_p|o. DO. B|
|00005480| 45 47 49 4e 0a 20 20 45 | 58 43 45 50 54 49 4f 4e |EGIN.  E|XCEPTION|
|00005490| 20 63 75 73 74 6f 6d 65 | 72 5f 63 68 65 63 6b 3b | custome|r_check;|
|000054a0| 0a 0a 20 20 55 50 44 41 | 54 45 20 63 75 73 74 6f |..  UPDA|TE custo|
|000054b0| 6d 65 72 0a 20 20 53 45 | 54 20 6f 6e 5f 68 6f 6c |mer.  SE|T on_hol|
|000054c0| 64 20 3d 20 22 2a 22 0a | 20 20 57 48 45 52 45 20 |d = "*".|  WHERE |
|000054d0| 63 75 73 74 5f 6e 6f 20 | 3d 20 3a 63 75 73 74 5f |cust_no |= :cust_|
|000054e0| 6e 6f 3b 0a 0a 20 20 53 | 55 53 50 45 4e 44 3b 0a |no;..  S|USPEND;.|
|000054f0| 20 45 4e 44 0a 0a 20 2f | 2a 0a 20 20 2a 20 53 68 | END.. /|*.  * Sh|
|00005500| 69 70 20 74 68 65 20 6f | 72 64 65 72 2e 0a 20 20 |ip the o|rder..  |
|00005510| 2a 2f 0a 20 55 50 44 41 | 54 45 20 73 61 6c 65 73 |*/. UPDA|TE sales|
|00005520| 0a 20 53 45 54 20 6f 72 | 64 65 72 5f 73 74 61 74 |. SET or|der_stat|
|00005530| 75 73 20 3d 20 22 00 73 | 68 69 70 70 65 64 22 2c |us = ".s|hipped",|
|00005540| 20 73 68 69 70 5f 64 61 | 74 65 20 3d 20 27 4e 4f | ship_da|te = 'NO|
|00005550| 57 27 0a 20 57 48 45 52 | 45 20 70 6f 5f 6e 75 6d |W'. WHER|E po_num|
|00005560| 62 65 72 20 3d 20 3a 70 | 6f 5f 6e 75 6d 3b 0a 0a |ber = :p|o_num;..|
|00005570| 20 53 55 53 50 45 4e 44 | 3b 0a 45 4e 44 00 08 04 | SUSPEND|;.END...|
|00005580| 88 02 00 00 04 02 04 00 | 02 00 0f 15 00 08 00 07 |........|........|
|00005590| 00 04 01 01 00 07 00 0c | 00 02 03 00 00 0f 15 00 |........|........|
|000055a0| 07 00 01 2d 1a 00 00 03 | 01 00 0f 15 00 01 00 01 |...-....|........|
|000055b0| 2d 1a 01 00 03 02 00 08 | 00 01 2d 1a 02 00 03 03 |-.......|..-.....|
|000055c0| 00 0f 15 00 08 00 01 2d | 1a 03 00 9b 11 00 02 02 |.......-|........|
|000055d0| 07 7f 43 02 92 05 53 41 | 4c 45 53 01 53 00 92 08 |..C...SA|LES.S...|
|000055e0| 43 55 53 54 4f 4d 45 52 | 01 43 01 47 3a 2f 17 00 |CUSTOMER|.C.G:/..|
|000055f0| 09 50 4f 5f 4e 55 4d 42 | 45 52 29 00 00 00 01 00 |.PO_NUMB|ER).....|
|00005600| 2f 17 00 07 43 55 53 54 | 5f 4e 4f 17 01 07 43 55 |/...CUST|_NO...CU|
|00005610| 53 54 5f 4e 4f ff 02 01 | 17 00 0c 4f 52 44 45 52 |ST_NO...|...ORDER|
|00005620| 5f 53 54 41 54 55 53 1a | 00 00 01 17 01 07 4f 4e |_STATUS.|......ON|
|00005630| 5f 48 4f 4c 44 1a 01 00 | 01 17 01 07 43 55 53 54 |_HOLD...|....CUST|
|00005640| 5f 4e 4f 1a 02 00 ff 08 | 2f 1a 00 00 15 0f 7f 00 |_NO.....|/.......|
|00005650| 07 00 73 68 69 70 70 65 | 64 02 02 80 02 15 4f 52 |..shippe|d.....OR|
|00005660| 44 45 52 5f 41 4c 52 45 | 41 44 59 5f 53 48 49 50 |DER_ALRE|ADY_SHIP|
|00005670| 50 45 44 02 0e 01 02 01 | 15 07 00 01 00 19 01 00 |PED.....|........|
|00005680| 00 ff 9b ff ff ff 08 2f | 1a 01 00 15 0f 7f 00 01 |......./|........|
|00005690| 00 2a 02 02 80 02 10 43 | 55 53 54 4f 4d 45 52 5f |.*.....C|USTOMER_|
|000056a0| 4f 4e 5f 48 4f 4c 44 02 | 0e 01 02 01 15 07 00 01 |ON_HOLD.|........|
|000056b0| 00 19 01 00 00 ff 9b ff | ff ff ff 07 43 01 4a 05 |........|....C.J.|
|000056c0| 53 41 4c 45 53 02 47 3a | 3a 3a 2f 17 02 07 43 55 |SALES.G:|::/...CU|
|000056d0| 53 54 5f 4e 4f 1a 02 00 | 2f 17 02 0c 4f 52 44 45 |ST_NO...|/...ORDE|
|000056e0| 52 5f 53 54 41 54 55 53 | 15 0f 7f 00 07 00 73 68 |R_STATUS|......sh|
|000056f0| 69 70 70 65 64 2f 17 02 | 04 50 41 49 44 15 0f 7f |ipped/..|.PAID...|
|00005700| 00 01 00 6e 33 17 02 09 | 53 48 49 50 5f 44 41 54 |...n3...|SHIP_DAT|
|00005710| 45 23 15 0f 7f 00 03 00 | 4e 4f 57 15 08 00 3c 00 |E#......|NOW...<.|
|00005720| 00 00 ff 02 01 17 02 09 | 50 4f 5f 4e 55 4d 42 45 |........|PO_NUMBE|
|00005730| 52 1a 03 00 02 02 80 02 | 0e 43 55 53 54 4f 4d 45 |R.......|.CUSTOME|
|00005740| 52 5f 43 48 45 43 4b 07 | 43 01 4a 08 43 55 53 54 |R_CHECK.|C.J.CUST|
|00005750| 4f 4d 45 52 03 47 2f 17 | 03 07 43 55 53 54 5f 4e |OMER.G/.|..CUST_N|
|00005760| 4f 1a 02 00 ff 0a 03 03 | 02 01 15 0f 7f 00 01 00 |O.......|........|
|00005770| 2a 17 03 07 4f 4e 5f 48 | 4f 4c 44 ff 02 0e 01 02 |*...ON_H|OLD.....|
|00005780| 01 15 07 00 01 00 19 01 | 00 00 ff 9b ff ff ff ff |........|........|
|00005790| 07 43 01 4a 05 53 41 4c | 45 53 04 47 2f 17 04 09 |.C.J.SAL|ES.G/...|
|000057a0| 50 4f 5f 4e 55 4d 42 45 | 52 29 00 00 00 01 00 ff |PO_NUMBE|R)......|
|000057b0| 0a 04 04 02 01 15 0f 7f | 00 07 00 73 68 69 70 70 |........|...shipp|
|000057c0| 65 64 17 04 0c 4f 52 44 | 45 52 5f 53 54 41 54 55 |ed...ORD|ER_STATU|
|000057d0| 53 01 15 0f 7f 00 03 00 | 4e 4f 57 17 04 09 53 48 |S.......|NOW...SH|
|000057e0| 49 50 5f 44 41 54 45 ff | 02 0e 01 02 01 15 07 00 |IP_DATE.|........|
|000057f0| 01 00 19 01 00 00 ff 9b | ff ff ff ff 0e 01 02 01 |........|........|
|00005800| 15 07 00 00 00 19 01 00 | 00 ff ff 4c 09 0e 53 51 |........|...L..SQ|
|00005810| 4c 24 53 48 49 50 5f 4f | 52 44 45 52 0a 06 53 59 |L$SHIP_O|RDER..SY|
|00005820| 53 44 42 41 00 1c 01 06 | 50 4f 5f 4e 55 4d 02 04 |SDBA....|PO_NUM..|
|00005830| 00 00 00 00 03 04 00 00 | 00 00 04 06 52 44 42 24 |........|....RDB$|
|00005840| 35 36 00 1d 1b 01 0a 53 | 48 4f 57 5f 4c 41 4e 47 |56.....S|HOW_LANG|
|00005850| 53 02 04 03 00 00 00 03 | 04 01 00 00 00 07 04 8b |S.......|........|
|00005860| 01 00 00 0a 44 45 43 4c | 41 52 45 20 56 41 52 49 |....DECL|ARE VARI|
|00005870| 41 42 4c 45 20 69 20 49 | 4e 54 45 47 45 52 3b 0a |ABLE i I|NTEGER;.|
|00005880| 42 45 47 49 4e 0a 20 20 | 69 20 3d 20 31 3b 0a 20 |BEGIN.  |i = 1;. |
|00005890| 20 57 48 49 4c 45 20 28 | 69 20 3c 3d 20 35 29 20 | WHILE (|i <= 5) |
|000058a0| 44 4f 0a 20 20 42 45 47 | 49 4e 0a 20 20 20 20 53 |DO.  BEG|IN.    S|
|000058b0| 45 4c 45 43 54 20 6c 61 | 6e 67 75 61 67 65 5f 72 |ELECT la|nguage_r|
|000058c0| 65 71 5b 3a 69 5d 20 46 | 52 4f 4d 20 6a 6f 42 0a |eq[:i] F|ROM joB.|
|000058d0| 20 20 20 20 57 48 45 52 | 45 20 28 28 6a 6f 62 5f |    WHER|E ((job_|
|000058e0| 63 6f 64 65 20 3d 20 3a | 63 6f 64 65 29 20 41 4e |code = :|code) AN|
|000058f0| 44 20 28 6a 6f 62 5f 67 | 72 61 64 65 20 3d 20 3a |D (job_g|rade = :|
|00005900| 67 72 61 64 65 29 20 41 | 4e 44 20 28 6a 6f 62 5f |grade) A|ND (job_|
|00005910| 63 6f 75 6e 74 72 79 20 | 3d 20 3a 63 74 79 29 0a |country |= :cty).|
|00005920| 20 20 20 20 20 20 20 20 | 20 20 20 41 4e 44 20 28 |        |   AND (|
|00005930| 6c 61 6e 67 75 61 67 65 | 5f 72 65 71 20 49 53 20 |language|_req IS |
|00005940| 4e 4f 54 20 4e 55 4c 4c | 29 29 0a 20 20 20 20 49 |NOT NULL|)).    I|
|00005950| 4e 54 4f 20 3a 6c 61 6e | 67 75 61 67 65 73 3b 0a |NTO :lan|guages;.|
|00005960| 20 20 20 20 49 46 20 28 | 6c 61 6e 67 75 61 67 65 |    IF (|language|
|00005970| 73 20 3d 20 22 20 22 29 | 20 54 48 45 4e 20 20 2f |s = " ")| THEN  /|
|00005980| 2a 20 50 72 69 6e 74 73 | 20 22 4e 55 4c 4c 22 20 |* Prints| "NULL" |
|00005990| 69 6e 73 74 65 61 64 20 | 6f 66 20 62 6c 61 6e 6b |instead |of blank|
|000059a0| 73 20 2a 2f 0a 20 20 20 | 20 20 20 20 6c 61 6e 67 |s */.   |    lang|
|000059b0| 75 61 67 65 73 20 3d 20 | 22 4e 55 4c 4c 22 3b 20 |uages = |"NULL"; |
|000059c0| 20 20 20 20 20 20 20 20 | 0a 20 20 20 20 69 20 3d |        |.    i =|
|000059d0| 20 69 20 2b 31 3b 0a 20 | 20 20 20 53 55 53 50 45 | i +1;. |   SUSPE|
|000059e0| 4e 44 3b 0a 20 20 45 4e | 44 0a 45 4e 44 00 08 04 |ND;.  EN|D.END...|
|000059f0| 3c 01 00 00 04 02 04 00 | 06 00 26 15 00 05 00 07 |<.......|..&.....|
|00005a00| 00 07 00 07 00 26 15 00 | 0f 00 07 00 04 01 03 00 |.....&..|........|
|00005a10| 26 15 00 0f 00 07 00 07 | 00 0c 00 02 03 00 00 26 |&.......|.......&|
|00005a20| 15 00 0f 00 01 2d 1a 00 | 00 03 01 00 08 00 01 2d |.....-..|.......-|
|00005a30| 1a 01 00 9b 11 00 02 02 | 01 15 08 00 01 00 00 00 |........|........|
|00005a40| 1a 01 00 11 01 09 02 08 | 34 1a 01 00 15 08 00 05 |........|4.......|
|00005a50| 00 00 00 02 02 07 7f 43 | 01 4a 03 4a 4f 42 00 47 |.......C|.J.JOB.G|
|00005a60| 3a 3a 3a 2f 17 00 08 4a | 4f 42 5f 43 4f 44 45 29 |:::/...J|OB_CODE)|
|00005a70| 00 00 00 01 00 2f 17 00 | 09 4a 4f 42 5f 47 52 41 |...../..|.JOB_GRA|
|00005a80| 44 45 29 00 02 00 03 00 | 2f 17 00 0b 4a 4f 42 5f |DE).....|/...JOB_|
|00005a90| 43 4f 55 4e 54 52 59 29 | 00 04 00 05 00 3b 3d 17 |COUNTRY)|.....;=.|
|00005aa0| 00 0c 4c 41 4e 47 55 41 | 47 45 5f 52 45 51 ff 02 |..LANGUA|GE_REQ..|
|00005ab0| 01 6b 17 00 0c 4c 41 4e | 47 55 41 47 45 5f 52 45 |.k...LAN|GUAGE_RE|
|00005ac0| 51 01 1a 01 00 1a 00 00 | ff 08 2f 1a 00 00 15 0f |Q.......|../.....|
|00005ad0| 7f 00 01 00 20 01 15 0f | 7f 00 04 00 4e 55 4c 4c |.... ...|....NULL|
|00005ae0| 1a 00 00 ff 01 22 1a 01 | 00 15 08 00 01 00 00 00 |....."..|........|
|00005af0| 1a 01 00 02 0e 01 02 01 | 1a 00 00 29 01 00 00 01 |........|...)....|
|00005b00| 00 01 15 07 00 01 00 19 | 01 02 00 ff 9b ff ff ff |........|........|
|00005b10| 12 01 ff ff ff ff 0e 01 | 02 01 1a 00 00 29 01 00 |........|.....)..|
|00005b20| 00 01 00 01 15 07 00 00 | 00 19 01 02 00 ff ff 4c |........|.......L|
|00005b30| 09 0e 53 51 4c 24 53 48 | 4f 57 5f 4c 41 4e 47 53 |..SQL$SH|OW_LANGS|
|00005b40| 0a 06 53 59 53 44 42 41 | 00 1c 01 04 43 4f 44 45 |..SYSDBA|....CODE|
|00005b50| 02 04 00 00 00 00 03 04 | 00 00 00 00 04 06 52 44 |........|......RD|
|00005b60| 42 24 35 37 00 1c 01 05 | 47 52 41 44 45 02 04 01 |B$57....|GRADE...|
|00005b70| 00 00 00 03 04 00 00 00 | 00 04 06 52 44 42 24 35 |........|...RDB$5|
|00005b80| 38 00 1c 01 03 43 54 59 | 02 04 02 00 00 00 03 04 |8....CTY|........|
|00005b90| 00 00 00 00 04 06 52 44 | 42 24 35 39 00 1c 01 09 |......RD|B$59....|
|00005ba0| 4c 41 4e 47 55 41 47 45 | 53 02 04 00 00 00 00 03 |LANGUAGE|S.......|
|00005bb0| 04 01 00 00 00 04 06 52 | 44 42 24 36 30 00 1d 1b |.......R|DB$60...|
|00005bc0| 01 09 41 4c 4c 5f 4c 41 | 4e 47 53 02 04 00 00 00 |..ALL_LA|NGS.....|
|00005bd0| 00 03 04 04 00 00 00 07 | 04 8b 01 00 00 0a 20 20 |........|......  |
|00005be0| 20 20 42 45 47 49 4e 0a | 20 46 4f 52 20 53 45 4c |  BEGIN.| FOR SEL|
|00005bf0| 45 43 54 20 6a 6f 62 5f | 63 6f 64 65 2c 20 6a 6f |ECT job_|code, jo|
|00005c00| 62 5f 67 72 61 64 65 2c | 20 6a 6f 62 5f 63 6f 75 |b_grade,| job_cou|
|00005c10| 6e 74 72 79 20 46 52 4f | 4d 20 6a 6f 62 20 0a 20 |ntry FRO|M job . |
|00005c20| 20 49 4e 54 4f 20 3a 63 | 6f 64 65 2c 20 3a 67 72 | INTO :c|ode, :gr|
|00005c30| 61 64 65 2c 20 3a 63 6f | 75 6e 74 72 79 0a 0a 20 |ade, :co|untry.. |
|00005c40| 44 4f 0a 20 42 45 47 49 | 4e 0a 20 20 20 20 20 46 |DO. BEGI|N.     F|
|00005c50| 4f 52 20 53 45 4c 45 43 | 54 20 6c 61 6e 67 75 61 |OR SELEC|T langua|
|00005c60| 67 65 73 20 46 52 4f 4d | 20 73 68 6f 77 5f 6c 61 |ges FROM| show_la|
|00005c70| 6e 67 73 20 0a 20 20 20 | 20 20 20 20 28 3a 63 6f |ngs .   |    (:co|
|00005c80| 64 65 2c 20 3a 67 72 61 | 64 65 2c 20 3a 63 6f 75 |de, :gra|de, :cou|
|00005c90| 6e 74 72 79 29 20 49 4e | 54 4f 20 3a 6c 61 6e 67 |ntry) IN|TO :lang|
|00005ca0| 20 44 4f 0a 20 20 20 20 | 20 20 20 20 20 53 55 53 | DO.    |     SUS|
|00005cb0| 50 45 4e 44 3b 0a 20 20 | 20 20 20 2f 2a 20 50 75 |PEND;.  |   /* Pu|
|00005cc0| 74 20 6e 69 63 65 20 73 | 65 70 61 72 61 74 6f 72 |t nice s|eparator|
|00005cd0| 73 20 62 65 74 77 65 65 | 6e 20 72 6f 77 73 20 2a |s betwee|n rows *|
|00005ce0| 2f 0a 20 20 20 20 20 63 | 6f 64 65 20 3d 20 22 3d |/.     c|ode = "=|
|00005cf0| 3d 3d 3d 3d 22 3b 0a 20 | 20 20 20 20 67 72 61 64 |====";. |    grad|
|00005d00| 65 20 3d 20 22 3d 3d 3d | 3d 3d 22 3b 0a 20 20 20 |e = "===|==";.   |
|00005d10| 20 20 63 6f 75 6e 74 72 | 79 20 3d 20 22 3d 3d 3d |  countr|y = "===|
|00005d20| 3d 3d 3d 3d 3d 3d 3d 3d | 3d 3d 3d 3d 22 3b 0a 20 |========|====";. |
|00005d30| 20 20 20 20 6c 61 6e 67 | 20 3d 20 22 3d 3d 3d 3d |    lang| = "====|
|00005d40| 3d 3d 3d 3d 3d 3d 3d 3d | 3d 3d 22 3b 0a 20 20 20 |========|==";.   |
|00005d50| 20 20 53 55 53 50 45 4e | 44 3b 0a 20 45 4e 44 0a |  SUSPEN|D;. END.|
|00005d60| 20 20 20 20 45 4e 44 00 | 08 04 c9 01 00 00 04 02 |    END.|........|
|00005d70| 04 01 09 00 26 15 00 05 | 00 07 00 26 15 00 05 00 |....&...|...&....|
|00005d80| 07 00 26 15 00 0f 00 07 | 00 26 15 00 0f 00 07 00 |..&.....|.&......|
|00005d90| 07 00 02 03 00 00 26 15 | 00 05 00 01 2d 1a 00 00 |......&.|....-...|
|00005da0| 03 01 00 26 15 00 05 00 | 01 2d 1a 01 00 03 02 00 |...&....|.-......|
|00005db0| 26 15 00 0f 00 01 2d 1a | 02 00 03 03 00 26 15 00 |&.....-.|.....&..|
|00005dc0| 0f 00 01 2d 1a 03 00 9b | 11 00 02 02 07 43 01 4a |...-....|.....C.J|
|00005dd0| 03 4a 4f 42 00 ff 02 01 | 17 00 08 4a 4f 42 5f 43 |.JOB....|...JOB_C|
|00005de0| 4f 44 45 1a 00 00 01 17 | 00 09 4a 4f 42 5f 47 52 |ODE.....|..JOB_GR|
|00005df0| 41 44 45 1a 01 00 01 17 | 00 0b 4a 4f 42 5f 43 4f |ADE.....|..JOB_CO|
|00005e00| 55 4e 54 52 59 1a 02 00 | 02 02 07 43 01 7c 0a 53 |UNTRY...|...C.|.S|
|00005e10| 48 4f 57 5f 4c 41 4e 47 | 53 01 03 00 1a 00 00 1a |HOW_LANG|S.......|
|00005e20| 01 00 1a 02 00 ff 02 01 | 17 01 09 4c 41 4e 47 55 |........|...LANGU|
|00005e30| 41 47 45 53 1a 03 00 02 | 0e 01 02 01 1a 00 00 29 |AGES....|.......)|
|00005e40| 01 00 00 01 00 01 1a 01 | 00 29 01 02 00 03 00 01 |........|.)......|
|00005e50| 1a 02 00 29 01 04 00 05 | 00 01 1a 03 00 29 01 06 |...)....|.....)..|
|00005e60| 00 07 00 01 15 07 00 01 | 00 19 01 08 00 ff 9b ff |........|........|
|00005e70| ff 01 15 0f 7f 00 05 00 | 3d 3d 3d 3d 3d 1a 00 00 |........|=====...|
|00005e80| 01 15 0f 7f 00 05 00 3d | 3d 3d 3d 3d 1a 01 00 01 |.......=|====....|
|00005e90| 15 0f 7f 00 0f 00 3d 3d | 3d 3d 3d 3d 3d 3d 3d 3d |......==|========|
|00005ea0| 3d 3d 3d 3d 3d 1a 02 00 | 01 15 0f 7f 00 0e 00 3d |=====...|.......=|
|00005eb0| 3d 3d 3d 3d 3d 3d 3d 3d | 3d 3d 3d 3d 3d 1a 03 00 |========|=====...|
|00005ec0| 02 0e 01 02 01 1a 00 00 | 29 01 00 00 01 00 01 1a |........|).......|
|00005ed0| 01 00 29 01 02 00 03 00 | 01 1a 02 00 29 01 04 00 |..).....|....)...|
|00005ee0| 05 00 01 1a 03 00 29 01 | 06 00 07 00 01 15 07 00 |......).|........|
|00005ef0| 01 00 19 01 08 00 ff 9b | ff ff ff ff ff ff ff 0e |........|........|
|00005f00| 01 02 01 1a 00 00 29 01 | 00 00 01 00 01 1a 01 00 |......).|........|
|00005f10| 29 01 02 00 03 00 01 1a | 02 00 29 01 04 00 05 00 |).......|..).....|
|00005f20| 01 1a 03 00 29 01 06 00 | 07 00 01 15 07 00 00 00 |....)...|........|
|00005f30| 19 01 08 00 ff ff 4c 09 | 0d 53 51 4c 24 41 4c 4c |......L.|.SQL$ALL|
|00005f40| 5f 4c 41 4e 47 53 0a 06 | 53 59 53 44 42 41 00 1c |_LANGS..|SYSDBA..|
|00005f50| 01 04 43 4f 44 45 02 04 | 00 00 00 00 03 04 01 00 |..CODE..|........|
|00005f60| 00 00 04 06 52 44 42 24 | 36 31 00 1c 01 05 47 52 |....RDB$|61....GR|
|00005f70| 41 44 45 02 04 01 00 00 | 00 03 04 01 00 00 00 04 |ADE.....|........|
|00005f80| 06 52 44 42 24 36 32 00 | 1c 01 07 43 4f 55 4e 54 |.RDB$62.|...COUNT|
|00005f90| 52 59 02 04 02 00 00 00 | 03 04 01 00 00 00 04 06 |RY......|........|
|00005fa0| 52 44 42 24 36 33 00 1c | 01 04 4c 41 4e 47 02 04 |RDB$63..|..LANG..|
|00005fb0| 03 00 00 00 03 04 01 00 | 00 00 04 06 52 44 42 24 |........|....RDB$|
|00005fc0| 36 34 00 1d 1b 01 10 46 | 52 45 4e 43 48 5f 43 55 |64.....F|RENCH_CU|
|00005fd0| 53 54 5f 53 4f 52 54 02 | 04 00 00 00 00 03 04 03 |ST_SORT.|........|
|00005fe0| 00 00 00 07 04 a8 00 00 | 00 0a 42 45 47 49 4e 0a |........|..BEGIN.|
|00005ff0| 20 20 20 20 20 20 20 20 | 46 4f 52 20 53 45 4c 45 |        |FOR SELE|
|00006000| 43 54 20 63 75 73 74 6f | 6d 65 72 2c 20 63 69 74 |CT custo|mer, cit|
|00006010| 79 2c 20 63 6f 75 6e 74 | 72 79 20 0a 20 20 20 20 |y, count|ry .    |
|00006020| 20 46 52 4f 4d 20 63 75 | 73 74 6f 6d 65 72 20 4f | FROM cu|stomer O|
|00006030| 52 44 45 52 20 42 59 20 | 63 75 73 74 6f 6d 65 72 |RDER BY |customer|
|00006040| 0a 20 20 20 20 20 20 20 | 20 20 20 20 20 49 4e 54 |.       |     INT|
|00006050| 4f 20 3a 63 75 73 74 6f | 6d 65 72 2c 20 3a 63 69 |O :custo|mer, :ci|
|00006060| 74 79 2c 20 3a 63 6f 75 | 6e 74 72 79 0a 20 20 20 |ty, :cou|ntry.   |
|00006070| 20 20 20 20 20 44 4f 0a | 20 20 20 20 20 20 20 20 |     DO.|        |
|00006080| 20 20 20 53 55 53 50 45 | 4e 44 3b 0a 0a 45 4e 44 |   SUSPE|ND;..END|
|00006090| 00 08 04 f1 00 00 00 04 | 02 04 01 07 00 26 15 00 |........|.....&..|
|000060a0| 28 00 07 00 26 15 00 19 | 00 07 00 26 15 00 0f 00 |(...&...|...&....|
|000060b0| 07 00 07 00 02 03 00 00 | 26 15 00 28 00 01 2d 1a |........|&..(..-.|
|000060c0| 00 00 03 01 00 26 15 00 | 19 00 01 2d 1a 01 00 03 |.....&..|...-....|
|000060d0| 02 00 26 15 00 0f 00 01 | 2d 1a 02 00 9b 11 00 02 |..&.....|-.......|
|000060e0| 02 07 43 01 4a 08 43 55 | 53 54 4f 4d 45 52 00 46 |..C.J.CU|STOMER.F|
|000060f0| 01 48 17 00 08 43 55 53 | 54 4f 4d 45 52 ff 02 01 |.H...CUS|TOMER...|
|00006100| 17 00 08 43 55 53 54 4f | 4d 45 52 1a 00 00 01 17 |...CUSTO|MER.....|
|00006110| 00 04 43 49 54 59 1a 01 | 00 01 17 00 07 43 4f 55 |..CITY..|.....COU|
|00006120| 4e 54 52 59 1a 02 00 02 | 0e 01 02 01 1a 00 00 29 |NTRY....|.......)|
|00006130| 01 00 00 01 00 01 1a 01 | 00 29 01 02 00 03 00 01 |........|.)......|
|00006140| 1a 02 00 29 01 04 00 05 | 00 01 15 07 00 01 00 19 |...)....|........|
|00006150| 01 06 00 ff 9b ff ff ff | ff ff 0e 01 02 01 1a 00 |........|........|
|00006160| 00 29 01 00 00 01 00 01 | 1a 01 00 29 01 02 00 03 |.)......|...)....|
|00006170| 00 01 1a 02 00 29 01 04 | 00 05 00 01 15 07 00 00 |.....)..|........|
|00006180| 00 19 01 06 00 ff ff 4c | 09 14 53 51 4c 24 46 52 |.......L|..SQL$FR|
|00006190| 45 4e 43 48 5f 43 55 53 | 54 5f 53 4f 52 54 0a 06 |ENCH_CUS|T_SORT..|
|000061a0| 53 59 53 44 42 41 00 1c | 01 08 43 55 53 54 4f 4d |SYSDBA..|..CUSTOM|
|000061b0| 45 52 02 04 00 00 00 00 | 03 04 01 00 00 00 04 06 |ER......|........|
|000061c0| 52 44 42 24 36 35 00 1c | 01 04 43 49 54 59 02 04 |RDB$65..|..CITY..|
|000061d0| 01 00 00 00 03 04 01 00 | 00 00 04 06 52 44 42 24 |........|....RDB$|
|000061e0| 36 36 00 1c 01 07 43 4f | 55 4e 54 52 59 02 04 02 |66....CO|UNTRY...|
|000061f0| 00 00 00 03 04 01 00 00 | 00 04 06 52 44 42 24 36 |........|...RDB$6|
|00006200| 37 00 1d 1b 01 10 47 45 | 52 4d 41 4e 5f 43 55 53 |7.....GE|RMAN_CUS|
|00006210| 54 5f 53 4f 52 54 02 04 | 00 00 00 00 03 04 03 00 |T_SORT..|........|
|00006220| 00 00 07 04 b6 00 00 00 | 0a 42 45 47 49 4e 0a 20 |........|.BEGIN. |
|00006230| 20 20 20 20 20 20 20 46 | 4f 52 20 53 45 4c 45 43 |       F|OR SELEC|
|00006240| 54 20 63 75 73 74 6f 6d | 65 72 2c 20 63 69 74 79 |T custom|er, city|
|00006250| 2c 20 63 6f 75 6e 74 72 | 79 20 0a 20 20 20 20 20 |, countr|y .     |
|00006260| 46 52 4f 4d 20 63 75 73 | 74 6f 6d 65 72 20 4f 52 |FROM cus|tomer OR|
|00006270| 44 45 52 20 42 59 20 63 | 75 73 74 6f 6d 65 72 20 |DER BY c|ustomer |
|00006280| 43 4f 4c 4c 41 54 45 20 | 44 45 5f 44 45 0a 20 20 |COLLATE |DE_DE.  |
|00006290| 20 20 20 20 20 20 20 20 | 20 20 49 4e 54 4f 20 3a |        |  INTO :|
|000062a0| 63 75 73 74 6f 6d 65 72 | 2c 20 3a 63 69 74 79 2c |customer|, :city,|
|000062b0| 20 3a 63 6f 75 6e 74 72 | 79 0a 20 20 20 20 20 20 | :countr|y.      |
|000062c0| 20 20 44 4f 0a 20 20 20 | 20 20 20 20 20 20 20 20 |  DO.   |        |
|000062d0| 53 55 53 50 45 4e 44 3b | 0a 0a 45 4e 44 00 08 04 |SUSPEND;|..END...|
|000062e0| f7 00 00 00 04 02 04 01 | 07 00 26 15 00 28 00 07 |........|..&..(..|
|000062f0| 00 26 15 00 19 00 07 00 | 26 15 00 0f 00 07 00 07 |.&......|&.......|
|00006300| 00 02 03 00 00 26 15 00 | 28 00 01 2d 1a 00 00 03 |.....&..|(..-....|
|00006310| 01 00 26 15 00 19 00 01 | 2d 1a 01 00 03 02 00 26 |..&.....|-......&|
|00006320| 15 00 0f 00 01 2d 1a 02 | 00 9b 11 00 02 02 07 43 |.....-..|.......C|
|00006330| 01 4a 08 43 55 53 54 4f | 4d 45 52 00 46 01 48 83 |.J.CUSTO|MER.F.H.|
|00006340| 26 15 06 00 00 17 00 08 | 43 55 53 54 4f 4d 45 52 |&.......|CUSTOMER|
|00006350| ff 02 01 17 00 08 43 55 | 53 54 4f 4d 45 52 1a 00 |......CU|STOMER..|
|00006360| 00 01 17 00 04 43 49 54 | 59 1a 01 00 01 17 00 07 |.....CIT|Y.......|
|00006370| 43 4f 55 4e 54 52 59 1a | 02 00 02 0e 01 02 01 1a |COUNTRY.|........|
|00006380| 00 00 29 01 00 00 01 00 | 01 1a 01 00 29 01 02 00 |..).....|....)...|
|00006390| 03 00 01 1a 02 00 29 01 | 04 00 05 00 01 15 07 00 |......).|........|
|000063a0| 01 00 19 01 06 00 ff 9b | ff ff ff ff ff 0e 01 02 |........|........|
|000063b0| 01 1a 00 00 29 01 00 00 | 01 00 01 1a 01 00 29 01 |....)...|......).|
|000063c0| 02 00 03 00 01 1a 02 00 | 29 01 04 00 05 00 01 15 |........|).......|
|000063d0| 07 00 00 00 19 01 06 00 | ff ff 4c 09 14 53 51 4c |........|..L..SQL|
|000063e0| 24 47 45 52 4d 41 4e 5f | 43 55 53 54 5f 53 4f 52 |$GERMAN_|CUST_SOR|
|000063f0| 54 0a 06 53 59 53 44 42 | 41 00 1c 01 08 43 55 53 |T..SYSDB|A....CUS|
+--------+-------------------------+-------------------------+--------+--------+
Only 25.0 KB of data is shown above.