Java 1.2 How-To

home *** CD-ROM | disk | FTP | other *** search
/ Java 1.2 How-To / JavaHowTo.iso / 3rdParty / jbuilder / TRIAL / WINCLNT / DATA.Z / intlemp.gbk < prev next >
Unknown | 1998-03-15 | 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 0405 0000 0004 0401 0000 ...	default (weak)
`99%`	file	data	default
`100%`	TrID	DEGAS hi-res bitmap	default (weak)
hex view
+--------+-------------------------+-------------------------+--------+--------+
|00000000| 00 02 04 05 00 00 00 04 | 04 01 00 00 00 05 04 01 |........|........|
|00000010| 00 00 00 06 04 00 20 00 | 00 08 04 01 00 00 00 07 |...... .|........|
|00000020| 0b 69 6e 74 6c 65 6d 70 | 2e 67 64 62 01 18 57 65 |.intlemp|.gdb..We|
|00000030| 64 20 4d 61 72 20 30 34 | 20 31 36 3a 34 37 3a 31 |d Mar 04| 16:47:1|
|00000040| 34 20 31 39 39 38 00 0e | 05 04 00 04 00 00 08 04 |4 1998..|........|
|00000050| 20 4e 00 00 0c 04 01 00 | 00 00 01 0b 69 6e 74 6c | N......|....intl|
|00000060| 65 6d 70 2e 67 64 62 00 | 01 0b 09 49 53 4f 38 38 |emp.gdb.|...ISO88|
|00000070| 35 39 5f 31 00 02 01 09 | 46 49 52 53 54 4e 41 4d |59_1....|FIRSTNAM|
|00000080| 45 05 00 07 00 08 04 25 | 00 00 00 0a 04 0f 00 00 |E......%|........|
|00000090| 00 09 04 00 00 00 00 0b | 04 00 00 00 00 29 04 0f |........|.....)..|
|000000a0| 00 00 00 2a 04 15 00 00 | 00 2b 04 04 00 00 00 00 |...*....|.+......|
|000000b0| 02 01 08 4c 41 53 54 4e | 41 4d 45 05 00 07 00 08 |...LASTN|AME.....|
|000000c0| 04 25 00 00 00 0a 04 19 | 00 00 00 09 04 00 00 00 |.%......|........|
|000000d0| 00 0b 04 00 00 00 00 29 | 04 19 00 00 00 2a 04 15 |.......)|.....*..|
|000000e0| 00 00 00 2b 04 04 00 00 | 00 00 02 01 0b 50 48 4f |...+....|.....PHO|
|000000f0| 4e 45 4e 55 4d 42 45 52 | 05 00 07 00 08 04 25 00 |NENUMBER|......%.|
|00000100| 00 00 0a 04 14 00 00 00 | 09 04 00 00 00 00 0b 04 |........|........|
|00000110| 00 00 00 00 29 04 14 00 | 00 00 2a 04 15 00 00 00 |....)...|..*.....|
|00000120| 2b 04 00 00 00 00 00 02 | 01 0b 43 4f 55 4e 54 52 |+.......|..COUNTR|
|00000130| 59 4e 41 4d 45 05 00 07 | 00 08 04 25 00 00 00 0a |YNAME...|...%....|
|00000140| 04 0f 00 00 00 09 04 00 | 00 00 00 0b 04 00 00 00 |........|........|
|00000150| 00 29 04 0f 00 00 00 2a | 04 15 00 00 00 2b 04 00 |.).....*|.....+..|
|00000160| 00 00 00 00 02 01 0b 41 | 44 44 52 45 53 53 4c 49 |.......A|DDRESSLI|
|00000170| 4e 45 05 00 07 00 08 04 | 25 00 00 00 0a 04 28 00 |NE......|%.....(.|
|00000180| 00 00 09 04 00 00 00 00 | 0b 04 00 00 00 00 29 04 |........|......).|
|00000190| 28 00 00 00 2a 04 15 00 | 00 00 2b 04 00 00 00 00 |(...*...|..+.....|
|000001a0| 00 02 01 05 45 4d 50 4e | 4f 05 00 07 00 08 04 07 |....EMPN|O.......|
|000001b0| 00 00 00 0a 04 02 00 00 | 00 09 04 00 00 00 00 0b |........|........|
|000001c0| 04 00 00 00 00 00 02 01 | 06 44 45 50 54 4e 4f 05 |........|.DEPTNO.|
|000001d0| 00 07 00 08 04 0e 00 00 | 00 0a 04 03 00 00 00 09 |........|........|
|000001e0| 04 00 00 00 00 0b 04 00 | 00 00 00 14 04 32 00 00 |........|.....2..|
|000001f0| 00 04 39 39 2f 18 00 00 | 00 15 0f 7f 00 03 00 30 |..99/...|.......0|
|00000200| 30 30 3a 31 18 00 00 00 | 15 0f 7f 00 01 00 30 34 |00:1....|......04|
|00000210| 18 00 00 00 15 0f 7f 00 | 03 00 39 39 39 3d 18 00 |........|..999=..|
|00000220| 00 00 4c 24 04 4b 00 00 | 00 43 48 45 43 4b 20 28 |..L$.K..|.CHECK (|
|00000230| 56 41 4c 55 45 20 3d 20 | 27 30 30 30 27 20 4f 52 |VALUE = |'000' OR|
|00000240| 20 28 56 41 4c 55 45 20 | 3e 20 27 30 27 20 41 4e | (VALUE |> '0' AN|
|00000250| 44 20 56 41 4c 55 45 20 | 3c 3d 20 27 39 39 39 27 |D VALUE |<= '999'|
|00000260| 29 20 4f 52 20 56 41 4c | 55 45 20 49 53 20 4e 55 |) OR VAL|UE IS NU|
|00000270| 4c 4c 29 00 29 04 03 00 | 00 00 2a 04 02 00 00 00 |LL).)...|..*.....|
|00000280| 2b 04 00 00 00 00 00 02 | 01 06 50 52 4f 4a 4e 4f |+.......|..PROJNO|
|00000290| 05 00 07 00 08 04 0e 00 | 00 00 0a 04 05 00 00 00 |........|........|
|000002a0| 09 04 00 00 00 00 0b 04 | 00 00 00 00 14 04 0c 00 |........|........|
|000002b0| 00 00 04 2f 18 00 00 00 | 67 18 00 00 00 4c 24 04 |.../....|g....L$.|
|000002c0| 1e 00 00 00 43 48 45 43 | 4b 20 28 56 41 4c 55 45 |....CHEC|K (VALUE|
|000002d0| 20 3d 20 55 50 50 45 52 | 20 28 56 41 4c 55 45 29 | = UPPER| (VALUE)|
|000002e0| 29 00 29 04 05 00 00 00 | 2a 04 02 00 00 00 2b 04 |).).....|*.....+.|
|000002f0| 00 00 00 00 00 02 01 06 | 43 55 53 54 4e 4f 05 00 |........|CUSTNO..|
|00000300| 07 00 08 04 08 00 00 00 | 0a 04 04 00 00 00 09 04 |........|........|
|00000310| 00 00 00 00 0b 04 00 00 | 00 00 14 04 0e 00 00 00 |........|........|
|00000320| 04 31 18 00 00 00 15 08 | 00 e8 03 00 00 4c 24 04 |.1......|.....L$.|
|00000330| 15 00 00 00 43 48 45 43 | 4b 20 28 56 41 4c 55 45 |....CHEC|K (VALUE|
|00000340| 20 3e 20 31 30 30 30 29 | 00 00 02 01 07 4a 4f 42 | > 1000)|.....JOB|
|00000350| 43 4f 44 45 05 00 07 00 | 08 04 25 00 00 00 0a 04 |CODE....|..%.....|
|00000360| 05 00 00 00 09 04 00 00 | 00 00 0b 04 00 00 00 00 |........|........|
|00000370| 14 04 12 00 00 00 04 31 | 18 00 00 00 15 0f 7f 00 |.......1|........|
|00000380| 05 00 39 39 39 39 39 4c | 24 04 18 00 00 00 43 48 |..99999L|$.....CH|
|00000390| 45 43 4b 20 28 56 41 4c | 55 45 20 3e 20 27 39 39 |ECK (VAL|UE > '99|
|000003a0| 39 39 39 27 29 00 29 04 | 05 00 00 00 2a 04 02 00 |999').).|....*...|
|000003b0| 00 00 2b 04 00 00 00 00 | 00 02 01 08 4a 4f 42 47 |..+.....|....JOBG|
|000003c0| 52 41 44 45 05 00 07 00 | 08 04 07 00 00 00 0a 04 |RADE....|........|
|000003d0| 02 00 00 00 09 04 00 00 | 00 00 0b 04 00 00 00 00 |........|........|
|000003e0| 14 04 15 00 00 00 04 38 | 18 00 00 00 15 08 00 00 |.......8|........|
|000003f0| 00 00 00 15 08 00 06 00 | 00 00 4c 24 04 1e 00 00 |........|..L$....|
|00000400| 00 43 48 45 43 4b 20 28 | 56 41 4c 55 45 20 42 45 |.CHECK (|VALUE BE|
|00000410| 54 57 45 45 4e 20 30 20 | 41 4e 44 20 36 29 00 00 |TWEEN 0 |AND 6)..|
|00000420| 02 01 06 53 41 4c 41 52 | 59 05 00 07 00 08 04 1b |...SALAR|Y.......|
|00000430| 00 00 00 0a 04 08 00 00 | 00 09 04 00 00 00 00 0b |........|........|
|00000440| 04 fe ff ff ff 0f 04 09 | 00 00 00 04 15 08 00 00 |........|........|
|00000450| 00 00 00 4c 14 04 0e 00 | 00 00 04 31 18 00 00 00 |...L....|...1....|
|00000460| 15 08 00 00 00 00 00 4c | 24 04 12 00 00 00 43 48 |.......L|$.....CH|
|00000470| 45 43 4b 20 28 56 41 4c | 55 45 20 3e 20 30 29 00 |ECK (VAL|UE > 0).|
|00000480| 27 04 0a 00 00 00 44 45 | 46 41 55 4c 54 20 30 00 |'.....DE|FAULT 0.|
|00000490| 00 02 01 06 42 55 44 47 | 45 54 05 00 07 00 08 04 |....BUDG|ET......|
|000004a0| 1b 00 00 00 0a 04 08 00 | 00 00 09 04 00 00 00 00 |........|........|
|000004b0| 0b 04 fe ff ff ff 0f 04 | 09 00 00 00 04 15 08 00 |........|........|
|000004c0| 50 c3 00 00 4c 14 04 1b | 00 00 00 04 3a 31 18 00 |P...L...|....:1..|
|000004d0| 00 00 15 08 00 10 27 00 | 00 34 18 00 00 00 15 08 |......'.|.4......|
|000004e0| 00 80 84 1e 00 4c 24 04 | 2b 00 00 00 43 48 45 43 |.....L$.|+...CHEC|
|000004f0| 4b 20 28 56 41 4c 55 45 | 20 3e 20 31 30 30 30 30 |K (VALUE| > 10000|
|00000500| 20 41 4e 44 20 56 41 4c | 55 45 20 3c 3d 20 32 30 | AND VAL|UE <= 20|
|00000510| 30 30 30 30 30 29 00 27 | 04 0e 00 00 00 44 45 46 |00000).'|.....DEF|
|00000520| 41 55 4c 54 20 35 30 30 | 30 30 00 00 02 01 08 50 |AULT 500|00.....P|
|00000530| 52 4f 44 54 59 50 45 05 | 00 07 00 08 04 25 00 00 |RODTYPE.|.....%..|
|00000540| 00 0a 04 0c 00 00 00 09 | 04 00 00 00 00 0b 04 00 |........|........|
|00000550| 00 00 00 0f 04 10 00 00 | 00 04 15 0f 7f 00 08 00 |........|........|
|00000560| 73 6f 66 74 77 61 72 65 | 4c 14 04 49 00 00 00 04 |software|L..I....|
|00000570| 39 39 39 2f 18 00 00 00 | 15 0f 7f 00 08 00 73 6f |999/....|......so|
|00000580| 66 74 77 61 72 65 2f 18 | 00 00 00 15 0f 7f 00 08 |ftware/.|........|
|00000590| 00 68 61 72 64 77 61 72 | 65 2f 18 00 00 00 15 0f |.hardwar|e/......|
|000005a0| 7f 00 05 00 6f 74 68 65 | 72 2f 18 00 00 00 15 0f |....othe|r/......|
|000005b0| 7f 00 03 00 4e 2f 41 4c | 24 04 3a 00 00 00 43 48 |....N/AL|$.:...CH|
|000005c0| 45 43 4b 20 28 56 41 4c | 55 45 20 49 4e 20 28 27 |ECK (VAL|UE IN ('|
|000005d0| 73 6f 66 74 77 61 72 65 | 27 2c 20 27 68 61 72 64 |software|', 'hard|
|000005e0| 77 61 72 65 27 2c 20 27 | 6f 74 68 65 72 27 2c 20 |ware', '|other', |
|000005f0| 27 4e 2f 41 27 29 29 00 | 26 04 01 00 00 00 29 04 |'N/A')).|&.....).|
|00000600| 0c 00 00 00 27 04 13 00 | 00 00 44 45 46 41 55 4c |....'...|..DEFAUL|
|00000610| 54 20 27 73 6f 66 74 77 | 61 72 65 27 00 2a 04 15 |T 'softw|are'.*..|
|00000620| 00 00 00 2b 04 00 00 00 | 00 00 02 01 08 50 4f 4e |...+....|.....PON|
|00000630| 55 4d 42 45 52 05 00 07 | 00 08 04 0e 00 00 00 0a |UMBER...|........|
|00000640| 04 08 00 00 00 09 04 00 | 00 00 00 0b 04 00 00 00 |........|........|
|00000650| 00 14 04 0e 00 00 00 04 | 37 18 00 00 00 15 0f 7f |........|7.......|
|00000660| 00 01 00 56 4c 24 04 20 | 00 00 00 43 48 45 43 4b |...VL$. |...CHECK|
|00000670| 20 28 56 41 4c 55 45 20 | 53 54 41 52 54 49 4e 47 | (VALUE |STARTING|
|00000680| 20 57 49 54 48 20 27 56 | 27 29 00 29 04 08 00 00 | WITH 'V|').)....|
|00000690| 00 2a 04 15 00 00 00 2b | 04 00 00 00 00 00 02 01 |.*.....+|........|
|000006a0| 05 52 44 42 24 31 05 00 | 07 00 08 04 25 00 00 00 |.RDB$1..|....%...|
|000006b0| 0a 04 0a 00 00 00 09 04 | 00 00 00 00 0b 04 00 00 |........|........|
|000006c0| 00 00 29 04 0a 00 00 00 | 2a 04 15 00 00 00 00 02 |..).....|*.......|
|000006d0| 01 05 52 44 42 24 32 05 | 00 07 00 08 04 25 00 00 |..RDB$2.|.....%..|
|000006e0| 00 0a 04 19 00 00 00 09 | 04 00 00 00 00 0b 04 00 |........|........|
|000006f0| 00 00 00 29 04 19 00 00 | 00 2a 04 15 00 00 00 00 |...)....|.*......|
|00000700| 02 01 05 52 44 42 24 33 | 05 00 07 00 08 04 05 01 |...RDB$3|........|
|00000710| 00 00 0a 04 08 00 00 00 | 09 04 01 00 00 00 0b 04 |........|........|
|00000720| 00 00 00 00 0c 04 90 01 | 00 00 2a 04 15 00 00 00 |........|..*.....|
|00000730| 00 02 01 05 52 44 42 24 | 34 05 00 07 00 08 04 25 |....RDB$|4......%|
|00000740| 00 00 00 0a 04 0f 00 00 | 00 09 04 00 00 00 00 0b |........|........|
|00000750| 04 00 00 00 00 1d 04 01 | 00 00 00 29 04 0f 00 00 |........|...)....|
|00000760| 00 2a 04 15 00 00 00 00 | 02 01 05 52 44 42 24 35 |.*......|...RDB$5|
|00000770| 05 00 07 00 08 04 25 00 | 00 00 0a 04 19 00 00 00 |......%.|........|
|00000780| 09 04 00 00 00 00 0b 04 | 00 00 00 00 29 04 19 00 |........|....)...|
|00000790| 00 00 2a 04 15 00 00 00 | 00 02 01 05 52 44 42 24 |..*.....|....RDB$|
|000007a0| 36 05 00 07 00 08 04 25 | 00 00 00 0a 04 0f 00 00 |6......%|........|
|000007b0| 00 09 04 00 00 00 00 0b | 04 00 00 00 00 29 04 0f |........|.....)..|
|000007c0| 00 00 00 2a 04 15 00 00 | 00 00 02 01 05 52 44 42 |...*....|.....RDB|
|000007d0| 24 37 05 00 07 00 08 04 | 25 00 00 00 0a 04 04 00 |$7......|%.......|
|000007e0| 00 00 09 04 00 00 00 00 | 0b 04 00 00 00 00 29 04 |........|......).|
|000007f0| 04 00 00 00 2a 04 15 00 | 00 00 00 02 01 05 52 44 |....*...|......RD|
|00000800| 42 24 38 05 00 07 00 08 | 04 23 00 00 00 0a 04 08 |B$8.....|.#......|
|00000810| 00 00 00 09 04 00 00 00 | 00 0b 04 00 00 00 00 00 |........|........|
|00000820| 02 01 05 52 44 42 24 39 | 05 00 07 00 08 04 25 00 |...RDB$9|......%.|
|00000830| 00 00 0a 04 2a 00 00 00 | 09 04 00 00 00 00 0b 04 |....*...|........|
|00000840| 00 00 00 00 12 04 25 00 | 00 00 04 27 27 17 00 09 |......%.|...''...|
|00000850| 4c 41 53 54 5f 4e 41 4d | 45 15 0f 7f 00 02 00 2c |LAST_NAM|E......,|
|00000860| 20 17 00 0a 46 49 52 53 | 54 5f 4e 41 4d 45 4c 25 | ...FIRS|T_NAMEL%|
|00000870| 04 22 00 00 00 28 6c 61 | 73 74 5f 6e 61 6d 65 20 |."...(la|st_name |
|00000880| 7c 7c 20 27 2c 20 27 20 | 7c 7c 20 66 69 72 73 74 ||| ', ' ||| first|
|00000890| 5f 6e 61 6d 65 29 00 29 | 04 00 00 00 00 2a 04 15 |_name).)|.....*..|
|000008a0| 00 00 00 00 02 01 06 52 | 44 42 24 31 30 05 00 07 |.......R|DB$10...|
|000008b0| 00 08 04 25 00 00 00 0a | 04 14 00 00 00 09 04 00 |...%....|........|
|000008c0| 00 00 00 0b 04 00 00 00 | 00 29 04 14 00 00 00 2a |........|.).....*|
|000008d0| 04 15 00 00 00 00 02 01 | 06 52 44 42 24 31 31 05 |........|.RDB$11.|
|000008e0| 00 07 00 08 04 05 01 00 | 00 0a 04 08 00 00 00 09 |........|........|
|000008f0| 04 01 00 00 00 0b 04 00 | 00 00 00 0c 04 20 03 00 |........|..... ..|
|00000900| 00 2a 04 15 00 00 00 00 | 02 01 06 52 44 42 24 31 |.*......|...RDB$1|
|00000910| 32 05 00 07 00 08 04 08 | 00 00 00 0a 04 04 00 00 |2.......|........|
|00000920| 00 09 04 00 00 00 00 0b | 04 00 00 00 00 00 02 01 |........|........|
|00000930| 06 52 44 42 24 31 33 05 | 00 07 00 08 04 08 00 00 |.RDB$13.|........|
|00000940| 00 0a 04 04 00 00 00 09 | 04 00 00 00 00 0b 04 00 |........|........|
|00000950| 00 00 00 1d 04 01 00 00 | 00 00 02 01 06 52 44 42 |........|.....RDB|
|00000960| 24 31 34 05 00 07 00 08 | 04 23 00 00 00 0a 04 08 |$14.....|.#......|
|00000970| 00 00 00 09 04 00 00 00 | 00 0b 04 00 00 00 00 00 |........|........|
|00000980| 02 01 06 52 44 42 24 31 | 35 05 00 07 00 08 04 25 |...RDB$1|5......%|
|00000990| 00 00 00 0a 04 14 00 00 | 00 09 04 00 00 00 00 0b |........|........|
|000009a0| 04 00 00 00 00 29 04 14 | 00 00 00 2a 04 15 00 00 |.....)..|...*....|
|000009b0| 00 00 02 01 06 52 44 42 | 24 31 36 05 00 07 00 08 |.....RDB|$16.....|
|000009c0| 04 1b 00 00 00 0a 04 08 | 00 00 00 09 04 00 00 00 |........|........|
|000009d0| 00 0b 04 00 00 00 00 00 | 02 01 06 52 44 42 24 31 |........|...RDB$1|
|000009e0| 37 05 00 07 00 08 04 1b | 00 00 00 0a 04 08 00 00 |7.......|........|
|000009f0| 00 09 04 00 00 00 00 0b | 04 00 00 00 00 12 04 37 |........|.......7|
|00000a00| 00 00 00 04 22 17 00 0a | 4f 4c 44 5f 53 41 4c 41 |...."...|OLD_SALA|
|00000a10| 52 59 25 24 17 00 0a 4f | 4c 44 5f 53 41 4c 41 52 |RY%$...O|LD_SALAR|
|00000a20| 59 17 00 0e 50 45 52 43 | 45 4e 54 5f 43 48 41 4e |Y...PERC|ENT_CHAN|
|00000a30| 47 45 15 08 00 64 00 00 | 00 4c 25 04 31 00 00 00 |GE...d..|.L%.1...|
|00000a40| 28 6f 6c 64 5f 73 61 6c | 61 72 79 20 2b 20 6f 6c |(old_sal|ary + ol|
|00000a50| 64 5f 73 61 6c 61 72 79 | 20 2a 20 70 65 72 63 65 |d_salary| * perce|
|00000a60| 6e 74 5f 63 68 61 6e 67 | 65 20 2f 20 31 30 30 29 |nt_chang|e / 100)|
|00000a70| 00 00 02 01 06 52 44 42 | 24 31 38 05 00 07 00 08 |.....RDB|$18.....|
|00000a80| 04 25 00 00 00 0a 04 23 | 00 00 00 09 04 00 00 00 |.%.....#|........|
|00000a90| 00 0b 04 00 00 00 00 29 | 04 23 00 00 00 2a 04 15 |.......)|.#...*..|
|00000aa0| 00 00 00 00 02 01 06 52 | 44 42 24 31 39 05 00 07 |.......R|DB$19...|
|00000ab0| 00 08 04 25 00 00 00 0a | 04 19 00 00 00 09 04 00 |...%....|........|
|00000ac0| 00 00 00 0b 04 00 00 00 | 00 29 04 19 00 00 00 2a |........|.).....*|
|00000ad0| 04 15 00 00 00 00 02 01 | 06 52 44 42 24 32 30 05 |........|.RDB$20.|
|00000ae0| 00 07 00 08 04 25 00 00 | 00 0a 04 0f 00 00 00 09 |.....%..|........|
|00000af0| 04 00 00 00 00 0b 04 00 | 00 00 00 29 04 0f 00 00 |........|...)....|
|00000b00| 00 2a 04 15 00 00 00 00 | 02 01 06 52 44 42 24 32 |.*......|...RDB$2|
|00000b10| 31 05 00 07 00 08 04 25 | 00 00 00 0a 04 0c 00 00 |1......%|........|
|00000b20| 00 09 04 00 00 00 00 0b | 04 00 00 00 00 29 04 0c |........|.....)..|
|00000b30| 00 00 00 2a 04 15 00 00 | 00 00 02 01 06 52 44 42 |...*....|.....RDB|
|00000b40| 24 32 32 05 00 07 00 08 | 04 0e 00 00 00 0a 04 01 |$22.....|........|
|00000b50| 00 00 00 09 04 00 00 00 | 00 0b 04 00 00 00 00 29 |........|.......)|
|00000b60| 04 01 00 00 00 2a 04 15 | 00 00 00 00 02 01 06 52 |.....*..|.......R|
|00000b70| 44 42 24 32 33 05 00 07 | 00 08 04 25 00 00 00 0a |DB$23...|...%....|
|00000b80| 04 07 00 00 00 09 04 00 | 00 00 00 0b 04 00 00 00 |........|........|
|00000b90| 00 29 04 07 00 00 00 2a | 04 15 00 00 00 00 02 01 |.).....*|........|
|00000ba0| 06 52 44 42 24 32 34 05 | 00 07 00 08 04 23 00 00 |.RDB$24.|.....#..|
|00000bb0| 00 0a 04 08 00 00 00 09 | 04 00 00 00 00 0b 04 00 |........|........|
|00000bc0| 00 00 00 00 02 01 06 52 | 44 42 24 32 35 05 00 07 |.......R|DB$25...|
|00000bd0| 00 08 04 23 00 00 00 0a | 04 08 00 00 00 09 04 00 |...#....|........|
|00000be0| 00 00 00 0b 04 00 00 00 | 00 00 02 01 06 52 44 42 |........|.....RDB|
|00000bf0| 24 32 36 05 00 07 00 08 | 04 23 00 00 00 0a 04 08 |$26.....|.#......|
|00000c00| 00 00 00 09 04 00 00 00 | 00 0b 04 00 00 00 00 00 |........|........|
|00000c10| 02 01 06 52 44 42 24 32 | 37 05 00 07 00 08 04 0e |...RDB$2|7.......|
|00000c20| 00 00 00 0a 04 01 00 00 | 00 09 04 00 00 00 00 0b |........|........|
|00000c30| 04 00 00 00 00 29 04 01 | 00 00 00 2a 04 15 00 00 |.....)..|...*....|
|00000c40| 00 00 02 01 06 52 44 42 | 24 32 38 05 00 07 00 08 |.....RDB|$28.....|
|00000c50| 04 08 00 00 00 0a 04 04 | 00 00 00 09 04 00 00 00 |........|........|
|00000c60| 00 0b 04 00 00 00 00 00 | 02 01 06 52 44 42 24 32 |........|...RDB$2|
|00000c70| 39 05 00 07 00 08 04 08 | 00 00 00 0a 04 04 00 00 |9.......|........|
|00000c80| 00 09 04 00 00 00 00 0b | 04 fe ff ff ff 00 02 01 |........|........|
|00000c90| 06 52 44 42 24 33 30 05 | 00 07 00 08 04 0a 00 00 |.RDB$30.|........|
|00000ca0| 00 0a 04 04 00 00 00 09 | 04 00 00 00 00 0b 04 00 |........|........|
|00000cb0| 00 00 00 00 02 01 06 52 | 44 42 24 33 31 05 00 07 |.......R|DB$31...|
|00000cc0| 00 08 04 1b 00 00 00 0a | 04 08 00 00 00 09 04 00 |........|........|
|00000cd0| 00 00 00 0b 04 00 00 00 | 00 12 04 1c 00 00 00 04 |........|........|
|00000ce0| 23 17 00 09 53 48 49 50 | 5f 44 41 54 45 17 00 0a |#...SHIP|_DATE...|
|00000cf0| 4f 52 44 45 52 5f 44 41 | 54 45 4c 25 04 19 00 00 |ORDER_DA|TEL%....|
|00000d00| 00 28 73 68 69 70 5f 64 | 61 74 65 20 2d 20 6f 72 |.(ship_d|ate - or|
|00000d10| 64 65 72 5f 64 61 74 65 | 29 00 00 02 01 06 52 44 |der_date|).....RD|
|00000d20| 42 24 33 32 05 00 07 00 | 08 04 07 00 00 00 0a 04 |B$32....|........|
|00000d30| 02 00 00 00 09 04 00 00 | 00 00 0b 04 00 00 00 00 |........|........|
|00000d40| 00 02 01 06 52 44 42 24 | 33 33 05 00 07 00 08 04 |....RDB$|33......|
|00000d50| 0e 00 00 00 0a 04 05 00 | 00 00 09 04 00 00 00 00 |........|........|
|00000d60| 0b 04 00 00 00 00 29 04 | 05 00 00 00 2a 04 15 00 |......).|....*...|
|00000d70| 00 00 2b 04 00 00 00 00 | 00 02 01 06 52 44 42 24 |..+.....|....RDB$|
|00000d80| 33 34 05 00 07 00 08 04 | 07 00 00 00 0a 04 02 00 |34......|........|
|00000d90| 00 00 09 04 00 00 00 00 | 0b 04 00 00 00 00 00 02 |........|........|
|00000da0| 01 06 52 44 42 24 33 35 | 05 00 07 00 08 04 0e 00 |..RDB$35|........|
|00000db0| 00 00 0a 04 05 00 00 00 | 09 04 00 00 00 00 0b 04 |........|........|
|00000dc0| 00 00 00 00 29 04 05 00 | 00 00 2a 04 15 00 00 00 |....)...|..*.....|
|00000dd0| 2b 04 00 00 00 00 00 02 | 01 06 52 44 42 24 33 36 |+.......|..RDB$36|
|00000de0| 05 00 07 00 08 04 0e 00 | 00 00 0a 04 03 00 00 00 |........|........|
|00000df0| 09 04 00 00 00 00 0b 04 | 00 00 00 00 29 04 03 00 |........|....)...|
|00000e00| 00 00 2a 04 15 00 00 00 | 2b 04 00 00 00 00 00 02 |..*.....|+.......|
|00000e10| 01 06 52 44 42 24 33 37 | 05 00 07 00 08 04 1b 00 |..RDB$37|........|
|00000e20| 00 00 0a 04 08 00 00 00 | 09 04 00 00 00 00 0b 04 |........|........|
|00000e30| fe ff ff ff 00 02 01 06 | 52 44 42 24 33 38 05 00 |........|RDB$38..|
|00000e40| 07 00 08 04 1b 00 00 00 | 0a 04 08 00 00 00 09 04 |........|........|
|00000e50| 00 00 00 00 0b 04 fe ff | ff ff 00 02 01 06 52 44 |........|......RD|
|00000e60| 42 24 33 39 05 00 07 00 | 08 04 1b 00 00 00 0a 04 |B$39....|........|
|00000e70| 08 00 00 00 09 04 00 00 | 00 00 0b 04 fe ff ff ff |........|........|
|00000e80| 00 02 01 06 52 44 42 24 | 34 30 05 00 07 00 08 04 |....RDB$|40......|
|00000e90| 1b 00 00 00 0a 04 08 00 | 00 00 09 04 00 00 00 00 |........|........|
|00000ea0| 0b 04 fe ff ff ff 00 02 | 01 06 52 44 42 24 34 31 |........|..RDB$41|
|00000eb0| 05 00 07 00 08 04 08 00 | 00 00 0a 04 04 00 00 00 |........|........|
|00000ec0| 09 04 00 00 00 00 0b 04 | 00 00 00 00 00 02 01 06 |........|........|
|00000ed0| 52 44 42 24 34 32 05 00 | 07 00 08 04 0e 00 00 00 |RDB$42..|........|
|00000ee0| 0a 04 03 00 00 00 09 04 | 00 00 00 00 0b 04 00 00 |........|........|
|00000ef0| 00 00 29 04 03 00 00 00 | 2a 04 15 00 00 00 2b 04 |..).....|*.....+.|
|00000f00| 00 00 00 00 00 02 01 06 | 52 44 42 24 34 33 05 00 |........|RDB$43..|
|00000f10| 07 00 08 04 1b 00 00 00 | 0a 04 08 00 00 00 09 04 |........|........|
|00000f20| 00 00 00 00 0b 04 fe ff | ff ff 00 02 01 06 52 44 |........|......RD|
|00000f30| 42 24 34 34 05 00 07 00 | 08 04 0e 00 00 00 0a 04 |B$44....|........|
|00000f40| 19 00 00 00 09 04 00 00 | 00 00 0b 04 00 00 00 00 |........|........|
|00000f50| 29 04 19 00 00 00 2a 04 | 15 00 00 00 2b 04 00 00 |).....*.|....+...|
|00000f60| 00 00 00 02 01 06 52 44 | 42 24 34 35 05 00 07 00 |......RD|B$45....|
|00000f70| 08 04 0e 00 00 00 0a 04 | 19 00 00 00 09 04 00 00 |........|........|
|00000f80| 00 00 0b 04 00 00 00 00 | 29 04 19 00 00 00 2a 04 |........|).....*.|
|00000f90| 15 00 00 00 2b 04 00 00 | 00 00 00 02 01 06 52 44 |....+...|......RD|
|00000fa0| 42 24 34 36 05 00 07 00 | 08 04 0e 00 00 00 0a 04 |B$46....|........|
|00000fb0| 14 00 00 00 09 04 00 00 | 00 00 0b 04 00 00 00 00 |........|........|
|00000fc0| 29 04 14 00 00 00 2a 04 | 15 00 00 00 2b 04 00 00 |).....*.|....+...|
|00000fd0| 00 00 00 02 01 06 52 44 | 42 24 34 37 05 00 07 00 |......RD|B$47....|
|00000fe0| 08 04 0e 00 00 00 0a 04 | 05 00 00 00 09 04 00 00 |........|........|
|00000ff0| 00 00 0b 04 00 00 00 00 | 29 04 05 00 00 00 2a 04 |........|).....*.|
|00001000| 15 00 00 00 2b 04 00 00 | 00 00 00 02 01 06 52 44 |....+...|......RD|
|00001010| 42 24 34 38 05 00 07 00 | 08 04 08 00 00 00 0a 04 |B$48....|........|
|00001020| 04 00 00 00 09 04 00 00 | 00 00 0b 04 00 00 00 00 |........|........|
|00001030| 00 02 01 06 52 44 42 24 | 34 39 05 00 07 00 08 04 |....RDB$|49......|
|00001040| 08 00 00 00 0a 04 04 00 | 00 00 09 04 00 00 00 00 |........|........|
|00001050| 0b 04 00 00 00 00 00 02 | 01 06 52 44 42 24 35 30 |........|..RDB$50|
|00001060| 05 00 07 00 08 04 0e 00 | 00 00 0a 04 28 00 00 00 |........|....(...|
|00001070| 09 04 00 00 00 00 0b 04 | 00 00 00 00 29 04 28 00 |........|....).(.|
|00001080| 00 00 2a 04 15 00 00 00 | 2b 04 00 00 00 00 00 02 |..*.....|+.......|
|00001090| 01 06 52 44 42 24 35 31 | 05 00 07 00 08 04 0e 00 |..RDB$51|........|
|000010a0| 00 00 0a 04 28 00 00 00 | 09 04 00 00 00 00 0b 04 |....(...|........|
|000010b0| 00 00 00 00 29 04 28 00 | 00 00 2a 04 15 00 00 00 |....).(.|..*.....|
|000010c0| 2b 04 00 00 00 00 00 02 | 01 06 52 44 42 24 35 32 |+.......|..RDB$52|
|000010d0| 05 00 07 00 08 04 0e 00 | 00 00 0a 04 28 00 00 00 |........|....(...|
|000010e0| 09 04 00 00 00 00 0b 04 | 00 00 00 00 29 04 28 00 |........|....).(.|
|000010f0| 00 00 2a 04 15 00 00 00 | 2b 04 00 00 00 00 00 02 |..*.....|+.......|
|00001100| 01 06 52 44 42 24 35 33 | 05 00 07 00 08 04 0e 00 |..RDB$53|........|
|00001110| 00 00 0a 04 28 00 00 00 | 09 04 00 00 00 00 0b 04 |....(...|........|
|00001120| 00 00 00 00 29 04 28 00 | 00 00 2a 04 15 00 00 00 |....).(.|..*.....|
|00001130| 2b 04 00 00 00 00 00 02 | 01 06 52 44 42 24 35 34 |+.......|..RDB$54|
|00001140| 05 00 07 00 08 04 0e 00 | 00 00 0a 04 28 00 00 00 |........|....(...|
|00001150| 09 04 00 00 00 00 0b 04 | 00 00 00 00 29 04 28 00 |........|....).(.|
|00001160| 00 00 2a 04 15 00 00 00 | 2b 04 00 00 00 00 00 02 |..*.....|+.......|
|00001170| 01 06 52 44 42 24 35 35 | 05 00 07 00 08 04 0e 00 |..RDB$55|........|
|00001180| 00 00 0a 04 28 00 00 00 | 09 04 00 00 00 00 0b 04 |....(...|........|
|00001190| 00 00 00 00 29 04 28 00 | 00 00 2a 04 15 00 00 00 |....).(.|..*.....|
|000011a0| 2b 04 00 00 00 00 00 02 | 01 06 52 44 42 24 35 36 |+.......|..RDB$56|
|000011b0| 05 00 07 00 08 04 0e 00 | 00 00 0a 04 08 00 00 00 |........|........|
|000011c0| 09 04 00 00 00 00 0b 04 | 00 00 00 00 29 04 08 00 |........|....)...|
|000011d0| 00 00 2a 04 15 00 00 00 | 2b 04 00 00 00 00 00 02 |..*.....|+.......|
|000011e0| 01 06 52 44 42 24 35 37 | 05 00 07 00 08 04 25 00 |..RDB$57|......%.|
|000011f0| 00 00 0a 04 05 00 00 00 | 09 04 00 00 00 00 0b 04 |........|........|
|00001200| 00 00 00 00 29 04 05 00 | 00 00 2a 04 15 00 00 00 |....)...|..*.....|
|00001210| 2b 04 00 00 00 00 00 02 | 01 06 52 44 42 24 35 38 |+.......|..RDB$58|
|00001220| 05 00 07 00 08 04 07 00 | 00 00 0a 04 02 00 00 00 |........|........|
|00001230| 09 04 00 00 00 00 0b 04 | 00 00 00 00 00 02 01 06 |........|........|
|00001240| 52 44 42 24 35 39 05 00 | 07 00 08 04 25 00 00 00 |RDB$59..|....%...|
|00001250| 0a 04 0f 00 00 00 09 04 | 00 00 00 00 0b 04 00 00 |........|........|
|00001260| 00 00 29 04 0f 00 00 00 | 2a 04 15 00 00 00 2b 04 |..).....|*.....+.|
|00001270| 00 00 00 00 00 02 01 06 | 52 44 42 24 36 30 05 00 |........|RDB$60..|
|00001280| 07 00 08 04 25 00 00 00 | 0a 04 0f 00 00 00 09 04 |....%...|........|
|00001290| 00 00 00 00 0b 04 00 00 | 00 00 29 04 0f 00 00 00 |........|..).....|
|000012a0| 2a 04 15 00 00 00 2b 04 | 00 00 00 00 00 02 01 06 |*.....+.|........|
|000012b0| 52 44 42 24 36 31 05 00 | 07 00 08 04 25 00 00 00 |RDB$61..|....%...|
|000012c0| 0a 04 05 00 00 00 09 04 | 00 00 00 00 0b 04 00 00 |........|........|
|000012d0| 00 00 29 04 05 00 00 00 | 2a 04 15 00 00 00 2b 04 |..).....|*.....+.|
|000012e0| 00 00 00 00 00 02 01 06 | 52 44 42 24 36 32 05 00 |........|RDB$62..|
|000012f0| 07 00 08 04 25 00 00 00 | 0a 04 05 00 00 00 09 04 |....%...|........|
|00001300| 00 00 00 00 0b 04 00 00 | 00 00 29 04 05 00 00 00 |........|..).....|
|00001310| 2a 04 15 00 00 00 2b 04 | 00 00 00 00 00 02 01 06 |*.....+.|........|
|00001320| 52 44 42 24 36 33 05 00 | 07 00 08 04 25 00 00 00 |RDB$63..|....%...|
|00001330| 0a 04 0f 00 00 00 09 04 | 00 00 00 00 0b 04 00 00 |........|........|
|00001340| 00 00 29 04 0f 00 00 00 | 2a 04 15 00 00 00 2b 04 |..).....|*.....+.|
|00001350| 00 00 00 00 00 02 01 06 | 52 44 42 24 36 34 05 00 |........|RDB$64..|
|00001360| 07 00 08 04 25 00 00 00 | 0a 04 0f 00 00 00 09 04 |....%...|........|
|00001370| 00 00 00 00 0b 04 00 00 | 00 00 29 04 0f 00 00 00 |........|..).....|
|00001380| 2a 04 15 00 00 00 2b 04 | 00 00 00 00 00 02 01 06 |*.....+.|........|
|00001390| 52 44 42 24 36 35 05 00 | 07 00 08 04 25 00 00 00 |RDB$65..|....%...|
|000013a0| 0a 04 28 00 00 00 09 04 | 00 00 00 00 0b 04 00 00 |..(.....|........|
|000013b0| 00 00 29 04 28 00 00 00 | 2a 04 15 00 00 00 2b 04 |..).(...|*.....+.|
|000013c0| 00 00 00 00 00 02 01 06 | 52 44 42 24 36 36 05 00 |........|RDB$66..|
|000013d0| 07 00 08 04 25 00 00 00 | 0a 04 19 00 00 00 09 04 |....%...|........|
|000013e0| 00 00 00 00 0b 04 00 00 | 00 00 29 04 19 00 00 00 |........|..).....|
|000013f0| 2a 04 15 00 00 00 2b 04 | 00 00 00 00 00 02 01 06 |*.....+.|........|
|00001400| 52 44 42 24 36 37 05 00 | 07 00 08 04 25 00 00 00 |RDB$67..|....%...|
|00001410| 0a 04 0f 00 00 00 09 04 | 00 00 00 00 0b 04 00 00 |........|........|
|00001420| 00 00 29 04 0f 00 00 00 | 2a 04 15 00 00 00 2b 04 |..).....|*.....+.|
|00001430| 00 00 00 00 00 02 01 06 | 52 44 42 24 36 38 05 00 |........|RDB$68..|
|00001440| 07 00 08 04 25 00 00 00 | 0a 04 28 00 00 00 09 04 |....%...|..(.....|
|00001450| 00 00 00 00 0b 04 00 00 | 00 00 29 04 28 00 00 00 |........|..).(...|
|00001460| 2a 04 15 00 00 00 2b 04 | 00 00 00 00 00 02 01 06 |*.....+.|........|
|00001470| 52 44 42 24 36 39 05 00 | 07 00 08 04 25 00 00 00 |RDB$69..|....%...|
|00001480| 0a 04 19 00 00 00 09 04 | 00 00 00 00 0b 04 00 00 |........|........|
|00001490| 00 00 29 04 19 00 00 00 | 2a 04 15 00 00 00 2b 04 |..).....|*.....+.|
|000014a0| 00 00 00 00 00 02 01 06 | 52 44 42 24 37 30 05 00 |........|RDB$70..|
|000014b0| 07 00 08 04 25 00 00 00 | 0a 04 0f 00 00 00 09 04 |....%...|........|
|000014c0| 00 00 00 00 0b 04 00 00 | 00 00 29 04 0f 00 00 00 |........|..).....|
|000014d0| 2a 04 15 00 00 00 2b 04 | 00 00 00 00 00 02 01 06 |*.....+.|........|
|000014e0| 52 44 42 24 37 31 05 00 | 07 00 08 04 25 00 00 00 |RDB$71..|....%...|
|000014f0| 0a 04 28 00 00 00 09 04 | 00 00 00 00 0b 04 00 00 |..(.....|........|
|00001500| 00 00 29 04 28 00 00 00 | 2a 04 15 00 00 00 2b 04 |..).(...|*.....+.|
|00001510| 00 00 00 00 00 02 01 06 | 52 44 42 24 37 32 05 00 |........|RDB$72..|
|00001520| 07 00 08 04 25 00 00 00 | 0a 04 19 00 00 00 09 04 |....%...|........|
|00001530| 00 00 00 00 0b 04 00 00 | 00 00 29 04 19 00 00 00 |........|..).....|
|00001540| 2a 04 15 00 00 00 2b 04 | 00 00 00 00 00 02 01 06 |*.....+.|........|
|00001550| 52 44 42 24 37 33 05 00 | 07 00 08 04 25 00 00 00 |RDB$73..|....%...|
|00001560| 0a 04 0f 00 00 00 09 04 | 00 00 00 00 0b 04 00 00 |........|........|
|00001570| 00 00 29 04 0f 00 00 00 | 2a 04 15 00 00 00 2b 04 |..).....|*.....+.|
|00001580| 00 00 00 00 00 18 01 05 | 52 44 42 24 34 1d 04 00 |........|RDB$4...|
|00001590| 00 00 00 20 04 01 00 00 | 00 21 04 05 00 00 00 00 |... ....|.!......|
|000015a0| 18 01 06 52 44 42 24 31 | 33 1d 04 00 00 00 00 20 |...RDB$1|3...... |
|000015b0| 04 01 00 00 00 21 04 04 | 00 00 00 00 03 01 07 43 |.....!..|.......C|
|000015c0| 4f 55 4e 54 52 59 10 04 | 01 00 00 00 08 0b 53 51 |OUNTRY..|......SQ|
|000015d0| 4c 24 43 4f 55 4e 54 52 | 59 0c 06 53 59 53 44 42 |L$COUNTR|Y..SYSDB|
|000015e0| 41 00 04 01 08 43 55 52 | 52 45 4e 43 59 02 05 52 |A....CUR|RENCY..R|
|000015f0| 44 42 24 31 0d 04 01 00 | 00 00 08 04 25 00 00 00 |DB$1....|....%...|
|00001600| 0a 04 0a 00 00 00 09 04 | 00 00 00 00 0b 04 00 00 |........|........|
|00001610| 00 00 16 04 02 00 00 00 | 18 04 00 00 00 00 22 04 |........|......".|
|00001620| 01 00 00 00 26 04 01 00 | 00 00 2a 04 15 00 00 00 |....&...|..*.....|
|00001630| 2b 04 00 00 00 00 00 04 | 01 07 43 4f 55 4e 54 52 |+.......|..COUNTR|
|00001640| 59 02 0b 43 4f 55 4e 54 | 52 59 4e 41 4d 45 0d 04 |Y..COUNT|RYNAME..|
|00001650| 00 00 00 00 08 04 25 00 | 00 00 0a 04 0f 00 00 00 |......%.|........|
|00001660| 09 04 00 00 00 00 0b 04 | 00 00 00 00 16 04 01 00 |........|........|
|00001670| 00 00 18 04 00 00 00 00 | 22 04 01 00 00 00 26 04 |........|".....&.|
|00001680| 01 00 00 00 2a 04 15 00 | 00 00 00 09 03 01 03 4a |....*...|.......J|
|00001690| 4f 42 10 04 01 00 00 00 | 08 07 53 51 4c 24 4a 4f |OB......|..SQL$JO|
|000016a0| 42 0c 06 53 59 53 44 42 | 41 00 04 01 0f 4a 4f 42 |B..SYSDB|A....JOB|
|000016b0| 5f 52 45 51 55 49 52 45 | 4d 45 4e 54 02 05 52 44 |_REQUIRE|MENT..RD|
|000016c0| 42 24 33 0d 04 06 00 00 | 00 08 04 05 01 00 00 0a |B$3.....|........|
|000016d0| 04 08 00 00 00 09 04 01 | 00 00 00 0b 04 00 00 00 |........|........|
|000016e0| 00 16 04 07 00 00 00 18 | 04 00 00 00 00 22 04 01 |........|....."..|
|000016f0| 00 00 00 2a 04 15 00 00 | 00 00 04 01 0a 4d 41 58 |...*....|.....MAX|
|00001700| 5f 53 41 4c 41 52 59 02 | 06 53 41 4c 41 52 59 0d |_SALARY.|.SALARY.|
|00001710| 04 05 00 00 00 08 04 1b | 00 00 00 0a 04 08 00 00 |........|........|
|00001720| 00 09 04 00 00 00 00 0b | 04 fe ff ff ff 16 04 06 |........|........|
|00001730| 00 00 00 18 04 00 00 00 | 00 22 04 01 00 00 00 26 |........|.".....&|
|00001740| 04 01 00 00 00 00 04 01 | 0a 4d 49 4e 5f 53 41 4c |........|.MIN_SAL|
|00001750| 41 52 59 02 06 53 41 4c | 41 52 59 0d 04 04 00 00 |ARY..SAL|ARY.....|
|00001760| 00 08 04 1b 00 00 00 0a | 04 08 00 00 00 09 04 00 |........|........|
|00001770| 00 00 00 0b 04 fe ff ff | ff 16 04 05 00 00 00 18 |........|........|
|00001780| 04 00 00 00 00 22 04 01 | 00 00 00 26 04 01 00 00 |....."..|...&....|
|00001790| 00 00 04 01 09 4a 4f 42 | 5f 47 52 41 44 45 02 08 |.....JOB|_GRADE..|
|000017a0| 4a 4f 42 47 52 41 44 45 | 0d 04 01 00 00 00 08 04 |JOBGRADE|........|
|000017b0| 07 00 00 00 0a 04 02 00 | 00 00 09 04 00 00 00 00 |........|........|
|000017c0| 0b 04 00 00 00 00 16 04 | 02 00 00 00 18 04 00 00 |........|........|
|000017d0| 00 00 22 04 01 00 00 00 | 26 04 01 00 00 00 00 04 |..".....|&.......|
|000017e0| 01 0c 4c 41 4e 47 55 41 | 47 45 5f 52 45 51 02 05 |..LANGUA|GE_REQ..|
|000017f0| 52 44 42 24 34 0d 04 07 | 00 00 00 08 04 25 00 00 |RDB$4...|.....%..|
|00001800| 00 0a 04 0f 00 00 00 09 | 04 00 00 00 00 0b 04 00 |........|........|
|00001810| 00 00 00 16 04 08 00 00 | 00 18 04 00 00 00 00 22 |........|......."|
|00001820| 04 01 00 00 00 2a 04 15 | 00 00 00 2b 04 00 00 00 |.....*..|...+....|
|00001830| 00 1d 04 01 00 00 00 20 | 04 01 00 00 00 21 04 05 |....... |.....!..|
|00001840| 00 00 00 00 04 01 09 4a | 4f 42 5f 54 49 54 4c 45 |.......J|OB_TITLE|
|00001850| 02 05 52 44 42 24 32 0d | 04 03 00 00 00 08 04 25 |..RDB$2.|.......%|
|00001860| 00 00 00 0a 04 19 00 00 | 00 09 04 00 00 00 00 0b |........|........|
|00001870| 04 00 00 00 00 16 04 04 | 00 00 00 18 04 00 00 00 |........|........|
|00001880| 00 22 04 01 00 00 00 26 | 04 01 00 00 00 2a 04 15 |.".....&|.....*..|
|00001890| 00 00 00 2b 04 00 00 00 | 00 00 04 01 0b 4a 4f 42 |...+....|.....JOB|
|000018a0| 5f 43 4f 55 4e 54 52 59 | 02 0b 43 4f 55 4e 54 52 |_COUNTRY|..COUNTR|
|000018b0| 59 4e 41 4d 45 0d 04 02 | 00 00 00 08 04 25 00 00 |YNAME...|.....%..|
|000018c0| 00 0a 04 0f 00 00 00 09 | 04 00 00 00 00 0b 04 00 |........|........|
|000018d0| 00 00 00 16 04 03 00 00 | 00 18 04 00 00 00 00 22 |........|......."|
|000018e0| 04 01 00 00 00 26 04 01 | 00 00 00 2a 04 15 00 00 |.....&..|...*....|
|000018f0| 00 00 04 01 08 4a 4f 42 | 5f 43 4f 44 45 02 07 4a |.....JOB|_CODE..J|
|00001900| 4f 42 43 4f 44 45 0d 04 | 00 00 00 00 08 04 25 00 |OBCODE..|......%.|
|00001910| 00 00 0a 04 05 00 00 00 | 09 04 00 00 00 00 0b 04 |........|........|
|00001920| 00 00 00 00 16 04 01 00 | 00 00 18 04 00 00 00 00 |........|........|
|00001930| 22 04 01 00 00 00 26 04 | 01 00 00 00 2a 04 02 00 |".....&.|....*...|
|00001940| 00 00 00 09 03 01 0a 44 | 45 50 41 52 54 4d 45 4e |.......D|EPARTMEN|
|00001950| 54 10 04 01 00 00 00 08 | 0e 53 51 4c 24 44 45 50 |T.......|.SQL$DEP|
|00001960| 41 52 54 4d 45 4e 54 0c | 06 53 59 53 44 42 41 00 |ARTMENT.|.SYSDBA.|
|00001970| 04 01 06 42 55 44 47 45 | 54 02 06 42 55 44 47 45 |...BUDGE|T..BUDGE|
|00001980| 54 0d 04 04 00 00 00 08 | 04 1b 00 00 00 0a 04 08 |T.......|........|
|00001990| 00 00 00 09 04 00 00 00 | 00 0b 04 fe ff ff ff 16 |........|........|
|000019a0| 04 05 00 00 00 18 04 00 | 00 00 00 22 04 01 00 00 |........|..."....|
|000019b0| 00 00 04 01 08 50 48 4f | 4e 45 5f 4e 4f 02 0b 50 |.....PHO|NE_NO..P|
|000019c0| 48 4f 4e 45 4e 55 4d 42 | 45 52 0d 04 06 00 00 00 |HONENUMB|ER......|
|000019d0| 08 04 25 00 00 00 0a 04 | 14 00 00 00 09 04 00 00 |..%.....|........|
|000019e0| 00 00 0b 04 00 00 00 00 | 16 04 07 00 00 00 18 04 |........|........|
|000019f0| 00 00 00 00 22 04 01 00 | 00 00 2a 04 15 00 00 00 |...."...|..*.....|
|00001a00| 0f 04 10 00 00 00 04 15 | 0f 7f 00 08 00 35 35 35 |........|.....555|
|00001a10| 2d 31 32 33 34 4c 27 04 | 14 00 00 00 20 44 45 46 |-1234L'.|.... DEF|
|00001a20| 41 55 4c 54 20 27 35 35 | 35 2d 31 32 33 34 27 00 |AULT '55|5-1234'.|
|00001a30| 00 04 01 07 4d 4e 47 52 | 5f 4e 4f 02 05 45 4d 50 |....MNGR|_NO..EMP|
|00001a40| 4e 4f 0d 04 03 00 00 00 | 08 04 07 00 00 00 0a 04 |NO......|........|
|00001a50| 02 00 00 00 09 04 00 00 | 00 00 0b 04 00 00 00 00 |........|........|
|00001a60| 16 04 04 00 00 00 18 04 | 00 00 00 00 22 04 01 00 |........|...."...|
|00001a70| 00 00 00 04 01 08 4c 4f | 43 41 54 49 4f 4e 02 05 |......LO|CATION..|
|00001a80| 52 44 42 24 36 0d 04 05 | 00 00 00 08 04 25 00 00 |RDB$6...|.....%..|
|00001a90| 00 0a 04 0f 00 00 00 09 | 04 00 00 00 00 0b 04 00 |........|........|
|00001aa0| 00 00 00 16 04 06 00 00 | 00 18 04 00 00 00 00 22 |........|......."|
|00001ab0| 04 01 00 00 00 2a 04 15 | 00 00 00 2b 04 00 00 00 |.....*..|...+....|
|00001ac0| 00 00 04 01 09 48 45 41 | 44 5f 44 45 50 54 02 06 |.....HEA|D_DEPT..|
|00001ad0| 44 45 50 54 4e 4f 0d 04 | 02 00 00 00 08 04 0e 00 |DEPTNO..|........|
|00001ae0| 00 00 0a 04 03 00 00 00 | 09 04 00 00 00 00 0b 04 |........|........|
|00001af0| 00 00 00 00 16 04 03 00 | 00 00 18 04 00 00 00 00 |........|........|
|00001b00| 22 04 01 00 00 00 2a 04 | 02 00 00 00 00 04 01 0a |".....*.|........|
|00001b10| 44 45 50 41 52 54 4d 45 | 4e 54 02 05 52 44 42 24 |DEPARTME|NT..RDB$|
|00001b20| 35 0d 04 01 00 00 00 08 | 04 25 00 00 00 0a 04 19 |5.......|.%......|
|00001b30| 00 00 00 09 04 00 00 00 | 00 0b 04 00 00 00 00 16 |........|........|
|00001b40| 04 02 00 00 00 18 04 00 | 00 00 00 22 04 01 00 00 |........|..."....|
|00001b50| 00 26 04 01 00 00 00 2a | 04 15 00 00 00 2b 04 00 |.&.....*|.....+..|
|00001b60| 00 00 00 00 04 01 07 44 | 45 50 54 5f 4e 4f 02 06 |.......D|EPT_NO..|
|00001b70| 44 45 50 54 4e 4f 0d 04 | 00 00 00 00 08 04 0e 00 |DEPTNO..|........|
|00001b80| 00 00 0a 04 03 00 00 00 | 09 04 00 00 00 00 0b 04 |........|........|
|00001b90| 00 00 00 00 16 04 01 00 | 00 00 18 04 00 00 00 00 |........|........|
|00001ba0| 22 04 01 00 00 00 26 04 | 01 00 00 00 2a 04 02 00 |".....&.|....*...|
|00001bb0| 00 00 00 09 03 01 08 45 | 4d 50 4c 4f 59 45 45 10 |.......E|MPLOYEE.|
|00001bc0| 04 01 00 00 00 08 0c 53 | 51 4c 24 45 4d 50 4c 4f |.......S|QL$EMPLO|
|00001bd0| 59 45 45 0c 06 53 59 53 | 44 42 41 00 04 01 06 53 |YEE..SYS|DBA....S|
|00001be0| 41 4c 41 52 59 02 06 53 | 41 4c 41 52 59 0d 04 09 |ALARY..S|ALARY...|
|00001bf0| 00 00 00 08 04 1b 00 00 | 00 0a 04 08 00 00 00 09 |........|........|
|00001c00| 04 00 00 00 00 0b 04 fe | ff ff ff 16 04 0a 00 00 |........|........|
|00001c10| 00 18 04 00 00 00 00 22 | 04 01 00 00 00 26 04 01 |......."|.....&..|
|00001c20| 00 00 00 00 04 01 09 48 | 49 52 45 5f 44 41 54 45 |.......H|IRE_DATE|
|00001c30| 02 05 52 44 42 24 38 0d | 04 04 00 00 00 08 04 23 |..RDB$8.|.......#|
|00001c40| 00 00 00 0a 04 08 00 00 | 00 09 04 00 00 00 00 0b |........|........|
|00001c50| 04 00 00 00 00 16 04 05 | 00 00 00 18 04 00 00 00 |........|........|
|00001c60| 00 22 04 01 00 00 00 26 | 04 01 00 00 00 0f 04 0b |.".....&|........|
|00001c70| 00 00 00 04 15 0f 7f 00 | 03 00 4e 4f 57 4c 27 04 |........|..NOWL'.|
|00001c80| 0e 00 00 00 44 45 46 41 | 55 4c 54 20 27 4e 4f 57 |....DEFA|ULT 'NOW|
|00001c90| 27 00 00 04 01 09 46 55 | 4c 4c 5f 4e 41 4d 45 02 |'.....FU|LL_NAME.|
|00001ca0| 05 52 44 42 24 39 0d 04 | 0a 00 00 00 08 04 25 00 |.RDB$9..|......%.|
|00001cb0| 00 00 0a 04 2a 00 00 00 | 09 04 00 00 00 00 0b 04 |....*...|........|
|00001cc0| 00 00 00 00 16 04 0b 00 | 00 00 18 04 00 00 00 00 |........|........|
|00001cd0| 22 04 00 00 00 00 2a 04 | 15 00 00 00 2b 04 00 00 |".....*.|....+...|
|00001ce0| 00 00 17 04 01 00 00 00 | 00 04 01 09 4a 4f 42 5f |........|....JOB_|
|00001cf0| 47 52 41 44 45 02 08 4a | 4f 42 47 52 41 44 45 0d |GRADE..J|OBGRADE.|
|00001d00| 04 07 00 00 00 08 04 07 | 00 00 00 0a 04 02 00 00 |........|........|
|00001d10| 00 09 04 00 00 00 00 0b | 04 00 00 00 00 16 04 08 |........|........|
|00001d20| 00 00 00 18 04 00 00 00 | 00 22 04 01 00 00 00 26 |........|.".....&|
|00001d30| 04 01 00 00 00 00 04 01 | 09 50 48 4f 4e 45 5f 45 |........|.PHONE_E|
|00001d40| 58 54 02 05 52 44 42 24 | 37 0d 04 03 00 00 00 08 |XT..RDB$|7.......|
|00001d50| 04 25 00 00 00 0a 04 04 | 00 00 00 09 04 00 00 00 |.%......|........|
|00001d60| 00 0b 04 00 00 00 00 16 | 04 04 00 00 00 18 04 00 |........|........|
|00001d70| 00 00 00 22 04 01 00 00 | 00 2a 04 15 00 00 00 2b |..."....|.*.....+|
|00001d80| 04 00 00 00 00 00 04 01 | 06 45 4d 50 5f 4e 4f 02 |........|.EMP_NO.|
|00001d90| 05 45 4d 50 4e 4f 0d 04 | 00 00 00 00 08 04 07 00 |.EMPNO..|........|
|00001da0| 00 00 0a 04 02 00 00 00 | 09 04 00 00 00 00 0b 04 |........|........|
|00001db0| 00 00 00 00 16 04 01 00 | 00 00 18 04 00 00 00 00 |........|........|
|00001dc0| 22 04 01 00 00 00 26 04 | 01 00 00 00 00 04 01 0b |".....&.|........|
|00001dd0| 4a 4f 42 5f 43 4f 55 4e | 54 52 59 02 0b 43 4f 55 |JOB_COUN|TRY..COU|
|00001de0| 4e 54 52 59 4e 41 4d 45 | 0d 04 08 00 00 00 08 04 |NTRYNAME|........|
|00001df0| 25 00 00 00 0a 04 0f 00 | 00 00 09 04 00 00 00 00 |%.......|........|
|00001e00| 0b 04 00 00 00 00 16 04 | 09 00 00 00 18 04 00 00 |........|........|
|00001e10| 00 00 22 04 01 00 00 00 | 26 04 01 00 00 00 2a 04 |..".....|&.....*.|
|00001e20| 15 00 00 00 00 04 01 08 | 4a 4f 42 5f 43 4f 44 45 |........|JOB_CODE|
|00001e30| 02 07 4a 4f 42 43 4f 44 | 45 0d 04 06 00 00 00 08 |..JOBCOD|E.......|
|00001e40| 04 25 00 00 00 0a 04 05 | 00 00 00 09 04 00 00 00 |.%......|........|
|00001e50| 00 0b 04 00 00 00 00 16 | 04 07 00 00 00 18 04 00 |........|........|
|00001e60| 00 00 00 22 04 01 00 00 | 00 26 04 01 00 00 00 2a |..."....|.&.....*|
|00001e70| 04 02 00 00 00 00 04 01 | 07 44 45 50 54 5f 4e 4f |........|.DEPT_NO|
|00001e80| 02 06 44 45 50 54 4e 4f | 0d 04 05 00 00 00 08 04 |..DEPTNO|........|
|00001e90| 0e 00 00 00 0a 04 03 00 | 00 00 09 04 00 00 00 00 |........|........|
|00001ea0| 0b 04 00 00 00 00 16 04 | 06 00 00 00 18 04 00 00 |........|........|
|00001eb0| 00 00 22 04 01 00 00 00 | 26 04 01 00 00 00 2a 04 |..".....|&.....*.|
|00001ec0| 02 00 00 00 00 04 01 09 | 4c 41 53 54 5f 4e 41 4d |........|LAST_NAM|
|00001ed0| 45 02 08 4c 41 53 54 4e | 41 4d 45 0d 04 02 00 00 |E..LASTN|AME.....|
|00001ee0| 00 08 04 25 00 00 00 0a | 04 19 00 00 00 09 04 00 |...%....|........|
|00001ef0| 00 00 00 0b 04 00 00 00 | 00 16 04 03 00 00 00 18 |........|........|
|00001f00| 04 00 00 00 00 22 04 01 | 00 00 00 26 04 01 00 00 |....."..|...&....|
|00001f10| 00 2a 04 15 00 00 00 00 | 04 01 0a 46 49 52 53 54 |.*......|...FIRST|
|00001f20| 5f 4e 41 4d 45 02 09 46 | 49 52 53 54 4e 41 4d 45 |_NAME..F|IRSTNAME|
|00001f30| 0d 04 01 00 00 00 08 04 | 25 00 00 00 0a 04 0f 00 |........|%.......|
|00001f40| 00 00 09 04 00 00 00 00 | 0b 04 00 00 00 00 16 04 |........|........|
|00001f50| 02 00 00 00 18 04 00 00 | 00 00 22 04 01 00 00 00 |........|..".....|
|00001f60| 26 04 01 00 00 00 2a 04 | 15 00 00 00 00 09 03 01 |&.....*.|........|
|00001f70| 07 50 52 4f 4a 45 43 54 | 10 04 01 00 00 00 08 0b |.PROJECT|........|
|00001f80| 53 51 4c 24 50 52 4f 4a | 45 43 54 0c 06 53 59 53 |SQL$PROJ|ECT..SYS|
|00001f90| 44 42 41 00 04 01 09 50 | 52 4f 4a 5f 44 45 53 43 |DBA....P|ROJ_DESC|
|00001fa0| 02 06 52 44 42 24 31 31 | 0d 04 02 00 00 00 08 04 |..RDB$11|........|
|00001fb0| 05 01 00 00 0a 04 08 00 | 00 00 09 04 01 00 00 00 |........|........|
|00001fc0| 0b 04 00 00 00 00 16 04 | 03 00 00 00 18 04 00 00 |........|........|
|00001fd0| 00 00 22 04 01 00 00 00 | 2a 04 15 00 00 00 00 04 |..".....|*.......|
|00001fe0| 01 07 50 52 4f 44 55 43 | 54 02 08 50 52 4f 44 54 |..PRODUC|T..PRODT|
|00001ff0| 59 50 45 0d 04 04 00 00 | 00 08 04 25 00 00 00 0a |YPE.....|...%....|
|00002000| 04 0c 00 00 00 09 04 00 | 00 00 00 0b 04 00 00 00 |........|........|
|00002010| 00 16 04 05 00 00 00 18 | 04 00 00 00 00 22 04 01 |........|....."..|
|00002020| 00 00 00 2a 04 15 00 00 | 00 00 04 01 0b 54 45 41 |...*....|.....TEA|
|00002030| 4d 5f 4c 45 41 44 45 52 | 02 05 45 4d 50 4e 4f 0d |M_LEADER|..EMPNO.|
|00002040| 04 03 00 00 00 08 04 07 | 00 00 00 0a 04 02 00 00 |........|........|
|00002050| 00 09 04 00 00 00 00 0b | 04 00 00 00 00 16 04 04 |........|........|
|00002060| 00 00 00 18 04 00 00 00 | 00 22 04 01 00 00 00 00 |........|."......|
|00002070| 04 01 09 50 52 4f 4a 5f | 4e 41 4d 45 02 06 52 44 |...PROJ_|NAME..RD|
|00002080| 42 24 31 30 0d 04 01 00 | 00 00 08 04 25 00 00 00 |B$10....|....%...|
|00002090| 0a 04 14 00 00 00 09 04 | 00 00 00 00 0b 04 00 00 |........|........|
|000020a0| 00 00 16 04 02 00 00 00 | 18 04 00 00 00 00 22 04 |........|......".|
|000020b0| 01 00 00 00 26 04 01 00 | 00 00 2a 04 15 00 00 00 |....&...|..*.....|
|000020c0| 2b 04 00 00 00 00 00 04 | 01 07 50 52 4f 4a 5f 49 |+.......|..PROJ_I|
|000020d0| 44 02 06 50 52 4f 4a 4e | 4f 0d 04 00 00 00 00 08 |D..PROJN|O.......|
|000020e0| 04 0e 00 00 00 0a 04 05 | 00 00 00 09 04 00 00 00 |........|........|
|000020f0| 00 0b 04 00 00 00 00 16 | 04 01 00 00 00 18 04 00 |........|........|
|00002100| 00 00 00 22 04 01 00 00 | 00 26 04 01 00 00 00 2a |..."....|.&.....*|
|00002110| 04 02 00 00 00 00 09 03 | 01 0a 50 48 4f 4e 45 5f |........|..PHONE_|
|00002120| 4c 49 53 54 02 04 33 00 | 00 00 04 43 02 4a 08 45 |LIST..3.|...C.J.E|
|00002130| 4d 50 4c 4f 59 45 45 01 | 4a 0a 44 45 50 41 52 54 |MPLOYEE.|J.DEPART|
|00002140| 4d 45 4e 54 02 47 2f 17 | 01 07 44 45 50 54 5f 4e |MENT.G/.|..DEPT_N|
|00002150| 4f 17 02 07 44 45 50 54 | 5f 4e 4f ff 4c 10 04 01 |O...DEPT|_NO.L...|
|00002160| 00 00 00 08 0e 53 51 4c | 24 50 48 4f 4e 45 5f 4c |.....SQL|$PHONE_L|
|00002170| 49 53 54 0e 04 97 00 00 | 00 20 53 45 4c 45 43 54 |IST.....|. SELECT|
|00002180| 0a 20 20 20 20 65 6d 70 | 5f 6e 6f 2c 20 66 69 72 |.    emp|_no, fir|
|00002190| 73 74 5f 6e 61 6d 65 2c | 20 6c 61 73 74 5f 6e 61 |st_name,| last_na|
|000021a0| 6d 65 2c 20 70 68 6f 6e | 65 5f 65 78 74 2c 20 6c |me, phon|e_ext, l|
|000021b0| 6f 63 61 74 69 6f 6e 2c | 20 70 68 6f 6e 65 5f 6e |ocation,| phone_n|
|000021c0| 6f 0a 20 20 20 20 46 52 | 4f 4d 20 65 6d 70 6c 6f |o.    FR|OM emplo|
|000021d0| 79 65 65 2c 20 64 65 70 | 61 72 74 6d 65 6e 74 0a |yee, dep|artment.|
|000021e0| 20 20 20 20 57 48 45 52 | 45 20 65 6d 70 6c 6f 79 |    WHER|E employ|
|000021f0| 65 65 2e 64 65 70 74 5f | 6e 6f 20 3d 20 64 65 70 |ee.dept_|no = dep|
|00002200| 61 72 74 6d 65 6e 74 2e | 64 65 70 74 5f 6e 6f 00 |artment.|dept_no.|
|00002210| 0c 06 53 59 53 44 42 41 | 00 04 01 08 50 48 4f 4e |..SYSDBA|....PHON|
|00002220| 45 5f 4e 4f 02 0b 50 48 | 4f 4e 45 4e 55 4d 42 45 |E_NO..PH|ONENUMBE|
|00002230| 52 0d 04 05 00 00 00 08 | 04 25 00 00 00 0a 04 14 |R.......|.%......|
|00002240| 00 00 00 09 04 00 00 00 | 00 0b 04 00 00 00 00 16 |........|........|
|00002250| 04 06 00 00 00 18 04 00 | 00 00 00 22 04 00 00 00 |........|..."....|
|00002260| 00 2a 04 15 00 00 00 04 | 04 02 00 00 00 03 08 50 |.*......|.......P|
|00002270| 48 4f 4e 45 5f 4e 4f 00 | 04 01 09 50 48 4f 4e 45 |HONE_NO.|...PHONE|
|00002280| 5f 45 58 54 02 05 52 44 | 42 24 37 0d 04 03 00 00 |_EXT..RD|B$7.....|
|00002290| 00 08 04 25 00 00 00 0a | 04 04 00 00 00 09 04 00 |...%....|........|
|000022a0| 00 00 00 0b 04 00 00 00 | 00 16 04 04 00 00 00 18 |........|........|
|000022b0| 04 00 00 00 00 22 04 00 | 00 00 00 2a 04 15 00 00 |....."..|...*....|
|000022c0| 00 04 04 01 00 00 00 03 | 09 50 48 4f 4e 45 5f 45 |........|.PHONE_E|
|000022d0| 58 54 00 04 01 06 45 4d | 50 5f 4e 4f 02 05 45 4d |XT....EM|P_NO..EM|
|000022e0| 50 4e 4f 0d 04 00 00 00 | 00 08 04 07 00 00 00 0a |PNO.....|........|
|000022f0| 04 02 00 00 00 09 04 00 | 00 00 00 0b 04 00 00 00 |........|........|
|00002300| 00 16 04 01 00 00 00 18 | 04 00 00 00 00 22 04 00 |........|....."..|
|00002310| 00 00 00 04 04 01 00 00 | 00 03 06 45 4d 50 5f 4e |........|...EMP_N|
|00002320| 4f 00 04 01 08 4c 4f 43 | 41 54 49 4f 4e 02 05 52 |O....LOC|ATION..R|
|00002330| 44 42 24 36 0d 04 04 00 | 00 00 08 04 25 00 00 00 |DB$6....|....%...|
|00002340| 0a 04 0f 00 00 00 09 04 | 00 00 00 00 0b 04 00 00 |........|........|
|00002350| 00 00 16 04 05 00 00 00 | 18 04 00 00 00 00 22 04 |........|......".|
|00002360| 00 00 00 00 2a 04 15 00 | 00 00 04 04 02 00 00 00 |....*...|........|
|00002370| 03 08 4c 4f 43 41 54 49 | 4f 4e 00 04 01 09 4c 41 |..LOCATI|ON....LA|
|00002380| 53 54 5f 4e 41 4d 45 02 | 08 4c 41 53 54 4e 41 4d |ST_NAME.|.LASTNAM|
|00002390| 45 0d 04 02 00 00 00 08 | 04 25 00 00 00 0a 04 19 |E.......|.%......|
|000023a0| 00 00 00 09 04 00 00 00 | 00 0b 04 00 00 00 00 16 |........|........|
|000023b0| 04 03 00 00 00 18 04 00 | 00 00 00 22 04 00 00 00 |........|..."....|
|000023c0| 00 2a 04 15 00 00 00 04 | 04 01 00 00 00 03 09 4c |.*......|.......L|
|000023d0| 41 53 54 5f 4e 41 4d 45 | 00 04 01 0a 46 49 52 53 |AST_NAME|....FIRS|
|000023e0| 54 5f 4e 41 4d 45 02 09 | 46 49 52 53 54 4e 41 4d |T_NAME..|FIRSTNAM|
|000023f0| 45 0d 04 01 00 00 00 08 | 04 25 00 00 00 0a 04 0f |E.......|.%......|
|00002400| 00 00 00 09 04 00 00 00 | 00 0b 04 00 00 00 00 16 |........|........|
|00002410| 04 02 00 00 00 18 04 00 | 00 00 00 22 04 00 00 00 |........|..."....|
|00002420| 00 2a 04 15 00 00 00 04 | 04 01 00 00 00 03 0a 46 |.*......|.......F|
|00002430| 49 52 53 54 5f 4e 41 4d | 45 00 0b 08 0a 44 45 50 |IRST_NAM|E....DEP|
|00002440| 41 52 54 4d 45 4e 54 09 | 04 02 00 00 00 0a 0a 44 |ARTMENT.|.......D|
|00002450| 45 50 41 52 54 4d 45 4e | 54 00 0b 08 08 45 4d 50 |EPARTMEN|T....EMP|
|00002460| 4c 4f 59 45 45 09 04 01 | 00 00 00 0a 08 45 4d 50 |LOYEE...|.....EMP|
|00002470| 4c 4f 59 45 45 00 09 03 | 01 10 45 4d 50 4c 4f 59 |LOYEE...|..EMPLOY|
|00002480| 45 45 5f 50 52 4f 4a 45 | 43 54 10 04 01 00 00 00 |EE_PROJE|CT......|
|00002490| 08 14 53 51 4c 24 45 4d | 50 4c 4f 59 45 45 5f 50 |..SQL$EM|PLOYEE_P|
|000024a0| 52 4f 4a 45 43 54 0c 06 | 53 59 53 44 42 41 00 04 |ROJECT..|SYSDBA..|
|000024b0| 01 06 45 4d 50 5f 4e 4f | 02 05 45 4d 50 4e 4f 0d |..EMP_NO|..EMPNO.|
|000024c0| 04 00 00 00 00 08 04 07 | 00 00 00 0a 04 02 00 00 |........|........|
|000024d0| 00 09 04 00 00 00 00 0b | 04 00 00 00 00 16 04 01 |........|........|
|000024e0| 00 00 00 18 04 00 00 00 | 00 22 04 01 00 00 00 26 |........|.".....&|
|000024f0| 04 01 00 00 00 00 04 01 | 07 50 52 4f 4a 5f 49 44 |........|.PROJ_ID|
|00002500| 02 06 50 52 4f 4a 4e 4f | 0d 04 01 00 00 00 08 04 |..PROJNO|........|
|00002510| 0e 00 00 00 0a 04 05 00 | 00 00 09 04 00 00 00 00 |........|........|
|00002520| 0b 04 00 00 00 00 16 04 | 02 00 00 00 18 04 00 00 |........|........|
|00002530| 00 00 22 04 01 00 00 00 | 26 04 01 00 00 00 2a 04 |..".....|&.....*.|
|00002540| 02 00 00 00 00 09 03 01 | 08 43 55 53 54 4f 4d 45 |........|.CUSTOME|
|00002550| 52 10 04 01 00 00 00 08 | 0c 53 51 4c 24 43 55 53 |R.......|.SQL$CUS|
|00002560| 54 4f 4d 45 52 0c 06 53 | 59 53 44 42 41 00 04 01 |TOMER..S|YSDBA...|
|00002570| 07 43 55 53 54 5f 4e 4f | 02 06 43 55 53 54 4e 4f |.CUST_NO|..CUSTNO|
|00002580| 0d 04 00 00 00 00 08 04 | 08 00 00 00 0a 04 04 00 |........|........|
|00002590| 00 00 09 04 00 00 00 00 | 0b 04 00 00 00 00 16 04 |........|........|
|000025a0| 01 00 00 00 18 04 00 00 | 00 00 22 04 01 00 00 00 |........|..".....|
|000025b0| 26 04 01 00 00 00 00 04 | 01 0b 50 4f 53 54 41 4c |&.......|..POSTAL|
|000025c0| 5f 43 4f 44 45 02 06 52 | 44 42 24 32 31 0d 04 0a |_CODE..R|DB$21...|
|000025d0| 00 00 00 08 04 25 00 00 | 00 0a 04 0c 00 00 00 09 |.....%..|........|
|000025e0| 04 00 00 00 00 0b 04 00 | 00 00 00 16 04 0b 00 00 |........|........|
|000025f0| 00 18 04 00 00 00 00 22 | 04 01 00 00 00 2a 04 15 |......."|.....*..|
|00002600| 00 00 00 2b 04 00 00 00 | 00 00 04 01 0d 41 44 44 |...+....|.....ADD|
|00002610| 52 45 53 53 5f 4c 49 4e | 45 32 02 0b 41 44 44 52 |RESS_LIN|E2..ADDR|
|00002620| 45 53 53 4c 49 4e 45 0d | 04 06 00 00 00 08 04 25 |ESSLINE.|.......%|
|00002630| 00 00 00 0a 04 28 00 00 | 00 09 04 00 00 00 00 0b |.....(..|........|
|00002640| 04 00 00 00 00 16 04 07 | 00 00 00 18 04 00 00 00 |........|........|
|00002650| 00 22 04 01 00 00 00 2a | 04 15 00 00 00 00 04 01 |.".....*|........|
|00002660| 0d 41 44 44 52 45 53 53 | 5f 4c 49 4e 45 31 02 0b |.ADDRESS|_LINE1..|
|00002670| 41 44 44 52 45 53 53 4c | 49 4e 45 0d 04 05 00 00 |ADDRESSL|INE.....|
|00002680| 00 08 04 25 00 00 00 0a | 04 28 00 00 00 09 04 00 |...%....|.(......|
|00002690| 00 00 00 0b 04 00 00 00 | 00 16 04 06 00 00 00 18 |........|........|
|000026a0| 04 00 00 00 00 22 04 01 | 00 00 00 2a 04 15 00 00 |....."..|...*....|
|000026b0| 00 00 04 01 08 50 48 4f | 4e 45 5f 4e 4f 02 0b 50 |.....PHO|NE_NO..P|
|000026c0| 48 4f 4e 45 4e 55 4d 42 | 45 52 0d 04 04 00 00 00 |HONENUMB|ER......|
|000026d0| 08 04 25 00 00 00 0a 04 | 14 00 00 00 09 04 00 00 |..%.....|........|
|000026e0| 00 00 0b 04 00 00 00 00 | 16 04 05 00 00 00 18 04 |........|........|
|000026f0| 00 00 00 00 22 04 01 00 | 00 00 2a 04 15 00 00 00 |...."...|..*.....|
|00002700| 00 04 01 07 4f 4e 5f 48 | 4f 4c 44 02 06 52 44 42 |....ON_H|OLD..RDB|
|00002710| 24 32 32 0d 04 0b 00 00 | 00 08 04 0e 00 00 00 0a |$22.....|........|
|00002720| 04 01 00 00 00 09 04 00 | 00 00 00 0b 04 00 00 00 |........|........|
|00002730| 00 16 04 0c 00 00 00 18 | 04 00 00 00 00 22 04 01 |........|....."..|
|00002740| 00 00 00 2a 04 15 00 00 | 00 2b 04 00 00 00 00 0f |...*....|.+......|
|00002750| 04 03 00 00 00 04 2d 4c | 27 04 0d 00 00 00 44 45 |......-L|'.....DE|
|00002760| 46 41 55 4c 54 20 4e 55 | 4c 4c 00 00 04 01 07 43 |FAULT NU|LL.....C|
|00002770| 4f 55 4e 54 52 59 02 0b | 43 4f 55 4e 54 52 59 4e |OUNTRY..|COUNTRYN|
|00002780| 41 4d 45 0d 04 09 00 00 | 00 08 04 25 00 00 00 0a |AME.....|...%....|
|00002790| 04 0f 00 00 00 09 04 00 | 00 00 00 0b 04 00 00 00 |........|........|
|000027a0| 00 16 04 0a 00 00 00 18 | 04 00 00 00 00 22 04 01 |........|....."..|
|000027b0| 00 00 00 2a 04 15 00 00 | 00 00 04 01 0e 53 54 41 |...*....|.....STA|
|000027c0| 54 45 5f 50 52 4f 56 49 | 4e 43 45 02 06 52 44 42 |TE_PROVI|NCE..RDB|
|000027d0| 24 32 30 0d 04 08 00 00 | 00 08 04 25 00 00 00 0a |$20.....|...%....|
|000027e0| 04 0f 00 00 00 09 04 00 | 00 00 00 0b 04 00 00 00 |........|........|
|000027f0| 00 16 04 09 00 00 00 18 | 04 00 00 00 00 22 04 01 |........|....."..|
|00002800| 00 00 00 2a 04 15 00 00 | 00 2b 04 00 00 00 00 00 |...*....|.+......|
|00002810| 04 01 04 43 49 54 59 02 | 06 52 44 42 24 31 39 0d |...CITY.|.RDB$19.|
|00002820| 04 07 00 00 00 08 04 25 | 00 00 00 0a 04 19 00 00 |.......%|........|
|00002830| 00 09 04 00 00 00 00 0b | 04 00 00 00 00 16 04 08 |........|........|
|00002840| 00 00 00 18 04 00 00 00 | 00 22 04 01 00 00 00 2a |........|.".....*|
|00002850| 04 15 00 00 00 2b 04 00 | 00 00 00 00 04 01 0c 43 |.....+..|.......C|
|00002860| 4f 4e 54 41 43 54 5f 4c | 41 53 54 02 08 4c 41 53 |ONTACT_L|AST..LAS|
|00002870| 54 4e 41 4d 45 0d 04 03 | 00 00 00 08 04 25 00 00 |TNAME...|.....%..|
|00002880| 00 0a 04 19 00 00 00 09 | 04 00 00 00 00 0b 04 00 |........|........|
|00002890| 00 00 00 16 04 04 00 00 | 00 18 04 00 00 00 00 22 |........|......."|
|000028a0| 04 01 00 00 00 2a 04 15 | 00 00 00 00 04 01 0d 43 |.....*..|.......C|
|000028b0| 4f 4e 54 41 43 54 5f 46 | 49 52 53 54 02 09 46 49 |ONTACT_F|IRST..FI|
|000028c0| 52 53 54 4e 41 4d 45 0d | 04 02 00 00 00 08 04 25 |RSTNAME.|.......%|
|000028d0| 00 00 00 0a 04 0f 00 00 | 00 09 04 00 00 00 00 0b |........|........|
|000028e0| 04 00 00 00 00 16 04 03 | 00 00 00 18 04 00 00 00 |........|........|
|000028f0| 00 22 04 01 00 00 00 2a | 04 15 00 00 00 00 04 01 |.".....*|........|
|00002900| 08 43 55 53 54 4f 4d 45 | 52 02 06 52 44 42 24 31 |.CUSTOME|R..RDB$1|
|00002910| 38 0d 04 01 00 00 00 08 | 04 25 00 00 00 0a 04 23 |8.......|.%.....#|
|00002920| 00 00 00 09 04 00 00 00 | 00 0b 04 00 00 00 00 16 |........|........|
|00002930| 04 02 00 00 00 18 04 00 | 00 00 00 22 04 01 00 00 |........|..."....|
|00002940| 00 26 04 01 00 00 00 2a | 04 15 00 00 00 2b 04 04 |.&.....*|.....+..|
|00002950| 00 00 00 00 09 03 01 05 | 53 41 4c 45 53 10 04 01 |........|SALES...|
|00002960| 00 00 00 08 09 53 51 4c | 24 53 41 4c 45 53 0c 06 |.....SQL|$SALES..|
|00002970| 53 59 53 44 42 41 00 04 | 01 04 41 47 45 44 02 06 |SYSDBA..|..AGED..|
|00002980| 52 44 42 24 33 31 0d 04 | 0c 00 00 00 08 04 1b 00 |RDB$31..|........|
|00002990| 00 00 0a 04 08 00 00 00 | 09 04 00 00 00 00 0b 04 |........|........|
|000029a0| 00 00 00 00 16 04 0d 00 | 00 00 18 04 00 00 00 00 |........|........|
|000029b0| 22 04 00 00 00 00 17 04 | 01 00 00 00 00 04 01 0b |".......|........|
|000029c0| 44 41 54 45 5f 4e 45 45 | 44 45 44 02 06 52 44 42 |DATE_NEE|DED..RDB|
|000029d0| 24 32 36 0d 04 06 00 00 | 00 08 04 23 00 00 00 0a |$26.....|...#....|
|000029e0| 04 08 00 00 00 09 04 00 | 00 00 00 0b 04 00 00 00 |........|........|
|000029f0| 00 16 04 07 00 00 00 18 | 04 00 00 00 00 22 04 01 |........|....."..|
|00002a00| 00 00 00 00 04 01 09 53 | 48 49 50 5f 44 41 54 45 |.......S|HIP_DATE|
|00002a10| 02 06 52 44 42 24 32 35 | 0d 04 05 00 00 00 08 04 |..RDB$25|........|
|00002a20| 23 00 00 00 0a 04 08 00 | 00 00 09 04 00 00 00 00 |#.......|........|
|00002a30| 0b 04 00 00 00 00 16 04 | 06 00 00 00 18 04 00 00 |........|........|
|00002a40| 00 00 22 04 01 00 00 00 | 00 04 01 0a 4f 52 44 45 |..".....|....ORDE|
|00002a50| 52 5f 44 41 54 45 02 06 | 52 44 42 24 32 34 0d 04 |R_DATE..|RDB$24..|
|00002a60| 04 00 00 00 08 04 23 00 | 00 00 0a 04 08 00 00 00 |......#.|........|
|00002a70| 09 04 00 00 00 00 0b 04 | 00 00 00 00 16 04 05 00 |........|........|
|00002a80| 00 00 18 04 00 00 00 00 | 22 04 01 00 00 00 26 04 |........|".....&.|
|00002a90| 01 00 00 00 0f 04 0b 00 | 00 00 04 15 0f 7f 00 03 |........|........|
|00002aa0| 00 6e 6f 77 4c 27 04 0e | 00 00 00 44 45 46 41 55 |.nowL'..|...DEFAU|
|00002ab0| 4c 54 20 27 6e 6f 77 27 | 00 00 04 01 09 50 4f 5f |LT 'now'|.....PO_|
|00002ac0| 4e 55 4d 42 45 52 02 08 | 50 4f 4e 55 4d 42 45 52 |NUMBER..|PONUMBER|
|00002ad0| 0d 04 00 00 00 00 08 04 | 0e 00 00 00 0a 04 08 00 |........|........|
|00002ae0| 00 00 09 04 00 00 00 00 | 0b 04 00 00 00 00 16 04 |........|........|
|00002af0| 01 00 00 00 18 04 00 00 | 00 00 22 04 01 00 00 00 |........|..".....|
|00002b00| 26 04 01 00 00 00 2a 04 | 15 00 00 00 00 04 01 08 |&.....*.|........|
|00002b10| 44 49 53 43 4f 55 4e 54 | 02 06 52 44 42 24 33 30 |DISCOUNT|..RDB$30|
|00002b20| 0d 04 0a 00 00 00 08 04 | 0a 00 00 00 0a 04 04 00 |........|........|
|00002b30| 00 00 09 04 00 00 00 00 | 0b 04 00 00 00 00 16 04 |........|........|
|00002b40| 0b 00 00 00 18 04 00 00 | 00 00 22 04 01 00 00 00 |........|..".....|
|00002b50| 26 04 01 00 00 00 0f 04 | 09 00 00 00 04 15 08 00 |&.......|........|
|00002b60| 00 00 00 00 4c 27 04 0a | 00 00 00 44 45 46 41 55 |....L'..|...DEFAU|
|00002b70| 4c 54 20 30 00 00 04 01 | 0b 54 4f 54 41 4c 5f 56 |LT 0....|.TOTAL_V|
|00002b80| 41 4c 55 45 02 06 52 44 | 42 24 32 39 0d 04 09 00 |ALUE..RD|B$29....|
|00002b90| 00 00 08 04 08 00 00 00 | 0a 04 04 00 00 00 09 04 |........|........|
|00002ba0| 00 00 00 00 0b 04 fe ff | ff ff 16 04 0a 00 00 00 |........|........|
|00002bb0| 18 04 00 00 00 00 22 04 | 01 00 00 00 26 04 01 00 |......".|....&...|
|00002bc0| 00 00 00 04 01 0b 51 54 | 59 5f 4f 52 44 45 52 45 |......QT|Y_ORDERE|
|00002bd0| 44 02 06 52 44 42 24 32 | 38 0d 04 08 00 00 00 08 |D..RDB$2|8.......|
|00002be0| 04 08 00 00 00 0a 04 04 | 00 00 00 09 04 00 00 00 |........|........|
|00002bf0| 00 0b 04 00 00 00 00 16 | 04 09 00 00 00 18 04 00 |........|........|
|00002c00| 00 00 00 22 04 01 00 00 | 00 26 04 01 00 00 00 0f |..."....|.&......|
|00002c10| 04 09 00 00 00 04 15 08 | 00 01 00 00 00 4c 27 04 |........|.....L'.|
|00002c20| 0a 00 00 00 44 45 46 41 | 55 4c 54 20 31 00 00 04 |....DEFA|ULT 1...|
|00002c30| 01 07 43 55 53 54 5f 4e | 4f 02 06 43 55 53 54 4e |..CUST_N|O..CUSTN|
|00002c40| 4f 0d 04 01 00 00 00 08 | 04 08 00 00 00 0a 04 04 |O.......|........|
|00002c50| 00 00 00 09 04 00 00 00 | 00 0b 04 00 00 00 00 16 |........|........|
|00002c60| 04 02 00 00 00 18 04 00 | 00 00 00 22 04 01 00 00 |........|..."....|
|00002c70| 00 26 04 01 00 00 00 00 | 04 01 09 49 54 45 4d 5f |.&......|...ITEM_|
|00002c80| 54 59 50 45 02 08 50 52 | 4f 44 54 59 50 45 0d 04 |TYPE..PR|ODTYPE..|
|00002c90| 0b 00 00 00 08 04 25 00 | 00 00 0a 04 0c 00 00 00 |......%.|........|
|00002ca0| 09 04 00 00 00 00 0b 04 | 00 00 00 00 16 04 0c 00 |........|........|
|00002cb0| 00 00 18 04 00 00 00 00 | 22 04 01 00 00 00 2a 04 |........|".....*.|
|00002cc0| 15 00 00 00 00 04 01 09 | 53 41 4c 45 53 5f 52 45 |........|SALES_RE|
|00002cd0| 50 02 05 45 4d 50 4e 4f | 0d 04 02 00 00 00 08 04 |P..EMPNO|........|
|00002ce0| 07 00 00 00 0a 04 02 00 | 00 00 09 04 00 00 00 00 |........|........|
|00002cf0| 0b 04 00 00 00 00 16 04 | 03 00 00 00 18 04 00 00 |........|........|
|00002d00| 00 00 22 04 01 00 00 00 | 00 04 01 04 50 41 49 44 |..".....|....PAID|
|00002d10| 02 06 52 44 42 24 32 37 | 0d 04 07 00 00 00 08 04 |..RDB$27|........|
|00002d20| 0e 00 00 00 0a 04 01 00 | 00 00 09 04 00 00 00 00 |........|........|
|00002d30| 0b 04 00 00 00 00 16 04 | 08 00 00 00 18 04 00 00 |........|........|
|00002d40| 00 00 22 04 01 00 00 00 | 2a 04 15 00 00 00 2b 04 |..".....|*.....+.|
|00002d50| 00 00 00 00 0f 04 09 00 | 00 00 04 15 0f 7f 00 01 |........|........|
|00002d60| 00 6e 4c 27 04 0c 00 00 | 00 44 45 46 41 55 4c 54 |.nL'....|.DEFAULT|
|00002d70| 20 27 6e 27 00 00 04 01 | 0c 4f 52 44 45 52 5f 53 | 'n'....|.ORDER_S|
|00002d80| 54 41 54 55 53 02 06 52 | 44 42 24 32 33 0d 04 03 |TATUS..R|DB$23...|
|00002d90| 00 00 00 08 04 25 00 00 | 00 0a 04 07 00 00 00 09 |.....%..|........|
|00002da0| 04 00 00 00 00 0b 04 00 | 00 00 00 16 04 04 00 00 |........|........|
|00002db0| 00 18 04 00 00 00 00 22 | 04 01 00 00 00 26 04 01 |......."|.....&..|
|00002dc0| 00 00 00 2a 04 15 00 00 | 00 2b 04 00 00 00 00 0f |...*....|.+......|
|00002dd0| 04 0b 00 00 00 04 15 0f | 7f 00 03 00 6e 65 77 4c |........|....newL|
|00002de0| 27 04 0e 00 00 00 44 45 | 46 41 55 4c 54 20 27 6e |'.....DE|FAULT 'n|
|00002df0| 65 77 27 00 00 09 03 01 | 10 50 52 4f 4a 5f 44 45 |ew'.....|.PROJ_DE|
|00002e00| 50 54 5f 42 55 44 47 45 | 54 10 04 01 00 00 00 08 |PT_BUDGE|T.......|
|00002e10| 14 53 51 4c 24 50 52 4f | 4a 5f 44 45 50 54 5f 42 |.SQL$PRO|J_DEPT_B|
|00002e20| 55 44 47 45 54 0c 06 53 | 59 53 44 42 41 00 04 01 |UDGET..S|YSDBA...|
|00002e30| 10 50 52 4f 4a 45 43 54 | 45 44 5f 42 55 44 47 45 |.PROJECT|ED_BUDGE|
|00002e40| 54 02 06 42 55 44 47 45 | 54 0d 04 04 00 00 00 08 |T..BUDGE|T.......|
|00002e50| 04 1b 00 00 00 0a 04 08 | 00 00 00 09 04 00 00 00 |........|........|
|00002e60| 00 0b 04 fe ff ff ff 16 | 04 05 00 00 00 18 04 00 |........|........|
|00002e70| 00 00 00 22 04 01 00 00 | 00 00 04 01 0e 51 55 41 |..."....|.....QUA|
|00002e80| 52 54 5f 48 45 41 44 5f | 43 4e 54 02 06 52 44 42 |RT_HEAD_|CNT..RDB|
|00002e90| 24 31 33 0d 04 03 00 00 | 00 08 04 08 00 00 00 0a |$13.....|........|
|00002ea0| 04 04 00 00 00 09 04 00 | 00 00 00 0b 04 00 00 00 |........|........|
|00002eb0| 00 16 04 04 00 00 00 18 | 04 00 00 00 00 22 04 01 |........|....."..|
|00002ec0| 00 00 00 1d 04 01 00 00 | 00 20 04 01 00 00 00 21 |........|. .....!|
|00002ed0| 04 04 00 00 00 00 04 01 | 04 59 45 41 52 02 06 52 |........|.YEAR..R|
|00002ee0| 44 42 24 31 32 0d 04 00 | 00 00 00 08 04 08 00 00 |DB$12...|........|
|00002ef0| 00 0a 04 04 00 00 00 09 | 04 00 00 00 00 0b 04 00 |........|........|
|00002f00| 00 00 00 16 04 01 00 00 | 00 18 04 00 00 00 00 22 |........|......."|
|00002f10| 04 01 00 00 00 26 04 01 | 00 00 00 00 04 01 07 44 |.....&..|.......D|
|00002f20| 45 50 54 5f 4e 4f 02 06 | 44 45 50 54 4e 4f 0d 04 |EPT_NO..|DEPTNO..|
|00002f30| 02 00 00 00 08 04 0e 00 | 00 00 0a 04 03 00 00 00 |........|........|
|00002f40| 09 04 00 00 00 00 0b 04 | 00 00 00 00 16 04 03 00 |........|........|
|00002f50| 00 00 18 04 00 00 00 00 | 22 04 01 00 00 00 26 04 |........|".....&.|
|00002f60| 01 00 00 00 2a 04 02 00 | 00 00 00 04 01 07 50 52 |....*...|......PR|
|00002f70| 4f 4a 5f 49 44 02 06 50 | 52 4f 4a 4e 4f 0d 04 01 |OJ_ID..P|ROJNO...|
|00002f80| 00 00 00 08 04 0e 00 00 | 00 0a 04 05 00 00 00 09 |........|........|
|00002f90| 04 00 00 00 00 0b 04 00 | 00 00 00 16 04 02 00 00 |........|........|
|00002fa0| 00 18 04 00 00 00 00 22 | 04 01 00 00 00 26 04 01 |......."|.....&..|
|00002fb0| 00 00 00 2a 04 02 00 00 | 00 00 09 03 01 0e 53 41 |...*....|......SA|
|00002fc0| 4c 41 52 59 5f 48 49 53 | 54 4f 52 59 10 04 01 00 |LARY_HIS|TORY....|
|00002fd0| 00 00 08 12 53 51 4c 24 | 53 41 4c 41 52 59 5f 48 |....SQL$|SALARY_H|
|00002fe0| 49 53 54 4f 52 59 0c 06 | 53 59 53 44 42 41 00 04 |ISTORY..|SYSDBA..|
|00002ff0| 01 0a 4e 45 57 5f 53 41 | 4c 41 52 59 02 06 52 44 |..NEW_SA|LARY..RD|
|00003000| 42 24 31 37 0d 04 05 00 | 00 00 08 04 1b 00 00 00 |B$17....|........|
|00003010| 0a 04 08 00 00 00 09 04 | 00 00 00 00 0b 04 00 00 |........|........|
|00003020| 00 00 16 04 06 00 00 00 | 18 04 00 00 00 00 22 04 |........|......".|
|00003030| 00 00 00 00 17 04 01 00 | 00 00 00 04 01 0e 50 45 |........|......PE|
|00003040| 52 43 45 4e 54 5f 43 48 | 41 4e 47 45 02 06 52 44 |RCENT_CH|ANGE..RD|
|00003050| 42 24 31 36 0d 04 04 00 | 00 00 08 04 1b 00 00 00 |B$16....|........|
|00003060| 0a 04 08 00 00 00 09 04 | 00 00 00 00 0b 04 00 00 |........|........|
|00003070| 00 00 16 04 05 00 00 00 | 18 04 00 00 00 00 22 04 |........|......".|
|00003080| 01 00 00 00 26 04 01 00 | 00 00 0f 04 09 00 00 00 |....&...|........|
|00003090| 04 15 08 00 00 00 00 00 | 4c 27 04 0a 00 00 00 44 |........|L'.....D|
|000030a0| 45 46 41 55 4c 54 20 30 | 00 00 04 01 0a 4f 4c 44 |EFAULT 0|.....OLD|
|000030b0| 5f 53 41 4c 41 52 59 02 | 06 53 41 4c 41 52 59 0d |_SALARY.|.SALARY.|
|000030c0| 04 03 00 00 00 08 04 1b | 00 00 00 0a 04 08 00 00 |........|........|
|000030d0| 00 09 04 00 00 00 00 0b | 04 fe ff ff ff 16 04 04 |........|........|
|000030e0| 00 00 00 18 04 00 00 00 | 00 22 04 01 00 00 00 26 |........|.".....&|
|000030f0| 04 01 00 00 00 00 04 01 | 0b 43 48 41 4e 47 45 5f |........|.CHANGE_|
|00003100| 44 41 54 45 02 06 52 44 | 42 24 31 34 0d 04 01 00 |DATE..RD|B$14....|
|00003110| 00 00 08 04 23 00 00 00 | 0a 04 08 00 00 00 09 04 |....#...|........|
|00003120| 00 00 00 00 0b 04 00 00 | 00 00 16 04 02 00 00 00 |........|........|
|00003130| 18 04 00 00 00 00 22 04 | 01 00 00 00 26 04 01 00 |......".|....&...|
|00003140| 00 00 0f 04 0b 00 00 00 | 04 15 0f 7f 00 03 00 4e |........|.......N|
|00003150| 4f 57 4c 27 04 0e 00 00 | 00 44 45 46 41 55 4c 54 |OWL'....|.DEFAULT|
|00003160| 20 27 4e 4f 57 27 00 00 | 04 01 0a 55 50 44 41 54 | 'NOW'..|...UPDAT|
|00003170| 45 52 5f 49 44 02 06 52 | 44 42 24 31 35 0d 04 02 |ER_ID..R|DB$15...|
|00003180| 00 00 00 08 04 25 00 00 | 00 0a 04 14 00 00 00 09 |.....%..|........|
|00003190| 04 00 00 00 00 0b 04 00 | 00 00 00 16 04 03 00 00 |........|........|
|000031a0| 00 18 04 00 00 00 00 22 | 04 01 00 00 00 26 04 01 |......."|.....&..|
|000031b0| 00 00 00 2a 04 15 00 00 | 00 2b 04 00 00 00 00 00 |...*....|.+......|
|000031c0| 04 01 06 45 4d 50 5f 4e | 4f 02 05 45 4d 50 4e 4f |...EMP_N|O..EMPNO|
|000031d0| 0d 04 00 00 00 00 08 04 | 07 00 00 00 0a 04 02 00 |........|........|
|000031e0| 00 00 09 04 00 00 00 00 | 0b 04 00 00 00 00 16 04 |........|........|
|000031f0| 01 00 00 00 18 04 00 00 | 00 00 22 04 01 00 00 00 |........|..".....|
|00003200| 26 04 01 00 00 00 00 09 | 1a 01 0a 45 4d 50 5f 4e |&.......|...EMP_N|
|00003210| 4f 5f 47 45 4e 02 04 91 | 00 00 00 00 1a 01 0b 43 |O_GEN...|.......C|
|00003220| 55 53 54 5f 4e 4f 5f 47 | 45 4e 02 04 f7 03 00 00 |UST_NO_G|EN......|
|00003230| 00 1b 01 0c 47 45 54 5f | 45 4d 50 5f 50 52 4f 4a |....GET_|EMP_PROJ|
|00003240| 02 04 01 00 00 00 03 04 | 01 00 00 00 07 04 6f 00 |........|......o.|
|00003250| 00 00 0a 42 45 47 49 4e | 0a 20 46 4f 52 20 53 45 |...BEGIN|. FOR SE|
|00003260| 4c 45 43 54 20 70 72 6f | 6a 5f 69 64 0a 20 20 46 |LECT pro|j_id.  F|
|00003270| 52 4f 4d 20 65 6d 70 6c | 6f 79 65 65 5f 70 72 6f |ROM empl|oyee_pro|
|00003280| 6a 65 63 74 0a 20 20 57 | 48 45 52 45 20 65 6d 70 |ject.  W|HERE emp|
|00003290| 5f 6e 6f 20 3d 20 3a 65 | 6d 70 5f 6e 6f 0a 20 20 |_no = :e|mp_no.  |
|000032a0| 49 4e 54 4f 20 3a 70 72 | 6f 6a 5f 69 64 0a 20 44 |INTO :pr|oj_id. D|
|000032b0| 4f 0a 20 20 53 55 53 50 | 45 4e 44 3b 0a 45 4e 44 |O.  SUSP|END;.END|
|000032c0| 00 08 04 9c 00 00 00 04 | 02 04 00 02 00 07 00 07 |........|........|
|000032d0| 00 04 01 03 00 0f 15 00 | 05 00 07 00 07 00 0c 00 |........|........|
|000032e0| 02 03 00 00 0f 15 00 05 | 00 01 2d 1a 00 00 9b 11 |........|..-.....|
|000032f0| 00 02 02 07 43 01 4a 10 | 45 4d 50 4c 4f 59 45 45 |....C.J.|EMPLOYEE|
|00003300| 5f 50 52 4f 4a 45 43 54 | 00 47 2f 17 00 06 45 4d |_PROJECT|.G/...EM|
|00003310| 50 5f 4e 4f 29 00 00 00 | 01 00 ff 02 01 17 00 07 |P_NO)...|........|
|00003320| 50 52 4f 4a 5f 49 44 1a | 00 00 02 0e 01 02 01 1a |PROJ_ID.|........|
|00003330| 00 00 29 01 00 00 01 00 | 01 15 07 00 01 00 19 01 |..).....|........|
|00003340| 02 00 ff 9b ff ff ff ff | ff 0e 01 02 01 1a 00 00 |........|........|
|00003350| 29 01 00 00 01 00 01 15 | 07 00 00 00 19 01 02 00 |).......|........|
|00003360| ff ff 4c 09 10 53 51 4c | 24 47 45 54 5f 45 4d 50 |..L..SQL|$GET_EMP|
|00003370| 5f 50 52 4f 4a 0a 06 53 | 59 53 44 42 41 00 1c 01 |_PROJ..S|YSDBA...|
|00003380| 06 45 4d 50 5f 4e 4f 02 | 04 00 00 00 00 03 04 00 |.EMP_NO.|........|
|00003390| 00 00 00 04 06 52 44 42 | 24 33 32 00 1c 01 07 50 |.....RDB|$32....P|
|000033a0| 52 4f 4a 5f 49 44 02 04 | 00 00 00 00 03 04 01 00 |ROJ_ID..|........|
|000033b0| 00 00 04 06 52 44 42 24 | 33 33 00 1d 1b 01 0c 41 |....RDB$|33.....A|
|000033c0| 44 44 5f 45 4d 50 5f 50 | 52 4f 4a 02 04 02 00 00 |DD_EMP_P|ROJ.....|
|000033d0| 00 03 04 00 00 00 00 07 | 04 9f 00 00 00 0a 42 45 |........|......BE|
|000033e0| 47 49 4e 0a 20 42 45 47 | 49 4e 0a 20 49 4e 53 45 |GIN. BEG|IN. INSE|
|000033f0| 52 54 20 49 4e 54 4f 20 | 65 6d 70 6c 6f 79 65 65 |RT INTO |employee|
|00003400| 5f 70 72 6f 6a 65 63 74 | 20 28 65 6d 70 5f 6e 6f |_project| (emp_no|
|00003410| 2c 20 70 72 6f 6a 5f 69 | 64 29 20 56 41 4c 55 45 |, proj_i|d) VALUE|
|00003420| 53 20 28 3a 65 6d 70 5f | 6e 6f 2c 20 3a 70 72 6f |S (:emp_|no, :pro|
|00003430| 6a 5f 69 64 29 3b 0a 20 | 57 48 45 4e 20 53 51 4c |j_id);. |WHEN SQL|
|00003440| 43 4f 44 45 20 2d 35 33 | 30 20 44 4f 0a 20 20 45 |CODE -53|0 DO.  E|
|00003450| 58 43 45 50 54 49 4f 4e | 20 75 6e 6b 6e 6f 77 6e |XCEPTION| unknown|
|00003460| 5f 65 6d 70 5f 69 64 3b | 0a 20 45 4e 44 0a 20 53 |_emp_id;|. END. S|
|00003470| 55 53 50 45 4e 44 3b 0a | 45 4e 44 00 08 04 9d 00 |USPEND;.|END.....|
|00003480| 00 00 04 02 04 00 04 00 | 07 00 07 00 0f 15 00 05 |........|........|
|00003490| 00 07 00 04 01 01 00 07 | 00 0c 00 02 9b 11 00 02 |........|........|
|000034a0| 02 81 02 02 86 0f 4a 10 | 45 4d 50 4c 4f 59 45 45 |......J.|EMPLOYEE|
|000034b0| 5f 50 52 4f 4a 45 43 54 | 00 02 01 29 00 00 00 01 |_PROJECT|...)....|
|000034c0| 00 17 00 06 45 4d 50 5f | 4e 4f 01 29 00 02 00 03 |....EMP_|NO.)....|
|000034d0| 00 17 00 07 50 52 4f 4a | 5f 49 44 ff 87 ff ff 82 |....PROJ|_ID.....|
|000034e0| 01 00 01 ee fd 02 86 80 | 02 0e 55 4e 4b 4e 4f 57 |........|..UNKNOW|
|000034f0| 4e 5f 45 4d 50 5f 49 44 | 87 ff ff 02 0e 01 02 01 |N_EMP_ID|........|
|00003500| 15 07 00 01 00 19 01 00 | 00 ff 9b ff ff ff ff 0e |........|........|
|00003510| 01 02 01 15 07 00 00 00 | 19 01 00 00 ff ff 4c 09 |........|......L.|
|00003520| 10 53 51 4c 24 41 44 44 | 5f 45 4d 50 5f 50 52 4f |.SQL$ADD|_EMP_PRO|
|00003530| 4a 0a 06 53 59 53 44 42 | 41 00 1c 01 06 45 4d 50 |J..SYSDB|A....EMP|
|00003540| 5f 4e 4f 02 04 00 00 00 | 00 03 04 00 00 00 00 04 |_NO.....|........|
|00003550| 06 52 44 42 24 33 34 00 | 1c 01 07 50 52 4f 4a 5f |.RDB$34.|...PROJ_|
|00003560| 49 44 02 04 01 00 00 00 | 03 04 00 00 00 00 04 06 |ID......|........|
|00003570| 52 44 42 24 33 35 00 1d | 1b 01 0e 53 55 42 5f 54 |RDB$35..|...SUB_T|
|00003580| 4f 54 5f 42 55 44 47 45 | 54 02 04 01 00 00 00 03 |OT_BUDGE|T.......|
|00003590| 04 04 00 00 00 07 04 bc | 00 00 00 0a 42 45 47 49 |........|....BEGI|
|000035a0| 4e 0a 20 53 45 4c 45 43 | 54 20 53 55 4d 28 62 75 |N. SELEC|T SUM(bu|
|000035b0| 64 67 65 74 29 2c 20 41 | 56 47 28 62 75 64 67 65 |dget), A|VG(budge|
|000035c0| 74 29 2c 20 4d 49 4e 28 | 62 75 64 67 65 74 29 2c |t), MIN(|budget),|
|000035d0| 20 4d 41 58 28 62 75 64 | 67 65 74 29 0a 20 20 46 | MAX(bud|get).  F|
|000035e0| 52 4f 4d 20 64 65 70 61 | 72 74 6d 65 6e 74 0a 20 |ROM depa|rtment. |
|000035f0| 20 57 48 45 52 45 20 68 | 65 61 64 5f 64 65 70 74 | WHERE h|ead_dept|
|00003600| 20 3d 20 3a 68 65 61 64 | 5f 64 65 70 74 0a 20 20 | = :head|_dept.  |
|00003610| 49 4e 54 4f 20 3a 74 6f | 74 5f 62 75 64 67 65 74 |INTO :to|t_budget|
|00003620| 2c 20 3a 61 76 67 5f 62 | 75 64 67 65 74 2c 20 3a |, :avg_b|udget, :|
|00003630| 6d 69 6e 5f 62 75 64 67 | 65 74 2c 20 3a 6d 61 78 |min_budg|et, :max|
|00003640| 5f 62 75 64 67 65 74 3b | 0a 20 53 55 53 50 45 4e |_budget;|. SUSPEN|
|00003650| 44 3b 0a 45 4e 44 00 08 | 04 41 01 00 00 04 02 04 |D;.END..|.A......|
|00003660| 00 02 00 0f 15 00 03 00 | 07 00 04 01 09 00 1b 07 |........|........|
|00003670| 00 1b 07 00 1b 07 00 1b | 07 00 07 00 0c 00 02 03 |........|........|
|00003680| 00 00 1b 01 2d 1a 00 00 | 03 01 00 1b 01 2d 1a 01 |....-...|.....-..|
|00003690| 00 03 02 00 1b 01 2d 1a | 02 00 03 03 00 1b 01 2d |......-.|.......-|
|000036a0| 1a 03 00 9b 11 00 02 02 | 07 7f 43 01 4f 01 43 01 |........|..C.O.C.|
|000036b0| 4a 0a 44 45 50 41 52 54 | 4d 45 4e 54 00 47 2f 17 |J.DEPART|MENT.G/.|
|000036c0| 00 09 48 45 41 44 5f 44 | 45 50 54 29 00 00 00 01 |..HEAD_D|EPT)....|
|000036d0| 00 ff 4e 00 4d 04 00 00 | 00 54 17 00 06 42 55 44 |..N.M...|.T...BUD|
|000036e0| 47 45 54 01 00 55 17 00 | 06 42 55 44 47 45 54 02 |GET..U..|.BUDGET.|
|000036f0| 00 57 17 00 06 42 55 44 | 47 45 54 03 00 56 17 00 |.W...BUD|GET..V..|
|00003700| 06 42 55 44 47 45 54 ff | 02 01 18 01 03 00 1a 00 |.BUDGET.|........|
|00003710| 00 01 18 01 02 00 1a 01 | 00 01 18 01 01 00 1a 02 |........|........|
|00003720| 00 01 18 01 00 00 1a 03 | 00 ff 02 0e 01 02 01 1a |........|........|
|00003730| 00 00 29 01 00 00 01 00 | 01 1a 01 00 29 01 02 00 |..).....|....)...|
|00003740| 03 00 01 1a 02 00 29 01 | 04 00 05 00 01 1a 03 00 |......).|........|
|00003750| 29 01 06 00 07 00 01 15 | 07 00 01 00 19 01 08 00 |).......|........|
|00003760| ff 9b ff ff ff ff 0e 01 | 02 01 1a 00 00 29 01 00 |........|.....)..|
|00003770| 00 01 00 01 1a 01 00 29 | 01 02 00 03 00 01 1a 02 |.......)|........|
|00003780| 00 29 01 04 00 05 00 01 | 1a 03 00 29 01 06 00 07 |.)......|...)....|
|00003790| 00 01 15 07 00 00 00 19 | 01 08 00 ff ff 4c 09 12 |........|.....L..|
|000037a0| 53 51 4c 24 53 55 42 5f | 54 4f 54 5f 42 55 44 47 |SQL$SUB_|TOT_BUDG|
|000037b0| 45 54 0a 06 53 59 53 44 | 42 41 00 1c 01 09 48 45 |ET..SYSD|BA....HE|
|000037c0| 41 44 5f 44 45 50 54 02 | 04 00 00 00 00 03 04 00 |AD_DEPT.|........|
|000037d0| 00 00 00 04 06 52 44 42 | 24 33 36 00 1c 01 0a 54 |.....RDB|$36....T|
|000037e0| 4f 54 5f 42 55 44 47 45 | 54 02 04 00 00 00 00 03 |OT_BUDGE|T.......|
|000037f0| 04 01 00 00 00 04 06 52 | 44 42 24 33 37 00 1c 01 |.......R|DB$37...|
|00003800| 0a 41 56 47 5f 42 55 44 | 47 45 54 02 04 01 00 00 |.AVG_BUD|GET.....|
|00003810| 00 03 04 01 00 00 00 04 | 06 52 44 42 24 33 38 00 |........|.RDB$38.|
|00003820| 1c 01 0a 4d 49 4e 5f 42 | 55 44 47 45 54 02 04 02 |...MIN_B|UDGET...|
|00003830| 00 00 00 03 04 01 00 00 | 00 04 06 52 44 42 24 33 |........|...RDB$3|
|00003840| 39 00 1c 01 0a 4d 41 58 | 5f 42 55 44 47 45 54 02 |9....MAX|_BUDGET.|
|00003850| 04 03 00 00 00 03 04 01 | 00 00 00 04 06 52 44 42 |........|.....RDB|
|00003860| 24 34 30 00 1d 1b 01 0f | 44 45 4c 45 54 45 5f 45 |$40.....|DELETE_E|
|00003870| 4d 50 4c 4f 59 45 45 02 | 04 01 00 00 00 03 04 00 |MPLOYEE.|........|
|00003880| 00 00 00 07 04 cc 03 00 | 00 0a 20 44 45 43 4c 41 |........|.. DECLA|
|00003890| 52 45 20 56 41 52 49 41 | 42 4c 45 20 61 6e 79 5f |RE VARIA|BLE any_|
|000038a0| 73 61 6c 65 73 20 49 4e | 54 45 47 45 52 3b 0a 42 |sales IN|TEGER;.B|
|000038b0| 45 47 49 4e 0a 20 61 6e | 79 5f 73 61 6c 65 73 20 |EGIN. an|y_sales |
|000038c0| 3d 20 30 3b 0a 0a 20 2f | 2a 0a 20 20 2a 20 49 66 |= 0;.. /|*.  * If|
|000038d0| 20 74 68 65 72 65 20 61 | 72 65 20 61 6e 79 20 73 | there a|re any s|
|000038e0| 61 6c 65 73 20 72 65 63 | 6f 72 64 73 20 72 65 66 |ales rec|ords ref|
|000038f0| 65 72 65 6e 63 69 6e 67 | 20 74 68 69 73 20 65 6d |erencing| this em|
|00003900| 70 6c 6f 79 65 65 2c 0a | 20 20 2a 20 63 61 6e 27 |ployee,.|  * can'|
|00003910| 74 20 64 65 6c 65 74 65 | 20 74 68 65 20 65 6d 70 |t delete| the emp|
|00003920| 6c 6f 79 65 65 20 75 6e | 74 69 6c 20 74 68 65 20 |loyee un|til the |
|00003930| 73 61 6c 65 73 20 61 72 | 65 20 72 65 2d 61 73 73 |sales ar|e re-ass|
|00003940| 69 67 6e 65 64 0a 20 20 | 2a 20 74 6f 20 61 6e 6f |igned.  |* to ano|
|00003950| 74 68 65 72 20 65 6d 70 | 6c 6f 79 65 65 20 6f 72 |ther emp|loyee or|
|00003960| 20 63 68 61 6e 67 65 64 | 20 74 6f 20 4e 55 4c 4c | changed| to NULL|
|00003970| 2e 0a 20 20 2a 2f 0a 20 | 53 45 4c 45 43 54 20 63 |..  */. |SELECT c|
|00003980| 6f 75 6e 74 28 70 6f 5f | 6e 75 6d 62 65 72 29 0a |ount(po_|number).|
|00003990| 20 46 52 4f 4d 20 73 61 | 6c 65 73 0a 20 57 48 45 | FROM sa|les. WHE|
|000039a0| 52 45 20 73 61 6c 65 73 | 5f 72 65 70 20 3d 20 3a |RE sales|_rep = :|
|000039b0| 65 6d 70 5f 6e 75 6d 0a | 20 49 4e 54 4f 20 3a 61 |emp_num.| INTO :a|
|000039c0| 6e 79 5f 73 61 6c 65 73 | 3b 0a 0a 20 49 46 20 28 |ny_sales|;.. IF (|
|000039d0| 61 6e 79 5f 73 61 6c 65 | 73 20 3e 20 30 29 20 54 |any_sale|s > 0) T|
|000039e0| 48 45 4e 0a 20 42 45 47 | 49 4e 0a 20 20 45 58 43 |HEN. BEG|IN.  EXC|
|000039f0| 45 50 54 49 4f 4e 20 72 | 65 61 73 73 69 67 6e 5f |EPTION r|eassign_|
|00003a00| 73 61 6c 65 73 3b 0a 20 | 20 53 55 53 50 45 4e 44 |sales;. | SUSPEND|
|00003a10| 3b 0a 20 45 4e 44 0a 0a | 20 2f 2a 0a 20 20 2a 20 |;. END..| /*.  * |
|00003a20| 49 66 20 74 68 65 20 65 | 6d 70 6c 6f 79 65 65 20 |If the e|mployee |
|00003a30| 69 73 20 61 20 6d 61 6e | 61 67 65 72 2c 20 75 70 |is a man|ager, up|
|00003a40| 64 61 74 65 20 74 68 65 | 20 64 65 70 61 72 74 6d |date the| departm|
|00003a50| 65 6e 74 2e 0a 20 20 2a | 2f 0a 20 55 50 44 41 54 |ent..  *|/. UPDAT|
|00003a60| 45 20 64 65 70 61 72 74 | 6d 65 6e 74 0a 20 53 45 |E depart|ment. SE|
|00003a70| 54 20 6d 6e 67 72 5f 6e | 6f 20 3d 20 4e 55 4c 4c |T mngr_n|o = NULL|
|00003a80| 0a 20 57 48 45 52 45 20 | 6d 00 6e 67 72 5f 6e 6f |. WHERE |m.ngr_no|
|00003a90| 20 3d 20 3a 65 6d 70 5f | 6e 75 6d 3b 0a 0a 20 2f | = :emp_|num;.. /|
|00003aa0| 2a 0a 20 20 2a 20 49 66 | 20 74 68 65 20 65 6d 70 |*.  * If| the emp|
|00003ab0| 6c 6f 79 65 65 20 69 73 | 20 61 20 70 72 6f 6a 65 |loyee is| a proje|
|00003ac0| 63 74 20 6c 65 61 64 65 | 72 2c 20 75 70 64 61 74 |ct leade|r, updat|
|00003ad0| 65 20 70 72 6f 6a 65 63 | 74 2e 0a 20 20 2a 2f 0a |e projec|t..  */.|
|00003ae0| 20 55 50 44 41 54 45 20 | 70 72 6f 6a 65 63 74 0a | UPDATE |project.|
|00003af0| 20 53 45 54 20 74 65 61 | 6d 5f 6c 65 61 64 65 72 | SET tea|m_leader|
|00003b00| 20 3d 20 4e 55 4c 4c 0a | 20 57 48 45 52 45 20 74 | = NULL.| WHERE t|
|00003b10| 65 61 6d 5f 6c 65 61 64 | 65 72 20 3d 20 3a 65 6d |eam_lead|er = :em|
|00003b20| 70 5f 6e 75 6d 3b 0a 0a | 20 2f 2a 0a 20 20 2a 20 |p_num;..| /*.  * |
|00003b30| 44 65 6c 65 74 65 20 74 | 68 65 20 65 6d 70 6c 6f |Delete t|he emplo|
|00003b40| 79 65 65 20 66 72 6f 6d | 20 61 6e 79 20 70 72 6f |yee from| any pro|
|00003b50| 6a 65 63 74 73 2e 0a 20 | 20 2a 2f 0a 20 44 45 4c |jects.. | */. DEL|
|00003b60| 45 54 45 20 46 52 4f 4d | 20 65 6d 70 6c 6f 79 65 |ETE FROM| employe|
|00003b70| 65 5f 70 72 6f 6a 65 63 | 74 0a 20 57 48 45 52 45 |e_projec|t. WHERE|
|00003b80| 20 65 6d 70 5f 6e 6f 20 | 3d 20 3a 65 6d 70 5f 6e | emp_no |= :emp_n|
|00003b90| 75 6d 3b 0a 0a 20 2f 2a | 0a 20 20 2a 20 44 65 6c |um;.. /*|.  * Del|
|00003ba0| 65 74 65 20 6f 6c 64 20 | 73 61 6c 61 72 79 20 72 |ete old |salary r|
|00003bb0| 65 63 6f 72 64 73 2e 0a | 20 20 2a 2f 0a 20 44 45 |ecords..|  */. DE|
|00003bc0| 4c 45 54 45 20 46 52 4f | 4d 20 73 61 6c 61 72 79 |LETE FRO|M salary|
|00003bd0| 5f 68 69 73 74 6f 72 79 | 0a 20 57 48 45 52 45 20 |_history|. WHERE |
|00003be0| 65 6d 70 5f 6e 6f 20 3d | 20 3a 65 6d 70 5f 6e 75 |emp_no =| :emp_nu|
|00003bf0| 6d 3b 0a 0a 20 2f 2a 0a | 20 20 2a 20 44 65 6c 65 |m;.. /*.|  * Dele|
|00003c00| 74 65 20 74 68 65 20 65 | 6d 70 6c 6f 79 65 65 2e |te the e|mployee.|
|00003c10| 0a 20 20 2a 2f 0a 20 44 | 45 4c 45 54 45 20 46 52 |.  */. D|ELETE FR|
|00003c20| 4f 4d 20 65 6d 70 6c 6f | 79 65 65 0a 20 57 48 45 |OM emplo|yee. WHE|
|00003c30| 52 45 20 65 6d 70 5f 6e | 6f 20 3d 20 3a 65 6d 70 |RE emp_n|o = :emp|
|00003c40| 5f 6e 75 6d 3b 0a 0a 20 | 53 55 53 50 45 4e 44 3b |_num;.. |SUSPEND;|
|00003c50| 0a 45 4e 44 00 08 04 a9 | 01 00 00 04 02 04 00 02 |.END....|........|
|00003c60| 00 08 00 07 00 04 01 01 | 00 07 00 0c 00 02 03 00 |........|........|
|00003c70| 00 08 00 01 2d 1a 00 00 | 9b 11 00 02 02 01 15 08 |....-...|........|
|00003c80| 00 00 00 00 00 1a 00 00 | 07 7f 43 01 4f 01 43 01 |........|..C.O.C.|
|00003c90| 4a 05 53 41 4c 45 53 00 | 47 2f 17 00 09 53 41 4c |J.SALES.|G/...SAL|
|00003ca0| 45 53 5f 52 45 50 29 00 | 00 00 01 00 ff 4e 00 4d |ES_REP).|.....N.M|
|00003cb0| 01 00 00 00 5d 17 00 09 | 50 4f 5f 4e 55 4d 42 45 |....]...|PO_NUMBE|
|00003cc0| 52 ff 02 01 18 01 00 00 | 1a 00 00 ff 08 31 1a 00 |R.......|.....1..|
|00003cd0| 00 15 08 00 00 00 00 00 | 02 02 80 02 0e 52 45 41 |........|.....REA|
|00003ce0| 53 53 49 47 4e 5f 53 41 | 4c 45 53 02 0e 01 02 01 |SSIGN_SA|LES.....|
|00003cf0| 15 07 00 01 00 19 01 00 | 00 ff 9b ff ff ff ff 07 |........|........|
|00003d00| 43 01 4a 0a 44 45 50 41 | 52 54 4d 45 4e 54 02 47 |C.J.DEPA|RTMENT.G|
|00003d10| 2f 17 02 07 4d 4e 47 52 | 5f 4e 4f 29 00 00 00 01 |/...MNGR|_NO)....|
|00003d20| 00 ff 0a 02 02 02 01 2d | 17 02 07 4d 4e 47 52 5f |.......-|...MNGR_|
|00003d30| 4e 4f ff 07 43 01 4a 07 | 50 52 4f 4a 45 43 54 03 |NO..C.J.|PROJECT.|
|00003d40| 47 2f 17 03 0b 54 45 41 | 4d 5f 4c 45 41 44 45 52 |G/...TEA|M_LEADER|
|00003d50| 29 00 00 00 01 00 ff 0a | 03 03 02 01 2d 17 03 0b |).......|....-...|
|00003d60| 54 45 41 4d 5f 4c 45 41 | 44 45 52 ff 07 43 01 4a |TEAM_LEA|DER..C.J|
|00003d70| 10 45 4d 50 4c 4f 59 45 | 45 5f 50 52 4f 4a 45 43 |.EMPLOYE|E_PROJEC|
|00003d80| 54 04 47 2f 17 04 06 45 | 4d 50 5f 4e 4f 29 00 00 |T.G/...E|MP_NO)..|
|00003d90| 00 01 00 ff 05 04 07 43 | 01 4a 0e 53 41 4c 41 52 |.......C|.J.SALAR|
|00003da0| 59 5f 48 49 53 54 4f 52 | 59 05 47 2f 17 05 06 45 |Y_HISTOR|Y.G/...E|
|00003db0| 4d 50 5f 4e 4f 29 00 00 | 00 01 00 ff 05 05 07 43 |MP_NO)..|.......C|
|00003dc0| 01 4a 08 45 4d 50 4c 4f | 59 45 45 06 47 2f 17 06 |.J.EMPLO|YEE.G/..|
|00003dd0| 06 45 4d 50 5f 4e 4f 29 | 00 00 00 01 00 ff 05 06 |.EMP_NO)|........|
|00003de0| 02 0e 01 02 01 15 07 00 | 01 00 19 01 00 00 ff 9b |........|........|
|00003df0| ff ff ff ff 0e 01 02 01 | 15 07 00 00 00 19 01 00 |........|........|
|00003e00| 00 ff ff 4c 09 13 53 51 | 4c 24 44 45 4c 45 54 45 |...L..SQ|L$DELETE|
|00003e10| 5f 45 4d 50 4c 4f 59 45 | 45 0a 06 53 59 53 44 42 |_EMPLOYE|E..SYSDB|
|00003e20| 41 00 1c 01 07 45 4d 50 | 5f 4e 55 4d 02 04 00 00 |A....EMP|_NUM....|
|00003e30| 00 00 03 04 00 00 00 00 | 04 06 52 44 42 24 34 31 |........|..RDB$41|
|00003e40| 00 1d 1b 01 0b 44 45 50 | 54 5f 42 55 44 47 45 54 |.....DEP|T_BUDGET|
|00003e50| 02 04 01 00 00 00 03 04 | 01 00 00 00 07 04 e1 01 |........|........|
|00003e60| 00 00 0a 20 44 45 43 4c | 41 52 45 20 56 41 52 49 |... DECL|ARE VARI|
|00003e70| 41 42 4c 45 20 73 75 6d | 62 20 44 45 43 49 4d 41 |ABLE sum|b DECIMA|
|00003e80| 4c 28 31 32 2c 20 32 29 | 3b 0a 20 44 45 43 4c 41 |L(12, 2)|;. DECLA|
|00003e90| 52 45 20 56 41 52 49 41 | 42 4c 45 20 72 64 6e 6f |RE VARIA|BLE rdno|
|00003ea0| 20 43 48 41 52 28 33 29 | 3b 0a 20 44 45 43 4c 41 | CHAR(3)|;. DECLA|
|00003eb0| 52 45 20 56 41 52 49 41 | 42 4c 45 20 63 6e 74 20 |RE VARIA|BLE cnt |
|00003ec0| 49 4e 54 45 47 45 52 3b | 0a 42 45 47 49 4e 0a 20 |INTEGER;|.BEGIN. |
|00003ed0| 74 6f 74 20 3d 20 30 3b | 0a 0a 20 53 45 4c 45 43 |tot = 0;|.. SELEC|
|00003ee0| 54 20 62 75 64 67 65 74 | 20 46 52 4f 4d 20 64 65 |T budget| FROM de|
|00003ef0| 70 61 72 74 6d 65 6e 74 | 20 57 48 45 52 45 20 64 |partment| WHERE d|
|00003f00| 65 70 74 5f 6e 6f 20 3d | 20 3a 64 6e 6f 20 49 4e |ept_no =| :dno IN|
|00003f10| 54 4f 20 3a 74 6f 74 3b | 0a 0a 20 53 45 4c 45 43 |TO :tot;|.. SELEC|
|00003f20| 54 20 63 6f 75 6e 74 28 | 62 75 64 67 65 74 29 20 |T count(|budget) |
|00003f30| 46 52 4f 4d 20 64 65 70 | 61 72 74 6d 65 6e 74 20 |FROM dep|artment |
|00003f40| 57 48 45 52 45 20 68 65 | 61 64 5f 64 65 70 74 20 |WHERE he|ad_dept |
|00003f50| 3d 20 3a 64 6e 6f 20 49 | 4e 54 4f 20 3a 63 6e 74 |= :dno I|NTO :cnt|
|00003f60| 3b 0a 0a 20 49 46 20 28 | 63 6e 74 20 3d 20 30 29 |;.. IF (|cnt = 0)|
|00003f70| 20 54 48 45 4e 0a 20 20 | 53 55 53 50 45 4e 44 3b | THEN.  |SUSPEND;|
|00003f80| 0a 0a 20 46 4f 52 20 53 | 45 4c 45 43 54 20 64 65 |.. FOR S|ELECT de|
|00003f90| 70 74 5f 6e 6f 0a 20 20 | 46 52 4f 4d 20 64 65 70 |pt_no.  |FROM dep|
|00003fa0| 61 72 74 6d 65 6e 74 0a | 20 20 57 48 45 52 45 20 |artment.|  WHERE |
|00003fb0| 68 65 61 64 5f 64 65 70 | 74 20 3d 20 3a 64 6e 6f |head_dep|t = :dno|
|00003fc0| 0a 20 20 49 4e 54 4f 20 | 3a 72 64 6e 6f 0a 20 44 |.  INTO |:rdno. D|
|00003fd0| 4f 0a 20 20 42 45 47 49 | 4e 0a 20 20 20 45 58 45 |O.  BEGI|N.   EXE|
|00003fe0| 43 55 54 45 20 50 52 4f | 43 45 44 55 52 45 20 64 |CUTE PRO|CEDURE d|
|00003ff0| 65 70 74 5f 62 75 64 67 | 65 74 20 3a 72 64 6e 6f |ept_budg|et :rdno|
|00004000| 20 52 45 54 55 52 4e 49 | 4e 47 5f 56 41 4c 55 45 | RETURNI|NG_VALUE|
|00004010| 53 20 3a 73 75 6d 62 3b | 0a 20 20 20 74 6f 74 20 |S :sumb;|.   tot |
|00004020| 3d 20 74 6f 74 20 2b 20 | 73 75 6d 62 3b 0a 20 20 |= tot + |sumb;.  |
|00004030| 45 4e 44 0a 0a 20 53 55 | 53 50 45 4e 44 3b 0a 45 |END.. SU|SPEND;.E|
|00004040| 4e 44 00 08 04 86 01 00 | 00 04 02 04 00 02 00 0f |ND......|........|
|00004050| 15 00 03 00 07 00 04 01 | 03 00 1b 07 00 07 00 0c |........|........|
|00004060| 00 02 03 00 00 1b 01 2d | 1a 00 00 03 01 00 1b 01 |.......-|........|
|00004070| 2d 1a 01 00 03 02 00 0f | 15 00 03 00 01 2d 1a 02 |-.......|.....-..|
|00004080| 00 03 03 00 08 00 01 2d | 1a 03 00 9b 11 00 02 02 |.......-|........|
|00004090| 01 15 08 00 00 00 00 00 | 1a 00 00 07 7f 43 01 4a |........|.....C.J|
|000040a0| 0a 44 45 50 41 52 54 4d | 45 4e 54 00 47 2f 17 00 |.DEPARTM|ENT.G/..|
|000040b0| 07 44 45 50 54 5f 4e 4f | 29 00 00 00 01 00 ff 02 |.DEPT_NO|).......|
|000040c0| 01 17 00 06 42 55 44 47 | 45 54 1a 00 00 ff 07 7f |....BUDG|ET......|
|000040d0| 43 01 4f 02 43 01 4a 0a | 44 45 50 41 52 54 4d 45 |C.O.C.J.|DEPARTME|
|000040e0| 4e 54 01 47 2f 17 01 09 | 48 45 41 44 5f 44 45 50 |NT.G/...|HEAD_DEP|
|000040f0| 54 29 00 00 00 01 00 ff | 4e 00 4d 01 00 00 00 5d |T)......|N.M....]|
|00004100| 17 01 06 42 55 44 47 45 | 54 ff 02 01 18 02 00 00 |...BUDGE|T.......|
|00004110| 1a 03 00 ff 08 2f 1a 03 | 00 15 08 00 00 00 00 00 |...../..|........|
|00004120| 02 0e 01 02 01 1a 00 00 | 29 01 00 00 01 00 01 15 |........|).......|
|00004130| 07 00 01 00 19 01 02 00 | ff 9b ff ff 07 43 01 4a |........|.....C.J|
|00004140| 0a 44 45 50 41 52 54 4d | 45 4e 54 03 47 2f 17 03 |.DEPARTM|ENT.G/..|
|00004150| 09 48 45 41 44 5f 44 45 | 50 54 29 00 00 00 01 00 |.HEAD_DE|PT).....|
|00004160| ff 02 01 17 03 07 44 45 | 50 54 5f 4e 4f 1a 02 00 |......DE|PT_NO...|
|00004170| 02 02 78 0b 44 45 50 54 | 5f 42 55 44 47 45 54 01 |..x.DEPT|_BUDGET.|
|00004180| 00 1a 02 00 01 00 1a 01 | 00 01 22 1a 00 00 1a 01 |........|..".....|
|00004190| 00 1a 00 00 ff ff ff 02 | 0e 01 02 01 1a 00 00 29 |........|.......)|
|000041a0| 01 00 00 01 00 01 15 07 | 00 01 00 19 01 02 00 ff |........|........|
|000041b0| 9b ff ff ff ff 0e 01 02 | 01 1a 00 00 29 01 00 00 |........|....)...|
|000041c0| 01 00 01 15 07 00 00 00 | 19 01 02 00 ff ff 4c 09 |........|......L.|
|000041d0| 0f 53 51 4c 24 44 45 50 | 54 5f 42 55 44 47 45 54 |.SQL$DEP|T_BUDGET|
|000041e0| 0a 06 53 59 53 44 42 41 | 00 1c 01 03 44 4e 4f 02 |..SYSDBA|....DNO.|
|000041f0| 04 00 00 00 00 03 04 00 | 00 00 00 04 06 52 44 42 |........|.....RDB|
|00004200| 24 34 32 00 1c 01 03 54 | 4f 54 02 04 00 00 00 00 |$42....T|OT......|
|00004210| 03 04 01 00 00 00 04 06 | 52 44 42 24 34 33 00 1d |........|RDB$43..|
|00004220| 1b 01 09 4f 52 47 5f 43 | 48 41 52 54 02 04 00 00 |...ORG_C|HART....|
|00004230| 00 00 03 04 05 00 00 00 | 07 04 4b 02 00 00 0a 20 |........|..K.... |
|00004240| 44 45 43 4c 41 52 45 20 | 56 41 52 49 41 42 4c 45 |DECLARE |VARIABLE|
|00004250| 20 6d 6e 67 72 5f 6e 6f | 20 49 4e 54 45 47 45 52 | mngr_no| INTEGER|
|00004260| 3b 0a 20 44 45 43 4c 41 | 52 45 20 56 41 52 49 41 |;. DECLA|RE VARIA|
|00004270| 42 4c 45 20 64 6e 6f 20 | 43 48 41 52 28 33 29 3b |BLE dno |CHAR(3);|
|00004280| 0a 42 45 47 49 4e 0a 20 | 46 4f 52 20 53 45 4c 45 |.BEGIN. |FOR SELE|
|00004290| 43 54 20 68 2e 64 65 70 | 61 72 74 6d 65 6e 74 2c |CT h.dep|artment,|
|000042a0| 20 64 2e 64 65 70 61 72 | 74 6d 65 6e 74 2c 20 64 | d.depar|tment, d|
|000042b0| 2e 6d 6e 67 72 5f 6e 6f | 2c 20 64 2e 64 65 70 74 |.mngr_no|, d.dept|
|000042c0| 5f 6e 6f 0a 20 20 46 52 | 4f 4d 20 64 65 70 61 72 |_no.  FR|OM depar|
|000042d0| 74 6d 65 6e 74 20 64 0a | 20 20 4c 45 46 54 20 4f |tment d.|  LEFT O|
|000042e0| 55 54 45 52 20 4a 4f 49 | 4e 20 64 65 70 61 72 74 |UTER JOI|N depart|
|000042f0| 6d 65 6e 74 20 68 20 4f | 4e 20 64 2e 68 65 61 64 |ment h O|N d.head|
|00004300| 5f 64 65 70 74 20 3d 20 | 68 2e 64 65 70 74 5f 6e |_dept = |h.dept_n|
|00004310| 6f 0a 20 20 4f 52 44 45 | 52 20 42 59 20 64 2e 64 |o.  ORDE|R BY d.d|
|00004320| 65 70 74 5f 6e 6f 0a 20 | 20 49 4e 54 4f 20 3a 68 |ept_no. | INTO :h|
|00004330| 65 61 64 5f 64 65 70 74 | 2c 20 3a 64 65 70 61 72 |ead_dept|, :depar|
|00004340| 74 6d 65 6e 74 2c 20 3a | 6d 6e 67 72 5f 6e 6f 2c |tment, :|mngr_no,|
|00004350| 20 3a 64 6e 6f 0a 20 44 | 4f 0a 20 42 45 47 49 4e | :dno. D|O. BEGIN|
|00004360| 0a 20 20 49 46 20 28 3a | 6d 6e 67 72 5f 6e 6f 20 |.  IF (:|mngr_no |
|00004370| 49 53 20 4e 55 4c 4c 29 | 20 54 48 45 4e 0a 20 20 |IS NULL)| THEN.  |
|00004380| 42 45 47 49 4e 0a 20 20 | 20 6d 6e 67 72 5f 6e 61 |BEGIN.  | mngr_na|
|00004390| 6d 65 20 3d 20 22 2d 2d | 54 42 48 2d 2d 22 3b 0a |me = "--|TBH--";.|
|000043a0| 20 20 20 74 69 74 6c 65 | 20 3d 20 22 22 3b 0a 20 |   title| = "";. |
|000043b0| 20 45 4e 44 0a 0a 20 20 | 45 4c 53 45 0a 20 20 20 | END..  |ELSE.   |
|000043c0| 53 45 4c 45 43 54 20 66 | 75 6c 6c 5f 6e 61 6d 65 |SELECT f|ull_name|
|000043d0| 2c 20 6a 6f 62 5f 63 6f | 64 65 0a 20 20 20 46 52 |, job_co|de.   FR|
|000043e0| 4f 4d 20 65 6d 70 6c 6f | 79 65 65 0a 20 20 20 57 |OM emplo|yee.   W|
|000043f0| 48 45 52 45 20 65 6d 70 | 5f 6e 6f 20 3d 20 3a 6d |HERE emp|_no = :m|
|00004400| 6e 67 72 5f 6e 6f 0a 20 | 20 20 49 4e 54 4f 20 3a |ngr_no. |  INTO :|
|00004410| 6d 6e 67 72 5f 6e 61 6d | 65 2c 20 3a 74 69 74 6c |mngr_nam|e, :titl|
|00004420| 65 3b 0a 0a 20 20 53 45 | 4c 45 43 54 20 43 4f 55 |e;..  SE|LECT COU|
|00004430| 4e 54 28 65 6d 70 5f 6e | 6f 29 0a 20 20 46 00 52 |NT(emp_n|o).  F.R|
|00004440| 4f 4d 20 65 6d 70 6c 6f | 79 65 65 0a 20 20 57 48 |OM emplo|yee.  WH|
|00004450| 45 52 45 20 64 65 70 74 | 5f 6e 6f 20 3d 20 3a 64 |ERE dept|_no = :d|
|00004460| 6e 6f 0a 20 20 49 4e 54 | 4f 20 3a 65 6d 70 5f 63 |no.  INT|O :emp_c|
|00004470| 6e 74 3b 0a 0a 20 20 53 | 55 53 50 45 4e 44 3b 0a |nt;..  S|USPEND;.|
|00004480| 20 45 4e 44 0a 45 4e 44 | 00 08 04 3d 02 00 00 04 | END.END|...=....|
|00004490| 02 04 01 0b 00 0f 15 00 | 19 00 07 00 0f 15 00 19 |........|........|
|000044a0| 00 07 00 0f 15 00 14 00 | 07 00 0f 15 00 05 00 07 |........|........|
|000044b0| 00 08 00 07 00 07 00 02 | 03 00 00 0f 15 00 19 00 |........|........|
|000044c0| 01 2d 1a 00 00 03 01 00 | 0f 15 00 19 00 01 2d 1a |.-......|......-.|
|000044d0| 01 00 03 02 00 0f 15 00 | 14 00 01 2d 1a 02 00 03 |........|...-....|
|000044e0| 03 00 0f 15 00 05 00 01 | 2d 1a 03 00 03 04 00 08 |........|-.......|
|000044f0| 00 01 2d 1a 04 00 03 05 | 00 08 00 01 2d 1a 05 00 |..-.....|....-...|
|00004500| 03 06 00 0f 15 00 03 00 | 01 2d 1a 06 00 9b 11 00 |........|.-......|
|00004510| 02 02 07 43 01 77 02 92 | 0a 44 45 50 41 52 54 4d |...C.w..|.DEPARTM|
|00004520| 45 4e 54 01 44 00 92 0a | 44 45 50 41 52 54 4d 45 |ENT.D...|DEPARTME|
|00004530| 4e 54 01 48 01 50 01 47 | 2f 17 00 09 48 45 41 44 |NT.H.P.G|/...HEAD|
|00004540| 5f 44 45 50 54 17 01 07 | 44 45 50 54 5f 4e 4f ff |_DEPT...|DEPT_NO.|
|00004550| 46 01 48 17 00 07 44 45 | 50 54 5f 4e 4f ff 02 01 |F.H...DE|PT_NO...|
|00004560| 17 01 0a 44 45 50 41 52 | 54 4d 45 4e 54 1a 00 00 |...DEPAR|TMENT...|
|00004570| 01 17 00 0a 44 45 50 41 | 52 54 4d 45 4e 54 1a 01 |....DEPA|RTMENT..|
|00004580| 00 01 17 00 07 4d 4e 47 | 52 5f 4e 4f 1a 05 00 01 |.....MNG|R_NO....|
|00004590| 17 00 07 44 45 50 54 5f | 4e 4f 1a 06 00 02 02 08 |...DEPT_|NO......|
|000045a0| 3d 1a 05 00 02 02 01 15 | 0f 7f 00 07 00 2d 2d 54 |=.......|.....--T|
|000045b0| 42 48 2d 2d 1a 02 00 01 | 15 0f 7f 00 00 00 1a 03 |BH--....|........|
|000045c0| 00 ff ff 07 7f 43 01 4a | 08 45 4d 50 4c 4f 59 45 |.....C.J|.EMPLOYE|
|000045d0| 45 02 47 2f 17 02 06 45 | 4d 50 5f 4e 4f 1a 05 00 |E.G/...E|MP_NO...|
|000045e0| ff 02 01 17 02 09 46 55 | 4c 4c 5f 4e 41 4d 45 1a |......FU|LL_NAME.|
|000045f0| 02 00 01 17 02 08 4a 4f | 42 5f 43 4f 44 45 1a 03 |......JO|B_CODE..|
|00004600| 00 ff 07 7f 43 01 4f 04 | 43 01 4a 08 45 4d 50 4c |....C.O.|C.J.EMPL|
|00004610| 4f 59 45 45 03 47 2f 17 | 03 07 44 45 50 54 5f 4e |OYEE.G/.|..DEPT_N|
|00004620| 4f 1a 06 00 ff 4e 00 4d | 01 00 00 00 5d 17 03 06 |O....N.M|....]...|
|00004630| 45 4d 50 5f 4e 4f ff 02 | 01 18 04 00 00 1a 04 00 |EMP_NO..|........|
|00004640| ff 02 0e 01 02 01 1a 00 | 00 29 01 00 00 01 00 01 |........|.)......|
|00004650| 1a 01 00 29 01 02 00 03 | 00 01 1a 02 00 29 01 04 |...)....|.....)..|
|00004660| 00 05 00 01 1a 03 00 29 | 01 06 00 07 00 01 1a 04 |.......)|........|
|00004670| 00 29 01 08 00 09 00 01 | 15 07 00 01 00 19 01 0a |.)......|........|
|00004680| 00 ff 9b ff ff ff ff ff | ff ff 0e 01 02 01 1a 00 |........|........|
|00004690| 00 29 01 00 00 01 00 01 | 1a 01 00 29 01 02 00 03 |.)......|...)....|
|000046a0| 00 01 1a 02 00 29 01 04 | 00 05 00 01 1a 03 00 29 |.....)..|.......)|
|000046b0| 01 06 00 07 00 01 1a 04 | 00 29 01 08 00 09 00 01 |........|.)......|
|000046c0| 15 07 00 00 00 19 01 0a | 00 ff ff 4c 09 0d 53 51 |........|...L..SQ|
|000046d0| 4c 24 4f 52 47 5f 43 48 | 41 52 54 0a 06 53 59 53 |L$ORG_CH|ART..SYS|
|000046e0| 44 42 41 00 1c 01 09 48 | 45 41 44 5f 44 45 50 54 |DBA....H|EAD_DEPT|
|000046f0| 02 04 00 00 00 00 03 04 | 01 00 00 00 04 06 52 44 |........|......RD|
|00004700| 42 24 34 34 00 1c 01 0a | 44 45 50 41 52 54 4d 45 |B$44....|DEPARTME|
|00004710| 4e 54 02 04 01 00 00 00 | 03 04 01 00 00 00 04 06 |NT......|........|
|00004720| 52 44 42 24 34 35 00 1c | 01 09 4d 4e 47 52 5f 4e |RDB$45..|..MNGR_N|
|00004730| 41 4d 45 02 04 02 00 00 | 00 03 04 01 00 00 00 04 |AME.....|........|
|00004740| 06 52 44 42 24 34 36 00 | 1c 01 05 54 49 54 4c 45 |.RDB$46.|...TITLE|
|00004750| 02 04 03 00 00 00 03 04 | 01 00 00 00 04 06 52 44 |........|......RD|
|00004760| 42 24 34 37 00 1c 01 07 | 45 4d 50 5f 43 4e 54 02 |B$47....|EMP_CNT.|
|00004770| 04 04 00 00 00 03 04 01 | 00 00 00 04 06 52 44 42 |........|.....RDB|
|00004780| 24 34 38 00 1d 1b 01 0a | 4d 41 49 4c 5f 4c 41 42 |$48.....|MAIL_LAB|
|00004790| 45 4c 02 04 01 00 00 00 | 03 04 06 00 00 00 07 04 |EL......|........|
|000047a0| f8 04 00 00 0a 20 44 45 | 43 4c 41 52 45 20 56 41 |..... DE|CLARE VA|
|000047b0| 52 49 41 42 4c 45 20 63 | 75 73 74 6f 6d 65 72 20 |RIABLE c|ustomer |
|000047c0| 56 41 52 43 48 41 52 28 | 32 35 29 3b 0a 20 44 45 |VARCHAR(|25);. DE|
|000047d0| 43 4c 41 52 45 20 56 41 | 52 49 41 42 4c 45 20 66 |CLARE VA|RIABLE f|
|000047e0| 69 72 73 74 20 20 56 41 | 52 43 48 41 52 28 31 35 |irst  VA|RCHAR(15|
|000047f0| 29 3b 0a 20 44 45 43 4c | 41 52 45 20 56 41 52 49 |);. DECL|ARE VARI|
|00004800| 41 42 4c 45 20 6c 61 73 | 74 20 20 56 41 52 43 48 |ABLE las|t  VARCH|
|00004810| 41 52 28 32 30 29 3b 0a | 20 44 45 43 4c 41 52 45 |AR(20);.| DECLARE|
|00004820| 20 56 41 52 49 41 42 4c | 45 20 61 64 64 72 31 20 | VARIABL|E addr1 |
|00004830| 20 56 41 52 43 48 41 52 | 28 33 30 29 3b 0a 20 44 | VARCHAR|(30);. D|
|00004840| 45 43 4c 41 52 45 20 56 | 41 52 49 41 42 4c 45 20 |ECLARE V|ARIABLE |
|00004850| 61 64 64 72 32 20 20 56 | 41 52 43 48 41 52 28 33 |addr2  V|ARCHAR(3|
|00004860| 30 29 3b 0a 20 44 45 43 | 4c 41 52 45 20 56 41 52 |0);. DEC|LARE VAR|
|00004870| 49 41 42 4c 45 20 63 69 | 74 79 20 20 56 41 52 43 |IABLE ci|ty  VARC|
|00004880| 48 41 52 28 32 35 29 3b | 0a 20 44 45 43 4c 41 52 |HAR(25);|. DECLAR|
|00004890| 45 20 56 41 52 49 41 42 | 4c 45 20 73 74 61 74 65 |E VARIAB|LE state|
|000048a0| 20 20 56 41 52 43 48 41 | 52 28 31 35 29 3b 0a 20 |  VARCHA|R(15);. |
|000048b0| 44 45 43 4c 41 52 45 20 | 56 41 52 49 41 42 4c 45 |DECLARE |VARIABLE|
|000048c0| 20 63 6f 75 6e 74 72 79 | 20 56 41 52 43 48 41 52 | country| VARCHAR|
|000048d0| 28 31 35 29 3b 0a 20 44 | 45 43 4c 41 52 45 20 56 |(15);. D|ECLARE V|
|000048e0| 41 52 49 41 42 4c 45 20 | 70 6f 73 74 63 6f 64 65 |ARIABLE |postcode|
|000048f0| 20 56 41 52 43 48 41 52 | 28 31 32 29 3b 0a 20 44 | VARCHAR|(12);. D|
|00004900| 45 43 4c 41 52 45 20 56 | 41 52 49 41 42 4c 45 20 |ECLARE V|ARIABLE |
|00004910| 63 6e 74 20 20 49 4e 54 | 45 47 45 52 3b 0a 42 45 |cnt  INT|EGER;.BE|
|00004920| 47 49 4e 0a 20 6c 69 6e | 65 31 20 3d 20 22 22 3b |GIN. lin|e1 = "";|
|00004930| 0a 20 6c 69 6e 65 32 20 | 3d 20 22 22 3b 0a 20 6c |. line2 |= "";. l|
|00004940| 69 6e 65 33 20 3d 20 22 | 22 3b 0a 20 6c 69 6e 65 |ine3 = "|";. line|
|00004950| 34 20 3d 20 22 22 3b 0a | 20 6c 69 6e 65 35 20 3d |4 = "";.| line5 =|
|00004960| 20 22 22 3b 0a 20 6c 69 | 6e 65 36 20 3d 20 22 22 | "";. li|ne6 = ""|
|00004970| 3b 0a 0a 20 53 45 4c 45 | 43 54 20 63 75 73 74 6f |;.. SELE|CT custo|
|00004980| 6d 65 72 2c 20 63 6f 6e | 74 61 63 74 5f 66 69 72 |mer, con|tact_fir|
|00004990| 73 74 2c 20 63 6f 6e 74 | 61 63 74 5f 6c 61 73 74 |st, cont|act_last|
|000049a0| 2c 20 61 64 00 64 72 65 | 73 73 5f 6c 69 6e 65 31 |, ad.dre|ss_line1|
|000049b0| 2c 0a 20 20 61 64 64 72 | 65 73 73 5f 6c 69 6e 65 |,.  addr|ess_line|
|000049c0| 32 2c 20 63 69 74 79 2c | 20 73 74 61 74 65 5f 70 |2, city,| state_p|
|000049d0| 72 6f 76 69 6e 63 65 2c | 20 63 6f 75 6e 74 72 79 |rovince,| country|
|000049e0| 2c 20 70 6f 73 74 61 6c | 5f 63 6f 64 65 0a 20 46 |, postal|_code. F|
|000049f0| 52 4f 4d 20 43 55 53 54 | 4f 4d 45 52 0a 20 57 48 |ROM CUST|OMER. WH|
|00004a00| 45 52 45 20 63 75 73 74 | 5f 6e 6f 20 3d 20 3a 63 |ERE cust|_no = :c|
|00004a10| 75 73 74 5f 6e 6f 0a 20 | 49 4e 54 4f 20 3a 63 75 |ust_no. |INTO :cu|
|00004a20| 73 74 6f 6d 65 72 2c 20 | 3a 66 69 72 73 74 2c 20 |stomer, |:first, |
|00004a30| 3a 6c 61 73 74 2c 20 3a | 61 64 64 72 31 2c 20 3a |:last, :|addr1, :|
|00004a40| 61 64 64 72 32 2c 0a 20 | 20 3a 63 69 74 79 2c 20 |addr2,. | :city, |
|00004a50| 3a 73 74 61 74 65 2c 20 | 3a 63 6f 75 6e 74 72 79 |:state, |:country|
|00004a60| 2c 20 3a 70 6f 73 74 63 | 6f 64 65 3b 0a 0a 20 49 |, :postc|ode;.. I|
|00004a70| 46 20 28 63 75 73 74 6f | 6d 65 72 20 49 53 20 4e |F (custo|mer IS N|
|00004a80| 4f 54 20 4e 55 4c 4c 29 | 20 54 48 45 4e 0a 20 20 |OT NULL)| THEN.  |
|00004a90| 6c 69 6e 65 31 20 3d 20 | 63 75 73 74 6f 6d 65 72 |line1 = |customer|
|00004aa0| 3b 0a 20 49 46 20 28 66 | 69 72 73 74 20 49 53 20 |;. IF (f|irst IS |
|00004ab0| 4e 4f 54 20 4e 55 4c 4c | 29 20 54 48 45 4e 0a 20 |NOT NULL|) THEN. |
|00004ac0| 20 6c 69 6e 65 32 20 3d | 20 66 69 72 73 74 20 7c | line2 =| first ||
|00004ad0| 7c 20 22 20 22 20 7c 7c | 20 6c 61 73 74 3b 0a 20 || " " ||| last;. |
|00004ae0| 45 4c 53 45 0a 20 20 6c | 69 6e 65 32 20 3d 20 6c |ELSE.  l|ine2 = l|
|00004af0| 61 73 74 3b 0a 20 49 46 | 20 28 61 64 64 72 31 20 |ast;. IF| (addr1 |
|00004b00| 49 53 20 4e 4f 54 20 4e | 55 4c 4c 29 20 54 48 45 |IS NOT N|ULL) THE|
|00004b10| 4e 0a 20 20 6c 69 6e 65 | 33 20 3d 20 61 64 64 72 |N.  line|3 = addr|
|00004b20| 31 3b 0a 20 49 46 20 28 | 61 64 64 72 32 20 49 53 |1;. IF (|addr2 IS|
|00004b30| 20 4e 4f 54 20 4e 55 4c | 4c 29 20 54 48 45 4e 0a | NOT NUL|L) THEN.|
|00004b40| 20 20 6c 69 6e 65 34 20 | 3d 20 61 64 64 72 32 3b |  line4 |= addr2;|
|00004b50| 0a 0a 20 49 46 20 28 63 | 6f 75 6e 74 72 79 20 3d |.. IF (c|ountry =|
|00004b60| 20 22 55 53 41 22 29 20 | 54 48 45 4e 0a 20 42 45 | "USA") |THEN. BE|
|00004b70| 47 49 4e 0a 20 20 49 46 | 20 28 63 69 74 79 20 49 |GIN.  IF| (city I|
|00004b80| 53 20 4e 4f 54 20 4e 55 | 4c 4c 29 20 54 48 45 4e |S NOT NU|LL) THEN|
|00004b90| 0a 20 20 20 6c 69 6e 65 | 35 20 3d 20 63 69 74 79 |.   line|5 = city|
|00004ba0| 20 7c 7c 20 22 00 2c 20 | 22 20 7c 7c 20 73 74 61 | || "., |" || sta|
|00004bb0| 74 65 20 7c 7c 20 22 20 | 20 22 20 7c 7c 20 70 6f |te || " | " || po|
|00004bc0| 73 74 63 6f 64 65 3b 0a | 20 20 45 4c 53 45 0a 20 |stcode;.|  ELSE. |
|00004bd0| 20 20 6c 69 6e 65 35 20 | 3d 20 73 74 61 74 65 20 |  line5 |= state |
|00004be0| 7c 7c 20 22 20 20 22 20 | 7c 7c 20 70 6f 73 74 63 ||| "  " ||| postc|
|00004bf0| 6f 64 65 3b 0a 20 45 4e | 44 0a 20 45 4c 53 45 0a |ode;. EN|D. ELSE.|
|00004c00| 20 42 45 47 49 4e 0a 20 | 20 49 46 20 28 63 69 74 | BEGIN. | IF (cit|
|00004c10| 79 20 49 53 20 4e 4f 54 | 20 4e 55 4c 4c 29 20 54 |y IS NOT| NULL) T|
|00004c20| 48 45 4e 0a 20 20 20 6c | 69 6e 65 35 20 3d 20 63 |HEN.   l|ine5 = c|
|00004c30| 69 74 79 20 7c 7c 20 22 | 2c 20 22 20 7c 7c 20 73 |ity || "|, " || s|
|00004c40| 74 61 74 65 3b 0a 20 20 | 45 4c 53 45 0a 20 20 20 |tate;.  |ELSE.   |
|00004c50| 6c 69 6e 65 35 20 3d 20 | 73 74 61 74 65 3b 0a 20 |line5 = |state;. |
|00004c60| 20 6c 69 6e 65 36 20 3d | 20 63 6f 75 6e 74 72 79 | line6 =| country|
|00004c70| 20 7c 7c 20 22 20 20 20 | 20 22 20 7c 7c 20 70 6f | || "   | " || po|
|00004c80| 73 74 63 6f 64 65 3b 0a | 20 45 4e 44 0a 0a 20 53 |stcode;.| END.. S|
|00004c90| 55 53 50 45 4e 44 3b 0a | 45 4e 44 00 08 04 7b 03 |USPEND;.|END...{.|
|00004ca0| 00 00 04 02 04 00 02 00 | 08 00 07 00 04 01 0d 00 |........|........|
|00004cb0| 0f 15 00 28 00 07 00 0f | 15 00 28 00 07 00 0f 15 |...(....|..(.....|
|00004cc0| 00 28 00 07 00 0f 15 00 | 28 00 07 00 0f 15 00 28 |.(......|(......(|
|00004cd0| 00 07 00 0f 15 00 28 00 | 07 00 07 00 0c 00 02 03 |......(.|........|
|00004ce0| 00 00 0f 15 00 28 00 01 | 2d 1a 00 00 03 01 00 0f |.....(..|-.......|
|00004cf0| 15 00 28 00 01 2d 1a 01 | 00 03 02 00 0f 15 00 28 |..(..-..|.......(|
|00004d00| 00 01 2d 1a 02 00 03 03 | 00 0f 15 00 28 00 01 2d |..-.....|....(..-|
|00004d10| 1a 03 00 03 04 00 0f 15 | 00 28 00 01 2d 1a 04 00 |........|.(..-...|
|00004d20| 03 05 00 0f 15 00 28 00 | 01 2d 1a 05 00 03 06 00 |......(.|.-......|
|00004d30| 26 15 00 19 00 01 2d 1a | 06 00 03 07 00 26 15 00 |&.....-.|.....&..|
|00004d40| 0f 00 01 2d 1a 07 00 03 | 08 00 26 15 00 14 00 01 |...-....|..&.....|
|00004d50| 2d 1a 08 00 03 09 00 26 | 15 00 1e 00 01 2d 1a 09 |-......&|.....-..|
|00004d60| 00 03 0a 00 26 15 00 1e | 00 01 2d 1a 0a 00 03 0b |....&...|..-.....|
|00004d70| 00 26 15 00 19 00 01 2d | 1a 0b 00 03 0c 00 26 15 |.&.....-|......&.|
|00004d80| 00 0f 00 01 2d 1a 0c 00 | 03 0d 00 26 15 00 0f 00 |....-...|...&....|
|00004d90| 01 2d 1a 0d 00 03 0e 00 | 26 15 00 0c 00 01 2d 1a |.-......|&.....-.|
|00004da0| 0e 00 03 0f 00 08 00 01 | 2d 1a 0f 00 9b 11 00 02 |........|-.......|
|00004db0| 02 01 15 0f 7f 00 00 00 | 1a 00 00 01 15 0f 7f 00 |........|........|
|00004dc0| 00 00 1a 01 00 01 15 0f | 7f 00 00 00 1a 02 00 01 |........|........|
|00004dd0| 15 0f 7f 00 00 00 1a 03 | 00 01 15 0f 7f 00 00 00 |........|........|
|00004de0| 1a 04 00 01 15 0f 7f 00 | 00 00 1a 05 00 07 7f 43 |........|.......C|
|00004df0| 01 4a 08 43 55 53 54 4f | 4d 45 52 00 47 2f 17 00 |.J.CUSTO|MER.G/..|
|00004e00| 07 43 55 53 54 5f 4e 4f | 29 00 00 00 01 00 ff 02 |.CUST_NO|).......|
|00004e10| 01 17 00 08 43 55 53 54 | 4f 4d 45 52 1a 06 00 01 |....CUST|OMER....|
|00004e20| 17 00 0d 43 4f 4e 54 41 | 43 54 5f 46 49 52 53 54 |...CONTA|CT_FIRST|
|00004e30| 1a 07 00 01 17 00 0c 43 | 4f 4e 54 41 43 54 5f 4c |.......C|ONTACT_L|
|00004e40| 41 53 54 1a 08 00 01 17 | 00 0d 41 44 44 52 45 53 |AST.....|..ADDRES|
|00004e50| 53 5f 4c 49 4e 45 31 1a | 09 00 01 17 00 0d 41 44 |S_LINE1.|......AD|
|00004e60| 44 52 45 53 53 5f 4c 49 | 4e 45 32 1a 0a 00 01 17 |DRESS_LI|NE2.....|
|00004e70| 00 04 43 49 54 59 1a 0b | 00 01 17 00 0e 53 54 41 |..CITY..|.....STA|
|00004e80| 54 45 5f 50 52 4f 56 49 | 4e 43 45 1a 0c 00 01 17 |TE_PROVI|NCE.....|
|00004e90| 00 07 43 4f 55 4e 54 52 | 59 1a 0d 00 01 17 00 0b |..COUNTR|Y.......|
|00004ea0| 50 4f 53 54 41 4c 5f 43 | 4f 44 45 1a 0e 00 ff 08 |POSTAL_C|ODE.....|
|00004eb0| 3b 3d 1a 06 00 01 1a 06 | 00 1a 00 00 ff 08 3b 3d |;=......|......;=|
|00004ec0| 1a 07 00 01 27 27 1a 07 | 00 15 0f 7f 00 01 00 20 |....''..|....... |
|00004ed0| 1a 08 00 1a 01 00 01 1a | 08 00 1a 01 00 08 3b 3d |........|......;=|
|00004ee0| 1a 09 00 01 1a 09 00 1a | 02 00 ff 08 3b 3d 1a 0a |........|....;=..|
|00004ef0| 00 01 1a 0a 00 1a 03 00 | ff 08 2f 1a 0d 00 15 0f |........|../.....|
|00004f00| 7f 00 03 00 55 53 41 02 | 02 08 3b 3d 1a 0b 00 01 |....USA.|..;=....|
|00004f10| 27 27 27 27 1a 0b 00 15 | 0f 7f 00 02 00 2c 20 1a |''''....|....., .|
|00004f20| 0c 00 15 0f 7f 00 02 00 | 20 20 1a 0e 00 1a 04 00 |........|  ......|
|00004f30| 01 27 27 1a 0c 00 15 0f | 7f 00 02 00 20 20 1a 0e |.''.....|....  ..|
|00004f40| 00 1a 04 00 ff ff 02 02 | 08 3b 3d 1a 0b 00 01 27 |........|.;=....'|
|00004f50| 27 1a 0b 00 15 0f 7f 00 | 02 00 2c 20 1a 0c 00 1a |'.......|.., ....|
|00004f60| 04 00 01 1a 0c 00 1a 04 | 00 01 27 27 1a 0d 00 15 |........|..''....|
|00004f70| 0f 7f 00 04 00 20 20 20 | 20 1a 0e 00 1a 05 00 ff |.....   | .......|
|00004f80| ff 02 0e 01 02 01 1a 00 | 00 29 01 00 00 01 00 01 |........|.)......|
|00004f90| 1a 01 00 29 01 02 00 03 | 00 01 1a 02 00 29 01 04 |...)....|.....)..|
|00004fa0| 00 05 00 01 1a 03 00 29 | 01 06 00 07 00 01 1a 04 |.......)|........|
|00004fb0| 00 29 01 08 00 09 00 01 | 1a 05 00 29 01 0a 00 0b |.)......|...)....|
|00004fc0| 00 01 15 07 00 01 00 19 | 01 0c 00 ff 9b ff ff ff |........|........|
|00004fd0| ff 0e 01 02 01 1a 00 00 | 29 01 00 00 01 00 01 1a |........|).......|
|00004fe0| 01 00 29 01 02 00 03 00 | 01 1a 02 00 29 01 04 00 |..).....|....)...|
|00004ff0| 05 00 01 1a 03 00 29 01 | 06 00 07 00 01 1a 04 00 |......).|........|
|00005000| 29 01 08 00 09 00 01 1a | 05 00 29 01 0a 00 0b 00 |).......|..).....|
|00005010| 01 15 07 00 00 00 19 01 | 0c 00 ff ff 4c 09 0e 53 |........|....L..S|
|00005020| 51 4c 24 4d 41 49 4c 5f | 4c 41 42 45 4c 0a 06 53 |QL$MAIL_|LABEL..S|
|00005030| 59 53 44 42 41 00 1c 01 | 07 43 55 53 54 5f 4e 4f |YSDBA...|.CUST_NO|
|00005040| 02 04 00 00 00 00 03 04 | 00 00 00 00 04 06 52 44 |........|......RD|
|00005050| 42 24 34 39 00 1c 01 05 | 4c 49 4e 45 31 02 04 00 |B$49....|LINE1...|
|00005060| 00 00 00 03 04 01 00 00 | 00 04 06 52 44 42 24 35 |........|...RDB$5|
|00005070| 30 00 1c 01 05 4c 49 4e | 45 32 02 04 01 00 00 00 |0....LIN|E2......|
|00005080| 03 04 01 00 00 00 04 06 | 52 44 42 24 35 31 00 1c |........|RDB$51..|
|00005090| 01 05 4c 49 4e 45 33 02 | 04 02 00 00 00 03 04 01 |..LINE3.|........|
|000050a0| 00 00 00 04 06 52 44 42 | 24 35 32 00 1c 01 05 4c |.....RDB|$52....L|
|000050b0| 49 4e 45 34 02 04 03 00 | 00 00 03 04 01 00 00 00 |INE4....|........|
|000050c0| 04 06 52 44 42 24 35 33 | 00 1c 01 05 4c 49 4e 45 |..RDB$53|....LINE|
|000050d0| 35 02 04 04 00 00 00 03 | 04 01 00 00 00 04 06 52 |5.......|.......R|
|000050e0| 44 42 24 35 34 00 1c 01 | 05 4c 49 4e 45 36 02 04 |DB$54...|.LINE6..|
|000050f0| 05 00 00 00 03 04 01 00 | 00 00 04 06 52 44 42 24 |........|....RDB$|
|00005100| 35 35 00 1d 1b 01 0a 53 | 48 49 50 5f 4f 52 44 45 |55.....S|HIP_ORDE|
|00005110| 52 02 04 01 00 00 00 03 | 04 00 00 00 00 07 04 49 |R.......|.......I|
|00005120| 04 00 00 0a 20 44 45 43 | 4c 41 52 45 20 56 41 52 |.... DEC|LARE VAR|
|00005130| 49 41 42 4c 45 20 6f 72 | 64 5f 73 74 61 74 20 43 |IABLE or|d_stat C|
|00005140| 48 41 52 28 37 29 3b 0a | 20 44 45 43 4c 41 52 45 |HAR(7);.| DECLARE|
|00005150| 20 56 41 52 49 41 42 4c | 45 20 68 6f 6c 64 5f 73 | VARIABL|E hold_s|
|00005160| 74 61 74 20 43 48 41 52 | 28 31 29 3b 0a 20 44 45 |tat CHAR|(1);. DE|
|00005170| 43 4c 41 52 45 20 56 41 | 52 49 41 42 4c 45 20 63 |CLARE VA|RIABLE c|
|00005180| 75 73 74 5f 6e 6f 20 49 | 4e 54 45 47 45 52 3b 0a |ust_no I|NTEGER;.|
|00005190| 20 44 45 43 4c 41 52 45 | 20 56 41 52 49 41 42 4c | DECLARE| VARIABL|
|000051a0| 45 20 61 6e 79 5f 70 6f | 20 43 48 41 52 28 38 29 |E any_po| CHAR(8)|
|000051b0| 3b 0a 42 45 47 49 4e 0a | 20 53 45 4c 45 43 54 20 |;.BEGIN.| SELECT |
|000051c0| 73 2e 6f 72 64 65 72 5f | 73 74 61 74 75 73 2c 20 |s.order_|status, |
|000051d0| 63 2e 6f 6e 5f 68 6f 6c | 64 2c 20 63 2e 63 75 73 |c.on_hol|d, c.cus|
|000051e0| 74 5f 6e 6f 0a 20 46 52 | 4f 4d 20 73 61 6c 65 73 |t_no. FR|OM sales|
|000051f0| 20 73 2c 20 63 75 73 74 | 6f 6d 65 72 20 63 0a 20 | s, cust|omer c. |
|00005200| 57 48 45 52 45 20 70 6f | 5f 6e 75 6d 62 65 72 20 |WHERE po|_number |
|00005210| 3d 20 3a 70 6f 5f 6e 75 | 6d 0a 20 41 4e 44 20 73 |= :po_nu|m. AND s|
|00005220| 2e 63 75 73 74 5f 6e 6f | 20 3d 20 63 2e 63 75 73 |.cust_no| = c.cus|
|00005230| 74 5f 6e 6f 0a 20 49 4e | 54 4f 20 3a 6f 72 64 5f |t_no. IN|TO :ord_|
|00005240| 73 74 61 74 2c 20 3a 68 | 6f 6c 64 5f 73 74 61 74 |stat, :h|old_stat|
|00005250| 2c 20 3a 63 75 73 74 5f | 6e 6f 3b 0a 0a 20 2f 2a |, :cust_|no;.. /*|
|00005260| 20 54 68 69 73 20 70 75 | 72 63 68 61 73 65 20 6f | This pu|rchase o|
|00005270| 72 64 65 72 20 68 61 73 | 20 62 65 65 6e 20 61 6c |rder has| been al|
|00005280| 72 65 61 64 79 20 73 68 | 69 70 70 65 64 2e 20 2a |ready sh|ipped. *|
|00005290| 2f 0a 20 49 46 20 28 6f | 72 64 5f 73 74 61 74 20 |/. IF (o|rd_stat |
|000052a0| 3d 20 22 73 68 69 70 70 | 65 64 22 29 20 54 48 45 |= "shipp|ed") THE|
|000052b0| 4e 0a 20 42 45 47 49 4e | 0a 20 20 45 58 43 45 50 |N. BEGIN|.  EXCEP|
|000052c0| 54 49 4f 4e 20 6f 72 64 | 65 72 5f 61 6c 72 65 61 |TION ord|er_alrea|
|000052d0| 64 79 5f 73 68 69 70 70 | 65 64 3b 0a 20 20 53 55 |dy_shipp|ed;.  SU|
|000052e0| 53 50 45 4e 44 3b 0a 20 | 45 4e 44 0a 0a 20 2f 2a |SPEND;. |END.. /*|
|000052f0| 20 43 75 73 74 6f 6d 65 | 72 20 69 73 20 6f 6e 20 | Custome|r is on |
|00005300| 68 6f 6c 64 2e 20 2a 2f | 0a 20 45 4c 53 45 20 49 |hold. */|. ELSE I|
|00005310| 46 20 28 68 6f 6c 64 5f | 73 74 61 74 20 3d 20 22 |F (hold_|stat = "|
|00005320| 2a 22 29 00 20 54 48 45 | 4e 0a 20 42 45 47 49 4e |*"). THE|N. BEGIN|
|00005330| 0a 20 20 45 58 43 45 50 | 54 49 4f 4e 20 63 75 73 |.  EXCEP|TION cus|
|00005340| 74 6f 6d 65 72 5f 6f 6e | 5f 68 6f 6c 64 3b 0a 20 |tomer_on|_hold;. |
|00005350| 20 53 55 53 50 45 4e 44 | 3b 0a 20 45 4e 44 0a 0a | SUSPEND|;. END..|
|00005360| 20 2f 2a 0a 20 20 2a 20 | 49 66 20 74 68 65 72 65 | /*.  * |If there|
|00005370| 20 69 73 20 61 6e 20 75 | 6e 70 61 69 64 20 62 61 | is an u|npaid ba|
|00005380| 6c 61 6e 63 65 20 6f 6e | 20 6f 72 64 65 72 73 20 |lance on| orders |
|00005390| 73 68 69 70 70 65 64 20 | 6f 76 65 72 20 32 20 6d |shipped |over 2 m|
|000053a0| 6f 6e 74 68 73 20 61 67 | 6f 2c 0a 20 20 2a 20 70 |onths ag|o,.  * p|
|000053b0| 75 74 20 74 68 65 20 63 | 75 73 74 6f 6d 65 72 20 |ut the c|ustomer |
|000053c0| 6f 6e 20 68 6f 6c 64 2e | 0a 20 20 2a 2f 0a 20 46 |on hold.|.  */. F|
|000053d0| 4f 52 20 53 45 4c 45 43 | 54 20 70 6f 5f 6e 75 6d |OR SELEC|T po_num|
|000053e0| 62 65 72 0a 20 20 46 52 | 4f 4d 20 73 61 6c 65 73 |ber.  FR|OM sales|
|000053f0| 0a 20 20 57 48 45 52 45 | 20 63 75 73 74 5f 6e 6f |.  WHERE| cust_no|
|00005400| 20 3d 20 3a 63 75 73 74 | 5f 6e 6f 0a 20 20 41 4e | = :cust|_no.  AN|
|00005410| 44 20 6f 72 64 65 72 5f | 73 74 61 74 75 73 20 3d |D order_|status =|
|00005420| 20 22 73 68 69 70 70 65 | 64 22 0a 20 20 41 4e 44 | "shippe|d".  AND|
|00005430| 20 70 61 69 64 20 3d 20 | 22 6e 22 0a 20 20 41 4e | paid = |"n".  AN|
|00005440| 44 20 73 68 69 70 5f 64 | 61 74 65 20 3c 20 27 4e |D ship_d|ate < 'N|
|00005450| 4f 57 27 20 2d 20 36 30 | 0a 20 20 49 4e 54 4f 20 |OW' - 60|.  INTO |
|00005460| 3a 61 6e 79 5f 70 6f 0a | 20 44 4f 0a 20 42 45 47 |:any_po.| DO. BEG|
|00005470| 49 4e 0a 20 20 45 58 43 | 45 50 54 49 4f 4e 20 63 |IN.  EXC|EPTION c|
|00005480| 75 73 74 6f 6d 65 72 5f | 63 68 65 63 6b 3b 0a 0a |ustomer_|check;..|
|00005490| 20 20 55 50 44 41 54 45 | 20 63 75 73 74 6f 6d 65 |  UPDATE| custome|
|000054a0| 72 0a 20 20 53 45 54 20 | 6f 6e 5f 68 6f 6c 64 20 |r.  SET |on_hold |
|000054b0| 3d 20 22 2a 22 0a 20 20 | 57 48 45 52 45 20 63 75 |= "*".  |WHERE cu|
|000054c0| 73 74 5f 6e 6f 20 3d 20 | 3a 63 75 73 74 5f 6e 6f |st_no = |:cust_no|
|000054d0| 3b 0a 0a 20 20 53 55 53 | 50 45 4e 44 3b 0a 20 45 |;..  SUS|PEND;. E|
|000054e0| 4e 44 0a 0a 20 2f 2a 0a | 20 20 2a 20 53 68 69 70 |ND.. /*.|  * Ship|
|000054f0| 20 74 68 65 20 6f 72 64 | 65 72 2e 0a 20 20 2a 2f | the ord|er..  */|
|00005500| 0a 20 55 50 44 41 54 45 | 20 73 61 6c 65 73 0a 20 |. UPDATE| sales. |
|00005510| 53 45 54 20 6f 72 64 65 | 72 5f 73 74 61 74 75 73 |SET orde|r_status|
|00005520| 20 3d 20 22 00 73 68 69 | 70 70 65 64 22 2c 20 73 | = ".shi|pped", s|
|00005530| 68 69 70 5f 64 61 74 65 | 20 3d 20 27 4e 4f 57 27 |hip_date| = 'NOW'|
|00005540| 0a 20 57 48 45 52 45 20 | 70 6f 5f 6e 75 6d 62 65 |. WHERE |po_numbe|
|00005550| 72 20 3d 20 3a 70 6f 5f | 6e 75 6d 3b 0a 0a 20 53 |r = :po_|num;.. S|
|00005560| 55 53 50 45 4e 44 3b 0a | 45 4e 44 00 08 04 88 02 |USPEND;.|END.....|
|00005570| 00 00 04 02 04 00 02 00 | 0f 15 00 08 00 07 00 04 |........|........|
|00005580| 01 01 00 07 00 0c 00 02 | 03 00 00 0f 15 00 07 00 |........|........|
|00005590| 01 2d 1a 00 00 03 01 00 | 0f 15 00 01 00 01 2d 1a |.-......|......-.|
|000055a0| 01 00 03 02 00 08 00 01 | 2d 1a 02 00 03 03 00 0f |........|-.......|
|000055b0| 15 00 08 00 01 2d 1a 03 | 00 9b 11 00 02 02 07 7f |.....-..|........|
|000055c0| 43 02 92 05 53 41 4c 45 | 53 01 53 00 92 08 43 55 |C...SALE|S.S...CU|
|000055d0| 53 54 4f 4d 45 52 01 43 | 01 47 3a 2f 17 00 09 50 |STOMER.C|.G:/...P|
|000055e0| 4f 5f 4e 55 4d 42 45 52 | 29 00 00 00 01 00 2f 17 |O_NUMBER|)...../.|
|000055f0| 00 07 43 55 53 54 5f 4e | 4f 17 01 07 43 55 53 54 |..CUST_N|O...CUST|
|00005600| 5f 4e 4f ff 02 01 17 00 | 0c 4f 52 44 45 52 5f 53 |_NO.....|.ORDER_S|
|00005610| 54 41 54 55 53 1a 00 00 | 01 17 01 07 4f 4e 5f 48 |TATUS...|....ON_H|
|00005620| 4f 4c 44 1a 01 00 01 17 | 01 07 43 55 53 54 5f 4e |OLD.....|..CUST_N|
|00005630| 4f 1a 02 00 ff 08 2f 1a | 00 00 15 0f 7f 00 07 00 |O...../.|........|
|00005640| 73 68 69 70 70 65 64 02 | 02 80 02 15 4f 52 44 45 |shipped.|....ORDE|
|00005650| 52 5f 41 4c 52 45 41 44 | 59 5f 53 48 49 50 50 45 |R_ALREAD|Y_SHIPPE|
|00005660| 44 02 0e 01 02 01 15 07 | 00 01 00 19 01 00 00 ff |D.......|........|
|00005670| 9b ff ff ff 08 2f 1a 01 | 00 15 0f 7f 00 01 00 2a |...../..|.......*|
|00005680| 02 02 80 02 10 43 55 53 | 54 4f 4d 45 52 5f 4f 4e |.....CUS|TOMER_ON|
|00005690| 5f 48 4f 4c 44 02 0e 01 | 02 01 15 07 00 01 00 19 |_HOLD...|........|
|000056a0| 01 00 00 ff 9b ff ff ff | ff 07 43 01 4a 05 53 41 |........|..C.J.SA|
|000056b0| 4c 45 53 02 47 3a 3a 3a | 2f 17 02 07 43 55 53 54 |LES.G:::|/...CUST|
|000056c0| 5f 4e 4f 1a 02 00 2f 17 | 02 0c 4f 52 44 45 52 5f |_NO.../.|..ORDER_|
|000056d0| 53 54 41 54 55 53 15 0f | 7f 00 07 00 73 68 69 70 |STATUS..|....ship|
|000056e0| 70 65 64 2f 17 02 04 50 | 41 49 44 15 0f 7f 00 01 |ped/...P|AID.....|
|000056f0| 00 6e 33 17 02 09 53 48 | 49 50 5f 44 41 54 45 23 |.n3...SH|IP_DATE#|
|00005700| 15 0f 7f 00 03 00 4e 4f | 57 15 08 00 3c 00 00 00 |......NO|W...<...|
|00005710| ff 02 01 17 02 09 50 4f | 5f 4e 55 4d 42 45 52 1a |......PO|_NUMBER.|
|00005720| 03 00 02 02 80 02 0e 43 | 55 53 54 4f 4d 45 52 5f |.......C|USTOMER_|
|00005730| 43 48 45 43 4b 07 43 01 | 4a 08 43 55 53 54 4f 4d |CHECK.C.|J.CUSTOM|
|00005740| 45 52 03 47 2f 17 03 07 | 43 55 53 54 5f 4e 4f 1a |ER.G/...|CUST_NO.|
|00005750| 02 00 ff 0a 03 03 02 01 | 15 0f 7f 00 01 00 2a 17 |........|......*.|
|00005760| 03 07 4f 4e 5f 48 4f 4c | 44 ff 02 0e 01 02 01 15 |..ON_HOL|D.......|
|00005770| 07 00 01 00 19 01 00 00 | ff 9b ff ff ff ff 07 43 |........|.......C|
|00005780| 01 4a 05 53 41 4c 45 53 | 04 47 2f 17 04 09 50 4f |.J.SALES|.G/...PO|
|00005790| 5f 4e 55 4d 42 45 52 29 | 00 00 00 01 00 ff 0a 04 |_NUMBER)|........|
|000057a0| 04 02 01 15 0f 7f 00 07 | 00 73 68 69 70 70 65 64 |........|.shipped|
|000057b0| 17 04 0c 4f 52 44 45 52 | 5f 53 54 41 54 55 53 01 |...ORDER|_STATUS.|
|000057c0| 15 0f 7f 00 03 00 4e 4f | 57 17 04 09 53 48 49 50 |......NO|W...SHIP|
|000057d0| 5f 44 41 54 45 ff 02 0e | 01 02 01 15 07 00 01 00 |_DATE...|........|
|000057e0| 19 01 00 00 ff 9b ff ff | ff ff 0e 01 02 01 15 07 |........|........|
|000057f0| 00 00 00 19 01 00 00 ff | ff 4c 09 0e 53 51 4c 24 |........|.L..SQL$|
|00005800| 53 48 49 50 5f 4f 52 44 | 45 52 0a 06 53 59 53 44 |SHIP_ORD|ER..SYSD|
|00005810| 42 41 00 1c 01 06 50 4f | 5f 4e 55 4d 02 04 00 00 |BA....PO|_NUM....|
|00005820| 00 00 03 04 00 00 00 00 | 04 06 52 44 42 24 35 36 |........|..RDB$56|
|00005830| 00 1d 1b 01 0a 53 48 4f | 57 5f 4c 41 4e 47 53 02 |.....SHO|W_LANGS.|
|00005840| 04 03 00 00 00 03 04 01 | 00 00 00 07 04 8b 01 00 |........|........|
|00005850| 00 0a 44 45 43 4c 41 52 | 45 20 56 41 52 49 41 42 |..DECLAR|E VARIAB|
|00005860| 4c 45 20 69 20 49 4e 54 | 45 47 45 52 3b 0a 42 45 |LE i INT|EGER;.BE|
|00005870| 47 49 4e 0a 20 20 69 20 | 3d 20 31 3b 0a 20 20 57 |GIN.  i |= 1;.  W|
|00005880| 48 49 4c 45 20 28 69 20 | 3c 3d 20 35 29 20 44 4f |HILE (i |<= 5) DO|
|00005890| 0a 20 20 42 45 47 49 4e | 0a 20 20 20 20 53 45 4c |.  BEGIN|.    SEL|
|000058a0| 45 43 54 20 6c 61 6e 67 | 75 61 67 65 5f 72 65 71 |ECT lang|uage_req|
|000058b0| 5b 3a 69 5d 20 46 52 4f | 4d 20 6a 6f 42 0a 20 20 |[:i] FRO|M joB.  |
|000058c0| 20 20 57 48 45 52 45 20 | 28 28 6a 6f 62 5f 63 6f |  WHERE |((job_co|
|000058d0| 64 65 20 3d 20 3a 63 6f | 64 65 29 20 41 4e 44 20 |de = :co|de) AND |
|000058e0| 28 6a 6f 62 5f 67 72 61 | 64 65 20 3d 20 3a 67 72 |(job_gra|de = :gr|
|000058f0| 61 64 65 29 20 41 4e 44 | 20 28 6a 6f 62 5f 63 6f |ade) AND| (job_co|
|00005900| 75 6e 74 72 79 20 3d 20 | 3a 63 74 79 29 0a 20 20 |untry = |:cty).  |
|00005910| 20 20 20 20 20 20 20 20 | 20 41 4e 44 20 28 6c 61 |        | AND (la|
|00005920| 6e 67 75 61 67 65 5f 72 | 65 71 20 49 53 20 4e 4f |nguage_r|eq IS NO|
|00005930| 54 20 4e 55 4c 4c 29 29 | 0a 20 20 20 20 49 4e 54 |T NULL))|.    INT|
|00005940| 4f 20 3a 6c 61 6e 67 75 | 61 67 65 73 3b 0a 20 20 |O :langu|ages;.  |
|00005950| 20 20 49 46 20 28 6c 61 | 6e 67 75 61 67 65 73 20 |  IF (la|nguages |
|00005960| 3d 20 22 20 22 29 20 54 | 48 45 4e 20 20 2f 2a 20 |= " ") T|HEN  /* |
|00005970| 50 72 69 6e 74 73 20 22 | 4e 55 4c 4c 22 20 69 6e |Prints "|NULL" in|
|00005980| 73 74 65 61 64 20 6f 66 | 20 62 6c 61 6e 6b 73 20 |stead of| blanks |
|00005990| 2a 2f 0a 20 20 20 20 20 | 20 20 6c 61 6e 67 75 61 |*/.     |  langua|
|000059a0| 67 65 73 20 3d 20 22 4e | 55 4c 4c 22 3b 20 20 20 |ges = "N|ULL";   |
|000059b0| 20 20 20 20 20 20 0a 20 | 20 20 20 69 20 3d 20 69 |      . |   i = i|
|000059c0| 20 2b 31 3b 0a 20 20 20 | 20 53 55 53 50 45 4e 44 | +1;.   | SUSPEND|
|000059d0| 3b 0a 20 20 45 4e 44 0a | 45 4e 44 00 08 04 3c 01 |;.  END.|END...<.|
|000059e0| 00 00 04 02 04 00 06 00 | 26 15 00 05 00 07 00 07 |........|&.......|
|000059f0| 00 07 00 26 15 00 0f 00 | 07 00 04 01 03 00 26 15 |...&....|......&.|
|00005a00| 00 0f 00 07 00 07 00 0c | 00 02 03 00 00 26 15 00 |........|.....&..|
|00005a10| 0f 00 01 2d 1a 00 00 03 | 01 00 08 00 01 2d 1a 01 |...-....|.....-..|
|00005a20| 00 9b 11 00 02 02 01 15 | 08 00 01 00 00 00 1a 01 |........|........|
|00005a30| 00 11 01 09 02 08 34 1a | 01 00 15 08 00 05 00 00 |......4.|........|
|00005a40| 00 02 02 07 7f 43 01 4a | 03 4a 4f 42 00 47 3a 3a |.....C.J|.JOB.G::|
|00005a50| 3a 2f 17 00 08 4a 4f 42 | 5f 43 4f 44 45 29 00 00 |:/...JOB|_CODE)..|
|00005a60| 00 01 00 2f 17 00 09 4a | 4f 42 5f 47 52 41 44 45 |.../...J|OB_GRADE|
|00005a70| 29 00 02 00 03 00 2f 17 | 00 0b 4a 4f 42 5f 43 4f |)...../.|..JOB_CO|
|00005a80| 55 4e 54 52 59 29 00 04 | 00 05 00 3b 3d 17 00 0c |UNTRY)..|...;=...|
|00005a90| 4c 41 4e 47 55 41 47 45 | 5f 52 45 51 ff 02 01 6b |LANGUAGE|_REQ...k|
|00005aa0| 17 00 0c 4c 41 4e 47 55 | 41 47 45 5f 52 45 51 01 |...LANGU|AGE_REQ.|
|00005ab0| 1a 01 00 1a 00 00 ff 08 | 2f 1a 00 00 15 0f 7f 00 |........|/.......|
|00005ac0| 01 00 20 01 15 0f 7f 00 | 04 00 4e 55 4c 4c 1a 00 |.. .....|..NULL..|
|00005ad0| 00 ff 01 22 1a 01 00 15 | 08 00 01 00 00 00 1a 01 |..."....|........|
|00005ae0| 00 02 0e 01 02 01 1a 00 | 00 29 01 00 00 01 00 01 |........|.)......|
|00005af0| 15 07 00 01 00 19 01 02 | 00 ff 9b ff ff ff 12 01 |........|........|
|00005b00| ff ff ff ff 0e 01 02 01 | 1a 00 00 29 01 00 00 01 |........|...)....|
|00005b10| 00 01 15 07 00 00 00 19 | 01 02 00 ff ff 4c 09 0e |........|.....L..|
|00005b20| 53 51 4c 24 53 48 4f 57 | 5f 4c 41 4e 47 53 0a 06 |SQL$SHOW|_LANGS..|
|00005b30| 53 59 53 44 42 41 00 1c | 01 04 43 4f 44 45 02 04 |SYSDBA..|..CODE..|
|00005b40| 00 00 00 00 03 04 00 00 | 00 00 04 06 52 44 42 24 |........|....RDB$|
|00005b50| 35 37 00 1c 01 05 47 52 | 41 44 45 02 04 01 00 00 |57....GR|ADE.....|
|00005b60| 00 03 04 00 00 00 00 04 | 06 52 44 42 24 35 38 00 |........|.RDB$58.|
|00005b70| 1c 01 03 43 54 59 02 04 | 02 00 00 00 03 04 00 00 |...CTY..|........|
|00005b80| 00 00 04 06 52 44 42 24 | 35 39 00 1c 01 09 4c 41 |....RDB$|59....LA|
|00005b90| 4e 47 55 41 47 45 53 02 | 04 00 00 00 00 03 04 01 |NGUAGES.|........|
|00005ba0| 00 00 00 04 06 52 44 42 | 24 36 30 00 1d 1b 01 09 |.....RDB|$60.....|
|00005bb0| 41 4c 4c 5f 4c 41 4e 47 | 53 02 04 00 00 00 00 03 |ALL_LANG|S.......|
|00005bc0| 04 04 00 00 00 07 04 8b | 01 00 00 0a 20 20 20 20 |........|....    |
|00005bd0| 42 45 47 49 4e 0a 20 46 | 4f 52 20 53 45 4c 45 43 |BEGIN. F|OR SELEC|
|00005be0| 54 20 6a 6f 62 5f 63 6f | 64 65 2c 20 6a 6f 62 5f |T job_co|de, job_|
|00005bf0| 67 72 61 64 65 2c 20 6a | 6f 62 5f 63 6f 75 6e 74 |grade, j|ob_count|
|00005c00| 72 79 20 46 52 4f 4d 20 | 6a 6f 62 20 0a 20 20 49 |ry FROM |job .  I|
|00005c10| 4e 54 4f 20 3a 63 6f 64 | 65 2c 20 3a 67 72 61 64 |NTO :cod|e, :grad|
|00005c20| 65 2c 20 3a 63 6f 75 6e | 74 72 79 0a 0a 20 44 4f |e, :coun|try.. DO|
|00005c30| 0a 20 42 45 47 49 4e 0a | 20 20 20 20 20 46 4f 52 |. BEGIN.|     FOR|
|00005c40| 20 53 45 4c 45 43 54 20 | 6c 61 6e 67 75 61 67 65 | SELECT |language|
|00005c50| 73 20 46 52 4f 4d 20 73 | 68 6f 77 5f 6c 61 6e 67 |s FROM s|how_lang|
|00005c60| 73 20 0a 20 20 20 20 20 | 20 20 28 3a 63 6f 64 65 |s .     |  (:code|
|00005c70| 2c 20 3a 67 72 61 64 65 | 2c 20 3a 63 6f 75 6e 74 |, :grade|, :count|
|00005c80| 72 79 29 20 49 4e 54 4f | 20 3a 6c 61 6e 67 20 44 |ry) INTO| :lang D|
|00005c90| 4f 0a 20 20 20 20 20 20 | 20 20 20 53 55 53 50 45 |O.      |   SUSPE|
|00005ca0| 4e 44 3b 0a 20 20 20 20 | 20 2f 2a 20 50 75 74 20 |ND;.    | /* Put |
|00005cb0| 6e 69 63 65 20 73 65 70 | 61 72 61 74 6f 72 73 20 |nice sep|arators |
|00005cc0| 62 65 74 77 65 65 6e 20 | 72 6f 77 73 20 2a 2f 0a |between |rows */.|
|00005cd0| 20 20 20 20 20 63 6f 64 | 65 20 3d 20 22 3d 3d 3d |     cod|e = "===|
|00005ce0| 3d 3d 22 3b 0a 20 20 20 | 20 20 67 72 61 64 65 20 |==";.   |  grade |
|00005cf0| 3d 20 22 3d 3d 3d 3d 3d | 22 3b 0a 20 20 20 20 20 |= "=====|";.     |
|00005d00| 63 6f 75 6e 74 72 79 20 | 3d 20 22 3d 3d 3d 3d 3d |country |= "=====|
|00005d10| 3d 3d 3d 3d 3d 3d 3d 3d | 3d 3d 22 3b 0a 20 20 20 |========|==";.   |
|00005d20| 20 20 6c 61 6e 67 20 3d | 20 22 3d 3d 3d 3d 3d 3d |  lang =| "======|
|00005d30| 3d 3d 3d 3d 3d 3d 3d 3d | 22 3b 0a 20 20 20 20 20 |========|";.     |
|00005d40| 53 55 53 50 45 4e 44 3b | 0a 20 45 4e 44 0a 20 20 |SUSPEND;|. END.  |
|00005d50| 20 20 45 4e 44 00 08 04 | c9 01 00 00 04 02 04 01 |  END...|........|
|00005d60| 09 00 26 15 00 05 00 07 | 00 26 15 00 05 00 07 00 |..&.....|.&......|
|00005d70| 26 15 00 0f 00 07 00 26 | 15 00 0f 00 07 00 07 00 |&......&|........|
|00005d80| 02 03 00 00 26 15 00 05 | 00 01 2d 1a 00 00 03 01 |....&...|..-.....|
|00005d90| 00 26 15 00 05 00 01 2d | 1a 01 00 03 02 00 26 15 |.&.....-|......&.|
|00005da0| 00 0f 00 01 2d 1a 02 00 | 03 03 00 26 15 00 0f 00 |....-...|...&....|
|00005db0| 01 2d 1a 03 00 9b 11 00 | 02 02 07 43 01 4a 03 4a |.-......|...C.J.J|
|00005dc0| 4f 42 00 ff 02 01 17 00 | 08 4a 4f 42 5f 43 4f 44 |OB......|.JOB_COD|
|00005dd0| 45 1a 00 00 01 17 00 09 | 4a 4f 42 5f 47 52 41 44 |E.......|JOB_GRAD|
|00005de0| 45 1a 01 00 01 17 00 0b | 4a 4f 42 5f 43 4f 55 4e |E.......|JOB_COUN|
|00005df0| 54 52 59 1a 02 00 02 02 | 07 43 01 7c 0a 53 48 4f |TRY.....|.C.|.SHO|
|00005e00| 57 5f 4c 41 4e 47 53 01 | 03 00 1a 00 00 1a 01 00 |W_LANGS.|........|
|00005e10| 1a 02 00 ff 02 01 17 01 | 09 4c 41 4e 47 55 41 47 |........|.LANGUAG|
|00005e20| 45 53 1a 03 00 02 0e 01 | 02 01 1a 00 00 29 01 00 |ES......|.....)..|
|00005e30| 00 01 00 01 1a 01 00 29 | 01 02 00 03 00 01 1a 02 |.......)|........|
|00005e40| 00 29 01 04 00 05 00 01 | 1a 03 00 29 01 06 00 07 |.)......|...)....|
|00005e50| 00 01 15 07 00 01 00 19 | 01 08 00 ff 9b ff ff 01 |........|........|
|00005e60| 15 0f 7f 00 05 00 3d 3d | 3d 3d 3d 1a 00 00 01 15 |......==|===.....|
|00005e70| 0f 7f 00 05 00 3d 3d 3d | 3d 3d 1a 01 00 01 15 0f |.....===|==......|
|00005e80| 7f 00 0f 00 3d 3d 3d 3d | 3d 3d 3d 3d 3d 3d 3d 3d |....====|========|
|00005e90| 3d 3d 3d 1a 02 00 01 15 | 0f 7f 00 0e 00 3d 3d 3d |===.....|.....===|
|00005ea0| 3d 3d 3d 3d 3d 3d 3d 3d | 3d 3d 3d 1a 03 00 02 0e |========|===.....|
|00005eb0| 01 02 01 1a 00 00 29 01 | 00 00 01 00 01 1a 01 00 |......).|........|
|00005ec0| 29 01 02 00 03 00 01 1a | 02 00 29 01 04 00 05 00 |).......|..).....|
|00005ed0| 01 1a 03 00 29 01 06 00 | 07 00 01 15 07 00 01 00 |....)...|........|
|00005ee0| 19 01 08 00 ff 9b ff ff | ff ff ff ff ff 0e 01 02 |........|........|
|00005ef0| 01 1a 00 00 29 01 00 00 | 01 00 01 1a 01 00 29 01 |....)...|......).|
|00005f00| 02 00 03 00 01 1a 02 00 | 29 01 04 00 05 00 01 1a |........|).......|
|00005f10| 03 00 29 01 06 00 07 00 | 01 15 07 00 00 00 19 01 |..).....|........|
|00005f20| 08 00 ff ff 4c 09 0d 53 | 51 4c 24 41 4c 4c 5f 4c |....L..S|QL$ALL_L|
|00005f30| 41 4e 47 53 0a 06 53 59 | 53 44 42 41 00 1c 01 04 |ANGS..SY|SDBA....|
|00005f40| 43 4f 44 45 02 04 00 00 | 00 00 03 04 01 00 00 00 |CODE....|........|
|00005f50| 04 06 52 44 42 24 36 31 | 00 1c 01 05 47 52 41 44 |..RDB$61|....GRAD|
|00005f60| 45 02 04 01 00 00 00 03 | 04 01 00 00 00 04 06 52 |E.......|.......R|
|00005f70| 44 42 24 36 32 00 1c 01 | 07 43 4f 55 4e 54 52 59 |DB$62...|.COUNTRY|
|00005f80| 02 04 02 00 00 00 03 04 | 01 00 00 00 04 06 52 44 |........|......RD|
|00005f90| 42 24 36 33 00 1c 01 04 | 4c 41 4e 47 02 04 03 00 |B$63....|LANG....|
|00005fa0| 00 00 03 04 01 00 00 00 | 04 06 52 44 42 24 36 34 |........|..RDB$64|
|00005fb0| 00 1d 1b 01 10 46 52 45 | 4e 43 48 5f 43 55 53 54 |.....FRE|NCH_CUST|
|00005fc0| 5f 53 4f 52 54 02 04 00 | 00 00 00 03 04 03 00 00 |_SORT...|........|
|00005fd0| 00 07 04 a8 00 00 00 0a | 42 45 47 49 4e 0a 20 20 |........|BEGIN.  |
|00005fe0| 20 20 20 20 20 20 46 4f | 52 20 53 45 4c 45 43 54 |      FO|R SELECT|
|00005ff0| 20 63 75 73 74 6f 6d 65 | 72 2c 20 63 69 74 79 2c | custome|r, city,|
|00006000| 20 63 6f 75 6e 74 72 79 | 20 0a 20 20 20 20 20 46 | country| .     F|
|00006010| 52 4f 4d 20 63 75 73 74 | 6f 6d 65 72 20 4f 52 44 |ROM cust|omer ORD|
|00006020| 45 52 20 42 59 20 63 75 | 73 74 6f 6d 65 72 0a 20 |ER BY cu|stomer. |
|00006030| 20 20 20 20 20 20 20 20 | 20 20 20 49 4e 54 4f 20 |        |   INTO |
|00006040| 3a 63 75 73 74 6f 6d 65 | 72 2c 20 3a 63 69 74 79 |:custome|r, :city|
|00006050| 2c 20 3a 63 6f 75 6e 74 | 72 79 0a 20 20 20 20 20 |, :count|ry.     |
|00006060| 20 20 20 44 4f 0a 20 20 | 20 20 20 20 20 20 20 20 |   DO.  |        |
|00006070| 20 53 55 53 50 45 4e 44 | 3b 0a 0a 45 4e 44 00 08 | SUSPEND|;..END..|
|00006080| 04 f1 00 00 00 04 02 04 | 01 07 00 26 15 00 28 00 |........|...&..(.|
|00006090| 07 00 26 15 00 19 00 07 | 00 26 15 00 0f 00 07 00 |..&.....|.&......|
|000060a0| 07 00 02 03 00 00 26 15 | 00 28 00 01 2d 1a 00 00 |......&.|.(..-...|
|000060b0| 03 01 00 26 15 00 19 00 | 01 2d 1a 01 00 03 02 00 |...&....|.-......|
|000060c0| 26 15 00 0f 00 01 2d 1a | 02 00 9b 11 00 02 02 07 |&.....-.|........|
|000060d0| 43 01 4a 08 43 55 53 54 | 4f 4d 45 52 00 46 01 48 |C.J.CUST|OMER.F.H|
|000060e0| 17 00 08 43 55 53 54 4f | 4d 45 52 ff 02 01 17 00 |...CUSTO|MER.....|
|000060f0| 08 43 55 53 54 4f 4d 45 | 52 1a 00 00 01 17 00 04 |.CUSTOME|R.......|
|00006100| 43 49 54 59 1a 01 00 01 | 17 00 07 43 4f 55 4e 54 |CITY....|...COUNT|
|00006110| 52 59 1a 02 00 02 0e 01 | 02 01 1a 00 00 29 01 00 |RY......|.....)..|
|00006120| 00 01 00 01 1a 01 00 29 | 01 02 00 03 00 01 1a 02 |.......)|........|
|00006130| 00 29 01 04 00 05 00 01 | 15 07 00 01 00 19 01 06 |.)......|........|
|00006140| 00 ff 9b ff ff ff ff ff | 0e 01 02 01 1a 00 00 29 |........|.......)|
|00006150| 01 00 00 01 00 01 1a 01 | 00 29 01 02 00 03 00 01 |........|.)......|
|00006160| 1a 02 00 29 01 04 00 05 | 00 01 15 07 00 00 00 19 |...)....|........|
|00006170| 01 06 00 ff ff 4c 09 14 | 53 51 4c 24 46 52 45 4e |.....L..|SQL$FREN|
|00006180| 43 48 5f 43 55 53 54 5f | 53 4f 52 54 0a 06 53 59 |CH_CUST_|SORT..SY|
|00006190| 53 44 42 41 00 1c 01 08 | 43 55 53 54 4f 4d 45 52 |SDBA....|CUSTOMER|
|000061a0| 02 04 00 00 00 00 03 04 | 01 00 00 00 04 06 52 44 |........|......RD|
|000061b0| 42 24 36 35 00 1c 01 04 | 43 49 54 59 02 04 01 00 |B$65....|CITY....|
|000061c0| 00 00 03 04 01 00 00 00 | 04 06 52 44 42 24 36 36 |........|..RDB$66|
|000061d0| 00 1c 01 07 43 4f 55 4e | 54 52 59 02 04 02 00 00 |....COUN|TRY.....|
|000061e0| 00 03 04 01 00 00 00 04 | 06 52 44 42 24 36 37 00 |........|.RDB$67.|
|000061f0| 1d 1b 01 10 47 45 52 4d | 41 4e 5f 43 55 53 54 5f |....GERM|AN_CUST_|
|00006200| 53 4f 52 54 02 04 00 00 | 00 00 03 04 03 00 00 00 |SORT....|........|
|00006210| 07 04 b6 00 00 00 0a 42 | 45 47 49 4e 0a 20 20 20 |.......B|EGIN.   |
|00006220| 20 20 20 20 20 46 4f 52 | 20 53 45 4c 45 43 54 20 |     FOR| SELECT |
|00006230| 63 75 73 74 6f 6d 65 72 | 2c 20 63 69 74 79 2c 20 |customer|, city, |
|00006240| 63 6f 75 6e 74 72 79 20 | 0a 20 20 20 20 20 46 52 |country |.     FR|
|00006250| 4f 4d 20 63 75 73 74 6f | 6d 65 72 20 4f 52 44 45 |OM custo|mer ORDE|
|00006260| 52 20 42 59 20 63 75 73 | 74 6f 6d 65 72 20 43 4f |R BY cus|tomer CO|
|00006270| 4c 4c 41 54 45 20 44 45 | 5f 44 45 0a 20 20 20 20 |LLATE DE|_DE.    |
|00006280| 20 20 20 20 20 20 20 20 | 49 4e 54 4f 20 3a 63 75 |        |INTO :cu|
|00006290| 73 74 6f 6d 65 72 2c 20 | 3a 63 69 74 79 2c 20 3a |stomer, |:city, :|
|000062a0| 63 6f 75 6e 74 72 79 0a | 20 20 20 20 20 20 20 20 |country.|        |
|000062b0| 44 4f 0a 20 20 20 20 20 | 20 20 20 20 20 20 53 55 |DO.     |      SU|
|000062c0| 53 50 45 4e 44 3b 0a 0a | 45 4e 44 00 08 04 f7 00 |SPEND;..|END.....|
|000062d0| 00 00 04 02 04 01 07 00 | 26 15 00 28 00 07 00 26 |........|&..(...&|
|000062e0| 15 00 19 00 07 00 26 15 | 00 0f 00 07 00 07 00 02 |......&.|........|
|000062f0| 03 00 00 26 15 00 28 00 | 01 2d 1a 00 00 03 01 00 |...&..(.|.-......|
|00006300| 26 15 00 19 00 01 2d 1a | 01 00 03 02 00 26 15 00 |&.....-.|.....&..|
|00006310| 0f 00 01 2d 1a 02 00 9b | 11 00 02 02 07 43 01 4a |...-....|.....C.J|
|00006320| 08 43 55 53 54 4f 4d 45 | 52 00 46 01 48 83 26 15 |.CUSTOME|R.F.H.&.|
|00006330| 06 00 00 17 00 08 43 55 | 53 54 4f 4d 45 52 ff 02 |......CU|STOMER..|
|00006340| 01 17 00 08 43 55 53 54 | 4f 4d 45 52 1a 00 00 01 |....CUST|OMER....|
|00006350| 17 00 04 43 49 54 59 1a | 01 00 01 17 00 07 43 4f |...CITY.|......CO|
|00006360| 55 4e 54 52 59 1a 02 00 | 02 0e 01 02 01 1a 00 00 |UNTRY...|........|
|00006370| 29 01 00 00 01 00 01 1a | 01 00 29 01 02 00 03 00 |).......|..).....|
|00006380| 01 1a 02 00 29 01 04 00 | 05 00 01 15 07 00 01 00 |....)...|........|
|00006390| 19 01 06 00 ff 9b ff ff | ff ff ff 0e 01 02 01 1a |........|........|
|000063a0| 00 00 29 01 00 00 01 00 | 01 1a 01 00 29 01 02 00 |..).....|....)...|
|000063b0| 03 00 01 1a 02 00 29 01 | 04 00 05 00 01 15 07 00 |......).|........|
|000063c0| 00 00 19 01 06 00 ff ff | 4c 09 14 53 51 4c 24 47 |........|L..SQL$G|
|000063d0| 45 52 4d 41 4e 5f 43 55 | 53 54 5f 53 4f 52 54 0a |ERMAN_CU|ST_SORT.|
|000063e0| 06 53 59 53 44 42 41 00 | 1c 01 08 43 55 53 54 4f |.SYSDBA.|...CUSTO|
|000063f0| 4d 45 52 02 04 00 00 00 | 00 03 04 01 00 00 00 04 |MER.....|........|
+--------+-------------------------+-------------------------+--------+--------+
Only 25.0 KB of data is shown above.