home *** CD-ROM | disk | FTP | other *** search
| Unknown | 1989-12-07 | 11.2 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
|
|---|
| 100%
| file
| data
| default
|
|
hex view+--------+-------------------------+-------------------------+--------+--------+
|00000000| fe 68 00 69 da e0 00 69 | 00 00 12 32 da e1 00 25 |.h.i...i|...2...%|
|00000010| 00 00 12 0c da e4 00 1e | 00 00 11 ed dc 49 00 37 |........|.....I.7|
|00000020| 00 00 11 b5 dc 4a 00 18 | 00 00 11 9c dc 4c 00 4f |.....J..|.....L.O|
|00000030| 00 00 11 4c dc 90 00 3a | 00 00 11 11 dc 91 00 86 |...L...:|........|
|00000040| 00 00 10 8a dc 92 00 86 | 00 00 10 03 dc 94 00 c3 |........|........|
|00000050| 00 00 0f 3f dc 95 00 5a | 00 00 0e e4 dc 96 00 3a |...?...Z|.......:|
|00000060| 00 00 0e a9 dc 97 00 51 | 00 00 0e 57 dc 98 00 45 |.......Q|...W...E|
|00000070| 00 00 0e 11 dc 99 00 b1 | 00 00 0d 5f dc 9a 00 b8 |........|..._....|
|00000080| 00 00 0c a6 dc 9b 00 5d | 00 00 0c 48 dc 9c 00 65 |.......]|...H...e|
|00000090| 00 00 0b e2 dc 9d 00 70 | 00 00 0b 71 dc a1 00 35 |.......p|...q...5|
|000000a0| 00 00 0b 3b dc a2 00 c9 | 00 00 0a 71 dc a3 00 d2 |...;....|...q....|
|000000b0| 00 00 09 9e dc a4 00 4a | 00 00 09 53 dc a5 00 89 |.......J|...S....|
|000000c0| 00 00 08 c9 dc a6 00 7c | 00 00 08 4c dc a7 00 64 |.......||...L...d|
|000000d0| 00 00 07 e7 dc a8 00 23 | 00 00 07 c3 dc a9 00 2c |.......#|.......,|
|000000e0| 00 00 07 96 dc aa 00 58 | 00 00 07 3d dc bf 00 73 |.......X|...=...s|
|000000f0| 00 00 06 c9 dc ca 01 3c | 00 00 05 8c dc d4 00 5d |.......<|.......]|
|00000100| 00 00 05 2e dc d6 00 32 | 00 00 04 fb dc d7 00 57 |.......2|.......W|
|00000110| 00 00 04 a3 e0 42 00 1d | 00 00 2a 6b e0 43 00 d7 |.....B..|..*k.C..|
|00000120| 00 00 29 93 e0 44 00 60 | 00 00 29 32 e0 45 00 6b |..)..D.`|..)2.E.k|
|00000130| 00 00 28 c6 e0 46 00 46 | 00 00 28 7f e0 4c 00 2a |..(..F.F|..(..L.*|
|00000140| 00 00 28 54 e0 4d 00 4e | 00 00 28 05 e0 4e 01 0c |..(T.M.N|..(..N..|
|00000150| 00 00 26 f8 e0 4f 00 45 | 00 00 26 b2 e0 50 00 a4 |..&..O.E|..&..P..|
|00000160| 00 00 26 0d e0 51 00 52 | 00 00 25 ba e0 52 00 45 |..&..Q.R|..%..R.E|
|00000170| 00 00 25 74 e0 54 00 4d | 00 00 25 26 e0 55 00 4b |..%t.T.M|..%&.U.K|
|00000180| 00 00 24 da e0 57 00 7f | 00 00 24 5a e0 58 00 3f |..$..W..|..$Z.X.?|
|00000190| 00 00 24 1a e0 59 01 15 | 00 00 23 04 e0 5a 00 70 |..$..Y..|..#..Z.p|
|000001a0| 00 00 22 93 e0 82 00 8b | 00 00 22 07 e0 83 00 5e |..".....|.."....^|
|000001b0| 00 00 21 a8 e0 84 00 47 | 00 00 21 60 e0 85 00 a3 |..!....G|..!`....|
|000001c0| 00 00 20 bc e0 86 00 2d | 00 00 20 8e e0 87 00 5e |.. ....-|.. ....^|
|000001d0| 00 00 20 2f e0 88 00 5d | 00 00 1f d1 e0 89 00 40 |.. /...]|.......@|
|000001e0| 00 00 1f 90 e0 8a 00 53 | 00 00 1f 3c e0 8b 00 5a |.......S|...<...Z|
|000001f0| 00 00 1e e1 e0 8c 00 5d | 00 00 1e 83 e0 8d 00 51 |.......]|.......Q|
|00000200| 00 00 1e 31 e0 9e 00 2f | 00 00 1e 01 e0 9f 00 3c |...1.../|.......<|
|00000210| 00 00 1d c4 e0 a2 00 40 | 00 00 1d 83 e0 a5 00 e9 |.......@|........|
|00000220| 00 00 1c 99 e0 a7 00 6f | 00 00 1c 29 e0 aa 00 4a |.......o|...)...J|
|00000230| 00 00 1b de e0 ab 00 5a | 00 00 1b 83 e0 ae 00 73 |.......Z|.......s|
|00000240| 00 00 1b 0f e0 af 00 e9 | 00 00 1a 25 e0 b0 00 68 |........|...%...h|
|00000250| 00 00 19 bc e0 b1 00 d0 | 00 00 18 eb e0 b2 01 10 |........|........|
|00000260| 00 00 17 da e0 b3 00 94 | 00 00 17 45 e0 b5 00 45 |........|...E...E|
|00000270| 00 00 2c 5f e0 b6 01 08 | 00 00 16 3c e0 b7 00 5d |..,_....|...<...]|
|00000280| 00 00 15 de e0 b8 00 5b | 00 00 15 82 e0 b9 00 30 |.......[|.......0|
|00000290| 00 00 15 51 e0 ba 00 38 | 00 00 15 18 e0 bb 00 85 |...Q...8|........|
|000002a0| 00 00 14 92 e0 bc 00 19 | 00 00 14 78 e0 bd 00 38 |........|...x...8|
|000002b0| 00 00 14 3f e0 be 00 db | 00 00 13 63 e0 bf 00 c6 |...?....|...c....|
|000002c0| 00 00 12 9c 1f 40 00 24 | 00 00 2a 89 1f 41 00 0f |.....@.$|..*..A..|
|000002d0| 00 00 2a ae 1f 42 00 11 | 00 00 2a be 1f 43 00 6d |..*..B..|..*..C.m|
|000002e0| 00 00 2a d0 1f 44 00 58 | 00 00 2b 3e 1f 45 00 32 |..*..D.X|..+>.E.2|
|000002f0| 00 00 2b 97 1f 48 00 5f | 00 00 2b ca 1f 49 00 16 |..+..H._|..+..I..|
|00000300| 00 00 2c 2a 1f 4a 00 1d | 00 00 2c 41 23 28 00 1c |..,*.J..|..,A#(..|
|00000310| 00 00 03 4c 23 29 00 2f | 00 00 03 69 23 2a 00 27 |...L#)./|...i#*.'|
|00000320| 00 00 03 99 23 2b 00 2e | 00 00 03 c1 23 2c 00 24 |....#+..|....#,.$|
|00000330| 00 00 03 f0 23 2d 00 2d | 00 00 04 15 23 2e 00 33 |....#-.-|....#..3|
|00000340| 00 00 04 43 23 2f 00 2b | 00 00 04 77 54 68 65 20 |...C#/.+|...wThe |
|00000350| 64 69 66 66 65 72 65 6e | 74 20 76 65 72 73 69 6f |differen|t versio|
|00000360| 6e 73 20 61 72 65 3a 0a | 00 41 43 45 47 4f 20 20 |ns are:.|.ACEGO |
|00000370| 53 51 4c 2f 41 43 45 20 | 52 65 70 6f 72 74 20 57 |SQL/ACE |Report W|
|00000380| 72 69 74 65 72 20 44 72 | 69 76 65 72 20 52 65 61 |riter Dr|iver Rea|
|00000390| 64 20 50 68 61 73 65 0a | 00 54 68 65 20 72 65 70 |d Phase.|.The rep|
|000003a0| 6f 72 74 20 77 69 6c 6c | 20 6e 6f 77 20 62 65 20 |ort will| now be |
|000003b0| 70 69 70 65 64 20 74 6f | 20 22 25 73 22 2e 0a 0a |piped to| "%s"...|
|000003c0| 00 54 68 65 20 72 65 70 | 6f 72 74 20 77 69 6c 6c |.The rep|ort will|
|000003d0| 20 6e 6f 77 20 62 65 20 | 77 72 69 74 74 65 6e 20 | now be |written |
|000003e0| 74 6f 20 66 69 6c 65 20 | 22 25 73 22 2e 0a 0a 00 |to file |"%s"....|
|000003f0| 0a 54 79 70 65 20 63 61 | 72 72 69 61 67 65 20 72 |.Type ca|rriage r|
|00000400| 65 74 75 72 6e 20 74 6f | 20 63 6f 6e 74 69 6e 75 |eturn to| continu|
|00000410| 65 2e 20 0a 00 54 68 65 | 20 72 65 61 64 69 6e 67 |e. ..The| reading|
|00000420| 20 6f 66 20 74 68 65 20 | 64 61 74 61 62 61 73 65 | of the |database|
|00000430| 20 77 69 6c 6c 20 6e 6f | 77 20 62 65 67 69 6e 2e | will no|w begin.|
|00000440| 0a 0a 00 53 65 6c 65 63 | 74 20 73 74 61 74 65 6d |...Selec|t statem|
|00000450| 65 6e 74 20 6e 75 6d 62 | 65 72 20 25 64 20 77 69 |ent numb|er %d wi|
|00000460| 6c 6c 20 6e 6f 77 20 62 | 65 20 70 72 6f 63 65 73 |ll now b|e proces|
|00000470| 73 65 64 2e 0a 0a 00 54 | 68 65 20 72 65 61 64 69 |sed....T|he readi|
|00000480| 6e 67 20 6f 66 20 74 68 | 65 20 64 61 74 61 62 61 |ng of th|e databa|
|00000490| 73 65 20 68 61 73 20 66 | 69 6e 69 73 68 65 64 2e |se has f|inished.|
|000004a0| 0a 0a 00 4f 6e 6c 79 20 | 63 6f 6c 75 6d 6e 73 20 |...Only |columns |
|000004b0| 6f 66 20 74 79 70 65 20 | 43 48 41 52 41 43 54 45 |of type |CHARACTE|
|000004c0| 52 20 6d 61 79 20 62 65 | 20 73 75 62 73 63 72 69 |R may be| subscri|
|000004d0| 70 74 65 64 20 6f 72 20 | 70 72 69 6e 74 65 64 0a |pted or |printed.|
|000004e0| 77 69 74 68 6f 75 74 20 | 74 72 61 69 6c 69 6e 67 |without |trailing|
|000004f0| 20 62 6c 61 6e 6b 73 2e | 20 0a 00 41 6e 20 75 6e | blanks.| ..An un|
|00000500| 6b 6e 6f 77 6e 20 6f 70 | 65 72 61 74 69 6f 6e 20 |known op|eration |
|00000510| 63 6f 64 65 20 77 61 73 | 20 66 6f 75 6e 64 20 69 |code was| found i|
|00000520| 6e 20 74 68 65 20 50 4d | 49 4d 2e 20 0a 00 54 68 |n the PM|IM. ..Th|
|00000530| 65 20 63 6f 6c 75 6d 6e | 20 22 25 73 22 20 69 73 |e column| "%s" is|
|00000540| 20 6e 6f 74 20 69 6e 20 | 74 68 65 20 63 75 72 72 | not in |the curr|
|00000550| 65 6e 74 20 74 61 62 6c | 65 2c 20 6f 72 0a 74 68 |ent tabl|e, or.th|
|00000560| 65 20 75 73 65 72 20 76 | 61 72 69 61 62 6c 65 20 |e user v|ariable |
|00000570| 22 25 73 22 20 68 61 73 | 20 6e 6f 74 20 62 65 65 |"%s" has| not bee|
|00000580| 6e 20 64 65 66 69 6e 65 | 64 2e 0a 00 0a 20 20 20 |n define|d.... |
|00000590| 20 20 55 73 61 67 65 3a | 20 53 41 43 45 47 4f 20 | Usage:| SACEGO |
|000005a0| 20 5b 2d 71 5d 5b 2d 64 | 20 64 61 74 61 62 61 73 | [-q][-d| databas|
|000005b0| 65 5d 20 72 65 70 6f 72 | 74 5f 66 69 6c 65 6e 61 |e] repor|t_filena|
|000005c0| 6d 65 0a 0a 20 20 20 20 | 20 66 6c 61 67 73 3a 0a |me.. | flags:.|
|000005d0| 0a 09 2d 71 20 20 53 41 | 43 45 47 4f 20 77 69 6c |..-q SA|CEGO wil|
|000005e0| 6c 20 6e 6f 74 20 70 72 | 69 6e 74 20 61 6e 79 20 |l not pr|int any |
|000005f0| 6d 65 73 73 61 67 65 73 | 20 6f 72 20 65 72 72 6f |messages| or erro|
|00000600| 72 73 0a 09 20 20 20 20 | 74 6f 20 74 68 65 20 73 |rs.. |to the s|
|00000610| 63 72 65 65 6e 2e 0a 0a | 09 2d 64 20 20 53 41 43 |creen...|.-d SAC|
|00000620| 45 47 4f 20 77 69 6c 6c | 20 75 73 65 20 74 68 65 |EGO will| use the|
|00000630| 20 64 61 74 61 62 61 73 | 65 20 6e 61 6d 65 20 74 | databas|e name t|
|00000640| 68 61 74 20 66 6f 6c 6c | 6f 77 73 0a 09 20 20 20 |hat foll|ows.. |
|00000650| 20 74 68 65 20 2d 64 20 | 6f 70 74 69 6f 6e 20 69 | the -d |option i|
|00000660| 6e 73 74 65 61 64 20 6f | 66 20 74 68 65 20 64 61 |nstead o|f the da|
|00000670| 74 61 62 61 73 65 20 6e | 61 6d 65 20 0a 09 20 20 |tabase n|ame .. |
|00000680| 20 20 73 70 65 63 69 66 | 69 65 64 20 69 6e 20 74 | specif|ied in t|
|00000690| 68 65 20 44 41 54 41 42 | 41 53 45 20 53 65 63 74 |he DATAB|ASE Sect|
|000006a0| 69 6f 6e 20 6f 66 20 74 | 68 65 20 72 65 70 6f 72 |ion of t|he repor|
|000006b0| 74 20 0a 09 20 20 20 20 | 73 70 65 63 69 66 69 63 |t .. |specific|
|000006c0| 61 74 69 6f 6e 2e 0a 0a | 00 54 68 65 20 63 6f 6c |ation...|.The col|
|000006d0| 75 6d 6e 20 22 25 73 22 | 20 69 73 20 6e 6f 74 20 |umn "%s"| is not |
|000006e0| 69 6e 20 74 68 65 20 63 | 75 72 72 65 6e 74 20 74 |in the c|urrent t|
|000006f0| 61 62 6c 65 2e 20 41 6c | 6c 20 63 6f 6c 75 6d 6e |able. Al|l column|
|00000700| 73 20 75 73 65 64 0a 61 | 73 20 61 6e 20 4f 52 44 |s used.a|s an ORD|
|00000710| 45 52 20 42 59 20 63 6f | 6c 75 6d 6e 20 6d 75 73 |ER BY co|lumn mus|
|00000720| 74 20 62 65 20 69 6e 20 | 74 68 65 20 63 75 72 72 |t be in |the curr|
|00000730| 65 6e 74 20 74 61 62 6c | 65 2e 20 0a 00 54 68 65 |ent tabl|e. ..The|
|00000740| 20 72 65 70 6f 72 74 20 | 6f 75 74 70 75 74 20 66 | report |output f|
|00000750| 69 6c 65 20 22 25 73 22 | 20 63 6f 75 6c 64 20 6e |ile "%s"| could n|
|00000760| 6f 74 20 62 65 20 6f 70 | 65 6e 65 64 2e 20 20 54 |ot be op|ened. T|
|00000770| 68 69 73 20 69 73 20 0a | 70 72 6f 62 61 62 6c 79 |his is .|probably|
|00000780| 20 64 75 65 20 74 6f 20 | 70 65 72 6d 69 73 73 69 | due to |permissi|
|00000790| 6f 6e 73 2e 0a 00 54 68 | 65 20 6f 75 74 70 75 74 |ons...Th|e output|
|000007a0| 20 66 69 6c 65 20 22 25 | 73 22 20 63 6f 75 6c 64 | file "%|s" could|
|000007b0| 20 6e 6f 74 20 62 65 20 | 63 72 65 61 74 65 64 2e | not be |created.|
|000007c0| 20 0a 00 54 68 65 20 70 | 69 70 65 20 22 25 73 22 | ..The p|ipe "%s"|
|000007d0| 20 63 6f 75 6c 64 20 6e | 6f 74 20 62 65 20 6f 70 | could n|ot be op|
|000007e0| 65 6e 65 64 2e 0a 00 41 | 20 76 61 6c 75 65 20 65 |ened...A| value e|
|000007f0| 6e 74 65 72 65 64 20 62 | 79 20 74 68 65 20 75 73 |ntered b|y the us|
|00000800| 65 72 20 61 73 20 61 20 | 63 6f 6d 6d 61 6e 64 20 |er as a |command |
|00000810| 6c 69 6e 65 20 70 61 72 | 61 6d 65 74 65 72 0a 63 |line par|ameter.c|
|00000820| 61 6e 6e 6f 74 20 62 65 | 20 63 6f 6e 76 65 72 74 |annot be| convert|
|00000830| 65 64 20 74 6f 20 74 68 | 65 20 64 61 74 61 20 74 |ed to th|e data t|
|00000840| 79 70 65 20 22 25 73 22 | 2e 20 0a 00 54 68 65 20 |ype "%s"|. ..The |
|00000850| 75 73 65 72 20 76 61 72 | 69 61 62 6c 65 20 22 25 |user var|iable "%|
|00000860| 73 22 20 69 73 20 6f 66 | 20 74 79 70 65 20 22 25 |s" is of| type "%|
|00000870| 73 22 2e 20 54 68 65 20 | 76 61 6c 75 65 20 65 6e |s". The |value en|
|00000880| 74 65 72 65 64 0a 62 79 | 20 74 68 65 20 75 73 65 |tered.by| the use|
|00000890| 72 20 69 73 20 6f 75 74 | 20 6f 66 20 72 61 6e 67 |r is out| of rang|
|000008a0| 65 20 6f 72 20 63 61 6e | 6e 6f 74 20 62 65 20 63 |e or can|not be c|
|000008b0| 6f 6e 76 65 72 74 65 64 | 20 74 6f 20 74 68 61 74 |onverted| to that|
|000008c0| 20 74 79 70 65 2e 20 0a | 00 54 68 65 20 6e 75 6d | type. .|.The num|
|000008d0| 62 65 72 20 6f 66 20 64 | 65 66 69 6e 65 64 20 70 |ber of d|efined p|
|000008e0| 61 72 61 6d 65 74 65 72 | 73 20 69 6e 20 74 68 65 |arameter|s in the|
|000008f0| 20 41 43 45 20 70 72 6f | 67 72 61 6d 20 64 6f 65 | ACE pro|gram doe|
|00000900| 73 0a 6e 6f 74 20 65 71 | 75 61 6c 20 74 68 65 20 |s.not eq|ual the |
|00000910| 6e 75 6d 62 65 72 20 6f | 66 20 61 63 74 75 61 6c |number o|f actual|
|00000920| 20 70 61 72 61 6d 65 74 | 65 72 73 20 70 61 73 73 | paramet|ers pass|
|00000930| 65 64 20 74 6f 20 41 43 | 45 47 4f 0a 6f 6e 20 74 |ed to AC|EGO.on t|
|00000940| 68 65 20 63 6f 6d 6d 61 | 6e 64 20 6c 69 6e 65 2e |he comma|nd line.|
|00000950| 20 0a 00 54 68 65 20 66 | 6f 72 6d 61 74 20 73 74 | ..The f|ormat st|
|00000960| 72 69 6e 67 20 69 73 20 | 74 6f 6f 20 6c 61 72 67 |ring is |too larg|
|00000970| 65 2e 20 20 49 74 20 6d | 61 79 20 6e 6f 74 20 62 |e. It m|ay not b|
|00000980| 65 20 6c 61 72 67 65 72 | 20 74 68 61 6e 20 37 39 |e larger| than 79|
|00000990| 20 63 68 61 72 61 63 74 | 65 72 73 2e 0a 00 41 6e | charact|ers...An|
|000009a0| 20 75 6e 6b 6e 6f 77 6e | 20 65 6e 74 72 79 20 69 | unknown| entry i|
|000009b0| 6e 20 74 68 65 20 2e 61 | 72 63 20 66 69 6c 65 20 |n the .a|rc file |
|000009c0| 68 61 73 20 62 65 65 6e | 20 64 65 63 74 65 63 74 |has been| dectect|
|000009d0| 65 64 2e 20 52 65 63 6f | 6d 70 69 6c 65 0a 79 6f |ed. Reco|mpile.yo|
|000009e0| 75 72 20 41 43 45 20 72 | 65 70 6f 72 74 20 73 70 |ur ACE r|eport sp|
|000009f0| 65 63 69 66 69 63 61 74 | 69 6f 6e 20 75 73 69 6e |ecificat|ion usin|
|00000a00| 67 20 53 41 43 45 50 52 | 45 50 20 61 6e 64 20 74 |g SACEPR|EP and t|
|00000a10| 68 65 6e 20 72 65 2d 72 | 75 6e 0a 53 41 43 45 47 |hen re-r|un.SACEG|
|00000a20| 4f 2e 20 42 65 20 63 65 | 72 74 61 69 6e 20 74 68 |O. Be ce|rtain th|
|00000a30| 61 74 20 74 68 65 20 76 | 65 72 73 69 6f 6e 20 6e |at the v|ersion n|
|00000a40| 75 6d 62 65 72 73 20 66 | 6f 72 20 53 41 43 45 50 |umbers f|or SACEP|
|00000a50| 52 45 50 2c 0a 61 6e 64 | 20 53 41 43 45 47 4f 20 |REP,.and| SACEGO |
|00000a60| 61 72 65 20 69 64 65 6e | 74 69 63 61 6c 2e 20 0a |are iden|tical. .|
|00000a70| 00 41 20 76 65 72 73 69 | 6f 6e 20 69 6e 63 6f 6d |.A versi|on incom|
|00000a80| 70 61 74 69 62 69 6c 69 | 74 79 20 68 61 73 20 62 |patibili|ty has b|
|00000a90| 65 65 6e 20 64 65 74 65 | 63 74 65 64 2e 20 52 65 |een dete|cted. Re|
|00000aa0| 63 6f 6d 70 69 6c 65 0a | 79 6f 75 72 20 41 43 45 |compile.|your ACE|
|00000ab0| 20 72 65 70 6f 72 74 20 | 73 70 65 63 69 66 69 63 | report |specific|
|00000ac0| 61 74 69 6f 6e 20 75 73 | 69 6e 67 20 53 41 43 45 |ation us|ing SACE|
|00000ad0| 50 52 45 50 20 61 6e 64 | 20 74 68 65 6e 20 72 65 |PREP and| then re|
|00000ae0| 2d 72 75 6e 0a 53 41 43 | 45 47 4f 2e 20 42 65 20 |-run.SAC|EGO. Be |
|00000af0| 63 65 72 74 61 69 6e 20 | 74 68 61 74 20 74 68 65 |certain |that the|
|00000b00| 20 76 65 72 73 69 6f 6e | 20 6e 75 6d 62 65 72 73 | version| numbers|
|00000b10| 20 66 6f 72 20 53 41 43 | 45 50 52 45 50 2c 0a 61 | for SAC|EPREP,.a|
|00000b20| 6e 64 20 53 41 43 45 47 | 4f 20 61 72 65 20 69 64 |nd SACEG|O are id|
|00000b30| 65 6e 74 69 63 61 6c 2e | 20 0a 00 54 68 65 20 41 |entical.| ..The A|
|00000b40| 43 45 20 52 65 70 6f 72 | 74 20 43 6f 6e 74 72 6f |CE Repor|t Contro|
|00000b50| 6c 20 66 69 6c 65 20 22 | 25 73 22 20 63 6f 75 6c |l file "|%s" coul|
|00000b60| 64 20 6e 6f 74 20 62 65 | 20 66 6f 75 6e 64 2e 0a |d not be| found..|
|00000b70| 00 41 20 73 65 6c 65 63 | 74 20 73 74 61 74 65 6d |.A selec|t statem|
|00000b80| 65 6e 74 20 77 68 69 63 | 68 20 69 73 20 6e 6f 74 |ent whic|h is not|
|00000b90| 20 74 68 65 20 66 69 6e | 61 6c 20 73 65 6c 65 63 | the fin|al selec|
|00000ba0| 74 20 73 74 61 74 65 6d | 65 6e 74 20 69 6e 20 61 |t statem|ent in a|
|00000bb0| 6e 0a 41 43 45 20 72 65 | 70 6f 72 74 20 6d 75 73 |n.ACE re|port mus|
|00000bc0| 74 20 73 65 6c 65 63 74 | 20 69 6e 74 6f 20 61 20 |t select| into a |
|00000bd0| 74 65 6d 70 6f 72 61 72 | 79 20 74 61 62 6c 65 2e |temporar|y table.|
|00000be0| 0a 00 54 68 65 20 76 61 | 6c 75 65 73 20 25 64 20 |..The va|lues %d |
|00000bf0| 61 6e 64 20 25 64 20 75 | 73 65 64 20 74 6f 20 73 |and %d u|sed to s|
|00000c00| 75 62 73 63 72 69 70 74 | 20 22 25 73 22 20 61 72 |ubscript| "%s" ar|
|00000c10| 65 20 6f 75 74 73 69 64 | 65 0a 74 68 65 20 62 6f |e outsid|e.the bo|
|00000c20| 75 6e 64 73 20 66 6f 72 | 20 74 68 65 20 63 6f 6c |unds for| the col|
|00000c30| 75 6d 6e 27 73 20 64 65 | 66 69 6e 65 64 20 6c 65 |umn's de|fined le|
|00000c40| 6e 67 74 68 2e 20 0a 00 | 41 20 27 53 45 4c 45 43 |ngth. ..|A 'SELEC|
|00000c50| 54 20 49 4e 54 4f 27 20 | 73 74 61 74 65 6d 65 6e |T INTO' |statemen|
|00000c60| 74 20 63 61 6e 6e 6f 74 | 20 62 65 20 65 78 65 63 |t cannot| be exec|
|00000c70| 75 74 65 64 20 61 73 20 | 74 68 65 20 6c 61 73 74 |uted as |the last|
|00000c80| 20 73 65 6c 65 63 74 20 | 0a 73 74 61 74 65 6d 65 | select |.stateme|
|00000c90| 6e 74 20 69 6e 20 61 6e | 20 41 43 45 20 72 65 70 |nt in an| ACE rep|
|00000ca0| 6f 72 74 2e 0a 00 41 6e | 20 65 72 72 6f 72 20 68 |ort...An| error h|
|00000cb0| 61 73 20 6f 63 63 75 72 | 72 65 64 20 64 75 72 69 |as occur|red duri|
|00000cc0| 6e 67 20 74 68 65 20 63 | 6f 6e 76 65 72 73 69 6f |ng the c|onversio|
|00000cd0| 6e 20 6f 66 20 61 20 6e | 75 6d 65 72 69 63 20 0a |n of a n|umeric .|
|00000ce0| 76 61 6c 75 65 20 74 6f | 20 61 20 43 48 41 52 41 |value to| a CHARA|
|00000cf0| 43 54 45 52 20 74 79 70 | 65 20 75 73 65 72 20 76 |CTER typ|e user v|
|00000d00| 61 72 69 61 62 6c 65 20 | 6f 72 20 64 61 74 61 62 |ariable |or datab|
|00000d10| 61 73 65 0a 63 6f 6c 75 | 6d 6e 2e 20 54 68 65 20 |ase.colu|mn. The |
|00000d20| 43 48 41 52 41 43 54 45 | 52 20 74 79 70 65 20 63 |CHARACTE|R type c|
|00000d30| 6f 6c 75 6d 6e 20 69 73 | 20 6e 6f 74 20 6c 6f 6e |olumn is| not lon|
|00000d40| 67 20 65 6e 6f 75 67 68 | 20 74 6f 20 68 6f 6c 64 |g enough| to hold|
|00000d50| 0a 74 68 65 20 72 65 73 | 75 6c 74 2e 20 0a 00 54 |.the res|ult. ..T|
|00000d60| 68 65 20 75 73 65 72 20 | 66 75 6e 63 74 69 6f 6e |he user |function|
|00000d70| 20 22 25 73 22 2c 20 64 | 65 66 69 6e 65 64 20 62 | "%s", d|efined b|
|00000d80| 79 20 74 68 65 20 75 73 | 65 72 20 69 6e 20 74 68 |y the us|er in th|
|00000d90| 65 20 44 45 46 49 4e 45 | 0a 73 74 61 74 65 6d 65 |e DEFINE|.stateme|
|00000da0| 6e 74 20 6f 66 20 41 43 | 45 2c 20 63 6f 75 6c 64 |nt of AC|E, could|
|00000db0| 20 6e 6f 74 20 62 65 20 | 66 6f 75 6e 64 20 69 6e | not be |found in|
|00000dc0| 20 74 68 65 20 43 20 66 | 75 6e 63 74 69 6f 6e 20 | the C f|unction |
|00000dd0| 64 65 66 69 6e 69 74 69 | 6f 6e 0a 74 61 62 6c 65 |definiti|on.table|
|00000de0| 20 22 75 73 65 72 66 75 | 6e 63 73 22 20 69 6e 20 | "userfu|ncs" in |
|00000df0| 74 68 65 20 75 73 65 72 | 27 73 20 43 20 73 74 61 |the user|'s C sta|
|00000e00| 74 69 63 20 64 61 74 61 | 20 61 72 65 61 2e 20 0a |tic data| area. .|
|00000e10| 00 54 68 65 20 72 75 6e | 2d 74 69 6d 65 20 73 74 |.The run|-time st|
|00000e20| 72 69 6e 67 20 74 61 62 | 6c 65 20 69 73 20 66 75 |ring tab|le is fu|
|00000e30| 6c 6c 2e 20 20 4e 6f 20 | 6d 6f 72 65 20 6d 65 6d |ll. No |more mem|
|00000e40| 6f 72 79 20 63 61 6e 20 | 62 65 20 61 6c 6c 6f 63 |ory can |be alloc|
|00000e50| 61 74 65 64 2e 0a 00 4d | 65 6d 6f 72 79 20 61 6c |ated...M|emory al|
|00000e60| 6c 6f 63 61 74 69 6f 6e | 20 68 61 73 20 66 61 69 |location| has fai|
|00000e70| 6c 65 64 2e 20 54 68 65 | 20 75 73 65 72 27 73 20 |led. The| user's |
|00000e80| 41 43 45 20 72 65 70 6f | 72 74 20 73 70 65 63 69 |ACE repo|rt speci|
|00000e90| 66 69 63 61 74 69 6f 6e | 0a 69 73 20 74 6f 6f 20 |fication|.is too |
|00000ea0| 6c 61 72 67 65 2e 20 0a | 00 41 6e 20 65 72 72 6f |large. .|.An erro|
|00000eb0| 72 20 68 61 73 20 6f 63 | 63 75 72 72 65 64 20 77 |r has oc|curred w|
|00000ec0| 68 69 6c 65 20 77 72 69 | 74 69 6e 67 20 74 6f 20 |hile wri|ting to |
|00000ed0| 74 68 65 20 6f 75 74 70 | 75 74 20 72 65 70 6f 72 |the outp|ut repor|
|00000ee0| 74 2e 0a 00 41 43 45 27 | 73 20 61 72 69 74 68 6d |t...ACE'|s arithm|
|00000ef0| 65 74 69 63 20 73 74 61 | 63 6b 20 68 61 73 20 65 |etic sta|ck has e|
|00000f00| 78 63 65 65 64 65 64 20 | 69 74 27 73 20 62 6f 75 |xceeded |it's bou|
|00000f10| 6e 64 73 2e 20 54 68 65 | 20 65 78 70 72 65 73 73 |nds. The| express|
|00000f20| 69 6f 6e 0a 68 65 72 65 | 20 69 73 20 74 6f 6f 20 |ion.here| is too |
|00000f30| 63 6f 6d 70 6c 69 63 61 | 74 65 64 2e 20 0a 00 41 |complica|ted. ..A|
|00000f40| 6e 20 53 51 4c 20 73 74 | 61 74 65 6d 65 6e 74 20 |n SQL st|atement |
|00000f50| 68 61 73 20 62 65 65 6e | 20 66 6f 75 6e 64 20 69 |has been| found i|
|00000f60| 6e 20 74 68 65 20 53 45 | 4c 45 43 54 20 73 65 63 |n the SE|LECT sec|
|00000f70| 74 69 6f 6e 20 74 68 61 | 74 20 69 73 0a 6e 6f 74 |tion tha|t is.not|
|00000f80| 20 61 20 53 45 4c 45 43 | 54 20 73 74 61 74 65 6d | a SELEC|T statem|
|00000f90| 65 6e 74 2e 20 20 4f 6e | 6c 79 20 53 45 4c 45 43 |ent. On|ly SELEC|
|00000fa0| 54 20 73 74 61 74 65 6d | 65 6e 74 73 20 6f 72 20 |T statem|ents or |
|00000fb0| 53 45 4c 45 43 54 20 73 | 74 61 74 65 6d 65 6e 74 |SELECT s|tatement|
|00000fc0| 73 0a 74 68 61 74 20 63 | 72 65 61 74 65 20 74 65 |s.that c|reate te|
|00000fd0| 6d 70 6f 72 61 72 79 20 | 74 61 62 6c 65 73 20 61 |mporary |tables a|
|00000fe0| 72 65 20 61 6c 6c 6f 77 | 65 64 20 69 6e 20 74 68 |re allow|ed in th|
|00000ff0| 65 20 53 45 4c 45 43 54 | 20 73 65 63 74 69 6f 6e |e SELECT| section|
|00001000| 2e 0a 00 41 20 72 65 63 | 6f 72 64 20 69 6e 20 74 |...A rec|ord in t|
|00001010| 68 65 20 66 6c 61 74 20 | 61 73 63 69 69 20 69 6e |he flat |ascii in|
|00001020| 70 75 74 20 66 69 6c 65 | 20 63 6f 6e 74 61 69 6e |put file| contain|
|00001030| 73 20 6d 6f 72 65 20 64 | 61 74 61 20 66 69 65 6c |s more d|ata fiel|
|00001040| 64 73 20 74 68 61 6e 20 | 0a 77 68 61 74 20 77 61 |ds than |.what wa|
|00001050| 73 20 73 70 65 63 69 66 | 69 65 64 20 69 6e 20 74 |s specif|ied in t|
|00001060| 68 65 20 44 45 46 49 4e | 45 20 41 53 43 49 49 20 |he DEFIN|E ASCII |
|00001070| 73 74 61 74 65 6d 65 6e | 74 20 6f 66 20 74 68 65 |statemen|t of the|
|00001080| 20 72 65 70 6f 72 74 2e | 0a 00 41 20 72 65 63 6f | report.|..A reco|
|00001090| 72 64 20 69 6e 20 74 68 | 65 20 66 6c 61 74 20 61 |rd in th|e flat a|
|000010a0| 73 63 69 69 20 69 6e 70 | 75 74 20 66 69 6c 65 20 |scii inp|ut file |
|000010b0| 63 6f 6e 74 61 69 6e 73 | 20 6c 65 73 73 20 64 61 |contains| less da|
|000010c0| 74 61 20 66 69 65 6c 64 | 73 20 74 68 61 6e 20 0a |ta field|s than .|
|000010d0| 77 68 61 74 20 77 61 73 | 20 73 70 65 63 69 66 69 |what was| specifi|
|000010e0| 65 64 20 69 6e 20 74 68 | 65 20 44 45 46 49 4e 45 |ed in th|e DEFINE|
|000010f0| 20 41 53 43 49 49 20 73 | 74 61 74 65 6d 65 6e 74 | ASCII s|tatement|
|00001100| 20 6f 66 20 74 68 65 20 | 72 65 70 6f 72 74 2e 0a | of the |report..|
|00001110| 00 25 73 20 72 65 63 6f | 72 64 28 73 29 20 66 72 |.%s reco|rd(s) fr|
|00001120| 6f 6d 20 74 68 65 20 61 | 73 63 69 69 20 69 6e 70 |om the a|scii inp|
|00001130| 75 74 20 66 69 6c 65 20 | 68 61 76 65 20 62 65 65 |ut file |have bee|
|00001140| 6e 20 72 65 61 64 20 69 | 6e 2e 0a 00 41 6e 20 61 |n read i|n...An a|
|00001150| 74 74 65 6d 70 74 20 77 | 61 73 20 6d 61 64 65 20 |ttempt w|as made |
|00001160| 74 6f 20 64 69 76 69 64 | 65 20 62 79 20 7a 65 72 |to divid|e by zer|
|00001170| 6f 20 6f 6e 20 6c 69 6e | 65 20 25 64 2e 20 54 68 |o on lin|e %d. Th|
|00001180| 65 0a 72 65 73 75 6c 74 | 20 77 61 73 20 73 65 74 |e.result| was set|
|00001190| 20 74 6f 20 7a 65 72 6f | 2e 20 0a 00 44 61 74 65 | to zero|. ..Date|
|000011a0| 20 63 6f 6e 76 65 72 73 | 69 6f 6e 20 65 72 72 6f | convers|ion erro|
|000011b0| 72 2e 20 0a 00 43 68 61 | 72 61 63 74 65 72 20 64 |r. ..Cha|racter d|
|000011c0| 61 74 61 20 63 61 6e 6e | 6f 74 20 62 65 20 70 72 |ata cann|ot be pr|
|000011d0| 69 6e 74 65 64 20 77 69 | 74 68 20 22 75 73 69 6e |inted wi|th "usin|
|000011e0| 67 22 20 66 6f 72 6d 61 | 74 73 2e 0a 00 41 20 73 |g" forma|ts...A s|
|000011f0| 75 62 73 63 72 69 70 74 | 20 69 73 20 6f 75 74 20 |ubscript| is out |
|00001200| 6f 66 20 62 6f 75 6e 64 | 73 2e 0a 00 54 68 65 20 |of bound|s...The |
|00001210| 74 61 62 6c 65 20 22 25 | 73 22 20 63 6f 75 6c 64 |table "%|s" could|
|00001220| 20 6e 6f 74 20 62 65 20 | 6f 70 65 6e 65 64 2e 20 | not be |opened. |
|00001230| 0a 00 54 68 65 20 61 72 | 67 75 6d 65 6e 74 20 25 |..The ar|gument %|
|00001240| 64 20 69 73 20 6f 75 74 | 20 6f 66 20 62 6f 75 6e |d is out| of boun|
|00001250| 64 73 20 66 6f 72 20 74 | 68 65 20 61 73 63 69 69 |ds for t|he ascii|
|00001260| 20 66 75 6e 63 74 69 6f | 6e 2e 0a 41 72 67 75 6d | functio|n..Argum|
|00001270| 65 6e 74 73 20 6d 75 73 | 74 20 62 65 20 62 65 74 |ents mus|t be bet|
|00001280| 77 65 65 6e 20 30 20 61 | 6e 64 20 32 35 35 2c 20 |ween 0 a|nd 255, |
|00001290| 69 6e 63 6c 75 73 69 76 | 65 2e 0a 00 54 68 65 20 |inclusiv|e...The |
|000012a0| 6e 75 6d 62 65 72 20 6f | 66 20 6e 65 77 6c 69 6e |number o|f newlin|
|000012b0| 65 73 20 73 70 65 63 69 | 66 69 65 64 20 66 6f 72 |es speci|fied for|
|000012c0| 20 54 4f 50 20 4d 41 52 | 47 49 4e 2c 20 46 49 52 | TOP MAR|GIN, FIR|
|000012d0| 53 54 20 50 41 47 45 0a | 48 45 41 44 45 52 20 28 |ST PAGE.|HEADER (|
|000012e0| 50 41 47 45 20 48 45 41 | 44 45 52 29 2c 20 50 41 |PAGE HEA|DER), PA|
|000012f0| 47 45 20 54 52 41 49 4c | 45 52 2c 20 61 6e 64 20 |GE TRAIL|ER, and |
|00001300| 42 4f 54 54 4f 4d 20 4d | 41 52 47 49 4e 20 6d 75 |BOTTOM M|ARGIN mu|
|00001310| 73 74 0a 6c 65 61 76 65 | 20 65 6e 6f 75 67 68 20 |st.leave| enough |
|00001320| 72 6f 6f 6d 20 6f 6e 20 | 74 68 65 20 70 61 67 65 |room on |the page|
|00001330| 20 66 6f 72 20 74 68 65 | 20 70 72 69 6e 74 69 6e | for the| printin|
|00001340| 67 20 6f 66 20 74 68 65 | 20 4f 4e 0a 45 56 45 52 |g of the| ON.EVER|
|00001350| 59 20 52 45 43 4f 52 44 | 20 63 6c 61 75 73 65 2e |Y RECORD| clause.|
|00001360| 20 0a 00 54 68 65 20 41 | 43 45 20 72 65 70 6f 72 | ..The A|CE repor|
|00001370| 74 20 73 70 65 63 69 66 | 69 63 61 74 69 6f 6e 20 |t specif|ication |
|00001380| 69 73 20 74 6f 6f 20 63 | 6f 6d 70 6c 65 78 20 6f |is too c|omplex o|
|00001390| 72 20 6c 61 72 67 65 20 | 74 6f 0a 62 65 20 70 72 |r large |to.be pr|
|000013a0| 6f 70 65 72 6c 79 20 63 | 6f 6d 70 69 6c 65 64 2e |operly c|ompiled.|
|000013b0| 20 54 68 65 20 6e 75 6d | 62 65 72 20 6f 66 20 69 | The num|ber of i|
|000013c0| 6e 73 74 72 75 63 74 69 | 6f 6e 73 20 6e 65 65 64 |nstructi|ons need|
|000013d0| 65 64 0a 74 6f 20 69 6d | 70 6c 65 6d 65 6e 74 20 |ed.to im|plement |
|000013e0| 74 68 69 73 20 73 70 65 | 63 69 66 69 63 61 74 69 |this spe|cificati|
|000013f0| 6f 6e 20 69 73 20 67 72 | 65 61 74 65 72 20 74 68 |on is gr|eater th|
|00001400| 61 6e 20 74 68 65 20 73 | 70 61 63 65 0a 61 6c 6c |an the s|pace.all|
|00001410| 6f 63 61 74 65 64 20 69 | 6e 20 74 68 65 20 63 6f |ocated i|n the co|
|00001420| 6d 70 69 6c 65 72 27 73 | 20 69 6e 73 74 72 75 63 |mpiler's| instruc|
|00001430| 74 69 6f 6e 20 74 61 62 | 6c 65 73 2e 20 0a 00 41 |tion tab|les. ..A|
|00001440| 6e 20 53 4d 41 4c 4c 49 | 4e 54 45 47 45 52 20 63 |n SMALLI|NTEGER c|
|00001450| 6f 6e 73 74 61 6e 74 20 | 6d 61 79 20 6e 6f 74 20 |onstant |may not |
|00001460| 62 65 20 6c 61 72 67 65 | 72 20 74 68 61 6e 20 33 |be large|r than 3|
|00001470| 32 37 36 37 2e 20 0a 00 | 49 6c 6c 65 67 61 6c 20 |2767. ..|Illegal |
|00001480| 46 4c 4f 41 54 20 63 6f | 6e 73 74 61 6e 74 2e 20 |FLOAT co|nstant. |
|00001490| 0a 00 54 6f 6f 20 6d 61 | 6e 79 20 75 73 65 72 20 |..Too ma|ny user |
|000014a0| 76 61 72 69 61 62 6c 65 | 73 2c 20 70 61 72 61 6d |variable|s, param|
|000014b0| 65 74 65 72 73 2c 20 6f | 72 20 66 75 6e 63 74 69 |eters, o|r functi|
|000014c0| 6f 6e 73 20 68 61 76 65 | 20 62 65 65 6e 20 64 65 |ons have| been de|
|000014d0| 66 69 6e 65 64 2e 20 20 | 0a 59 6f 75 20 6d 61 79 |fined. |.You may|
|000014e0| 20 6e 6f 74 20 64 65 66 | 69 6e 65 20 61 6e 79 20 | not def|ine any |
|000014f0| 6d 6f 72 65 20 74 68 61 | 6e 20 31 30 30 20 69 6e |more tha|n 100 in|
|00001500| 20 61 6e 20 41 43 45 20 | 73 70 65 63 69 66 69 63 | an ACE |specific|
|00001510| 61 74 69 6f 6e 2e 0a 00 | 41 20 71 75 6f 74 65 64 |ation...|A quoted|
|00001520| 20 73 74 72 69 6e 67 20 | 6d 61 79 20 6e 6f 74 20 | string |may not |
|00001530| 65 78 63 65 65 64 20 25 | 64 20 63 68 61 72 61 63 |exceed %|d charac|
|00001540| 74 65 72 73 20 69 6e 20 | 6c 65 6e 67 74 68 2e 0a |ters in |length..|
|00001550| 00 54 68 65 72 65 20 69 | 73 20 61 6e 20 75 6e 6d |.There i|s an unm|
|00001560| 61 74 63 68 65 64 20 71 | 75 6f 74 65 20 69 6e 20 |atched q|uote in |
|00001570| 61 20 71 75 6f 74 65 64 | 20 73 74 72 69 6e 67 2e |a quoted| string.|
|00001580| 0a 00 54 68 65 20 66 69 | 6c 65 20 22 25 73 22 20 |..The fi|le "%s" |
|00001590| 63 6f 75 6c 64 20 6e 6f | 74 20 62 65 20 6f 70 65 |could no|t be ope|
|000015a0| 6e 65 64 2e 20 54 68 65 | 20 6f 70 65 72 61 74 69 |ned. The| operati|
|000015b0| 6e 67 20 73 79 73 74 65 | 6d 0a 77 61 73 20 61 73 |ng syste|m.was as|
|000015c0| 6b 65 64 20 74 6f 20 6f | 70 65 6e 20 69 74 20 66 |ked to o|pen it f|
|000015d0| 6f 72 20 72 65 61 64 69 | 6e 67 2e 20 0a 00 41 20 |or readi|ng. ..A |
|000015e0| 6d 65 6d 6f 72 79 20 61 | 6c 6c 6f 63 61 74 69 6f |memory a|llocatio|
|000015f0| 6e 20 65 72 72 6f 72 20 | 68 61 73 20 6f 63 63 75 |n error |has occu|
|00001600| 72 72 65 64 2e 20 20 54 | 68 65 20 41 43 45 20 72 |rred. T|he ACE r|
|00001610| 65 70 6f 72 74 0a 73 70 | 65 63 69 66 69 63 61 74 |eport.sp|ecificat|
|00001620| 69 6f 6e 20 69 73 20 70 | 72 6f 62 61 62 6c 79 20 |ion is p|robably |
|00001630| 74 6f 6f 20 6c 61 72 67 | 65 2e 0a 00 54 68 65 20 |too larg|e...The |
|00001640| 66 69 6c 65 20 22 25 73 | 22 20 63 6f 75 6c 64 20 |file "%s|" could |
|00001650| 6e 6f 74 20 62 65 20 6f | 70 65 6e 65 64 2e 20 54 |not be o|pened. T|
|00001660| 68 65 20 6f 70 65 72 61 | 74 69 6e 67 20 0a 73 79 |he opera|ting .sy|
|00001670| 73 74 65 6d 20 77 61 73 | 20 61 73 6b 65 64 20 74 |stem was| asked t|
|00001680| 6f 20 6f 70 65 6e 20 69 | 74 20 66 6f 72 20 77 72 |o open i|t for wr|
|00001690| 69 74 69 6e 67 2e 20 49 | 74 20 69 73 20 70 6f 73 |iting. I|t is pos|
|000016a0| 73 69 62 6c 65 20 74 68 | 61 74 20 61 20 66 69 6c |sible th|at a fil|
|000016b0| 65 0a 62 79 20 74 68 65 | 20 73 61 6d 65 20 6e 61 |e.by the| same na|
|000016c0| 6d 65 20 61 6c 72 65 61 | 64 79 20 65 78 69 73 74 |me alrea|dy exist|
|000016d0| 73 2c 20 62 75 74 20 74 | 68 65 20 75 73 65 72 20 |s, but t|he user |
|000016e0| 68 61 73 20 6e 6f 20 70 | 65 72 6d 69 73 73 69 6f |has no p|ermissio|
|000016f0| 6e 20 74 6f 20 77 72 69 | 74 65 20 0a 6f 76 65 72 |n to wri|te .over|
|00001700| 20 69 74 2c 20 6f 72 2c | 20 69 66 20 22 2d 6f 22 | it, or,| if "-o"|
|00001710| 20 69 73 20 75 73 65 64 | 2c 20 74 68 65 20 64 65 | is used|, the de|
|00001720| 73 74 69 6e 61 74 69 6f | 6e 20 64 69 72 65 63 74 |stinatio|n direct|
|00001730| 6f 72 79 0a 64 6f 65 73 | 20 6e 6f 74 20 65 78 69 |ory.does| not exi|
|00001740| 73 74 2e 0a 00 41 6e 20 | 65 72 72 6f 72 20 6f 63 |st...An |error oc|
|00001750| 63 75 72 72 65 64 20 77 | 68 65 6e 20 61 6e 20 61 |curred w|hen an a|
|00001760| 74 74 65 6d 70 74 20 77 | 61 73 20 6d 61 64 65 20 |ttempt w|as made |
|00001770| 74 6f 20 6f 70 65 6e 20 | 74 68 65 20 6c 69 73 74 |to open |the list|
|00001780| 69 6e 67 0a 66 69 6c 65 | 20 22 25 73 22 2e 20 20 |ing.file| "%s". |
|00001790| 42 65 20 63 65 72 74 61 | 69 6e 20 74 68 61 74 20 |Be certa|in that |
|000017a0| 74 68 65 20 75 73 65 72 | 20 68 61 73 20 77 72 69 |the user| has wri|
|000017b0| 74 65 20 70 65 72 6d 69 | 73 73 69 6f 6e 73 20 69 |te permi|ssions i|
|000017c0| 6e 0a 74 68 65 20 63 75 | 72 72 65 6e 74 20 64 69 |n.the cu|rrent di|
|000017d0| 72 65 63 74 6f 72 79 2e | 0a 00 0a 20 20 20 20 20 |rectory.|... |
|000017e0| 55 73 61 67 65 3a 20 53 | 41 43 45 50 52 45 50 20 |Usage: S|ACEPREP |
|000017f0| 5b 2d 71 5d 5b 2d 6f 20 | 6f 75 74 70 75 74 5f 64 |[-q][-o |output_d|
|00001800| 69 72 65 63 74 6f 72 79 | 5d 20 69 6e 70 75 74 5f |irectory|] input_|
|00001810| 66 69 6c 65 6e 61 6d 65 | 0a 0a 20 20 20 20 20 66 |filename|.. f|
|00001820| 6c 61 67 73 3a 0a 0a 09 | 2d 71 20 20 53 41 43 45 |lags:...|-q SACE|
|00001830| 50 52 45 50 20 77 69 6c | 6c 20 6e 6f 74 20 70 72 |PREP wil|l not pr|
|00001840| 69 6e 74 20 61 6e 79 20 | 6d 65 73 73 61 67 65 73 |int any |messages|
|00001850| 20 6f 72 20 65 72 72 6f | 72 73 0a 09 20 20 20 20 | or erro|rs.. |
|00001860| 74 6f 20 74 68 65 20 73 | 63 72 65 65 6e 2e 0a 0a |to the s|creen...|
|00001870| 09 2d 6f 20 20 53 41 43 | 45 50 52 45 50 20 77 69 |.-o SAC|EPREP wi|
|00001880| 6c 6c 20 74 61 6b 65 20 | 74 68 65 20 6e 65 78 74 |ll take |the next|
|00001890| 20 61 72 67 75 6d 65 6e | 74 20 61 73 20 74 68 65 | argumen|t as the|
|000018a0| 0a 09 20 20 20 20 64 69 | 72 65 63 74 6f 72 79 20 |.. di|rectory |
|000018b0| 77 68 65 72 65 20 74 68 | 65 20 22 2e 65 72 72 22 |where th|e ".err"|
|000018c0| 2c 20 61 6e 64 20 22 2e | 61 72 63 22 20 66 69 6c |, and ".|arc" fil|
|000018d0| 65 73 0a 09 20 20 20 20 | 77 69 6c 6c 20 62 65 20 |es.. |will be |
|000018e0| 77 72 69 74 74 65 6e 2e | 0a 0a 00 41 6e 20 6f 70 |written.|...An op|
|000018f0| 65 6e 20 63 6f 6d 6d 65 | 6e 74 20 73 79 6d 62 6f |en comme|nt symbo|
|00001900| 6c 2c 20 7b 2c 20 77 61 | 73 20 66 6f 75 6e 64 20 |l, {, wa|s found |
|00001910| 69 6e 73 69 64 65 20 61 | 6e 20 61 6c 72 65 61 64 |inside a|n alread|
|00001920| 79 20 6f 70 65 6e 0a 63 | 6f 6d 6d 65 6e 74 20 6f |y open.c|omment o|
|00001930| 6e 20 6c 69 6e 65 20 25 | 64 2c 20 63 68 61 72 61 |n line %|d, chara|
|00001940| 63 74 65 72 20 25 64 2e | 20 54 68 69 73 20 63 6f |cter %d.| This co|
|00001950| 75 6c 64 20 62 65 20 64 | 75 65 20 74 6f 0a 61 20 |uld be d|ue to.a |
|00001960| 66 61 69 6c 75 72 65 20 | 74 6f 20 63 6c 6f 73 65 |failure |to close|
|00001970| 20 74 68 65 20 70 72 65 | 76 69 6f 75 73 6c 79 20 | the pre|viously |
|00001980| 6f 70 65 6e 65 64 20 63 | 6f 6d 6d 65 6e 74 2c 20 |opened c|omment, |
|00001990| 77 68 69 63 68 20 77 61 | 73 0a 62 65 67 75 6e 20 |which wa|s.begun |
|000019a0| 6f 6e 20 6c 69 6e 65 20 | 25 64 2c 20 63 68 61 72 |on line |%d, char|
|000019b0| 61 63 74 65 72 20 25 64 | 2e 20 0a 00 41 20 63 6f |acter %d|. ..A co|
|000019c0| 6d 6d 65 6e 74 20 68 61 | 73 20 62 65 65 6e 20 6f |mment ha|s been o|
|000019d0| 70 65 6e 65 64 2c 20 62 | 75 74 20 6e 6f 74 20 63 |pened, b|ut not c|
|000019e0| 6c 6f 73 65 64 2e 20 54 | 68 65 20 6c 61 73 74 20 |losed. T|he last |
|000019f0| 63 6f 6d 6d 65 6e 74 0a | 62 65 67 75 6e 20 77 61 |comment.|begun wa|
|00001a00| 73 20 6f 70 65 6e 65 64 | 20 6f 6e 20 6c 69 6e 65 |s opened| on line|
|00001a10| 20 25 64 2c 20 63 68 61 | 72 61 63 74 65 72 20 25 | %d, cha|racter %|
|00001a20| 64 2e 20 0a 00 41 6e 20 | 69 6c 6c 65 67 61 6c 20 |d. ..An |illegal |
|00001a30| 28 69 6e 76 69 73 69 62 | 6c 65 2c 20 63 6f 6e 74 |(invisib|le, cont|
|00001a40| 72 6f 6c 29 20 63 68 61 | 72 61 63 74 65 72 20 68 |rol) cha|racter h|
|00001a50| 61 73 20 62 65 65 6e 20 | 66 6f 75 6e 64 0a 6f 6e |as been |found.on|
|00001a60| 20 6c 69 6e 65 20 25 64 | 2c 20 63 68 61 72 61 63 | line %d|, charac|
|00001a70| 74 65 72 20 25 64 2e 20 | 49 74 20 68 61 73 20 62 |ter %d. |It has b|
|00001a80| 65 65 6e 20 72 65 70 6c | 61 63 65 64 20 62 79 20 |een repl|aced by |
|00001a90| 61 20 62 6c 61 6e 6b 0a | 69 6e 20 74 68 65 20 6c |a blank.|in the l|
|00001aa0| 69 73 74 69 6e 67 2c 20 | 62 75 74 20 69 74 20 69 |isting, |but it i|
|00001ab0| 73 20 73 74 69 6c 6c 20 | 69 6e 20 74 68 65 20 73 |s still |in the s|
|00001ac0| 6f 75 72 63 65 20 28 69 | 6e 70 75 74 29 20 66 69 |ource (i|nput) fi|
|00001ad0| 6c 65 2c 0a 61 6e 64 20 | 73 68 6f 75 6c 64 20 62 |le,.and |should b|
|00001ae0| 65 20 72 65 6d 6f 76 65 | 64 20 62 65 66 6f 72 65 |e remove|d before|
|00001af0| 20 61 74 74 65 6d 70 74 | 69 6e 67 20 74 6f 20 63 | attempt|ing to c|
|00001b00| 6f 6d 70 69 6c 65 20 61 | 67 61 69 6e 2e 0a 00 41 |ompile a|gain...A|
|00001b10| 20 67 72 61 6d 6d 61 74 | 69 63 61 6c 20 65 72 72 | grammat|ical err|
|00001b20| 6f 72 20 68 61 73 20 62 | 65 65 6e 20 66 6f 75 6e |or has b|een foun|
|00001b30| 64 20 6f 6e 20 6c 69 6e | 65 20 25 64 2c 20 63 68 |d on lin|e %d, ch|
|00001b40| 61 72 61 63 74 65 72 20 | 25 64 2e 20 0a 54 68 65 |aracter |%d. .The|
|00001b50| 20 63 6f 6e 73 74 72 75 | 63 74 20 69 73 20 6e 6f | constru|ct is no|
|00001b60| 74 20 75 6e 64 65 72 73 | 74 61 6e 64 61 62 6c 65 |t unders|tandable|
|00001b70| 20 69 6e 20 69 74 73 20 | 63 6f 6e 74 65 78 74 2e | in its |context.|
|00001b80| 20 0a 00 54 68 65 20 73 | 6f 75 72 63 65 20 66 69 | ..The s|ource fi|
|00001b90| 6c 65 20 22 25 73 22 20 | 63 61 6e 20 6e 6f 74 20 |le "%s" |can not |
|00001ba0| 62 65 20 6f 70 65 6e 65 | 64 2e 20 54 68 69 73 20 |be opene|d. This |
|00001bb0| 69 73 20 70 72 6f 62 61 | 62 6c 79 0a 62 65 63 61 |is proba|bly.beca|
|00001bc0| 75 73 65 20 74 68 65 20 | 66 69 6c 65 20 64 6f 65 |use the |file doe|
|00001bd0| 73 20 6e 6f 74 20 65 78 | 69 73 74 2e 0a 00 54 68 |s not ex|ist...Th|
|00001be0| 69 73 20 69 64 65 6e 74 | 69 66 69 65 72 20 65 78 |is ident|ifier ex|
|00001bf0| 63 65 65 64 73 20 74 68 | 65 20 6d 61 78 69 6d 75 |ceeds th|e maximu|
|00001c00| 6d 20 6c 65 6e 67 74 68 | 20 66 6f 72 20 69 64 65 |m length| for ide|
|00001c10| 6e 74 69 66 69 65 72 73 | 2c 0a 77 68 69 63 68 20 |ntifiers|,.which |
|00001c20| 69 73 20 25 64 2e 20 0a | 00 54 68 65 20 63 6f 6d |is %d. .|.The com|
|00001c30| 6d 65 6e 74 20 63 6c 6f | 73 65 20 73 79 6d 62 6f |ment clo|se symbo|
|00001c40| 6c 2c 20 7d 2c 20 68 61 | 73 20 62 65 65 6e 20 66 |l, }, ha|s been f|
|00001c50| 6f 75 6e 64 20 6f 6e 20 | 6c 69 6e 65 20 25 64 2c |ound on |line %d,|
|00001c60| 0a 63 68 61 72 61 63 74 | 65 72 20 25 64 2c 20 65 |.charact|er %d, e|
|00001c70| 76 65 6e 20 74 68 6f 75 | 67 68 20 6e 6f 20 63 6f |ven thou|gh no co|
|00001c80| 6d 6d 65 6e 74 20 68 61 | 73 20 62 65 65 6e 20 6f |mment ha|s been o|
|00001c90| 70 65 6e 65 64 2e 20 0a | 00 41 6e 20 69 6c 6c 65 |pened. .|.An ille|
|00001ca0| 67 61 6c 20 28 69 6e 76 | 69 73 69 62 6c 65 2c 20 |gal (inv|isible, |
|00001cb0| 63 6f 6e 74 72 6f 6c 29 | 20 63 68 61 72 61 63 74 |control)| charact|
|00001cc0| 65 72 20 68 61 73 20 62 | 65 65 6e 20 66 6f 75 6e |er has b|een foun|
|00001cd0| 64 0a 6f 6e 20 6c 69 6e | 65 20 25 64 2c 20 63 68 |d.on lin|e %d, ch|
|00001ce0| 61 72 61 63 74 65 72 20 | 25 64 2e 20 49 74 20 68 |aracter |%d. It h|
|00001cf0| 61 73 20 62 65 65 6e 20 | 72 65 70 6c 61 63 65 64 |as been |replaced|
|00001d00| 20 62 79 20 61 20 62 6c | 61 6e 6b 0a 69 6e 20 74 | by a bl|ank.in t|
|00001d10| 68 65 20 6c 69 73 74 69 | 6e 67 2c 20 62 75 74 20 |he listi|ng, but |
|00001d20| 69 74 20 69 73 20 73 74 | 69 6c 6c 20 69 6e 20 74 |it is st|ill in t|
|00001d30| 68 65 20 73 6f 75 72 63 | 65 20 28 69 6e 70 75 74 |he sourc|e (input|
|00001d40| 29 20 66 69 6c 65 2c 0a | 61 6e 64 20 73 68 6f 75 |) file,.|and shou|
|00001d50| 6c 64 20 62 65 20 72 65 | 6d 6f 76 65 64 20 62 65 |ld be re|moved be|
|00001d60| 66 6f 72 65 20 61 74 74 | 65 6d 70 74 69 6e 67 20 |fore att|empting |
|00001d70| 74 6f 20 63 6f 6d 70 69 | 6c 65 20 61 67 61 69 6e |to compi|le again|
|00001d80| 2e 0a 00 41 20 74 79 70 | 6f 67 72 61 70 68 69 63 |...A typ|ographic|
|00001d90| 61 6c 20 65 72 72 6f 72 | 20 68 61 73 20 62 65 65 |al error| has bee|
|00001da0| 6e 20 66 6f 75 6e 64 20 | 6f 6e 20 6c 69 6e 65 20 |n found |on line |
|00001db0| 25 64 2c 20 63 68 61 72 | 61 63 74 65 72 0a 25 64 |%d, char|acter.%d|
|00001dc0| 2e 20 0a 00 54 68 65 20 | 73 6f 75 72 63 65 20 66 |. ..The |source f|
|00001dd0| 69 6c 65 20 6e 61 6d 65 | 20 22 25 73 22 20 65 78 |ile name| "%s" ex|
|00001de0| 63 65 65 64 73 20 74 68 | 65 20 6d 61 78 69 6d 75 |ceeds th|e maximu|
|00001df0| 6d 20 6c 65 6e 67 74 68 | 20 6f 66 20 25 64 2e 0a |m length| of %d..|
|00001e00| 00 41 6e 20 75 6e 6b 6e | 6f 77 6e 20 66 6c 61 67 |.An unkn|own flag|
|00001e10| 20 77 61 73 20 66 6f 75 | 6e 64 20 6f 6e 20 74 68 | was fou|nd on th|
|00001e20| 65 20 63 6f 6d 6d 61 6e | 64 20 6c 69 6e 65 2e 0a |e comman|d line..|
|00001e30| 00 54 68 65 20 4c 45 46 | 54 20 4d 41 52 47 49 4e |.The LEF|T MARGIN|
|00001e40| 20 6d 75 73 74 20 62 65 | 20 6e 6f 20 6c 65 73 73 | must be| no less|
|00001e50| 20 74 68 61 6e 20 7a 65 | 72 6f 20 61 6e 64 20 6e | than ze|ro and n|
|00001e60| 6f 20 67 72 65 61 74 65 | 72 0a 74 68 61 6e 20 74 |o greate|r.than t|
|00001e70| 68 65 20 52 49 47 48 54 | 20 4d 41 52 47 49 4e 2e |he RIGHT| MARGIN.|
|00001e80| 20 0a 00 54 68 65 72 65 | 20 69 73 20 69 6e 73 75 | ..There| is insu|
|00001e90| 66 66 69 63 69 65 6e 74 | 20 73 70 61 63 65 20 69 |fficient| space i|
|00001ea0| 6e 20 74 68 65 20 63 6f | 6d 70 69 6c 65 72 20 73 |n the co|mpiler s|
|00001eb0| 74 72 69 6e 67 20 74 61 | 62 6c 65 20 66 6f 72 0a |tring ta|ble for.|
|00001ec0| 74 68 65 20 73 74 6f 72 | 61 67 65 20 6f 66 20 43 |the stor|age of C|
|00001ed0| 48 41 52 20 76 61 72 69 | 61 62 6c 65 73 2e 20 0a |HAR vari|ables. .|
|00001ee0| 00 4e 65 69 74 68 65 72 | 20 74 68 65 20 50 41 47 |.Neither| the PAG|
|00001ef0| 45 20 4c 45 4e 47 54 48 | 2c 20 54 4f 50 20 4d 41 |E LENGTH|, TOP MA|
|00001f00| 52 47 49 4e 2c 20 6e 6f | 72 20 42 4f 54 54 4f 4d |RGIN, no|r BOTTOM|
|00001f10| 20 4d 41 52 47 49 4e 20 | 61 72 65 0a 61 6c 6c 6f | MARGIN |are.allo|
|00001f20| 77 65 64 20 74 6f 20 62 | 65 20 6c 65 73 73 20 74 |wed to b|e less t|
|00001f30| 68 61 6e 20 7a 65 72 6f | 2e 20 0a 00 54 68 65 20 |han zero|. ..The |
|00001f40| 73 74 72 69 6e 67 20 22 | 25 73 22 20 64 6f 65 73 |string "|%s" does|
|00001f50| 20 6e 6f 74 20 66 69 74 | 20 69 6e 74 6f 20 72 65 | not fit| into re|
|00001f60| 6d 61 69 6e 69 6e 67 20 | 73 70 61 63 65 20 69 6e |maining |space in|
|00001f70| 20 74 68 65 0a 63 6f 6d | 70 69 6c 65 72 27 73 20 | the.com|piler's |
|00001f80| 73 74 72 69 6e 67 20 74 | 61 62 6c 65 2e 20 0a 00 |string t|able. ..|
|00001f90| 54 68 69 73 20 63 6f 6e | 73 74 61 6e 74 20 63 61 |This con|stant ca|
|00001fa0| 75 73 65 73 20 74 68 65 | 20 63 6f 6e 73 74 61 6e |uses the| constan|
|00001fb0| 74 20 74 61 62 6c 65 20 | 69 6e 20 41 43 45 50 52 |t table |in ACEPR|
|00001fc0| 45 50 20 74 6f 20 6f 76 | 65 72 66 6c 6f 77 2e 0a |EP to ov|erflow..|
|00001fd0| 00 53 6b 69 70 70 69 6e | 67 20 6c 69 6e 65 73 20 |.Skippin|g lines |
|00001fe0| 69 6e 73 69 64 65 20 6f | 66 20 57 48 49 4c 45 20 |inside o|f WHILE |
|00001ff0| 6f 72 20 46 4f 52 20 6c | 6f 6f 70 73 20 69 73 20 |or FOR l|oops is |
|00002000| 6e 6f 74 20 61 6c 6c 6f | 77 65 64 0a 77 69 74 68 |not allo|wed.with|
|00002010| 69 6e 20 50 41 47 45 20 | 48 45 41 44 45 52 53 20 |in PAGE |HEADERS |
|00002020| 6f 72 20 54 52 41 49 4c | 45 52 53 2e 20 0a 00 4f |or TRAIL|ERS. ..O|
|00002030| 6e 6c 79 20 75 73 65 72 | 20 76 61 72 69 61 62 6c |nly user| variabl|
|00002040| 65 73 20 6f 66 20 74 79 | 70 65 20 43 48 41 52 41 |es of ty|pe CHARA|
|00002050| 43 54 45 52 20 6d 61 79 | 20 62 65 20 73 75 62 73 |CTER may| be subs|
|00002060| 63 72 69 70 74 65 64 0a | 6f 72 20 68 61 76 65 20 |cripted.|or have |
|00002070| 6c 69 73 74 73 20 69 6e | 20 74 68 65 20 4c 45 54 |lists in| the LET|
|00002080| 20 73 74 61 74 65 6d 65 | 6e 74 2e 20 0a 00 54 68 | stateme|nt. ..Th|
|00002090| 65 20 41 53 43 49 49 20 | 66 69 65 6c 64 20 25 73 |e ASCII |field %s|
|000020a0| 20 68 61 73 20 61 6c 72 | 65 61 64 79 20 62 65 65 | has alr|eady bee|
|000020b0| 6e 20 64 65 66 69 6e 65 | 64 2e 0a 00 54 68 65 20 |n define|d...The |
|000020c0| 6c 69 6d 69 74 20 66 6f | 72 20 22 49 46 22 20 73 |limit fo|r "IF" s|
|000020d0| 74 61 74 65 6d 65 6e 74 | 20 6e 65 73 74 69 6e 67 |tatement| nesting|
|000020e0| 20 68 61 73 20 62 65 65 | 6e 20 65 78 63 65 65 64 | has bee|n exceed|
|000020f0| 65 64 2e 0a 54 68 65 72 | 65 20 61 72 65 20 74 6f |ed..Ther|e are to|
|00002100| 6f 20 6d 61 6e 79 20 22 | 49 46 22 20 73 74 61 74 |o many "|IF" stat|
|00002110| 65 6d 65 6e 74 73 20 77 | 69 74 68 69 6e 20 22 49 |ements w|ithin "I|
|00002120| 46 22 20 73 74 61 74 65 | 6d 65 6e 74 73 0a 66 6f |F" state|ments.fo|
|00002130| 72 20 41 43 45 20 74 6f | 20 70 72 6f 70 65 72 6c |r ACE to| properl|
|00002140| 79 20 63 6f 6d 70 69 6c | 65 20 74 68 69 73 20 73 |y compil|e this s|
|00002150| 70 65 63 69 66 69 63 61 | 74 69 6f 6e 2e 20 0a 00 |pecifica|tion. ..|
|00002160| 41 6e 20 65 6e 64 2d 6f | 66 2d 66 69 6c 65 20 68 |An end-o|f-file h|
|00002170| 61 73 20 62 65 65 6e 20 | 70 72 65 6d 61 74 75 72 |as been |prematur|
|00002180| 65 6c 79 20 66 6f 75 6e | 64 20 69 6e 20 74 68 65 |ely foun|d in the|
|00002190| 20 72 65 70 6f 72 74 20 | 73 70 65 63 69 66 69 63 | report |specific|
|000021a0| 61 74 69 6f 6e 2e 0a 00 | 54 68 69 73 20 72 65 70 |ation...|This rep|
|000021b0| 6f 72 74 20 63 6f 6e 74 | 61 69 6e 73 20 61 20 52 |ort cont|ains a R|
|000021c0| 45 41 44 20 73 74 61 74 | 65 6d 65 6e 74 2c 20 62 |EAD stat|ement, b|
|000021d0| 75 74 20 6e 6f 20 41 53 | 43 49 49 20 72 65 63 6f |ut no AS|CII reco|
|000021e0| 72 64 20 64 65 66 69 6e | 69 74 69 6f 6e 20 20 20 |rd defin|ition |
|000021f0| 20 0a 68 61 73 20 62 65 | 65 6e 20 73 70 65 63 69 | .has be|en speci|
|00002200| 66 69 65 64 2e 0a 00 54 | 68 69 73 20 72 65 70 6f |fied...T|his repo|
|00002210| 72 74 20 63 6f 6e 74 61 | 69 6e 73 20 61 20 53 45 |rt conta|ins a SE|
|00002220| 4c 45 43 54 20 73 74 61 | 74 65 6d 65 6e 74 2c 20 |LECT sta|tement, |
|00002230| 62 75 74 20 61 20 52 45 | 41 44 20 73 74 61 74 65 |but a RE|AD state|
|00002240| 6d 65 6e 74 20 73 68 6f | 75 6c 64 0a 62 65 20 75 |ment sho|uld.be u|
|00002250| 73 65 64 20 69 6e 73 74 | 65 61 64 2c 20 62 65 63 |sed inst|ead, bec|
|00002260| 61 75 73 65 20 61 6e 20 | 41 53 43 49 49 20 72 65 |ause an |ASCII re|
|00002270| 63 6f 72 64 20 64 65 66 | 69 6e 69 74 69 6f 6e 20 |cord def|inition |
|00002280| 68 61 73 20 62 65 20 73 | 70 65 63 69 66 69 65 64 |has be s|pecified|
|00002290| 2e 0a 00 54 68 65 72 65 | 20 6d 61 79 20 62 65 20 |...There| may be |
|000022a0| 6f 6e 6c 79 20 6f 6e 65 | 20 41 46 54 45 52 20 6f |only one| AFTER o|
|000022b0| 72 20 42 45 46 4f 52 45 | 20 47 52 4f 55 50 20 4f |r BEFORE| GROUP O|
|000022c0| 46 20 63 6c 61 75 73 65 | 20 66 6f 72 0a 61 6e 79 |F clause| for.any|
|000022d0| 20 73 69 6e 67 6c 65 20 | 63 6f 6c 75 6d 6e 20 73 | single |column s|
|000022e0| 70 65 63 69 66 69 65 64 | 20 69 6e 20 74 68 65 20 |pecified| in the |
|000022f0| 4f 52 44 45 52 20 42 59 | 20 63 6f 6d 6d 61 6e 64 |ORDER BY| command|
|00002300| 2e 20 0a 00 49 6e 20 6f | 72 64 65 72 20 66 6f 72 |. ..In o|rder for|
|00002310| 20 74 68 65 20 42 45 46 | 4f 52 45 20 6f 72 20 41 | the BEF|ORE or A|
|00002320| 46 54 45 52 20 47 52 4f | 55 50 20 4f 46 20 63 6c |FTER GRO|UP OF cl|
|00002330| 61 75 73 65 20 74 6f 20 | 66 75 6e 63 74 69 6f 6e |ause to |function|
|00002340| 0a 70 72 6f 70 65 72 6c | 79 20 74 68 65 20 63 6f |.properl|y the co|
|00002350| 6c 75 6d 6e 20 73 70 65 | 63 69 66 69 65 64 20 69 |lumn spe|cified i|
|00002360| 6e 20 74 68 65 20 63 6c | 61 75 73 65 20 6d 75 73 |n the cl|ause mus|
|00002370| 74 20 61 6c 73 6f 20 68 | 61 76 65 0a 62 65 65 6e |t also h|ave.been|
|00002380| 20 73 70 65 63 69 66 69 | 65 64 20 61 73 20 61 20 | specifi|ed as a |
|00002390| 73 6f 72 74 20 63 6f 6c | 75 6d 6e 20 69 6e 20 74 |sort col|umn in t|
|000023a0| 68 65 20 4f 52 44 45 52 | 20 42 59 20 63 6f 6d 6d |he ORDER| BY comm|
|000023b0| 61 6e 64 2e 20 49 66 0a | 74 68 65 20 73 6f 72 74 |and. If.|the sort|
|000023c0| 20 63 6f 6c 75 6d 6e 20 | 69 73 20 73 75 62 73 63 | column |is subsc|
|000023d0| 72 69 70 74 65 64 2c 20 | 74 68 65 20 63 6f 6c 75 |ripted, |the colu|
|000023e0| 6d 6e 20 69 6e 20 74 68 | 65 20 42 45 46 4f 52 45 |mn in th|e BEFORE|
|000023f0| 20 6f 72 0a 41 46 54 45 | 52 20 47 52 4f 55 50 20 | or.AFTE|R GROUP |
|00002400| 4f 46 20 63 6c 61 75 73 | 65 20 6d 75 73 74 20 62 |OF claus|e must b|
|00002410| 65 20 61 6c 73 6f 2e 20 | 0a 00 47 72 6f 75 70 20 |e also. |..Group |
|00002420| 61 67 67 72 65 67 61 74 | 65 73 20 63 61 6e 20 6f |aggregat|es can o|
|00002430| 6e 6c 79 20 62 65 20 75 | 73 65 64 20 69 6e 20 61 |nly be u|sed in a|
|00002440| 6e 20 41 46 54 45 52 20 | 47 52 4f 55 50 20 4f 46 |n AFTER |GROUP OF|
|00002450| 20 63 6c 61 75 73 65 2e | 0a 00 41 67 67 72 65 67 | clause.|..Aggreg|
|00002460| 61 74 65 73 20 6d 61 79 | 20 6e 6f 74 20 62 65 20 |ates may| not be |
|00002470| 75 73 65 64 20 77 69 74 | 68 69 6e 20 61 6e 6f 74 |used wit|hin anot|
|00002480| 68 65 72 20 61 67 67 72 | 65 67 61 74 65 2e 20 4e |her aggr|egate. N|
|00002490| 6f 72 0a 6d 61 79 20 61 | 67 67 72 65 67 61 74 65 |or.may a|ggregate|
|000024a0| 73 20 62 65 20 75 73 65 | 64 20 77 69 74 68 69 6e |s be use|d within|
|000024b0| 20 74 68 65 20 57 48 45 | 52 45 20 63 6c 61 75 73 | the WHE|RE claus|
|000024c0| 65 20 6f 66 20 61 6e 6f | 74 68 65 72 0a 61 67 67 |e of ano|ther.agg|
|000024d0| 72 65 67 61 74 65 2e 20 | 0a 00 41 20 75 73 65 72 |regate. |..A user|
|000024e0| 20 76 61 72 69 61 62 6c | 65 20 6f 72 20 70 61 72 | variabl|e or par|
|000024f0| 61 6d 65 74 65 72 20 68 | 61 73 20 62 65 65 6e 20 |ameter h|as been |
|00002500| 64 65 66 69 6e 65 64 20 | 62 79 20 74 68 65 20 75 |defined |by the u|
|00002510| 73 65 72 0a 6d 6f 72 65 | 20 74 68 61 6e 20 6f 6e |ser.more| than on|
|00002520| 63 65 2e 20 0a 00 41 20 | 75 73 65 72 20 76 61 72 |ce. ..A |user var|
|00002530| 69 61 62 6c 65 20 6f 72 | 20 70 61 72 61 6d 65 74 |iable or| paramet|
|00002540| 65 72 20 6d 75 73 74 20 | 68 61 76 65 20 61 20 6c |er must |have a l|
|00002550| 65 6e 67 74 68 20 77 68 | 69 63 68 20 69 73 0a 67 |ength wh|ich is.g|
|00002560| 72 65 61 74 65 72 20 74 | 68 61 6e 20 7a 65 72 6f |reater t|han zero|
|00002570| 2e 20 0a 00 54 68 65 20 | 75 73 65 72 20 76 61 72 |. ..The |user var|
|00002580| 69 61 62 6c 65 20 63 61 | 6c 6c 65 64 20 22 25 73 |iable ca|lled "%s|
|00002590| 22 20 68 61 73 20 6e 6f | 74 20 79 65 74 20 62 65 |" has no|t yet be|
|000025a0| 65 6e 20 64 65 66 69 6e | 65 64 20 62 79 0a 74 68 |en defin|ed by.th|
|000025b0| 65 20 75 73 65 72 2e 20 | 0a 00 55 73 65 72 20 76 |e user. |..User v|
|000025c0| 61 72 69 61 62 6c 65 73 | 20 61 6e 64 20 72 75 6e |ariables| and run|
|000025d0| 2d 74 69 6d 65 20 70 61 | 72 61 6d 65 74 65 72 73 |-time pa|rameters|
|000025e0| 20 6d 61 79 20 6e 6f 74 | 20 62 65 20 75 73 65 64 | may not| be used|
|000025f0| 20 69 6e 0a 61 6e 20 4f | 52 44 45 52 20 42 59 20 | in.an O|RDER BY |
|00002600| 73 74 61 74 65 6d 65 6e | 74 2e 20 0a 00 57 69 74 |statemen|t. ..Wit|
|00002610| 68 69 6e 20 61 6e 20 49 | 46 2d 54 48 45 4e 2d 45 |hin an I|F-THEN-E|
|00002620| 4c 53 45 20 73 74 61 74 | 65 6d 65 6e 74 20 6f 66 |LSE stat|ement of|
|00002630| 20 61 20 68 65 61 64 65 | 72 20 6f 72 20 74 72 61 | a heade|r or tra|
|00002640| 69 6c 65 72 0a 63 6c 61 | 75 73 65 20 74 68 65 20 |iler.cla|use the |
|00002650| 6e 75 6d 62 65 72 20 6f | 66 20 6c 69 6e 65 73 20 |number o|f lines |
|00002660| 70 72 69 6e 74 65 64 20 | 69 6e 20 74 68 65 20 49 |printed |in the I|
|00002670| 46 20 70 61 72 74 20 6d | 75 73 74 20 65 71 75 61 |F part m|ust equa|
|00002680| 6c 0a 74 68 65 20 6e 75 | 6d 62 65 72 20 6f 66 20 |l.the nu|mber of |
|00002690| 6c 69 6e 65 73 20 70 72 | 69 6e 74 65 64 20 69 6e |lines pr|inted in|
|000026a0| 20 74 68 65 20 45 4c 53 | 45 20 70 61 72 74 2e 20 | the ELS|E part. |
|000026b0| 0a 00 53 4b 49 50 20 54 | 4f 20 54 4f 50 20 4f 46 |..SKIP T|O TOP OF|
|000026c0| 20 50 41 47 45 20 69 73 | 20 6e 6f 74 20 61 6c 6c | PAGE is| not all|
|000026d0| 6f 77 65 64 20 69 6e 20 | 61 6e 79 20 68 65 61 64 |owed in |any head|
|000026e0| 65 72 20 6f 72 20 74 72 | 61 69 6c 65 72 0a 63 6c |er or tr|ailer.cl|
|000026f0| 61 75 73 65 2e 20 0a 00 | 54 68 65 20 6e 75 6d 62 |ause. ..|The numb|
|00002700| 65 72 20 6f 66 20 6c 69 | 6e 65 73 20 74 6f 20 62 |er of li|nes to b|
|00002710| 65 20 70 72 69 6e 74 65 | 64 20 69 6e 20 74 68 65 |e printe|d in the|
|00002720| 20 74 6f 70 20 61 6e 64 | 20 62 6f 74 74 6f 6d 0a | top and| bottom.|
|00002730| 6d 61 72 67 69 6e 73 20 | 70 6c 75 73 20 74 68 65 |margins |plus the|
|00002740| 20 6c 69 6e 65 73 20 74 | 6f 20 62 65 20 70 72 69 | lines t|o be pri|
|00002750| 6e 74 65 64 20 69 6e 20 | 74 68 65 20 70 61 67 65 |nted in |the page|
|00002760| 20 68 65 61 64 65 72 20 | 61 6e 64 0a 74 72 61 69 | header |and.trai|
|00002770| 6c 65 72 20 63 6c 61 75 | 73 65 73 20 65 78 63 65 |ler clau|ses exce|
|00002780| 65 64 73 20 6f 72 20 65 | 71 75 61 6c 73 20 74 68 |eds or e|quals th|
|00002790| 65 20 70 61 67 65 20 6c | 65 6e 67 74 68 2e 20 0a |e page l|ength. .|
|000027a0| 54 68 65 20 6d 61 78 69 | 6d 75 6d 20 6e 75 6d 62 |The maxi|mum numb|
|000027b0| 65 72 20 6f 66 20 6c 69 | 6e 65 73 20 74 68 61 74 |er of li|nes that|
|000027c0| 20 63 61 6e 20 62 65 20 | 70 72 69 6e 74 65 64 20 | can be |printed |
|000027d0| 69 6e 20 74 68 65 20 70 | 61 67 65 20 20 20 0a 68 |in the p|age .h|
|000027e0| 65 61 64 65 72 20 69 73 | 20 74 68 65 20 70 61 67 |eader is| the pag|
|000027f0| 65 20 6c 65 6e 67 74 68 | 20 6d 69 6e 75 73 20 6f |e length| minus o|
|00002800| 6e 65 2e 0a 00 54 68 65 | 72 65 20 6d 61 79 20 62 |ne...The|re may b|
|00002810| 65 20 6e 6f 20 6d 6f 72 | 65 20 74 68 61 6e 20 25 |e no mor|e than %|
|00002820| 64 20 73 6f 72 74 20 63 | 6f 6c 75 6d 6e 73 20 73 |d sort c|olumns s|
|00002830| 70 65 63 69 66 69 65 64 | 20 69 6e 20 74 68 65 0a |pecified| in the.|
|00002840| 4f 52 44 45 52 20 42 59 | 20 63 6f 6d 6d 61 6e 64 |ORDER BY| command|
|00002850| 2e 20 0a 00 49 6c 6c 65 | 67 61 6c 20 73 75 62 73 |. ..Ille|gal subs|
|00002860| 63 72 69 70 74 69 6e 67 | 20 69 6e 20 4f 52 44 45 |cripting| in ORDE|
|00002870| 52 20 42 59 20 63 6f 6d | 6d 61 6e 64 20 0a 00 4e |R BY com|mand ..N|
|00002880| 45 45 44 20 6e 20 4c 49 | 4e 45 53 20 6d 61 79 20 |EED n LI|NES may |
|00002890| 6e 6f 74 20 62 65 20 75 | 73 65 64 20 69 6e 20 50 |not be u|sed in P|
|000028a0| 41 47 45 20 48 45 41 44 | 45 52 20 6f 72 20 50 41 |AGE HEAD|ER or PA|
|000028b0| 47 45 20 54 52 41 49 4c | 45 52 0a 63 6c 61 75 73 |GE TRAIL|ER.claus|
|000028c0| 65 73 2e 20 0a 00 54 68 | 65 20 50 52 49 4e 54 20 |es. ..Th|e PRINT |
|000028d0| 46 49 4c 45 20 63 6f 6d | 6d 61 6e 64 20 69 73 20 |FILE com|mand is |
|000028e0| 6e 6f 74 20 61 6c 6c 6f | 77 65 64 20 77 69 74 68 |not allo|wed with|
|000028f0| 69 6e 20 74 68 65 20 46 | 49 52 53 54 20 50 41 47 |in the F|IRST PAG|
|00002900| 45 0a 48 45 41 44 45 52 | 2c 20 50 41 47 45 20 48 |E.HEADER|, PAGE H|
|00002910| 45 41 44 45 52 2c 20 6f | 72 20 50 41 47 45 20 54 |EADER, o|r PAGE T|
|00002920| 52 41 49 4c 45 52 20 63 | 6c 61 75 73 65 73 2e 20 |RAILER c|lauses. |
|00002930| 0a 00 41 20 75 73 65 72 | 20 76 61 72 69 61 62 6c |..A user| variabl|
|00002940| 65 20 75 73 65 64 20 69 | 6e 20 74 68 65 20 61 62 |e used i|n the ab|
|00002950| 6f 76 65 20 71 75 65 72 | 79 20 68 61 73 20 6e 6f |ove quer|y has no|
|00002960| 74 20 62 65 65 6e 20 64 | 65 66 69 6e 65 64 0a 62 |t been d|efined.b|
|00002970| 79 20 74 68 65 20 75 73 | 65 72 20 69 6e 20 74 68 |y the us|er in th|
|00002980| 65 20 44 45 46 49 4e 45 | 20 73 65 63 74 69 6f 6e |e DEFINE| section|
|00002990| 2e 0a 00 54 68 65 20 6b | 65 79 77 6f 72 64 20 45 |...The k|eyword E|
|000029a0| 4e 44 20 77 61 73 20 66 | 6f 75 6e 64 20 6d 6f 72 |ND was f|ound mor|
|000029b0| 65 20 74 68 61 6e 20 6f | 6e 63 65 20 69 6e 73 69 |e than o|nce insi|
|000029c0| 64 65 20 74 68 65 20 53 | 45 4c 45 43 54 20 73 65 |de the S|ELECT se|
|000029d0| 63 74 69 6f 6e 2e 0a 57 | 69 74 68 69 6e 20 74 68 |ction..W|ithin th|
|000029e0| 65 20 53 45 4c 45 43 54 | 20 73 65 63 74 69 6f 6e |e SELECT| section|
|000029f0| 2c 20 75 73 65 20 73 65 | 6d 69 63 6f 6c 6f 6e 73 |, use se|micolons|
|00002a00| 20 74 6f 20 73 65 70 61 | 72 61 74 65 20 53 51 4c | to sepa|rate SQL|
|00002a10| 20 73 74 61 74 65 6d 65 | 6e 74 73 2e 20 20 0a 55 | stateme|nts. .U|
|00002a20| 73 65 20 74 68 65 20 6b | 65 79 77 6f 72 64 20 45 |se the k|eyword E|
|00002a30| 4e 44 20 6f 6e 6c 79 20 | 61 66 74 65 72 20 74 68 |ND only |after th|
|00002a40| 65 20 66 69 6e 61 6c 20 | 53 51 4c 20 73 74 61 74 |e final |SQL stat|
|00002a50| 65 6d 65 6e 74 20 77 69 | 74 68 69 6e 20 74 68 65 |ement wi|thin the|
|00002a60| 20 73 65 63 74 69 6f 6e | 2e 0a 00 50 41 52 41 4d | section|...PARAM|
|00002a70| 5b 30 5d 20 6d 61 79 20 | 6e 6f 74 20 62 65 20 64 |[0] may |not be d|
|00002a80| 65 66 69 6e 65 64 2e 0a | 00 54 68 65 20 66 69 6c |efined..|.The fil|
|00002a90| 65 20 22 25 73 22 20 77 | 69 6c 6c 20 6e 6f 77 20 |e "%s" w|ill now |
|00002aa0| 62 65 20 63 6f 6d 70 69 | 6c 65 64 2e 0a 00 50 72 |be compi|led...Pr|
|00002ab0| 6f 67 72 61 6d 20 6f 76 | 65 72 2e 0a 0a 00 50 72 |ogram ov|er....Pr|
|00002ac0| 6f 67 72 61 6d 20 61 62 | 6f 72 74 65 64 2e 0a 00 |ogram ab|orted...|
|00002ad0| 54 68 65 20 63 6f 6d 70 | 69 6c 61 74 69 6f 6e 20 |The comp|ilation |
|00002ae0| 77 61 73 20 73 75 63 63 | 65 73 73 66 75 6c 2e 20 |was succ|essful. |
|00002af0| 20 54 68 65 20 66 69 6c | 65 20 74 68 61 74 20 68 | The fil|e that h|
|00002b00| 6f 6c 64 73 0a 74 68 65 | 20 41 43 45 20 52 65 70 |olds.the| ACE Rep|
|00002b10| 6f 72 74 20 43 6f 6e 74 | 72 6f 6c 20 74 61 62 6c |ort Cont|rol tabl|
|00002b20| 65 73 2c 20 22 25 73 22 | 2c 20 68 61 73 20 62 65 |es, "%s"|, has be|
|00002b30| 65 6e 20 63 72 65 61 74 | 65 64 2e 0a 0a 00 54 68 |en creat|ed....Th|
|00002b40| 65 20 63 6f 6d 70 69 6c | 61 74 69 6f 6e 20 77 61 |e compil|ation wa|
|00002b50| 73 20 6e 6f 74 20 73 75 | 63 63 65 73 73 66 75 6c |s not su|ccessful|
|00002b60| 2e 20 20 45 72 72 6f 72 | 73 20 66 6f 75 6e 64 3a |. Error|s found:|
|00002b70| 20 25 64 2e 0a 54 68 65 | 20 66 69 6c 65 20 22 25 | %d..The| file "%|
|00002b80| 73 22 20 68 61 73 20 62 | 65 65 6e 20 77 72 69 74 |s" has b|een writ|
|00002b90| 74 65 6e 2e 0a 0a 00 41 | 43 45 50 52 45 50 20 20 |ten....A|CEPREP |
|00002ba0| 53 51 4c 2f 41 43 45 20 | 52 65 70 6f 72 74 20 57 |SQL/ACE |Report W|
|00002bb0| 72 69 74 69 6e 67 20 4c | 61 6e 67 75 61 67 65 20 |riting L|anguage |
|00002bc0| 43 6f 6d 70 69 6c 65 72 | 0a 00 0a 57 41 52 4e 49 |Compiler|...WARNI|
|00002bd0| 4e 47 3a 20 55 73 65 72 | 20 76 61 72 69 61 62 6c |NG: User| variabl|
|00002be0| 65 73 20 75 73 65 64 20 | 77 69 74 68 69 6e 20 61 |es used |within a|
|00002bf0| 67 67 72 65 67 61 74 65 | 73 20 6d 61 79 20 0a 6c |ggregate|s may .l|
|00002c00| 65 61 64 20 74 6f 20 75 | 6e 65 78 70 65 63 74 65 |ead to u|nexpecte|
|00002c10| 64 20 72 65 73 75 6c 74 | 73 2e 20 20 53 65 65 20 |d result|s. See |
|00002c20| 6c 69 6e 65 20 25 64 2e | 0a 00 53 65 65 20 65 72 |line %d.|..See er|
|00002c30| 72 6f 72 20 6e 75 6d 62 | 65 72 20 25 64 2e 0a 0a |ror numb|er %d...|
|00002c40| 00 53 6f 75 72 63 65 20 | 63 6f 64 65 20 6c 69 6e |.Source |code lin|
|00002c50| 65 20 6e 75 6d 62 65 72 | 20 25 64 2e 0a 0a 00 54 |e number| %d....T|
|00002c60| 68 65 20 75 73 65 72 20 | 66 75 6e 63 74 69 6f 6e |he user |function|
|00002c70| 20 63 61 6c 6c 65 64 20 | 22 25 73 22 20 68 61 73 | called |"%s" has|
|00002c80| 20 6e 6f 74 20 79 65 74 | 20 62 65 65 6e 20 64 65 | not yet| been de|
|00002c90| 66 69 6e 65 64 20 62 79 | 0a 74 68 65 20 75 73 65 |fined by|.the use|
|00002ca0| 72 2e 20 0a 00 | |r. .. | |
+--------+-------------------------+-------------------------+--------+--------+
