Freelog 42

home *** CD-ROM | disk | FTP | other *** search
/ Freelog 42 / Freelog042.iso / Alu / Ancestrologie / Sources / InterBase_WI-V6.0.1-server.ZIP / examples / database / intlemp.gbk < prev next >
Unknown | 2001-01-05 | 78.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 0406 0000 0004 0401 0000 ...	default (weak)
`99%`	file	data	default
`100%`	TrID	DEGAS hi-res bitmap	default (weak)
hex view
+--------+-------------------------+-------------------------+--------+--------+
|00000000| 00 02 04 06 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 4a 61 6e 20 30 33 | 20 31 37 3a 33 35 3a 34 |d Jan 03| 17:35:4|
|00000040| 32 20 32 30 30 31 00 0e | 0e 04 01 00 00 00 05 04 |2 2001..|........|
|00000050| 00 04 00 00 08 04 20 4e | 00 00 0c 04 01 00 00 00 |...... N|........|
|00000060| 01 0b 69 6e 74 6c 65 6d | 70 2e 67 64 62 00 01 0b |..intlem|p.gdb...|
|00000070| 09 49 53 4f 38 38 35 39 | 5f 31 00 02 01 09 46 49 |.ISO8859|_1....FI|
|00000080| 52 53 54 4e 41 4d 45 05 | 00 07 00 08 04 25 00 00 |RSTNAME.|.....%..|
|00000090| 00 0a 04 0f 00 00 00 09 | 04 00 00 00 00 0b 04 00 |........|........|
|000000a0| 00 00 00 29 04 0f 00 00 | 00 2a 04 15 00 00 00 2b |...)....|.*.....+|
|000000b0| 04 04 00 00 00 00 02 01 | 08 4c 41 53 54 4e 41 4d |........|.LASTNAM|
|000000c0| 45 05 00 07 00 08 04 25 | 00 00 00 0a 04 19 00 00 |E......%|........|
|000000d0| 00 09 04 00 00 00 00 0b | 04 00 00 00 00 29 04 19 |........|.....)..|
|000000e0| 00 00 00 2a 04 15 00 00 | 00 2b 04 04 00 00 00 00 |...*....|.+......|
|000000f0| 02 01 0b 50 48 4f 4e 45 | 4e 55 4d 42 45 52 05 00 |...PHONE|NUMBER..|
|00000100| 07 00 08 04 25 00 00 00 | 0a 04 14 00 00 00 09 04 |....%...|........|
|00000110| 00 00 00 00 0b 04 00 00 | 00 00 29 04 14 00 00 00 |........|..).....|
|00000120| 2a 04 15 00 00 00 2b 04 | 00 00 00 00 00 02 01 0b |*.....+.|........|
|00000130| 43 4f 55 4e 54 52 59 4e | 41 4d 45 05 00 07 00 08 |COUNTRYN|AME.....|
|00000140| 04 25 00 00 00 0a 04 0f | 00 00 00 09 04 00 00 00 |.%......|........|
|00000150| 00 0b 04 00 00 00 00 29 | 04 0f 00 00 00 2a 04 15 |.......)|.....*..|
|00000160| 00 00 00 2b 04 00 00 00 | 00 00 02 01 0b 41 44 44 |...+....|.....ADD|
|00000170| 52 45 53 53 4c 49 4e 45 | 05 00 07 00 08 04 25 00 |RESSLINE|......%.|
|00000180| 00 00 0a 04 28 00 00 00 | 09 04 00 00 00 00 0b 04 |....(...|........|
|00000190| 00 00 00 00 29 04 28 00 | 00 00 2a 04 15 00 00 00 |....).(.|..*.....|
|000001a0| 2b 04 00 00 00 00 00 02 | 01 05 45 4d 50 4e 4f 05 |+.......|..EMPNO.|
|000001b0| 00 07 00 08 04 07 00 00 | 00 0a 04 02 00 00 00 09 |........|........|
|000001c0| 04 00 00 00 00 0b 04 00 | 00 00 00 2c 04 00 00 00 |........|...,....|
|000001d0| 00 00 02 01 06 44 45 50 | 54 4e 4f 05 00 07 00 08 |.....DEP|TNO.....|
|000001e0| 04 0e 00 00 00 0a 04 03 | 00 00 00 09 04 00 00 00 |........|........|
|000001f0| 00 0b 04 00 00 00 00 14 | 04 32 00 00 00 04 39 39 |........|.2....99|
|00000200| 2f 18 00 00 00 15 0f 7f | 00 03 00 30 30 30 3a 31 |/.......|...000:1|
|00000210| 18 00 00 00 15 0f 7f 00 | 01 00 30 34 18 00 00 00 |........|..04....|
|00000220| 15 0f 7f 00 03 00 39 39 | 39 3d 18 00 00 00 4c 24 |......99|9=....L$|
|00000230| 04 4b 00 00 00 43 48 45 | 43 4b 20 28 56 41 4c 55 |.K...CHE|CK (VALU|
|00000240| 45 20 3d 20 27 30 30 30 | 27 20 4f 52 20 28 56 41 |E = '000|' OR (VA|
|00000250| 4c 55 45 20 3e 20 27 30 | 27 20 41 4e 44 20 56 41 |LUE > '0|' AND VA|
|00000260| 4c 55 45 20 3c 3d 20 27 | 39 39 39 27 29 20 4f 52 |LUE <= '|999') OR|
|00000270| 20 56 41 4c 55 45 20 49 | 53 20 4e 55 4c 4c 29 00 | VALUE I|S NULL).|
|00000280| 29 04 03 00 00 00 2a 04 | 02 00 00 00 2b 04 00 00 |).....*.|....+...|
|00000290| 00 00 00 02 01 06 50 52 | 4f 4a 4e 4f 05 00 07 00 |......PR|OJNO....|
|000002a0| 08 04 0e 00 00 00 0a 04 | 05 00 00 00 09 04 00 00 |........|........|
|000002b0| 00 00 0b 04 00 00 00 00 | 14 04 0c 00 00 00 04 2f |........|......./|
|000002c0| 18 00 00 00 67 18 00 00 | 00 4c 24 04 1e 00 00 00 |....g...|.L$.....|
|000002d0| 43 48 45 43 4b 20 28 56 | 41 4c 55 45 20 3d 20 55 |CHECK (V|ALUE = U|
|000002e0| 50 50 45 52 20 28 56 41 | 4c 55 45 29 29 00 29 04 |PPER (VA|LUE)).).|
|000002f0| 05 00 00 00 2a 04 02 00 | 00 00 2b 04 00 00 00 00 |....*...|..+.....|
|00000300| 00 02 01 06 43 55 53 54 | 4e 4f 05 00 07 00 08 04 |....CUST|NO......|
|00000310| 08 00 00 00 0a 04 04 00 | 00 00 09 04 00 00 00 00 |........|........|
|00000320| 0b 04 00 00 00 00 14 04 | 0e 00 00 00 04 31 18 00 |........|.....1..|
|00000330| 00 00 15 08 00 e8 03 00 | 00 4c 24 04 15 00 00 00 |........|.L$.....|
|00000340| 43 48 45 43 4b 20 28 56 | 41 4c 55 45 20 3e 20 31 |CHECK (V|ALUE > 1|
|00000350| 30 30 30 29 00 2c 04 00 | 00 00 00 00 02 01 07 4a |000).,..|.......J|
|00000360| 4f 42 43 4f 44 45 05 00 | 07 00 08 04 25 00 00 00 |OBCODE..|....%...|
|00000370| 0a 04 05 00 00 00 09 04 | 00 00 00 00 0b 04 00 00 |........|........|
|00000380| 00 00 14 04 12 00 00 00 | 04 31 18 00 00 00 15 0f |........|.1......|
|00000390| 7f 00 05 00 39 39 39 39 | 39 4c 24 04 18 00 00 00 |....9999|9L$.....|
|000003a0| 43 48 45 43 4b 20 28 56 | 41 4c 55 45 20 3e 20 27 |CHECK (V|ALUE > '|
|000003b0| 39 39 39 39 39 27 29 00 | 29 04 05 00 00 00 2a 04 |99999').|).....*.|
|000003c0| 02 00 00 00 2b 04 00 00 | 00 00 00 02 01 08 4a 4f |....+...|......JO|
|000003d0| 42 47 52 41 44 45 05 00 | 07 00 08 04 07 00 00 00 |BGRADE..|........|
|000003e0| 0a 04 02 00 00 00 09 04 | 00 00 00 00 0b 04 00 00 |........|........|
|000003f0| 00 00 14 04 15 00 00 00 | 04 38 18 00 00 00 15 08 |........|.8......|
|00000400| 00 00 00 00 00 15 08 00 | 06 00 00 00 4c 24 04 1e |........|....L$..|
|00000410| 00 00 00 43 48 45 43 4b | 20 28 56 41 4c 55 45 20 |...CHECK| (VALUE |
|00000420| 42 45 54 57 45 45 4e 20 | 30 20 41 4e 44 20 36 29 |BETWEEN |0 AND 6)|
|00000430| 00 2c 04 00 00 00 00 00 | 02 01 06 53 41 4c 41 52 |.,......|...SALAR|
|00000440| 59 05 00 07 00 08 04 1b | 00 00 00 0a 04 08 00 00 |Y.......|........|
|00000450| 00 09 04 00 00 00 00 0b | 04 fe ff ff ff 0f 04 09 |........|........|
|00000460| 00 00 00 04 15 08 00 00 | 00 00 00 4c 14 04 0e 00 |........|...L....|
|00000470| 00 00 04 31 18 00 00 00 | 15 08 00 00 00 00 00 4c |...1....|.......L|
|00000480| 24 04 12 00 00 00 43 48 | 45 43 4b 20 28 56 41 4c |$.....CH|ECK (VAL|
|00000490| 55 45 20 3e 20 30 29 00 | 27 04 0a 00 00 00 44 45 |UE > 0).|'.....DE|
|000004a0| 46 41 55 4c 54 20 30 00 | 00 02 01 06 42 55 44 47 |FAULT 0.|....BUDG|
|000004b0| 45 54 05 00 07 00 08 04 | 1b 00 00 00 0a 04 08 00 |ET......|........|
|000004c0| 00 00 09 04 00 00 00 00 | 0b 04 fe ff ff ff 0f 04 |........|........|
|000004d0| 09 00 00 00 04 15 08 00 | 50 c3 00 00 4c 14 04 1b |........|P...L...|
|000004e0| 00 00 00 04 3a 31 18 00 | 00 00 15 08 00 10 27 00 |....:1..|......'.|
|000004f0| 00 34 18 00 00 00 15 08 | 00 80 84 1e 00 4c 24 04 |.4......|.....L$.|
|00000500| 2b 00 00 00 43 48 45 43 | 4b 20 28 56 41 4c 55 45 |+...CHEC|K (VALUE|
|00000510| 20 3e 20 31 30 30 30 30 | 20 41 4e 44 20 56 41 4c | > 10000| AND VAL|
|00000520| 55 45 20 3c 3d 20 32 30 | 30 30 30 30 30 29 00 27 |UE <= 20|00000).'|
|00000530| 04 0e 00 00 00 44 45 46 | 41 55 4c 54 20 35 30 30 |.....DEF|AULT 500|
|00000540| 30 30 00 00 02 01 08 50 | 52 4f 44 54 59 50 45 05 |00.....P|RODTYPE.|
|00000550| 00 07 00 08 04 25 00 00 | 00 0a 04 0c 00 00 00 09 |.....%..|........|
|00000560| 04 00 00 00 00 0b 04 00 | 00 00 00 0f 04 10 00 00 |........|........|
|00000570| 00 04 15 0f 7f 00 08 00 | 73 6f 66 74 77 61 72 65 |........|software|
|00000580| 4c 14 04 49 00 00 00 04 | 39 39 39 2f 18 00 00 00 |L..I....|999/....|
|00000590| 15 0f 7f 00 08 00 73 6f | 66 74 77 61 72 65 2f 18 |......so|ftware/.|
|000005a0| 00 00 00 15 0f 7f 00 08 | 00 68 61 72 64 77 61 72 |........|.hardwar|
|000005b0| 65 2f 18 00 00 00 15 0f | 7f 00 05 00 6f 74 68 65 |e/......|....othe|
|000005c0| 72 2f 18 00 00 00 15 0f | 7f 00 03 00 4e 2f 41 4c |r/......|....N/AL|
|000005d0| 24 04 3a 00 00 00 43 48 | 45 43 4b 20 28 56 41 4c |$.:...CH|ECK (VAL|
|000005e0| 55 45 20 49 4e 20 28 27 | 73 6f 66 74 77 61 72 65 |UE IN ('|software|
|000005f0| 27 2c 20 27 68 61 72 64 | 77 61 72 65 27 2c 20 27 |', 'hard|ware', '|
|00000600| 6f 74 68 65 72 27 2c 20 | 27 4e 2f 41 27 29 29 00 |other', |'N/A')).|
|00000610| 26 04 01 00 00 00 29 04 | 0c 00 00 00 27 04 13 00 |&.....).|....'...|
|00000620| 00 00 44 45 46 41 55 4c | 54 20 27 73 6f 66 74 77 |..DEFAUL|T 'softw|
|00000630| 61 72 65 27 00 2a 04 15 | 00 00 00 2b 04 00 00 00 |are'.*..|...+....|
|00000640| 00 00 02 01 08 50 4f 4e | 55 4d 42 45 52 05 00 07 |.....PON|UMBER...|
|00000650| 00 08 04 0e 00 00 00 0a | 04 08 00 00 00 09 04 00 |........|........|
|00000660| 00 00 00 0b 04 00 00 00 | 00 14 04 0e 00 00 00 04 |........|........|
|00000670| 37 18 00 00 00 15 0f 7f | 00 01 00 56 4c 24 04 20 |7.......|...VL$. |
|00000680| 00 00 00 43 48 45 43 4b | 20 28 56 41 4c 55 45 20 |...CHECK| (VALUE |
|00000690| 53 54 41 52 54 49 4e 47 | 20 57 49 54 48 20 27 56 |STARTING| WITH 'V|
|000006a0| 27 29 00 29 04 08 00 00 | 00 2a 04 15 00 00 00 2b |').)....|.*.....+|
|000006b0| 04 00 00 00 00 00 02 01 | 05 52 44 42 24 31 05 00 |........|.RDB$1..|
|000006c0| 07 00 08 04 25 00 00 00 | 0a 04 0a 00 00 00 09 04 |....%...|........|
|000006d0| 00 00 00 00 0b 04 00 00 | 00 00 29 04 0a 00 00 00 |........|..).....|
|000006e0| 2a 04 15 00 00 00 00 02 | 01 05 52 44 42 24 32 05 |*.......|..RDB$2.|
|000006f0| 00 07 00 08 04 25 00 00 | 00 0a 04 19 00 00 00 09 |.....%..|........|
|00000700| 04 00 00 00 00 0b 04 00 | 00 00 00 29 04 19 00 00 |........|...)....|
|00000710| 00 2a 04 15 00 00 00 00 | 02 01 05 52 44 42 24 33 |.*......|...RDB$3|
|00000720| 05 00 07 00 08 04 05 01 | 00 00 0a 04 08 00 00 00 |........|........|
|00000730| 09 04 01 00 00 00 0b 04 | 00 00 00 00 0c 04 90 01 |........|........|
|00000740| 00 00 2a 04 15 00 00 00 | 00 02 01 05 52 44 42 24 |..*.....|....RDB$|
|00000750| 34 05 00 07 00 08 04 25 | 00 00 00 0a 04 0f 00 00 |4......%|........|
|00000760| 00 09 04 00 00 00 00 0b | 04 00 00 00 00 1d 04 01 |........|........|
|00000770| 00 00 00 29 04 0f 00 00 | 00 2a 04 15 00 00 00 00 |...)....|.*......|
|00000780| 02 01 05 52 44 42 24 35 | 05 00 07 00 08 04 25 00 |...RDB$5|......%.|
|00000790| 00 00 0a 04 19 00 00 00 | 09 04 00 00 00 00 0b 04 |........|........|
|000007a0| 00 00 00 00 29 04 19 00 | 00 00 2a 04 15 00 00 00 |....)...|..*.....|
|000007b0| 00 02 01 05 52 44 42 24 | 36 05 00 07 00 08 04 25 |....RDB$|6......%|
|000007c0| 00 00 00 0a 04 0f 00 00 | 00 09 04 00 00 00 00 0b |........|........|
|000007d0| 04 00 00 00 00 29 04 0f | 00 00 00 2a 04 15 00 00 |.....)..|...*....|
|000007e0| 00 00 02 01 05 52 44 42 | 24 37 05 00 07 00 08 04 |.....RDB|$7......|
|000007f0| 25 00 00 00 0a 04 04 00 | 00 00 09 04 00 00 00 00 |%.......|........|
|00000800| 0b 04 00 00 00 00 29 04 | 04 00 00 00 2a 04 15 00 |......).|....*...|
|00000810| 00 00 00 02 01 05 52 44 | 42 24 38 05 00 07 00 08 |......RD|B$8.....|
|00000820| 04 23 00 00 00 0a 04 08 | 00 00 00 09 04 00 00 00 |.#......|........|
|00000830| 00 0b 04 00 00 00 00 00 | 02 01 05 52 44 42 24 39 |........|...RDB$9|
|00000840| 05 00 07 00 08 04 25 00 | 00 00 0a 04 2a 00 00 00 |......%.|....*...|
|00000850| 09 04 00 00 00 00 0b 04 | 00 00 00 00 12 04 25 00 |........|......%.|
|00000860| 00 00 04 27 27 17 00 09 | 4c 41 53 54 5f 4e 41 4d |...''...|LAST_NAM|
|00000870| 45 15 0f 7f 00 02 00 2c | 20 17 00 0a 46 49 52 53 |E......,| ...FIRS|
|00000880| 54 5f 4e 41 4d 45 4c 25 | 04 22 00 00 00 28 6c 61 |T_NAMEL%|."...(la|
|00000890| 73 74 5f 6e 61 6d 65 20 | 7c 7c 20 27 2c 20 27 20 |st_name ||| ', ' |
|000008a0| 7c 7c 20 66 69 72 73 74 | 5f 6e 61 6d 65 29 00 29 ||| first|_name).)|
|000008b0| 04 00 00 00 00 2a 04 15 | 00 00 00 00 02 01 06 52 |.....*..|.......R|
|000008c0| 44 42 24 31 30 05 00 07 | 00 08 04 25 00 00 00 0a |DB$10...|...%....|
|000008d0| 04 14 00 00 00 09 04 00 | 00 00 00 0b 04 00 00 00 |........|........|
|000008e0| 00 29 04 14 00 00 00 2a | 04 15 00 00 00 00 02 01 |.).....*|........|
|000008f0| 06 52 44 42 24 31 31 05 | 00 07 00 08 04 05 01 00 |.RDB$11.|........|
|00000900| 00 0a 04 08 00 00 00 09 | 04 01 00 00 00 0b 04 00 |........|........|
|00000910| 00 00 00 0c 04 20 03 00 | 00 2a 04 15 00 00 00 00 |..... ..|.*......|
|00000920| 02 01 06 52 44 42 24 31 | 32 05 00 07 00 08 04 08 |...RDB$1|2.......|
|00000930| 00 00 00 0a 04 04 00 00 | 00 09 04 00 00 00 00 0b |........|........|
|00000940| 04 00 00 00 00 2c 04 00 | 00 00 00 00 02 01 06 52 |.....,..|.......R|
|00000950| 44 42 24 31 33 05 00 07 | 00 08 04 08 00 00 00 0a |DB$13...|........|
|00000960| 04 04 00 00 00 09 04 00 | 00 00 00 0b 04 00 00 00 |........|........|
|00000970| 00 1d 04 01 00 00 00 2c | 04 00 00 00 00 00 02 01 |.......,|........|
|00000980| 06 52 44 42 24 31 34 05 | 00 07 00 08 04 23 00 00 |.RDB$14.|.....#..|
|00000990| 00 0a 04 08 00 00 00 09 | 04 00 00 00 00 0b 04 00 |........|........|
|000009a0| 00 00 00 00 02 01 06 52 | 44 42 24 31 35 05 00 07 |.......R|DB$15...|
|000009b0| 00 08 04 25 00 00 00 0a | 04 14 00 00 00 09 04 00 |...%....|........|
|000009c0| 00 00 00 0b 04 00 00 00 | 00 29 04 14 00 00 00 2a |........|.).....*|
|000009d0| 04 15 00 00 00 00 02 01 | 06 52 44 42 24 31 36 05 |........|.RDB$16.|
|000009e0| 00 07 00 08 04 1b 00 00 | 00 0a 04 08 00 00 00 09 |........|........|
|000009f0| 04 00 00 00 00 0b 04 00 | 00 00 00 00 02 01 06 52 |........|.......R|
|00000a00| 44 42 24 31 37 05 00 07 | 00 08 04 1b 00 00 00 0a |DB$17...|........|
|00000a10| 04 08 00 00 00 09 04 00 | 00 00 00 0b 04 00 00 00 |........|........|
|00000a20| 00 12 04 37 00 00 00 04 | 22 17 00 0a 4f 4c 44 5f |...7....|"...OLD_|
|00000a30| 53 41 4c 41 52 59 25 24 | 17 00 0a 4f 4c 44 5f 53 |SALARY%$|...OLD_S|
|00000a40| 41 4c 41 52 59 17 00 0e | 50 45 52 43 45 4e 54 5f |ALARY...|PERCENT_|
|00000a50| 43 48 41 4e 47 45 15 08 | 00 64 00 00 00 4c 25 04 |CHANGE..|.d...L%.|
|00000a60| 31 00 00 00 28 6f 6c 64 | 5f 73 61 6c 61 72 79 20 |1...(old|_salary |
|00000a70| 2b 20 6f 6c 64 5f 73 61 | 6c 61 72 79 20 2a 20 70 |+ old_sa|lary * p|
|00000a80| 65 72 63 65 6e 74 5f 63 | 68 61 6e 67 65 20 2f 20 |ercent_c|hange / |
|00000a90| 31 30 30 29 00 00 02 01 | 06 52 44 42 24 31 38 05 |100)....|.RDB$18.|
|00000aa0| 00 07 00 08 04 25 00 00 | 00 0a 04 23 00 00 00 09 |.....%..|...#....|
|00000ab0| 04 00 00 00 00 0b 04 00 | 00 00 00 29 04 23 00 00 |........|...).#..|
|00000ac0| 00 2a 04 15 00 00 00 00 | 02 01 06 52 44 42 24 31 |.*......|...RDB$1|
|00000ad0| 39 05 00 07 00 08 04 25 | 00 00 00 0a 04 19 00 00 |9......%|........|
|00000ae0| 00 09 04 00 00 00 00 0b | 04 00 00 00 00 29 04 19 |........|.....)..|
|00000af0| 00 00 00 2a 04 15 00 00 | 00 00 02 01 06 52 44 42 |...*....|.....RDB|
|00000b00| 24 32 30 05 00 07 00 08 | 04 25 00 00 00 0a 04 0f |$20.....|.%......|
|00000b10| 00 00 00 09 04 00 00 00 | 00 0b 04 00 00 00 00 29 |........|.......)|
|00000b20| 04 0f 00 00 00 2a 04 15 | 00 00 00 00 02 01 06 52 |.....*..|.......R|
|00000b30| 44 42 24 32 31 05 00 07 | 00 08 04 25 00 00 00 0a |DB$21...|...%....|
|00000b40| 04 0c 00 00 00 09 04 00 | 00 00 00 0b 04 00 00 00 |........|........|
|00000b50| 00 29 04 0c 00 00 00 2a | 04 15 00 00 00 00 02 01 |.).....*|........|
|00000b60| 06 52 44 42 24 32 32 05 | 00 07 00 08 04 0e 00 00 |.RDB$22.|........|
|00000b70| 00 0a 04 01 00 00 00 09 | 04 00 00 00 00 0b 04 00 |........|........|
|00000b80| 00 00 00 29 04 01 00 00 | 00 2a 04 15 00 00 00 00 |...)....|.*......|
|00000b90| 02 01 06 52 44 42 24 32 | 33 05 00 07 00 08 04 25 |...RDB$2|3......%|
|00000ba0| 00 00 00 0a 04 07 00 00 | 00 09 04 00 00 00 00 0b |........|........|
|00000bb0| 04 00 00 00 00 29 04 07 | 00 00 00 2a 04 15 00 00 |.....)..|...*....|
|00000bc0| 00 00 02 01 06 52 44 42 | 24 32 34 05 00 07 00 08 |.....RDB|$24.....|
|00000bd0| 04 23 00 00 00 0a 04 08 | 00 00 00 09 04 00 00 00 |.#......|........|
|00000be0| 00 0b 04 00 00 00 00 00 | 02 01 06 52 44 42 24 32 |........|...RDB$2|
|00000bf0| 35 05 00 07 00 08 04 23 | 00 00 00 0a 04 08 00 00 |5......#|........|
|00000c00| 00 09 04 00 00 00 00 0b | 04 00 00 00 00 00 02 01 |........|........|
|00000c10| 06 52 44 42 24 32 36 05 | 00 07 00 08 04 23 00 00 |.RDB$26.|.....#..|
|00000c20| 00 0a 04 08 00 00 00 09 | 04 00 00 00 00 0b 04 00 |........|........|
|00000c30| 00 00 00 00 02 01 06 52 | 44 42 24 32 37 05 00 07 |.......R|DB$27...|
|00000c40| 00 08 04 0e 00 00 00 0a | 04 01 00 00 00 09 04 00 |........|........|
|00000c50| 00 00 00 0b 04 00 00 00 | 00 29 04 01 00 00 00 2a |........|.).....*|
|00000c60| 04 15 00 00 00 00 02 01 | 06 52 44 42 24 32 38 05 |........|.RDB$28.|
|00000c70| 00 07 00 08 04 08 00 00 | 00 0a 04 04 00 00 00 09 |........|........|
|00000c80| 04 00 00 00 00 0b 04 00 | 00 00 00 2c 04 00 00 00 |........|...,....|
|00000c90| 00 00 02 01 06 52 44 42 | 24 32 39 05 00 07 00 08 |.....RDB|$29.....|
|00000ca0| 04 08 00 00 00 0a 04 04 | 00 00 00 09 04 02 00 00 |........|........|
|00000cb0| 00 0b 04 fe ff ff ff 2c | 04 09 00 00 00 00 02 01 |.......,|........|
|00000cc0| 06 52 44 42 24 33 30 05 | 00 07 00 08 04 0a 00 00 |.RDB$30.|........|
|00000cd0| 00 0a 04 04 00 00 00 09 | 04 00 00 00 00 0b 04 00 |........|........|
|00000ce0| 00 00 00 00 02 01 06 52 | 44 42 24 33 31 05 00 07 |.......R|DB$31...|
|00000cf0| 00 08 04 1b 00 00 00 0a | 04 08 00 00 00 09 04 00 |........|........|
|00000d00| 00 00 00 0b 04 00 00 00 | 00 12 04 1c 00 00 00 04 |........|........|
|00000d10| 23 17 00 09 53 48 49 50 | 5f 44 41 54 45 17 00 0a |#...SHIP|_DATE...|
|00000d20| 4f 52 44 45 52 5f 44 41 | 54 45 4c 25 04 19 00 00 |ORDER_DA|TEL%....|
|00000d30| 00 28 73 68 69 70 5f 64 | 61 74 65 20 2d 20 6f 72 |.(ship_d|ate - or|
|00000d40| 64 65 72 5f 64 61 74 65 | 29 00 00 02 01 06 52 44 |der_date|).....RD|
|00000d50| 42 24 33 32 05 00 07 00 | 08 04 07 00 00 00 0a 04 |B$32....|........|
|00000d60| 02 00 00 00 09 04 00 00 | 00 00 0b 04 00 00 00 00 |........|........|
|00000d70| 2c 04 00 00 00 00 00 02 | 01 06 52 44 42 24 33 33 |,.......|..RDB$33|
|00000d80| 05 00 07 00 08 04 0e 00 | 00 00 0a 04 05 00 00 00 |........|........|
|00000d90| 09 04 00 00 00 00 0b 04 | 00 00 00 00 29 04 05 00 |........|....)...|
|00000da0| 00 00 2a 04 15 00 00 00 | 2b 04 00 00 00 00 00 02 |..*.....|+.......|
|00000db0| 01 06 52 44 42 24 33 34 | 05 00 07 00 08 04 07 00 |..RDB$34|........|
|00000dc0| 00 00 0a 04 02 00 00 00 | 09 04 00 00 00 00 0b 04 |........|........|
|00000dd0| 00 00 00 00 2c 04 00 00 | 00 00 00 02 01 06 52 44 |....,...|......RD|
|00000de0| 42 24 33 35 05 00 07 00 | 08 04 0e 00 00 00 0a 04 |B$35....|........|
|00000df0| 05 00 00 00 09 04 00 00 | 00 00 0b 04 00 00 00 00 |........|........|
|00000e00| 29 04 05 00 00 00 2a 04 | 15 00 00 00 2b 04 00 00 |).....*.|....+...|
|00000e10| 00 00 00 02 01 06 52 44 | 42 24 33 36 05 00 07 00 |......RD|B$36....|
|00000e20| 08 04 0e 00 00 00 0a 04 | 03 00 00 00 09 04 00 00 |........|........|
|00000e30| 00 00 0b 04 00 00 00 00 | 29 04 03 00 00 00 2a 04 |........|).....*.|
|00000e40| 15 00 00 00 2b 04 00 00 | 00 00 00 02 01 06 52 44 |....+...|......RD|
|00000e50| 42 24 33 37 05 00 07 00 | 08 04 1b 00 00 00 0a 04 |B$37....|........|
|00000e60| 08 00 00 00 09 04 00 00 | 00 00 0b 04 fe ff ff ff |........|........|
|00000e70| 00 02 01 06 52 44 42 24 | 33 38 05 00 07 00 08 04 |....RDB$|38......|
|00000e80| 1b 00 00 00 0a 04 08 00 | 00 00 09 04 00 00 00 00 |........|........|
|00000e90| 0b 04 fe ff ff ff 00 02 | 01 06 52 44 42 24 33 39 |........|..RDB$39|
|00000ea0| 05 00 07 00 08 04 1b 00 | 00 00 0a 04 08 00 00 00 |........|........|
|00000eb0| 09 04 00 00 00 00 0b 04 | fe ff ff ff 00 02 01 06 |........|........|
|00000ec0| 52 44 42 24 34 30 05 00 | 07 00 08 04 1b 00 00 00 |RDB$40..|........|
|00000ed0| 0a 04 08 00 00 00 09 04 | 00 00 00 00 0b 04 fe ff |........|........|
|00000ee0| ff ff 00 02 01 06 52 44 | 42 24 34 31 05 00 07 00 |......RD|B$41....|
|00000ef0| 08 04 08 00 00 00 0a 04 | 04 00 00 00 09 04 00 00 |........|........|
|00000f00| 00 00 0b 04 00 00 00 00 | 2c 04 00 00 00 00 00 02 |........|,.......|
|00000f10| 01 06 52 44 42 24 34 32 | 05 00 07 00 08 04 0e 00 |..RDB$42|........|
|00000f20| 00 00 0a 04 03 00 00 00 | 09 04 00 00 00 00 0b 04 |........|........|
|00000f30| 00 00 00 00 29 04 03 00 | 00 00 2a 04 15 00 00 00 |....)...|..*.....|
|00000f40| 2b 04 00 00 00 00 00 02 | 01 06 52 44 42 24 34 33 |+.......|..RDB$43|
|00000f50| 05 00 07 00 08 04 1b 00 | 00 00 0a 04 08 00 00 00 |........|........|
|00000f60| 09 04 00 00 00 00 0b 04 | fe ff ff ff 00 02 01 06 |........|........|
|00000f70| 52 44 42 24 34 34 05 00 | 07 00 08 04 0e 00 00 00 |RDB$44..|........|
|00000f80| 0a 04 19 00 00 00 09 04 | 00 00 00 00 0b 04 00 00 |........|........|
|00000f90| 00 00 29 04 19 00 00 00 | 2a 04 15 00 00 00 2b 04 |..).....|*.....+.|
|00000fa0| 00 00 00 00 00 02 01 06 | 52 44 42 24 34 35 05 00 |........|RDB$45..|
|00000fb0| 07 00 08 04 0e 00 00 00 | 0a 04 19 00 00 00 09 04 |........|........|
|00000fc0| 00 00 00 00 0b 04 00 00 | 00 00 29 04 19 00 00 00 |........|..).....|
|00000fd0| 2a 04 15 00 00 00 2b 04 | 00 00 00 00 00 02 01 06 |*.....+.|........|
|00000fe0| 52 44 42 24 34 36 05 00 | 07 00 08 04 0e 00 00 00 |RDB$46..|........|
|00000ff0| 0a 04 14 00 00 00 09 04 | 00 00 00 00 0b 04 00 00 |........|........|
|00001000| 00 00 29 04 14 00 00 00 | 2a 04 15 00 00 00 2b 04 |..).....|*.....+.|
|00001010| 00 00 00 00 00 02 01 06 | 52 44 42 24 34 37 05 00 |........|RDB$47..|
|00001020| 07 00 08 04 0e 00 00 00 | 0a 04 05 00 00 00 09 04 |........|........|
|00001030| 00 00 00 00 0b 04 00 00 | 00 00 29 04 05 00 00 00 |........|..).....|
|00001040| 2a 04 15 00 00 00 2b 04 | 00 00 00 00 00 02 01 06 |*.....+.|........|
|00001050| 52 44 42 24 34 38 05 00 | 07 00 08 04 08 00 00 00 |RDB$48..|........|
|00001060| 0a 04 04 00 00 00 09 04 | 00 00 00 00 0b 04 00 00 |........|........|
|00001070| 00 00 2c 04 00 00 00 00 | 00 02 01 06 52 44 42 24 |..,.....|....RDB$|
|00001080| 34 39 05 00 07 00 08 04 | 08 00 00 00 0a 04 04 00 |49......|........|
|00001090| 00 00 09 04 00 00 00 00 | 0b 04 00 00 00 00 2c 04 |........|......,.|
|000010a0| 00 00 00 00 00 02 01 06 | 52 44 42 24 35 30 05 00 |........|RDB$50..|
|000010b0| 07 00 08 04 0e 00 00 00 | 0a 04 28 00 00 00 09 04 |........|..(.....|
|000010c0| 00 00 00 00 0b 04 00 00 | 00 00 29 04 28 00 00 00 |........|..).(...|
|000010d0| 2a 04 15 00 00 00 2b 04 | 00 00 00 00 00 02 01 06 |*.....+.|........|
|000010e0| 52 44 42 24 35 31 05 00 | 07 00 08 04 0e 00 00 00 |RDB$51..|........|
|000010f0| 0a 04 28 00 00 00 09 04 | 00 00 00 00 0b 04 00 00 |..(.....|........|
|00001100| 00 00 29 04 28 00 00 00 | 2a 04 15 00 00 00 2b 04 |..).(...|*.....+.|
|00001110| 00 00 00 00 00 02 01 06 | 52 44 42 24 35 32 05 00 |........|RDB$52..|
|00001120| 07 00 08 04 0e 00 00 00 | 0a 04 28 00 00 00 09 04 |........|..(.....|
|00001130| 00 00 00 00 0b 04 00 00 | 00 00 29 04 28 00 00 00 |........|..).(...|
|00001140| 2a 04 15 00 00 00 2b 04 | 00 00 00 00 00 02 01 06 |*.....+.|........|
|00001150| 52 44 42 24 35 33 05 00 | 07 00 08 04 0e 00 00 00 |RDB$53..|........|
|00001160| 0a 04 28 00 00 00 09 04 | 00 00 00 00 0b 04 00 00 |..(.....|........|
|00001170| 00 00 29 04 28 00 00 00 | 2a 04 15 00 00 00 2b 04 |..).(...|*.....+.|
|00001180| 00 00 00 00 00 02 01 06 | 52 44 42 24 35 34 05 00 |........|RDB$54..|
|00001190| 07 00 08 04 0e 00 00 00 | 0a 04 28 00 00 00 09 04 |........|..(.....|
|000011a0| 00 00 00 00 0b 04 00 00 | 00 00 29 04 28 00 00 00 |........|..).(...|
|000011b0| 2a 04 15 00 00 00 2b 04 | 00 00 00 00 00 02 01 06 |*.....+.|........|
|000011c0| 52 44 42 24 35 35 05 00 | 07 00 08 04 0e 00 00 00 |RDB$55..|........|
|000011d0| 0a 04 28 00 00 00 09 04 | 00 00 00 00 0b 04 00 00 |..(.....|........|
|000011e0| 00 00 29 04 28 00 00 00 | 2a 04 15 00 00 00 2b 04 |..).(...|*.....+.|
|000011f0| 00 00 00 00 00 02 01 06 | 52 44 42 24 35 36 05 00 |........|RDB$56..|
|00001200| 07 00 08 04 0e 00 00 00 | 0a 04 08 00 00 00 09 04 |........|........|
|00001210| 00 00 00 00 0b 04 00 00 | 00 00 29 04 08 00 00 00 |........|..).....|
|00001220| 2a 04 15 00 00 00 2b 04 | 00 00 00 00 00 02 01 06 |*.....+.|........|
|00001230| 52 44 42 24 35 37 05 00 | 07 00 08 04 25 00 00 00 |RDB$57..|....%...|
|00001240| 0a 04 05 00 00 00 09 04 | 00 00 00 00 0b 04 00 00 |........|........|
|00001250| 00 00 29 04 05 00 00 00 | 2a 04 15 00 00 00 2b 04 |..).....|*.....+.|
|00001260| 00 00 00 00 00 02 01 06 | 52 44 42 24 35 38 05 00 |........|RDB$58..|
|00001270| 07 00 08 04 07 00 00 00 | 0a 04 02 00 00 00 09 04 |........|........|
|00001280| 00 00 00 00 0b 04 00 00 | 00 00 2c 04 00 00 00 00 |........|..,.....|
|00001290| 00 02 01 06 52 44 42 24 | 35 39 05 00 07 00 08 04 |....RDB$|59......|
|000012a0| 25 00 00 00 0a 04 0f 00 | 00 00 09 04 00 00 00 00 |%.......|........|
|000012b0| 0b 04 00 00 00 00 29 04 | 0f 00 00 00 2a 04 15 00 |......).|....*...|
|000012c0| 00 00 2b 04 00 00 00 00 | 00 02 01 06 52 44 42 24 |..+.....|....RDB$|
|000012d0| 36 30 05 00 07 00 08 04 | 25 00 00 00 0a 04 0f 00 |60......|%.......|
|000012e0| 00 00 09 04 00 00 00 00 | 0b 04 00 00 00 00 29 04 |........|......).|
|000012f0| 0f 00 00 00 2a 04 15 00 | 00 00 2b 04 00 00 00 00 |....*...|..+.....|
|00001300| 00 02 01 06 52 44 42 24 | 36 31 05 00 07 00 08 04 |....RDB$|61......|
|00001310| 25 00 00 00 0a 04 05 00 | 00 00 09 04 00 00 00 00 |%.......|........|
|00001320| 0b 04 00 00 00 00 29 04 | 05 00 00 00 2a 04 15 00 |......).|....*...|
|00001330| 00 00 2b 04 00 00 00 00 | 00 02 01 06 52 44 42 24 |..+.....|....RDB$|
|00001340| 36 32 05 00 07 00 08 04 | 25 00 00 00 0a 04 05 00 |62......|%.......|
|00001350| 00 00 09 04 00 00 00 00 | 0b 04 00 00 00 00 29 04 |........|......).|
|00001360| 05 00 00 00 2a 04 15 00 | 00 00 2b 04 00 00 00 00 |....*...|..+.....|
|00001370| 00 02 01 06 52 44 42 24 | 36 33 05 00 07 00 08 04 |....RDB$|63......|
|00001380| 25 00 00 00 0a 04 0f 00 | 00 00 09 04 00 00 00 00 |%.......|........|
|00001390| 0b 04 00 00 00 00 29 04 | 0f 00 00 00 2a 04 15 00 |......).|....*...|
|000013a0| 00 00 2b 04 00 00 00 00 | 00 02 01 06 52 44 42 24 |..+.....|....RDB$|
|000013b0| 36 34 05 00 07 00 08 04 | 25 00 00 00 0a 04 0f 00 |64......|%.......|
|000013c0| 00 00 09 04 00 00 00 00 | 0b 04 00 00 00 00 29 04 |........|......).|
|000013d0| 0f 00 00 00 2a 04 15 00 | 00 00 2b 04 00 00 00 00 |....*...|..+.....|
|000013e0| 00 02 01 06 52 44 42 24 | 36 35 05 00 07 00 08 04 |....RDB$|65......|
|000013f0| 25 00 00 00 0a 04 28 00 | 00 00 09 04 00 00 00 00 |%.....(.|........|
|00001400| 0b 04 00 00 00 00 29 04 | 28 00 00 00 2a 04 15 00 |......).|(...*...|
|00001410| 00 00 2b 04 00 00 00 00 | 00 02 01 06 52 44 42 24 |..+.....|....RDB$|
|00001420| 36 36 05 00 07 00 08 04 | 25 00 00 00 0a 04 19 00 |66......|%.......|
|00001430| 00 00 09 04 00 00 00 00 | 0b 04 00 00 00 00 29 04 |........|......).|
|00001440| 19 00 00 00 2a 04 15 00 | 00 00 2b 04 00 00 00 00 |....*...|..+.....|
|00001450| 00 02 01 06 52 44 42 24 | 36 37 05 00 07 00 08 04 |....RDB$|67......|
|00001460| 25 00 00 00 0a 04 0f 00 | 00 00 09 04 00 00 00 00 |%.......|........|
|00001470| 0b 04 00 00 00 00 29 04 | 0f 00 00 00 2a 04 15 00 |......).|....*...|
|00001480| 00 00 2b 04 00 00 00 00 | 00 02 01 06 52 44 42 24 |..+.....|....RDB$|
|00001490| 36 38 05 00 07 00 08 04 | 25 00 00 00 0a 04 28 00 |68......|%.....(.|
|000014a0| 00 00 09 04 00 00 00 00 | 0b 04 00 00 00 00 29 04 |........|......).|
|000014b0| 28 00 00 00 2a 04 15 00 | 00 00 2b 04 00 00 00 00 |(...*...|..+.....|
|000014c0| 00 02 01 06 52 44 42 24 | 36 39 05 00 07 00 08 04 |....RDB$|69......|
|000014d0| 25 00 00 00 0a 04 19 00 | 00 00 09 04 00 00 00 00 |%.......|........|
|000014e0| 0b 04 00 00 00 00 29 04 | 19 00 00 00 2a 04 15 00 |......).|....*...|
|000014f0| 00 00 2b 04 00 00 00 00 | 00 02 01 06 52 44 42 24 |..+.....|....RDB$|
|00001500| 37 30 05 00 07 00 08 04 | 25 00 00 00 0a 04 0f 00 |70......|%.......|
|00001510| 00 00 09 04 00 00 00 00 | 0b 04 00 00 00 00 29 04 |........|......).|
|00001520| 0f 00 00 00 2a 04 15 00 | 00 00 2b 04 00 00 00 00 |....*...|..+.....|
|00001530| 00 02 01 06 52 44 42 24 | 37 31 05 00 07 00 08 04 |....RDB$|71......|
|00001540| 25 00 00 00 0a 04 28 00 | 00 00 09 04 00 00 00 00 |%.....(.|........|
|00001550| 0b 04 00 00 00 00 29 04 | 28 00 00 00 2a 04 15 00 |......).|(...*...|
|00001560| 00 00 2b 04 00 00 00 00 | 00 02 01 06 52 44 42 24 |..+.....|....RDB$|
|00001570| 37 32 05 00 07 00 08 04 | 25 00 00 00 0a 04 19 00 |72......|%.......|
|00001580| 00 00 09 04 00 00 00 00 | 0b 04 00 00 00 00 29 04 |........|......).|
|00001590| 19 00 00 00 2a 04 15 00 | 00 00 2b 04 00 00 00 00 |....*...|..+.....|
|000015a0| 00 02 01 06 52 44 42 24 | 37 33 05 00 07 00 08 04 |....RDB$|73......|
|000015b0| 25 00 00 00 0a 04 0f 00 | 00 00 09 04 00 00 00 00 |%.......|........|
|000015c0| 0b 04 00 00 00 00 29 04 | 0f 00 00 00 2a 04 15 00 |......).|....*...|
|000015d0| 00 00 2b 04 00 00 00 00 | 00 18 01 05 52 44 42 24 |..+.....|....RDB$|
|000015e0| 34 1d 04 00 00 00 00 20 | 04 01 00 00 00 21 04 05 |4...... |.....!..|
|000015f0| 00 00 00 00 18 01 06 52 | 44 42 24 31 33 1d 04 00 |.......R|DB$13...|
|00001600| 00 00 00 20 04 01 00 00 | 00 21 04 04 00 00 00 00 |... ....|.!......|
|00001610| 03 01 07 43 4f 55 4e 54 | 52 59 10 04 01 00 00 00 |...COUNT|RY......|
|00001620| 08 0b 53 51 4c 24 43 4f | 55 4e 54 52 59 0c 07 42 |..SQL$CO|UNTRY..B|
|00001630| 55 49 4c 44 45 52 00 04 | 01 08 43 55 52 52 45 4e |UILDER..|..CURREN|
|00001640| 43 59 02 05 52 44 42 24 | 31 0d 04 01 00 00 00 08 |CY..RDB$|1.......|
|00001650| 04 25 00 00 00 0a 04 0a | 00 00 00 09 04 00 00 00 |.%......|........|
|00001660| 00 0b 04 00 00 00 00 16 | 04 02 00 00 00 18 04 00 |........|........|
|00001670| 00 00 00 22 04 01 00 00 | 00 26 04 01 00 00 00 2a |..."....|.&.....*|
|00001680| 04 15 00 00 00 2b 04 00 | 00 00 00 00 04 01 07 43 |.....+..|.......C|
|00001690| 4f 55 4e 54 52 59 02 0b | 43 4f 55 4e 54 52 59 4e |OUNTRY..|COUNTRYN|
|000016a0| 41 4d 45 0d 04 00 00 00 | 00 08 04 25 00 00 00 0a |AME.....|...%....|
|000016b0| 04 0f 00 00 00 09 04 00 | 00 00 00 0b 04 00 00 00 |........|........|
|000016c0| 00 16 04 01 00 00 00 18 | 04 00 00 00 00 22 04 01 |........|....."..|
|000016d0| 00 00 00 26 04 01 00 00 | 00 2a 04 15 00 00 00 00 |...&....|.*......|
|000016e0| 09 03 01 03 4a 4f 42 10 | 04 01 00 00 00 08 07 53 |....JOB.|.......S|
|000016f0| 51 4c 24 4a 4f 42 0c 07 | 42 55 49 4c 44 45 52 00 |QL$JOB..|BUILDER.|
|00001700| 04 01 0f 4a 4f 42 5f 52 | 45 51 55 49 52 45 4d 45 |...JOB_R|EQUIREME|
|00001710| 4e 54 02 05 52 44 42 24 | 33 0d 04 06 00 00 00 08 |NT..RDB$|3.......|
|00001720| 04 05 01 00 00 0a 04 08 | 00 00 00 09 04 01 00 00 |........|........|
|00001730| 00 0b 04 00 00 00 00 16 | 04 07 00 00 00 18 04 00 |........|........|
|00001740| 00 00 00 22 04 01 00 00 | 00 2a 04 15 00 00 00 00 |..."....|.*......|
|00001750| 04 01 0a 4d 41 58 5f 53 | 41 4c 41 52 59 02 06 53 |...MAX_S|ALARY..S|
|00001760| 41 4c 41 52 59 0d 04 05 | 00 00 00 08 04 1b 00 00 |ALARY...|........|
|00001770| 00 0a 04 08 00 00 00 09 | 04 00 00 00 00 0b 04 fe |........|........|
|00001780| ff ff ff 16 04 06 00 00 | 00 18 04 00 00 00 00 22 |........|......."|
|00001790| 04 01 00 00 00 26 04 01 | 00 00 00 00 04 01 0a 4d |.....&..|.......M|
|000017a0| 49 4e 5f 53 41 4c 41 52 | 59 02 06 53 41 4c 41 52 |IN_SALAR|Y..SALAR|
|000017b0| 59 0d 04 04 00 00 00 08 | 04 1b 00 00 00 0a 04 08 |Y.......|........|
|000017c0| 00 00 00 09 04 00 00 00 | 00 0b 04 fe ff ff ff 16 |........|........|
|000017d0| 04 05 00 00 00 18 04 00 | 00 00 00 22 04 01 00 00 |........|..."....|
|000017e0| 00 26 04 01 00 00 00 00 | 04 01 09 4a 4f 42 5f 47 |.&......|...JOB_G|
|000017f0| 52 41 44 45 02 08 4a 4f | 42 47 52 41 44 45 0d 04 |RADE..JO|BGRADE..|
|00001800| 01 00 00 00 08 04 07 00 | 00 00 0a 04 02 00 00 00 |........|........|
|00001810| 09 04 00 00 00 00 0b 04 | 00 00 00 00 16 04 02 00 |........|........|
|00001820| 00 00 18 04 00 00 00 00 | 22 04 01 00 00 00 26 04 |........|".....&.|
|00001830| 01 00 00 00 00 04 01 0c | 4c 41 4e 47 55 41 47 45 |........|LANGUAGE|
|00001840| 5f 52 45 51 02 05 52 44 | 42 24 34 0d 04 07 00 00 |_REQ..RD|B$4.....|
|00001850| 00 08 04 25 00 00 00 0a | 04 0f 00 00 00 09 04 00 |...%....|........|
|00001860| 00 00 00 0b 04 00 00 00 | 00 16 04 08 00 00 00 18 |........|........|
|00001870| 04 00 00 00 00 22 04 01 | 00 00 00 2a 04 15 00 00 |....."..|...*....|
|00001880| 00 2b 04 00 00 00 00 1d | 04 01 00 00 00 20 04 01 |.+......|..... ..|
|00001890| 00 00 00 21 04 05 00 00 | 00 00 04 01 09 4a 4f 42 |...!....|.....JOB|
|000018a0| 5f 54 49 54 4c 45 02 05 | 52 44 42 24 32 0d 04 03 |_TITLE..|RDB$2...|
|000018b0| 00 00 00 08 04 25 00 00 | 00 0a 04 19 00 00 00 09 |.....%..|........|
|000018c0| 04 00 00 00 00 0b 04 00 | 00 00 00 16 04 04 00 00 |........|........|
|000018d0| 00 18 04 00 00 00 00 22 | 04 01 00 00 00 26 04 01 |......."|.....&..|
|000018e0| 00 00 00 2a 04 15 00 00 | 00 2b 04 00 00 00 00 00 |...*....|.+......|
|000018f0| 04 01 0b 4a 4f 42 5f 43 | 4f 55 4e 54 52 59 02 0b |...JOB_C|OUNTRY..|
|00001900| 43 4f 55 4e 54 52 59 4e | 41 4d 45 0d 04 02 00 00 |COUNTRYN|AME.....|
|00001910| 00 08 04 25 00 00 00 0a | 04 0f 00 00 00 09 04 00 |...%....|........|
|00001920| 00 00 00 0b 04 00 00 00 | 00 16 04 03 00 00 00 18 |........|........|
|00001930| 04 00 00 00 00 22 04 01 | 00 00 00 26 04 01 00 00 |....."..|...&....|
|00001940| 00 2a 04 15 00 00 00 00 | 04 01 08 4a 4f 42 5f 43 |.*......|...JOB_C|
|00001950| 4f 44 45 02 07 4a 4f 42 | 43 4f 44 45 0d 04 00 00 |ODE..JOB|CODE....|
|00001960| 00 00 08 04 25 00 00 00 | 0a 04 05 00 00 00 09 04 |....%...|........|
|00001970| 00 00 00 00 0b 04 00 00 | 00 00 16 04 01 00 00 00 |........|........|
|00001980| 18 04 00 00 00 00 22 04 | 01 00 00 00 26 04 01 00 |......".|....&...|
|00001990| 00 00 2a 04 02 00 00 00 | 00 09 03 01 0a 44 45 50 |..*.....|.....DEP|
|000019a0| 41 52 54 4d 45 4e 54 10 | 04 01 00 00 00 08 0e 53 |ARTMENT.|.......S|
|000019b0| 51 4c 24 44 45 50 41 52 | 54 4d 45 4e 54 0c 07 42 |QL$DEPAR|TMENT..B|
|000019c0| 55 49 4c 44 45 52 00 04 | 01 06 42 55 44 47 45 54 |UILDER..|..BUDGET|
|000019d0| 02 06 42 55 44 47 45 54 | 0d 04 04 00 00 00 08 04 |..BUDGET|........|
|000019e0| 1b 00 00 00 0a 04 08 00 | 00 00 09 04 00 00 00 00 |........|........|
|000019f0| 0b 04 fe ff ff ff 16 04 | 05 00 00 00 18 04 00 00 |........|........|
|00001a00| 00 00 22 04 01 00 00 00 | 00 04 01 08 50 48 4f 4e |..".....|....PHON|
|00001a10| 45 5f 4e 4f 02 0b 50 48 | 4f 4e 45 4e 55 4d 42 45 |E_NO..PH|ONENUMBE|
|00001a20| 52 0d 04 06 00 00 00 08 | 04 25 00 00 00 0a 04 14 |R.......|.%......|
|00001a30| 00 00 00 09 04 00 00 00 | 00 0b 04 00 00 00 00 16 |........|........|
|00001a40| 04 07 00 00 00 18 04 00 | 00 00 00 22 04 01 00 00 |........|..."....|
|00001a50| 00 2a 04 15 00 00 00 0f | 04 10 00 00 00 04 15 0f |.*......|........|
|00001a60| 7f 00 08 00 35 35 35 2d | 31 32 33 34 4c 27 04 14 |....555-|1234L'..|
|00001a70| 00 00 00 20 44 45 46 41 | 55 4c 54 20 27 35 35 35 |... DEFA|ULT '555|
|00001a80| 2d 31 32 33 34 27 00 00 | 04 01 07 4d 4e 47 52 5f |-1234'..|...MNGR_|
|00001a90| 4e 4f 02 05 45 4d 50 4e | 4f 0d 04 03 00 00 00 08 |NO..EMPN|O.......|
|00001aa0| 04 07 00 00 00 0a 04 02 | 00 00 00 09 04 00 00 00 |........|........|
|00001ab0| 00 0b 04 00 00 00 00 16 | 04 04 00 00 00 18 04 00 |........|........|
|00001ac0| 00 00 00 22 04 01 00 00 | 00 00 04 01 08 4c 4f 43 |..."....|.....LOC|
|00001ad0| 41 54 49 4f 4e 02 05 52 | 44 42 24 36 0d 04 05 00 |ATION..R|DB$6....|
|00001ae0| 00 00 08 04 25 00 00 00 | 0a 04 0f 00 00 00 09 04 |....%...|........|
|00001af0| 00 00 00 00 0b 04 00 00 | 00 00 16 04 06 00 00 00 |........|........|
|00001b00| 18 04 00 00 00 00 22 04 | 01 00 00 00 2a 04 15 00 |......".|....*...|
|00001b10| 00 00 2b 04 00 00 00 00 | 00 04 01 09 48 45 41 44 |..+.....|....HEAD|
|00001b20| 5f 44 45 50 54 02 06 44 | 45 50 54 4e 4f 0d 04 02 |_DEPT..D|EPTNO...|
|00001b30| 00 00 00 08 04 0e 00 00 | 00 0a 04 03 00 00 00 09 |........|........|
|00001b40| 04 00 00 00 00 0b 04 00 | 00 00 00 16 04 03 00 00 |........|........|
|00001b50| 00 18 04 00 00 00 00 22 | 04 01 00 00 00 2a 04 02 |......."|.....*..|
|00001b60| 00 00 00 00 04 01 0a 44 | 45 50 41 52 54 4d 45 4e |.......D|EPARTMEN|
|00001b70| 54 02 05 52 44 42 24 35 | 0d 04 01 00 00 00 08 04 |T..RDB$5|........|
|00001b80| 25 00 00 00 0a 04 19 00 | 00 00 09 04 00 00 00 00 |%.......|........|
|00001b90| 0b 04 00 00 00 00 16 04 | 02 00 00 00 18 04 00 00 |........|........|
|00001ba0| 00 00 22 04 01 00 00 00 | 26 04 01 00 00 00 2a 04 |..".....|&.....*.|
|00001bb0| 15 00 00 00 2b 04 00 00 | 00 00 00 04 01 07 44 45 |....+...|......DE|
|00001bc0| 50 54 5f 4e 4f 02 06 44 | 45 50 54 4e 4f 0d 04 00 |PT_NO..D|EPTNO...|
|00001bd0| 00 00 00 08 04 0e 00 00 | 00 0a 04 03 00 00 00 09 |........|........|
|00001be0| 04 00 00 00 00 0b 04 00 | 00 00 00 16 04 01 00 00 |........|........|
|00001bf0| 00 18 04 00 00 00 00 22 | 04 01 00 00 00 26 04 01 |......."|.....&..|
|00001c00| 00 00 00 2a 04 02 00 00 | 00 00 09 03 01 08 45 4d |...*....|......EM|
|00001c10| 50 4c 4f 59 45 45 10 04 | 01 00 00 00 08 0c 53 51 |PLOYEE..|......SQ|
|00001c20| 4c 24 45 4d 50 4c 4f 59 | 45 45 0c 07 42 55 49 4c |L$EMPLOY|EE..BUIL|
|00001c30| 44 45 52 00 04 01 06 53 | 41 4c 41 52 59 02 06 53 |DER....S|ALARY..S|
|00001c40| 41 4c 41 52 59 0d 04 09 | 00 00 00 08 04 1b 00 00 |ALARY...|........|
|00001c50| 00 0a 04 08 00 00 00 09 | 04 00 00 00 00 0b 04 fe |........|........|
|00001c60| ff ff ff 16 04 0a 00 00 | 00 18 04 00 00 00 00 22 |........|......."|
|00001c70| 04 01 00 00 00 26 04 01 | 00 00 00 00 04 01 09 48 |.....&..|.......H|
|00001c80| 49 52 45 5f 44 41 54 45 | 02 05 52 44 42 24 38 0d |IRE_DATE|..RDB$8.|
|00001c90| 04 04 00 00 00 08 04 23 | 00 00 00 0a 04 08 00 00 |.......#|........|
|00001ca0| 00 09 04 00 00 00 00 0b | 04 00 00 00 00 16 04 05 |........|........|
|00001cb0| 00 00 00 18 04 00 00 00 | 00 22 04 01 00 00 00 26 |........|.".....&|
|00001cc0| 04 01 00 00 00 0f 04 0b | 00 00 00 04 15 0f 7f 00 |........|........|
|00001cd0| 03 00 4e 4f 57 4c 27 04 | 0e 00 00 00 44 45 46 41 |..NOWL'.|....DEFA|
|00001ce0| 55 4c 54 20 27 4e 4f 57 | 27 00 00 04 01 09 46 55 |ULT 'NOW|'.....FU|
|00001cf0| 4c 4c 5f 4e 41 4d 45 02 | 05 52 44 42 24 39 0d 04 |LL_NAME.|.RDB$9..|
|00001d00| 0a 00 00 00 08 04 25 00 | 00 00 0a 04 2a 00 00 00 |......%.|....*...|
|00001d10| 09 04 00 00 00 00 0b 04 | 00 00 00 00 16 04 0b 00 |........|........|
|00001d20| 00 00 18 04 00 00 00 00 | 22 04 00 00 00 00 2a 04 |........|".....*.|
|00001d30| 15 00 00 00 2b 04 00 00 | 00 00 17 04 01 00 00 00 |....+...|........|
|00001d40| 00 04 01 09 4a 4f 42 5f | 47 52 41 44 45 02 08 4a |....JOB_|GRADE..J|
|00001d50| 4f 42 47 52 41 44 45 0d | 04 07 00 00 00 08 04 07 |OBGRADE.|........|
|00001d60| 00 00 00 0a 04 02 00 00 | 00 09 04 00 00 00 00 0b |........|........|
|00001d70| 04 00 00 00 00 16 04 08 | 00 00 00 18 04 00 00 00 |........|........|
|00001d80| 00 22 04 01 00 00 00 26 | 04 01 00 00 00 00 04 01 |.".....&|........|
|00001d90| 09 50 48 4f 4e 45 5f 45 | 58 54 02 05 52 44 42 24 |.PHONE_E|XT..RDB$|
|00001da0| 37 0d 04 03 00 00 00 08 | 04 25 00 00 00 0a 04 04 |7.......|.%......|
|00001db0| 00 00 00 09 04 00 00 00 | 00 0b 04 00 00 00 00 16 |........|........|
|00001dc0| 04 04 00 00 00 18 04 00 | 00 00 00 22 04 01 00 00 |........|..."....|
|00001dd0| 00 2a 04 15 00 00 00 2b | 04 00 00 00 00 00 04 01 |.*.....+|........|
|00001de0| 06 45 4d 50 5f 4e 4f 02 | 05 45 4d 50 4e 4f 0d 04 |.EMP_NO.|.EMPNO..|
|00001df0| 00 00 00 00 08 04 07 00 | 00 00 0a 04 02 00 00 00 |........|........|
|00001e00| 09 04 00 00 00 00 0b 04 | 00 00 00 00 16 04 01 00 |........|........|
|00001e10| 00 00 18 04 00 00 00 00 | 22 04 01 00 00 00 26 04 |........|".....&.|
|00001e20| 01 00 00 00 00 04 01 0b | 4a 4f 42 5f 43 4f 55 4e |........|JOB_COUN|
|00001e30| 54 52 59 02 0b 43 4f 55 | 4e 54 52 59 4e 41 4d 45 |TRY..COU|NTRYNAME|
|00001e40| 0d 04 08 00 00 00 08 04 | 25 00 00 00 0a 04 0f 00 |........|%.......|
|00001e50| 00 00 09 04 00 00 00 00 | 0b 04 00 00 00 00 16 04 |........|........|
|00001e60| 09 00 00 00 18 04 00 00 | 00 00 22 04 01 00 00 00 |........|..".....|
|00001e70| 26 04 01 00 00 00 2a 04 | 15 00 00 00 00 04 01 08 |&.....*.|........|
|00001e80| 4a 4f 42 5f 43 4f 44 45 | 02 07 4a 4f 42 43 4f 44 |JOB_CODE|..JOBCOD|
|00001e90| 45 0d 04 06 00 00 00 08 | 04 25 00 00 00 0a 04 05 |E.......|.%......|
|00001ea0| 00 00 00 09 04 00 00 00 | 00 0b 04 00 00 00 00 16 |........|........|
|00001eb0| 04 07 00 00 00 18 04 00 | 00 00 00 22 04 01 00 00 |........|..."....|
|00001ec0| 00 26 04 01 00 00 00 2a | 04 02 00 00 00 00 04 01 |.&.....*|........|
|00001ed0| 07 44 45 50 54 5f 4e 4f | 02 06 44 45 50 54 4e 4f |.DEPT_NO|..DEPTNO|
|00001ee0| 0d 04 05 00 00 00 08 04 | 0e 00 00 00 0a 04 03 00 |........|........|
|00001ef0| 00 00 09 04 00 00 00 00 | 0b 04 00 00 00 00 16 04 |........|........|
|00001f00| 06 00 00 00 18 04 00 00 | 00 00 22 04 01 00 00 00 |........|..".....|
|00001f10| 26 04 01 00 00 00 2a 04 | 02 00 00 00 00 04 01 09 |&.....*.|........|
|00001f20| 4c 41 53 54 5f 4e 41 4d | 45 02 08 4c 41 53 54 4e |LAST_NAM|E..LASTN|
|00001f30| 41 4d 45 0d 04 02 00 00 | 00 08 04 25 00 00 00 0a |AME.....|...%....|
|00001f40| 04 19 00 00 00 09 04 00 | 00 00 00 0b 04 00 00 00 |........|........|
|00001f50| 00 16 04 03 00 00 00 18 | 04 00 00 00 00 22 04 01 |........|....."..|
|00001f60| 00 00 00 26 04 01 00 00 | 00 2a 04 15 00 00 00 00 |...&....|.*......|
|00001f70| 04 01 0a 46 49 52 53 54 | 5f 4e 41 4d 45 02 09 46 |...FIRST|_NAME..F|
|00001f80| 49 52 53 54 4e 41 4d 45 | 0d 04 01 00 00 00 08 04 |IRSTNAME|........|
|00001f90| 25 00 00 00 0a 04 0f 00 | 00 00 09 04 00 00 00 00 |%.......|........|
|00001fa0| 0b 04 00 00 00 00 16 04 | 02 00 00 00 18 04 00 00 |........|........|
|00001fb0| 00 00 22 04 01 00 00 00 | 26 04 01 00 00 00 2a 04 |..".....|&.....*.|
|00001fc0| 15 00 00 00 00 09 03 01 | 07 50 52 4f 4a 45 43 54 |........|.PROJECT|
|00001fd0| 10 04 01 00 00 00 08 0b | 53 51 4c 24 50 52 4f 4a |........|SQL$PROJ|
|00001fe0| 45 43 54 0c 07 42 55 49 | 4c 44 45 52 00 04 01 09 |ECT..BUI|LDER....|
|00001ff0| 50 52 4f 4a 5f 44 45 53 | 43 02 06 52 44 42 24 31 |PROJ_DES|C..RDB$1|
|00002000| 31 0d 04 02 00 00 00 08 | 04 05 01 00 00 0a 04 08 |1.......|........|
|00002010| 00 00 00 09 04 01 00 00 | 00 0b 04 00 00 00 00 16 |........|........|
|00002020| 04 03 00 00 00 18 04 00 | 00 00 00 22 04 01 00 00 |........|..."....|
|00002030| 00 2a 04 15 00 00 00 00 | 04 01 07 50 52 4f 44 55 |.*......|...PRODU|
|00002040| 43 54 02 08 50 52 4f 44 | 54 59 50 45 0d 04 04 00 |CT..PROD|TYPE....|
|00002050| 00 00 08 04 25 00 00 00 | 0a 04 0c 00 00 00 09 04 |....%...|........|
|00002060| 00 00 00 00 0b 04 00 00 | 00 00 16 04 05 00 00 00 |........|........|
|00002070| 18 04 00 00 00 00 22 04 | 01 00 00 00 2a 04 15 00 |......".|....*...|
|00002080| 00 00 00 04 01 0b 54 45 | 41 4d 5f 4c 45 41 44 45 |......TE|AM_LEADE|
|00002090| 52 02 05 45 4d 50 4e 4f | 0d 04 03 00 00 00 08 04 |R..EMPNO|........|
|000020a0| 07 00 00 00 0a 04 02 00 | 00 00 09 04 00 00 00 00 |........|........|
|000020b0| 0b 04 00 00 00 00 16 04 | 04 00 00 00 18 04 00 00 |........|........|
|000020c0| 00 00 22 04 01 00 00 00 | 00 04 01 09 50 52 4f 4a |..".....|....PROJ|
|000020d0| 5f 4e 41 4d 45 02 06 52 | 44 42 24 31 30 0d 04 01 |_NAME..R|DB$10...|
|000020e0| 00 00 00 08 04 25 00 00 | 00 0a 04 14 00 00 00 09 |.....%..|........|
|000020f0| 04 00 00 00 00 0b 04 00 | 00 00 00 16 04 02 00 00 |........|........|
|00002100| 00 18 04 00 00 00 00 22 | 04 01 00 00 00 26 04 01 |......."|.....&..|
|00002110| 00 00 00 2a 04 15 00 00 | 00 2b 04 00 00 00 00 00 |...*....|.+......|
|00002120| 04 01 07 50 52 4f 4a 5f | 49 44 02 06 50 52 4f 4a |...PROJ_|ID..PROJ|
|00002130| 4e 4f 0d 04 00 00 00 00 | 08 04 0e 00 00 00 0a 04 |NO......|........|
|00002140| 05 00 00 00 09 04 00 00 | 00 00 0b 04 00 00 00 00 |........|........|
|00002150| 16 04 01 00 00 00 18 04 | 00 00 00 00 22 04 01 00 |........|...."...|
|00002160| 00 00 26 04 01 00 00 00 | 2a 04 02 00 00 00 00 09 |..&.....|*.......|
|00002170| 03 01 0a 50 48 4f 4e 45 | 5f 4c 49 53 54 02 04 33 |...PHONE|_LIST..3|
|00002180| 00 00 00 04 43 02 4a 08 | 45 4d 50 4c 4f 59 45 45 |....C.J.|EMPLOYEE|
|00002190| 01 4a 0a 44 45 50 41 52 | 54 4d 45 4e 54 02 47 2f |.J.DEPAR|TMENT.G/|
|000021a0| 17 01 07 44 45 50 54 5f | 4e 4f 17 02 07 44 45 50 |...DEPT_|NO...DEP|
|000021b0| 54 5f 4e 4f ff 4c 10 04 | 01 00 00 00 08 0e 53 51 |T_NO.L..|......SQ|
|000021c0| 4c 24 50 48 4f 4e 45 5f | 4c 49 53 54 0e 04 97 00 |L$PHONE_|LIST....|
|000021d0| 00 00 20 53 45 4c 45 43 | 54 0a 20 20 20 20 65 6d |.. SELEC|T.    em|
|000021e0| 70 5f 6e 6f 2c 20 66 69 | 72 73 74 5f 6e 61 6d 65 |p_no, fi|rst_name|
|000021f0| 2c 20 6c 61 73 74 5f 6e | 61 6d 65 2c 20 70 68 6f |, last_n|ame, pho|
|00002200| 6e 65 5f 65 78 74 2c 20 | 6c 6f 63 61 74 69 6f 6e |ne_ext, |location|
|00002210| 2c 20 70 68 6f 6e 65 5f | 6e 6f 0a 20 20 20 20 46 |, phone_|no.    F|
|00002220| 52 4f 4d 20 65 6d 70 6c | 6f 79 65 65 2c 20 64 65 |ROM empl|oyee, de|
|00002230| 70 61 72 74 6d 65 6e 74 | 0a 20 20 20 20 57 48 45 |partment|.    WHE|
|00002240| 52 45 20 65 6d 70 6c 6f | 79 65 65 2e 64 65 70 74 |RE emplo|yee.dept|
|00002250| 5f 6e 6f 20 3d 20 64 65 | 70 61 72 74 6d 65 6e 74 |_no = de|partment|
|00002260| 2e 64 65 70 74 5f 6e 6f | 00 0c 07 42 55 49 4c 44 |.dept_no|...BUILD|
|00002270| 45 52 00 04 01 08 50 48 | 4f 4e 45 5f 4e 4f 02 0b |ER....PH|ONE_NO..|
|00002280| 50 48 4f 4e 45 4e 55 4d | 42 45 52 0d 04 05 00 00 |PHONENUM|BER.....|
|00002290| 00 08 04 25 00 00 00 0a | 04 14 00 00 00 09 04 00 |...%....|........|
|000022a0| 00 00 00 0b 04 00 00 00 | 00 16 04 06 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 02 00 00 00 03 | 08 50 48 4f 4e 45 5f 4e |........|.PHONE_N|
|000022d0| 4f 00 04 01 09 50 48 4f | 4e 45 5f 45 58 54 02 05 |O....PHO|NE_EXT..|
|000022e0| 52 44 42 24 37 0d 04 03 | 00 00 00 08 04 25 00 00 |RDB$7...|.....%..|
|000022f0| 00 0a 04 04 00 00 00 09 | 04 00 00 00 00 0b 04 00 |........|........|
|00002300| 00 00 00 16 04 04 00 00 | 00 18 04 00 00 00 00 22 |........|......."|
|00002310| 04 00 00 00 00 2a 04 15 | 00 00 00 04 04 01 00 00 |.....*..|........|
|00002320| 00 03 09 50 48 4f 4e 45 | 5f 45 58 54 00 04 01 06 |...PHONE|_EXT....|
|00002330| 45 4d 50 5f 4e 4f 02 05 | 45 4d 50 4e 4f 0d 04 00 |EMP_NO..|EMPNO...|
|00002340| 00 00 00 08 04 07 00 00 | 00 0a 04 02 00 00 00 09 |........|........|
|00002350| 04 00 00 00 00 0b 04 00 | 00 00 00 16 04 01 00 00 |........|........|
|00002360| 00 18 04 00 00 00 00 22 | 04 00 00 00 00 04 04 01 |......."|........|
|00002370| 00 00 00 03 06 45 4d 50 | 5f 4e 4f 00 04 01 08 4c |.....EMP|_NO....L|
|00002380| 4f 43 41 54 49 4f 4e 02 | 05 52 44 42 24 36 0d 04 |OCATION.|.RDB$6..|
|00002390| 04 00 00 00 08 04 25 00 | 00 00 0a 04 0f 00 00 00 |......%.|........|
|000023a0| 09 04 00 00 00 00 0b 04 | 00 00 00 00 16 04 05 00 |........|........|
|000023b0| 00 00 18 04 00 00 00 00 | 22 04 00 00 00 00 2a 04 |........|".....*.|
|000023c0| 15 00 00 00 04 04 02 00 | 00 00 03 08 4c 4f 43 41 |........|....LOCA|
|000023d0| 54 49 4f 4e 00 04 01 09 | 4c 41 53 54 5f 4e 41 4d |TION....|LAST_NAM|
|000023e0| 45 02 08 4c 41 53 54 4e | 41 4d 45 0d 04 02 00 00 |E..LASTN|AME.....|
|000023f0| 00 08 04 25 00 00 00 0a | 04 19 00 00 00 09 04 00 |...%....|........|
|00002400| 00 00 00 0b 04 00 00 00 | 00 16 04 03 00 00 00 18 |........|........|
|00002410| 04 00 00 00 00 22 04 00 | 00 00 00 2a 04 15 00 00 |....."..|...*....|
|00002420| 00 04 04 01 00 00 00 03 | 09 4c 41 53 54 5f 4e 41 |........|.LAST_NA|
|00002430| 4d 45 00 04 01 0a 46 49 | 52 53 54 5f 4e 41 4d 45 |ME....FI|RST_NAME|
|00002440| 02 09 46 49 52 53 54 4e | 41 4d 45 0d 04 01 00 00 |..FIRSTN|AME.....|
|00002450| 00 08 04 25 00 00 00 0a | 04 0f 00 00 00 09 04 00 |...%....|........|
|00002460| 00 00 00 0b 04 00 00 00 | 00 16 04 02 00 00 00 18 |........|........|
|00002470| 04 00 00 00 00 22 04 00 | 00 00 00 2a 04 15 00 00 |....."..|...*....|
|00002480| 00 04 04 01 00 00 00 03 | 0a 46 49 52 53 54 5f 4e |........|.FIRST_N|
|00002490| 41 4d 45 00 0b 08 0a 44 | 45 50 41 52 54 4d 45 4e |AME....D|EPARTMEN|
|000024a0| 54 09 04 02 00 00 00 0a | 0a 44 45 50 41 52 54 4d |T.......|.DEPARTM|
|000024b0| 45 4e 54 00 0b 08 08 45 | 4d 50 4c 4f 59 45 45 09 |ENT....E|MPLOYEE.|
|000024c0| 04 01 00 00 00 0a 08 45 | 4d 50 4c 4f 59 45 45 00 |.......E|MPLOYEE.|
|000024d0| 09 03 01 10 45 4d 50 4c | 4f 59 45 45 5f 50 52 4f |....EMPL|OYEE_PRO|
|000024e0| 4a 45 43 54 10 04 01 00 | 00 00 08 14 53 51 4c 24 |JECT....|....SQL$|
|000024f0| 45 4d 50 4c 4f 59 45 45 | 5f 50 52 4f 4a 45 43 54 |EMPLOYEE|_PROJECT|
|00002500| 0c 07 42 55 49 4c 44 45 | 52 00 04 01 06 45 4d 50 |..BUILDE|R....EMP|
|00002510| 5f 4e 4f 02 05 45 4d 50 | 4e 4f 0d 04 00 00 00 00 |_NO..EMP|NO......|
|00002520| 08 04 07 00 00 00 0a 04 | 02 00 00 00 09 04 00 00 |........|........|
|00002530| 00 00 0b 04 00 00 00 00 | 16 04 01 00 00 00 18 04 |........|........|
|00002540| 00 00 00 00 22 04 01 00 | 00 00 26 04 01 00 00 00 |...."...|..&.....|
|00002550| 00 04 01 07 50 52 4f 4a | 5f 49 44 02 06 50 52 4f |....PROJ|_ID..PRO|
|00002560| 4a 4e 4f 0d 04 01 00 00 | 00 08 04 0e 00 00 00 0a |JNO.....|........|
|00002570| 04 05 00 00 00 09 04 00 | 00 00 00 0b 04 00 00 00 |........|........|
|00002580| 00 16 04 02 00 00 00 18 | 04 00 00 00 00 22 04 01 |........|....."..|
|00002590| 00 00 00 26 04 01 00 00 | 00 2a 04 02 00 00 00 00 |...&....|.*......|
|000025a0| 09 03 01 08 43 55 53 54 | 4f 4d 45 52 10 04 01 00 |....CUST|OMER....|
|000025b0| 00 00 08 0c 53 51 4c 24 | 43 55 53 54 4f 4d 45 52 |....SQL$|CUSTOMER|
|000025c0| 0c 07 42 55 49 4c 44 45 | 52 00 04 01 07 43 55 53 |..BUILDE|R....CUS|
|000025d0| 54 5f 4e 4f 02 06 43 55 | 53 54 4e 4f 0d 04 00 00 |T_NO..CU|STNO....|
|000025e0| 00 00 08 04 08 00 00 00 | 0a 04 04 00 00 00 09 04 |........|........|
|000025f0| 00 00 00 00 0b 04 00 00 | 00 00 16 04 01 00 00 00 |........|........|
|00002600| 18 04 00 00 00 00 22 04 | 01 00 00 00 26 04 01 00 |......".|....&...|
|00002610| 00 00 00 04 01 0b 50 4f | 53 54 41 4c 5f 43 4f 44 |......PO|STAL_COD|
|00002620| 45 02 06 52 44 42 24 32 | 31 0d 04 0a 00 00 00 08 |E..RDB$2|1.......|
|00002630| 04 25 00 00 00 0a 04 0c | 00 00 00 09 04 00 00 00 |.%......|........|
|00002640| 00 0b 04 00 00 00 00 16 | 04 0b 00 00 00 18 04 00 |........|........|
|00002650| 00 00 00 22 04 01 00 00 | 00 2a 04 15 00 00 00 2b |..."....|.*.....+|
|00002660| 04 00 00 00 00 00 04 01 | 0d 41 44 44 52 45 53 53 |........|.ADDRESS|
|00002670| 5f 4c 49 4e 45 32 02 0b | 41 44 44 52 45 53 53 4c |_LINE2..|ADDRESSL|
|00002680| 49 4e 45 0d 04 06 00 00 | 00 08 04 25 00 00 00 0a |INE.....|...%....|
|00002690| 04 28 00 00 00 09 04 00 | 00 00 00 0b 04 00 00 00 |.(......|........|
|000026a0| 00 16 04 07 00 00 00 18 | 04 00 00 00 00 22 04 01 |........|....."..|
|000026b0| 00 00 00 2a 04 15 00 00 | 00 00 04 01 0d 41 44 44 |...*....|.....ADD|
|000026c0| 52 45 53 53 5f 4c 49 4e | 45 31 02 0b 41 44 44 52 |RESS_LIN|E1..ADDR|
|000026d0| 45 53 53 4c 49 4e 45 0d | 04 05 00 00 00 08 04 25 |ESSLINE.|.......%|
|000026e0| 00 00 00 0a 04 28 00 00 | 00 09 04 00 00 00 00 0b |.....(..|........|
|000026f0| 04 00 00 00 00 16 04 06 | 00 00 00 18 04 00 00 00 |........|........|
|00002700| 00 22 04 01 00 00 00 2a | 04 15 00 00 00 00 04 01 |.".....*|........|
|00002710| 08 50 48 4f 4e 45 5f 4e | 4f 02 0b 50 48 4f 4e 45 |.PHONE_N|O..PHONE|
|00002720| 4e 55 4d 42 45 52 0d 04 | 04 00 00 00 08 04 25 00 |NUMBER..|......%.|
|00002730| 00 00 0a 04 14 00 00 00 | 09 04 00 00 00 00 0b 04 |........|........|
|00002740| 00 00 00 00 16 04 05 00 | 00 00 18 04 00 00 00 00 |........|........|
|00002750| 22 04 01 00 00 00 2a 04 | 15 00 00 00 00 04 01 07 |".....*.|........|
|00002760| 4f 4e 5f 48 4f 4c 44 02 | 06 52 44 42 24 32 32 0d |ON_HOLD.|.RDB$22.|
|00002770| 04 0b 00 00 00 08 04 0e | 00 00 00 0a 04 01 00 00 |........|........|
|00002780| 00 09 04 00 00 00 00 0b | 04 00 00 00 00 16 04 0c |........|........|
|00002790| 00 00 00 18 04 00 00 00 | 00 22 04 01 00 00 00 2a |........|.".....*|
|000027a0| 04 15 00 00 00 2b 04 00 | 00 00 00 0f 04 03 00 00 |.....+..|........|
|000027b0| 00 04 2d 4c 27 04 0d 00 | 00 00 44 45 46 41 55 4c |..-L'...|..DEFAUL|
|000027c0| 54 20 4e 55 4c 4c 00 00 | 04 01 07 43 4f 55 4e 54 |T NULL..|...COUNT|
|000027d0| 52 59 02 0b 43 4f 55 4e | 54 52 59 4e 41 4d 45 0d |RY..COUN|TRYNAME.|
|000027e0| 04 09 00 00 00 08 04 25 | 00 00 00 0a 04 0f 00 00 |.......%|........|
|000027f0| 00 09 04 00 00 00 00 0b | 04 00 00 00 00 16 04 0a |........|........|
|00002800| 00 00 00 18 04 00 00 00 | 00 22 04 01 00 00 00 2a |........|.".....*|
|00002810| 04 15 00 00 00 00 04 01 | 0e 53 54 41 54 45 5f 50 |........|.STATE_P|
|00002820| 52 4f 56 49 4e 43 45 02 | 06 52 44 42 24 32 30 0d |ROVINCE.|.RDB$20.|
|00002830| 04 08 00 00 00 08 04 25 | 00 00 00 0a 04 0f 00 00 |.......%|........|
|00002840| 00 09 04 00 00 00 00 0b | 04 00 00 00 00 16 04 09 |........|........|
|00002850| 00 00 00 18 04 00 00 00 | 00 22 04 01 00 00 00 2a |........|.".....*|
|00002860| 04 15 00 00 00 2b 04 00 | 00 00 00 00 04 01 04 43 |.....+..|.......C|
|00002870| 49 54 59 02 06 52 44 42 | 24 31 39 0d 04 07 00 00 |ITY..RDB|$19.....|
|00002880| 00 08 04 25 00 00 00 0a | 04 19 00 00 00 09 04 00 |...%....|........|
|00002890| 00 00 00 0b 04 00 00 00 | 00 16 04 08 00 00 00 18 |........|........|
|000028a0| 04 00 00 00 00 22 04 01 | 00 00 00 2a 04 15 00 00 |....."..|...*....|
|000028b0| 00 2b 04 00 00 00 00 00 | 04 01 0c 43 4f 4e 54 41 |.+......|...CONTA|
|000028c0| 43 54 5f 4c 41 53 54 02 | 08 4c 41 53 54 4e 41 4d |CT_LAST.|.LASTNAM|
|000028d0| 45 0d 04 03 00 00 00 08 | 04 25 00 00 00 0a 04 19 |E.......|.%......|
|000028e0| 00 00 00 09 04 00 00 00 | 00 0b 04 00 00 00 00 16 |........|........|
|000028f0| 04 04 00 00 00 18 04 00 | 00 00 00 22 04 01 00 00 |........|..."....|
|00002900| 00 2a 04 15 00 00 00 00 | 04 01 0d 43 4f 4e 54 41 |.*......|...CONTA|
|00002910| 43 54 5f 46 49 52 53 54 | 02 09 46 49 52 53 54 4e |CT_FIRST|..FIRSTN|
|00002920| 41 4d 45 0d 04 02 00 00 | 00 08 04 25 00 00 00 0a |AME.....|...%....|
|00002930| 04 0f 00 00 00 09 04 00 | 00 00 00 0b 04 00 00 00 |........|........|
|00002940| 00 16 04 03 00 00 00 18 | 04 00 00 00 00 22 04 01 |........|....."..|
|00002950| 00 00 00 2a 04 15 00 00 | 00 00 04 01 08 43 55 53 |...*....|.....CUS|
|00002960| 54 4f 4d 45 52 02 06 52 | 44 42 24 31 38 0d 04 01 |TOMER..R|DB$18...|
|00002970| 00 00 00 08 04 25 00 00 | 00 0a 04 23 00 00 00 09 |.....%..|...#....|
|00002980| 04 00 00 00 00 0b 04 00 | 00 00 00 16 04 02 00 00 |........|........|
|00002990| 00 18 04 00 00 00 00 22 | 04 01 00 00 00 26 04 01 |......."|.....&..|
|000029a0| 00 00 00 2a 04 15 00 00 | 00 2b 04 04 00 00 00 00 |...*....|.+......|
|000029b0| 09 03 01 05 53 41 4c 45 | 53 10 04 01 00 00 00 08 |....SALE|S.......|
|000029c0| 09 53 51 4c 24 53 41 4c | 45 53 0c 07 42 55 49 4c |.SQL$SAL|ES..BUIL|
|000029d0| 44 45 52 00 04 01 04 41 | 47 45 44 02 06 52 44 42 |DER....A|GED..RDB|
|000029e0| 24 33 31 0d 04 0c 00 00 | 00 08 04 1b 00 00 00 0a |$31.....|........|
|000029f0| 04 08 00 00 00 09 04 00 | 00 00 00 0b 04 00 00 00 |........|........|
|00002a00| 00 16 04 0d 00 00 00 18 | 04 00 00 00 00 22 04 00 |........|....."..|
|00002a10| 00 00 00 17 04 01 00 00 | 00 00 04 01 0b 44 41 54 |........|.....DAT|
|00002a20| 45 5f 4e 45 45 44 45 44 | 02 06 52 44 42 24 32 36 |E_NEEDED|..RDB$26|
|00002a30| 0d 04 06 00 00 00 08 04 | 23 00 00 00 0a 04 08 00 |........|#.......|
|00002a40| 00 00 09 04 00 00 00 00 | 0b 04 00 00 00 00 16 04 |........|........|
|00002a50| 07 00 00 00 18 04 00 00 | 00 00 22 04 01 00 00 00 |........|..".....|
|00002a60| 00 04 01 09 53 48 49 50 | 5f 44 41 54 45 02 06 52 |....SHIP|_DATE..R|
|00002a70| 44 42 24 32 35 0d 04 05 | 00 00 00 08 04 23 00 00 |DB$25...|.....#..|
|00002a80| 00 0a 04 08 00 00 00 09 | 04 00 00 00 00 0b 04 00 |........|........|
|00002a90| 00 00 00 16 04 06 00 00 | 00 18 04 00 00 00 00 22 |........|......."|
|00002aa0| 04 01 00 00 00 00 04 01 | 0a 4f 52 44 45 52 5f 44 |........|.ORDER_D|
|00002ab0| 41 54 45 02 06 52 44 42 | 24 32 34 0d 04 04 00 00 |ATE..RDB|$24.....|
|00002ac0| 00 08 04 23 00 00 00 0a | 04 08 00 00 00 09 04 00 |...#....|........|
|00002ad0| 00 00 00 0b 04 00 00 00 | 00 16 04 05 00 00 00 18 |........|........|
|00002ae0| 04 00 00 00 00 22 04 01 | 00 00 00 26 04 01 00 00 |....."..|...&....|
|00002af0| 00 0f 04 0b 00 00 00 04 | 15 0f 7f 00 03 00 4e 4f |........|......NO|
|00002b00| 57 4c 27 04 0e 00 00 00 | 44 45 46 41 55 4c 54 20 |WL'.....|DEFAULT |
|00002b10| 27 4e 4f 57 27 00 00 04 | 01 09 50 4f 5f 4e 55 4d |'NOW'...|..PO_NUM|
|00002b20| 42 45 52 02 08 50 4f 4e | 55 4d 42 45 52 0d 04 00 |BER..PON|UMBER...|
|00002b30| 00 00 00 08 04 0e 00 00 | 00 0a 04 08 00 00 00 09 |........|........|
|00002b40| 04 00 00 00 00 0b 04 00 | 00 00 00 16 04 01 00 00 |........|........|
|00002b50| 00 18 04 00 00 00 00 22 | 04 01 00 00 00 26 04 01 |......."|.....&..|
|00002b60| 00 00 00 2a 04 15 00 00 | 00 00 04 01 08 44 49 53 |...*....|.....DIS|
|00002b70| 43 4f 55 4e 54 02 06 52 | 44 42 24 33 30 0d 04 0a |COUNT..R|DB$30...|
|00002b80| 00 00 00 08 04 0a 00 00 | 00 0a 04 04 00 00 00 09 |........|........|
|00002b90| 04 00 00 00 00 0b 04 00 | 00 00 00 16 04 0b 00 00 |........|........|
|00002ba0| 00 18 04 00 00 00 00 22 | 04 01 00 00 00 26 04 01 |......."|.....&..|
|00002bb0| 00 00 00 0f 04 09 00 00 | 00 04 15 08 00 00 00 00 |........|........|
|00002bc0| 00 4c 27 04 0a 00 00 00 | 44 45 46 41 55 4c 54 20 |.L'.....|DEFAULT |
|00002bd0| 30 00 00 04 01 0b 54 4f | 54 41 4c 5f 56 41 4c 55 |0.....TO|TAL_VALU|
|00002be0| 45 02 06 52 44 42 24 32 | 39 0d 04 09 00 00 00 08 |E..RDB$2|9.......|
|00002bf0| 04 08 00 00 00 0a 04 04 | 00 00 00 09 04 02 00 00 |........|........|
|00002c00| 00 0b 04 fe ff ff ff 16 | 04 0a 00 00 00 18 04 00 |........|........|
|00002c10| 00 00 00 22 04 01 00 00 | 00 26 04 01 00 00 00 00 |..."....|.&......|
|00002c20| 04 01 0b 51 54 59 5f 4f | 52 44 45 52 45 44 02 06 |...QTY_O|RDERED..|
|00002c30| 52 44 42 24 32 38 0d 04 | 08 00 00 00 08 04 08 00 |RDB$28..|........|
|00002c40| 00 00 0a 04 04 00 00 00 | 09 04 00 00 00 00 0b 04 |........|........|
|00002c50| 00 00 00 00 16 04 09 00 | 00 00 18 04 00 00 00 00 |........|........|
|00002c60| 22 04 01 00 00 00 26 04 | 01 00 00 00 0f 04 09 00 |".....&.|........|
|00002c70| 00 00 04 15 08 00 01 00 | 00 00 4c 27 04 0a 00 00 |........|..L'....|
|00002c80| 00 44 45 46 41 55 4c 54 | 20 31 00 00 04 01 07 43 |.DEFAULT| 1.....C|
|00002c90| 55 53 54 5f 4e 4f 02 06 | 43 55 53 54 4e 4f 0d 04 |UST_NO..|CUSTNO..|
|00002ca0| 01 00 00 00 08 04 08 00 | 00 00 0a 04 04 00 00 00 |........|........|
|00002cb0| 09 04 00 00 00 00 0b 04 | 00 00 00 00 16 04 02 00 |........|........|
|00002cc0| 00 00 18 04 00 00 00 00 | 22 04 01 00 00 00 26 04 |........|".....&.|
|00002cd0| 01 00 00 00 00 04 01 09 | 49 54 45 4d 5f 54 59 50 |........|ITEM_TYP|
|00002ce0| 45 02 08 50 52 4f 44 54 | 59 50 45 0d 04 0b 00 00 |E..PRODT|YPE.....|
|00002cf0| 00 08 04 25 00 00 00 0a | 04 0c 00 00 00 09 04 00 |...%....|........|
|00002d00| 00 00 00 0b 04 00 00 00 | 00 16 04 0c 00 00 00 18 |........|........|
|00002d10| 04 00 00 00 00 22 04 01 | 00 00 00 2a 04 15 00 00 |....."..|...*....|
|00002d20| 00 00 04 01 09 53 41 4c | 45 53 5f 52 45 50 02 05 |.....SAL|ES_REP..|
|00002d30| 45 4d 50 4e 4f 0d 04 02 | 00 00 00 08 04 07 00 00 |EMPNO...|........|
|00002d40| 00 0a 04 02 00 00 00 09 | 04 00 00 00 00 0b 04 00 |........|........|
|00002d50| 00 00 00 16 04 03 00 00 | 00 18 04 00 00 00 00 22 |........|......."|
|00002d60| 04 01 00 00 00 00 04 01 | 04 50 41 49 44 02 06 52 |........|.PAID..R|
|00002d70| 44 42 24 32 37 0d 04 07 | 00 00 00 08 04 0e 00 00 |DB$27...|........|
|00002d80| 00 0a 04 01 00 00 00 09 | 04 00 00 00 00 0b 04 00 |........|........|
|00002d90| 00 00 00 16 04 08 00 00 | 00 18 04 00 00 00 00 22 |........|......."|
|00002da0| 04 01 00 00 00 2a 04 15 | 00 00 00 2b 04 00 00 00 |.....*..|...+....|
|00002db0| 00 0f 04 09 00 00 00 04 | 15 0f 7f 00 01 00 6e 4c |........|......nL|
|00002dc0| 27 04 0c 00 00 00 44 45 | 46 41 55 4c 54 20 27 6e |'.....DE|FAULT 'n|
|00002dd0| 27 00 00 04 01 0c 4f 52 | 44 45 52 5f 53 54 41 54 |'.....OR|DER_STAT|
|00002de0| 55 53 02 06 52 44 42 24 | 32 33 0d 04 03 00 00 00 |US..RDB$|23......|
|00002df0| 08 04 25 00 00 00 0a 04 | 07 00 00 00 09 04 00 00 |..%.....|........|
|00002e00| 00 00 0b 04 00 00 00 00 | 16 04 04 00 00 00 18 04 |........|........|
|00002e10| 00 00 00 00 22 04 01 00 | 00 00 26 04 01 00 00 00 |...."...|..&.....|
|00002e20| 2a 04 15 00 00 00 2b 04 | 00 00 00 00 0f 04 0b 00 |*.....+.|........|
|00002e30| 00 00 04 15 0f 7f 00 03 | 00 6e 65 77 4c 27 04 0e |........|.newL'..|
|00002e40| 00 00 00 44 45 46 41 55 | 4c 54 20 27 6e 65 77 27 |...DEFAU|LT 'new'|
|00002e50| 00 00 09 03 01 10 50 52 | 4f 4a 5f 44 45 50 54 5f |......PR|OJ_DEPT_|
|00002e60| 42 55 44 47 45 54 10 04 | 01 00 00 00 08 14 53 51 |BUDGET..|......SQ|
|00002e70| 4c 24 50 52 4f 4a 5f 44 | 45 50 54 5f 42 55 44 47 |L$PROJ_D|EPT_BUDG|
|00002e80| 45 54 0c 07 42 55 49 4c | 44 45 52 00 04 01 10 50 |ET..BUIL|DER....P|
|00002e90| 52 4f 4a 45 43 54 45 44 | 5f 42 55 44 47 45 54 02 |ROJECTED|_BUDGET.|
|00002ea0| 06 42 55 44 47 45 54 0d | 04 04 00 00 00 08 04 1b |.BUDGET.|........|
|00002eb0| 00 00 00 0a 04 08 00 00 | 00 09 04 00 00 00 00 0b |........|........|
|00002ec0| 04 fe ff ff ff 16 04 05 | 00 00 00 18 04 00 00 00 |........|........|
|00002ed0| 00 22 04 01 00 00 00 00 | 04 01 0e 51 55 41 52 54 |."......|...QUART|
|00002ee0| 5f 48 45 41 44 5f 43 4e | 54 02 06 52 44 42 24 31 |_HEAD_CN|T..RDB$1|
|00002ef0| 33 0d 04 03 00 00 00 08 | 04 08 00 00 00 0a 04 04 |3.......|........|
|00002f00| 00 00 00 09 04 00 00 00 | 00 0b 04 00 00 00 00 16 |........|........|
|00002f10| 04 04 00 00 00 18 04 00 | 00 00 00 22 04 01 00 00 |........|..."....|
|00002f20| 00 1d 04 01 00 00 00 20 | 04 01 00 00 00 21 04 04 |....... |.....!..|
|00002f30| 00 00 00 00 04 01 0b 46 | 49 53 43 41 4c 5f 59 45 |.......F|ISCAL_YE|
|00002f40| 41 52 02 06 52 44 42 24 | 31 32 0d 04 00 00 00 00 |AR..RDB$|12......|
|00002f50| 08 04 08 00 00 00 0a 04 | 04 00 00 00 09 04 00 00 |........|........|
|00002f60| 00 00 0b 04 00 00 00 00 | 16 04 01 00 00 00 18 04 |........|........|
|00002f70| 00 00 00 00 22 04 01 00 | 00 00 26 04 01 00 00 00 |...."...|..&.....|
|00002f80| 00 04 01 07 44 45 50 54 | 5f 4e 4f 02 06 44 45 50 |....DEPT|_NO..DEP|
|00002f90| 54 4e 4f 0d 04 02 00 00 | 00 08 04 0e 00 00 00 0a |TNO.....|........|
|00002fa0| 04 03 00 00 00 09 04 00 | 00 00 00 0b 04 00 00 00 |........|........|
|00002fb0| 00 16 04 03 00 00 00 18 | 04 00 00 00 00 22 04 01 |........|....."..|
|00002fc0| 00 00 00 26 04 01 00 00 | 00 2a 04 02 00 00 00 00 |...&....|.*......|
|00002fd0| 04 01 07 50 52 4f 4a 5f | 49 44 02 06 50 52 4f 4a |...PROJ_|ID..PROJ|
|00002fe0| 4e 4f 0d 04 01 00 00 00 | 08 04 0e 00 00 00 0a 04 |NO......|........|
|00002ff0| 05 00 00 00 09 04 00 00 | 00 00 0b 04 00 00 00 00 |........|........|
|00003000| 16 04 02 00 00 00 18 04 | 00 00 00 00 22 04 01 00 |........|...."...|
|00003010| 00 00 26 04 01 00 00 00 | 2a 04 02 00 00 00 00 09 |..&.....|*.......|
|00003020| 03 01 0e 53 41 4c 41 52 | 59 5f 48 49 53 54 4f 52 |...SALAR|Y_HISTOR|
|00003030| 59 10 04 01 00 00 00 08 | 12 53 51 4c 24 53 41 4c |Y.......|.SQL$SAL|
|00003040| 41 52 59 5f 48 49 53 54 | 4f 52 59 0c 07 42 55 49 |ARY_HIST|ORY..BUI|
|00003050| 4c 44 45 52 00 04 01 0a | 4e 45 57 5f 53 41 4c 41 |LDER....|NEW_SALA|
|00003060| 52 59 02 06 52 44 42 24 | 31 37 0d 04 05 00 00 00 |RY..RDB$|17......|
|00003070| 08 04 1b 00 00 00 0a 04 | 08 00 00 00 09 04 00 00 |........|........|
|00003080| 00 00 0b 04 00 00 00 00 | 16 04 06 00 00 00 18 04 |........|........|
|00003090| 00 00 00 00 22 04 00 00 | 00 00 17 04 01 00 00 00 |...."...|........|
|000030a0| 00 04 01 0e 50 45 52 43 | 45 4e 54 5f 43 48 41 4e |....PERC|ENT_CHAN|
|000030b0| 47 45 02 06 52 44 42 24 | 31 36 0d 04 04 00 00 00 |GE..RDB$|16......|
|000030c0| 08 04 1b 00 00 00 0a 04 | 08 00 00 00 09 04 00 00 |........|........|
|000030d0| 00 00 0b 04 00 00 00 00 | 16 04 05 00 00 00 18 04 |........|........|
|000030e0| 00 00 00 00 22 04 01 00 | 00 00 26 04 01 00 00 00 |...."...|..&.....|
|000030f0| 0f 04 09 00 00 00 04 15 | 08 00 00 00 00 00 4c 27 |........|......L'|
|00003100| 04 0a 00 00 00 44 45 46 | 41 55 4c 54 20 30 00 00 |.....DEF|AULT 0..|
|00003110| 04 01 0a 4f 4c 44 5f 53 | 41 4c 41 52 59 02 06 53 |...OLD_S|ALARY..S|
|00003120| 41 4c 41 52 59 0d 04 03 | 00 00 00 08 04 1b 00 00 |ALARY...|........|
|00003130| 00 0a 04 08 00 00 00 09 | 04 00 00 00 00 0b 04 fe |........|........|
|00003140| ff ff ff 16 04 04 00 00 | 00 18 04 00 00 00 00 22 |........|......."|
|00003150| 04 01 00 00 00 26 04 01 | 00 00 00 00 04 01 0b 43 |.....&..|.......C|
|00003160| 48 41 4e 47 45 5f 44 41 | 54 45 02 06 52 44 42 24 |HANGE_DA|TE..RDB$|
|00003170| 31 34 0d 04 01 00 00 00 | 08 04 23 00 00 00 0a 04 |14......|..#.....|
|00003180| 08 00 00 00 09 04 00 00 | 00 00 0b 04 00 00 00 00 |........|........|
|00003190| 16 04 02 00 00 00 18 04 | 00 00 00 00 22 04 01 00 |........|...."...|
|000031a0| 00 00 26 04 01 00 00 00 | 0f 04 0b 00 00 00 04 15 |..&.....|........|
|000031b0| 0f 7f 00 03 00 4e 4f 57 | 4c 27 04 0e 00 00 00 44 |.....NOW|L'.....D|
|000031c0| 45 46 41 55 4c 54 20 27 | 4e 4f 57 27 00 00 04 01 |EFAULT '|NOW'....|
|000031d0| 0a 55 50 44 41 54 45 52 | 5f 49 44 02 06 52 44 42 |.UPDATER|_ID..RDB|
|000031e0| 24 31 35 0d 04 02 00 00 | 00 08 04 25 00 00 00 0a |$15.....|...%....|
|000031f0| 04 14 00 00 00 09 04 00 | 00 00 00 0b 04 00 00 00 |........|........|
|00003200| 00 16 04 03 00 00 00 18 | 04 00 00 00 00 22 04 01 |........|....."..|
|00003210| 00 00 00 26 04 01 00 00 | 00 2a 04 15 00 00 00 2b |...&....|.*.....+|
|00003220| 04 00 00 00 00 00 04 01 | 06 45 4d 50 5f 4e 4f 02 |........|.EMP_NO.|
|00003230| 05 45 4d 50 4e 4f 0d 04 | 00 00 00 00 08 04 07 00 |.EMPNO..|........|
|00003240| 00 00 0a 04 02 00 00 00 | 09 04 00 00 00 00 0b 04 |........|........|
|00003250| 00 00 00 00 16 04 01 00 | 00 00 18 04 00 00 00 00 |........|........|
|00003260| 22 04 01 00 00 00 26 04 | 01 00 00 00 00 09 1a 01 |".....&.|........|
|00003270| 0a 45 4d 50 5f 4e 4f 5f | 47 45 4e 03 08 91 00 00 |.EMP_NO_|GEN.....|
|00003280| 00 00 00 00 00 00 1a 01 | 0b 43 55 53 54 5f 4e 4f |........|.CUST_NO|
|00003290| 5f 47 45 4e 03 08 f7 03 | 00 00 00 00 00 00 00 1b |_GEN....|........|
|000032a0| 01 0c 47 45 54 5f 45 4d | 50 5f 50 52 4f 4a 02 04 |..GET_EM|P_PROJ..|
|000032b0| 01 00 00 00 03 04 01 00 | 00 00 07 04 6f 00 00 00 |........|....o...|
|000032c0| 0a 42 45 47 49 4e 0a 20 | 46 4f 52 20 53 45 4c 45 |.BEGIN. |FOR SELE|
|000032d0| 43 54 20 70 72 6f 6a 5f | 69 64 0a 20 20 46 52 4f |CT proj_|id.  FRO|
|000032e0| 4d 20 65 6d 70 6c 6f 79 | 65 65 5f 70 72 6f 6a 65 |M employ|ee_proje|
|000032f0| 63 74 0a 20 20 57 48 45 | 52 45 20 65 6d 70 5f 6e |ct.  WHE|RE emp_n|
|00003300| 6f 20 3d 20 3a 65 6d 70 | 5f 6e 6f 0a 20 20 49 4e |o = :emp|_no.  IN|
|00003310| 54 4f 20 3a 70 72 6f 6a | 5f 69 64 0a 20 44 4f 0a |TO :proj|_id. DO.|
|00003320| 20 20 53 55 53 50 45 4e | 44 3b 0a 45 4e 44 00 08 |  SUSPEN|D;.END..|
|00003330| 04 9c 00 00 00 04 02 04 | 00 02 00 07 00 07 00 04 |........|........|
|00003340| 01 03 00 0f 15 00 05 00 | 07 00 07 00 0c 00 02 03 |........|........|
|00003350| 00 00 0f 15 00 05 00 01 | 2d 1a 00 00 9b 11 00 02 |........|-.......|
|00003360| 02 07 43 01 4a 10 45 4d | 50 4c 4f 59 45 45 5f 50 |..C.J.EM|PLOYEE_P|
|00003370| 52 4f 4a 45 43 54 00 47 | 2f 17 00 06 45 4d 50 5f |ROJECT.G|/...EMP_|
|00003380| 4e 4f 29 00 00 00 01 00 | ff 02 01 17 00 07 50 52 |NO).....|......PR|
|00003390| 4f 4a 5f 49 44 1a 00 00 | 02 0e 01 02 01 1a 00 00 |OJ_ID...|........|
|000033a0| 29 01 00 00 01 00 01 15 | 07 00 01 00 19 01 02 00 |).......|........|
|000033b0| ff 9b ff ff ff ff ff 0e | 01 02 01 1a 00 00 29 01 |........|......).|
|000033c0| 00 00 01 00 01 15 07 00 | 00 00 19 01 02 00 ff ff |........|........|
|000033d0| 4c 09 10 53 51 4c 24 47 | 45 54 5f 45 4d 50 5f 50 |L..SQL$G|ET_EMP_P|
|000033e0| 52 4f 4a 0a 07 42 55 49 | 4c 44 45 52 00 1c 01 06 |ROJ..BUI|LDER....|
|000033f0| 45 4d 50 5f 4e 4f 02 04 | 00 00 00 00 03 04 00 00 |EMP_NO..|........|
|00003400| 00 00 04 06 52 44 42 24 | 33 32 00 1c 01 07 50 52 |....RDB$|32....PR|
|00003410| 4f 4a 5f 49 44 02 04 00 | 00 00 00 03 04 01 00 00 |OJ_ID...|........|
|00003420| 00 04 06 52 44 42 24 33 | 33 00 1d 1b 01 0c 41 44 |...RDB$3|3.....AD|
|00003430| 44 5f 45 4d 50 5f 50 52 | 4f 4a 02 04 02 00 00 00 |D_EMP_PR|OJ......|
|00003440| 03 04 00 00 00 00 07 04 | 9f 00 00 00 0a 42 45 47 |........|.....BEG|
|00003450| 49 4e 0a 20 42 45 47 49 | 4e 0a 20 49 4e 53 45 52 |IN. BEGI|N. INSER|
|00003460| 54 20 49 4e 54 4f 20 65 | 6d 70 6c 6f 79 65 65 5f |T INTO e|mployee_|
|00003470| 70 72 6f 6a 65 63 74 20 | 28 65 6d 70 5f 6e 6f 2c |project |(emp_no,|
|00003480| 20 70 72 6f 6a 5f 69 64 | 29 20 56 41 4c 55 45 53 | proj_id|) VALUES|
|00003490| 20 28 3a 65 6d 70 5f 6e | 6f 2c 20 3a 70 72 6f 6a | (:emp_n|o, :proj|
|000034a0| 5f 69 64 29 3b 0a 20 57 | 48 45 4e 20 53 51 4c 43 |_id);. W|HEN SQLC|
|000034b0| 4f 44 45 20 2d 35 33 30 | 20 44 4f 0a 20 20 45 58 |ODE -530| DO.  EX|
|000034c0| 43 45 50 54 49 4f 4e 20 | 75 6e 6b 6e 6f 77 6e 5f |CEPTION |unknown_|
|000034d0| 65 6d 70 5f 69 64 3b 0a | 20 45 4e 44 0a 20 53 55 |emp_id;.| END. SU|
|000034e0| 53 50 45 4e 44 3b 0a 45 | 4e 44 00 08 04 9d 00 00 |SPEND;.E|ND......|
|000034f0| 00 04 02 04 00 04 00 07 | 00 07 00 0f 15 00 05 00 |........|........|
|00003500| 07 00 04 01 01 00 07 00 | 0c 00 02 9b 11 00 02 02 |........|........|
|00003510| 81 02 02 86 0f 4a 10 45 | 4d 50 4c 4f 59 45 45 5f |.....J.E|MPLOYEE_|
|00003520| 50 52 4f 4a 45 43 54 00 | 02 01 29 00 00 00 01 00 |PROJECT.|..).....|
|00003530| 17 00 06 45 4d 50 5f 4e | 4f 01 29 00 02 00 03 00 |...EMP_N|O.).....|
|00003540| 17 00 07 50 52 4f 4a 5f | 49 44 ff 87 ff ff 82 01 |...PROJ_|ID......|
|00003550| 00 01 ee fd 02 86 80 02 | 0e 55 4e 4b 4e 4f 57 4e |........|.UNKNOWN|
|00003560| 5f 45 4d 50 5f 49 44 87 | ff ff 02 0e 01 02 01 15 |_EMP_ID.|........|
|00003570| 07 00 01 00 19 01 00 00 | ff 9b ff ff ff ff 0e 01 |........|........|
|00003580| 02 01 15 07 00 00 00 19 | 01 00 00 ff ff 4c 09 10 |........|.....L..|
|00003590| 53 51 4c 24 41 44 44 5f | 45 4d 50 5f 50 52 4f 4a |SQL$ADD_|EMP_PROJ|
|000035a0| 0a 07 42 55 49 4c 44 45 | 52 00 1c 01 06 45 4d 50 |..BUILDE|R....EMP|
|000035b0| 5f 4e 4f 02 04 00 00 00 | 00 03 04 00 00 00 00 04 |_NO.....|........|
|000035c0| 06 52 44 42 24 33 34 00 | 1c 01 07 50 52 4f 4a 5f |.RDB$34.|...PROJ_|
|000035d0| 49 44 02 04 01 00 00 00 | 03 04 00 00 00 00 04 06 |ID......|........|
|000035e0| 52 44 42 24 33 35 00 1d | 1b 01 0e 53 55 42 5f 54 |RDB$35..|...SUB_T|
|000035f0| 4f 54 5f 42 55 44 47 45 | 54 02 04 01 00 00 00 03 |OT_BUDGE|T.......|
|00003600| 04 04 00 00 00 07 04 bc | 00 00 00 0a 42 45 47 49 |........|....BEGI|
|00003610| 4e 0a 20 53 45 4c 45 43 | 54 20 53 55 4d 28 62 75 |N. SELEC|T SUM(bu|
|00003620| 64 67 65 74 29 2c 20 41 | 56 47 28 62 75 64 67 65 |dget), A|VG(budge|
|00003630| 74 29 2c 20 4d 49 4e 28 | 62 75 64 67 65 74 29 2c |t), MIN(|budget),|
|00003640| 20 4d 41 58 28 62 75 64 | 67 65 74 29 0a 20 20 46 | MAX(bud|get).  F|
|00003650| 52 4f 4d 20 64 65 70 61 | 72 74 6d 65 6e 74 0a 20 |ROM depa|rtment. |
|00003660| 20 57 48 45 52 45 20 68 | 65 61 64 5f 64 65 70 74 | WHERE h|ead_dept|
|00003670| 20 3d 20 3a 68 65 61 64 | 5f 64 65 70 74 0a 20 20 | = :head|_dept.  |
|00003680| 49 4e 54 4f 20 3a 74 6f | 74 5f 62 75 64 67 65 74 |INTO :to|t_budget|
|00003690| 2c 20 3a 61 76 67 5f 62 | 75 64 67 65 74 2c 20 3a |, :avg_b|udget, :|
|000036a0| 6d 69 6e 5f 62 75 64 67 | 65 74 2c 20 3a 6d 61 78 |min_budg|et, :max|
|000036b0| 5f 62 75 64 67 65 74 3b | 0a 20 53 55 53 50 45 4e |_budget;|. SUSPEN|
|000036c0| 44 3b 0a 45 4e 44 00 08 | 04 41 01 00 00 04 02 04 |D;.END..|.A......|
|000036d0| 00 02 00 0f 15 00 03 00 | 07 00 04 01 09 00 1b 07 |........|........|
|000036e0| 00 1b 07 00 1b 07 00 1b | 07 00 07 00 0c 00 02 03 |........|........|
|000036f0| 00 00 1b 01 2d 1a 00 00 | 03 01 00 1b 01 2d 1a 01 |....-...|.....-..|
|00003700| 00 03 02 00 1b 01 2d 1a | 02 00 03 03 00 1b 01 2d |......-.|.......-|
|00003710| 1a 03 00 9b 11 00 02 02 | 07 7f 43 01 4f 01 43 01 |........|..C.O.C.|
|00003720| 4a 0a 44 45 50 41 52 54 | 4d 45 4e 54 00 47 2f 17 |J.DEPART|MENT.G/.|
|00003730| 00 09 48 45 41 44 5f 44 | 45 50 54 29 00 00 00 01 |..HEAD_D|EPT)....|
|00003740| 00 ff 4e 00 4d 04 00 00 | 00 54 17 00 06 42 55 44 |..N.M...|.T...BUD|
|00003750| 47 45 54 01 00 55 17 00 | 06 42 55 44 47 45 54 02 |GET..U..|.BUDGET.|
|00003760| 00 57 17 00 06 42 55 44 | 47 45 54 03 00 56 17 00 |.W...BUD|GET..V..|
|00003770| 06 42 55 44 47 45 54 ff | 02 01 18 01 03 00 1a 00 |.BUDGET.|........|
|00003780| 00 01 18 01 02 00 1a 01 | 00 01 18 01 01 00 1a 02 |........|........|
|00003790| 00 01 18 01 00 00 1a 03 | 00 ff 02 0e 01 02 01 1a |........|........|
|000037a0| 00 00 29 01 00 00 01 00 | 01 1a 01 00 29 01 02 00 |..).....|....)...|
|000037b0| 03 00 01 1a 02 00 29 01 | 04 00 05 00 01 1a 03 00 |......).|........|
|000037c0| 29 01 06 00 07 00 01 15 | 07 00 01 00 19 01 08 00 |).......|........|
|000037d0| ff 9b ff ff ff ff 0e 01 | 02 01 1a 00 00 29 01 00 |........|.....)..|
|000037e0| 00 01 00 01 1a 01 00 29 | 01 02 00 03 00 01 1a 02 |.......)|........|
|000037f0| 00 29 01 04 00 05 00 01 | 1a 03 00 29 01 06 00 07 |.)......|...)....|
|00003800| 00 01 15 07 00 00 00 19 | 01 08 00 ff ff 4c 09 12 |........|.....L..|
|00003810| 53 51 4c 24 53 55 42 5f | 54 4f 54 5f 42 55 44 47 |SQL$SUB_|TOT_BUDG|
|00003820| 45 54 0a 07 42 55 49 4c | 44 45 52 00 1c 01 09 48 |ET..BUIL|DER....H|
|00003830| 45 41 44 5f 44 45 50 54 | 02 04 00 00 00 00 03 04 |EAD_DEPT|........|
|00003840| 00 00 00 00 04 06 52 44 | 42 24 33 36 00 1c 01 0a |......RD|B$36....|
|00003850| 54 4f 54 5f 42 55 44 47 | 45 54 02 04 00 00 00 00 |TOT_BUDG|ET......|
|00003860| 03 04 01 00 00 00 04 06 | 52 44 42 24 33 37 00 1c |........|RDB$37..|
|00003870| 01 0a 41 56 47 5f 42 55 | 44 47 45 54 02 04 01 00 |..AVG_BU|DGET....|
|00003880| 00 00 03 04 01 00 00 00 | 04 06 52 44 42 24 33 38 |........|..RDB$38|
|00003890| 00 1c 01 0a 4d 49 4e 5f | 42 55 44 47 45 54 02 04 |....MIN_|BUDGET..|
|000038a0| 02 00 00 00 03 04 01 00 | 00 00 04 06 52 44 42 24 |........|....RDB$|
|000038b0| 33 39 00 1c 01 0a 4d 41 | 58 5f 42 55 44 47 45 54 |39....MA|X_BUDGET|
|000038c0| 02 04 03 00 00 00 03 04 | 01 00 00 00 04 06 52 44 |........|......RD|
|000038d0| 42 24 34 30 00 1d 1b 01 | 0f 44 45 4c 45 54 45 5f |B$40....|.DELETE_|
|000038e0| 45 4d 50 4c 4f 59 45 45 | 02 04 01 00 00 00 03 04 |EMPLOYEE|........|
|000038f0| 00 00 00 00 07 04 cc 03 | 00 00 0a 20 44 45 43 4c |........|... DECL|
|00003900| 41 52 45 20 56 41 52 49 | 41 42 4c 45 20 61 6e 79 |ARE VARI|ABLE any|
|00003910| 5f 73 61 6c 65 73 20 49 | 4e 54 45 47 45 52 3b 0a |_sales I|NTEGER;.|
|00003920| 42 45 47 49 4e 0a 20 61 | 6e 79 5f 73 61 6c 65 73 |BEGIN. a|ny_sales|
|00003930| 20 3d 20 30 3b 0a 0a 20 | 2f 2a 0a 20 20 2a 20 49 | = 0;.. |/*.  * I|
|00003940| 66 20 74 68 65 72 65 20 | 61 72 65 20 61 6e 79 20 |f there |are any |
|00003950| 73 61 6c 65 73 20 72 65 | 63 6f 72 64 73 20 72 65 |sales re|cords re|
|00003960| 66 65 72 65 6e 63 69 6e | 67 20 74 68 69 73 20 65 |ferencin|g this e|
|00003970| 6d 70 6c 6f 79 65 65 2c | 0a 20 20 2a 20 63 61 6e |mployee,|.  * can|
|00003980| 27 74 20 64 65 6c 65 74 | 65 20 74 68 65 20 65 6d |'t delet|e the em|
|00003990| 70 6c 6f 79 65 65 20 75 | 6e 74 69 6c 20 74 68 65 |ployee u|ntil the|
|000039a0| 20 73 61 6c 65 73 20 61 | 72 65 20 72 65 2d 61 73 | sales a|re re-as|
|000039b0| 73 69 67 6e 65 64 0a 20 | 20 2a 20 74 6f 20 61 6e |signed. | * to an|
|000039c0| 6f 74 68 65 72 20 65 6d | 70 6c 6f 79 65 65 20 6f |other em|ployee o|
|000039d0| 72 20 63 68 61 6e 67 65 | 64 20 74 6f 20 4e 55 4c |r change|d to NUL|
|000039e0| 4c 2e 0a 20 20 2a 2f 0a | 20 53 45 4c 45 43 54 20 |L..  */.| SELECT |
|000039f0| 63 6f 75 6e 74 28 70 6f | 5f 6e 75 6d 62 65 72 29 |count(po|_number)|
|00003a00| 0a 20 46 52 4f 4d 20 73 | 61 6c 65 73 0a 20 57 48 |. FROM s|ales. WH|
|00003a10| 45 52 45 20 73 61 6c 65 | 73 5f 72 65 70 20 3d 20 |ERE sale|s_rep = |
|00003a20| 3a 65 6d 70 5f 6e 75 6d | 0a 20 49 4e 54 4f 20 3a |:emp_num|. INTO :|
|00003a30| 61 6e 79 5f 73 61 6c 65 | 73 3b 0a 0a 20 49 46 20 |any_sale|s;.. IF |
|00003a40| 28 61 6e 79 5f 73 61 6c | 65 73 20 3e 20 30 29 20 |(any_sal|es > 0) |
|00003a50| 54 48 45 4e 0a 20 42 45 | 47 49 4e 0a 20 20 45 58 |THEN. BE|GIN.  EX|
|00003a60| 43 45 50 54 49 4f 4e 20 | 72 65 61 73 73 69 67 6e |CEPTION |reassign|
|00003a70| 5f 73 61 6c 65 73 3b 0a | 20 20 53 55 53 50 45 4e |_sales;.|  SUSPEN|
|00003a80| 44 3b 0a 20 45 4e 44 0a | 0a 20 2f 2a 0a 20 20 2a |D;. END.|. /*.  *|
|00003a90| 20 49 66 20 74 68 65 20 | 65 6d 70 6c 6f 79 65 65 | If the |employee|
|00003aa0| 20 69 73 20 61 20 6d 61 | 6e 61 67 65 72 2c 20 75 | is a ma|nager, u|
|00003ab0| 70 64 61 74 65 20 74 68 | 65 20 64 65 70 61 72 74 |pdate th|e depart|
|00003ac0| 6d 65 6e 74 2e 0a 20 20 | 2a 2f 0a 20 55 50 44 41 |ment..  |*/. UPDA|
|00003ad0| 54 45 20 64 65 70 61 72 | 74 6d 65 6e 74 0a 20 53 |TE depar|tment. S|
|00003ae0| 45 54 20 6d 6e 67 72 5f | 6e 6f 20 3d 20 4e 55 4c |ET mngr_|no = NUL|
|00003af0| 4c 0a 20 57 48 45 52 45 | 20 6d 00 6e 67 72 5f 6e |L. WHERE| m.ngr_n|
|00003b00| 6f 20 3d 20 3a 65 6d 70 | 5f 6e 75 6d 3b 0a 0a 20 |o = :emp|_num;.. |
|00003b10| 2f 2a 0a 20 20 2a 20 49 | 66 20 74 68 65 20 65 6d |/*.  * I|f the em|
|00003b20| 70 6c 6f 79 65 65 20 69 | 73 20 61 20 70 72 6f 6a |ployee i|s a proj|
|00003b30| 65 63 74 20 6c 65 61 64 | 65 72 2c 20 75 70 64 61 |ect lead|er, upda|
|00003b40| 74 65 20 70 72 6f 6a 65 | 63 74 2e 0a 20 20 2a 2f |te proje|ct..  */|
|00003b50| 0a 20 55 50 44 41 54 45 | 20 70 72 6f 6a 65 63 74 |. UPDATE| project|
|00003b60| 0a 20 53 45 54 20 74 65 | 61 6d 5f 6c 65 61 64 65 |. SET te|am_leade|
|00003b70| 72 20 3d 20 4e 55 4c 4c | 0a 20 57 48 45 52 45 20 |r = NULL|. WHERE |
|00003b80| 74 65 61 6d 5f 6c 65 61 | 64 65 72 20 3d 20 3a 65 |team_lea|der = :e|
|00003b90| 6d 70 5f 6e 75 6d 3b 0a | 0a 20 2f 2a 0a 20 20 2a |mp_num;.|. /*.  *|
|00003ba0| 20 44 65 6c 65 74 65 20 | 74 68 65 20 65 6d 70 6c | Delete |the empl|
|00003bb0| 6f 79 65 65 20 66 72 6f | 6d 20 61 6e 79 20 70 72 |oyee fro|m any pr|
|00003bc0| 6f 6a 65 63 74 73 2e 0a | 20 20 2a 2f 0a 20 44 45 |ojects..|  */. DE|
|00003bd0| 4c 45 54 45 20 46 52 4f | 4d 20 65 6d 70 6c 6f 79 |LETE FRO|M employ|
|00003be0| 65 65 5f 70 72 6f 6a 65 | 63 74 0a 20 57 48 45 52 |ee_proje|ct. WHER|
|00003bf0| 45 20 65 6d 70 5f 6e 6f | 20 3d 20 3a 65 6d 70 5f |E emp_no| = :emp_|
|00003c00| 6e 75 6d 3b 0a 0a 20 2f | 2a 0a 20 20 2a 20 44 65 |num;.. /|*.  * De|
|00003c10| 6c 65 74 65 20 6f 6c 64 | 20 73 61 6c 61 72 79 20 |lete old| salary |
|00003c20| 72 65 63 6f 72 64 73 2e | 0a 20 20 2a 2f 0a 20 44 |records.|.  */. D|
|00003c30| 45 4c 45 54 45 20 46 52 | 4f 4d 20 73 61 6c 61 72 |ELETE FR|OM salar|
|00003c40| 79 5f 68 69 73 74 6f 72 | 79 0a 20 57 48 45 52 45 |y_histor|y. WHERE|
|00003c50| 20 65 6d 70 5f 6e 6f 20 | 3d 20 3a 65 6d 70 5f 6e | emp_no |= :emp_n|
|00003c60| 75 6d 3b 0a 0a 20 2f 2a | 0a 20 20 2a 20 44 65 6c |um;.. /*|.  * Del|
|00003c70| 65 74 65 20 74 68 65 20 | 65 6d 70 6c 6f 79 65 65 |ete the |employee|
|00003c80| 2e 0a 20 20 2a 2f 0a 20 | 44 45 4c 45 54 45 20 46 |..  */. |DELETE F|
|00003c90| 52 4f 4d 20 65 6d 70 6c | 6f 79 65 65 0a 20 57 48 |ROM empl|oyee. WH|
|00003ca0| 45 52 45 20 65 6d 70 5f | 6e 6f 20 3d 20 3a 65 6d |ERE emp_|no = :em|
|00003cb0| 70 5f 6e 75 6d 3b 0a 0a | 20 53 55 53 50 45 4e 44 |p_num;..| SUSPEND|
|00003cc0| 3b 0a 45 4e 44 00 08 04 | a9 01 00 00 04 02 04 00 |;.END...|........|
|00003cd0| 02 00 08 00 07 00 04 01 | 01 00 07 00 0c 00 02 03 |........|........|
|00003ce0| 00 00 08 00 01 2d 1a 00 | 00 9b 11 00 02 02 01 15 |.....-..|........|
|00003cf0| 08 00 00 00 00 00 1a 00 | 00 07 7f 43 01 4f 01 43 |........|...C.O.C|
|00003d00| 01 4a 05 53 41 4c 45 53 | 00 47 2f 17 00 09 53 41 |.J.SALES|.G/...SA|
|00003d10| 4c 45 53 5f 52 45 50 29 | 00 00 00 01 00 ff 4e 00 |LES_REP)|......N.|
|00003d20| 4d 01 00 00 00 5d 17 00 | 09 50 4f 5f 4e 55 4d 42 |M....]..|.PO_NUMB|
|00003d30| 45 52 ff 02 01 18 01 00 | 00 1a 00 00 ff 08 31 1a |ER......|......1.|
|00003d40| 00 00 15 08 00 00 00 00 | 00 02 02 80 02 0e 52 45 |........|......RE|
|00003d50| 41 53 53 49 47 4e 5f 53 | 41 4c 45 53 02 0e 01 02 |ASSIGN_S|ALES....|
|00003d60| 01 15 07 00 01 00 19 01 | 00 00 ff 9b ff ff ff ff |........|........|
|00003d70| 07 43 01 4a 0a 44 45 50 | 41 52 54 4d 45 4e 54 02 |.C.J.DEP|ARTMENT.|
|00003d80| 47 2f 17 02 07 4d 4e 47 | 52 5f 4e 4f 29 00 00 00 |G/...MNG|R_NO)...|
|00003d90| 01 00 ff 0a 02 02 02 01 | 2d 17 02 07 4d 4e 47 52 |........|-...MNGR|
|00003da0| 5f 4e 4f ff 07 43 01 4a | 07 50 52 4f 4a 45 43 54 |_NO..C.J|.PROJECT|
|00003db0| 03 47 2f 17 03 0b 54 45 | 41 4d 5f 4c 45 41 44 45 |.G/...TE|AM_LEADE|
|00003dc0| 52 29 00 00 00 01 00 ff | 0a 03 03 02 01 2d 17 03 |R)......|.....-..|
|00003dd0| 0b 54 45 41 4d 5f 4c 45 | 41 44 45 52 ff 07 43 01 |.TEAM_LE|ADER..C.|
|00003de0| 4a 10 45 4d 50 4c 4f 59 | 45 45 5f 50 52 4f 4a 45 |J.EMPLOY|EE_PROJE|
|00003df0| 43 54 04 47 2f 17 04 06 | 45 4d 50 5f 4e 4f 29 00 |CT.G/...|EMP_NO).|
|00003e00| 00 00 01 00 ff 05 04 07 | 43 01 4a 0e 53 41 4c 41 |........|C.J.SALA|
|00003e10| 52 59 5f 48 49 53 54 4f | 52 59 05 47 2f 17 05 06 |RY_HISTO|RY.G/...|
|00003e20| 45 4d 50 5f 4e 4f 29 00 | 00 00 01 00 ff 05 05 07 |EMP_NO).|........|
|00003e30| 43 01 4a 08 45 4d 50 4c | 4f 59 45 45 06 47 2f 17 |C.J.EMPL|OYEE.G/.|
|00003e40| 06 06 45 4d 50 5f 4e 4f | 29 00 00 00 01 00 ff 05 |..EMP_NO|).......|
|00003e50| 06 02 0e 01 02 01 15 07 | 00 01 00 19 01 00 00 ff |........|........|
|00003e60| 9b ff ff ff ff 0e 01 02 | 01 15 07 00 00 00 19 01 |........|........|
|00003e70| 00 00 ff ff 4c 09 13 53 | 51 4c 24 44 45 4c 45 54 |....L..S|QL$DELET|
|00003e80| 45 5f 45 4d 50 4c 4f 59 | 45 45 0a 07 42 55 49 4c |E_EMPLOY|EE..BUIL|
|00003e90| 44 45 52 00 1c 01 07 45 | 4d 50 5f 4e 55 4d 02 04 |DER....E|MP_NUM..|
|00003ea0| 00 00 00 00 03 04 00 00 | 00 00 04 06 52 44 42 24 |........|....RDB$|
|00003eb0| 34 31 00 1d 1b 01 0b 44 | 45 50 54 5f 42 55 44 47 |41.....D|EPT_BUDG|
|00003ec0| 45 54 02 04 01 00 00 00 | 03 04 01 00 00 00 07 04 |ET......|........|
|00003ed0| e1 01 00 00 0a 20 44 45 | 43 4c 41 52 45 20 56 41 |..... DE|CLARE VA|
|00003ee0| 52 49 41 42 4c 45 20 73 | 75 6d 62 20 44 45 43 49 |RIABLE s|umb DECI|
|00003ef0| 4d 41 4c 28 31 32 2c 20 | 32 29 3b 0a 20 44 45 43 |MAL(12, |2);. DEC|
|00003f00| 4c 41 52 45 20 56 41 52 | 49 41 42 4c 45 20 72 64 |LARE VAR|IABLE rd|
|00003f10| 6e 6f 20 43 48 41 52 28 | 33 29 3b 0a 20 44 45 43 |no CHAR(|3);. DEC|
|00003f20| 4c 41 52 45 20 56 41 52 | 49 41 42 4c 45 20 63 6e |LARE VAR|IABLE cn|
|00003f30| 74 20 49 4e 54 45 47 45 | 52 3b 0a 42 45 47 49 4e |t INTEGE|R;.BEGIN|
|00003f40| 0a 20 74 6f 74 20 3d 20 | 30 3b 0a 0a 20 53 45 4c |. tot = |0;.. SEL|
|00003f50| 45 43 54 20 62 75 64 67 | 65 74 20 46 52 4f 4d 20 |ECT budg|et FROM |
|00003f60| 64 65 70 61 72 74 6d 65 | 6e 74 20 57 48 45 52 45 |departme|nt WHERE|
|00003f70| 20 64 65 70 74 5f 6e 6f | 20 3d 20 3a 64 6e 6f 20 | dept_no| = :dno |
|00003f80| 49 4e 54 4f 20 3a 74 6f | 74 3b 0a 0a 20 53 45 4c |INTO :to|t;.. SEL|
|00003f90| 45 43 54 20 63 6f 75 6e | 74 28 62 75 64 67 65 74 |ECT coun|t(budget|
|00003fa0| 29 20 46 52 4f 4d 20 64 | 65 70 61 72 74 6d 65 6e |) FROM d|epartmen|
|00003fb0| 74 20 57 48 45 52 45 20 | 68 65 61 64 5f 64 65 70 |t WHERE |head_dep|
|00003fc0| 74 20 3d 20 3a 64 6e 6f | 20 49 4e 54 4f 20 3a 63 |t = :dno| INTO :c|
|00003fd0| 6e 74 3b 0a 0a 20 49 46 | 20 28 63 6e 74 20 3d 20 |nt;.. IF| (cnt = |
|00003fe0| 30 29 20 54 48 45 4e 0a | 20 20 53 55 53 50 45 4e |0) THEN.|  SUSPEN|
|00003ff0| 44 3b 0a 0a 20 46 4f 52 | 20 53 45 4c 45 43 54 20 |D;.. FOR| SELECT |
|00004000| 64 65 70 74 5f 6e 6f 0a | 20 20 46 52 4f 4d 20 64 |dept_no.|  FROM d|
|00004010| 65 70 61 72 74 6d 65 6e | 74 0a 20 20 57 48 45 52 |epartmen|t.  WHER|
|00004020| 45 20 68 65 61 64 5f 64 | 65 70 74 20 3d 20 3a 64 |E head_d|ept = :d|
|00004030| 6e 6f 0a 20 20 49 4e 54 | 4f 20 3a 72 64 6e 6f 0a |no.  INT|O :rdno.|
|00004040| 20 44 4f 0a 20 20 42 45 | 47 49 4e 0a 20 20 20 45 | DO.  BE|GIN.   E|
|00004050| 58 45 43 55 54 45 20 50 | 52 4f 43 45 44 55 52 45 |XECUTE P|ROCEDURE|
|00004060| 20 64 65 70 74 5f 62 75 | 64 67 65 74 20 3a 72 64 | dept_bu|dget :rd|
|00004070| 6e 6f 20 52 45 54 55 52 | 4e 49 4e 47 5f 56 41 4c |no RETUR|NING_VAL|
|00004080| 55 45 53 20 3a 73 75 6d | 62 3b 0a 20 20 20 74 6f |UES :sum|b;.   to|
|00004090| 74 20 3d 20 74 6f 74 20 | 2b 20 73 75 6d 62 3b 0a |t = tot |+ sumb;.|
|000040a0| 20 20 45 4e 44 0a 0a 20 | 53 55 53 50 45 4e 44 3b |  END.. |SUSPEND;|
|000040b0| 0a 45 4e 44 00 08 04 86 | 01 00 00 04 02 04 00 02 |.END....|........|
|000040c0| 00 0f 15 00 03 00 07 00 | 04 01 03 00 1b 07 00 07 |........|........|
|000040d0| 00 0c 00 02 03 00 00 1b | 01 2d 1a 00 00 03 01 00 |........|.-......|
|000040e0| 1b 01 2d 1a 01 00 03 02 | 00 0f 15 00 03 00 01 2d |..-.....|.......-|
|000040f0| 1a 02 00 03 03 00 08 00 | 01 2d 1a 03 00 9b 11 00 |........|.-......|
|00004100| 02 02 01 15 08 00 00 00 | 00 00 1a 00 00 07 7f 43 |........|.......C|
|00004110| 01 4a 0a 44 45 50 41 52 | 54 4d 45 4e 54 00 47 2f |.J.DEPAR|TMENT.G/|
|00004120| 17 00 07 44 45 50 54 5f | 4e 4f 29 00 00 00 01 00 |...DEPT_|NO).....|
|00004130| ff 02 01 17 00 06 42 55 | 44 47 45 54 1a 00 00 ff |......BU|DGET....|
|00004140| 07 7f 43 01 4f 02 43 01 | 4a 0a 44 45 50 41 52 54 |..C.O.C.|J.DEPART|
|00004150| 4d 45 4e 54 01 47 2f 17 | 01 09 48 45 41 44 5f 44 |MENT.G/.|..HEAD_D|
|00004160| 45 50 54 29 00 00 00 01 | 00 ff 4e 00 4d 01 00 00 |EPT)....|..N.M...|
|00004170| 00 5d 17 01 06 42 55 44 | 47 45 54 ff 02 01 18 02 |.]...BUD|GET.....|
|00004180| 00 00 1a 03 00 ff 08 2f | 1a 03 00 15 08 00 00 00 |......./|........|
|00004190| 00 00 02 0e 01 02 01 1a | 00 00 29 01 00 00 01 00 |........|..).....|
|000041a0| 01 15 07 00 01 00 19 01 | 02 00 ff 9b ff ff 07 43 |........|.......C|
|000041b0| 01 4a 0a 44 45 50 41 52 | 54 4d 45 4e 54 03 47 2f |.J.DEPAR|TMENT.G/|
|000041c0| 17 03 09 48 45 41 44 5f | 44 45 50 54 29 00 00 00 |...HEAD_|DEPT)...|
|000041d0| 01 00 ff 02 01 17 03 07 | 44 45 50 54 5f 4e 4f 1a |........|DEPT_NO.|
|000041e0| 02 00 02 02 78 0b 44 45 | 50 54 5f 42 55 44 47 45 |....x.DE|PT_BUDGE|
|000041f0| 54 01 00 1a 02 00 01 00 | 1a 01 00 01 22 1a 00 00 |T.......|...."...|
|00004200| 1a 01 00 1a 00 00 ff ff | ff 02 0e 01 02 01 1a 00 |........|........|
|00004210| 00 29 01 00 00 01 00 01 | 15 07 00 01 00 19 01 02 |.)......|........|
|00004220| 00 ff 9b ff ff ff ff 0e | 01 02 01 1a 00 00 29 01 |........|......).|
|00004230| 00 00 01 00 01 15 07 00 | 00 00 19 01 02 00 ff ff |........|........|
|00004240| 4c 09 0f 53 51 4c 24 44 | 45 50 54 5f 42 55 44 47 |L..SQL$D|EPT_BUDG|
|00004250| 45 54 0a 07 42 55 49 4c | 44 45 52 00 1c 01 03 44 |ET..BUIL|DER....D|
|00004260| 4e 4f 02 04 00 00 00 00 | 03 04 00 00 00 00 04 06 |NO......|........|
|00004270| 52 44 42 24 34 32 00 1c | 01 03 54 4f 54 02 04 00 |RDB$42..|..TOT...|
|00004280| 00 00 00 03 04 01 00 00 | 00 04 06 52 44 42 24 34 |........|...RDB$4|
|00004290| 33 00 1d 1b 01 09 4f 52 | 47 5f 43 48 41 52 54 02 |3.....OR|G_CHART.|
|000042a0| 04 00 00 00 00 03 04 05 | 00 00 00 07 04 4b 02 00 |........|.....K..|
|000042b0| 00 0a 20 44 45 43 4c 41 | 52 45 20 56 41 52 49 41 |.. DECLA|RE VARIA|
|000042c0| 42 4c 45 20 6d 6e 67 72 | 5f 6e 6f 20 49 4e 54 45 |BLE mngr|_no INTE|
|000042d0| 47 45 52 3b 0a 20 44 45 | 43 4c 41 52 45 20 56 41 |GER;. DE|CLARE VA|
|000042e0| 52 49 41 42 4c 45 20 64 | 6e 6f 20 43 48 41 52 28 |RIABLE d|no CHAR(|
|000042f0| 33 29 3b 0a 42 45 47 49 | 4e 0a 20 46 4f 52 20 53 |3);.BEGI|N. FOR S|
|00004300| 45 4c 45 43 54 20 68 2e | 64 65 70 61 72 74 6d 65 |ELECT h.|departme|
|00004310| 6e 74 2c 20 64 2e 64 65 | 70 61 72 74 6d 65 6e 74 |nt, d.de|partment|
|00004320| 2c 20 64 2e 6d 6e 67 72 | 5f 6e 6f 2c 20 64 2e 64 |, d.mngr|_no, d.d|
|00004330| 65 70 74 5f 6e 6f 0a 20 | 20 46 52 4f 4d 20 64 65 |ept_no. | FROM de|
|00004340| 70 61 72 74 6d 65 6e 74 | 20 64 0a 20 20 4c 45 46 |partment| d.  LEF|
|00004350| 54 20 4f 55 54 45 52 20 | 4a 4f 49 4e 20 64 65 70 |T OUTER |JOIN dep|
|00004360| 61 72 74 6d 65 6e 74 20 | 68 20 4f 4e 20 64 2e 68 |artment |h ON d.h|
|00004370| 65 61 64 5f 64 65 70 74 | 20 3d 20 68 2e 64 65 70 |ead_dept| = h.dep|
|00004380| 74 5f 6e 6f 0a 20 20 4f | 52 44 45 52 20 42 59 20 |t_no.  O|RDER BY |
|00004390| 64 2e 64 65 70 74 5f 6e | 6f 0a 20 20 49 4e 54 4f |d.dept_n|o.  INTO|
|000043a0| 20 3a 68 65 61 64 5f 64 | 65 70 74 2c 20 3a 64 65 | :head_d|ept, :de|
|000043b0| 70 61 72 74 6d 65 6e 74 | 2c 20 3a 6d 6e 67 72 5f |partment|, :mngr_|
|000043c0| 6e 6f 2c 20 3a 64 6e 6f | 0a 20 44 4f 0a 20 42 45 |no, :dno|. DO. BE|
|000043d0| 47 49 4e 0a 20 20 49 46 | 20 28 3a 6d 6e 67 72 5f |GIN.  IF| (:mngr_|
|000043e0| 6e 6f 20 49 53 20 4e 55 | 4c 4c 29 20 54 48 45 4e |no IS NU|LL) THEN|
|000043f0| 0a 20 20 42 45 47 49 4e | 0a 20 20 20 6d 6e 67 72 |.  BEGIN|.   mngr|
|00004400| 5f 6e 61 6d 65 20 3d 20 | 27 2d 2d 54 42 48 2d 2d |_name = |'--TBH--|
|00004410| 27 3b 0a 20 20 20 74 69 | 74 6c 65 20 3d 20 27 27 |';.   ti|tle = ''|
|00004420| 3b 0a 20 20 45 4e 44 0a | 0a 20 20 45 4c 53 45 0a |;.  END.|.  ELSE.|
|00004430| 20 20 20 53 45 4c 45 43 | 54 20 66 75 6c 6c 5f 6e |   SELEC|T full_n|
|00004440| 61 6d 65 2c 20 6a 6f 62 | 5f 63 6f 64 65 0a 20 20 |ame, job|_code.  |
|00004450| 20 46 52 4f 4d 20 65 6d | 70 6c 6f 79 65 65 0a 20 | FROM em|ployee. |
|00004460| 20 20 57 48 45 52 45 20 | 65 6d 70 5f 6e 6f 20 3d |  WHERE |emp_no =|
|00004470| 20 3a 6d 6e 67 72 5f 6e | 6f 0a 20 20 20 49 4e 54 | :mngr_n|o.   INT|
|00004480| 4f 20 3a 6d 6e 67 72 5f | 6e 61 6d 65 2c 20 3a 74 |O :mngr_|name, :t|
|00004490| 69 74 6c 65 3b 0a 0a 20 | 20 53 45 4c 45 43 54 20 |itle;.. | SELECT |
|000044a0| 43 4f 55 4e 54 28 65 6d | 70 5f 6e 6f 29 0a 20 20 |COUNT(em|p_no).  |
|000044b0| 46 00 52 4f 4d 20 65 6d | 70 6c 6f 79 65 65 0a 20 |F.ROM em|ployee. |
|000044c0| 20 57 48 45 52 45 20 64 | 65 70 74 5f 6e 6f 20 3d | WHERE d|ept_no =|
|000044d0| 20 3a 64 6e 6f 0a 20 20 | 49 4e 54 4f 20 3a 65 6d | :dno.  |INTO :em|
|000044e0| 70 5f 63 6e 74 3b 0a 0a | 20 20 53 55 53 50 45 4e |p_cnt;..|  SUSPEN|
|000044f0| 44 3b 0a 20 45 4e 44 0a | 45 4e 44 00 08 04 3d 02 |D;. END.|END...=.|
|00004500| 00 00 04 02 04 01 0b 00 | 0f 15 00 19 00 07 00 0f |........|........|
|00004510| 15 00 19 00 07 00 0f 15 | 00 14 00 07 00 0f 15 00 |........|........|
|00004520| 05 00 07 00 08 00 07 00 | 07 00 02 03 00 00 0f 15 |........|........|
|00004530| 00 19 00 01 2d 1a 00 00 | 03 01 00 0f 15 00 19 00 |....-...|........|
|00004540| 01 2d 1a 01 00 03 02 00 | 0f 15 00 14 00 01 2d 1a |.-......|......-.|
|00004550| 02 00 03 03 00 0f 15 00 | 05 00 01 2d 1a 03 00 03 |........|...-....|
|00004560| 04 00 08 00 01 2d 1a 04 | 00 03 05 00 08 00 01 2d |.....-..|.......-|
|00004570| 1a 05 00 03 06 00 0f 15 | 00 03 00 01 2d 1a 06 00 |........|....-...|
|00004580| 9b 11 00 02 02 07 43 01 | 77 02 92 0a 44 45 50 41 |......C.|w...DEPA|
|00004590| 52 54 4d 45 4e 54 01 44 | 00 92 0a 44 45 50 41 52 |RTMENT.D|...DEPAR|
|000045a0| 54 4d 45 4e 54 01 48 01 | 50 01 47 2f 17 00 09 48 |TMENT.H.|P.G/...H|
|000045b0| 45 41 44 5f 44 45 50 54 | 17 01 07 44 45 50 54 5f |EAD_DEPT|...DEPT_|
|000045c0| 4e 4f ff 46 01 48 17 00 | 07 44 45 50 54 5f 4e 4f |NO.F.H..|.DEPT_NO|
|000045d0| ff 02 01 17 01 0a 44 45 | 50 41 52 54 4d 45 4e 54 |......DE|PARTMENT|
|000045e0| 1a 00 00 01 17 00 0a 44 | 45 50 41 52 54 4d 45 4e |.......D|EPARTMEN|
|000045f0| 54 1a 01 00 01 17 00 07 | 4d 4e 47 52 5f 4e 4f 1a |T.......|MNGR_NO.|
|00004600| 05 00 01 17 00 07 44 45 | 50 54 5f 4e 4f 1a 06 00 |......DE|PT_NO...|
|00004610| 02 02 08 3d 1a 05 00 02 | 02 01 15 0f 7f 00 07 00 |...=....|........|
|00004620| 2d 2d 54 42 48 2d 2d 1a | 02 00 01 15 0f 7f 00 00 |--TBH--.|........|
|00004630| 00 1a 03 00 ff ff 07 7f | 43 01 4a 08 45 4d 50 4c |........|C.J.EMPL|
|00004640| 4f 59 45 45 02 47 2f 17 | 02 06 45 4d 50 5f 4e 4f |OYEE.G/.|..EMP_NO|
|00004650| 1a 05 00 ff 02 01 17 02 | 09 46 55 4c 4c 5f 4e 41 |........|.FULL_NA|
|00004660| 4d 45 1a 02 00 01 17 02 | 08 4a 4f 42 5f 43 4f 44 |ME......|.JOB_COD|
|00004670| 45 1a 03 00 ff 07 7f 43 | 01 4f 04 43 01 4a 08 45 |E......C|.O.C.J.E|
|00004680| 4d 50 4c 4f 59 45 45 03 | 47 2f 17 03 07 44 45 50 |MPLOYEE.|G/...DEP|
|00004690| 54 5f 4e 4f 1a 06 00 ff | 4e 00 4d 01 00 00 00 5d |T_NO....|N.M....]|
|000046a0| 17 03 06 45 4d 50 5f 4e | 4f ff 02 01 18 04 00 00 |...EMP_N|O.......|
|000046b0| 1a 04 00 ff 02 0e 01 02 | 01 1a 00 00 29 01 00 00 |........|....)...|
|000046c0| 01 00 01 1a 01 00 29 01 | 02 00 03 00 01 1a 02 00 |......).|........|
|000046d0| 29 01 04 00 05 00 01 1a | 03 00 29 01 06 00 07 00 |).......|..).....|
|000046e0| 01 1a 04 00 29 01 08 00 | 09 00 01 15 07 00 01 00 |....)...|........|
|000046f0| 19 01 0a 00 ff 9b ff ff | ff ff ff ff ff 0e 01 02 |........|........|
|00004700| 01 1a 00 00 29 01 00 00 | 01 00 01 1a 01 00 29 01 |....)...|......).|
|00004710| 02 00 03 00 01 1a 02 00 | 29 01 04 00 05 00 01 1a |........|).......|
|00004720| 03 00 29 01 06 00 07 00 | 01 1a 04 00 29 01 08 00 |..).....|....)...|
|00004730| 09 00 01 15 07 00 00 00 | 19 01 0a 00 ff ff 4c 09 |........|......L.|
|00004740| 0d 53 51 4c 24 4f 52 47 | 5f 43 48 41 52 54 0a 07 |.SQL$ORG|_CHART..|
|00004750| 42 55 49 4c 44 45 52 00 | 1c 01 09 48 45 41 44 5f |BUILDER.|...HEAD_|
|00004760| 44 45 50 54 02 04 00 00 | 00 00 03 04 01 00 00 00 |DEPT....|........|
|00004770| 04 06 52 44 42 24 34 34 | 00 1c 01 0a 44 45 50 41 |..RDB$44|....DEPA|
|00004780| 52 54 4d 45 4e 54 02 04 | 01 00 00 00 03 04 01 00 |RTMENT..|........|
|00004790| 00 00 04 06 52 44 42 24 | 34 35 00 1c 01 09 4d 4e |....RDB$|45....MN|
|000047a0| 47 52 5f 4e 41 4d 45 02 | 04 02 00 00 00 03 04 01 |GR_NAME.|........|
|000047b0| 00 00 00 04 06 52 44 42 | 24 34 36 00 1c 01 05 54 |.....RDB|$46....T|
|000047c0| 49 54 4c 45 02 04 03 00 | 00 00 03 04 01 00 00 00 |ITLE....|........|
|000047d0| 04 06 52 44 42 24 34 37 | 00 1c 01 07 45 4d 50 5f |..RDB$47|....EMP_|
|000047e0| 43 4e 54 02 04 04 00 00 | 00 03 04 01 00 00 00 04 |CNT.....|........|
|000047f0| 06 52 44 42 24 34 38 00 | 1d 1b 01 0a 4d 41 49 4c |.RDB$48.|....MAIL|
|00004800| 5f 4c 41 42 45 4c 02 04 | 01 00 00 00 03 04 06 00 |_LABEL..|........|
|00004810| 00 00 07 04 f8 04 00 00 | 0a 20 44 45 43 4c 41 52 |........|. DECLAR|
|00004820| 45 20 56 41 52 49 41 42 | 4c 45 20 63 75 73 74 6f |E VARIAB|LE custo|
|00004830| 6d 65 72 20 56 41 52 43 | 48 41 52 28 32 35 29 3b |mer VARC|HAR(25);|
|00004840| 0a 20 44 45 43 4c 41 52 | 45 20 56 41 52 49 41 42 |. DECLAR|E VARIAB|
|00004850| 4c 45 20 66 69 72 73 74 | 20 20 56 41 52 43 48 41 |LE first|  VARCHA|
|00004860| 52 28 31 35 29 3b 0a 20 | 44 45 43 4c 41 52 45 20 |R(15);. |DECLARE |
|00004870| 56 41 52 49 41 42 4c 45 | 20 6c 61 73 74 20 20 56 |VARIABLE| last  V|
|00004880| 41 52 43 48 41 52 28 32 | 30 29 3b 0a 20 44 45 43 |ARCHAR(2|0);. DEC|
|00004890| 4c 41 52 45 20 56 41 52 | 49 41 42 4c 45 20 61 64 |LARE VAR|IABLE ad|
|000048a0| 64 72 31 20 20 56 41 52 | 43 48 41 52 28 33 30 29 |dr1  VAR|CHAR(30)|
|000048b0| 3b 0a 20 44 45 43 4c 41 | 52 45 20 56 41 52 49 41 |;. DECLA|RE VARIA|
|000048c0| 42 4c 45 20 61 64 64 72 | 32 20 20 56 41 52 43 48 |BLE addr|2  VARCH|
|000048d0| 41 52 28 33 30 29 3b 0a | 20 44 45 43 4c 41 52 45 |AR(30);.| DECLARE|
|000048e0| 20 56 41 52 49 41 42 4c | 45 20 63 69 74 79 20 20 | VARIABL|E city  |
|000048f0| 56 41 52 43 48 41 52 28 | 32 35 29 3b 0a 20 44 45 |VARCHAR(|25);. DE|
|00004900| 43 4c 41 52 45 20 56 41 | 52 49 41 42 4c 45 20 73 |CLARE VA|RIABLE s|
|00004910| 74 61 74 65 20 20 56 41 | 52 43 48 41 52 28 31 35 |tate  VA|RCHAR(15|
|00004920| 29 3b 0a 20 44 45 43 4c | 41 52 45 20 56 41 52 49 |);. DECL|ARE VARI|
|00004930| 41 42 4c 45 20 63 6f 75 | 6e 74 72 79 20 56 41 52 |ABLE cou|ntry VAR|
|00004940| 43 48 41 52 28 31 35 29 | 3b 0a 20 44 45 43 4c 41 |CHAR(15)|;. DECLA|
|00004950| 52 45 20 56 41 52 49 41 | 42 4c 45 20 70 6f 73 74 |RE VARIA|BLE post|
|00004960| 63 6f 64 65 20 56 41 52 | 43 48 41 52 28 31 32 29 |code VAR|CHAR(12)|
|00004970| 3b 0a 20 44 45 43 4c 41 | 52 45 20 56 41 52 49 41 |;. DECLA|RE VARIA|
|00004980| 42 4c 45 20 63 6e 74 20 | 20 49 4e 54 45 47 45 52 |BLE cnt | INTEGER|
|00004990| 3b 0a 42 45 47 49 4e 0a | 20 6c 69 6e 65 31 20 3d |;.BEGIN.| line1 =|
|000049a0| 20 27 27 3b 0a 20 6c 69 | 6e 65 32 20 3d 20 27 27 | '';. li|ne2 = ''|
|000049b0| 3b 0a 20 6c 69 6e 65 33 | 20 3d 20 27 27 3b 0a 20 |;. line3| = '';. |
|000049c0| 6c 69 6e 65 34 20 3d 20 | 27 27 3b 0a 20 6c 69 6e |line4 = |'';. lin|
|000049d0| 65 35 20 3d 20 27 27 3b | 0a 20 6c 69 6e 65 36 20 |e5 = '';|. line6 |
|000049e0| 3d 20 27 27 3b 0a 0a 20 | 53 45 4c 45 43 54 20 63 |= '';.. |SELECT c|
|000049f0| 75 73 74 6f 6d 65 72 2c | 20 63 6f 6e 74 61 63 74 |ustomer,| contact|
|00004a00| 5f 66 69 72 73 74 2c 20 | 63 6f 6e 74 61 63 74 5f |_first, |contact_|
|00004a10| 6c 61 73 74 2c 20 61 64 | 00 64 72 65 73 73 5f 6c |last, ad|.dress_l|
|00004a20| 69 6e 65 31 2c 0a 20 20 | 61 64 64 72 65 73 73 5f |ine1,.  |address_|
|00004a30| 6c 69 6e 65 32 2c 20 63 | 69 74 79 2c 20 73 74 61 |line2, c|ity, sta|
|00004a40| 74 65 5f 70 72 6f 76 69 | 6e 63 65 2c 20 63 6f 75 |te_provi|nce, cou|
|00004a50| 6e 74 72 79 2c 20 70 6f | 73 74 61 6c 5f 63 6f 64 |ntry, po|stal_cod|
|00004a60| 65 0a 20 46 52 4f 4d 20 | 43 55 53 54 4f 4d 45 52 |e. FROM |CUSTOMER|
|00004a70| 0a 20 57 48 45 52 45 20 | 63 75 73 74 5f 6e 6f 20 |. WHERE |cust_no |
|00004a80| 3d 20 3a 63 75 73 74 5f | 6e 6f 0a 20 49 4e 54 4f |= :cust_|no. INTO|
|00004a90| 20 3a 63 75 73 74 6f 6d | 65 72 2c 20 3a 66 69 72 | :custom|er, :fir|
|00004aa0| 73 74 2c 20 3a 6c 61 73 | 74 2c 20 3a 61 64 64 72 |st, :las|t, :addr|
|00004ab0| 31 2c 20 3a 61 64 64 72 | 32 2c 0a 20 20 3a 63 69 |1, :addr|2,.  :ci|
|00004ac0| 74 79 2c 20 3a 73 74 61 | 74 65 2c 20 3a 63 6f 75 |ty, :sta|te, :cou|
|00004ad0| 6e 74 72 79 2c 20 3a 70 | 6f 73 74 63 6f 64 65 3b |ntry, :p|ostcode;|
|00004ae0| 0a 0a 20 49 46 20 28 63 | 75 73 74 6f 6d 65 72 20 |.. IF (c|ustomer |
|00004af0| 49 53 20 4e 4f 54 20 4e | 55 4c 4c 29 20 54 48 45 |IS NOT N|ULL) THE|
|00004b00| 4e 0a 20 20 6c 69 6e 65 | 31 20 3d 20 63 75 73 74 |N.  line|1 = cust|
|00004b10| 6f 6d 65 72 3b 0a 20 49 | 46 20 28 66 69 72 73 74 |omer;. I|F (first|
|00004b20| 20 49 53 20 4e 4f 54 20 | 4e 55 4c 4c 29 20 54 48 | IS NOT |NULL) TH|
|00004b30| 45 4e 0a 20 20 6c 69 6e | 65 32 20 3d 20 66 69 72 |EN.  lin|e2 = fir|
|00004b40| 73 74 20 7c 7c 20 27 20 | 27 20 7c 7c 20 6c 61 73 |st || ' |' || las|
|00004b50| 74 3b 0a 20 45 4c 53 45 | 0a 20 20 6c 69 6e 65 32 |t;. ELSE|.  line2|
|00004b60| 20 3d 20 6c 61 73 74 3b | 0a 20 49 46 20 28 61 64 | = last;|. IF (ad|
|00004b70| 64 72 31 20 49 53 20 4e | 4f 54 20 4e 55 4c 4c 29 |dr1 IS N|OT NULL)|
|00004b80| 20 54 48 45 4e 0a 20 20 | 6c 69 6e 65 33 20 3d 20 | THEN.  |line3 = |
|00004b90| 61 64 64 72 31 3b 0a 20 | 49 46 20 28 61 64 64 72 |addr1;. |IF (addr|
|00004ba0| 32 20 49 53 20 4e 4f 54 | 20 4e 55 4c 4c 29 20 54 |2 IS NOT| NULL) T|
|00004bb0| 48 45 4e 0a 20 20 6c 69 | 6e 65 34 20 3d 20 61 64 |HEN.  li|ne4 = ad|
|00004bc0| 64 72 32 3b 0a 0a 20 49 | 46 20 28 63 6f 75 6e 74 |dr2;.. I|F (count|
|00004bd0| 72 79 20 3d 20 27 55 53 | 41 27 29 20 54 48 45 4e |ry = 'US|A') THEN|
|00004be0| 0a 20 42 45 47 49 4e 0a | 20 20 49 46 20 28 63 69 |. BEGIN.|  IF (ci|
|00004bf0| 74 79 20 49 53 20 4e 4f | 54 20 4e 55 4c 4c 29 20 |ty IS NO|T NULL) |
|00004c00| 54 48 45 4e 0a 20 20 20 | 6c 69 6e 65 35 20 3d 20 |THEN.   |line5 = |
|00004c10| 63 69 74 79 20 7c 7c 20 | 27 00 2c 20 27 20 7c 7c |city || |'., ' |||
|00004c20| 20 73 74 61 74 65 20 7c | 7c 20 27 20 20 27 20 7c | state ||| '  ' ||
|00004c30| 7c 20 70 6f 73 74 63 6f | 64 65 3b 0a 20 20 45 4c || postco|de;.  EL|
|00004c40| 53 45 0a 20 20 20 6c 69 | 6e 65 35 20 3d 20 73 74 |SE.   li|ne5 = st|
|00004c50| 61 74 65 20 7c 7c 20 27 | 20 20 27 20 7c 7c 20 70 |ate || '|  ' || p|
|00004c60| 6f 73 74 63 6f 64 65 3b | 0a 20 45 4e 44 0a 20 45 |ostcode;|. END. E|
|00004c70| 4c 53 45 0a 20 42 45 47 | 49 4e 0a 20 20 49 46 20 |LSE. BEG|IN.  IF |
|00004c80| 28 63 69 74 79 20 49 53 | 20 4e 4f 54 20 4e 55 4c |(city IS| NOT NUL|
|00004c90| 4c 29 20 54 48 45 4e 0a | 20 20 20 6c 69 6e 65 35 |L) THEN.|   line5|
|00004ca0| 20 3d 20 63 69 74 79 20 | 7c 7c 20 27 2c 20 27 20 | = city ||| ', ' |
|00004cb0| 7c 7c 20 73 74 61 74 65 | 3b 0a 20 20 45 4c 53 45 ||| state|;.  ELSE|
|00004cc0| 0a 20 20 20 6c 69 6e 65 | 35 20 3d 20 73 74 61 74 |.   line|5 = stat|
|00004cd0| 65 3b 0a 20 20 6c 69 6e | 65 36 20 3d 20 63 6f 75 |e;.  lin|e6 = cou|
|00004ce0| 6e 74 72 79 20 7c 7c 20 | 27 20 20 20 20 27 20 7c |ntry || |'    ' ||
|00004cf0| 7c 20 70 6f 73 74 63 6f | 64 65 3b 0a 20 45 4e 44 || postco|de;. END|
|00004d00| 0a 0a 20 53 55 53 50 45 | 4e 44 3b 0a 45 4e 44 00 |.. SUSPE|ND;.END.|
|00004d10| 08 04 7b 03 00 00 04 02 | 04 00 02 00 08 00 07 00 |..{.....|........|
|00004d20| 04 01 0d 00 0f 15 00 28 | 00 07 00 0f 15 00 28 00 |.......(|......(.|
|00004d30| 07 00 0f 15 00 28 00 07 | 00 0f 15 00 28 00 07 00 |.....(..|....(...|
|00004d40| 0f 15 00 28 00 07 00 0f | 15 00 28 00 07 00 07 00 |...(....|..(.....|
|00004d50| 0c 00 02 03 00 00 0f 15 | 00 28 00 01 2d 1a 00 00 |........|.(..-...|
|00004d60| 03 01 00 0f 15 00 28 00 | 01 2d 1a 01 00 03 02 00 |......(.|.-......|
|00004d70| 0f 15 00 28 00 01 2d 1a | 02 00 03 03 00 0f 15 00 |...(..-.|........|
|00004d80| 28 00 01 2d 1a 03 00 03 | 04 00 0f 15 00 28 00 01 |(..-....|.....(..|
|00004d90| 2d 1a 04 00 03 05 00 0f | 15 00 28 00 01 2d 1a 05 |-.......|..(..-..|
|00004da0| 00 03 06 00 26 15 00 19 | 00 01 2d 1a 06 00 03 07 |....&...|..-.....|
|00004db0| 00 26 15 00 0f 00 01 2d | 1a 07 00 03 08 00 26 15 |.&.....-|......&.|
|00004dc0| 00 14 00 01 2d 1a 08 00 | 03 09 00 26 15 00 1e 00 |....-...|...&....|
|00004dd0| 01 2d 1a 09 00 03 0a 00 | 26 15 00 1e 00 01 2d 1a |.-......|&.....-.|
|00004de0| 0a 00 03 0b 00 26 15 00 | 19 00 01 2d 1a 0b 00 03 |.....&..|...-....|
|00004df0| 0c 00 26 15 00 0f 00 01 | 2d 1a 0c 00 03 0d 00 26 |..&.....|-......&|
|00004e00| 15 00 0f 00 01 2d 1a 0d | 00 03 0e 00 26 15 00 0c |.....-..|....&...|
|00004e10| 00 01 2d 1a 0e 00 03 0f | 00 08 00 01 2d 1a 0f 00 |..-.....|....-...|
|00004e20| 9b 11 00 02 02 01 15 0f | 7f 00 00 00 1a 00 00 01 |........|........|
|00004e30| 15 0f 7f 00 00 00 1a 01 | 00 01 15 0f 7f 00 00 00 |........|........|
|00004e40| 1a 02 00 01 15 0f 7f 00 | 00 00 1a 03 00 01 15 0f |........|........|
|00004e50| 7f 00 00 00 1a 04 00 01 | 15 0f 7f 00 00 00 1a 05 |........|........|
|00004e60| 00 07 7f 43 01 4a 08 43 | 55 53 54 4f 4d 45 52 00 |...C.J.C|USTOMER.|
|00004e70| 47 2f 17 00 07 43 55 53 | 54 5f 4e 4f 29 00 00 00 |G/...CUS|T_NO)...|
|00004e80| 01 00 ff 02 01 17 00 08 | 43 55 53 54 4f 4d 45 52 |........|CUSTOMER|
|00004e90| 1a 06 00 01 17 00 0d 43 | 4f 4e 54 41 43 54 5f 46 |.......C|ONTACT_F|
|00004ea0| 49 52 53 54 1a 07 00 01 | 17 00 0c 43 4f 4e 54 41 |IRST....|...CONTA|
|00004eb0| 43 54 5f 4c 41 53 54 1a | 08 00 01 17 00 0d 41 44 |CT_LAST.|......AD|
|00004ec0| 44 52 45 53 53 5f 4c 49 | 4e 45 31 1a 09 00 01 17 |DRESS_LI|NE1.....|
|00004ed0| 00 0d 41 44 44 52 45 53 | 53 5f 4c 49 4e 45 32 1a |..ADDRES|S_LINE2.|
|00004ee0| 0a 00 01 17 00 04 43 49 | 54 59 1a 0b 00 01 17 00 |......CI|TY......|
|00004ef0| 0e 53 54 41 54 45 5f 50 | 52 4f 56 49 4e 43 45 1a |.STATE_P|ROVINCE.|
|00004f00| 0c 00 01 17 00 07 43 4f | 55 4e 54 52 59 1a 0d 00 |......CO|UNTRY...|
|00004f10| 01 17 00 0b 50 4f 53 54 | 41 4c 5f 43 4f 44 45 1a |....POST|AL_CODE.|
|00004f20| 0e 00 ff 08 3b 3d 1a 06 | 00 01 1a 06 00 1a 00 00 |....;=..|........|
|00004f30| ff 08 3b 3d 1a 07 00 01 | 27 27 1a 07 00 15 0f 7f |..;=....|''......|
|00004f40| 00 01 00 20 1a 08 00 1a | 01 00 01 1a 08 00 1a 01 |... ....|........|
|00004f50| 00 08 3b 3d 1a 09 00 01 | 1a 09 00 1a 02 00 ff 08 |..;=....|........|
|00004f60| 3b 3d 1a 0a 00 01 1a 0a | 00 1a 03 00 ff 08 2f 1a |;=......|....../.|
|00004f70| 0d 00 15 0f 7f 00 03 00 | 55 53 41 02 02 08 3b 3d |........|USA...;=|
|00004f80| 1a 0b 00 01 27 27 27 27 | 1a 0b 00 15 0f 7f 00 02 |....''''|........|
|00004f90| 00 2c 20 1a 0c 00 15 0f | 7f 00 02 00 20 20 1a 0e |., .....|....  ..|
|00004fa0| 00 1a 04 00 01 27 27 1a | 0c 00 15 0f 7f 00 02 00 |.....''.|........|
|00004fb0| 20 20 1a 0e 00 1a 04 00 | ff ff 02 02 08 3b 3d 1a |  ......|.....;=.|
|00004fc0| 0b 00 01 27 27 1a 0b 00 | 15 0f 7f 00 02 00 2c 20 |...''...|......, |
|00004fd0| 1a 0c 00 1a 04 00 01 1a | 0c 00 1a 04 00 01 27 27 |........|......''|
|00004fe0| 1a 0d 00 15 0f 7f 00 04 | 00 20 20 20 20 1a 0e 00 |........|.    ...|
|00004ff0| 1a 05 00 ff ff 02 0e 01 | 02 01 1a 00 00 29 01 00 |........|.....)..|
|00005000| 00 01 00 01 1a 01 00 29 | 01 02 00 03 00 01 1a 02 |.......)|........|
|00005010| 00 29 01 04 00 05 00 01 | 1a 03 00 29 01 06 00 07 |.)......|...)....|
|00005020| 00 01 1a 04 00 29 01 08 | 00 09 00 01 1a 05 00 29 |.....)..|.......)|
|00005030| 01 0a 00 0b 00 01 15 07 | 00 01 00 19 01 0c 00 ff |........|........|
|00005040| 9b ff ff ff ff 0e 01 02 | 01 1a 00 00 29 01 00 00 |........|....)...|
|00005050| 01 00 01 1a 01 00 29 01 | 02 00 03 00 01 1a 02 00 |......).|........|
|00005060| 29 01 04 00 05 00 01 1a | 03 00 29 01 06 00 07 00 |).......|..).....|
|00005070| 01 1a 04 00 29 01 08 00 | 09 00 01 1a 05 00 29 01 |....)...|......).|
|00005080| 0a 00 0b 00 01 15 07 00 | 00 00 19 01 0c 00 ff ff |........|........|
|00005090| 4c 09 0e 53 51 4c 24 4d | 41 49 4c 5f 4c 41 42 45 |L..SQL$M|AIL_LABE|
|000050a0| 4c 0a 07 42 55 49 4c 44 | 45 52 00 1c 01 07 43 55 |L..BUILD|ER....CU|
|000050b0| 53 54 5f 4e 4f 02 04 00 | 00 00 00 03 04 00 00 00 |ST_NO...|........|
|000050c0| 00 04 06 52 44 42 24 34 | 39 00 1c 01 05 4c 49 4e |...RDB$4|9....LIN|
|000050d0| 45 31 02 04 00 00 00 00 | 03 04 01 00 00 00 04 06 |E1......|........|
|000050e0| 52 44 42 24 35 30 00 1c | 01 05 4c 49 4e 45 32 02 |RDB$50..|..LINE2.|
|000050f0| 04 01 00 00 00 03 04 01 | 00 00 00 04 06 52 44 42 |........|.....RDB|
|00005100| 24 35 31 00 1c 01 05 4c | 49 4e 45 33 02 04 02 00 |$51....L|INE3....|
|00005110| 00 00 03 04 01 00 00 00 | 04 06 52 44 42 24 35 32 |........|..RDB$52|
|00005120| 00 1c 01 05 4c 49 4e 45 | 34 02 04 03 00 00 00 03 |....LINE|4.......|
|00005130| 04 01 00 00 00 04 06 52 | 44 42 24 35 33 00 1c 01 |.......R|DB$53...|
|00005140| 05 4c 49 4e 45 35 02 04 | 04 00 00 00 03 04 01 00 |.LINE5..|........|
|00005150| 00 00 04 06 52 44 42 24 | 35 34 00 1c 01 05 4c 49 |....RDB$|54....LI|
|00005160| 4e 45 36 02 04 05 00 00 | 00 03 04 01 00 00 00 04 |NE6.....|........|
|00005170| 06 52 44 42 24 35 35 00 | 1d 1b 01 0a 53 48 49 50 |.RDB$55.|....SHIP|
|00005180| 5f 4f 52 44 45 52 02 04 | 01 00 00 00 03 04 00 00 |_ORDER..|........|
|00005190| 00 00 07 04 58 04 00 00 | 0a 20 44 45 43 4c 41 52 |....X...|. DECLAR|
|000051a0| 45 20 56 41 52 49 41 42 | 4c 45 20 6f 72 64 5f 73 |E VARIAB|LE ord_s|
|000051b0| 74 61 74 20 43 48 41 52 | 28 37 29 3b 0a 20 44 45 |tat CHAR|(7);. DE|
|000051c0| 43 4c 41 52 45 20 56 41 | 52 49 41 42 4c 45 20 68 |CLARE VA|RIABLE h|
|000051d0| 6f 6c 64 5f 73 74 61 74 | 20 43 48 41 52 28 31 29 |old_stat| CHAR(1)|
|000051e0| 3b 0a 20 44 45 43 4c 41 | 52 45 20 56 41 52 49 41 |;. DECLA|RE VARIA|
|000051f0| 42 4c 45 20 63 75 73 74 | 5f 6e 6f 20 49 4e 54 45 |BLE cust|_no INTE|
|00005200| 47 45 52 3b 0a 20 44 45 | 43 4c 41 52 45 20 56 41 |GER;. DE|CLARE VA|
|00005210| 52 49 41 42 4c 45 20 61 | 6e 79 5f 70 6f 20 43 48 |RIABLE a|ny_po CH|
|00005220| 41 52 28 38 29 3b 0a 42 | 45 47 49 4e 0a 20 53 45 |AR(8);.B|EGIN. SE|
|00005230| 4c 45 43 54 20 73 2e 6f | 72 64 65 72 5f 73 74 61 |LECT s.o|rder_sta|
|00005240| 74 75 73 2c 20 63 2e 6f | 6e 5f 68 6f 6c 64 2c 20 |tus, c.o|n_hold, |
|00005250| 63 2e 63 75 73 74 5f 6e | 6f 0a 20 46 52 4f 4d 20 |c.cust_n|o. FROM |
|00005260| 73 61 6c 65 73 20 73 2c | 20 63 75 73 74 6f 6d 65 |sales s,| custome|
|00005270| 72 20 63 0a 20 57 48 45 | 52 45 20 70 6f 5f 6e 75 |r c. WHE|RE po_nu|
|00005280| 6d 62 65 72 20 3d 20 3a | 70 6f 5f 6e 75 6d 0a 20 |mber = :|po_num. |
|00005290| 41 4e 44 20 73 2e 63 75 | 73 74 5f 6e 6f 20 3d 20 |AND s.cu|st_no = |
|000052a0| 63 2e 63 75 73 74 5f 6e | 6f 0a 20 49 4e 54 4f 20 |c.cust_n|o. INTO |
|000052b0| 3a 6f 72 64 5f 73 74 61 | 74 2c 20 3a 68 6f 6c 64 |:ord_sta|t, :hold|
|000052c0| 5f 73 74 61 74 2c 20 3a | 63 75 73 74 5f 6e 6f 3b |_stat, :|cust_no;|
|000052d0| 0a 0a 20 2f 2a 20 54 68 | 69 73 20 70 75 72 63 68 |.. /* Th|is purch|
|000052e0| 61 73 65 20 6f 72 64 65 | 72 20 68 61 73 20 62 65 |ase orde|r has be|
|000052f0| 65 6e 20 61 6c 72 65 61 | 64 79 20 73 68 69 70 70 |en alrea|dy shipp|
|00005300| 65 64 2e 20 2a 2f 0a 20 | 49 46 20 28 6f 72 64 5f |ed. */. |IF (ord_|
|00005310| 73 74 61 74 20 3d 20 27 | 73 68 69 70 70 65 64 27 |stat = '|shipped'|
|00005320| 29 20 54 48 45 4e 0a 20 | 42 45 47 49 4e 0a 20 20 |) THEN. |BEGIN.  |
|00005330| 45 58 43 45 50 54 49 4f | 4e 20 6f 72 64 65 72 5f |EXCEPTIO|N order_|
|00005340| 61 6c 72 65 61 64 79 5f | 73 68 69 70 70 65 64 3b |already_|shipped;|
|00005350| 0a 20 20 53 55 53 50 45 | 4e 44 3b 0a 20 45 4e 44 |.  SUSPE|ND;. END|
|00005360| 0a 0a 20 2f 2a 20 43 75 | 73 74 6f 6d 65 72 20 69 |.. /* Cu|stomer i|
|00005370| 73 20 6f 6e 20 68 6f 6c | 64 2e 20 2a 2f 0a 20 45 |s on hol|d. */. E|
|00005380| 4c 53 45 20 49 46 20 28 | 68 6f 6c 64 5f 73 74 61 |LSE IF (|hold_sta|
|00005390| 74 20 3d 20 27 2a 27 29 | 00 20 54 48 45 4e 0a 20 |t = '*')|. THEN. |
|000053a0| 42 45 47 49 4e 0a 20 20 | 45 58 43 45 50 54 49 4f |BEGIN.  |EXCEPTIO|
|000053b0| 4e 20 63 75 73 74 6f 6d | 65 72 5f 6f 6e 5f 68 6f |N custom|er_on_ho|
|000053c0| 6c 64 3b 0a 20 20 53 55 | 53 50 45 4e 44 3b 0a 20 |ld;.  SU|SPEND;. |
|000053d0| 45 4e 44 0a 0a 20 2f 2a | 0a 20 20 2a 20 49 66 20 |END.. /*|.  * If |
|000053e0| 74 68 65 72 65 20 69 73 | 20 61 6e 20 75 6e 70 61 |there is| an unpa|
|000053f0| 69 64 20 62 61 6c 61 6e | 63 65 20 6f 6e 20 6f 72 |id balan|ce on or|
|00005400| 64 65 72 73 20 73 68 69 | 70 70 65 64 20 6f 76 65 |ders shi|pped ove|
|00005410| 72 20 32 20 6d 6f 6e 74 | 68 73 20 61 67 6f 2c 0a |r 2 mont|hs ago,.|
|00005420| 20 20 2a 20 70 75 74 20 | 74 68 65 20 63 75 73 74 |  * put |the cust|
|00005430| 6f 6d 65 72 20 6f 6e 20 | 68 6f 6c 64 2e 0a 20 20 |omer on |hold..  |
|00005440| 2a 2f 0a 20 46 4f 52 20 | 53 45 4c 45 43 54 20 70 |*/. FOR |SELECT p|
|00005450| 6f 5f 6e 75 6d 62 65 72 | 0a 20 20 46 52 4f 4d 20 |o_number|.  FROM |
|00005460| 73 61 6c 65 73 0a 20 20 | 57 48 45 52 45 20 63 75 |sales.  |WHERE cu|
|00005470| 73 74 5f 6e 6f 20 3d 20 | 3a 63 75 73 74 5f 6e 6f |st_no = |:cust_no|
|00005480| 0a 20 20 41 4e 44 20 6f | 72 64 65 72 5f 73 74 61 |.  AND o|rder_sta|
|00005490| 74 75 73 20 3d 20 27 73 | 68 69 70 70 65 64 27 0a |tus = 's|hipped'.|
|000054a0| 20 20 41 4e 44 20 70 61 | 69 64 20 3d 20 27 6e 27 |  AND pa|id = 'n'|
|000054b0| 0a 20 20 41 4e 44 20 73 | 68 69 70 5f 64 61 74 65 |.  AND s|hip_date|
|000054c0| 20 3c 20 43 41 53 54 28 | 27 4e 4f 57 27 20 41 53 | < CAST(|'NOW' AS|
|000054d0| 20 44 41 54 45 29 20 2d | 20 36 30 0a 20 20 49 4e | DATE) -| 60.  IN|
|000054e0| 54 4f 20 3a 61 6e 79 5f | 70 6f 0a 20 44 4f 0a 20 |TO :any_|po. DO. |
|000054f0| 42 45 47 49 4e 0a 20 20 | 45 58 43 45 50 54 49 4f |BEGIN.  |EXCEPTIO|
|00005500| 4e 20 63 75 73 74 6f 6d | 65 72 5f 63 68 65 63 6b |N custom|er_check|
|00005510| 3b 0a 0a 20 20 55 50 44 | 41 54 45 20 63 75 73 74 |;..  UPD|ATE cust|
|00005520| 6f 6d 65 72 0a 20 20 53 | 45 54 20 6f 6e 5f 68 6f |omer.  S|ET on_ho|
|00005530| 6c 64 20 3d 20 27 2a 27 | 0a 20 20 57 48 45 52 45 |ld = '*'|.  WHERE|
|00005540| 20 63 75 73 74 5f 6e 6f | 20 3d 20 3a 63 75 73 74 | cust_no| = :cust|
|00005550| 5f 6e 6f 3b 0a 0a 20 20 | 53 55 53 50 45 4e 44 3b |_no;..  |SUSPEND;|
|00005560| 0a 20 45 4e 44 0a 0a 20 | 2f 2a 0a 20 20 2a 20 53 |. END.. |/*.  * S|
|00005570| 68 69 70 20 74 68 65 20 | 6f 72 64 65 72 2e 0a 20 |hip the |order.. |
|00005580| 20 2a 2f 0a 20 55 50 44 | 41 54 45 20 73 61 6c 65 | */. UPD|ATE sale|
|00005590| 73 0a 20 53 45 54 20 6f | 72 00 64 65 72 5f 73 74 |s. SET o|r.der_st|
|000055a0| 61 74 75 73 20 3d 20 27 | 73 68 69 70 70 65 64 27 |atus = '|shipped'|
|000055b0| 2c 20 73 68 69 70 5f 64 | 61 74 65 20 3d 20 27 4e |, ship_d|ate = 'N|
|000055c0| 4f 57 27 20 0a 20 57 48 | 45 52 45 20 70 6f 5f 6e |OW' . WH|ERE po_n|
|000055d0| 75 6d 62 65 72 20 3d 20 | 3a 70 6f 5f 6e 75 6d 3b |umber = |:po_num;|
|000055e0| 0a 0a 20 53 55 53 50 45 | 4e 44 3b 0a 45 4e 44 00 |.. SUSPE|ND;.END.|
|000055f0| 08 04 8a 02 00 00 04 02 | 04 00 02 00 0f 15 00 08 |........|........|
|00005600| 00 07 00 04 01 01 00 07 | 00 0c 00 02 03 00 00 0f |........|........|
|00005610| 15 00 07 00 01 2d 1a 00 | 00 03 01 00 0f 15 00 01 |.....-..|........|
|00005620| 00 01 2d 1a 01 00 03 02 | 00 08 00 01 2d 1a 02 00 |..-.....|....-...|
|00005630| 03 03 00 0f 15 00 08 00 | 01 2d 1a 03 00 9b 11 00 |........|.-......|
|00005640| 02 02 07 7f 43 02 92 05 | 53 41 4c 45 53 01 53 00 |....C...|SALES.S.|
|00005650| 92 08 43 55 53 54 4f 4d | 45 52 01 43 01 47 3a 2f |..CUSTOM|ER.C.G:/|
|00005660| 17 00 09 50 4f 5f 4e 55 | 4d 42 45 52 29 00 00 00 |...PO_NU|MBER)...|
|00005670| 01 00 2f 17 00 07 43 55 | 53 54 5f 4e 4f 17 01 07 |../...CU|ST_NO...|
|00005680| 43 55 53 54 5f 4e 4f ff | 02 01 17 00 0c 4f 52 44 |CUST_NO.|.....ORD|
|00005690| 45 52 5f 53 54 41 54 55 | 53 1a 00 00 01 17 01 07 |ER_STATU|S.......|
|000056a0| 4f 4e 5f 48 4f 4c 44 1a | 01 00 01 17 01 07 43 55 |ON_HOLD.|......CU|
|000056b0| 53 54 5f 4e 4f 1a 02 00 | ff 08 2f 1a 00 00 15 0f |ST_NO...|../.....|
|000056c0| 7f 00 07 00 73 68 69 70 | 70 65 64 02 02 80 02 15 |....ship|ped.....|
|000056d0| 4f 52 44 45 52 5f 41 4c | 52 45 41 44 59 5f 53 48 |ORDER_AL|READY_SH|
|000056e0| 49 50 50 45 44 02 0e 01 | 02 01 15 07 00 01 00 19 |IPPED...|........|
|000056f0| 01 00 00 ff 9b ff ff ff | 08 2f 1a 01 00 15 0f 7f |........|./......|
|00005700| 00 01 00 2a 02 02 80 02 | 10 43 55 53 54 4f 4d 45 |...*....|.CUSTOME|
|00005710| 52 5f 4f 4e 5f 48 4f 4c | 44 02 0e 01 02 01 15 07 |R_ON_HOL|D.......|
|00005720| 00 01 00 19 01 00 00 ff | 9b ff ff ff ff 07 43 01 |........|......C.|
|00005730| 4a 05 53 41 4c 45 53 02 | 47 3a 3a 3a 2f 17 02 07 |J.SALES.|G:::/...|
|00005740| 43 55 53 54 5f 4e 4f 1a | 02 00 2f 17 02 0c 4f 52 |CUST_NO.|../...OR|
|00005750| 44 45 52 5f 53 54 41 54 | 55 53 15 0f 7f 00 07 00 |DER_STAT|US......|
|00005760| 73 68 69 70 70 65 64 2f | 17 02 04 50 41 49 44 15 |shipped/|...PAID.|
|00005770| 0f 7f 00 01 00 6e 33 17 | 02 09 53 48 49 50 5f 44 |.....n3.|..SHIP_D|
|00005780| 41 54 45 23 83 23 15 0f | 7f 00 03 00 4e 4f 57 15 |ATE#.#..|....NOW.|
|00005790| 08 00 3c 00 00 00 ff 02 | 01 17 02 09 50 4f 5f 4e |..<.....|....PO_N|
|000057a0| 55 4d 42 45 52 1a 03 00 | 02 02 80 02 0e 43 55 53 |UMBER...|.....CUS|
|000057b0| 54 4f 4d 45 52 5f 43 48 | 45 43 4b 07 43 01 4a 08 |TOMER_CH|ECK.C.J.|
|000057c0| 43 55 53 54 4f 4d 45 52 | 03 47 2f 17 03 07 43 55 |CUSTOMER|.G/...CU|
|000057d0| 53 54 5f 4e 4f 1a 02 00 | ff 0a 03 03 02 01 15 0f |ST_NO...|........|
|000057e0| 7f 00 01 00 2a 17 03 07 | 4f 4e 5f 48 4f 4c 44 ff |....*...|ON_HOLD.|
|000057f0| 02 0e 01 02 01 15 07 00 | 01 00 19 01 00 00 ff 9b |........|........|
|00005800| ff ff ff ff 07 43 01 4a | 05 53 41 4c 45 53 04 47 |.....C.J|.SALES.G|
|00005810| 2f 17 04 09 50 4f 5f 4e | 55 4d 42 45 52 29 00 00 |/...PO_N|UMBER)..|
|00005820| 00 01 00 ff 0a 04 04 02 | 01 15 0f 7f 00 07 00 73 |........|.......s|
|00005830| 68 69 70 70 65 64 17 04 | 0c 4f 52 44 45 52 5f 53 |hipped..|.ORDER_S|
|00005840| 54 41 54 55 53 01 15 0f | 7f 00 03 00 4e 4f 57 17 |TATUS...|....NOW.|
|00005850| 04 09 53 48 49 50 5f 44 | 41 54 45 ff 02 0e 01 02 |..SHIP_D|ATE.....|
|00005860| 01 15 07 00 01 00 19 01 | 00 00 ff 9b ff ff ff ff |........|........|
|00005870| 0e 01 02 01 15 07 00 00 | 00 19 01 00 00 ff ff 4c |........|.......L|
|00005880| 09 0e 53 51 4c 24 53 48 | 49 50 5f 4f 52 44 45 52 |..SQL$SH|IP_ORDER|
|00005890| 0a 07 42 55 49 4c 44 45 | 52 00 1c 01 06 50 4f 5f |..BUILDE|R....PO_|
|000058a0| 4e 55 4d 02 04 00 00 00 | 00 03 04 00 00 00 00 04 |NUM.....|........|
|000058b0| 06 52 44 42 24 35 36 00 | 1d 1b 01 0a 53 48 4f 57 |.RDB$56.|....SHOW|
|000058c0| 5f 4c 41 4e 47 53 02 04 | 03 00 00 00 03 04 01 00 |_LANGS..|........|
|000058d0| 00 00 07 04 8b 01 00 00 | 0a 44 45 43 4c 41 52 45 |........|.DECLARE|
|000058e0| 20 56 41 52 49 41 42 4c | 45 20 69 20 49 4e 54 45 | VARIABL|E i INTE|
|000058f0| 47 45 52 3b 0a 42 45 47 | 49 4e 0a 20 20 69 20 3d |GER;.BEG|IN.  i =|
|00005900| 20 31 3b 0a 20 20 57 48 | 49 4c 45 20 28 69 20 3c | 1;.  WH|ILE (i <|
|00005910| 3d 20 35 29 20 44 4f 0a | 20 20 42 45 47 49 4e 0a |= 5) DO.|  BEGIN.|
|00005920| 20 20 20 20 53 45 4c 45 | 43 54 20 6c 61 6e 67 75 |    SELE|CT langu|
|00005930| 61 67 65 5f 72 65 71 5b | 3a 69 5d 20 46 52 4f 4d |age_req[|:i] FROM|
|00005940| 20 6a 6f 42 0a 20 20 20 | 20 57 48 45 52 45 20 28 | joB.   | WHERE (|
|00005950| 28 6a 6f 62 5f 63 6f 64 | 65 20 3d 20 3a 63 6f 64 |(job_cod|e = :cod|
|00005960| 65 29 20 41 4e 44 20 28 | 6a 6f 62 5f 67 72 61 64 |e) AND (|job_grad|
|00005970| 65 20 3d 20 3a 67 72 61 | 64 65 29 20 41 4e 44 20 |e = :gra|de) AND |
|00005980| 28 6a 6f 62 5f 63 6f 75 | 6e 74 72 79 20 3d 20 3a |(job_cou|ntry = :|
|00005990| 63 74 79 29 0a 20 20 20 | 20 20 20 20 20 20 20 20 |cty).   |        |
|000059a0| 41 4e 44 20 28 6c 61 6e | 67 75 61 67 65 5f 72 65 |AND (lan|guage_re|
|000059b0| 71 20 49 53 20 4e 4f 54 | 20 4e 55 4c 4c 29 29 0a |q IS NOT| NULL)).|
|000059c0| 20 20 20 20 49 4e 54 4f | 20 3a 6c 61 6e 67 75 61 |    INTO| :langua|
|000059d0| 67 65 73 3b 0a 20 20 20 | 20 49 46 20 28 6c 61 6e |ges;.   | IF (lan|
|000059e0| 67 75 61 67 65 73 20 3d | 20 27 20 27 29 20 54 48 |guages =| ' ') TH|
|000059f0| 45 4e 20 20 2f 2a 20 50 | 72 69 6e 74 73 20 27 4e |EN  /* P|rints 'N|
|00005a00| 55 4c 4c 27 20 69 6e 73 | 74 65 61 64 20 6f 66 20 |ULL' ins|tead of |
|00005a10| 62 6c 61 6e 6b 73 20 2a | 2f 0a 20 20 20 20 20 20 |blanks *|/.      |
|00005a20| 20 6c 61 6e 67 75 61 67 | 65 73 20 3d 20 27 4e 55 | languag|es = 'NU|
|00005a30| 4c 4c 27 3b 20 20 20 20 | 20 20 20 20 20 0a 20 20 |LL';    |     .  |
|00005a40| 20 20 69 20 3d 20 69 20 | 2b 31 3b 0a 20 20 20 20 |  i = i |+1;.    |
|00005a50| 53 55 53 50 45 4e 44 3b | 0a 20 20 45 4e 44 0a 45 |SUSPEND;|.  END.E|
|00005a60| 4e 44 00 08 04 3c 01 00 | 00 04 02 04 00 06 00 26 |ND...<..|.......&|
|00005a70| 15 00 05 00 07 00 07 00 | 07 00 26 15 00 0f 00 07 |........|..&.....|
|00005a80| 00 04 01 03 00 26 15 00 | 0f 00 07 00 07 00 0c 00 |.....&..|........|
|00005a90| 02 03 00 00 26 15 00 0f | 00 01 2d 1a 00 00 03 01 |....&...|..-.....|
|00005aa0| 00 08 00 01 2d 1a 01 00 | 9b 11 00 02 02 01 15 08 |....-...|........|
|00005ab0| 00 01 00 00 00 1a 01 00 | 11 01 09 02 08 34 1a 01 |........|.....4..|
|00005ac0| 00 15 08 00 05 00 00 00 | 02 02 07 7f 43 01 4a 03 |........|....C.J.|
|00005ad0| 4a 4f 42 00 47 3a 3a 3a | 2f 17 00 08 4a 4f 42 5f |JOB.G:::|/...JOB_|
|00005ae0| 43 4f 44 45 29 00 00 00 | 01 00 2f 17 00 09 4a 4f |CODE)...|../...JO|
|00005af0| 42 5f 47 52 41 44 45 29 | 00 02 00 03 00 2f 17 00 |B_GRADE)|...../..|
|00005b00| 0b 4a 4f 42 5f 43 4f 55 | 4e 54 52 59 29 00 04 00 |.JOB_COU|NTRY)...|
|00005b10| 05 00 3b 3d 17 00 0c 4c | 41 4e 47 55 41 47 45 5f |..;=...L|ANGUAGE_|
|00005b20| 52 45 51 ff 02 01 6b 17 | 00 0c 4c 41 4e 47 55 41 |REQ...k.|..LANGUA|
|00005b30| 47 45 5f 52 45 51 01 1a | 01 00 1a 00 00 ff 08 2f |GE_REQ..|......./|
|00005b40| 1a 00 00 15 0f 7f 00 01 | 00 20 01 15 0f 7f 00 04 |........|. ......|
|00005b50| 00 4e 55 4c 4c 1a 00 00 | ff 01 22 1a 01 00 15 08 |.NULL...|..".....|
|00005b60| 00 01 00 00 00 1a 01 00 | 02 0e 01 02 01 1a 00 00 |........|........|
|00005b70| 29 01 00 00 01 00 01 15 | 07 00 01 00 19 01 02 00 |).......|........|
|00005b80| ff 9b ff ff ff 12 01 ff | ff ff ff 0e 01 02 01 1a |........|........|
|00005b90| 00 00 29 01 00 00 01 00 | 01 15 07 00 00 00 19 01 |..).....|........|
|00005ba0| 02 00 ff ff 4c 09 0e 53 | 51 4c 24 53 48 4f 57 5f |....L..S|QL$SHOW_|
|00005bb0| 4c 41 4e 47 53 0a 07 42 | 55 49 4c 44 45 52 00 1c |LANGS..B|UILDER..|
|00005bc0| 01 04 43 4f 44 45 02 04 | 00 00 00 00 03 04 00 00 |..CODE..|........|
|00005bd0| 00 00 04 06 52 44 42 24 | 35 37 00 1c 01 05 47 52 |....RDB$|57....GR|
|00005be0| 41 44 45 02 04 01 00 00 | 00 03 04 00 00 00 00 04 |ADE.....|........|
|00005bf0| 06 52 44 42 24 35 38 00 | 1c 01 03 43 54 59 02 04 |.RDB$58.|...CTY..|
|00005c00| 02 00 00 00 03 04 00 00 | 00 00 04 06 52 44 42 24 |........|....RDB$|
|00005c10| 35 39 00 1c 01 09 4c 41 | 4e 47 55 41 47 45 53 02 |59....LA|NGUAGES.|
|00005c20| 04 00 00 00 00 03 04 01 | 00 00 00 04 06 52 44 42 |........|.....RDB|
|00005c30| 24 36 30 00 1d 1b 01 09 | 41 4c 4c 5f 4c 41 4e 47 |$60.....|ALL_LANG|
|00005c40| 53 02 04 00 00 00 00 03 | 04 04 00 00 00 07 04 8b |S.......|........|
|00005c50| 01 00 00 0a 20 20 20 20 | 42 45 47 49 4e 0a 20 46 |....    |BEGIN. F|
|00005c60| 4f 52 20 53 45 4c 45 43 | 54 20 6a 6f 62 5f 63 6f |OR SELEC|T job_co|
|00005c70| 64 65 2c 20 6a 6f 62 5f | 67 72 61 64 65 2c 20 6a |de, job_|grade, j|
|00005c80| 6f 62 5f 63 6f 75 6e 74 | 72 79 20 46 52 4f 4d 20 |ob_count|ry FROM |
|00005c90| 6a 6f 62 20 0a 20 20 49 | 4e 54 4f 20 3a 63 6f 64 |job .  I|NTO :cod|
|00005ca0| 65 2c 20 3a 67 72 61 64 | 65 2c 20 3a 63 6f 75 6e |e, :grad|e, :coun|
|00005cb0| 74 72 79 0a 0a 20 44 4f | 0a 20 42 45 47 49 4e 0a |try.. DO|. BEGIN.|
|00005cc0| 20 20 20 20 20 46 4f 52 | 20 53 45 4c 45 43 54 20 |     FOR| SELECT |
|00005cd0| 6c 61 6e 67 75 61 67 65 | 73 20 46 52 4f 4d 20 73 |language|s FROM s|
|00005ce0| 68 6f 77 5f 6c 61 6e 67 | 73 20 0a 20 20 20 20 20 |how_lang|s .     |
|00005cf0| 20 20 28 3a 63 6f 64 65 | 2c 20 3a 67 72 61 64 65 |  (:code|, :grade|
|00005d00| 2c 20 3a 63 6f 75 6e 74 | 72 79 29 20 49 4e 54 4f |, :count|ry) INTO|
|00005d10| 20 3a 6c 61 6e 67 20 44 | 4f 0a 20 20 20 20 20 20 | :lang D|O.      |
|00005d20| 20 20 20 53 55 53 50 45 | 4e 44 3b 0a 20 20 20 20 |   SUSPE|ND;.    |
|00005d30| 20 2f 2a 20 50 75 74 20 | 6e 69 63 65 20 73 65 70 | /* Put |nice sep|
|00005d40| 61 72 61 74 6f 72 73 20 | 62 65 74 77 65 65 6e 20 |arators |between |
|00005d50| 72 6f 77 73 20 2a 2f 0a | 20 20 20 20 20 63 6f 64 |rows */.|     cod|
|00005d60| 65 20 3d 20 27 3d 3d 3d | 3d 3d 27 3b 0a 20 20 20 |e = '===|==';.   |
|00005d70| 20 20 67 72 61 64 65 20 | 3d 20 27 3d 3d 3d 3d 3d |  grade |= '=====|
|00005d80| 27 3b 0a 20 20 20 20 20 | 63 6f 75 6e 74 72 79 20 |';.     |country |
|00005d90| 3d 20 27 3d 3d 3d 3d 3d | 3d 3d 3d 3d 3d 3d 3d 3d |= '=====|========|
|00005da0| 3d 3d 27 3b 0a 20 20 20 | 20 20 6c 61 6e 67 20 3d |==';.   |  lang =|
|00005db0| 20 27 3d 3d 3d 3d 3d 3d | 3d 3d 3d 3d 3d 3d 3d 3d | '======|========|
|00005dc0| 27 3b 0a 20 20 20 20 20 | 53 55 53 50 45 4e 44 3b |';.     |SUSPEND;|
|00005dd0| 0a 20 45 4e 44 0a 20 20 | 20 20 45 4e 44 00 08 04 |. END.  |  END...|
|00005de0| c9 01 00 00 04 02 04 01 | 09 00 26 15 00 05 00 07 |........|..&.....|
|00005df0| 00 26 15 00 05 00 07 00 | 26 15 00 0f 00 07 00 26 |.&......|&......&|
|00005e00| 15 00 0f 00 07 00 07 00 | 02 03 00 00 26 15 00 05 |........|....&...|
|00005e10| 00 01 2d 1a 00 00 03 01 | 00 26 15 00 05 00 01 2d |..-.....|.&.....-|
|00005e20| 1a 01 00 03 02 00 26 15 | 00 0f 00 01 2d 1a 02 00 |......&.|....-...|
|00005e30| 03 03 00 26 15 00 0f 00 | 01 2d 1a 03 00 9b 11 00 |...&....|.-......|
|00005e40| 02 02 07 43 01 4a 03 4a | 4f 42 00 ff 02 01 17 00 |...C.J.J|OB......|
|00005e50| 08 4a 4f 42 5f 43 4f 44 | 45 1a 00 00 01 17 00 09 |.JOB_COD|E.......|
|00005e60| 4a 4f 42 5f 47 52 41 44 | 45 1a 01 00 01 17 00 0b |JOB_GRAD|E.......|
|00005e70| 4a 4f 42 5f 43 4f 55 4e | 54 52 59 1a 02 00 02 02 |JOB_COUN|TRY.....|
|00005e80| 07 43 01 7c 0a 53 48 4f | 57 5f 4c 41 4e 47 53 01 |.C.|.SHO|W_LANGS.|
|00005e90| 03 00 1a 00 00 1a 01 00 | 1a 02 00 ff 02 01 17 01 |........|........|
|00005ea0| 09 4c 41 4e 47 55 41 47 | 45 53 1a 03 00 02 0e 01 |.LANGUAG|ES......|
|00005eb0| 02 01 1a 00 00 29 01 00 | 00 01 00 01 1a 01 00 29 |.....)..|.......)|
|00005ec0| 01 02 00 03 00 01 1a 02 | 00 29 01 04 00 05 00 01 |........|.)......|
|00005ed0| 1a 03 00 29 01 06 00 07 | 00 01 15 07 00 01 00 19 |...)....|........|
|00005ee0| 01 08 00 ff 9b ff ff 01 | 15 0f 7f 00 05 00 3d 3d |........|......==|
|00005ef0| 3d 3d 3d 1a 00 00 01 15 | 0f 7f 00 05 00 3d 3d 3d |===.....|.....===|
|00005f00| 3d 3d 1a 01 00 01 15 0f | 7f 00 0f 00 3d 3d 3d 3d |==......|....====|
|00005f10| 3d 3d 3d 3d 3d 3d 3d 3d | 3d 3d 3d 1a 02 00 01 15 |========|===.....|
|00005f20| 0f 7f 00 0e 00 3d 3d 3d | 3d 3d 3d 3d 3d 3d 3d 3d |.....===|========|
|00005f30| 3d 3d 3d 1a 03 00 02 0e | 01 02 01 1a 00 00 29 01 |===.....|......).|
|00005f40| 00 00 01 00 01 1a 01 00 | 29 01 02 00 03 00 01 1a |........|).......|
|00005f50| 02 00 29 01 04 00 05 00 | 01 1a 03 00 29 01 06 00 |..).....|....)...|
|00005f60| 07 00 01 15 07 00 01 00 | 19 01 08 00 ff 9b ff ff |........|........|
|00005f70| ff ff ff ff ff 0e 01 02 | 01 1a 00 00 29 01 00 00 |........|....)...|
|00005f80| 01 00 01 1a 01 00 29 01 | 02 00 03 00 01 1a 02 00 |......).|........|
|00005f90| 29 01 04 00 05 00 01 1a | 03 00 29 01 06 00 07 00 |).......|..).....|
|00005fa0| 01 15 07 00 00 00 19 01 | 08 00 ff ff 4c 09 0d 53 |........|....L..S|
|00005fb0| 51 4c 24 41 4c 4c 5f 4c | 41 4e 47 53 0a 07 42 55 |QL$ALL_L|ANGS..BU|
|00005fc0| 49 4c 44 45 52 00 1c 01 | 04 43 4f 44 45 02 04 00 |ILDER...|.CODE...|
|00005fd0| 00 00 00 03 04 01 00 00 | 00 04 06 52 44 42 24 36 |........|...RDB$6|
|00005fe0| 31 00 1c 01 05 47 52 41 | 44 45 02 04 01 00 00 00 |1....GRA|DE......|
|00005ff0| 03 04 01 00 00 00 04 06 | 52 44 42 24 36 32 00 1c |........|RDB$62..|
|00006000| 01 07 43 4f 55 4e 54 52 | 59 02 04 02 00 00 00 03 |..COUNTR|Y.......|
|00006010| 04 01 00 00 00 04 06 52 | 44 42 24 36 33 00 1c 01 |.......R|DB$63...|
|00006020| 04 4c 41 4e 47 02 04 03 | 00 00 00 03 04 01 00 00 |.LANG...|........|
|00006030| 00 04 06 52 44 42 24 36 | 34 00 1d 1b 01 10 46 52 |...RDB$6|4.....FR|
|00006040| 45 4e 43 48 5f 43 55 53 | 54 5f 53 4f 52 54 02 04 |ENCH_CUS|T_SORT..|
|00006050| 00 00 00 00 03 04 03 00 | 00 00 07 04 a8 00 00 00 |........|........|
|00006060| 0a 42 45 47 49 4e 0a 20 | 20 20 20 20 20 20 20 46 |.BEGIN. |       F|
|00006070| 4f 52 20 53 45 4c 45 43 | 54 20 63 75 73 74 6f 6d |OR SELEC|T custom|
|00006080| 65 72 2c 20 63 69 74 79 | 2c 20 63 6f 75 6e 74 72 |er, city|, countr|
|00006090| 79 20 0a 20 20 20 20 20 | 46 52 4f 4d 20 63 75 73 |y .     |FROM cus|
|000060a0| 74 6f 6d 65 72 20 4f 52 | 44 45 52 20 42 59 20 63 |tomer OR|DER BY c|
|000060b0| 75 73 74 6f 6d 65 72 0a | 20 20 20 20 20 20 20 20 |ustomer.|        |
|000060c0| 20 20 20 20 49 4e 54 4f | 20 3a 63 75 73 74 6f 6d |    INTO| :custom|
|000060d0| 65 72 2c 20 3a 63 69 74 | 79 2c 20 3a 63 6f 75 6e |er, :cit|y, :coun|
|000060e0| 74 72 79 0a 20 20 20 20 | 20 20 20 20 44 4f 0a 20 |try.    |    DO. |
|000060f0| 20 20 20 20 20 20 20 20 | 20 20 53 55 53 50 45 4e |        |  SUSPEN|
|00006100| 44 3b 0a 0a 45 4e 44 00 | 08 04 f1 00 00 00 04 02 |D;..END.|........|
|00006110| 04 01 07 00 26 15 00 28 | 00 07 00 26 15 00 19 00 |....&..(|...&....|
|00006120| 07 00 26 15 00 0f 00 07 | 00 07 00 02 03 00 00 26 |..&.....|.......&|
|00006130| 15 00 28 00 01 2d 1a 00 | 00 03 01 00 26 15 00 19 |..(..-..|....&...|
|00006140| 00 01 2d 1a 01 00 03 02 | 00 26 15 00 0f 00 01 2d |..-.....|.&.....-|
|00006150| 1a 02 00 9b 11 00 02 02 | 07 43 01 4a 08 43 55 53 |........|.C.J.CUS|
|00006160| 54 4f 4d 45 52 00 46 01 | 48 17 00 08 43 55 53 54 |TOMER.F.|H...CUST|
|00006170| 4f 4d 45 52 ff 02 01 17 | 00 08 43 55 53 54 4f 4d |OMER....|..CUSTOM|
|00006180| 45 52 1a 00 00 01 17 00 | 04 43 49 54 59 1a 01 00 |ER......|.CITY...|
|00006190| 01 17 00 07 43 4f 55 4e | 54 52 59 1a 02 00 02 0e |....COUN|TRY.....|
|000061a0| 01 02 01 1a 00 00 29 01 | 00 00 01 00 01 1a 01 00 |......).|........|
|000061b0| 29 01 02 00 03 00 01 1a | 02 00 29 01 04 00 05 00 |).......|..).....|
|000061c0| 01 15 07 00 01 00 19 01 | 06 00 ff 9b ff ff ff ff |........|........|
|000061d0| ff 0e 01 02 01 1a 00 00 | 29 01 00 00 01 00 01 1a |........|).......|
|000061e0| 01 00 29 01 02 00 03 00 | 01 1a 02 00 29 01 04 00 |..).....|....)...|
|000061f0| 05 00 01 15 07 00 00 00 | 19 01 06 00 ff ff 4c 09 |........|......L.|
|00006200| 14 53 51 4c 24 46 52 45 | 4e 43 48 5f 43 55 53 54 |.SQL$FRE|NCH_CUST|
|00006210| 5f 53 4f 52 54 0a 07 42 | 55 49 4c 44 45 52 00 1c |_SORT..B|UILDER..|
|00006220| 01 08 43 55 53 54 4f 4d | 45 52 02 04 00 00 00 00 |..CUSTOM|ER......|
|00006230| 03 04 01 00 00 00 04 06 | 52 44 42 24 36 35 00 1c |........|RDB$65..|
|00006240| 01 04 43 49 54 59 02 04 | 01 00 00 00 03 04 01 00 |..CITY..|........|
|00006250| 00 00 04 06 52 44 42 24 | 36 36 00 1c 01 07 43 4f |....RDB$|66....CO|
|00006260| 55 4e 54 52 59 02 04 02 | 00 00 00 03 04 01 00 00 |UNTRY...|........|
|00006270| 00 04 06 52 44 42 24 36 | 37 00 1d 1b 01 10 47 45 |...RDB$6|7.....GE|
|00006280| 52 4d 41 4e 5f 43 55 53 | 54 5f 53 4f 52 54 02 04 |RMAN_CUS|T_SORT..|
|00006290| 00 00 00 00 03 04 03 00 | 00 00 07 04 b6 00 00 00 |........|........|
|000062a0| 0a 42 45 47 49 4e 0a 20 | 20 20 20 20 20 20 20 46 |.BEGIN. |       F|
|000062b0| 4f 52 20 53 45 4c 45 43 | 54 20 63 75 73 74 6f 6d |OR SELEC|T custom|
|000062c0| 65 72 2c 20 63 69 74 79 | 2c 20 63 6f 75 6e 74 72 |er, city|, countr|
|000062d0| 79 20 0a 20 20 20 20 20 | 46 52 4f 4d 20 63 75 73 |y .     |FROM cus|
|000062e0| 74 6f 6d 65 72 20 4f 52 | 44 45 52 20 42 59 20 63 |tomer OR|DER BY c|
|000062f0| 75 73 74 6f 6d 65 72 20 | 43 4f 4c 4c 41 54 45 20 |ustomer |COLLATE |
|00006300| 44 45 5f 44 45 0a 20 20 | 20 20 20 20 20 20 20 20 |DE_DE.  |        |
|00006310| 20 20 49 4e 54 4f 20 3a | 63 75 73 74 6f 6d 65 72 |  INTO :|customer|
|00006320| 2c 20 3a 63 69 74 79 2c | 20 3a 63 6f 75 6e 74 72 |, :city,| :countr|
|00006330| 79 0a 20 20 20 20 20 20 | 20 20 44 4f 0a 20 20 20 |y.      |  DO.   |
|00006340| 20 20 20 20 20 20 20 20 | 53 55 53 50 45 4e 44 3b |        |SUSPEND;|
|00006350| 0a 0a 45 4e 44 00 08 04 | f7 00 00 00 04 02 04 01 |..END...|........|
|00006360| 07 00 26 15 00 28 00 07 | 00 26 15 00 19 00 07 00 |..&..(..|.&......|
|00006370| 26 15 00 0f 00 07 00 07 | 00 02 03 00 00 26 15 00 |&.......|.....&..|
|00006380| 28 00 01 2d 1a 00 00 03 | 01 00 26 15 00 19 00 01 |(..-....|..&.....|
|00006390| 2d 1a 01 00 03 02 00 26 | 15 00 0f 00 01 2d 1a 02 |-......&|.....-..|
|000063a0| 00 9b 11 00 02 02 07 43 | 01 4a 08 43 55 53 54 4f |.......C|.J.CUSTO|
|000063b0| 4d 45 52 00 46 01 48 83 | 26 15 06 00 00 17 00 08 |MER.F.H.|&.......|
|000063c0| 43 55 53 54 4f 4d 45 52 | ff 02 01 17 00 08 43 55 |CUSTOMER|......CU|
|000063d0| 53 54 4f 4d 45 52 1a 00 | 00 01 17 00 04 43 49 54 |STOMER..|.....CIT|
|000063e0| 59 1a 01 00 01 17 00 07 | 43 4f 55 4e 54 52 59 1a |Y.......|COUNTRY.|
|000063f0| 02 00 02 0e 01 02 01 1a | 00 00 29 01 00 00 01 00 |........|..).....|
+--------+-------------------------+-------------------------+--------+--------+
Only 25.0 KB of data is shown above.