PC Format Collection 48

home *** CD-ROM | disk | FTP | other *** search
/ PC Format Collection 48 / SENT14D.ISO / tech / delphi / disk14 / ibexampl.pak / EMPLOYEE.GBK next >
Unknown | 1995-08-24 | 70.5 KB
open in:
MacOS 8.1 |
Win98 |
DOS
view JSON data |
view as text

This file was not able to be converted.
This format is not currently supported by dexvert.
Confidence	Program	Detection	Match Type	Support
`10%`	dexvert	Degas High Resolution Picture (PI) `(image/degasHiPI)`	magic	Supported
`100%`	file	Atari DEGAS Elite bitmap 640 x 400 x 2, color palette 0404 0000 0004 0401 0000 ...	default (weak)
`99%`	file	data	default
`100%`	TrID	DEGAS hi-res bitmap	default (weak)
hex view
+--------+-------------------------+-------------------------+--------+--------+
|00000000| 00 02 04 04 00 00 00 04 | 04 01 00 00 00 05 04 01 |........|........|
|00000010| 00 00 00 06 04 00 02 00 | 00 08 04 01 00 00 00 07 |........|........|
|00000020| 18 2e 2e 5c 65 78 61 6d | 70 6c 65 34 5c 65 6d 70 |...\exam|ple4\emp|
|00000030| 6c 6f 79 65 65 2e 67 64 | 62 01 18 54 75 65 20 46 |loyee.gd|b..Tue F|
|00000040| 65 62 20 30 37 20 32 33 | 3a 30 38 3a 31 35 20 31 |eb 07 23|:08:15 1|
|00000050| 39 39 35 00 0e 05 04 00 | 04 00 00 08 04 20 4e 00 |995.....|..... N.|
|00000060| 00 01 18 2e 2e 5c 65 78 | 61 6d 70 6c 65 34 5c 65 |.....\ex|ample4\e|
|00000070| 6d 70 6c 6f 79 65 65 2e | 67 64 62 00 01 00 02 01 |mployee.|gdb.....|
|00000080| 09 46 49 52 53 54 4e 41 | 4d 45 05 00 07 00 08 04 |.FIRSTNA|ME......|
|00000090| 25 00 00 00 0a 04 0f 00 | 00 00 09 04 00 00 00 00 |%.......|........|
|000000a0| 0b 04 00 00 00 00 29 04 | 0f 00 00 00 2a 04 00 00 |......).|....*...|
|000000b0| 00 00 2b 04 00 00 00 00 | 00 02 01 08 4c 41 53 54 |..+.....|....LAST|
|000000c0| 4e 41 4d 45 05 00 07 00 | 08 04 25 00 00 00 0a 04 |NAME....|..%.....|
|000000d0| 14 00 00 00 09 04 00 00 | 00 00 0b 04 00 00 00 00 |........|........|
|000000e0| 29 04 14 00 00 00 2a 04 | 00 00 00 00 2b 04 00 00 |).....*.|....+...|
|000000f0| 00 00 00 02 01 0b 50 48 | 4f 4e 45 4e 55 4d 42 45 |......PH|ONENUMBE|
|00000100| 52 05 00 07 00 08 04 25 | 00 00 00 0a 04 14 00 00 |R......%|........|
|00000110| 00 09 04 00 00 00 00 0b | 04 00 00 00 00 29 04 14 |........|.....)..|
|00000120| 00 00 00 2a 04 00 00 00 | 00 2b 04 00 00 00 00 00 |...*....|.+......|
|00000130| 02 01 0b 43 4f 55 4e 54 | 52 59 4e 41 4d 45 05 00 |...COUNT|RYNAME..|
|00000140| 07 00 08 04 25 00 00 00 | 0a 04 0f 00 00 00 09 04 |....%...|........|
|00000150| 00 00 00 00 0b 04 00 00 | 00 00 29 04 0f 00 00 00 |........|..).....|
|00000160| 2a 04 00 00 00 00 2b 04 | 00 00 00 00 00 02 01 0b |*.....+.|........|
|00000170| 41 44 44 52 45 53 53 4c | 49 4e 45 05 00 07 00 08 |ADDRESSL|INE.....|
|00000180| 04 25 00 00 00 0a 04 1e | 00 00 00 09 04 00 00 00 |.%......|........|
|00000190| 00 0b 04 00 00 00 00 29 | 04 1e 00 00 00 2a 04 00 |.......)|.....*..|
|000001a0| 00 00 00 2b 04 00 00 00 | 00 00 02 01 05 45 4d 50 |...+....|.....EMP|
|000001b0| 4e 4f 05 00 07 00 08 04 | 07 00 00 00 0a 04 02 00 |NO......|........|
|000001c0| 00 00 09 04 00 00 00 00 | 0b 04 00 00 00 00 00 02 |........|........|
|000001d0| 01 06 44 45 50 54 4e 4f | 05 00 07 00 08 04 0e 00 |..DEPTNO|........|
|000001e0| 00 00 0a 04 03 00 00 00 | 09 04 00 00 00 00 0b 04 |........|........|
|000001f0| 00 00 00 00 14 04 32 00 | 00 00 04 39 39 2f 18 00 |......2.|...99/..|
|00000200| 00 00 15 0f 7f 00 03 00 | 30 30 30 3a 31 18 00 00 |........|000:1...|
|00000210| 00 15 0f 7f 00 01 00 30 | 34 18 00 00 00 15 0f 7f |.......0|4.......|
|00000220| 00 03 00 39 39 39 3d 18 | 00 00 00 4c 24 04 4b 00 |...999=.|...L$.K.|
|00000230| 00 00 43 48 45 43 4b 20 | 28 56 41 4c 55 45 20 3d |..CHECK |(VALUE =|
|00000240| 20 27 30 30 30 27 20 4f | 52 20 28 56 41 4c 55 45 | '000' O|R (VALUE|
|00000250| 20 3e 20 27 30 27 20 41 | 4e 44 20 56 41 4c 55 45 | > '0' A|ND VALUE|
|00000260| 20 3c 3d 20 27 39 39 39 | 27 29 20 4f 52 20 56 41 | <= '999|') OR VA|
|00000270| 4c 55 45 20 49 53 20 4e | 55 4c 4c 29 00 29 04 03 |LUE IS N|ULL).)..|
|00000280| 00 00 00 2a 04 00 00 00 | 00 2b 04 00 00 00 00 00 |...*....|.+......|
|00000290| 02 01 06 50 52 4f 4a 4e | 4f 05 00 07 00 08 04 0e |...PROJN|O.......|
|000002a0| 00 00 00 0a 04 05 00 00 | 00 09 04 00 00 00 00 0b |........|........|
|000002b0| 04 00 00 00 00 14 04 0c | 00 00 00 04 2f 18 00 00 |........|..../...|
|000002c0| 00 67 18 00 00 00 4c 24 | 04 1e 00 00 00 43 48 45 |.g....L$|.....CHE|
|000002d0| 43 4b 20 28 56 41 4c 55 | 45 20 3d 20 55 50 50 45 |CK (VALU|E = UPPE|
|000002e0| 52 20 28 56 41 4c 55 45 | 29 29 00 29 04 05 00 00 |R (VALUE|)).)....|
|000002f0| 00 2a 04 00 00 00 00 2b | 04 00 00 00 00 00 02 01 |.*.....+|........|
|00000300| 06 43 55 53 54 4e 4f 05 | 00 07 00 08 04 08 00 00 |.CUSTNO.|........|
|00000310| 00 0a 04 04 00 00 00 09 | 04 00 00 00 00 0b 04 00 |........|........|
|00000320| 00 00 00 14 04 0e 00 00 | 00 04 31 18 00 00 00 15 |........|..1.....|
|00000330| 08 00 e8 03 00 00 4c 24 | 04 15 00 00 00 43 48 45 |......L$|.....CHE|
|00000340| 43 4b 20 28 56 41 4c 55 | 45 20 3e 20 31 30 30 30 |CK (VALU|E > 1000|
|00000350| 29 00 00 02 01 07 4a 4f | 42 43 4f 44 45 05 00 07 |).....JO|BCODE...|
|00000360| 00 08 04 25 00 00 00 0a | 04 05 00 00 00 09 04 00 |...%....|........|
|00000370| 00 00 00 0b 04 00 00 00 | 00 14 04 12 00 00 00 04 |........|........|
|00000380| 31 18 00 00 00 15 0f 7f | 00 05 00 39 39 39 39 39 |1.......|...99999|
|00000390| 4c 24 04 18 00 00 00 43 | 48 45 43 4b 20 28 56 41 |L$.....C|HECK (VA|
|000003a0| 4c 55 45 20 3e 20 27 39 | 39 39 39 39 27 29 00 29 |LUE > '9|9999').)|
|000003b0| 04 05 00 00 00 2a 04 00 | 00 00 00 2b 04 00 00 00 |.....*..|...+....|
|000003c0| 00 00 02 01 08 4a 4f 42 | 47 52 41 44 45 05 00 07 |.....JOB|GRADE...|
|000003d0| 00 08 04 07 00 00 00 0a | 04 02 00 00 00 09 04 00 |........|........|
|000003e0| 00 00 00 0b 04 00 00 00 | 00 14 04 15 00 00 00 04 |........|........|
|000003f0| 38 18 00 00 00 15 08 00 | 00 00 00 00 15 08 00 06 |8.......|........|
|00000400| 00 00 00 4c 24 04 1e 00 | 00 00 43 48 45 43 4b 20 |...L$...|..CHECK |
|00000410| 28 56 41 4c 55 45 20 42 | 45 54 57 45 45 4e 20 30 |(VALUE B|ETWEEN 0|
|00000420| 20 41 4e 44 20 36 29 00 | 00 02 01 06 53 41 4c 41 | AND 6).|....SALA|
|00000430| 52 59 05 00 07 00 08 04 | 1b 00 00 00 0a 04 08 00 |RY......|........|
|00000440| 00 00 09 04 00 00 00 00 | 0b 04 fe ff ff ff 0f 04 |........|........|
|00000450| 09 00 00 00 04 15 08 00 | 00 00 00 00 4c 14 04 0e |........|....L...|
|00000460| 00 00 00 04 31 18 00 00 | 00 15 08 00 00 00 00 00 |....1...|........|
|00000470| 4c 24 04 12 00 00 00 43 | 48 45 43 4b 20 28 56 41 |L$.....C|HECK (VA|
|00000480| 4c 55 45 20 3e 20 30 29 | 00 27 04 0a 00 00 00 44 |LUE > 0)|.'.....D|
|00000490| 45 46 41 55 4c 54 20 30 | 00 00 02 01 06 42 55 44 |EFAULT 0|.....BUD|
|000004a0| 47 45 54 05 00 07 00 08 | 04 1b 00 00 00 0a 04 08 |GET.....|........|
|000004b0| 00 00 00 09 04 00 00 00 | 00 0b 04 fe ff ff ff 0f |........|........|
|000004c0| 04 09 00 00 00 04 15 08 | 00 50 c3 00 00 4c 14 04 |........|.P...L..|
|000004d0| 1b 00 00 00 04 3a 31 18 | 00 00 00 15 08 00 10 27 |.....:1.|.......'|
|000004e0| 00 00 34 18 00 00 00 15 | 08 00 80 84 1e 00 4c 24 |..4.....|......L$|
|000004f0| 04 2b 00 00 00 43 48 45 | 43 4b 20 28 56 41 4c 55 |.+...CHE|CK (VALU|
|00000500| 45 20 3e 20 31 30 30 30 | 30 20 41 4e 44 20 56 41 |E > 1000|0 AND VA|
|00000510| 4c 55 45 20 3c 3d 20 32 | 30 30 30 30 30 30 29 00 |LUE <= 2|000000).|
|00000520| 27 04 0e 00 00 00 44 45 | 46 41 55 4c 54 20 35 30 |'.....DE|FAULT 50|
|00000530| 30 30 30 00 00 02 01 08 | 50 52 4f 44 54 59 50 45 |000.....|PRODTYPE|
|00000540| 05 00 07 00 08 04 25 00 | 00 00 0a 04 0c 00 00 00 |......%.|........|
|00000550| 09 04 00 00 00 00 0b 04 | 00 00 00 00 0f 04 10 00 |........|........|
|00000560| 00 00 04 15 0f 7f 00 08 | 00 73 6f 66 74 77 61 72 |........|.softwar|
|00000570| 65 4c 14 04 49 00 00 00 | 04 39 39 39 2f 18 00 00 |eL..I...|.999/...|
|00000580| 00 15 0f 7f 00 08 00 73 | 6f 66 74 77 61 72 65 2f |.......s|oftware/|
|00000590| 18 00 00 00 15 0f 7f 00 | 08 00 68 61 72 64 77 61 |........|..hardwa|
|000005a0| 72 65 2f 18 00 00 00 15 | 0f 7f 00 05 00 6f 74 68 |re/.....|.....oth|
|000005b0| 65 72 2f 18 00 00 00 15 | 0f 7f 00 03 00 4e 2f 41 |er/.....|.....N/A|
|000005c0| 4c 24 04 3a 00 00 00 43 | 48 45 43 4b 20 28 56 41 |L$.:...C|HECK (VA|
|000005d0| 4c 55 45 20 49 4e 20 28 | 27 73 6f 66 74 77 61 72 |LUE IN (|'softwar|
|000005e0| 65 27 2c 20 27 68 61 72 | 64 77 61 72 65 27 2c 20 |e', 'har|dware', |
|000005f0| 27 6f 74 68 65 72 27 2c | 20 27 4e 2f 41 27 29 29 |'other',| 'N/A'))|
|00000600| 00 26 04 01 00 00 00 29 | 04 0c 00 00 00 27 04 13 |.&.....)|.....'..|
|00000610| 00 00 00 44 45 46 41 55 | 4c 54 20 27 73 6f 66 74 |...DEFAU|LT 'soft|
|00000620| 77 61 72 65 27 00 2a 04 | 00 00 00 00 2b 04 00 00 |ware'.*.|....+...|
|00000630| 00 00 00 02 01 08 50 4f | 4e 55 4d 42 45 52 05 00 |......PO|NUMBER..|
|00000640| 07 00 08 04 0e 00 00 00 | 0a 04 08 00 00 00 09 04 |........|........|
|00000650| 00 00 00 00 0b 04 00 00 | 00 00 14 04 0e 00 00 00 |........|........|
|00000660| 04 37 18 00 00 00 15 0f | 7f 00 01 00 56 4c 24 04 |.7......|....VL$.|
|00000670| 20 00 00 00 43 48 45 43 | 4b 20 28 56 41 4c 55 45 | ...CHEC|K (VALUE|
|00000680| 20 53 54 41 52 54 49 4e | 47 20 57 49 54 48 20 27 | STARTIN|G WITH '|
|00000690| 56 27 29 00 29 04 08 00 | 00 00 2a 04 00 00 00 00 |V').)...|..*.....|
|000006a0| 2b 04 00 00 00 00 00 02 | 01 05 52 44 42 24 31 05 |+.......|..RDB$1.|
|000006b0| 00 07 00 08 04 25 00 00 | 00 0a 04 0a 00 00 00 09 |.....%..|........|
|000006c0| 04 00 00 00 00 0b 04 00 | 00 00 00 29 04 0a 00 00 |........|...)....|
|000006d0| 00 2a 04 00 00 00 00 00 | 02 01 05 52 44 42 24 32 |.*......|...RDB$2|
|000006e0| 05 00 07 00 08 04 25 00 | 00 00 0a 04 19 00 00 00 |......%.|........|
|000006f0| 09 04 00 00 00 00 0b 04 | 00 00 00 00 29 04 19 00 |........|....)...|
|00000700| 00 00 2a 04 00 00 00 00 | 00 02 01 05 52 44 42 24 |..*.....|....RDB$|
|00000710| 33 05 00 07 00 08 04 05 | 01 00 00 0a 04 08 00 00 |3.......|........|
|00000720| 00 09 04 01 00 00 00 0b | 04 00 00 00 00 0c 04 90 |........|........|
|00000730| 01 00 00 2a 04 00 00 00 | 00 00 02 01 05 52 44 42 |...*....|.....RDB|
|00000740| 24 34 05 00 07 00 08 04 | 25 00 00 00 0a 04 0f 00 |$4......|%.......|
|00000750| 00 00 09 04 00 00 00 00 | 0b 04 00 00 00 00 1d 04 |........|........|
|00000760| 01 00 00 00 29 04 0f 00 | 00 00 2a 04 00 00 00 00 |....)...|..*.....|
|00000770| 00 02 01 05 52 44 42 24 | 35 05 00 07 00 08 04 25 |....RDB$|5......%|
|00000780| 00 00 00 0a 04 19 00 00 | 00 09 04 00 00 00 00 0b |........|........|
|00000790| 04 00 00 00 00 29 04 19 | 00 00 00 2a 04 00 00 00 |.....)..|...*....|
|000007a0| 00 00 02 01 05 52 44 42 | 24 36 05 00 07 00 08 04 |.....RDB|$6......|
|000007b0| 25 00 00 00 0a 04 0f 00 | 00 00 09 04 00 00 00 00 |%.......|........|
|000007c0| 0b 04 00 00 00 00 29 04 | 0f 00 00 00 2a 04 00 00 |......).|....*...|
|000007d0| 00 00 00 02 01 05 52 44 | 42 24 37 05 00 07 00 08 |......RD|B$7.....|
|000007e0| 04 25 00 00 00 0a 04 04 | 00 00 00 09 04 00 00 00 |.%......|........|
|000007f0| 00 0b 04 00 00 00 00 29 | 04 04 00 00 00 2a 04 00 |.......)|.....*..|
|00000800| 00 00 00 00 02 01 05 52 | 44 42 24 38 05 00 07 00 |.......R|DB$8....|
|00000810| 08 04 23 00 00 00 0a 04 | 08 00 00 00 09 04 00 00 |..#.....|........|
|00000820| 00 00 0b 04 00 00 00 00 | 00 02 01 05 52 44 42 24 |........|....RDB$|
|00000830| 39 05 00 07 00 08 04 25 | 00 00 00 0a 04 25 00 00 |9......%|.....%..|
|00000840| 00 09 04 00 00 00 00 0b | 04 00 00 00 00 12 04 25 |........|.......%|
|00000850| 00 00 00 04 27 27 17 00 | 09 4c 41 53 54 5f 4e 41 |....''..|.LAST_NA|
|00000860| 4d 45 15 0f 7f 00 02 00 | 2c 20 17 00 0a 46 49 52 |ME......|, ...FIR|
|00000870| 53 54 5f 4e 41 4d 45 4c | 25 04 22 00 00 00 28 6c |ST_NAMEL|%."...(l|
|00000880| 61 73 74 5f 6e 61 6d 65 | 20 7c 7c 20 27 2c 20 27 |ast_name| || ', '|
|00000890| 20 7c 7c 20 66 69 72 73 | 74 5f 6e 61 6d 65 29 00 | || firs|t_name).|
|000008a0| 29 04 00 00 00 00 2a 04 | 00 00 00 00 00 02 01 06 |).....*.|........|
|000008b0| 52 44 42 24 31 30 05 00 | 07 00 08 04 25 00 00 00 |RDB$10..|....%...|
|000008c0| 0a 04 14 00 00 00 09 04 | 00 00 00 00 0b 04 00 00 |........|........|
|000008d0| 00 00 29 04 14 00 00 00 | 2a 04 00 00 00 00 00 02 |..).....|*.......|
|000008e0| 01 06 52 44 42 24 31 31 | 05 00 07 00 08 04 05 01 |..RDB$11|........|
|000008f0| 00 00 0a 04 08 00 00 00 | 09 04 01 00 00 00 0b 04 |........|........|
|00000900| 00 00 00 00 0c 04 20 03 | 00 00 2a 04 00 00 00 00 |...... .|..*.....|
|00000910| 00 02 01 06 52 44 42 24 | 31 32 05 00 07 00 08 04 |....RDB$|12......|
|00000920| 08 00 00 00 0a 04 04 00 | 00 00 09 04 00 00 00 00 |........|........|
|00000930| 0b 04 00 00 00 00 00 02 | 01 06 52 44 42 24 31 33 |........|..RDB$13|
|00000940| 05 00 07 00 08 04 08 00 | 00 00 0a 04 04 00 00 00 |........|........|
|00000950| 09 04 00 00 00 00 0b 04 | 00 00 00 00 1d 04 01 00 |........|........|
|00000960| 00 00 00 02 01 06 52 44 | 42 24 31 34 05 00 07 00 |......RD|B$14....|
|00000970| 08 04 23 00 00 00 0a 04 | 08 00 00 00 09 04 00 00 |..#.....|........|
|00000980| 00 00 0b 04 00 00 00 00 | 00 02 01 06 52 44 42 24 |........|....RDB$|
|00000990| 31 35 05 00 07 00 08 04 | 25 00 00 00 0a 04 14 00 |15......|%.......|
|000009a0| 00 00 09 04 00 00 00 00 | 0b 04 00 00 00 00 29 04 |........|......).|
|000009b0| 14 00 00 00 2a 04 00 00 | 00 00 00 02 01 06 52 44 |....*...|......RD|
|000009c0| 42 24 31 36 05 00 07 00 | 08 04 1b 00 00 00 0a 04 |B$16....|........|
|000009d0| 08 00 00 00 09 04 00 00 | 00 00 0b 04 00 00 00 00 |........|........|
|000009e0| 00 02 01 06 52 44 42 24 | 31 37 05 00 07 00 08 04 |....RDB$|17......|
|000009f0| 1b 00 00 00 0a 04 08 00 | 00 00 09 04 00 00 00 00 |........|........|
|00000a00| 0b 04 00 00 00 00 12 04 | 37 00 00 00 04 22 17 00 |........|7...."..|
|00000a10| 0a 4f 4c 44 5f 53 41 4c | 41 52 59 25 24 17 00 0a |.OLD_SAL|ARY%$...|
|00000a20| 4f 4c 44 5f 53 41 4c 41 | 52 59 17 00 0e 50 45 52 |OLD_SALA|RY...PER|
|00000a30| 43 45 4e 54 5f 43 48 41 | 4e 47 45 15 08 00 64 00 |CENT_CHA|NGE...d.|
|00000a40| 00 00 4c 25 04 31 00 00 | 00 28 6f 6c 64 5f 73 61 |..L%.1..|.(old_sa|
|00000a50| 6c 61 72 79 20 2b 20 6f | 6c 64 5f 73 61 6c 61 72 |lary + o|ld_salar|
|00000a60| 79 20 2a 20 70 65 72 63 | 65 6e 74 5f 63 68 61 6e |y * perc|ent_chan|
|00000a70| 67 65 20 2f 20 31 30 30 | 29 00 00 02 01 06 52 44 |ge / 100|).....RD|
|00000a80| 42 24 31 38 05 00 07 00 | 08 04 25 00 00 00 0a 04 |B$18....|..%.....|
|00000a90| 19 00 00 00 09 04 00 00 | 00 00 0b 04 00 00 00 00 |........|........|
|00000aa0| 29 04 19 00 00 00 2a 04 | 00 00 00 00 00 02 01 06 |).....*.|........|
|00000ab0| 52 44 42 24 31 39 05 00 | 07 00 08 04 25 00 00 00 |RDB$19..|....%...|
|00000ac0| 0a 04 19 00 00 00 09 04 | 00 00 00 00 0b 04 00 00 |........|........|
|00000ad0| 00 00 29 04 19 00 00 00 | 2a 04 00 00 00 00 00 02 |..).....|*.......|
|00000ae0| 01 06 52 44 42 24 32 30 | 05 00 07 00 08 04 25 00 |..RDB$20|......%.|
|00000af0| 00 00 0a 04 0f 00 00 00 | 09 04 00 00 00 00 0b 04 |........|........|
|00000b00| 00 00 00 00 29 04 0f 00 | 00 00 2a 04 00 00 00 00 |....)...|..*.....|
|00000b10| 00 02 01 06 52 44 42 24 | 32 31 05 00 07 00 08 04 |....RDB$|21......|
|00000b20| 25 00 00 00 0a 04 0c 00 | 00 00 09 04 00 00 00 00 |%.......|........|
|00000b30| 0b 04 00 00 00 00 29 04 | 0c 00 00 00 2a 04 00 00 |......).|....*...|
|00000b40| 00 00 00 02 01 06 52 44 | 42 24 32 32 05 00 07 00 |......RD|B$22....|
|00000b50| 08 04 0e 00 00 00 0a 04 | 01 00 00 00 09 04 00 00 |........|........|
|00000b60| 00 00 0b 04 00 00 00 00 | 29 04 01 00 00 00 2a 04 |........|).....*.|
|00000b70| 00 00 00 00 00 02 01 06 | 52 44 42 24 32 33 05 00 |........|RDB$23..|
|00000b80| 07 00 08 04 25 00 00 00 | 0a 04 07 00 00 00 09 04 |....%...|........|
|00000b90| 00 00 00 00 0b 04 00 00 | 00 00 29 04 07 00 00 00 |........|..).....|
|00000ba0| 2a 04 00 00 00 00 00 02 | 01 06 52 44 42 24 32 34 |*.......|..RDB$24|
|00000bb0| 05 00 07 00 08 04 23 00 | 00 00 0a 04 08 00 00 00 |......#.|........|
|00000bc0| 09 04 00 00 00 00 0b 04 | 00 00 00 00 00 02 01 06 |........|........|
|00000bd0| 52 44 42 24 32 35 05 00 | 07 00 08 04 23 00 00 00 |RDB$25..|....#...|
|00000be0| 0a 04 08 00 00 00 09 04 | 00 00 00 00 0b 04 00 00 |........|........|
|00000bf0| 00 00 00 02 01 06 52 44 | 42 24 32 36 05 00 07 00 |......RD|B$26....|
|00000c00| 08 04 23 00 00 00 0a 04 | 08 00 00 00 09 04 00 00 |..#.....|........|
|00000c10| 00 00 0b 04 00 00 00 00 | 00 02 01 06 52 44 42 24 |........|....RDB$|
|00000c20| 32 37 05 00 07 00 08 04 | 0e 00 00 00 0a 04 01 00 |27......|........|
|00000c30| 00 00 09 04 00 00 00 00 | 0b 04 00 00 00 00 29 04 |........|......).|
|00000c40| 01 00 00 00 2a 04 00 00 | 00 00 00 02 01 06 52 44 |....*...|......RD|
|00000c50| 42 24 32 38 05 00 07 00 | 08 04 08 00 00 00 0a 04 |B$28....|........|
|00000c60| 04 00 00 00 09 04 00 00 | 00 00 0b 04 00 00 00 00 |........|........|
|00000c70| 00 02 01 06 52 44 42 24 | 32 39 05 00 07 00 08 04 |....RDB$|29......|
|00000c80| 08 00 00 00 0a 04 04 00 | 00 00 09 04 00 00 00 00 |........|........|
|00000c90| 0b 04 fe ff ff ff 00 02 | 01 06 52 44 42 24 33 30 |........|..RDB$30|
|00000ca0| 05 00 07 00 08 04 0a 00 | 00 00 0a 04 04 00 00 00 |........|........|
|00000cb0| 09 04 00 00 00 00 0b 04 | 00 00 00 00 00 02 01 06 |........|........|
|00000cc0| 52 44 42 24 33 31 05 00 | 07 00 08 04 1b 00 00 00 |RDB$31..|........|
|00000cd0| 0a 04 08 00 00 00 09 04 | 00 00 00 00 0b 04 00 00 |........|........|
|00000ce0| 00 00 12 04 1c 00 00 00 | 04 23 17 00 09 53 48 49 |........|.#...SHI|
|00000cf0| 50 5f 44 41 54 45 17 00 | 0a 4f 52 44 45 52 5f 44 |P_DATE..|.ORDER_D|
|00000d00| 41 54 45 4c 25 04 19 00 | 00 00 28 73 68 69 70 5f |ATEL%...|..(ship_|
|00000d10| 64 61 74 65 20 2d 20 6f | 72 64 65 72 5f 64 61 74 |date - o|rder_dat|
|00000d20| 65 29 00 00 02 01 06 52 | 44 42 24 33 32 05 00 07 |e).....R|DB$32...|
|00000d30| 00 08 04 07 00 00 00 0a | 04 02 00 00 00 09 04 00 |........|........|
|00000d40| 00 00 00 0b 04 00 00 00 | 00 00 02 01 06 52 44 42 |........|.....RDB|
|00000d50| 24 33 33 05 00 07 00 08 | 04 0e 00 00 00 0a 04 05 |$33.....|........|
|00000d60| 00 00 00 09 04 00 00 00 | 00 0b 04 00 00 00 00 29 |........|.......)|
|00000d70| 04 05 00 00 00 2a 04 00 | 00 00 00 2b 04 00 00 00 |.....*..|...+....|
|00000d80| 00 00 02 01 06 52 44 42 | 24 33 34 05 00 07 00 08 |.....RDB|$34.....|
|00000d90| 04 07 00 00 00 0a 04 02 | 00 00 00 09 04 00 00 00 |........|........|
|00000da0| 00 0b 04 00 00 00 00 00 | 02 01 06 52 44 42 24 33 |........|...RDB$3|
|00000db0| 35 05 00 07 00 08 04 0e | 00 00 00 0a 04 05 00 00 |5.......|........|
|00000dc0| 00 09 04 00 00 00 00 0b | 04 00 00 00 00 29 04 05 |........|.....)..|
|00000dd0| 00 00 00 2a 04 00 00 00 | 00 2b 04 00 00 00 00 00 |...*....|.+......|
|00000de0| 02 01 06 52 44 42 24 33 | 36 05 00 07 00 08 04 0e |...RDB$3|6.......|
|00000df0| 00 00 00 0a 04 03 00 00 | 00 09 04 00 00 00 00 0b |........|........|
|00000e00| 04 00 00 00 00 29 04 03 | 00 00 00 2a 04 00 00 00 |.....)..|...*....|
|00000e10| 00 2b 04 00 00 00 00 00 | 02 01 06 52 44 42 24 33 |.+......|...RDB$3|
|00000e20| 37 05 00 07 00 08 04 1b | 00 00 00 0a 04 08 00 00 |7.......|........|
|00000e30| 00 09 04 00 00 00 00 0b | 04 fe ff ff ff 00 02 01 |........|........|
|00000e40| 06 52 44 42 24 33 38 05 | 00 07 00 08 04 1b 00 00 |.RDB$38.|........|
|00000e50| 00 0a 04 08 00 00 00 09 | 04 00 00 00 00 0b 04 fe |........|........|
|00000e60| ff ff ff 00 02 01 06 52 | 44 42 24 33 39 05 00 07 |.......R|DB$39...|
|00000e70| 00 08 04 1b 00 00 00 0a | 04 08 00 00 00 09 04 00 |........|........|
|00000e80| 00 00 00 0b 04 fe ff ff | ff 00 02 01 06 52 44 42 |........|.....RDB|
|00000e90| 24 34 30 05 00 07 00 08 | 04 1b 00 00 00 0a 04 08 |$40.....|........|
|00000ea0| 00 00 00 09 04 00 00 00 | 00 0b 04 fe ff ff ff 00 |........|........|
|00000eb0| 02 01 06 52 44 42 24 34 | 31 05 00 07 00 08 04 08 |...RDB$4|1.......|
|00000ec0| 00 00 00 0a 04 04 00 00 | 00 09 04 00 00 00 00 0b |........|........|
|00000ed0| 04 00 00 00 00 00 02 01 | 06 52 44 42 24 34 32 05 |........|.RDB$42.|
|00000ee0| 00 07 00 08 04 0e 00 00 | 00 0a 04 03 00 00 00 09 |........|........|
|00000ef0| 04 00 00 00 00 0b 04 00 | 00 00 00 29 04 03 00 00 |........|...)....|
|00000f00| 00 2a 04 00 00 00 00 2b | 04 00 00 00 00 00 02 01 |.*.....+|........|
|00000f10| 06 52 44 42 24 34 33 05 | 00 07 00 08 04 1b 00 00 |.RDB$43.|........|
|00000f20| 00 0a 04 08 00 00 00 09 | 04 00 00 00 00 0b 04 fe |........|........|
|00000f30| ff ff ff 00 02 01 06 52 | 44 42 24 34 34 05 00 07 |.......R|DB$44...|
|00000f40| 00 08 04 0e 00 00 00 0a | 04 19 00 00 00 09 04 00 |........|........|
|00000f50| 00 00 00 0b 04 00 00 00 | 00 29 04 19 00 00 00 2a |........|.).....*|
|00000f60| 04 00 00 00 00 2b 04 00 | 00 00 00 00 02 01 06 52 |.....+..|.......R|
|00000f70| 44 42 24 34 35 05 00 07 | 00 08 04 0e 00 00 00 0a |DB$45...|........|
|00000f80| 04 19 00 00 00 09 04 00 | 00 00 00 0b 04 00 00 00 |........|........|
|00000f90| 00 29 04 19 00 00 00 2a | 04 00 00 00 00 2b 04 00 |.).....*|.....+..|
|00000fa0| 00 00 00 00 02 01 06 52 | 44 42 24 34 36 05 00 07 |.......R|DB$46...|
|00000fb0| 00 08 04 0e 00 00 00 0a | 04 14 00 00 00 09 04 00 |........|........|
|00000fc0| 00 00 00 0b 04 00 00 00 | 00 29 04 14 00 00 00 2a |........|.).....*|
|00000fd0| 04 00 00 00 00 2b 04 00 | 00 00 00 00 02 01 06 52 |.....+..|.......R|
|00000fe0| 44 42 24 34 37 05 00 07 | 00 08 04 0e 00 00 00 0a |DB$47...|........|
|00000ff0| 04 05 00 00 00 09 04 00 | 00 00 00 0b 04 00 00 00 |........|........|
|00001000| 00 29 04 05 00 00 00 2a | 04 00 00 00 00 2b 04 00 |.).....*|.....+..|
|00001010| 00 00 00 00 02 01 06 52 | 44 42 24 34 38 05 00 07 |.......R|DB$48...|
|00001020| 00 08 04 08 00 00 00 0a | 04 04 00 00 00 09 04 00 |........|........|
|00001030| 00 00 00 0b 04 00 00 00 | 00 00 02 01 06 52 44 42 |........|.....RDB|
|00001040| 24 34 39 05 00 07 00 08 | 04 08 00 00 00 0a 04 04 |$49.....|........|
|00001050| 00 00 00 09 04 00 00 00 | 00 0b 04 00 00 00 00 00 |........|........|
|00001060| 02 01 06 52 44 42 24 35 | 30 05 00 07 00 08 04 0e |...RDB$5|0.......|
|00001070| 00 00 00 0a 04 28 00 00 | 00 09 04 00 00 00 00 0b |.....(..|........|
|00001080| 04 00 00 00 00 29 04 28 | 00 00 00 2a 04 00 00 00 |.....).(|...*....|
|00001090| 00 2b 04 00 00 00 00 00 | 02 01 06 52 44 42 24 35 |.+......|...RDB$5|
|000010a0| 31 05 00 07 00 08 04 0e | 00 00 00 0a 04 28 00 00 |1.......|.....(..|
|000010b0| 00 09 04 00 00 00 00 0b | 04 00 00 00 00 29 04 28 |........|.....).(|
|000010c0| 00 00 00 2a 04 00 00 00 | 00 2b 04 00 00 00 00 00 |...*....|.+......|
|000010d0| 02 01 06 52 44 42 24 35 | 32 05 00 07 00 08 04 0e |...RDB$5|2.......|
|000010e0| 00 00 00 0a 04 28 00 00 | 00 09 04 00 00 00 00 0b |.....(..|........|
|000010f0| 04 00 00 00 00 29 04 28 | 00 00 00 2a 04 00 00 00 |.....).(|...*....|
|00001100| 00 2b 04 00 00 00 00 00 | 02 01 06 52 44 42 24 35 |.+......|...RDB$5|
|00001110| 33 05 00 07 00 08 04 0e | 00 00 00 0a 04 28 00 00 |3.......|.....(..|
|00001120| 00 09 04 00 00 00 00 0b | 04 00 00 00 00 29 04 28 |........|.....).(|
|00001130| 00 00 00 2a 04 00 00 00 | 00 2b 04 00 00 00 00 00 |...*....|.+......|
|00001140| 02 01 06 52 44 42 24 35 | 34 05 00 07 00 08 04 0e |...RDB$5|4.......|
|00001150| 00 00 00 0a 04 28 00 00 | 00 09 04 00 00 00 00 0b |.....(..|........|
|00001160| 04 00 00 00 00 29 04 28 | 00 00 00 2a 04 00 00 00 |.....).(|...*....|
|00001170| 00 2b 04 00 00 00 00 00 | 02 01 06 52 44 42 24 35 |.+......|...RDB$5|
|00001180| 35 05 00 07 00 08 04 0e | 00 00 00 0a 04 28 00 00 |5.......|.....(..|
|00001190| 00 09 04 00 00 00 00 0b | 04 00 00 00 00 29 04 28 |........|.....).(|
|000011a0| 00 00 00 2a 04 00 00 00 | 00 2b 04 00 00 00 00 00 |...*....|.+......|
|000011b0| 02 01 06 52 44 42 24 35 | 36 05 00 07 00 08 04 0e |...RDB$5|6.......|
|000011c0| 00 00 00 0a 04 08 00 00 | 00 09 04 00 00 00 00 0b |........|........|
|000011d0| 04 00 00 00 00 29 04 08 | 00 00 00 2a 04 00 00 00 |.....)..|...*....|
|000011e0| 00 2b 04 00 00 00 00 00 | 02 01 06 52 44 42 24 35 |.+......|...RDB$5|
|000011f0| 37 05 00 07 00 08 04 25 | 00 00 00 0a 04 05 00 00 |7......%|........|
|00001200| 00 09 04 00 00 00 00 0b | 04 00 00 00 00 29 04 05 |........|.....)..|
|00001210| 00 00 00 2a 04 00 00 00 | 00 2b 04 00 00 00 00 00 |...*....|.+......|
|00001220| 02 01 06 52 44 42 24 35 | 38 05 00 07 00 08 04 07 |...RDB$5|8.......|
|00001230| 00 00 00 0a 04 02 00 00 | 00 09 04 00 00 00 00 0b |........|........|
|00001240| 04 00 00 00 00 00 02 01 | 06 52 44 42 24 35 39 05 |........|.RDB$59.|
|00001250| 00 07 00 08 04 25 00 00 | 00 0a 04 0f 00 00 00 09 |.....%..|........|
|00001260| 04 00 00 00 00 0b 04 00 | 00 00 00 29 04 0f 00 00 |........|...)....|
|00001270| 00 2a 04 00 00 00 00 2b | 04 00 00 00 00 00 02 01 |.*.....+|........|
|00001280| 06 52 44 42 24 36 30 05 | 00 07 00 08 04 25 00 00 |.RDB$60.|.....%..|
|00001290| 00 0a 04 0f 00 00 00 09 | 04 00 00 00 00 0b 04 00 |........|........|
|000012a0| 00 00 00 29 04 0f 00 00 | 00 2a 04 00 00 00 00 2b |...)....|.*.....+|
|000012b0| 04 00 00 00 00 00 02 01 | 06 52 44 42 24 36 31 05 |........|.RDB$61.|
|000012c0| 00 07 00 08 04 25 00 00 | 00 0a 04 05 00 00 00 09 |.....%..|........|
|000012d0| 04 00 00 00 00 0b 04 00 | 00 00 00 29 04 05 00 00 |........|...)....|
|000012e0| 00 2a 04 00 00 00 00 2b | 04 00 00 00 00 00 02 01 |.*.....+|........|
|000012f0| 06 52 44 42 24 36 32 05 | 00 07 00 08 04 25 00 00 |.RDB$62.|.....%..|
|00001300| 00 0a 04 05 00 00 00 09 | 04 00 00 00 00 0b 04 00 |........|........|
|00001310| 00 00 00 29 04 05 00 00 | 00 2a 04 00 00 00 00 2b |...)....|.*.....+|
|00001320| 04 00 00 00 00 00 02 01 | 06 52 44 42 24 36 33 05 |........|.RDB$63.|
|00001330| 00 07 00 08 04 25 00 00 | 00 0a 04 0f 00 00 00 09 |.....%..|........|
|00001340| 04 00 00 00 00 0b 04 00 | 00 00 00 29 04 0f 00 00 |........|...)....|
|00001350| 00 2a 04 00 00 00 00 2b | 04 00 00 00 00 00 02 01 |.*.....+|........|
|00001360| 06 52 44 42 24 36 34 05 | 00 07 00 08 04 25 00 00 |.RDB$64.|.....%..|
|00001370| 00 0a 04 0f 00 00 00 09 | 04 00 00 00 00 0b 04 00 |........|........|
|00001380| 00 00 00 29 04 0f 00 00 | 00 2a 04 00 00 00 00 2b |...)....|.*.....+|
|00001390| 04 00 00 00 00 00 18 01 | 05 52 44 42 24 34 1d 04 |........|.RDB$4..|
|000013a0| 00 00 00 00 20 04 01 00 | 00 00 21 04 05 00 00 00 |.... ...|..!.....|
|000013b0| 00 18 01 06 52 44 42 24 | 31 33 1d 04 00 00 00 00 |....RDB$|13......|
|000013c0| 20 04 01 00 00 00 21 04 | 04 00 00 00 00 03 01 07 | .....!.|........|
|000013d0| 43 4f 55 4e 54 52 59 10 | 04 01 00 00 00 08 0b 53 |COUNTRY.|.......S|
|000013e0| 51 4c 24 43 4f 55 4e 54 | 52 59 0c 06 53 59 53 44 |QL$COUNT|RY..SYSD|
|000013f0| 42 41 00 04 01 08 43 55 | 52 52 45 4e 43 59 02 05 |BA....CU|RRENCY..|
|00001400| 52 44 42 24 31 0d 04 01 | 00 00 00 08 04 25 00 00 |RDB$1...|.....%..|
|00001410| 00 0a 04 0a 00 00 00 09 | 04 00 00 00 00 0b 04 00 |........|........|
|00001420| 00 00 00 16 04 02 00 00 | 00 18 04 00 00 00 00 22 |........|......."|
|00001430| 04 01 00 00 00 26 04 01 | 00 00 00 2a 04 00 00 00 |.....&..|...*....|
|00001440| 00 2b 04 00 00 00 00 00 | 04 01 07 43 4f 55 4e 54 |.+......|...COUNT|
|00001450| 52 59 02 0b 43 4f 55 4e | 54 52 59 4e 41 4d 45 0d |RY..COUN|TRYNAME.|
|00001460| 04 00 00 00 00 08 04 25 | 00 00 00 0a 04 0f 00 00 |.......%|........|
|00001470| 00 09 04 00 00 00 00 0b | 04 00 00 00 00 16 04 01 |........|........|
|00001480| 00 00 00 18 04 00 00 00 | 00 22 04 01 00 00 00 26 |........|.".....&|
|00001490| 04 01 00 00 00 2a 04 00 | 00 00 00 00 09 03 01 03 |.....*..|........|
|000014a0| 4a 4f 42 10 04 01 00 00 | 00 08 07 53 51 4c 24 4a |JOB.....|...SQL$J|
|000014b0| 4f 42 0c 06 53 59 53 44 | 42 41 00 04 01 0f 4a 4f |OB..SYSD|BA....JO|
|000014c0| 42 5f 52 45 51 55 49 52 | 45 4d 45 4e 54 02 05 52 |B_REQUIR|EMENT..R|
|000014d0| 44 42 24 33 0d 04 06 00 | 00 00 08 04 05 01 00 00 |DB$3....|........|
|000014e0| 0a 04 08 00 00 00 09 04 | 01 00 00 00 0b 04 00 00 |........|........|
|000014f0| 00 00 16 04 07 00 00 00 | 18 04 00 00 00 00 22 04 |........|......".|
|00001500| 01 00 00 00 2a 04 00 00 | 00 00 00 04 01 0a 4d 41 |....*...|......MA|
|00001510| 58 5f 53 41 4c 41 52 59 | 02 06 53 41 4c 41 52 59 |X_SALARY|..SALARY|
|00001520| 0d 04 05 00 00 00 08 04 | 1b 00 00 00 0a 04 08 00 |........|........|
|00001530| 00 00 09 04 00 00 00 00 | 0b 04 fe ff ff ff 16 04 |........|........|
|00001540| 06 00 00 00 18 04 00 00 | 00 00 22 04 01 00 00 00 |........|..".....|
|00001550| 26 04 01 00 00 00 00 04 | 01 0a 4d 49 4e 5f 53 41 |&.......|..MIN_SA|
|00001560| 4c 41 52 59 02 06 53 41 | 4c 41 52 59 0d 04 04 00 |LARY..SA|LARY....|
|00001570| 00 00 08 04 1b 00 00 00 | 0a 04 08 00 00 00 09 04 |........|........|
|00001580| 00 00 00 00 0b 04 fe ff | ff ff 16 04 05 00 00 00 |........|........|
|00001590| 18 04 00 00 00 00 22 04 | 01 00 00 00 26 04 01 00 |......".|....&...|
|000015a0| 00 00 00 04 01 09 4a 4f | 42 5f 47 52 41 44 45 02 |......JO|B_GRADE.|
|000015b0| 08 4a 4f 42 47 52 41 44 | 45 0d 04 01 00 00 00 08 |.JOBGRAD|E.......|
|000015c0| 04 07 00 00 00 0a 04 02 | 00 00 00 09 04 00 00 00 |........|........|
|000015d0| 00 0b 04 00 00 00 00 16 | 04 02 00 00 00 18 04 00 |........|........|
|000015e0| 00 00 00 22 04 01 00 00 | 00 26 04 01 00 00 00 00 |..."....|.&......|
|000015f0| 04 01 0c 4c 41 4e 47 55 | 41 47 45 5f 52 45 51 02 |...LANGU|AGE_REQ.|
|00001600| 05 52 44 42 24 34 0d 04 | 07 00 00 00 08 04 25 00 |.RDB$4..|......%.|
|00001610| 00 00 0a 04 0f 00 00 00 | 09 04 00 00 00 00 0b 04 |........|........|
|00001620| 00 00 00 00 16 04 08 00 | 00 00 18 04 00 00 00 00 |........|........|
|00001630| 22 04 01 00 00 00 2a 04 | 00 00 00 00 2b 04 00 00 |".....*.|....+...|
|00001640| 00 00 1d 04 01 00 00 00 | 20 04 01 00 00 00 21 04 |........| .....!.|
|00001650| 05 00 00 00 00 04 01 09 | 4a 4f 42 5f 54 49 54 4c |........|JOB_TITL|
|00001660| 45 02 05 52 44 42 24 32 | 0d 04 03 00 00 00 08 04 |E..RDB$2|........|
|00001670| 25 00 00 00 0a 04 19 00 | 00 00 09 04 00 00 00 00 |%.......|........|
|00001680| 0b 04 00 00 00 00 16 04 | 04 00 00 00 18 04 00 00 |........|........|
|00001690| 00 00 22 04 01 00 00 00 | 26 04 01 00 00 00 2a 04 |..".....|&.....*.|
|000016a0| 00 00 00 00 2b 04 00 00 | 00 00 00 04 01 0b 4a 4f |....+...|......JO|
|000016b0| 42 5f 43 4f 55 4e 54 52 | 59 02 0b 43 4f 55 4e 54 |B_COUNTR|Y..COUNT|
|000016c0| 52 59 4e 41 4d 45 0d 04 | 02 00 00 00 08 04 25 00 |RYNAME..|......%.|
|000016d0| 00 00 0a 04 0f 00 00 00 | 09 04 00 00 00 00 0b 04 |........|........|
|000016e0| 00 00 00 00 16 04 03 00 | 00 00 18 04 00 00 00 00 |........|........|
|000016f0| 22 04 01 00 00 00 26 04 | 01 00 00 00 2a 04 00 00 |".....&.|....*...|
|00001700| 00 00 00 04 01 08 4a 4f | 42 5f 43 4f 44 45 02 07 |......JO|B_CODE..|
|00001710| 4a 4f 42 43 4f 44 45 0d | 04 00 00 00 00 08 04 25 |JOBCODE.|.......%|
|00001720| 00 00 00 0a 04 05 00 00 | 00 09 04 00 00 00 00 0b |........|........|
|00001730| 04 00 00 00 00 16 04 01 | 00 00 00 18 04 00 00 00 |........|........|
|00001740| 00 22 04 01 00 00 00 26 | 04 01 00 00 00 2a 04 00 |.".....&|.....*..|
|00001750| 00 00 00 00 09 03 01 0a | 44 45 50 41 52 54 4d 45 |........|DEPARTME|
|00001760| 4e 54 10 04 01 00 00 00 | 08 0e 53 51 4c 24 44 45 |NT......|..SQL$DE|
|00001770| 50 41 52 54 4d 45 4e 54 | 0c 06 53 59 53 44 42 41 |PARTMENT|..SYSDBA|
|00001780| 00 04 01 06 42 55 44 47 | 45 54 02 06 42 55 44 47 |....BUDG|ET..BUDG|
|00001790| 45 54 0d 04 04 00 00 00 | 08 04 1b 00 00 00 0a 04 |ET......|........|
|000017a0| 08 00 00 00 09 04 00 00 | 00 00 0b 04 fe ff ff ff |........|........|
|000017b0| 16 04 05 00 00 00 18 04 | 00 00 00 00 22 04 01 00 |........|...."...|
|000017c0| 00 00 00 04 01 08 50 48 | 4f 4e 45 5f 4e 4f 02 0b |......PH|ONE_NO..|
|000017d0| 50 48 4f 4e 45 4e 55 4d | 42 45 52 0d 04 06 00 00 |PHONENUM|BER.....|
|000017e0| 00 08 04 25 00 00 00 0a | 04 14 00 00 00 09 04 00 |...%....|........|
|000017f0| 00 00 00 0b 04 00 00 00 | 00 16 04 07 00 00 00 18 |........|........|
|00001800| 04 00 00 00 00 22 04 01 | 00 00 00 2a 04 00 00 00 |....."..|...*....|
|00001810| 00 0f 04 10 00 00 00 04 | 15 0f 7f 00 08 00 35 35 |........|......55|
|00001820| 35 2d 31 32 33 34 4c 27 | 04 14 00 00 00 20 44 45 |5-1234L'|..... DE|
|00001830| 46 41 55 4c 54 20 27 35 | 35 35 2d 31 32 33 34 27 |FAULT '5|55-1234'|
|00001840| 00 00 04 01 07 4d 4e 47 | 52 5f 4e 4f 02 05 45 4d |.....MNG|R_NO..EM|
|00001850| 50 4e 4f 0d 04 03 00 00 | 00 08 04 07 00 00 00 0a |PNO.....|........|
|00001860| 04 02 00 00 00 09 04 00 | 00 00 00 0b 04 00 00 00 |........|........|
|00001870| 00 16 04 04 00 00 00 18 | 04 00 00 00 00 22 04 01 |........|....."..|
|00001880| 00 00 00 00 04 01 08 4c | 4f 43 41 54 49 4f 4e 02 |.......L|OCATION.|
|00001890| 05 52 44 42 24 36 0d 04 | 05 00 00 00 08 04 25 00 |.RDB$6..|......%.|
|000018a0| 00 00 0a 04 0f 00 00 00 | 09 04 00 00 00 00 0b 04 |........|........|
|000018b0| 00 00 00 00 16 04 06 00 | 00 00 18 04 00 00 00 00 |........|........|
|000018c0| 22 04 01 00 00 00 2a 04 | 00 00 00 00 2b 04 00 00 |".....*.|....+...|
|000018d0| 00 00 00 04 01 09 48 45 | 41 44 5f 44 45 50 54 02 |......HE|AD_DEPT.|
|000018e0| 06 44 45 50 54 4e 4f 0d | 04 02 00 00 00 08 04 0e |.DEPTNO.|........|
|000018f0| 00 00 00 0a 04 03 00 00 | 00 09 04 00 00 00 00 0b |........|........|
|00001900| 04 00 00 00 00 16 04 03 | 00 00 00 18 04 00 00 00 |........|........|
|00001910| 00 22 04 01 00 00 00 2a | 04 00 00 00 00 00 04 01 |.".....*|........|
|00001920| 0a 44 45 50 41 52 54 4d | 45 4e 54 02 05 52 44 42 |.DEPARTM|ENT..RDB|
|00001930| 24 35 0d 04 01 00 00 00 | 08 04 25 00 00 00 0a 04 |$5......|..%.....|
|00001940| 19 00 00 00 09 04 00 00 | 00 00 0b 04 00 00 00 00 |........|........|
|00001950| 16 04 02 00 00 00 18 04 | 00 00 00 00 22 04 01 00 |........|...."...|
|00001960| 00 00 26 04 01 00 00 00 | 2a 04 00 00 00 00 2b 04 |..&.....|*.....+.|
|00001970| 00 00 00 00 00 04 01 07 | 44 45 50 54 5f 4e 4f 02 |........|DEPT_NO.|
|00001980| 06 44 45 50 54 4e 4f 0d | 04 00 00 00 00 08 04 0e |.DEPTNO.|........|
|00001990| 00 00 00 0a 04 03 00 00 | 00 09 04 00 00 00 00 0b |........|........|
|000019a0| 04 00 00 00 00 16 04 01 | 00 00 00 18 04 00 00 00 |........|........|
|000019b0| 00 22 04 01 00 00 00 26 | 04 01 00 00 00 2a 04 00 |.".....&|.....*..|
|000019c0| 00 00 00 00 09 03 01 08 | 45 4d 50 4c 4f 59 45 45 |........|EMPLOYEE|
|000019d0| 10 04 01 00 00 00 08 0c | 53 51 4c 24 45 4d 50 4c |........|SQL$EMPL|
|000019e0| 4f 59 45 45 0c 06 53 59 | 53 44 42 41 00 04 01 06 |OYEE..SY|SDBA....|
|000019f0| 53 41 4c 41 52 59 02 06 | 53 41 4c 41 52 59 0d 04 |SALARY..|SALARY..|
|00001a00| 09 00 00 00 08 04 1b 00 | 00 00 0a 04 08 00 00 00 |........|........|
|00001a10| 09 04 00 00 00 00 0b 04 | fe ff ff ff 16 04 0a 00 |........|........|
|00001a20| 00 00 18 04 00 00 00 00 | 22 04 01 00 00 00 26 04 |........|".....&.|
|00001a30| 01 00 00 00 00 04 01 09 | 48 49 52 45 5f 44 41 54 |........|HIRE_DAT|
|00001a40| 45 02 05 52 44 42 24 38 | 0d 04 04 00 00 00 08 04 |E..RDB$8|........|
|00001a50| 23 00 00 00 0a 04 08 00 | 00 00 09 04 00 00 00 00 |#.......|........|
|00001a60| 0b 04 00 00 00 00 16 04 | 05 00 00 00 18 04 00 00 |........|........|
|00001a70| 00 00 22 04 01 00 00 00 | 26 04 01 00 00 00 0f 04 |..".....|&.......|
|00001a80| 0b 00 00 00 04 15 0f 7f | 00 03 00 4e 4f 57 4c 27 |........|...NOWL'|
|00001a90| 04 0e 00 00 00 44 45 46 | 41 55 4c 54 20 27 4e 4f |.....DEF|AULT 'NO|
|00001aa0| 57 27 00 00 04 01 09 4a | 4f 42 5f 47 52 41 44 45 |W'.....J|OB_GRADE|
|00001ab0| 02 08 4a 4f 42 47 52 41 | 44 45 0d 04 07 00 00 00 |..JOBGRA|DE......|
|00001ac0| 08 04 07 00 00 00 0a 04 | 02 00 00 00 09 04 00 00 |........|........|
|00001ad0| 00 00 0b 04 00 00 00 00 | 16 04 08 00 00 00 18 04 |........|........|
|00001ae0| 00 00 00 00 22 04 01 00 | 00 00 26 04 01 00 00 00 |...."...|..&.....|
|00001af0| 00 04 01 09 50 48 4f 4e | 45 5f 45 58 54 02 05 52 |....PHON|E_EXT..R|
|00001b00| 44 42 24 37 0d 04 03 00 | 00 00 08 04 25 00 00 00 |DB$7....|....%...|
|00001b10| 0a 04 04 00 00 00 09 04 | 00 00 00 00 0b 04 00 00 |........|........|
|00001b20| 00 00 16 04 04 00 00 00 | 18 04 00 00 00 00 22 04 |........|......".|
|00001b30| 01 00 00 00 2a 04 00 00 | 00 00 2b 04 00 00 00 00 |....*...|..+.....|
|00001b40| 00 04 01 09 4c 41 53 54 | 5f 4e 41 4d 45 02 08 4c |....LAST|_NAME..L|
|00001b50| 41 53 54 4e 41 4d 45 0d | 04 02 00 00 00 08 04 25 |ASTNAME.|.......%|
|00001b60| 00 00 00 0a 04 14 00 00 | 00 09 04 00 00 00 00 0b |........|........|
|00001b70| 04 00 00 00 00 16 04 03 | 00 00 00 18 04 00 00 00 |........|........|
|00001b80| 00 22 04 01 00 00 00 26 | 04 01 00 00 00 2a 04 00 |.".....&|.....*..|
|00001b90| 00 00 00 00 04 01 06 45 | 4d 50 5f 4e 4f 02 05 45 |.......E|MP_NO..E|
|00001ba0| 4d 50 4e 4f 0d 04 00 00 | 00 00 08 04 07 00 00 00 |MPNO....|........|
|00001bb0| 0a 04 02 00 00 00 09 04 | 00 00 00 00 0b 04 00 00 |........|........|
|00001bc0| 00 00 16 04 01 00 00 00 | 18 04 00 00 00 00 22 04 |........|......".|
|00001bd0| 01 00 00 00 26 04 01 00 | 00 00 00 04 01 09 46 55 |....&...|......FU|
|00001be0| 4c 4c 5f 4e 41 4d 45 02 | 05 52 44 42 24 39 0d 04 |LL_NAME.|.RDB$9..|
|00001bf0| 0a 00 00 00 08 04 25 00 | 00 00 0a 04 25 00 00 00 |......%.|....%...|
|00001c00| 09 04 00 00 00 00 0b 04 | 00 00 00 00 16 04 0b 00 |........|........|
|00001c10| 00 00 18 04 00 00 00 00 | 22 04 00 00 00 00 2a 04 |........|".....*.|
|00001c20| 00 00 00 00 2b 04 00 00 | 00 00 17 04 01 00 00 00 |....+...|........|
|00001c30| 00 04 01 0b 4a 4f 42 5f | 43 4f 55 4e 54 52 59 02 |....JOB_|COUNTRY.|
|00001c40| 0b 43 4f 55 4e 54 52 59 | 4e 41 4d 45 0d 04 08 00 |.COUNTRY|NAME....|
|00001c50| 00 00 08 04 25 00 00 00 | 0a 04 0f 00 00 00 09 04 |....%...|........|
|00001c60| 00 00 00 00 0b 04 00 00 | 00 00 16 04 09 00 00 00 |........|........|
|00001c70| 18 04 00 00 00 00 22 04 | 01 00 00 00 26 04 01 00 |......".|....&...|
|00001c80| 00 00 2a 04 00 00 00 00 | 00 04 01 08 4a 4f 42 5f |..*.....|....JOB_|
|00001c90| 43 4f 44 45 02 07 4a 4f | 42 43 4f 44 45 0d 04 06 |CODE..JO|BCODE...|
|00001ca0| 00 00 00 08 04 25 00 00 | 00 0a 04 05 00 00 00 09 |.....%..|........|
|00001cb0| 04 00 00 00 00 0b 04 00 | 00 00 00 16 04 07 00 00 |........|........|
|00001cc0| 00 18 04 00 00 00 00 22 | 04 01 00 00 00 26 04 01 |......."|.....&..|
|00001cd0| 00 00 00 2a 04 00 00 00 | 00 00 04 01 07 44 45 50 |...*....|.....DEP|
|00001ce0| 54 5f 4e 4f 02 06 44 45 | 50 54 4e 4f 0d 04 05 00 |T_NO..DE|PTNO....|
|00001cf0| 00 00 08 04 0e 00 00 00 | 0a 04 03 00 00 00 09 04 |........|........|
|00001d00| 00 00 00 00 0b 04 00 00 | 00 00 16 04 06 00 00 00 |........|........|
|00001d10| 18 04 00 00 00 00 22 04 | 01 00 00 00 26 04 01 00 |......".|....&...|
|00001d20| 00 00 2a 04 00 00 00 00 | 00 04 01 0a 46 49 52 53 |..*.....|....FIRS|
|00001d30| 54 5f 4e 41 4d 45 02 09 | 46 49 52 53 54 4e 41 4d |T_NAME..|FIRSTNAM|
|00001d40| 45 0d 04 01 00 00 00 08 | 04 25 00 00 00 0a 04 0f |E.......|.%......|
|00001d50| 00 00 00 09 04 00 00 00 | 00 0b 04 00 00 00 00 16 |........|........|
|00001d60| 04 02 00 00 00 18 04 00 | 00 00 00 22 04 01 00 00 |........|..."....|
|00001d70| 00 26 04 01 00 00 00 2a | 04 00 00 00 00 00 09 03 |.&.....*|........|
|00001d80| 01 0a 50 48 4f 4e 45 5f | 4c 49 53 54 02 04 33 00 |..PHONE_|LIST..3.|
|00001d90| 00 00 04 43 02 4a 08 45 | 4d 50 4c 4f 59 45 45 01 |...C.J.E|MPLOYEE.|
|00001da0| 4a 0a 44 45 50 41 52 54 | 4d 45 4e 54 02 47 2f 17 |J.DEPART|MENT.G/.|
|00001db0| 01 07 44 45 50 54 5f 4e | 4f 17 02 07 44 45 50 54 |..DEPT_N|O...DEPT|
|00001dc0| 5f 4e 4f ff 4c 10 04 01 | 00 00 00 08 0e 53 51 4c |_NO.L...|.....SQL|
|00001dd0| 24 50 48 4f 4e 45 5f 4c | 49 53 54 0e 04 97 00 00 |$PHONE_L|IST.....|
|00001de0| 00 20 53 45 4c 45 43 54 | 0a 20 20 20 20 65 6d 70 |. SELECT|.    emp|
|00001df0| 5f 6e 6f 2c 20 66 69 72 | 73 74 5f 6e 61 6d 65 2c |_no, fir|st_name,|
|00001e00| 20 6c 61 73 74 5f 6e 61 | 6d 65 2c 20 70 68 6f 6e | last_na|me, phon|
|00001e10| 65 5f 65 78 74 2c 20 6c | 6f 63 61 74 69 6f 6e 2c |e_ext, l|ocation,|
|00001e20| 20 70 68 6f 6e 65 5f 6e | 6f 0a 20 20 20 20 46 52 | phone_n|o.    FR|
|00001e30| 4f 4d 20 65 6d 70 6c 6f | 79 65 65 2c 20 64 65 70 |OM emplo|yee, dep|
|00001e40| 61 72 74 6d 65 6e 74 0a | 20 20 20 20 57 48 45 52 |artment.|    WHER|
|00001e50| 45 20 65 6d 70 6c 6f 79 | 65 65 2e 64 65 70 74 5f |E employ|ee.dept_|
|00001e60| 6e 6f 20 3d 20 64 65 70 | 61 72 74 6d 65 6e 74 2e |no = dep|artment.|
|00001e70| 64 65 70 74 5f 6e 6f 00 | 0c 06 53 59 53 44 42 41 |dept_no.|..SYSDBA|
|00001e80| 00 04 01 08 50 48 4f 4e | 45 5f 4e 4f 02 0b 50 48 |....PHON|E_NO..PH|
|00001e90| 4f 4e 45 4e 55 4d 42 45 | 52 0d 04 05 00 00 00 08 |ONENUMBE|R.......|
|00001ea0| 04 25 00 00 00 0a 04 14 | 00 00 00 09 04 00 00 00 |.%......|........|
|00001eb0| 00 0b 04 00 00 00 00 16 | 04 06 00 00 00 18 04 00 |........|........|
|00001ec0| 00 00 00 22 04 00 00 00 | 00 2a 04 00 00 00 00 04 |..."....|.*......|
|00001ed0| 04 02 00 00 00 03 08 50 | 48 4f 4e 45 5f 4e 4f 00 |.......P|HONE_NO.|
|00001ee0| 04 01 09 50 48 4f 4e 45 | 5f 45 58 54 02 05 52 44 |...PHONE|_EXT..RD|
|00001ef0| 42 24 37 0d 04 03 00 00 | 00 08 04 25 00 00 00 0a |B$7.....|...%....|
|00001f00| 04 04 00 00 00 09 04 00 | 00 00 00 0b 04 00 00 00 |........|........|
|00001f10| 00 16 04 04 00 00 00 18 | 04 00 00 00 00 22 04 00 |........|....."..|
|00001f20| 00 00 00 2a 04 00 00 00 | 00 04 04 01 00 00 00 03 |...*....|........|
|00001f30| 09 50 48 4f 4e 45 5f 45 | 58 54 00 04 01 09 4c 41 |.PHONE_E|XT....LA|
|00001f40| 53 54 5f 4e 41 4d 45 02 | 08 4c 41 53 54 4e 41 4d |ST_NAME.|.LASTNAM|
|00001f50| 45 0d 04 02 00 00 00 08 | 04 25 00 00 00 0a 04 14 |E.......|.%......|
|00001f60| 00 00 00 09 04 00 00 00 | 00 0b 04 00 00 00 00 16 |........|........|
|00001f70| 04 03 00 00 00 18 04 00 | 00 00 00 22 04 00 00 00 |........|..."....|
|00001f80| 00 2a 04 00 00 00 00 04 | 04 01 00 00 00 03 09 4c |.*......|.......L|
|00001f90| 41 53 54 5f 4e 41 4d 45 | 00 04 01 06 45 4d 50 5f |AST_NAME|....EMP_|
|00001fa0| 4e 4f 02 05 45 4d 50 4e | 4f 0d 04 00 00 00 00 08 |NO..EMPN|O.......|
|00001fb0| 04 07 00 00 00 0a 04 02 | 00 00 00 09 04 00 00 00 |........|........|
|00001fc0| 00 0b 04 00 00 00 00 16 | 04 01 00 00 00 18 04 00 |........|........|
|00001fd0| 00 00 00 22 04 00 00 00 | 00 04 04 01 00 00 00 03 |..."....|........|
|00001fe0| 06 45 4d 50 5f 4e 4f 00 | 04 01 08 4c 4f 43 41 54 |.EMP_NO.|...LOCAT|
|00001ff0| 49 4f 4e 02 05 52 44 42 | 24 36 0d 04 04 00 00 00 |ION..RDB|$6......|
|00002000| 08 04 25 00 00 00 0a 04 | 0f 00 00 00 09 04 00 00 |..%.....|........|
|00002010| 00 00 0b 04 00 00 00 00 | 16 04 05 00 00 00 18 04 |........|........|
|00002020| 00 00 00 00 22 04 00 00 | 00 00 2a 04 00 00 00 00 |...."...|..*.....|
|00002030| 04 04 02 00 00 00 03 08 | 4c 4f 43 41 54 49 4f 4e |........|LOCATION|
|00002040| 00 04 01 0a 46 49 52 53 | 54 5f 4e 41 4d 45 02 09 |....FIRS|T_NAME..|
|00002050| 46 49 52 53 54 4e 41 4d | 45 0d 04 01 00 00 00 08 |FIRSTNAM|E.......|
|00002060| 04 25 00 00 00 0a 04 0f | 00 00 00 09 04 00 00 00 |.%......|........|
|00002070| 00 0b 04 00 00 00 00 16 | 04 02 00 00 00 18 04 00 |........|........|
|00002080| 00 00 00 22 04 00 00 00 | 00 2a 04 00 00 00 00 04 |..."....|.*......|
|00002090| 04 01 00 00 00 03 0a 46 | 49 52 53 54 5f 4e 41 4d |.......F|IRST_NAM|
|000020a0| 45 00 0b 08 0a 44 45 50 | 41 52 54 4d 45 4e 54 09 |E....DEP|ARTMENT.|
|000020b0| 04 02 00 00 00 0a 0a 44 | 45 50 41 52 54 4d 45 4e |.......D|EPARTMEN|
|000020c0| 54 00 0b 08 08 45 4d 50 | 4c 4f 59 45 45 09 04 01 |T....EMP|LOYEE...|
|000020d0| 00 00 00 0a 08 45 4d 50 | 4c 4f 59 45 45 00 09 03 |.....EMP|LOYEE...|
|000020e0| 01 07 50 52 4f 4a 45 43 | 54 10 04 01 00 00 00 08 |..PROJEC|T.......|
|000020f0| 0b 53 51 4c 24 50 52 4f | 4a 45 43 54 0c 06 53 59 |.SQL$PRO|JECT..SY|
|00002100| 53 44 42 41 00 04 01 09 | 50 52 4f 4a 5f 44 45 53 |SDBA....|PROJ_DES|
|00002110| 43 02 06 52 44 42 24 31 | 31 0d 04 02 00 00 00 08 |C..RDB$1|1.......|
|00002120| 04 05 01 00 00 0a 04 08 | 00 00 00 09 04 01 00 00 |........|........|
|00002130| 00 0b 04 00 00 00 00 16 | 04 03 00 00 00 18 04 00 |........|........|
|00002140| 00 00 00 22 04 01 00 00 | 00 2a 04 00 00 00 00 00 |..."....|.*......|
|00002150| 04 01 07 50 52 4f 44 55 | 43 54 02 08 50 52 4f 44 |...PRODU|CT..PROD|
|00002160| 54 59 50 45 0d 04 04 00 | 00 00 08 04 25 00 00 00 |TYPE....|....%...|
|00002170| 0a 04 0c 00 00 00 09 04 | 00 00 00 00 0b 04 00 00 |........|........|
|00002180| 00 00 16 04 05 00 00 00 | 18 04 00 00 00 00 22 04 |........|......".|
|00002190| 01 00 00 00 2a 04 00 00 | 00 00 00 04 01 0b 54 45 |....*...|......TE|
|000021a0| 41 4d 5f 4c 45 41 44 45 | 52 02 05 45 4d 50 4e 4f |AM_LEADE|R..EMPNO|
|000021b0| 0d 04 03 00 00 00 08 04 | 07 00 00 00 0a 04 02 00 |........|........|
|000021c0| 00 00 09 04 00 00 00 00 | 0b 04 00 00 00 00 16 04 |........|........|
|000021d0| 04 00 00 00 18 04 00 00 | 00 00 22 04 01 00 00 00 |........|..".....|
|000021e0| 00 04 01 09 50 52 4f 4a | 5f 4e 41 4d 45 02 06 52 |....PROJ|_NAME..R|
|000021f0| 44 42 24 31 30 0d 04 01 | 00 00 00 08 04 25 00 00 |DB$10...|.....%..|
|00002200| 00 0a 04 14 00 00 00 09 | 04 00 00 00 00 0b 04 00 |........|........|
|00002210| 00 00 00 16 04 02 00 00 | 00 18 04 00 00 00 00 22 |........|......."|
|00002220| 04 01 00 00 00 26 04 01 | 00 00 00 2a 04 00 00 00 |.....&..|...*....|
|00002230| 00 2b 04 00 00 00 00 00 | 04 01 07 50 52 4f 4a 5f |.+......|...PROJ_|
|00002240| 49 44 02 06 50 52 4f 4a | 4e 4f 0d 04 00 00 00 00 |ID..PROJ|NO......|
|00002250| 08 04 0e 00 00 00 0a 04 | 05 00 00 00 09 04 00 00 |........|........|
|00002260| 00 00 0b 04 00 00 00 00 | 16 04 01 00 00 00 18 04 |........|........|
|00002270| 00 00 00 00 22 04 01 00 | 00 00 26 04 01 00 00 00 |...."...|..&.....|
|00002280| 2a 04 00 00 00 00 00 09 | 03 01 08 43 55 53 54 4f |*.......|...CUSTO|
|00002290| 4d 45 52 10 04 01 00 00 | 00 08 0c 53 51 4c 24 43 |MER.....|...SQL$C|
|000022a0| 55 53 54 4f 4d 45 52 0c | 06 53 59 53 44 42 41 00 |USTOMER.|.SYSDBA.|
|000022b0| 04 01 0d 41 44 44 52 45 | 53 53 5f 4c 49 4e 45 32 |...ADDRE|SS_LINE2|
|000022c0| 02 0b 41 44 44 52 45 53 | 53 4c 49 4e 45 0d 04 06 |..ADDRES|SLINE...|
|000022d0| 00 00 00 08 04 25 00 00 | 00 0a 04 1e 00 00 00 09 |.....%..|........|
|000022e0| 04 00 00 00 00 0b 04 00 | 00 00 00 16 04 07 00 00 |........|........|
|000022f0| 00 18 04 00 00 00 00 22 | 04 01 00 00 00 2a 04 00 |......."|.....*..|
|00002300| 00 00 00 00 04 01 0d 41 | 44 44 52 45 53 53 5f 4c |.......A|DDRESS_L|
|00002310| 49 4e 45 31 02 0b 41 44 | 44 52 45 53 53 4c 49 4e |INE1..AD|DRESSLIN|
|00002320| 45 0d 04 05 00 00 00 08 | 04 25 00 00 00 0a 04 1e |E.......|.%......|
|00002330| 00 00 00 09 04 00 00 00 | 00 0b 04 00 00 00 00 16 |........|........|
|00002340| 04 06 00 00 00 18 04 00 | 00 00 00 22 04 01 00 00 |........|..."....|
|00002350| 00 2a 04 00 00 00 00 00 | 04 01 07 43 55 53 54 5f |.*......|...CUST_|
|00002360| 4e 4f 02 06 43 55 53 54 | 4e 4f 0d 04 00 00 00 00 |NO..CUST|NO......|
|00002370| 08 04 08 00 00 00 0a 04 | 04 00 00 00 09 04 00 00 |........|........|
|00002380| 00 00 0b 04 00 00 00 00 | 16 04 01 00 00 00 18 04 |........|........|
|00002390| 00 00 00 00 22 04 01 00 | 00 00 26 04 01 00 00 00 |...."...|..&.....|
|000023a0| 00 04 01 0b 50 4f 53 54 | 41 4c 5f 43 4f 44 45 02 |....POST|AL_CODE.|
|000023b0| 06 52 44 42 24 32 31 0d | 04 0a 00 00 00 08 04 25 |.RDB$21.|.......%|
|000023c0| 00 00 00 0a 04 0c 00 00 | 00 09 04 00 00 00 00 0b |........|........|
|000023d0| 04 00 00 00 00 16 04 0b | 00 00 00 18 04 00 00 00 |........|........|
|000023e0| 00 22 04 01 00 00 00 2a | 04 00 00 00 00 2b 04 00 |.".....*|.....+..|
|000023f0| 00 00 00 00 04 01 08 50 | 48 4f 4e 45 5f 4e 4f 02 |.......P|HONE_NO.|
|00002400| 0b 50 48 4f 4e 45 4e 55 | 4d 42 45 52 0d 04 04 00 |.PHONENU|MBER....|
|00002410| 00 00 08 04 25 00 00 00 | 0a 04 14 00 00 00 09 04 |....%...|........|
|00002420| 00 00 00 00 0b 04 00 00 | 00 00 16 04 05 00 00 00 |........|........|
|00002430| 18 04 00 00 00 00 22 04 | 01 00 00 00 2a 04 00 00 |......".|....*...|
|00002440| 00 00 00 04 01 0c 43 4f | 4e 54 41 43 54 5f 4c 41 |......CO|NTACT_LA|
|00002450| 53 54 02 08 4c 41 53 54 | 4e 41 4d 45 0d 04 03 00 |ST..LAST|NAME....|
|00002460| 00 00 08 04 25 00 00 00 | 0a 04 14 00 00 00 09 04 |....%...|........|
|00002470| 00 00 00 00 0b 04 00 00 | 00 00 16 04 04 00 00 00 |........|........|
|00002480| 18 04 00 00 00 00 22 04 | 01 00 00 00 2a 04 00 00 |......".|....*...|
|00002490| 00 00 00 04 01 07 4f 4e | 5f 48 4f 4c 44 02 06 52 |......ON|_HOLD..R|
|000024a0| 44 42 24 32 32 0d 04 0b | 00 00 00 08 04 0e 00 00 |DB$22...|........|
|000024b0| 00 0a 04 01 00 00 00 09 | 04 00 00 00 00 0b 04 00 |........|........|
|000024c0| 00 00 00 16 04 0c 00 00 | 00 18 04 00 00 00 00 22 |........|......."|
|000024d0| 04 01 00 00 00 2a 04 00 | 00 00 00 2b 04 00 00 00 |.....*..|...+....|
|000024e0| 00 0f 04 03 00 00 00 04 | 2d 4c 27 04 0d 00 00 00 |........|-L'.....|
|000024f0| 44 45 46 41 55 4c 54 20 | 4e 55 4c 4c 00 00 04 01 |DEFAULT |NULL....|
|00002500| 07 43 4f 55 4e 54 52 59 | 02 0b 43 4f 55 4e 54 52 |.COUNTRY|..COUNTR|
|00002510| 59 4e 41 4d 45 0d 04 09 | 00 00 00 08 04 25 00 00 |YNAME...|.....%..|
|00002520| 00 0a 04 0f 00 00 00 09 | 04 00 00 00 00 0b 04 00 |........|........|
|00002530| 00 00 00 16 04 0a 00 00 | 00 18 04 00 00 00 00 22 |........|......."|
|00002540| 04 01 00 00 00 2a 04 00 | 00 00 00 00 04 01 0e 53 |.....*..|.......S|
|00002550| 54 41 54 45 5f 50 52 4f | 56 49 4e 43 45 02 06 52 |TATE_PRO|VINCE..R|
|00002560| 44 42 24 32 30 0d 04 08 | 00 00 00 08 04 25 00 00 |DB$20...|.....%..|
|00002570| 00 0a 04 0f 00 00 00 09 | 04 00 00 00 00 0b 04 00 |........|........|
|00002580| 00 00 00 16 04 09 00 00 | 00 18 04 00 00 00 00 22 |........|......."|
|00002590| 04 01 00 00 00 2a 04 00 | 00 00 00 2b 04 00 00 00 |.....*..|...+....|
|000025a0| 00 00 04 01 04 43 49 54 | 59 02 06 52 44 42 24 31 |.....CIT|Y..RDB$1|
|000025b0| 39 0d 04 07 00 00 00 08 | 04 25 00 00 00 0a 04 19 |9.......|.%......|
|000025c0| 00 00 00 09 04 00 00 00 | 00 0b 04 00 00 00 00 16 |........|........|
|000025d0| 04 08 00 00 00 18 04 00 | 00 00 00 22 04 01 00 00 |........|..."....|
|000025e0| 00 2a 04 00 00 00 00 2b | 04 00 00 00 00 00 04 01 |.*.....+|........|
|000025f0| 0d 43 4f 4e 54 41 43 54 | 5f 46 49 52 53 54 02 09 |.CONTACT|_FIRST..|
|00002600| 46 49 52 53 54 4e 41 4d | 45 0d 04 02 00 00 00 08 |FIRSTNAM|E.......|
|00002610| 04 25 00 00 00 0a 04 0f | 00 00 00 09 04 00 00 00 |.%......|........|
|00002620| 00 0b 04 00 00 00 00 16 | 04 03 00 00 00 18 04 00 |........|........|
|00002630| 00 00 00 22 04 01 00 00 | 00 2a 04 00 00 00 00 00 |..."....|.*......|
|00002640| 04 01 08 43 55 53 54 4f | 4d 45 52 02 06 52 44 42 |...CUSTO|MER..RDB|
|00002650| 24 31 38 0d 04 01 00 00 | 00 08 04 25 00 00 00 0a |$18.....|...%....|
|00002660| 04 19 00 00 00 09 04 00 | 00 00 00 0b 04 00 00 00 |........|........|
|00002670| 00 16 04 02 00 00 00 18 | 04 00 00 00 00 22 04 01 |........|....."..|
|00002680| 00 00 00 26 04 01 00 00 | 00 2a 04 00 00 00 00 2b |...&....|.*.....+|
|00002690| 04 00 00 00 00 00 09 03 | 01 05 53 41 4c 45 53 10 |........|..SALES.|
|000026a0| 04 01 00 00 00 08 09 53 | 51 4c 24 53 41 4c 45 53 |.......S|QL$SALES|
|000026b0| 0c 06 53 59 53 44 42 41 | 00 04 01 04 41 47 45 44 |..SYSDBA|....AGED|
|000026c0| 02 06 52 44 42 24 33 31 | 0d 04 0c 00 00 00 08 04 |..RDB$31|........|
|000026d0| 1b 00 00 00 0a 04 08 00 | 00 00 09 04 00 00 00 00 |........|........|
|000026e0| 0b 04 00 00 00 00 16 04 | 0d 00 00 00 18 04 00 00 |........|........|
|000026f0| 00 00 22 04 00 00 00 00 | 17 04 01 00 00 00 00 04 |..".....|........|
|00002700| 01 0b 44 41 54 45 5f 4e | 45 45 44 45 44 02 06 52 |..DATE_N|EEDED..R|
|00002710| 44 42 24 32 36 0d 04 06 | 00 00 00 08 04 23 00 00 |DB$26...|.....#..|
|00002720| 00 0a 04 08 00 00 00 09 | 04 00 00 00 00 0b 04 00 |........|........|
|00002730| 00 00 00 16 04 07 00 00 | 00 18 04 00 00 00 00 22 |........|......."|
|00002740| 04 01 00 00 00 00 04 01 | 09 53 48 49 50 5f 44 41 |........|.SHIP_DA|
|00002750| 54 45 02 06 52 44 42 24 | 32 35 0d 04 05 00 00 00 |TE..RDB$|25......|
|00002760| 08 04 23 00 00 00 0a 04 | 08 00 00 00 09 04 00 00 |..#.....|........|
|00002770| 00 00 0b 04 00 00 00 00 | 16 04 06 00 00 00 18 04 |........|........|
|00002780| 00 00 00 00 22 04 01 00 | 00 00 00 04 01 0a 4f 52 |...."...|......OR|
|00002790| 44 45 52 5f 44 41 54 45 | 02 06 52 44 42 24 32 34 |DER_DATE|..RDB$24|
|000027a0| 0d 04 04 00 00 00 08 04 | 23 00 00 00 0a 04 08 00 |........|#.......|
|000027b0| 00 00 09 04 00 00 00 00 | 0b 04 00 00 00 00 16 04 |........|........|
|000027c0| 05 00 00 00 18 04 00 00 | 00 00 22 04 01 00 00 00 |........|..".....|
|000027d0| 26 04 01 00 00 00 0f 04 | 0b 00 00 00 04 15 0f 7f |&.......|........|
|000027e0| 00 03 00 6e 6f 77 4c 27 | 04 0e 00 00 00 44 45 46 |...nowL'|.....DEF|
|000027f0| 41 55 4c 54 20 27 6e 6f | 77 27 00 00 04 01 09 50 |AULT 'no|w'.....P|
|00002800| 4f 5f 4e 55 4d 42 45 52 | 02 08 50 4f 4e 55 4d 42 |O_NUMBER|..PONUMB|
|00002810| 45 52 0d 04 00 00 00 00 | 08 04 0e 00 00 00 0a 04 |ER......|........|
|00002820| 08 00 00 00 09 04 00 00 | 00 00 0b 04 00 00 00 00 |........|........|
|00002830| 16 04 01 00 00 00 18 04 | 00 00 00 00 22 04 01 00 |........|...."...|
|00002840| 00 00 26 04 01 00 00 00 | 2a 04 00 00 00 00 00 04 |..&.....|*.......|
|00002850| 01 08 44 49 53 43 4f 55 | 4e 54 02 06 52 44 42 24 |..DISCOU|NT..RDB$|
|00002860| 33 30 0d 04 0a 00 00 00 | 08 04 0a 00 00 00 0a 04 |30......|........|
|00002870| 04 00 00 00 09 04 00 00 | 00 00 0b 04 00 00 00 00 |........|........|
|00002880| 16 04 0b 00 00 00 18 04 | 00 00 00 00 22 04 01 00 |........|...."...|
|00002890| 00 00 26 04 01 00 00 00 | 0f 04 09 00 00 00 04 15 |..&.....|........|
|000028a0| 08 00 00 00 00 00 4c 27 | 04 0a 00 00 00 44 45 46 |......L'|.....DEF|
|000028b0| 41 55 4c 54 20 30 00 00 | 04 01 0b 54 4f 54 41 4c |AULT 0..|...TOTAL|
|000028c0| 5f 56 41 4c 55 45 02 06 | 52 44 42 24 32 39 0d 04 |_VALUE..|RDB$29..|
|000028d0| 09 00 00 00 08 04 08 00 | 00 00 0a 04 04 00 00 00 |........|........|
|000028e0| 09 04 00 00 00 00 0b 04 | fe ff ff ff 16 04 0a 00 |........|........|
|000028f0| 00 00 18 04 00 00 00 00 | 22 04 01 00 00 00 26 04 |........|".....&.|
|00002900| 01 00 00 00 00 04 01 0b | 51 54 59 5f 4f 52 44 45 |........|QTY_ORDE|
|00002910| 52 45 44 02 06 52 44 42 | 24 32 38 0d 04 08 00 00 |RED..RDB|$28.....|
|00002920| 00 08 04 08 00 00 00 0a | 04 04 00 00 00 09 04 00 |........|........|
|00002930| 00 00 00 0b 04 00 00 00 | 00 16 04 09 00 00 00 18 |........|........|
|00002940| 04 00 00 00 00 22 04 01 | 00 00 00 26 04 01 00 00 |....."..|...&....|
|00002950| 00 0f 04 09 00 00 00 04 | 15 08 00 01 00 00 00 4c |........|.......L|
|00002960| 27 04 0a 00 00 00 44 45 | 46 41 55 4c 54 20 31 00 |'.....DE|FAULT 1.|
|00002970| 00 04 01 07 43 55 53 54 | 5f 4e 4f 02 06 43 55 53 |....CUST|_NO..CUS|
|00002980| 54 4e 4f 0d 04 01 00 00 | 00 08 04 08 00 00 00 0a |TNO.....|........|
|00002990| 04 04 00 00 00 09 04 00 | 00 00 00 0b 04 00 00 00 |........|........|
|000029a0| 00 16 04 02 00 00 00 18 | 04 00 00 00 00 22 04 01 |........|....."..|
|000029b0| 00 00 00 26 04 01 00 00 | 00 00 04 01 09 49 54 45 |...&....|.....ITE|
|000029c0| 4d 5f 54 59 50 45 02 08 | 50 52 4f 44 54 59 50 45 |M_TYPE..|PRODTYPE|
|000029d0| 0d 04 0b 00 00 00 08 04 | 25 00 00 00 0a 04 0c 00 |........|%.......|
|000029e0| 00 00 09 04 00 00 00 00 | 0b 04 00 00 00 00 16 04 |........|........|
|000029f0| 0c 00 00 00 18 04 00 00 | 00 00 22 04 01 00 00 00 |........|..".....|
|00002a00| 2a 04 00 00 00 00 00 04 | 01 09 53 41 4c 45 53 5f |*.......|..SALES_|
|00002a10| 52 45 50 02 05 45 4d 50 | 4e 4f 0d 04 02 00 00 00 |REP..EMP|NO......|
|00002a20| 08 04 07 00 00 00 0a 04 | 02 00 00 00 09 04 00 00 |........|........|
|00002a30| 00 00 0b 04 00 00 00 00 | 16 04 03 00 00 00 18 04 |........|........|
|00002a40| 00 00 00 00 22 04 01 00 | 00 00 00 04 01 04 50 41 |...."...|......PA|
|00002a50| 49 44 02 06 52 44 42 24 | 32 37 0d 04 07 00 00 00 |ID..RDB$|27......|
|00002a60| 08 04 0e 00 00 00 0a 04 | 01 00 00 00 09 04 00 00 |........|........|
|00002a70| 00 00 0b 04 00 00 00 00 | 16 04 08 00 00 00 18 04 |........|........|
|00002a80| 00 00 00 00 22 04 01 00 | 00 00 2a 04 00 00 00 00 |...."...|..*.....|
|00002a90| 2b 04 00 00 00 00 0f 04 | 09 00 00 00 04 15 0f 7f |+.......|........|
|00002aa0| 00 01 00 6e 4c 27 04 0c | 00 00 00 44 45 46 41 55 |...nL'..|...DEFAU|
|00002ab0| 4c 54 20 27 6e 27 00 00 | 04 01 0c 4f 52 44 45 52 |LT 'n'..|...ORDER|
|00002ac0| 5f 53 54 41 54 55 53 02 | 06 52 44 42 24 32 33 0d |_STATUS.|.RDB$23.|
|00002ad0| 04 03 00 00 00 08 04 25 | 00 00 00 0a 04 07 00 00 |.......%|........|
|00002ae0| 00 09 04 00 00 00 00 0b | 04 00 00 00 00 16 04 04 |........|........|
|00002af0| 00 00 00 18 04 00 00 00 | 00 22 04 01 00 00 00 26 |........|.".....&|
|00002b00| 04 01 00 00 00 2a 04 00 | 00 00 00 2b 04 00 00 00 |.....*..|...+....|
|00002b10| 00 0f 04 0b 00 00 00 04 | 15 0f 7f 00 03 00 6e 65 |........|......ne|
|00002b20| 77 4c 27 04 0e 00 00 00 | 44 45 46 41 55 4c 54 20 |wL'.....|DEFAULT |
|00002b30| 27 6e 65 77 27 00 00 09 | 03 01 10 45 4d 50 4c 4f |'new'...|...EMPLO|
|00002b40| 59 45 45 5f 50 52 4f 4a | 45 43 54 10 04 01 00 00 |YEE_PROJ|ECT.....|
|00002b50| 00 08 14 53 51 4c 24 45 | 4d 50 4c 4f 59 45 45 5f |...SQL$E|MPLOYEE_|
|00002b60| 50 52 4f 4a 45 43 54 0c | 06 53 59 53 44 42 41 00 |PROJECT.|.SYSDBA.|
|00002b70| 04 01 06 45 4d 50 5f 4e | 4f 02 05 45 4d 50 4e 4f |...EMP_N|O..EMPNO|
|00002b80| 0d 04 00 00 00 00 08 04 | 07 00 00 00 0a 04 02 00 |........|........|
|00002b90| 00 00 09 04 00 00 00 00 | 0b 04 00 00 00 00 16 04 |........|........|
|00002ba0| 01 00 00 00 18 04 00 00 | 00 00 22 04 01 00 00 00 |........|..".....|
|00002bb0| 26 04 01 00 00 00 00 04 | 01 07 50 52 4f 4a 5f 49 |&.......|..PROJ_I|
|00002bc0| 44 02 06 50 52 4f 4a 4e | 4f 0d 04 01 00 00 00 08 |D..PROJN|O.......|
|00002bd0| 04 0e 00 00 00 0a 04 05 | 00 00 00 09 04 00 00 00 |........|........|
|00002be0| 00 0b 04 00 00 00 00 16 | 04 02 00 00 00 18 04 00 |........|........|
|00002bf0| 00 00 00 22 04 01 00 00 | 00 26 04 01 00 00 00 2a |..."....|.&.....*|
|00002c00| 04 00 00 00 00 00 09 03 | 01 10 50 52 4f 4a 5f 44 |........|..PROJ_D|
|00002c10| 45 50 54 5f 42 55 44 47 | 45 54 10 04 01 00 00 00 |EPT_BUDG|ET......|
|00002c20| 08 14 53 51 4c 24 50 52 | 4f 4a 5f 44 45 50 54 5f |..SQL$PR|OJ_DEPT_|
|00002c30| 42 55 44 47 45 54 0c 06 | 53 59 53 44 42 41 00 04 |BUDGET..|SYSDBA..|
|00002c40| 01 10 50 52 4f 4a 45 43 | 54 45 44 5f 42 55 44 47 |..PROJEC|TED_BUDG|
|00002c50| 45 54 02 06 42 55 44 47 | 45 54 0d 04 04 00 00 00 |ET..BUDG|ET......|
|00002c60| 08 04 1b 00 00 00 0a 04 | 08 00 00 00 09 04 00 00 |........|........|
|00002c70| 00 00 0b 04 fe ff ff ff | 16 04 05 00 00 00 18 04 |........|........|
|00002c80| 00 00 00 00 22 04 01 00 | 00 00 00 04 01 0e 51 55 |...."...|......QU|
|00002c90| 41 52 54 5f 48 45 41 44 | 5f 43 4e 54 02 06 52 44 |ART_HEAD|_CNT..RD|
|00002ca0| 42 24 31 33 0d 04 03 00 | 00 00 08 04 08 00 00 00 |B$13....|........|
|00002cb0| 0a 04 04 00 00 00 09 04 | 00 00 00 00 0b 04 00 00 |........|........|
|00002cc0| 00 00 16 04 04 00 00 00 | 18 04 00 00 00 00 22 04 |........|......".|
|00002cd0| 01 00 00 00 1d 04 01 00 | 00 00 20 04 01 00 00 00 |........|.. .....|
|00002ce0| 21 04 04 00 00 00 00 04 | 01 04 59 45 41 52 02 06 |!.......|..YEAR..|
|00002cf0| 52 44 42 24 31 32 0d 04 | 00 00 00 00 08 04 08 00 |RDB$12..|........|
|00002d00| 00 00 0a 04 04 00 00 00 | 09 04 00 00 00 00 0b 04 |........|........|
|00002d10| 00 00 00 00 16 04 01 00 | 00 00 18 04 00 00 00 00 |........|........|
|00002d20| 22 04 01 00 00 00 26 04 | 01 00 00 00 00 04 01 07 |".....&.|........|
|00002d30| 44 45 50 54 5f 4e 4f 02 | 06 44 45 50 54 4e 4f 0d |DEPT_NO.|.DEPTNO.|
|00002d40| 04 02 00 00 00 08 04 0e | 00 00 00 0a 04 03 00 00 |........|........|
|00002d50| 00 09 04 00 00 00 00 0b | 04 00 00 00 00 16 04 03 |........|........|
|00002d60| 00 00 00 18 04 00 00 00 | 00 22 04 01 00 00 00 26 |........|.".....&|
|00002d70| 04 01 00 00 00 2a 04 00 | 00 00 00 00 04 01 07 50 |.....*..|.......P|
|00002d80| 52 4f 4a 5f 49 44 02 06 | 50 52 4f 4a 4e 4f 0d 04 |ROJ_ID..|PROJNO..|
|00002d90| 01 00 00 00 08 04 0e 00 | 00 00 0a 04 05 00 00 00 |........|........|
|00002da0| 09 04 00 00 00 00 0b 04 | 00 00 00 00 16 04 02 00 |........|........|
|00002db0| 00 00 18 04 00 00 00 00 | 22 04 01 00 00 00 26 04 |........|".....&.|
|00002dc0| 01 00 00 00 2a 04 00 00 | 00 00 00 09 03 01 0e 53 |....*...|.......S|
|00002dd0| 41 4c 41 52 59 5f 48 49 | 53 54 4f 52 59 10 04 01 |ALARY_HI|STORY...|
|00002de0| 00 00 00 08 12 53 51 4c | 24 53 41 4c 41 52 59 5f |.....SQL|$SALARY_|
|00002df0| 48 49 53 54 4f 52 59 0c | 06 53 59 53 44 42 41 00 |HISTORY.|.SYSDBA.|
|00002e00| 04 01 0a 4e 45 57 5f 53 | 41 4c 41 52 59 02 06 52 |...NEW_S|ALARY..R|
|00002e10| 44 42 24 31 37 0d 04 05 | 00 00 00 08 04 1b 00 00 |DB$17...|........|
|00002e20| 00 0a 04 08 00 00 00 09 | 04 00 00 00 00 0b 04 00 |........|........|
|00002e30| 00 00 00 16 04 06 00 00 | 00 18 04 00 00 00 00 22 |........|......."|
|00002e40| 04 00 00 00 00 17 04 01 | 00 00 00 00 04 01 0e 50 |........|.......P|
|00002e50| 45 52 43 45 4e 54 5f 43 | 48 41 4e 47 45 02 06 52 |ERCENT_C|HANGE..R|
|00002e60| 44 42 24 31 36 0d 04 04 | 00 00 00 08 04 1b 00 00 |DB$16...|........|
|00002e70| 00 0a 04 08 00 00 00 09 | 04 00 00 00 00 0b 04 00 |........|........|
|00002e80| 00 00 00 16 04 05 00 00 | 00 18 04 00 00 00 00 22 |........|......."|
|00002e90| 04 01 00 00 00 26 04 01 | 00 00 00 0f 04 09 00 00 |.....&..|........|
|00002ea0| 00 04 15 08 00 00 00 00 | 00 4c 27 04 0a 00 00 00 |........|.L'.....|
|00002eb0| 44 45 46 41 55 4c 54 20 | 30 00 00 04 01 0a 4f 4c |DEFAULT |0.....OL|
|00002ec0| 44 5f 53 41 4c 41 52 59 | 02 06 53 41 4c 41 52 59 |D_SALARY|..SALARY|
|00002ed0| 0d 04 03 00 00 00 08 04 | 1b 00 00 00 0a 04 08 00 |........|........|
|00002ee0| 00 00 09 04 00 00 00 00 | 0b 04 fe ff ff ff 16 04 |........|........|
|00002ef0| 04 00 00 00 18 04 00 00 | 00 00 22 04 01 00 00 00 |........|..".....|
|00002f00| 26 04 01 00 00 00 00 04 | 01 0b 43 48 41 4e 47 45 |&.......|..CHANGE|
|00002f10| 5f 44 41 54 45 02 06 52 | 44 42 24 31 34 0d 04 01 |_DATE..R|DB$14...|
|00002f20| 00 00 00 08 04 23 00 00 | 00 0a 04 08 00 00 00 09 |.....#..|........|
|00002f30| 04 00 00 00 00 0b 04 00 | 00 00 00 16 04 02 00 00 |........|........|
|00002f40| 00 18 04 00 00 00 00 22 | 04 01 00 00 00 26 04 01 |......."|.....&..|
|00002f50| 00 00 00 0f 04 0b 00 00 | 00 04 15 0f 7f 00 03 00 |........|........|
|00002f60| 4e 4f 57 4c 27 04 0e 00 | 00 00 44 45 46 41 55 4c |NOWL'...|..DEFAUL|
|00002f70| 54 20 27 4e 4f 57 27 00 | 00 04 01 0a 55 50 44 41 |T 'NOW'.|....UPDA|
|00002f80| 54 45 52 5f 49 44 02 06 | 52 44 42 24 31 35 0d 04 |TER_ID..|RDB$15..|
|00002f90| 02 00 00 00 08 04 25 00 | 00 00 0a 04 14 00 00 00 |......%.|........|
|00002fa0| 09 04 00 00 00 00 0b 04 | 00 00 00 00 16 04 03 00 |........|........|
|00002fb0| 00 00 18 04 00 00 00 00 | 22 04 01 00 00 00 26 04 |........|".....&.|
|00002fc0| 01 00 00 00 2a 04 00 00 | 00 00 2b 04 00 00 00 00 |....*...|..+.....|
|00002fd0| 00 04 01 06 45 4d 50 5f | 4e 4f 02 05 45 4d 50 4e |....EMP_|NO..EMPN|
|00002fe0| 4f 0d 04 00 00 00 00 08 | 04 07 00 00 00 0a 04 02 |O.......|........|
|00002ff0| 00 00 00 09 04 00 00 00 | 00 0b 04 00 00 00 00 16 |........|........|
|00003000| 04 01 00 00 00 18 04 00 | 00 00 00 22 04 01 00 00 |........|..."....|
|00003010| 00 26 04 01 00 00 00 00 | 09 1a 01 0a 45 4d 50 5f |.&......|....EMP_|
|00003020| 4e 4f 5f 47 45 4e 02 04 | 91 00 00 00 00 1a 01 0b |NO_GEN..|........|
|00003030| 43 55 53 54 5f 4e 4f 5f | 47 45 4e 02 04 f7 03 00 |CUST_NO_|GEN.....|
|00003040| 00 00 1b 01 0c 47 45 54 | 5f 45 4d 50 5f 50 52 4f |.....GET|_EMP_PRO|
|00003050| 4a 02 04 01 00 00 00 03 | 04 01 00 00 00 07 04 6f |J.......|.......o|
|00003060| 00 00 00 0a 42 45 47 49 | 4e 0a 20 46 4f 52 20 53 |....BEGI|N. FOR S|
|00003070| 45 4c 45 43 54 20 70 72 | 6f 6a 5f 69 64 0a 20 20 |ELECT pr|oj_id.  |
|00003080| 46 52 4f 4d 20 65 6d 70 | 6c 6f 79 65 65 5f 70 72 |FROM emp|loyee_pr|
|00003090| 6f 6a 65 63 74 0a 20 20 | 57 48 45 52 45 20 65 6d |oject.  |WHERE em|
|000030a0| 70 5f 6e 6f 20 3d 20 3a | 65 6d 70 5f 6e 6f 0a 20 |p_no = :|emp_no. |
|000030b0| 20 49 4e 54 4f 20 3a 70 | 72 6f 6a 5f 69 64 0a 20 | INTO :p|roj_id. |
|000030c0| 44 4f 0a 20 20 53 55 53 | 50 45 4e 44 3b 0a 45 4e |DO.  SUS|PEND;.EN|
|000030d0| 44 00 08 04 9c 00 00 00 | 04 02 04 00 02 00 07 00 |D.......|........|
|000030e0| 07 00 04 01 03 00 0f 00 | 00 05 00 07 00 07 00 0c |........|........|
|000030f0| 00 02 03 00 00 0f 00 00 | 05 00 01 2d 1a 00 00 9b |........|...-....|
|00003100| 11 00 02 02 07 43 01 4a | 10 45 4d 50 4c 4f 59 45 |.....C.J|.EMPLOYE|
|00003110| 45 5f 50 52 4f 4a 45 43 | 54 00 47 2f 17 00 06 45 |E_PROJEC|T.G/...E|
|00003120| 4d 50 5f 4e 4f 29 00 00 | 00 01 00 ff 02 01 17 00 |MP_NO)..|........|
|00003130| 07 50 52 4f 4a 5f 49 44 | 1a 00 00 02 0e 01 02 01 |.PROJ_ID|........|
|00003140| 1a 00 00 29 01 00 00 01 | 00 01 15 07 00 01 00 19 |...)....|........|
|00003150| 01 02 00 ff 9b ff ff ff | ff ff 0e 01 02 01 1a 00 |........|........|
|00003160| 00 29 01 00 00 01 00 01 | 15 07 00 00 00 19 01 02 |.)......|........|
|00003170| 00 ff ff 4c 09 10 53 51 | 4c 24 47 45 54 5f 45 4d |...L..SQ|L$GET_EM|
|00003180| 50 5f 50 52 4f 4a 0a 06 | 53 59 53 44 42 41 00 1c |P_PROJ..|SYSDBA..|
|00003190| 01 06 45 4d 50 5f 4e 4f | 02 04 00 00 00 00 03 04 |..EMP_NO|........|
|000031a0| 00 00 00 00 04 06 52 44 | 42 24 33 32 00 1c 01 07 |......RD|B$32....|
|000031b0| 50 52 4f 4a 5f 49 44 02 | 04 00 00 00 00 03 04 01 |PROJ_ID.|........|
|000031c0| 00 00 00 04 06 52 44 42 | 24 33 33 00 1d 1b 01 0c |.....RDB|$33.....|
|000031d0| 41 44 44 5f 45 4d 50 5f | 50 52 4f 4a 02 04 02 00 |ADD_EMP_|PROJ....|
|000031e0| 00 00 03 04 00 00 00 00 | 07 04 9f 00 00 00 0a 42 |........|.......B|
|000031f0| 45 47 49 4e 0a 20 42 45 | 47 49 4e 0a 20 49 4e 53 |EGIN. BE|GIN. INS|
|00003200| 45 52 54 20 49 4e 54 4f | 20 65 6d 70 6c 6f 79 65 |ERT INTO| employe|
|00003210| 65 5f 70 72 6f 6a 65 63 | 74 20 28 65 6d 70 5f 6e |e_projec|t (emp_n|
|00003220| 6f 2c 20 70 72 6f 6a 5f | 69 64 29 20 56 41 4c 55 |o, proj_|id) VALU|
|00003230| 45 53 20 28 3a 65 6d 70 | 5f 6e 6f 2c 20 3a 70 72 |ES (:emp|_no, :pr|
|00003240| 6f 6a 5f 69 64 29 3b 0a | 20 57 48 45 4e 20 53 51 |oj_id);.| WHEN SQ|
|00003250| 4c 43 4f 44 45 20 2d 35 | 33 30 20 44 4f 0a 20 20 |LCODE -5|30 DO.  |
|00003260| 45 58 43 45 50 54 49 4f | 4e 20 75 6e 6b 6e 6f 77 |EXCEPTIO|N unknow|
|00003270| 6e 5f 65 6d 70 5f 69 64 | 3b 0a 20 45 4e 44 0a 20 |n_emp_id|;. END. |
|00003280| 53 55 53 50 45 4e 44 3b | 0a 45 4e 44 00 08 04 9d |SUSPEND;|.END....|
|00003290| 00 00 00 04 02 04 00 04 | 00 07 00 07 00 0f 00 00 |........|........|
|000032a0| 05 00 07 00 04 01 01 00 | 07 00 0c 00 02 9b 11 00 |........|........|
|000032b0| 02 02 81 02 02 86 0f 4a | 10 45 4d 50 4c 4f 59 45 |.......J|.EMPLOYE|
|000032c0| 45 5f 50 52 4f 4a 45 43 | 54 00 02 01 29 00 00 00 |E_PROJEC|T...)...|
|000032d0| 01 00 17 00 06 45 4d 50 | 5f 4e 4f 01 29 00 02 00 |.....EMP|_NO.)...|
|000032e0| 03 00 17 00 07 50 52 4f | 4a 5f 49 44 ff 87 ff ff |.....PRO|J_ID....|
|000032f0| 82 01 00 01 ee fd 02 86 | 80 02 0e 55 4e 4b 4e 4f |........|...UNKNO|
|00003300| 57 4e 5f 45 4d 50 5f 49 | 44 87 ff ff 02 0e 01 02 |WN_EMP_I|D.......|
|00003310| 01 15 07 00 01 00 19 01 | 00 00 ff 9b ff ff ff ff |........|........|
|00003320| 0e 01 02 01 15 07 00 00 | 00 19 01 00 00 ff ff 4c |........|.......L|
|00003330| 09 10 53 51 4c 24 41 44 | 44 5f 45 4d 50 5f 50 52 |..SQL$AD|D_EMP_PR|
|00003340| 4f 4a 0a 06 53 59 53 44 | 42 41 00 1c 01 06 45 4d |OJ..SYSD|BA....EM|
|00003350| 50 5f 4e 4f 02 04 00 00 | 00 00 03 04 00 00 00 00 |P_NO....|........|
|00003360| 04 06 52 44 42 24 33 34 | 00 1c 01 07 50 52 4f 4a |..RDB$34|....PROJ|
|00003370| 5f 49 44 02 04 01 00 00 | 00 03 04 00 00 00 00 04 |_ID.....|........|
|00003380| 06 52 44 42 24 33 35 00 | 1d 1b 01 0e 53 55 42 5f |.RDB$35.|....SUB_|
|00003390| 54 4f 54 5f 42 55 44 47 | 45 54 02 04 01 00 00 00 |TOT_BUDG|ET......|
|000033a0| 03 04 04 00 00 00 07 04 | bc 00 00 00 0a 42 45 47 |........|.....BEG|
|000033b0| 49 4e 0a 20 53 45 4c 45 | 43 54 20 53 55 4d 28 62 |IN. SELE|CT SUM(b|
|000033c0| 75 64 67 65 74 29 2c 20 | 41 56 47 28 62 75 64 67 |udget), |AVG(budg|
|000033d0| 65 74 29 2c 20 4d 49 4e | 28 62 75 64 67 65 74 29 |et), MIN|(budget)|
|000033e0| 2c 20 4d 41 58 28 62 75 | 64 67 65 74 29 0a 20 20 |, MAX(bu|dget).  |
|000033f0| 46 52 4f 4d 20 64 65 70 | 61 72 74 6d 65 6e 74 0a |FROM dep|artment.|
|00003400| 20 20 57 48 45 52 45 20 | 68 65 61 64 5f 64 65 70 |  WHERE |head_dep|
|00003410| 74 20 3d 20 3a 68 65 61 | 64 5f 64 65 70 74 0a 20 |t = :hea|d_dept. |
|00003420| 20 49 4e 54 4f 20 3a 74 | 6f 74 5f 62 75 64 67 65 | INTO :t|ot_budge|
|00003430| 74 2c 20 3a 61 76 67 5f | 62 75 64 67 65 74 2c 20 |t, :avg_|budget, |
|00003440| 3a 6d 69 6e 5f 62 75 64 | 67 65 74 2c 20 3a 6d 61 |:min_bud|get, :ma|
|00003450| 78 5f 62 75 64 67 65 74 | 3b 0a 20 53 55 53 50 45 |x_budget|;. SUSPE|
|00003460| 4e 44 3b 0a 45 4e 44 00 | 08 04 41 01 00 00 04 02 |ND;.END.|..A.....|
|00003470| 04 00 02 00 0f 00 00 03 | 00 07 00 04 01 09 00 1b |........|........|
|00003480| 07 00 1b 07 00 1b 07 00 | 1b 07 00 07 00 0c 00 02 |........|........|
|00003490| 03 00 00 1b 01 2d 1a 00 | 00 03 01 00 1b 01 2d 1a |.....-..|......-.|
|000034a0| 01 00 03 02 00 1b 01 2d | 1a 02 00 03 03 00 1b 01 |.......-|........|
|000034b0| 2d 1a 03 00 9b 11 00 02 | 02 07 7f 43 01 4f 01 43 |-.......|...C.O.C|
|000034c0| 01 4a 0a 44 45 50 41 52 | 54 4d 45 4e 54 00 47 2f |.J.DEPAR|TMENT.G/|
|000034d0| 17 00 09 48 45 41 44 5f | 44 45 50 54 29 00 00 00 |...HEAD_|DEPT)...|
|000034e0| 01 00 ff 4e 00 4d 04 00 | 00 00 54 17 00 06 42 55 |...N.M..|..T...BU|
|000034f0| 44 47 45 54 01 00 55 17 | 00 06 42 55 44 47 45 54 |DGET..U.|..BUDGET|
|00003500| 02 00 57 17 00 06 42 55 | 44 47 45 54 03 00 56 17 |..W...BU|DGET..V.|
|00003510| 00 06 42 55 44 47 45 54 | ff 02 01 18 01 03 00 1a |..BUDGET|........|
|00003520| 00 00 01 18 01 02 00 1a | 01 00 01 18 01 01 00 1a |........|........|
|00003530| 02 00 01 18 01 00 00 1a | 03 00 ff 02 0e 01 02 01 |........|........|
|00003540| 1a 00 00 29 01 00 00 01 | 00 01 1a 01 00 29 01 02 |...)....|.....)..|
|00003550| 00 03 00 01 1a 02 00 29 | 01 04 00 05 00 01 1a 03 |.......)|........|
|00003560| 00 29 01 06 00 07 00 01 | 15 07 00 01 00 19 01 08 |.)......|........|
|00003570| 00 ff 9b ff ff ff ff 0e | 01 02 01 1a 00 00 29 01 |........|......).|
|00003580| 00 00 01 00 01 1a 01 00 | 29 01 02 00 03 00 01 1a |........|).......|
|00003590| 02 00 29 01 04 00 05 00 | 01 1a 03 00 29 01 06 00 |..).....|....)...|
|000035a0| 07 00 01 15 07 00 00 00 | 19 01 08 00 ff ff 4c 09 |........|......L.|
|000035b0| 12 53 51 4c 24 53 55 42 | 5f 54 4f 54 5f 42 55 44 |.SQL$SUB|_TOT_BUD|
|000035c0| 47 45 54 0a 06 53 59 53 | 44 42 41 00 1c 01 09 48 |GET..SYS|DBA....H|
|000035d0| 45 41 44 5f 44 45 50 54 | 02 04 00 00 00 00 03 04 |EAD_DEPT|........|
|000035e0| 00 00 00 00 04 06 52 44 | 42 24 33 36 00 1c 01 0a |......RD|B$36....|
|000035f0| 54 4f 54 5f 42 55 44 47 | 45 54 02 04 00 00 00 00 |TOT_BUDG|ET......|
|00003600| 03 04 01 00 00 00 04 06 | 52 44 42 24 33 37 00 1c |........|RDB$37..|
|00003610| 01 0a 41 56 47 5f 42 55 | 44 47 45 54 02 04 01 00 |..AVG_BU|DGET....|
|00003620| 00 00 03 04 01 00 00 00 | 04 06 52 44 42 24 33 38 |........|..RDB$38|
|00003630| 00 1c 01 0a 4d 49 4e 5f | 42 55 44 47 45 54 02 04 |....MIN_|BUDGET..|
|00003640| 02 00 00 00 03 04 01 00 | 00 00 04 06 52 44 42 24 |........|....RDB$|
|00003650| 33 39 00 1c 01 0a 4d 41 | 58 5f 42 55 44 47 45 54 |39....MA|X_BUDGET|
|00003660| 02 04 03 00 00 00 03 04 | 01 00 00 00 04 06 52 44 |........|......RD|
|00003670| 42 24 34 30 00 1d 1b 01 | 0f 44 45 4c 45 54 45 5f |B$40....|.DELETE_|
|00003680| 45 4d 50 4c 4f 59 45 45 | 02 04 01 00 00 00 03 04 |EMPLOYEE|........|
|00003690| 00 00 00 00 07 04 cc 03 | 00 00 0a 20 44 45 43 4c |........|... DECL|
|000036a0| 41 52 45 20 56 41 52 49 | 41 42 4c 45 20 61 6e 79 |ARE VARI|ABLE any|
|000036b0| 5f 73 61 6c 65 73 20 49 | 4e 54 45 47 45 52 3b 0a |_sales I|NTEGER;.|
|000036c0| 42 45 47 49 4e 0a 20 61 | 6e 79 5f 73 61 6c 65 73 |BEGIN. a|ny_sales|
|000036d0| 20 3d 20 30 3b 0a 0a 20 | 2f 2a 0a 20 20 2a 20 49 | = 0;.. |/*.  * I|
|000036e0| 66 20 74 68 65 72 65 20 | 61 72 65 20 61 6e 79 20 |f there |are any |
|000036f0| 73 61 6c 65 73 20 72 65 | 63 6f 72 64 73 20 72 65 |sales re|cords re|
|00003700| 66 65 72 65 6e 63 69 6e | 67 20 74 68 69 73 20 65 |ferencin|g this e|
|00003710| 6d 70 6c 6f 79 65 65 2c | 0a 20 20 2a 20 63 61 6e |mployee,|.  * can|
|00003720| 27 74 20 64 65 6c 65 74 | 65 20 74 68 65 20 65 6d |'t delet|e the em|
|00003730| 70 6c 6f 79 65 65 20 75 | 6e 74 69 6c 20 74 68 65 |ployee u|ntil the|
|00003740| 20 73 61 6c 65 73 20 61 | 72 65 20 72 65 2d 61 73 | sales a|re re-as|
|00003750| 73 69 67 6e 65 64 0a 20 | 20 2a 20 74 6f 20 61 6e |signed. | * to an|
|00003760| 6f 74 68 65 72 20 65 6d | 70 6c 6f 79 65 65 20 6f |other em|ployee o|
|00003770| 72 20 63 68 61 6e 67 65 | 64 20 74 6f 20 4e 55 4c |r change|d to NUL|
|00003780| 4c 2e 0a 20 20 2a 2f 0a | 20 53 45 4c 45 43 54 20 |L..  */.| SELECT |
|00003790| 63 6f 75 6e 74 28 70 6f | 5f 6e 75 6d 62 65 72 29 |count(po|_number)|
|000037a0| 0a 20 46 52 4f 4d 20 73 | 61 6c 65 73 0a 20 57 48 |. FROM s|ales. WH|
|000037b0| 45 52 45 20 73 61 6c 65 | 73 5f 72 65 70 20 3d 20 |ERE sale|s_rep = |
|000037c0| 3a 65 6d 70 5f 6e 75 6d | 0a 20 49 4e 54 4f 20 3a |:emp_num|. INTO :|
|000037d0| 61 6e 79 5f 73 61 6c 65 | 73 3b 0a 0a 20 49 46 20 |any_sale|s;.. IF |
|000037e0| 28 61 6e 79 5f 73 61 6c | 65 73 20 3e 20 30 29 20 |(any_sal|es > 0) |
|000037f0| 54 48 45 4e 0a 20 42 45 | 47 49 4e 0a 20 20 45 58 |THEN. BE|GIN.  EX|
|00003800| 43 45 50 54 49 4f 4e 20 | 72 65 61 73 73 69 67 6e |CEPTION |reassign|
|00003810| 5f 73 61 6c 65 73 3b 0a | 20 20 53 55 53 50 45 4e |_sales;.|  SUSPEN|
|00003820| 44 3b 0a 20 45 4e 44 0a | 0a 20 2f 2a 0a 20 20 2a |D;. END.|. /*.  *|
|00003830| 20 49 66 20 74 68 65 20 | 65 6d 70 6c 6f 79 65 65 | If the |employee|
|00003840| 20 69 73 20 61 20 6d 61 | 6e 61 67 65 72 2c 20 75 | is a ma|nager, u|
|00003850| 70 64 61 74 65 20 74 68 | 65 20 64 65 70 61 72 74 |pdate th|e depart|
|00003860| 6d 65 6e 74 2e 0a 20 20 | 2a 2f 0a 20 55 50 44 41 |ment..  |*/. UPDA|
|00003870| 54 45 20 64 65 70 61 72 | 74 6d 65 6e 74 0a 20 53 |TE depar|tment. S|
|00003880| 45 54 20 6d 6e 67 72 5f | 6e 6f 20 3d 20 4e 55 4c |ET mngr_|no = NUL|
|00003890| 4c 0a 20 57 48 45 52 45 | 20 6d 00 6e 67 72 5f 6e |L. WHERE| m.ngr_n|
|000038a0| 6f 20 3d 20 3a 65 6d 70 | 5f 6e 75 6d 3b 0a 0a 20 |o = :emp|_num;.. |
|000038b0| 2f 2a 0a 20 20 2a 20 49 | 66 20 74 68 65 20 65 6d |/*.  * I|f the em|
|000038c0| 70 6c 6f 79 65 65 20 69 | 73 20 61 20 70 72 6f 6a |ployee i|s a proj|
|000038d0| 65 63 74 20 6c 65 61 64 | 65 72 2c 20 75 70 64 61 |ect lead|er, upda|
|000038e0| 74 65 20 70 72 6f 6a 65 | 63 74 2e 0a 20 20 2a 2f |te proje|ct..  */|
|000038f0| 0a 20 55 50 44 41 54 45 | 20 70 72 6f 6a 65 63 74 |. UPDATE| project|
|00003900| 0a 20 53 45 54 20 74 65 | 61 6d 5f 6c 65 61 64 65 |. SET te|am_leade|
|00003910| 72 20 3d 20 4e 55 4c 4c | 0a 20 57 48 45 52 45 20 |r = NULL|. WHERE |
|00003920| 74 65 61 6d 5f 6c 65 61 | 64 65 72 20 3d 20 3a 65 |team_lea|der = :e|
|00003930| 6d 70 5f 6e 75 6d 3b 0a | 0a 20 2f 2a 0a 20 20 2a |mp_num;.|. /*.  *|
|00003940| 20 44 65 6c 65 74 65 20 | 74 68 65 20 65 6d 70 6c | Delete |the empl|
|00003950| 6f 79 65 65 20 66 72 6f | 6d 20 61 6e 79 20 70 72 |oyee fro|m any pr|
|00003960| 6f 6a 65 63 74 73 2e 0a | 20 20 2a 2f 0a 20 44 45 |ojects..|  */. DE|
|00003970| 4c 45 54 45 20 46 52 4f | 4d 20 65 6d 70 6c 6f 79 |LETE FRO|M employ|
|00003980| 65 65 5f 70 72 6f 6a 65 | 63 74 0a 20 57 48 45 52 |ee_proje|ct. WHER|
|00003990| 45 20 65 6d 70 5f 6e 6f | 20 3d 20 3a 65 6d 70 5f |E emp_no| = :emp_|
|000039a0| 6e 75 6d 3b 0a 0a 20 2f | 2a 0a 20 20 2a 20 44 65 |num;.. /|*.  * De|
|000039b0| 6c 65 74 65 20 6f 6c 64 | 20 73 61 6c 61 72 79 20 |lete old| salary |
|000039c0| 72 65 63 6f 72 64 73 2e | 0a 20 20 2a 2f 0a 20 44 |records.|.  */. D|
|000039d0| 45 4c 45 54 45 20 46 52 | 4f 4d 20 73 61 6c 61 72 |ELETE FR|OM salar|
|000039e0| 79 5f 68 69 73 74 6f 72 | 79 0a 20 57 48 45 52 45 |y_histor|y. WHERE|
|000039f0| 20 65 6d 70 5f 6e 6f 20 | 3d 20 3a 65 6d 70 5f 6e | emp_no |= :emp_n|
|00003a00| 75 6d 3b 0a 0a 20 2f 2a | 0a 20 20 2a 20 44 65 6c |um;.. /*|.  * Del|
|00003a10| 65 74 65 20 74 68 65 20 | 65 6d 70 6c 6f 79 65 65 |ete the |employee|
|00003a20| 2e 0a 20 20 2a 2f 0a 20 | 44 45 4c 45 54 45 20 46 |..  */. |DELETE F|
|00003a30| 52 4f 4d 20 65 6d 70 6c | 6f 79 65 65 0a 20 57 48 |ROM empl|oyee. WH|
|00003a40| 45 52 45 20 65 6d 70 5f | 6e 6f 20 3d 20 3a 65 6d |ERE emp_|no = :em|
|00003a50| 70 5f 6e 75 6d 3b 0a 0a | 20 53 55 53 50 45 4e 44 |p_num;..| SUSPEND|
|00003a60| 3b 0a 45 4e 44 00 08 04 | a9 01 00 00 04 02 04 00 |;.END...|........|
|00003a70| 02 00 08 00 07 00 04 01 | 01 00 07 00 0c 00 02 03 |........|........|
|00003a80| 00 00 08 00 01 2d 1a 00 | 00 9b 11 00 02 02 01 15 |.....-..|........|
|00003a90| 08 00 00 00 00 00 1a 00 | 00 07 7f 43 01 4f 01 43 |........|...C.O.C|
|00003aa0| 01 4a 05 53 41 4c 45 53 | 00 47 2f 17 00 09 53 41 |.J.SALES|.G/...SA|
|00003ab0| 4c 45 53 5f 52 45 50 29 | 00 00 00 01 00 ff 4e 00 |LES_REP)|......N.|
|00003ac0| 4d 01 00 00 00 5d 17 00 | 09 50 4f 5f 4e 55 4d 42 |M....]..|.PO_NUMB|
|00003ad0| 45 52 ff 02 01 18 01 00 | 00 1a 00 00 ff 08 31 1a |ER......|......1.|
|00003ae0| 00 00 15 08 00 00 00 00 | 00 02 02 80 02 0e 52 45 |........|......RE|
|00003af0| 41 53 53 49 47 4e 5f 53 | 41 4c 45 53 02 0e 01 02 |ASSIGN_S|ALES....|
|00003b00| 01 15 07 00 01 00 19 01 | 00 00 ff 9b ff ff ff ff |........|........|
|00003b10| 07 43 01 4a 0a 44 45 50 | 41 52 54 4d 45 4e 54 02 |.C.J.DEP|ARTMENT.|
|00003b20| 47 2f 17 02 07 4d 4e 47 | 52 5f 4e 4f 29 00 00 00 |G/...MNG|R_NO)...|
|00003b30| 01 00 ff 0a 02 02 02 01 | 2d 17 02 07 4d 4e 47 52 |........|-...MNGR|
|00003b40| 5f 4e 4f ff 07 43 01 4a | 07 50 52 4f 4a 45 43 54 |_NO..C.J|.PROJECT|
|00003b50| 03 47 2f 17 03 0b 54 45 | 41 4d 5f 4c 45 41 44 45 |.G/...TE|AM_LEADE|
|00003b60| 52 29 00 00 00 01 00 ff | 0a 03 03 02 01 2d 17 03 |R)......|.....-..|
|00003b70| 0b 54 45 41 4d 5f 4c 45 | 41 44 45 52 ff 07 43 01 |.TEAM_LE|ADER..C.|
|00003b80| 4a 10 45 4d 50 4c 4f 59 | 45 45 5f 50 52 4f 4a 45 |J.EMPLOY|EE_PROJE|
|00003b90| 43 54 04 47 2f 17 04 06 | 45 4d 50 5f 4e 4f 29 00 |CT.G/...|EMP_NO).|
|00003ba0| 00 00 01 00 ff 05 04 07 | 43 01 4a 0e 53 41 4c 41 |........|C.J.SALA|
|00003bb0| 52 59 5f 48 49 53 54 4f | 52 59 05 47 2f 17 05 06 |RY_HISTO|RY.G/...|
|00003bc0| 45 4d 50 5f 4e 4f 29 00 | 00 00 01 00 ff 05 05 07 |EMP_NO).|........|
|00003bd0| 43 01 4a 08 45 4d 50 4c | 4f 59 45 45 06 47 2f 17 |C.J.EMPL|OYEE.G/.|
|00003be0| 06 06 45 4d 50 5f 4e 4f | 29 00 00 00 01 00 ff 05 |..EMP_NO|).......|
|00003bf0| 06 02 0e 01 02 01 15 07 | 00 01 00 19 01 00 00 ff |........|........|
|00003c00| 9b ff ff ff ff 0e 01 02 | 01 15 07 00 00 00 19 01 |........|........|
|00003c10| 00 00 ff ff 4c 09 13 53 | 51 4c 24 44 45 4c 45 54 |....L..S|QL$DELET|
|00003c20| 45 5f 45 4d 50 4c 4f 59 | 45 45 0a 06 53 59 53 44 |E_EMPLOY|EE..SYSD|
|00003c30| 42 41 00 1c 01 07 45 4d | 50 5f 4e 55 4d 02 04 00 |BA....EM|P_NUM...|
|00003c40| 00 00 00 03 04 00 00 00 | 00 04 06 52 44 42 24 34 |........|...RDB$4|
|00003c50| 31 00 1d 1b 01 0b 44 45 | 50 54 5f 42 55 44 47 45 |1.....DE|PT_BUDGE|
|00003c60| 54 02 04 01 00 00 00 03 | 04 01 00 00 00 07 04 e1 |T.......|........|
|00003c70| 01 00 00 0a 20 44 45 43 | 4c 41 52 45 20 56 41 52 |.... DEC|LARE VAR|
|00003c80| 49 41 42 4c 45 20 73 75 | 6d 62 20 44 45 43 49 4d |IABLE su|mb DECIM|
|00003c90| 41 4c 28 31 32 2c 20 32 | 29 3b 0a 20 44 45 43 4c |AL(12, 2|);. DECL|
|00003ca0| 41 52 45 20 56 41 52 49 | 41 42 4c 45 20 72 64 6e |ARE VARI|ABLE rdn|
|00003cb0| 6f 20 43 48 41 52 28 33 | 29 3b 0a 20 44 45 43 4c |o CHAR(3|);. DECL|
|00003cc0| 41 52 45 20 56 41 52 49 | 41 42 4c 45 20 63 6e 74 |ARE VARI|ABLE cnt|
|00003cd0| 20 49 4e 54 45 47 45 52 | 3b 0a 42 45 47 49 4e 0a | INTEGER|;.BEGIN.|
|00003ce0| 20 74 6f 74 20 3d 20 30 | 3b 0a 0a 20 53 45 4c 45 | tot = 0|;.. SELE|
|00003cf0| 43 54 20 62 75 64 67 65 | 74 20 46 52 4f 4d 20 64 |CT budge|t FROM d|
|00003d00| 65 70 61 72 74 6d 65 6e | 74 20 57 48 45 52 45 20 |epartmen|t WHERE |
|00003d10| 64 65 70 74 5f 6e 6f 20 | 3d 20 3a 64 6e 6f 20 49 |dept_no |= :dno I|
|00003d20| 4e 54 4f 20 3a 74 6f 74 | 3b 0a 0a 20 53 45 4c 45 |NTO :tot|;.. SELE|
|00003d30| 43 54 20 63 6f 75 6e 74 | 28 62 75 64 67 65 74 29 |CT count|(budget)|
|00003d40| 20 46 52 4f 4d 20 64 65 | 70 61 72 74 6d 65 6e 74 | FROM de|partment|
|00003d50| 20 57 48 45 52 45 20 68 | 65 61 64 5f 64 65 70 74 | WHERE h|ead_dept|
|00003d60| 20 3d 20 3a 64 6e 6f 20 | 49 4e 54 4f 20 3a 63 6e | = :dno |INTO :cn|
|00003d70| 74 3b 0a 0a 20 49 46 20 | 28 63 6e 74 20 3d 20 30 |t;.. IF |(cnt = 0|
|00003d80| 29 20 54 48 45 4e 0a 20 | 20 53 55 53 50 45 4e 44 |) THEN. | SUSPEND|
|00003d90| 3b 0a 0a 20 46 4f 52 20 | 53 45 4c 45 43 54 20 64 |;.. FOR |SELECT d|
|00003da0| 65 70 74 5f 6e 6f 0a 20 | 20 46 52 4f 4d 20 64 65 |ept_no. | FROM de|
|00003db0| 70 61 72 74 6d 65 6e 74 | 0a 20 20 57 48 45 52 45 |partment|.  WHERE|
|00003dc0| 20 68 65 61 64 5f 64 65 | 70 74 20 3d 20 3a 64 6e | head_de|pt = :dn|
|00003dd0| 6f 0a 20 20 49 4e 54 4f | 20 3a 72 64 6e 6f 0a 20 |o.  INTO| :rdno. |
|00003de0| 44 4f 0a 20 20 42 45 47 | 49 4e 0a 20 20 20 45 58 |DO.  BEG|IN.   EX|
|00003df0| 45 43 55 54 45 20 50 52 | 4f 43 45 44 55 52 45 20 |ECUTE PR|OCEDURE |
|00003e00| 64 65 70 74 5f 62 75 64 | 67 65 74 20 3a 72 64 6e |dept_bud|get :rdn|
|00003e10| 6f 20 52 45 54 55 52 4e | 49 4e 47 5f 56 41 4c 55 |o RETURN|ING_VALU|
|00003e20| 45 53 20 3a 73 75 6d 62 | 3b 0a 20 20 20 74 6f 74 |ES :sumb|;.   tot|
|00003e30| 20 3d 20 74 6f 74 20 2b | 20 73 75 6d 62 3b 0a 20 | = tot +| sumb;. |
|00003e40| 20 45 4e 44 0a 0a 20 53 | 55 53 50 45 4e 44 3b 0a | END.. S|USPEND;.|
|00003e50| 45 4e 44 00 08 04 86 01 | 00 00 04 02 04 00 02 00 |END.....|........|
|00003e60| 0f 00 00 03 00 07 00 04 | 01 03 00 1b 07 00 07 00 |........|........|
|00003e70| 0c 00 02 03 00 00 1b 01 | 2d 1a 00 00 03 01 00 1b |........|-.......|
|00003e80| 01 2d 1a 01 00 03 02 00 | 0f 00 00 03 00 01 2d 1a |.-......|......-.|
|00003e90| 02 00 03 03 00 08 00 01 | 2d 1a 03 00 9b 11 00 02 |........|-.......|
|00003ea0| 02 01 15 08 00 00 00 00 | 00 1a 00 00 07 7f 43 01 |........|......C.|
|00003eb0| 4a 0a 44 45 50 41 52 54 | 4d 45 4e 54 00 47 2f 17 |J.DEPART|MENT.G/.|
|00003ec0| 00 07 44 45 50 54 5f 4e | 4f 29 00 00 00 01 00 ff |..DEPT_N|O)......|
|00003ed0| 02 01 17 00 06 42 55 44 | 47 45 54 1a 00 00 ff 07 |.....BUD|GET.....|
|00003ee0| 7f 43 01 4f 02 43 01 4a | 0a 44 45 50 41 52 54 4d |.C.O.C.J|.DEPARTM|
|00003ef0| 45 4e 54 01 47 2f 17 01 | 09 48 45 41 44 5f 44 45 |ENT.G/..|.HEAD_DE|
|00003f00| 50 54 29 00 00 00 01 00 | ff 4e 00 4d 01 00 00 00 |PT).....|.N.M....|
|00003f10| 5d 17 01 06 42 55 44 47 | 45 54 ff 02 01 18 02 00 |]...BUDG|ET......|
|00003f20| 00 1a 03 00 ff 08 2f 1a | 03 00 15 08 00 00 00 00 |....../.|........|
|00003f30| 00 02 0e 01 02 01 1a 00 | 00 29 01 00 00 01 00 01 |........|.)......|
|00003f40| 15 07 00 01 00 19 01 02 | 00 ff 9b ff ff 07 43 01 |........|......C.|
|00003f50| 4a 0a 44 45 50 41 52 54 | 4d 45 4e 54 03 47 2f 17 |J.DEPART|MENT.G/.|
|00003f60| 03 09 48 45 41 44 5f 44 | 45 50 54 29 00 00 00 01 |..HEAD_D|EPT)....|
|00003f70| 00 ff 02 01 17 03 07 44 | 45 50 54 5f 4e 4f 1a 02 |.......D|EPT_NO..|
|00003f80| 00 02 02 78 0b 44 45 50 | 54 5f 42 55 44 47 45 54 |...x.DEP|T_BUDGET|
|00003f90| 01 00 1a 02 00 01 00 1a | 01 00 01 22 1a 00 00 1a |........|..."....|
|00003fa0| 01 00 1a 00 00 ff ff ff | 02 0e 01 02 01 1a 00 00 |........|........|
|00003fb0| 29 01 00 00 01 00 01 15 | 07 00 01 00 19 01 02 00 |).......|........|
|00003fc0| ff 9b ff ff ff ff 0e 01 | 02 01 1a 00 00 29 01 00 |........|.....)..|
|00003fd0| 00 01 00 01 15 07 00 00 | 00 19 01 02 00 ff ff 4c |........|.......L|
|00003fe0| 09 0f 53 51 4c 24 44 45 | 50 54 5f 42 55 44 47 45 |..SQL$DE|PT_BUDGE|
|00003ff0| 54 0a 06 53 59 53 44 42 | 41 00 1c 01 03 44 4e 4f |T..SYSDB|A....DNO|
|00004000| 02 04 00 00 00 00 03 04 | 00 00 00 00 04 06 52 44 |........|......RD|
|00004010| 42 24 34 32 00 1c 01 03 | 54 4f 54 02 04 00 00 00 |B$42....|TOT.....|
|00004020| 00 03 04 01 00 00 00 04 | 06 52 44 42 24 34 33 00 |........|.RDB$43.|
|00004030| 1d 1b 01 09 4f 52 47 5f | 43 48 41 52 54 02 04 00 |....ORG_|CHART...|
|00004040| 00 00 00 03 04 05 00 00 | 00 07 04 4b 02 00 00 0a |........|...K....|
|00004050| 20 44 45 43 4c 41 52 45 | 20 56 41 52 49 41 42 4c | DECLARE| VARIABL|
|00004060| 45 20 6d 6e 67 72 5f 6e | 6f 20 49 4e 54 45 47 45 |E mngr_n|o INTEGE|
|00004070| 52 3b 0a 20 44 45 43 4c | 41 52 45 20 56 41 52 49 |R;. DECL|ARE VARI|
|00004080| 41 42 4c 45 20 64 6e 6f | 20 43 48 41 52 28 33 29 |ABLE dno| CHAR(3)|
|00004090| 3b 0a 42 45 47 49 4e 0a | 20 46 4f 52 20 53 45 4c |;.BEGIN.| FOR SEL|
|000040a0| 45 43 54 20 68 2e 64 65 | 70 61 72 74 6d 65 6e 74 |ECT h.de|partment|
|000040b0| 2c 20 64 2e 64 65 70 61 | 72 74 6d 65 6e 74 2c 20 |, d.depa|rtment, |
|000040c0| 64 2e 6d 6e 67 72 5f 6e | 6f 2c 20 64 2e 64 65 70 |d.mngr_n|o, d.dep|
|000040d0| 74 5f 6e 6f 0a 20 20 46 | 52 4f 4d 20 64 65 70 61 |t_no.  F|ROM depa|
|000040e0| 72 74 6d 65 6e 74 20 64 | 0a 20 20 4c 45 46 54 20 |rtment d|.  LEFT |
|000040f0| 4f 55 54 45 52 20 4a 4f | 49 4e 20 64 65 70 61 72 |OUTER JO|IN depar|
|00004100| 74 6d 65 6e 74 20 68 20 | 4f 4e 20 64 2e 68 65 61 |tment h |ON d.hea|
|00004110| 64 5f 64 65 70 74 20 3d | 20 68 2e 64 65 70 74 5f |d_dept =| h.dept_|
|00004120| 6e 6f 0a 20 20 4f 52 44 | 45 52 20 42 59 20 64 2e |no.  ORD|ER BY d.|
|00004130| 64 65 70 74 5f 6e 6f 0a | 20 20 49 4e 54 4f 20 3a |dept_no.|  INTO :|
|00004140| 68 65 61 64 5f 64 65 70 | 74 2c 20 3a 64 65 70 61 |head_dep|t, :depa|
|00004150| 72 74 6d 65 6e 74 2c 20 | 3a 6d 6e 67 72 5f 6e 6f |rtment, |:mngr_no|
|00004160| 2c 20 3a 64 6e 6f 0a 20 | 44 4f 0a 20 42 45 47 49 |, :dno. |DO. BEGI|
|00004170| 4e 0a 20 20 49 46 20 28 | 3a 6d 6e 67 72 5f 6e 6f |N.  IF (|:mngr_no|
|00004180| 20 49 53 20 4e 55 4c 4c | 29 20 54 48 45 4e 0a 20 | IS NULL|) THEN. |
|00004190| 20 42 45 47 49 4e 0a 20 | 20 20 6d 6e 67 72 5f 6e | BEGIN. |  mngr_n|
|000041a0| 61 6d 65 20 3d 20 22 2d | 2d 54 42 48 2d 2d 22 3b |ame = "-|-TBH--";|
|000041b0| 0a 20 20 20 74 69 74 6c | 65 20 3d 20 22 22 3b 0a |.   titl|e = "";.|
|000041c0| 20 20 45 4e 44 0a 0a 20 | 20 45 4c 53 45 0a 20 20 |  END.. | ELSE.  |
|000041d0| 20 53 45 4c 45 43 54 20 | 66 75 6c 6c 5f 6e 61 6d | SELECT |full_nam|
|000041e0| 65 2c 20 6a 6f 62 5f 63 | 6f 64 65 0a 20 20 20 46 |e, job_c|ode.   F|
|000041f0| 52 4f 4d 20 65 6d 70 6c | 6f 79 65 65 0a 20 20 20 |ROM empl|oyee.   |
|00004200| 57 48 45 52 45 20 65 6d | 70 5f 6e 6f 20 3d 20 3a |WHERE em|p_no = :|
|00004210| 6d 6e 67 72 5f 6e 6f 0a | 20 20 20 49 4e 54 4f 20 |mngr_no.|   INTO |
|00004220| 3a 6d 6e 67 72 5f 6e 61 | 6d 65 2c 20 3a 74 69 74 |:mngr_na|me, :tit|
|00004230| 6c 65 3b 0a 0a 20 20 53 | 45 4c 45 43 54 20 43 4f |le;..  S|ELECT CO|
|00004240| 55 4e 54 28 65 6d 70 5f | 6e 6f 29 0a 20 20 46 00 |UNT(emp_|no).  F.|
|00004250| 52 4f 4d 20 65 6d 70 6c | 6f 79 65 65 0a 20 20 57 |ROM empl|oyee.  W|
|00004260| 48 45 52 45 20 64 65 70 | 74 5f 6e 6f 20 3d 20 3a |HERE dep|t_no = :|
|00004270| 64 6e 6f 0a 20 20 49 4e | 54 4f 20 3a 65 6d 70 5f |dno.  IN|TO :emp_|
|00004280| 63 6e 74 3b 0a 0a 20 20 | 53 55 53 50 45 4e 44 3b |cnt;..  |SUSPEND;|
|00004290| 0a 20 45 4e 44 0a 45 4e | 44 00 08 04 3d 02 00 00 |. END.EN|D...=...|
|000042a0| 04 02 04 01 0b 00 0f 00 | 00 19 00 07 00 0f 00 00 |........|........|
|000042b0| 19 00 07 00 0f 00 00 14 | 00 07 00 0f 00 00 05 00 |........|........|
|000042c0| 07 00 08 00 07 00 07 00 | 02 03 00 00 0f 00 00 19 |........|........|
|000042d0| 00 01 2d 1a 00 00 03 01 | 00 0f 00 00 19 00 01 2d |..-.....|.......-|
|000042e0| 1a 01 00 03 02 00 0f 00 | 00 14 00 01 2d 1a 02 00 |........|....-...|
|000042f0| 03 03 00 0f 00 00 05 00 | 01 2d 1a 03 00 03 04 00 |........|.-......|
|00004300| 08 00 01 2d 1a 04 00 03 | 05 00 08 00 01 2d 1a 05 |...-....|.....-..|
|00004310| 00 03 06 00 0f 00 00 03 | 00 01 2d 1a 06 00 9b 11 |........|..-.....|
|00004320| 00 02 02 07 43 01 77 02 | 92 0a 44 45 50 41 52 54 |....C.w.|..DEPART|
|00004330| 4d 45 4e 54 01 44 00 92 | 0a 44 45 50 41 52 54 4d |MENT.D..|.DEPARTM|
|00004340| 45 4e 54 01 48 01 50 01 | 47 2f 17 00 09 48 45 41 |ENT.H.P.|G/...HEA|
|00004350| 44 5f 44 45 50 54 17 01 | 07 44 45 50 54 5f 4e 4f |D_DEPT..|.DEPT_NO|
|00004360| ff 46 01 48 17 00 07 44 | 45 50 54 5f 4e 4f ff 02 |.F.H...D|EPT_NO..|
|00004370| 01 17 01 0a 44 45 50 41 | 52 54 4d 45 4e 54 1a 00 |....DEPA|RTMENT..|
|00004380| 00 01 17 00 0a 44 45 50 | 41 52 54 4d 45 4e 54 1a |.....DEP|ARTMENT.|
|00004390| 01 00 01 17 00 07 4d 4e | 47 52 5f 4e 4f 1a 05 00 |......MN|GR_NO...|
|000043a0| 01 17 00 07 44 45 50 54 | 5f 4e 4f 1a 06 00 02 02 |....DEPT|_NO.....|
|000043b0| 08 3d 1a 05 00 02 02 01 | 15 0f 7f 00 07 00 2d 2d |.=......|......--|
|000043c0| 54 42 48 2d 2d 1a 02 00 | 01 15 0f 7f 00 00 00 1a |TBH--...|........|
|000043d0| 03 00 ff ff 07 7f 43 01 | 4a 08 45 4d 50 4c 4f 59 |......C.|J.EMPLOY|
|000043e0| 45 45 02 47 2f 17 02 06 | 45 4d 50 5f 4e 4f 1a 05 |EE.G/...|EMP_NO..|
|000043f0| 00 ff 02 01 17 02 09 46 | 55 4c 4c 5f 4e 41 4d 45 |.......F|ULL_NAME|
|00004400| 1a 02 00 01 17 02 08 4a | 4f 42 5f 43 4f 44 45 1a |.......J|OB_CODE.|
|00004410| 03 00 ff 07 7f 43 01 4f | 04 43 01 4a 08 45 4d 50 |.....C.O|.C.J.EMP|
|00004420| 4c 4f 59 45 45 03 47 2f | 17 03 07 44 45 50 54 5f |LOYEE.G/|...DEPT_|
|00004430| 4e 4f 1a 06 00 ff 4e 00 | 4d 01 00 00 00 5d 17 03 |NO....N.|M....]..|
|00004440| 06 45 4d 50 5f 4e 4f ff | 02 01 18 04 00 00 1a 04 |.EMP_NO.|........|
|00004450| 00 ff 02 0e 01 02 01 1a | 00 00 29 01 00 00 01 00 |........|..).....|
|00004460| 01 1a 01 00 29 01 02 00 | 03 00 01 1a 02 00 29 01 |....)...|......).|
|00004470| 04 00 05 00 01 1a 03 00 | 29 01 06 00 07 00 01 1a |........|).......|
|00004480| 04 00 29 01 08 00 09 00 | 01 15 07 00 01 00 19 01 |..).....|........|
|00004490| 0a 00 ff 9b ff ff ff ff | ff ff ff 0e 01 02 01 1a |........|........|
|000044a0| 00 00 29 01 00 00 01 00 | 01 1a 01 00 29 01 02 00 |..).....|....)...|
|000044b0| 03 00 01 1a 02 00 29 01 | 04 00 05 00 01 1a 03 00 |......).|........|
|000044c0| 29 01 06 00 07 00 01 1a | 04 00 29 01 08 00 09 00 |).......|..).....|
|000044d0| 01 15 07 00 00 00 19 01 | 0a 00 ff ff 4c 09 0d 53 |........|....L..S|
|000044e0| 51 4c 24 4f 52 47 5f 43 | 48 41 52 54 0a 06 53 59 |QL$ORG_C|HART..SY|
|000044f0| 53 44 42 41 00 1c 01 09 | 48 45 41 44 5f 44 45 50 |SDBA....|HEAD_DEP|
|00004500| 54 02 04 00 00 00 00 03 | 04 01 00 00 00 04 06 52 |T.......|.......R|
|00004510| 44 42 24 34 34 00 1c 01 | 0a 44 45 50 41 52 54 4d |DB$44...|.DEPARTM|
|00004520| 45 4e 54 02 04 01 00 00 | 00 03 04 01 00 00 00 04 |ENT.....|........|
|00004530| 06 52 44 42 24 34 35 00 | 1c 01 09 4d 4e 47 52 5f |.RDB$45.|...MNGR_|
|00004540| 4e 41 4d 45 02 04 02 00 | 00 00 03 04 01 00 00 00 |NAME....|........|
|00004550| 04 06 52 44 42 24 34 36 | 00 1c 01 05 54 49 54 4c |..RDB$46|....TITL|
|00004560| 45 02 04 03 00 00 00 03 | 04 01 00 00 00 04 06 52 |E.......|.......R|
|00004570| 44 42 24 34 37 00 1c 01 | 07 45 4d 50 5f 43 4e 54 |DB$47...|.EMP_CNT|
|00004580| 02 04 04 00 00 00 03 04 | 01 00 00 00 04 06 52 44 |........|......RD|
|00004590| 42 24 34 38 00 1d 1b 01 | 0a 4d 41 49 4c 5f 4c 41 |B$48....|.MAIL_LA|
|000045a0| 42 45 4c 02 04 01 00 00 | 00 03 04 06 00 00 00 07 |BEL.....|........|
|000045b0| 04 f8 04 00 00 0a 20 44 | 45 43 4c 41 52 45 20 56 |...... D|ECLARE V|
|000045c0| 41 52 49 41 42 4c 45 20 | 63 75 73 74 6f 6d 65 72 |ARIABLE |customer|
|000045d0| 20 56 41 52 43 48 41 52 | 28 32 35 29 3b 0a 20 44 | VARCHAR|(25);. D|
|000045e0| 45 43 4c 41 52 45 20 56 | 41 52 49 41 42 4c 45 20 |ECLARE V|ARIABLE |
|000045f0| 66 69 72 73 74 20 20 56 | 41 52 43 48 41 52 28 31 |first  V|ARCHAR(1|
|00004600| 35 29 3b 0a 20 44 45 43 | 4c 41 52 45 20 56 41 52 |5);. DEC|LARE VAR|
|00004610| 49 41 42 4c 45 20 6c 61 | 73 74 20 20 56 41 52 43 |IABLE la|st  VARC|
|00004620| 48 41 52 28 32 30 29 3b | 0a 20 44 45 43 4c 41 52 |HAR(20);|. DECLAR|
|00004630| 45 20 56 41 52 49 41 42 | 4c 45 20 61 64 64 72 31 |E VARIAB|LE addr1|
|00004640| 20 20 56 41 52 43 48 41 | 52 28 33 30 29 3b 0a 20 |  VARCHA|R(30);. |
|00004650| 44 45 43 4c 41 52 45 20 | 56 41 52 49 41 42 4c 45 |DECLARE |VARIABLE|
|00004660| 20 61 64 64 72 32 20 20 | 56 41 52 43 48 41 52 28 | addr2  |VARCHAR(|
|00004670| 33 30 29 3b 0a 20 44 45 | 43 4c 41 52 45 20 56 41 |30);. DE|CLARE VA|
|00004680| 52 49 41 42 4c 45 20 63 | 69 74 79 20 20 56 41 52 |RIABLE c|ity  VAR|
|00004690| 43 48 41 52 28 32 35 29 | 3b 0a 20 44 45 43 4c 41 |CHAR(25)|;. DECLA|
|000046a0| 52 45 20 56 41 52 49 41 | 42 4c 45 20 73 74 61 74 |RE VARIA|BLE stat|
|000046b0| 65 20 20 56 41 52 43 48 | 41 52 28 31 35 29 3b 0a |e  VARCH|AR(15);.|
|000046c0| 20 44 45 43 4c 41 52 45 | 20 56 41 52 49 41 42 4c | DECLARE| VARIABL|
|000046d0| 45 20 63 6f 75 6e 74 72 | 79 20 56 41 52 43 48 41 |E countr|y VARCHA|
|000046e0| 52 28 31 35 29 3b 0a 20 | 44 45 43 4c 41 52 45 20 |R(15);. |DECLARE |
|000046f0| 56 41 52 49 41 42 4c 45 | 20 70 6f 73 74 63 6f 64 |VARIABLE| postcod|
|00004700| 65 20 56 41 52 43 48 41 | 52 28 31 32 29 3b 0a 20 |e VARCHA|R(12);. |
|00004710| 44 45 43 4c 41 52 45 20 | 56 41 52 49 41 42 4c 45 |DECLARE |VARIABLE|
|00004720| 20 63 6e 74 20 20 49 4e | 54 45 47 45 52 3b 0a 42 | cnt  IN|TEGER;.B|
|00004730| 45 47 49 4e 0a 20 6c 69 | 6e 65 31 20 3d 20 22 22 |EGIN. li|ne1 = ""|
|00004740| 3b 0a 20 6c 69 6e 65 32 | 20 3d 20 22 22 3b 0a 20 |;. line2| = "";. |
|00004750| 6c 69 6e 65 33 20 3d 20 | 22 22 3b 0a 20 6c 69 6e |line3 = |"";. lin|
|00004760| 65 34 20 3d 20 22 22 3b | 0a 20 6c 69 6e 65 35 20 |e4 = "";|. line5 |
|00004770| 3d 20 22 22 3b 0a 20 6c | 69 6e 65 36 20 3d 20 22 |= "";. l|ine6 = "|
|00004780| 22 3b 0a 0a 20 53 45 4c | 45 43 54 20 63 75 73 74 |";.. SEL|ECT cust|
|00004790| 6f 6d 65 72 2c 20 63 6f | 6e 74 61 63 74 5f 66 69 |omer, co|ntact_fi|
|000047a0| 72 73 74 2c 20 63 6f 6e | 74 61 63 74 5f 6c 61 73 |rst, con|tact_las|
|000047b0| 74 2c 20 61 64 00 64 72 | 65 73 73 5f 6c 69 6e 65 |t, ad.dr|ess_line|
|000047c0| 31 2c 0a 20 20 61 64 64 | 72 65 73 73 5f 6c 69 6e |1,.  add|ress_lin|
|000047d0| 65 32 2c 20 63 69 74 79 | 2c 20 73 74 61 74 65 5f |e2, city|, state_|
|000047e0| 70 72 6f 76 69 6e 63 65 | 2c 20 63 6f 75 6e 74 72 |province|, countr|
|000047f0| 79 2c 20 70 6f 73 74 61 | 6c 5f 63 6f 64 65 0a 20 |y, posta|l_code. |
|00004800| 46 52 4f 4d 20 43 55 53 | 54 4f 4d 45 52 0a 20 57 |FROM CUS|TOMER. W|
|00004810| 48 45 52 45 20 63 75 73 | 74 5f 6e 6f 20 3d 20 3a |HERE cus|t_no = :|
|00004820| 63 75 73 74 5f 6e 6f 0a | 20 49 4e 54 4f 20 3a 63 |cust_no.| INTO :c|
|00004830| 75 73 74 6f 6d 65 72 2c | 20 3a 66 69 72 73 74 2c |ustomer,| :first,|
|00004840| 20 3a 6c 61 73 74 2c 20 | 3a 61 64 64 72 31 2c 20 | :last, |:addr1, |
|00004850| 3a 61 64 64 72 32 2c 0a | 20 20 3a 63 69 74 79 2c |:addr2,.|  :city,|
|00004860| 20 3a 73 74 61 74 65 2c | 20 3a 63 6f 75 6e 74 72 | :state,| :countr|
|00004870| 79 2c 20 3a 70 6f 73 74 | 63 6f 64 65 3b 0a 0a 20 |y, :post|code;.. |
|00004880| 49 46 20 28 63 75 73 74 | 6f 6d 65 72 20 49 53 20 |IF (cust|omer IS |
|00004890| 4e 4f 54 20 4e 55 4c 4c | 29 20 54 48 45 4e 0a 20 |NOT NULL|) THEN. |
|000048a0| 20 6c 69 6e 65 31 20 3d | 20 63 75 73 74 6f 6d 65 | line1 =| custome|
|000048b0| 72 3b 0a 20 49 46 20 28 | 66 69 72 73 74 20 49 53 |r;. IF (|first IS|
|000048c0| 20 4e 4f 54 20 4e 55 4c | 4c 29 20 54 48 45 4e 0a | NOT NUL|L) THEN.|
|000048d0| 20 20 6c 69 6e 65 32 20 | 3d 20 66 69 72 73 74 20 |  line2 |= first |
|000048e0| 7c 7c 20 22 20 22 20 7c | 7c 20 6c 61 73 74 3b 0a ||| " " ||| last;.|
|000048f0| 20 45 4c 53 45 0a 20 20 | 6c 69 6e 65 32 20 3d 20 | ELSE.  |line2 = |
|00004900| 6c 61 73 74 3b 0a 20 49 | 46 20 28 61 64 64 72 31 |last;. I|F (addr1|
|00004910| 20 49 53 20 4e 4f 54 20 | 4e 55 4c 4c 29 20 54 48 | IS NOT |NULL) TH|
|00004920| 45 4e 0a 20 20 6c 69 6e | 65 33 20 3d 20 61 64 64 |EN.  lin|e3 = add|
|00004930| 72 31 3b 0a 20 49 46 20 | 28 61 64 64 72 32 20 49 |r1;. IF |(addr2 I|
|00004940| 53 20 4e 4f 54 20 4e 55 | 4c 4c 29 20 54 48 45 4e |S NOT NU|LL) THEN|
|00004950| 0a 20 20 6c 69 6e 65 34 | 20 3d 20 61 64 64 72 32 |.  line4| = addr2|
|00004960| 3b 0a 0a 20 49 46 20 28 | 63 6f 75 6e 74 72 79 20 |;.. IF (|country |
|00004970| 3d 20 22 55 53 41 22 29 | 20 54 48 45 4e 0a 20 42 |= "USA")| THEN. B|
|00004980| 45 47 49 4e 0a 20 20 49 | 46 20 28 63 69 74 79 20 |EGIN.  I|F (city |
|00004990| 49 53 20 4e 4f 54 20 4e | 55 4c 4c 29 20 54 48 45 |IS NOT N|ULL) THE|
|000049a0| 4e 0a 20 20 20 6c 69 6e | 65 35 20 3d 20 63 69 74 |N.   lin|e5 = cit|
|000049b0| 79 20 7c 7c 20 22 00 2c | 20 22 20 7c 7c 20 73 74 |y || ".,| " || st|
|000049c0| 61 74 65 20 7c 7c 20 22 | 20 20 22 20 7c 7c 20 70 |ate || "|  " || p|
|000049d0| 6f 73 74 63 6f 64 65 3b | 0a 20 20 45 4c 53 45 0a |ostcode;|.  ELSE.|
|000049e0| 20 20 20 6c 69 6e 65 35 | 20 3d 20 73 74 61 74 65 |   line5| = state|
|000049f0| 20 7c 7c 20 22 20 20 22 | 20 7c 7c 20 70 6f 73 74 | || "  "| || post|
|00004a00| 63 6f 64 65 3b 0a 20 45 | 4e 44 0a 20 45 4c 53 45 |code;. E|ND. ELSE|
|00004a10| 0a 20 42 45 47 49 4e 0a | 20 20 49 46 20 28 63 69 |. BEGIN.|  IF (ci|
|00004a20| 74 79 20 49 53 20 4e 4f | 54 20 4e 55 4c 4c 29 20 |ty IS NO|T NULL) |
|00004a30| 54 48 45 4e 0a 20 20 20 | 6c 69 6e 65 35 20 3d 20 |THEN.   |line5 = |
|00004a40| 63 69 74 79 20 7c 7c 20 | 22 2c 20 22 20 7c 7c 20 |city || |", " || |
|00004a50| 73 74 61 74 65 3b 0a 20 | 20 45 4c 53 45 0a 20 20 |state;. | ELSE.  |
|00004a60| 20 6c 69 6e 65 35 20 3d | 20 73 74 61 74 65 3b 0a | line5 =| state;.|
|00004a70| 20 20 6c 69 6e 65 36 20 | 3d 20 63 6f 75 6e 74 72 |  line6 |= countr|
|00004a80| 79 20 7c 7c 20 22 20 20 | 20 20 22 20 7c 7c 20 70 |y || "  |  " || p|
|00004a90| 6f 73 74 63 6f 64 65 3b | 0a 20 45 4e 44 0a 0a 20 |ostcode;|. END.. |
|00004aa0| 53 55 53 50 45 4e 44 3b | 0a 45 4e 44 00 08 04 7b |SUSPEND;|.END...{|
|00004ab0| 03 00 00 04 02 04 00 02 | 00 08 00 07 00 04 01 0d |........|........|
|00004ac0| 00 0f 00 00 28 00 07 00 | 0f 00 00 28 00 07 00 0f |....(...|...(....|
|00004ad0| 00 00 28 00 07 00 0f 00 | 00 28 00 07 00 0f 00 00 |..(.....|.(......|
|00004ae0| 28 00 07 00 0f 00 00 28 | 00 07 00 07 00 0c 00 02 |(......(|........|
|00004af0| 03 00 00 0f 00 00 28 00 | 01 2d 1a 00 00 03 01 00 |......(.|.-......|
|00004b00| 0f 00 00 28 00 01 2d 1a | 01 00 03 02 00 0f 00 00 |...(..-.|........|
|00004b10| 28 00 01 2d 1a 02 00 03 | 03 00 0f 00 00 28 00 01 |(..-....|.....(..|
|00004b20| 2d 1a 03 00 03 04 00 0f | 00 00 28 00 01 2d 1a 04 |-.......|..(..-..|
|00004b30| 00 03 05 00 0f 00 00 28 | 00 01 2d 1a 05 00 03 06 |.......(|..-.....|
|00004b40| 00 26 00 00 19 00 01 2d | 1a 06 00 03 07 00 26 00 |.&.....-|......&.|
|00004b50| 00 0f 00 01 2d 1a 07 00 | 03 08 00 26 00 00 14 00 |....-...|...&....|
|00004b60| 01 2d 1a 08 00 03 09 00 | 26 00 00 1e 00 01 2d 1a |.-......|&.....-.|
|00004b70| 09 00 03 0a 00 26 00 00 | 1e 00 01 2d 1a 0a 00 03 |.....&..|...-....|
|00004b80| 0b 00 26 00 00 19 00 01 | 2d 1a 0b 00 03 0c 00 26 |..&.....|-......&|
|00004b90| 00 00 0f 00 01 2d 1a 0c | 00 03 0d 00 26 00 00 0f |.....-..|....&...|
|00004ba0| 00 01 2d 1a 0d 00 03 0e | 00 26 00 00 0c 00 01 2d |..-.....|.&.....-|
|00004bb0| 1a 0e 00 03 0f 00 08 00 | 01 2d 1a 0f 00 9b 11 00 |........|.-......|
|00004bc0| 02 02 01 15 0f 7f 00 00 | 00 1a 00 00 01 15 0f 7f |........|........|
|00004bd0| 00 00 00 1a 01 00 01 15 | 0f 7f 00 00 00 1a 02 00 |........|........|
|00004be0| 01 15 0f 7f 00 00 00 1a | 03 00 01 15 0f 7f 00 00 |........|........|
|00004bf0| 00 1a 04 00 01 15 0f 7f | 00 00 00 1a 05 00 07 7f |........|........|
|00004c00| 43 01 4a 08 43 55 53 54 | 4f 4d 45 52 00 47 2f 17 |C.J.CUST|OMER.G/.|
|00004c10| 00 07 43 55 53 54 5f 4e | 4f 29 00 00 00 01 00 ff |..CUST_N|O)......|
|00004c20| 02 01 17 00 08 43 55 53 | 54 4f 4d 45 52 1a 06 00 |.....CUS|TOMER...|
|00004c30| 01 17 00 0d 43 4f 4e 54 | 41 43 54 5f 46 49 52 53 |....CONT|ACT_FIRS|
|00004c40| 54 1a 07 00 01 17 00 0c | 43 4f 4e 54 41 43 54 5f |T.......|CONTACT_|
|00004c50| 4c 41 53 54 1a 08 00 01 | 17 00 0d 41 44 44 52 45 |LAST....|...ADDRE|
|00004c60| 53 53 5f 4c 49 4e 45 31 | 1a 09 00 01 17 00 0d 41 |SS_LINE1|.......A|
|00004c70| 44 44 52 45 53 53 5f 4c | 49 4e 45 32 1a 0a 00 01 |DDRESS_L|INE2....|
|00004c80| 17 00 04 43 49 54 59 1a | 0b 00 01 17 00 0e 53 54 |...CITY.|......ST|
|00004c90| 41 54 45 5f 50 52 4f 56 | 49 4e 43 45 1a 0c 00 01 |ATE_PROV|INCE....|
|00004ca0| 17 00 07 43 4f 55 4e 54 | 52 59 1a 0d 00 01 17 00 |...COUNT|RY......|
|00004cb0| 0b 50 4f 53 54 41 4c 5f | 43 4f 44 45 1a 0e 00 ff |.POSTAL_|CODE....|
|00004cc0| 08 3b 3d 1a 06 00 01 1a | 06 00 1a 00 00 ff 08 3b |.;=.....|.......;|
|00004cd0| 3d 1a 07 00 01 27 27 1a | 07 00 15 0f 7f 00 01 00 |=....''.|........|
|00004ce0| 20 1a 08 00 1a 01 00 01 | 1a 08 00 1a 01 00 08 3b | .......|.......;|
|00004cf0| 3d 1a 09 00 01 1a 09 00 | 1a 02 00 ff 08 3b 3d 1a |=.......|.....;=.|
|00004d00| 0a 00 01 1a 0a 00 1a 03 | 00 ff 08 2f 1a 0d 00 15 |........|.../....|
|00004d10| 0f 7f 00 03 00 55 53 41 | 02 02 08 3b 3d 1a 0b 00 |.....USA|...;=...|
|00004d20| 01 27 27 27 27 1a 0b 00 | 15 0f 7f 00 02 00 2c 20 |.''''...|......, |
|00004d30| 1a 0c 00 15 0f 7f 00 02 | 00 20 20 1a 0e 00 1a 04 |........|.  .....|
|00004d40| 00 01 27 27 1a 0c 00 15 | 0f 7f 00 02 00 20 20 1a |..''....|.....  .|
|00004d50| 0e 00 1a 04 00 ff ff 02 | 02 08 3b 3d 1a 0b 00 01 |........|..;=....|
|00004d60| 27 27 1a 0b 00 15 0f 7f | 00 02 00 2c 20 1a 0c 00 |''......|..., ...|
|00004d70| 1a 04 00 01 1a 0c 00 1a | 04 00 01 27 27 1a 0d 00 |........|...''...|
|00004d80| 15 0f 7f 00 04 00 20 20 | 20 20 1a 0e 00 1a 05 00 |......  |  ......|
|00004d90| ff ff 02 0e 01 02 01 1a | 00 00 29 01 00 00 01 00 |........|..).....|
|00004da0| 01 1a 01 00 29 01 02 00 | 03 00 01 1a 02 00 29 01 |....)...|......).|
|00004db0| 04 00 05 00 01 1a 03 00 | 29 01 06 00 07 00 01 1a |........|).......|
|00004dc0| 04 00 29 01 08 00 09 00 | 01 1a 05 00 29 01 0a 00 |..).....|....)...|
|00004dd0| 0b 00 01 15 07 00 01 00 | 19 01 0c 00 ff 9b ff ff |........|........|
|00004de0| ff ff 0e 01 02 01 1a 00 | 00 29 01 00 00 01 00 01 |........|.)......|
|00004df0| 1a 01 00 29 01 02 00 03 | 00 01 1a 02 00 29 01 04 |...)....|.....)..|
|00004e00| 00 05 00 01 1a 03 00 29 | 01 06 00 07 00 01 1a 04 |.......)|........|
|00004e10| 00 29 01 08 00 09 00 01 | 1a 05 00 29 01 0a 00 0b |.)......|...)....|
|00004e20| 00 01 15 07 00 00 00 19 | 01 0c 00 ff ff 4c 09 0e |........|.....L..|
|00004e30| 53 51 4c 24 4d 41 49 4c | 5f 4c 41 42 45 4c 0a 06 |SQL$MAIL|_LABEL..|
|00004e40| 53 59 53 44 42 41 00 1c | 01 07 43 55 53 54 5f 4e |SYSDBA..|..CUST_N|
|00004e50| 4f 02 04 00 00 00 00 03 | 04 00 00 00 00 04 06 52 |O.......|.......R|
|00004e60| 44 42 24 34 39 00 1c 01 | 05 4c 49 4e 45 31 02 04 |DB$49...|.LINE1..|
|00004e70| 00 00 00 00 03 04 01 00 | 00 00 04 06 52 44 42 24 |........|....RDB$|
|00004e80| 35 30 00 1c 01 05 4c 49 | 4e 45 32 02 04 01 00 00 |50....LI|NE2.....|
|00004e90| 00 03 04 01 00 00 00 04 | 06 52 44 42 24 35 31 00 |........|.RDB$51.|
|00004ea0| 1c 01 05 4c 49 4e 45 33 | 02 04 02 00 00 00 03 04 |...LINE3|........|
|00004eb0| 01 00 00 00 04 06 52 44 | 42 24 35 32 00 1c 01 05 |......RD|B$52....|
|00004ec0| 4c 49 4e 45 34 02 04 03 | 00 00 00 03 04 01 00 00 |LINE4...|........|
|00004ed0| 00 04 06 52 44 42 24 35 | 33 00 1c 01 05 4c 49 4e |...RDB$5|3....LIN|
|00004ee0| 45 35 02 04 04 00 00 00 | 03 04 01 00 00 00 04 06 |E5......|........|
|00004ef0| 52 44 42 24 35 34 00 1c | 01 05 4c 49 4e 45 36 02 |RDB$54..|..LINE6.|
|00004f00| 04 05 00 00 00 03 04 01 | 00 00 00 04 06 52 44 42 |........|.....RDB|
|00004f10| 24 35 35 00 1d 1b 01 0a | 53 48 49 50 5f 4f 52 44 |$55.....|SHIP_ORD|
|00004f20| 45 52 02 04 01 00 00 00 | 03 04 00 00 00 00 07 04 |ER......|........|
|00004f30| 49 04 00 00 0a 20 44 45 | 43 4c 41 52 45 20 56 41 |I.... DE|CLARE VA|
|00004f40| 52 49 41 42 4c 45 20 6f | 72 64 5f 73 74 61 74 20 |RIABLE o|rd_stat |
|00004f50| 43 48 41 52 28 37 29 3b | 0a 20 44 45 43 4c 41 52 |CHAR(7);|. DECLAR|
|00004f60| 45 20 56 41 52 49 41 42 | 4c 45 20 68 6f 6c 64 5f |E VARIAB|LE hold_|
|00004f70| 73 74 61 74 20 43 48 41 | 52 28 31 29 3b 0a 20 44 |stat CHA|R(1);. D|
|00004f80| 45 43 4c 41 52 45 20 56 | 41 52 49 41 42 4c 45 20 |ECLARE V|ARIABLE |
|00004f90| 63 75 73 74 5f 6e 6f 20 | 49 4e 54 45 47 45 52 3b |cust_no |INTEGER;|
|00004fa0| 0a 20 44 45 43 4c 41 52 | 45 20 56 41 52 49 41 42 |. DECLAR|E VARIAB|
|00004fb0| 4c 45 20 61 6e 79 5f 70 | 6f 20 43 48 41 52 28 38 |LE any_p|o CHAR(8|
|00004fc0| 29 3b 0a 42 45 47 49 4e | 0a 20 53 45 4c 45 43 54 |);.BEGIN|. SELECT|
|00004fd0| 20 73 2e 6f 72 64 65 72 | 5f 73 74 61 74 75 73 2c | s.order|_status,|
|00004fe0| 20 63 2e 6f 6e 5f 68 6f | 6c 64 2c 20 63 2e 63 75 | c.on_ho|ld, c.cu|
|00004ff0| 73 74 5f 6e 6f 0a 20 46 | 52 4f 4d 20 73 61 6c 65 |st_no. F|ROM sale|
|00005000| 73 20 73 2c 20 63 75 73 | 74 6f 6d 65 72 20 63 0a |s s, cus|tomer c.|
|00005010| 20 57 48 45 52 45 20 70 | 6f 5f 6e 75 6d 62 65 72 | WHERE p|o_number|
|00005020| 20 3d 20 3a 70 6f 5f 6e | 75 6d 0a 20 41 4e 44 20 | = :po_n|um. AND |
|00005030| 73 2e 63 75 73 74 5f 6e | 6f 20 3d 20 63 2e 63 75 |s.cust_n|o = c.cu|
|00005040| 73 74 5f 6e 6f 0a 20 49 | 4e 54 4f 20 3a 6f 72 64 |st_no. I|NTO :ord|
|00005050| 5f 73 74 61 74 2c 20 3a | 68 6f 6c 64 5f 73 74 61 |_stat, :|hold_sta|
|00005060| 74 2c 20 3a 63 75 73 74 | 5f 6e 6f 3b 0a 0a 20 2f |t, :cust|_no;.. /|
|00005070| 2a 20 54 68 69 73 20 70 | 75 72 63 68 61 73 65 20 |* This p|urchase |
|00005080| 6f 72 64 65 72 20 68 61 | 73 20 62 65 65 6e 20 61 |order ha|s been a|
|00005090| 6c 72 65 61 64 79 20 73 | 68 69 70 70 65 64 2e 20 |lready s|hipped. |
|000050a0| 2a 2f 0a 20 49 46 20 28 | 6f 72 64 5f 73 74 61 74 |*/. IF (|ord_stat|
|000050b0| 20 3d 20 22 73 68 69 70 | 70 65 64 22 29 20 54 48 | = "ship|ped") TH|
|000050c0| 45 4e 0a 20 42 45 47 49 | 4e 0a 20 20 45 58 43 45 |EN. BEGI|N.  EXCE|
|000050d0| 50 54 49 4f 4e 20 6f 72 | 64 65 72 5f 61 6c 72 65 |PTION or|der_alre|
|000050e0| 61 64 79 5f 73 68 69 70 | 70 65 64 3b 0a 20 20 53 |ady_ship|ped;.  S|
|000050f0| 55 53 50 45 4e 44 3b 0a | 20 45 4e 44 0a 0a 20 2f |USPEND;.| END.. /|
|00005100| 2a 20 43 75 73 74 6f 6d | 65 72 20 69 73 20 6f 6e |* Custom|er is on|
|00005110| 20 68 6f 6c 64 2e 20 2a | 2f 0a 20 45 4c 53 45 20 | hold. *|/. ELSE |
|00005120| 49 46 20 28 68 6f 6c 64 | 5f 73 74 61 74 20 3d 20 |IF (hold|_stat = |
|00005130| 22 2a 22 29 00 20 54 48 | 45 4e 0a 20 42 45 47 49 |"*"). TH|EN. BEGI|
|00005140| 4e 0a 20 20 45 58 43 45 | 50 54 49 4f 4e 20 63 75 |N.  EXCE|PTION cu|
|00005150| 73 74 6f 6d 65 72 5f 6f | 6e 5f 68 6f 6c 64 3b 0a |stomer_o|n_hold;.|
|00005160| 20 20 53 55 53 50 45 4e | 44 3b 0a 20 45 4e 44 0a |  SUSPEN|D;. END.|
|00005170| 0a 20 2f 2a 0a 20 20 2a | 20 49 66 20 74 68 65 72 |. /*.  *| If ther|
|00005180| 65 20 69 73 20 61 6e 20 | 75 6e 70 61 69 64 20 62 |e is an |unpaid b|
|00005190| 61 6c 61 6e 63 65 20 6f | 6e 20 6f 72 64 65 72 73 |alance o|n orders|
|000051a0| 20 73 68 69 70 70 65 64 | 20 6f 76 65 72 20 32 20 | shipped| over 2 |
|000051b0| 6d 6f 6e 74 68 73 20 61 | 67 6f 2c 0a 20 20 2a 20 |months a|go,.  * |
|000051c0| 70 75 74 20 74 68 65 20 | 63 75 73 74 6f 6d 65 72 |put the |customer|
|000051d0| 20 6f 6e 20 68 6f 6c 64 | 2e 0a 20 20 2a 2f 0a 20 | on hold|..  */. |
|000051e0| 46 4f 52 20 53 45 4c 45 | 43 54 20 70 6f 5f 6e 75 |FOR SELE|CT po_nu|
|000051f0| 6d 62 65 72 0a 20 20 46 | 52 4f 4d 20 73 61 6c 65 |mber.  F|ROM sale|
|00005200| 73 0a 20 20 57 48 45 52 | 45 20 63 75 73 74 5f 6e |s.  WHER|E cust_n|
|00005210| 6f 20 3d 20 3a 63 75 73 | 74 5f 6e 6f 0a 20 20 41 |o = :cus|t_no.  A|
|00005220| 4e 44 20 6f 72 64 65 72 | 5f 73 74 61 74 75 73 20 |ND order|_status |
|00005230| 3d 20 22 73 68 69 70 70 | 65 64 22 0a 20 20 41 4e |= "shipp|ed".  AN|
|00005240| 44 20 70 61 69 64 20 3d | 20 22 6e 22 0a 20 20 41 |D paid =| "n".  A|
|00005250| 4e 44 20 73 68 69 70 5f | 64 61 74 65 20 3c 20 27 |ND ship_|date < '|
|00005260| 4e 4f 57 27 20 2d 20 36 | 30 0a 20 20 49 4e 54 4f |NOW' - 6|0.  INTO|
|00005270| 20 3a 61 6e 79 5f 70 6f | 0a 20 44 4f 0a 20 42 45 | :any_po|. DO. BE|
|00005280| 47 49 4e 0a 20 20 45 58 | 43 45 50 54 49 4f 4e 20 |GIN.  EX|CEPTION |
|00005290| 63 75 73 74 6f 6d 65 72 | 5f 63 68 65 63 6b 3b 0a |customer|_check;.|
|000052a0| 0a 20 20 55 50 44 41 54 | 45 20 63 75 73 74 6f 6d |.  UPDAT|E custom|
|000052b0| 65 72 0a 20 20 53 45 54 | 20 6f 6e 5f 68 6f 6c 64 |er.  SET| on_hold|
|000052c0| 20 3d 20 22 2a 22 0a 20 | 20 57 48 45 52 45 20 63 | = "*". | WHERE c|
|000052d0| 75 73 74 5f 6e 6f 20 3d | 20 3a 63 75 73 74 5f 6e |ust_no =| :cust_n|
|000052e0| 6f 3b 0a 0a 20 20 53 55 | 53 50 45 4e 44 3b 0a 20 |o;..  SU|SPEND;. |
|000052f0| 45 4e 44 0a 0a 20 2f 2a | 0a 20 20 2a 20 53 68 69 |END.. /*|.  * Shi|
|00005300| 70 20 74 68 65 20 6f 72 | 64 65 72 2e 0a 20 20 2a |p the or|der..  *|
|00005310| 2f 0a 20 55 50 44 41 54 | 45 20 73 61 6c 65 73 0a |/. UPDAT|E sales.|
|00005320| 20 53 45 54 20 6f 72 64 | 65 72 5f 73 74 61 74 75 | SET ord|er_statu|
|00005330| 73 20 3d 20 22 00 73 68 | 69 70 70 65 64 22 2c 20 |s = ".sh|ipped", |
|00005340| 73 68 69 70 5f 64 61 74 | 65 20 3d 20 27 4e 4f 57 |ship_dat|e = 'NOW|
|00005350| 27 0a 20 57 48 45 52 45 | 20 70 6f 5f 6e 75 6d 62 |'. WHERE| po_numb|
|00005360| 65 72 20 3d 20 3a 70 6f | 5f 6e 75 6d 3b 0a 0a 20 |er = :po|_num;.. |
|00005370| 53 55 53 50 45 4e 44 3b | 0a 45 4e 44 00 08 04 88 |SUSPEND;|.END....|
|00005380| 02 00 00 04 02 04 00 02 | 00 0f 00 00 08 00 07 00 |........|........|
|00005390| 04 01 01 00 07 00 0c 00 | 02 03 00 00 0f 00 00 07 |........|........|
|000053a0| 00 01 2d 1a 00 00 03 01 | 00 0f 00 00 01 00 01 2d |..-.....|.......-|
|000053b0| 1a 01 00 03 02 00 08 00 | 01 2d 1a 02 00 03 03 00 |........|.-......|
|000053c0| 0f 00 00 08 00 01 2d 1a | 03 00 9b 11 00 02 02 07 |......-.|........|
|000053d0| 7f 43 02 92 05 53 41 4c | 45 53 01 53 00 92 08 43 |.C...SAL|ES.S...C|
|000053e0| 55 53 54 4f 4d 45 52 01 | 43 01 47 3a 2f 17 00 09 |USTOMER.|C.G:/...|
|000053f0| 50 4f 5f 4e 55 4d 42 45 | 52 29 00 00 00 01 00 2f |PO_NUMBE|R)...../|
|00005400| 17 00 07 43 55 53 54 5f | 4e 4f 17 01 07 43 55 53 |...CUST_|NO...CUS|
|00005410| 54 5f 4e 4f ff 02 01 17 | 00 0c 4f 52 44 45 52 5f |T_NO....|..ORDER_|
|00005420| 53 54 41 54 55 53 1a 00 | 00 01 17 01 07 4f 4e 5f |STATUS..|.....ON_|
|00005430| 48 4f 4c 44 1a 01 00 01 | 17 01 07 43 55 53 54 5f |HOLD....|...CUST_|
|00005440| 4e 4f 1a 02 00 ff 08 2f | 1a 00 00 15 0f 7f 00 07 |NO...../|........|
|00005450| 00 73 68 69 70 70 65 64 | 02 02 80 02 15 4f 52 44 |.shipped|.....ORD|
|00005460| 45 52 5f 41 4c 52 45 41 | 44 59 5f 53 48 49 50 50 |ER_ALREA|DY_SHIPP|
|00005470| 45 44 02 0e 01 02 01 15 | 07 00 01 00 19 01 00 00 |ED......|........|
|00005480| ff 9b ff ff ff 08 2f 1a | 01 00 15 0f 7f 00 01 00 |....../.|........|
|00005490| 2a 02 02 80 02 10 43 55 | 53 54 4f 4d 45 52 5f 4f |*.....CU|STOMER_O|
|000054a0| 4e 5f 48 4f 4c 44 02 0e | 01 02 01 15 07 00 01 00 |N_HOLD..|........|
|000054b0| 19 01 00 00 ff 9b ff ff | ff ff 07 43 01 4a 05 53 |........|...C.J.S|
|000054c0| 41 4c 45 53 02 47 3a 3a | 3a 2f 17 02 07 43 55 53 |ALES.G::|:/...CUS|
|000054d0| 54 5f 4e 4f 1a 02 00 2f | 17 02 0c 4f 52 44 45 52 |T_NO.../|...ORDER|
|000054e0| 5f 53 54 41 54 55 53 15 | 0f 7f 00 07 00 73 68 69 |_STATUS.|.....shi|
|000054f0| 70 70 65 64 2f 17 02 04 | 50 41 49 44 15 0f 7f 00 |pped/...|PAID....|
|00005500| 01 00 6e 33 17 02 09 53 | 48 49 50 5f 44 41 54 45 |..n3...S|HIP_DATE|
|00005510| 23 15 0f 7f 00 03 00 4e | 4f 57 15 08 00 3c 00 00 |#......N|OW...<..|
|00005520| 00 ff 02 01 17 02 09 50 | 4f 5f 4e 55 4d 42 45 52 |.......P|O_NUMBER|
|00005530| 1a 03 00 02 02 80 02 0e | 43 55 53 54 4f 4d 45 52 |........|CUSTOMER|
|00005540| 5f 43 48 45 43 4b 07 43 | 01 4a 08 43 55 53 54 4f |_CHECK.C|.J.CUSTO|
|00005550| 4d 45 52 03 47 2f 17 03 | 07 43 55 53 54 5f 4e 4f |MER.G/..|.CUST_NO|
|00005560| 1a 02 00 ff 0a 03 03 02 | 01 15 0f 7f 00 01 00 2a |........|.......*|
|00005570| 17 03 07 4f 4e 5f 48 4f | 4c 44 ff 02 0e 01 02 01 |...ON_HO|LD......|
|00005580| 15 07 00 01 00 19 01 00 | 00 ff 9b ff ff ff ff 07 |........|........|
|00005590| 43 01 4a 05 53 41 4c 45 | 53 04 47 2f 17 04 09 50 |C.J.SALE|S.G/...P|
|000055a0| 4f 5f 4e 55 4d 42 45 52 | 29 00 00 00 01 00 ff 0a |O_NUMBER|).......|
|000055b0| 04 04 02 01 15 0f 7f 00 | 07 00 73 68 69 70 70 65 |........|..shippe|
|000055c0| 64 17 04 0c 4f 52 44 45 | 52 5f 53 54 41 54 55 53 |d...ORDE|R_STATUS|
|000055d0| 01 15 0f 7f 00 03 00 4e | 4f 57 17 04 09 53 48 49 |.......N|OW...SHI|
|000055e0| 50 5f 44 41 54 45 ff 02 | 0e 01 02 01 15 07 00 01 |P_DATE..|........|
|000055f0| 00 19 01 00 00 ff 9b ff | ff ff ff 0e 01 02 01 15 |........|........|
|00005600| 07 00 00 00 19 01 00 00 | ff ff 4c 09 0e 53 51 4c |........|..L..SQL|
|00005610| 24 53 48 49 50 5f 4f 52 | 44 45 52 0a 06 53 59 53 |$SHIP_OR|DER..SYS|
|00005620| 44 42 41 00 1c 01 06 50 | 4f 5f 4e 55 4d 02 04 00 |DBA....P|O_NUM...|
|00005630| 00 00 00 03 04 00 00 00 | 00 04 06 52 44 42 24 35 |........|...RDB$5|
|00005640| 36 00 1d 1b 01 0a 53 48 | 4f 57 5f 4c 41 4e 47 53 |6.....SH|OW_LANGS|
|00005650| 02 04 03 00 00 00 03 04 | 01 00 00 00 07 04 8b 01 |........|........|
|00005660| 00 00 0a 44 45 43 4c 41 | 52 45 20 56 41 52 49 41 |...DECLA|RE VARIA|
|00005670| 42 4c 45 20 69 20 49 4e | 54 45 47 45 52 3b 0a 42 |BLE i IN|TEGER;.B|
|00005680| 45 47 49 4e 0a 20 20 69 | 20 3d 20 31 3b 0a 20 20 |EGIN.  i| = 1;.  |
|00005690| 57 48 49 4c 45 20 28 69 | 20 3c 3d 20 35 29 20 44 |WHILE (i| <= 5) D|
|000056a0| 4f 0a 20 20 42 45 47 49 | 4e 0a 20 20 20 20 53 45 |O.  BEGI|N.    SE|
|000056b0| 4c 45 43 54 20 6c 61 6e | 67 75 61 67 65 5f 72 65 |LECT lan|guage_re|
|000056c0| 71 5b 3a 69 5d 20 46 52 | 4f 4d 20 6a 6f 42 0a 20 |q[:i] FR|OM joB. |
|000056d0| 20 20 20 57 48 45 52 45 | 20 28 28 6a 6f 62 5f 63 |   WHERE| ((job_c|
|000056e0| 6f 64 65 20 3d 20 3a 63 | 6f 64 65 29 20 41 4e 44 |ode = :c|ode) AND|
|000056f0| 20 28 6a 6f 62 5f 67 72 | 61 64 65 20 3d 20 3a 67 | (job_gr|ade = :g|
|00005700| 72 61 64 65 29 20 41 4e | 44 20 28 6a 6f 62 5f 63 |rade) AN|D (job_c|
|00005710| 6f 75 6e 74 72 79 20 3d | 20 3a 63 74 79 29 0a 20 |ountry =| :cty). |
|00005720| 20 20 20 20 20 20 20 20 | 20 20 41 4e 44 20 28 6c |        |  AND (l|
|00005730| 61 6e 67 75 61 67 65 5f | 72 65 71 20 49 53 20 4e |anguage_|req IS N|
|00005740| 4f 54 20 4e 55 4c 4c 29 | 29 0a 20 20 20 20 49 4e |OT NULL)|).    IN|
|00005750| 54 4f 20 3a 6c 61 6e 67 | 75 61 67 65 73 3b 0a 20 |TO :lang|uages;. |
|00005760| 20 20 20 49 46 20 28 6c | 61 6e 67 75 61 67 65 73 |   IF (l|anguages|
|00005770| 20 3d 20 22 20 22 29 20 | 54 48 45 4e 20 20 2f 2a | = " ") |THEN  /*|
|00005780| 20 50 72 69 6e 74 73 20 | 22 4e 55 4c 4c 22 20 69 | Prints |"NULL" i|
|00005790| 6e 73 74 65 61 64 20 6f | 66 20 62 6c 61 6e 6b 73 |nstead o|f blanks|
|000057a0| 20 2a 2f 0a 20 20 20 20 | 20 20 20 6c 61 6e 67 75 | */.    |   langu|
|000057b0| 61 67 65 73 20 3d 20 22 | 4e 55 4c 4c 22 3b 20 20 |ages = "|NULL";  |
|000057c0| 20 20 20 20 20 20 20 0a | 20 20 20 20 69 20 3d 20 |       .|    i = |
|000057d0| 69 20 2b 31 3b 0a 20 20 | 20 20 53 55 53 50 45 4e |i +1;.  |  SUSPEN|
|000057e0| 44 3b 0a 20 20 45 4e 44 | 0a 45 4e 44 00 08 04 3c |D;.  END|.END...<|
|000057f0| 01 00 00 04 02 04 00 06 | 00 26 00 00 05 00 07 00 |........|.&......|
|00005800| 07 00 07 00 26 00 00 0f | 00 07 00 04 01 03 00 26 |....&...|.......&|
|00005810| 00 00 0f 00 07 00 07 00 | 0c 00 02 03 00 00 26 00 |........|......&.|
|00005820| 00 0f 00 01 2d 1a 00 00 | 03 01 00 08 00 01 2d 1a |....-...|......-.|
|00005830| 01 00 9b 11 00 02 02 01 | 15 08 00 01 00 00 00 1a |........|........|
|00005840| 01 00 11 01 09 02 08 34 | 1a 01 00 15 08 00 05 00 |.......4|........|
|00005850| 00 00 02 02 07 7f 43 01 | 4a 03 4a 4f 42 00 47 3a |......C.|J.JOB.G:|
|00005860| 3a 3a 2f 17 00 08 4a 4f | 42 5f 43 4f 44 45 29 00 |::/...JO|B_CODE).|
|00005870| 00 00 01 00 2f 17 00 09 | 4a 4f 42 5f 47 52 41 44 |..../...|JOB_GRAD|
|00005880| 45 29 00 02 00 03 00 2f | 17 00 0b 4a 4f 42 5f 43 |E)...../|...JOB_C|
|00005890| 4f 55 4e 54 52 59 29 00 | 04 00 05 00 3b 3d 17 00 |OUNTRY).|....;=..|
|000058a0| 0c 4c 41 4e 47 55 41 47 | 45 5f 52 45 51 ff 02 01 |.LANGUAG|E_REQ...|
|000058b0| 6b 17 00 0c 4c 41 4e 47 | 55 41 47 45 5f 52 45 51 |k...LANG|UAGE_REQ|
|000058c0| 01 1a 01 00 1a 00 00 ff | 08 2f 1a 00 00 15 0f 7f |........|./......|
|000058d0| 00 01 00 20 01 15 0f 7f | 00 04 00 4e 55 4c 4c 1a |... ....|...NULL.|
|000058e0| 00 00 ff 01 22 1a 01 00 | 15 08 00 01 00 00 00 1a |...."...|........|
|000058f0| 01 00 02 0e 01 02 01 1a | 00 00 29 01 00 00 01 00 |........|..).....|
|00005900| 01 15 07 00 01 00 19 01 | 02 00 ff 9b ff ff ff 12 |........|........|
|00005910| 01 ff ff ff ff 0e 01 02 | 01 1a 00 00 29 01 00 00 |........|....)...|
|00005920| 01 00 01 15 07 00 00 00 | 19 01 02 00 ff ff 4c 09 |........|......L.|
|00005930| 0e 53 51 4c 24 53 48 4f | 57 5f 4c 41 4e 47 53 0a |.SQL$SHO|W_LANGS.|
|00005940| 06 53 59 53 44 42 41 00 | 1c 01 04 43 4f 44 45 02 |.SYSDBA.|...CODE.|
|00005950| 04 00 00 00 00 03 04 00 | 00 00 00 04 06 52 44 42 |........|.....RDB|
|00005960| 24 35 37 00 1c 01 05 47 | 52 41 44 45 02 04 01 00 |$57....G|RADE....|
|00005970| 00 00 03 04 00 00 00 00 | 04 06 52 44 42 24 35 38 |........|..RDB$58|
|00005980| 00 1c 01 03 43 54 59 02 | 04 02 00 00 00 03 04 00 |....CTY.|........|
|00005990| 00 00 00 04 06 52 44 42 | 24 35 39 00 1c 01 09 4c |.....RDB|$59....L|
|000059a0| 41 4e 47 55 41 47 45 53 | 02 04 00 00 00 00 03 04 |ANGUAGES|........|
|000059b0| 01 00 00 00 04 06 52 44 | 42 24 36 30 00 1d 1b 01 |......RD|B$60....|
|000059c0| 09 41 4c 4c 5f 4c 41 4e | 47 53 02 04 00 00 00 00 |.ALL_LAN|GS......|
|000059d0| 03 04 04 00 00 00 07 04 | 8b 01 00 00 0a 20 20 20 |........|.....   |
|000059e0| 20 42 45 47 49 4e 0a 20 | 46 4f 52 20 53 45 4c 45 | BEGIN. |FOR SELE|
|000059f0| 43 54 20 6a 6f 62 5f 63 | 6f 64 65 2c 20 6a 6f 62 |CT job_c|ode, job|
|00005a00| 5f 67 72 61 64 65 2c 20 | 6a 6f 62 5f 63 6f 75 6e |_grade, |job_coun|
|00005a10| 74 72 79 20 46 52 4f 4d | 20 6a 6f 62 20 0a 20 20 |try FROM| job .  |
|00005a20| 49 4e 54 4f 20 3a 63 6f | 64 65 2c 20 3a 67 72 61 |INTO :co|de, :gra|
|00005a30| 64 65 2c 20 3a 63 6f 75 | 6e 74 72 79 0a 0a 20 44 |de, :cou|ntry.. D|
|00005a40| 4f 0a 20 42 45 47 49 4e | 0a 20 20 20 20 20 46 4f |O. BEGIN|.     FO|
|00005a50| 52 20 53 45 4c 45 43 54 | 20 6c 61 6e 67 75 61 67 |R SELECT| languag|
|00005a60| 65 73 20 46 52 4f 4d 20 | 73 68 6f 77 5f 6c 61 6e |es FROM |show_lan|
|00005a70| 67 73 20 0a 20 20 20 20 | 20 20 20 28 3a 63 6f 64 |gs .    |   (:cod|
|00005a80| 65 2c 20 3a 67 72 61 64 | 65 2c 20 3a 63 6f 75 6e |e, :grad|e, :coun|
|00005a90| 74 72 79 29 20 49 4e 54 | 4f 20 3a 6c 61 6e 67 20 |try) INT|O :lang |
|00005aa0| 44 4f 0a 20 20 20 20 20 | 20 20 20 20 53 55 53 50 |DO.     |    SUSP|
|00005ab0| 45 4e 44 3b 0a 20 20 20 | 20 20 2f 2a 20 50 75 74 |END;.   |  /* Put|
|00005ac0| 20 6e 69 63 65 20 73 65 | 70 61 72 61 74 6f 72 73 | nice se|parators|
|00005ad0| 20 62 65 74 77 65 65 6e | 20 72 6f 77 73 20 2a 2f | between| rows */|
|00005ae0| 0a 20 20 20 20 20 63 6f | 64 65 20 3d 20 22 3d 3d |.     co|de = "==|
|00005af0| 3d 3d 3d 22 3b 0a 20 20 | 20 20 20 67 72 61 64 65 |===";.  |   grade|
|00005b00| 20 3d 20 22 3d 3d 3d 3d | 3d 22 3b 0a 20 20 20 20 | = "====|=";.    |
|00005b10| 20 63 6f 75 6e 74 72 79 | 20 3d 20 22 3d 3d 3d 3d | country| = "====|
|00005b20| 3d 3d 3d 3d 3d 3d 3d 3d | 3d 3d 3d 22 3b 0a 20 20 |========|===";.  |
|00005b30| 20 20 20 6c 61 6e 67 20 | 3d 20 22 3d 3d 3d 3d 3d |   lang |= "=====|
|00005b40| 3d 3d 3d 3d 3d 3d 3d 3d | 3d 22 3b 0a 20 20 20 20 |========|=";.    |
|00005b50| 20 53 55 53 50 45 4e 44 | 3b 0a 20 45 4e 44 0a 20 | SUSPEND|;. END. |
|00005b60| 20 20 20 45 4e 44 00 08 | 04 c9 01 00 00 04 02 04 |   END..|........|
|00005b70| 01 09 00 26 00 00 05 00 | 07 00 26 00 00 05 00 07 |...&....|..&.....|
|00005b80| 00 26 00 00 0f 00 07 00 | 26 00 00 0f 00 07 00 07 |.&......|&.......|
|00005b90| 00 02 03 00 00 26 00 00 | 05 00 01 2d 1a 00 00 03 |.....&..|...-....|
|00005ba0| 01 00 26 00 00 05 00 01 | 2d 1a 01 00 03 02 00 26 |..&.....|-......&|
|00005bb0| 00 00 0f 00 01 2d 1a 02 | 00 03 03 00 26 00 00 0f |.....-..|....&...|
|00005bc0| 00 01 2d 1a 03 00 9b 11 | 00 02 02 07 43 01 4a 03 |..-.....|....C.J.|
|00005bd0| 4a 4f 42 00 ff 02 01 17 | 00 08 4a 4f 42 5f 43 4f |JOB.....|..JOB_CO|
|00005be0| 44 45 1a 00 00 01 17 00 | 09 4a 4f 42 5f 47 52 41 |DE......|.JOB_GRA|
|00005bf0| 44 45 1a 01 00 01 17 00 | 0b 4a 4f 42 5f 43 4f 55 |DE......|.JOB_COU|
|00005c00| 4e 54 52 59 1a 02 00 02 | 02 07 43 01 7c 0a 53 48 |NTRY....|..C.|.SH|
|00005c10| 4f 57 5f 4c 41 4e 47 53 | 01 03 00 1a 00 00 1a 01 |OW_LANGS|........|
|00005c20| 00 1a 02 00 ff 02 01 17 | 01 09 4c 41 4e 47 55 41 |........|..LANGUA|
|00005c30| 47 45 53 1a 03 00 02 0e | 01 02 01 1a 00 00 29 01 |GES.....|......).|
|00005c40| 00 00 01 00 01 1a 01 00 | 29 01 02 00 03 00 01 1a |........|).......|
|00005c50| 02 00 29 01 04 00 05 00 | 01 1a 03 00 29 01 06 00 |..).....|....)...|
|00005c60| 07 00 01 15 07 00 01 00 | 19 01 08 00 ff 9b ff ff |........|........|
|00005c70| 01 15 0f 7f 00 05 00 3d | 3d 3d 3d 3d 1a 00 00 01 |.......=|====....|
|00005c80| 15 0f 7f 00 05 00 3d 3d | 3d 3d 3d 1a 01 00 01 15 |......==|===.....|
|00005c90| 0f 7f 00 0f 00 3d 3d 3d | 3d 3d 3d 3d 3d 3d 3d 3d |.....===|========|
|00005ca0| 3d 3d 3d 3d 1a 02 00 01 | 15 0f 7f 00 0e 00 3d 3d |====....|......==|
|00005cb0| 3d 3d 3d 3d 3d 3d 3d 3d | 3d 3d 3d 3d 1a 03 00 02 |========|====....|
|00005cc0| 0e 01 02 01 1a 00 00 29 | 01 00 00 01 00 01 1a 01 |.......)|........|
|00005cd0| 00 29 01 02 00 03 00 01 | 1a 02 00 29 01 04 00 05 |.)......|...)....|
|00005ce0| 00 01 1a 03 00 29 01 06 | 00 07 00 01 15 07 00 01 |.....)..|........|
|00005cf0| 00 19 01 08 00 ff 9b ff | ff ff ff ff ff ff 0e 01 |........|........|
|00005d00| 02 01 1a 00 00 29 01 00 | 00 01 00 01 1a 01 00 29 |.....)..|.......)|
|00005d10| 01 02 00 03 00 01 1a 02 | 00 29 01 04 00 05 00 01 |........|.)......|
|00005d20| 1a 03 00 29 01 06 00 07 | 00 01 15 07 00 00 00 19 |...)....|........|
|00005d30| 01 08 00 ff ff 4c 09 0d | 53 51 4c 24 41 4c 4c 5f |.....L..|SQL$ALL_|
|00005d40| 4c 41 4e 47 53 0a 06 53 | 59 53 44 42 41 00 1c 01 |LANGS..S|YSDBA...|
|00005d50| 04 43 4f 44 45 02 04 00 | 00 00 00 03 04 01 00 00 |.CODE...|........|
|00005d60| 00 04 06 52 44 42 24 36 | 31 00 1c 01 05 47 52 41 |...RDB$6|1....GRA|
|00005d70| 44 45 02 04 01 00 00 00 | 03 04 01 00 00 00 04 06 |DE......|........|
|00005d80| 52 44 42 24 36 32 00 1c | 01 07 43 4f 55 4e 54 52 |RDB$62..|..COUNTR|
|00005d90| 59 02 04 02 00 00 00 03 | 04 01 00 00 00 04 06 52 |Y.......|.......R|
|00005da0| 44 42 24 36 33 00 1c 01 | 04 4c 41 4e 47 02 04 03 |DB$63...|.LANG...|
|00005db0| 00 00 00 03 04 01 00 00 | 00 04 06 52 44 42 24 36 |........|...RDB$6|
|00005dc0| 34 00 1d 1e 01 0e 55 4e | 4b 4e 4f 57 4e 5f 45 4d |4.....UN|KNOWN_EM|
|00005dd0| 50 5f 49 44 02 26 49 6e | 76 61 6c 69 64 20 65 6d |P_ID.&In|valid em|
|00005de0| 70 6c 6f 79 65 65 20 6e | 75 6d 62 65 72 20 6f 72 |ployee n|umber or|
|00005df0| 20 70 72 6f 6a 65 63 74 | 20 69 64 2e 00 1e 01 0e | project| id.....|
|00005e00| 52 45 41 53 53 49 47 4e | 5f 53 41 4c 45 53 02 39 |REASSIGN|_SALES.9|
|00005e10| 52 65 61 73 73 69 67 6e | 20 74 68 65 20 73 61 6c |Reassign| the sal|
|00005e20| 65 73 20 72 65 63 6f 72 | 64 73 20 62 65 66 6f 72 |es recor|ds befor|
|00005e30| 65 20 64 65 6c 65 74 69 | 6e 67 20 74 68 69 73 20 |e deleti|ng this |
|00005e40| 65 6d 70 6c 6f 79 65 65 | 2e 00 1e 01 15 4f 52 44 |employee|.....ORD|
|00005e50| 45 52 5f 41 4c 52 45 41 | 44 59 5f 53 48 49 50 50 |ER_ALREA|DY_SHIPP|
|00005e60| 45 44 02 1a 4f 72 64 65 | 72 20 73 74 61 74 75 73 |ED..Orde|r status|
|00005e70| 20 69 73 20 27 73 68 69 | 70 70 65 64 2e 27 00 1e | is 'shi|pped.'..|
|00005e80| 01 10 43 55 53 54 4f 4d | 45 52 5f 4f 4e 5f 48 4f |..CUSTOM|ER_ON_HO|
|00005e90| 4c 44 02 19 54 68 69 73 | 20 63 75 73 74 6f 6d 65 |LD..This| custome|
|00005ea0| 72 20 69 73 20 6f 6e 20 | 68 6f 6c 64 2e 00 1e 01 |r is on |hold....|
|00005eb0| 0e 43 55 53 54 4f 4d 45 | 52 5f 43 48 45 43 4b 02 |.CUSTOME|R_CHECK.|
|00005ec0| 1e 4f 76 65 72 64 75 65 | 20 62 61 6c 61 6e 63 65 |.Overdue| balance|
|00005ed0| 20 2d 2d 20 63 61 6e 27 | 74 20 73 68 69 70 2e 00 | -- can'|t ship..|
|00005ee0| 08 01 0e 53 41 4c 41 52 | 59 5f 48 49 53 54 4f 52 |...SALAR|Y_HISTOR|
|00005ef0| 59 00 05 01 0d 52 44 42 | 24 50 52 49 4d 41 52 59 |Y....RDB|$PRIMARY|
|00005f00| 32 30 02 04 03 00 00 00 | 03 04 00 00 00 00 04 04 |20......|........|
|00005f10| 01 00 00 00 05 06 45 4d | 50 5f 4e 4f 05 0b 43 48 |......EM|P_NO..CH|
|00005f20| 41 4e 47 45 5f 44 41 54 | 45 05 0a 55 50 44 41 54 |ANGE_DAT|E..UPDAT|
|00005f30| 45 52 5f 49 44 07 04 00 | 00 00 00 00 05 01 0d 52 |ER_ID...|.......R|
|00005f40| 44 42 24 46 4f 52 45 49 | 47 4e 32 31 02 04 01 00 |DB$FOREI|GN21....|
|00005f50| 00 00 03 04 00 00 00 00 | 04 04 00 00 00 00 05 06 |........|........|
|00005f60| 45 4d 50 5f 4e 4f 07 04 | 00 00 00 00 08 0c 52 44 |EMP_NO..|......RD|
|00005f70| 42 24 50 52 49 4d 41 52 | 59 37 00 05 01 08 55 50 |B$PRIMAR|Y7....UP|
|00005f80| 44 41 54 45 52 58 02 04 | 01 00 00 00 03 04 00 00 |DATERX..|........|
|00005f90| 00 00 04 04 00 00 00 00 | 05 0a 55 50 44 41 54 45 |........|..UPDATE|
|00005fa0| 52 5f 49 44 07 04 00 00 | 00 00 00 05 01 07 43 48 |R_ID....|......CH|
|00005fb0| 41 4e 47 45 58 02 04 01 | 00 00 00 03 04 00 00 00 |ANGEX...|........|
|00005fc0| 00 04 04 00 00 00 00 05 | 0b 43 48 41 4e 47 45 5f |........|.CHANGE_|
|00005fd0| 44 41 54 45 07 04 01 00 | 00 00 00 06 01 04 3a 00 |DATE....|......:.|
|00005fe0| 00 00 11 04 3c 00 00 00 | 02 02 40 24 fa 00 03 40 |....<...|..@$...@|
|00005ff0| d3 88 f9 00 02 bf 4b f9 | 00 09 06 61 64 6d 69 6e |......K.|...admin|
|00006000| 32 00 f0 fd 00 01 1c ec | 00 06 01 04 3c 00 00 00 |2.......|....<...|
|00006010| 11 04 3c 00 00 00 02 0b | 40 20 1f 58 d0 fa c6 88 |..<.....|@ .X....|
|00006020| 40 f7 ed f9 00 02 bf 4b | f9 00 09 06 61 64 6d 69 |@......K|....admi|
|00006030| 6e 32 00 f0 fd 00 01 02 | ec 00 06 01 04 3c 00 00 |n2......|.....<..|
|00006040| 00 11 04 3c 00 00 00 02 | 02 40 20 fb aa 04 ab 40 |...<....|.@ ....@|
|00006050| f5 f9 f9 00 02 bf 4b f9 | 00 09 06 61 64 6d 69 6e |......K.|...admin|
|00006060| 32 00 f0 fd 00 01 04 ec | 00 06 01 04 3c 00 00 00 |2.......|....<...|
|00006070| 11 04 3c 00 00 00 02 0c | 40 20 50 d7 94 35 e5 0d |..<.....|@ P..5..|
|00006080| 40 f7 31 80 fa 00 02 bf | 4b f9 00 09 06 61 64 6d |@.1.....|K....adm|
|00006090| 69 6e 32 00 f0 fd 00 01 | 05 ec 00 06 01 04 3c 00 |in2.....|......<.|
|000060a0| 00 00 11 04 3c 00 00 00 | 02 02 40 1e fa 00 03 40 |....<...|..@....@|
|000060b0| f1 17 f9 00 02 bf 4b f9 | 00 09 06 61 64 6d 69 6e |......K.|...admin|
|000060c0| 32 00 f0 fd 00 01 0b ec | 00 06 01 04 3c 00 00 00 |2.......|....<...|
|000060d0| 11 04 3c 00 00 00 02 02 | 40 1e fa 00 03 40 e7 70 |..<.....|@....@.p|
|000060e0| f9 00 02 bf 4b f9 00 09 | 06 61 64 6d 69 6e 32 00 |....K...|.admin2.|
|000060f0| f0 fd 00 01 0c ec 00 06 | 01 04 3c 00 00 00 11 04 |........|..<.....|
|00006100| 3c 00 00 00 02 02 40 1e | fa 00 03 40 ee 46 f9 00 |<.....@.|...@.F..|
|00006110| 02 bf 4b f9 00 09 06 61 | 64 6d 69 6e 32 00 f0 fd |..K....a|dmin2...|
|00006120| 00 01 0e ec 00 06 01 04 | 3c 00 00 00 11 04 3c 00 |........|<.....<.|
|00006130| 00 00 02 02 40 1e fa 00 | 03 40 ed 4c f9 00 02 bf |....@...|.@.L....|
|00006140| 4b f9 00 09 06 61 64 6d | 69 6e 32 00 f0 fd 00 01 |K....adm|in2.....|
|00006150| 0f ec 00 06 01 04 3c 00 | 00 00 11 04 3c 00 00 00 |......<.|....<...|
|00006160| 02 02 40 1e fa 00 03 40 | f3 88 f9 00 02 bf 4b f9 |..@....@|......K.|
|00006170| 00 09 06 61 64 6d 69 6e | 32 00 f0 fd 00 01 14 ec |...admin|2.......|
|00006180| 00 06 01 04 3c 00 00 00 | 11 04 3c 00 00 00 02 02 |....<...|..<.....|
|00006190| 40 1e fa 00 04 40 f1 d2 | 80 fa 00 02 bf 4b f9 00 |@....@..|.....K..|
|000061a0| 09 06 61 64 6d 69 6e 32 | 00 f0 fd 00 01 18 ec 00 |..admin2|........|
|000061b0| 06 01 04 3c 00 00 00 11 | 04 3c 00 00 00 02 02 40 |...<....|.<.....@|
|000061c0| 1e fa 00 03 40 ee 46 f9 | 00 02 bf 4b f9 00 09 06 |....@.F.|...K....|
|000061d0| 61 64 6d 69 6e 32 00 f0 | fd 00 01 1d ec 00 06 01 |admin2..|........|
|000061e0| 04 3c 00 00 00 11 04 3c | 00 00 00 02 02 40 1e fa |.<.....<|.....@..|
|000061f0| 00 03 40 ea db f9 00 02 | bf 4b f9 00 09 06 61 64 |..@.....|.K....ad|
|00006200| 6d 69 6e 32 00 f0 fd 00 | 01 22 ec 00 06 01 04 3c |min2....|.".....<|
|00006210| 00 00 00 11 04 3c 00 00 | 00 02 02 40 1e fa 00 03 |.....<..|...@....|
|00006220| 40 dd 4c f9 00 02 bf 4b | f9 00 09 06 61 64 6d 69 |@.L....K|....admi|
|00006230| 6e 32 00 f0 fd 00 01 24 | ec 00 06 01 04 3c 00 00 |n2.....$|.....<..|
|00006240| 00 11 04 3c 00 00 00 02 | 02 40 1e fa 00 03 40 e1 |...<....|.@....@.|
|00006250| 17 f9 00 02 bf 4b f9 00 | 09 06 61 64 6d 69 6e 32 |.....K..|..admin2|
|00006260| 00 f0 fd 00 01 25 ec 00 | 06 01 04 3c 00 00 00 11 |.....%..|...<....|
|00006270| 04 3c 00 00 00 02 02 40 | 1e fa 00 03 40 e8 6a f9 |.<.....@|....@.j.|
|00006280| 00 02 bf 4b f9 00 09 06 | 61 64 6d 69 6e 32 00 f0 |...K....|admin2..|
|00006290| fd 00 01 2c ec 00 06 01 | 04 3c 00 00 00 11 04 3c |...,....|.<.....<|
|000062a0| 00 00 00 02 02 40 1e fa | 00 03 40 f1 94 f9 00 02 |.....@..|..@.....|
|000062b0| bf 4b f9 00 09 06 61 64 | 6d 69 6e 32 00 f0 fd 00 |.K....ad|min2....|
|000062c0| 01 2d ec 00 06 01 04 3c | 00 00 00 11 04 3c 00 00 |.-.....<|.....<..|
|000062d0| 00 02 02 40 11 fa 00 03 | 40 ee 46 f9 00 02 c0 56 |...@....|@.F....V|
|000062e0| f9 00 09 06 65 6c 61 69 | 6e 65 00 f0 fd 00 01 08 |....elai|ne......|
|000062f0| ec 00 06 01 04 3c 00 00 | 00 11 04 3c 00 00 00 02 |.....<..|...<....|
|00006300| 02 40 11 fa 00 03 40 f1 | 94 f9 00 02 c0 56 f9 00 |.@....@.|.....V..|
|00006310| 09 06 65 6c 61 69 6e 65 | 00 f0 fd 00 01 09 ec 00 |..elaine|........|
|00006320| 06 01 04 3c 00 00 00 11 | 04 3c 00 00 00 02 02 40 |...<....|.<.....@|
|00006330| 11 fa 00 04 40 f2 5f 20 | fa 00 02 c0 56 f9 00 09 |....@._ |....V...|
|00006340| 06 65 6c 61 69 6e 65 00 | f0 fd 00 01 0b ec 00 06 |.elaine.|........|
|00006350| 01 04 3c 00 00 00 11 04 | 3c 00 00 00 02 02 40 11 |..<.....|<.....@.|
|00006360| fa 00 03 40 e9 32 f9 00 | 02 c0 56 f9 00 09 06 65 |...@.2..|..V....e|
|00006370| 6c 61 69 6e 65 00 f0 fd | 00 01 0c ec 00 06 01 04 |laine...|........|
|00006380| 3c 00 00 00 11 04 3c 00 | 00 00 02 02 40 11 fa 00 |<.....<.|....@...|
|00006390| 04 40 f0 45 a0 fa 00 02 | c0 56 f9 00 09 06 65 6c |.@.E....|.V....el|
|000063a0| 61 69 6e 65 00 f0 fd 00 | 01 0e ec 00 06 01 04 3c |aine....|.......<|
|000063b0| 00 00 00 11 04 3c 00 00 | 00 02 02 40 11 fa 00 04 |.....<..|...@....|
|000063c0| 40 ef 7e 80 fa 00 02 c0 | 56 f9 00 09 06 65 6c 61 |@.~.....|V....ela|
|000063d0| 69 6e 65 00 f0 fd 00 01 | 0f ec 00 06 01 04 3c 00 |ine.....|......<.|
|000063e0| 00 00 11 04 3c 00 00 00 | 02 02 40 11 fa 00 03 40 |....<...|..@....@|
|000063f0| f4 ff f9 00 02 c0 56 f9 | 00 09 06 65 6c 61 69 6e |......V.|...elain|
+--------+-------------------------+-------------------------+--------+--------+
Only 25.0 KB of data is shown above.