PC Pro 1999 February

home *** CD-ROM | disk | FTP | other *** search
/ PC Pro 1999 February / DPPCPRO0299.ISO / February / Delphi / Install / DATA.Z / INTLEMP.GBK < prev next >
Unknown | 1996-05-16 | 79.5 KB
open in:
MacOS 8.1 |
Win98 |
DOS
view JSON data |
view as text

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