home *** CD-ROM | disk | FTP | other *** search
| Unknown | 1996-06-20 | 252.0 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
| PDP-11 UNIX/RT ldp
| default (weak)
| |
| 99%
| file
| data
| default
| |
| 100%
| TrID
| Cardwar Cards deck
| default (weak)
| |
| 100%
| xdgMime
| image/x-tga
| default
|
|
hex view+--------+-------------------------+-------------------------+--------+--------+
|00000000| 01 01 01 00 0a 0a 00 0a | 0a 00 0a 0a 00 00 00 00 |........|........|
|00000010| 00 25 31 20 28 25 32 29 | 00 25 31 20 28 25 32 29 |.%1 (%2)|.%1 (%2)|
|00000020| 00 25 31 20 28 25 32 29 | 00 25 31 20 28 25 32 29 |.%1 (%2)|.%1 (%2)|
|00000030| 00 00 00 73 63 68 69 6c | 69 74 65 2e 64 6c 6c 00 |...schil|ite.dll.|
|00000040| 43 48 45 43 4b 20 28 20 | 20 20 29 00 43 48 45 43 |CHECK ( | ).CHEC|
|00000050| 4b 20 28 20 20 20 29 00 | 43 48 45 43 4b 20 28 20 |K ( ).|CHECK ( |
|00000060| 20 20 29 00 00 00 00 00 | 59 45 53 00 4e 4f 00 00 | ).....|YES.NO..|
|00000070| 59 45 53 00 59 45 53 00 | 4e 4f 00 00 5c 00 00 5c |YES.YES.|NO..\..\|
|00000080| 00 25 31 20 28 25 32 29 | 00 00 00 00 34 2e 30 00 |.%1 (%2)|....4.0.|
|00000090| 35 2e 30 00 35 2e 30 2e | 30 32 00 20 00 00 00 00 |5.0.5.0.|02. ....|
|000000a0| 00 00 00 00 00 00 00 00 | 25 31 20 28 25 32 29 00 |........|%1 (%2).|
|000000b0| 00 28 20 25 31 20 29 00 | 00 00 00 00 00 00 00 00 |.( %1 ).|........|
|000000c0| 00 00 00 00 43 4f 4e 4e | 45 43 54 20 55 53 49 4e |....CONN|ECT USIN|
|000000d0| 47 20 27 25 31 27 00 25 | 31 20 2d 64 20 22 3b 22 |G '%1'.%|1 -d ";"|
|000000e0| 20 2d 63 20 22 25 32 22 | 00 49 73 71 6c 44 62 78 | -c "%2"|.IsqlDbx|
|000000f0| 54 61 67 00 49 73 71 6c | 44 62 78 49 64 6c 65 00 |Tag.Isql|DbxIdle.|
|00000100| 69 73 71 6c 2e 65 78 65 | 00 00 00 00 7c 00 7c 00 |isql.exe|....|.|.|
|00000110| 2d 2d 00 7c 00 7c 00 2d | 2d 00 2a 00 63 6f 70 79 |--.|.|.-|-.*.copy|
|00000120| 00 25 31 5f 25 32 00 73 | 63 68 69 6c 69 74 65 2e |.%1_%2.s|chilite.|
|00000130| 64 6c 6c 00 00 73 63 68 | 69 6c 69 74 65 2e 64 6c |dll..sch|ilite.dl|
|00000140| 6c 00 00 00 00 00 00 20 | 09 0d 0a 00 20 09 0d 0a |l...... |.... ...|
|00000150| 00 20 09 0d 0a 28 00 43 | 52 45 41 54 45 00 41 4c |. ...(.C|REATE.AL|
|00000160| 54 45 52 00 50 52 4f 43 | 45 44 55 52 45 00 46 55 |TER.PROC|EDURE.FU|
|00000170| 4e 43 54 49 4f 4e 00 43 | 52 45 41 54 45 20 50 52 |NCTION.C|REATE PR|
|00000180| 4f 43 45 44 55 52 45 20 | 2f 2a 20 63 72 65 61 74 |OCEDURE |/* creat|
|00000190| 6f 72 2e 20 2a 2f 22 70 | 72 6f 63 5f 6e 61 6d 65 |or. */"p|roc_name|
|000001a0| 22 20 28 20 2f 2a 20 70 | 61 72 61 6d 65 74 65 72 |" ( /* p|arameter|
|000001b0| 73 2c 2e 2e 2e 20 2a 2f | 20 29 0d 0a 2f 2a 20 52 |s,... */| )../* R|
|000001c0| 45 53 55 4c 54 20 28 20 | 63 6f 6c 75 6d 6e 2d 6e |ESULT ( |column-n|
|000001d0| 61 6d 65 2c 2e 2e 2e 20 | 29 20 2a 2f 0d 0a 42 45 |ame,... |) */..BE|
|000001e0| 47 49 4e 0d 0a 20 20 20 | 20 20 20 20 3b 0d 0a 45 |GIN.. | ;..E|
|000001f0| 4e 44 00 43 52 45 41 54 | 45 20 50 52 4f 43 45 44 |ND.CREAT|E PROCED|
|00000200| 55 52 45 20 22 00 22 2e | 22 00 22 0d 0a 20 2f 2a |URE ".".|".".. /*|
|00000210| 20 28 20 40 70 61 72 61 | 6d 65 74 65 72 5f 6e 61 | ( @para|meter_na|
|00000220| 6d 65 20 64 61 74 61 74 | 79 70 65 20 5b 3d 20 64 |me datat|ype [= d|
|00000230| 65 66 61 75 6c 74 5d 20 | 5b 6f 75 74 70 75 74 5d |efault] |[output]|
|00000240| 2c 20 2e 2e 2e 20 29 20 | 2a 2f 20 00 0d 0a 41 53 |, ... ) |*/ ...AS|
|00000250| 0d 0a 00 42 45 47 49 4e | 0d 0a 0d 0a 45 4e 44 00 |...BEGIN|....END.|
|00000260| 22 20 20 28 20 2f 2a 20 | 70 61 72 61 6d 65 74 65 |" ( /* |paramete|
|00000270| 72 73 2c 2e 2e 2e 20 2a | 2f 20 29 0d 0a 00 42 45 |rs,... *|/ )...BE|
|00000280| 47 49 4e 0d 0a 20 20 20 | 20 20 20 20 3b 0d 0a 45 |GIN.. | ;..E|
|00000290| 4e 44 00 2f 2a 20 52 45 | 53 55 4c 54 20 28 20 63 |ND./* RE|SULT ( c|
|000002a0| 6f 6c 75 6d 6e 2d 6e 61 | 6d 65 2c 2e 2e 2e 20 29 |olumn-na|me,... )|
|000002b0| 20 2a 2f 0d 0a 00 57 61 | 74 63 6f 6d 2d 53 51 4c | */...Wa|tcom-SQL|
|000002c0| 00 54 72 61 6e 73 61 63 | 74 2d 53 51 4c 00 00 00 |.Transac|t-SQL...|
|000002d0| 52 45 53 55 4d 45 20 41 | 4c 4c 3b 0d 0a 00 22 00 |RESUME A|LL;...".|
|000002e0| 2c 20 00 22 00 2c 20 00 | 43 52 45 41 54 45 20 56 |, ."., .|CREATE V|
|000002f0| 41 52 49 41 42 4c 45 20 | 22 25 31 22 20 25 32 3b |ARIABLE |"%1" %2;|
|00000300| 0d 0a 00 43 41 4c 4c 20 | 22 25 31 22 2e 22 25 32 |...CALL |"%1"."%2|
|00000310| 22 28 20 25 33 20 29 3b | 0d 0a 00 53 45 4c 45 43 |"( %3 );|...SELEC|
|00000320| 54 20 22 25 31 22 28 20 | 25 32 20 29 20 46 52 4f |T "%1"( |%2 ) FRO|
|00000330| 4d 20 44 55 4d 4d 59 3b | 0d 0a 00 53 45 4c 45 43 |M DUMMY;|...SELEC|
|00000340| 54 20 22 25 31 22 20 46 | 52 4f 4d 20 44 55 4d 4d |T "%1" F|ROM DUMM|
|00000350| 59 3b 0d 0a 00 44 52 4f | 50 20 56 41 52 49 41 42 |Y;...DRO|P VARIAB|
|00000360| 4c 45 20 22 25 31 22 3b | 0d 0a 00 53 45 54 20 22 |LE "%1";|...SET "|
|00000370| 25 31 22 20 3d 20 25 32 | 3b 0d 0a 00 53 45 54 20 |%1" = %2|;...SET |
|00000380| 4f 50 54 49 4f 4e 20 4f | 6e 5f 65 72 72 6f 72 20 |OPTION O|n_error |
|00000390| 3d 20 27 63 6f 6e 74 69 | 6e 75 65 27 3b 0d 0a 00 |= 'conti|nue';...|
|000003a0| 53 45 54 20 4f 50 54 49 | 4f 4e 20 4f 6e 5f 65 72 |SET OPTI|ON On_er|
|000003b0| 72 6f 72 20 3d 20 27 70 | 72 6f 6d 70 74 27 3b 0d |ror = 'p|rompt';.|
|000003c0| 0a 00 25 25 20 25 31 0d | 0a 00 00 00 00 00 00 00 |..%% %1.|........|
|000003d0| 73 63 68 69 6c 69 74 65 | 2e 64 6c 6c 00 53 45 4c |schilite|.dll.SEL|
|000003e0| 45 43 54 00 53 45 4c 45 | 43 54 00 00 43 52 45 41 |ECT.SELE|CT..CREA|
|000003f0| 54 45 20 50 52 4f 43 45 | 44 55 52 45 20 22 00 22 |TE PROCE|DURE "."|
|00000400| 2e 22 00 22 20 20 28 20 | 2f 2a 20 70 61 72 61 6d |."." ( |/* param|
|00000410| 65 74 65 72 73 2c 2e 2e | 2e 20 2a 2f 20 29 0d 0a |eters,..|. */ )..|
|00000420| 00 42 45 47 49 4e 0d 0a | 20 20 20 20 20 20 20 3b |.BEGIN..| ;|
|00000430| 0d 0a 45 4e 44 00 2f 2a | 20 52 45 53 55 4c 54 20 |..END./*| RESULT |
|00000440| 28 20 63 6f 6c 75 6d 6e | 2d 6e 61 6d 65 2c 2e 2e |( column|-name,..|
|00000450| 2e 20 29 20 2a 2f 0d 0a | 00 00 00 00 20 28 20 00 |. ) */..|.... ( .|
|00000460| 20 7c 20 00 20 29 00 00 | 73 63 68 69 6c 69 74 65 | | . )..|schilite|
|00000470| 2e 64 6c 6c 00 00 00 20 | 28 00 29 00 57 48 45 52 |.dll... |(.).WHER|
|00000480| 45 20 00 57 48 45 52 45 | 20 00 00 57 48 45 52 45 |E .WHERE| ..WHERE|
|00000490| 00 57 48 45 52 45 20 00 | 53 55 42 53 43 52 49 42 |.WHERE .|SUBSCRIB|
|000004a0| 45 20 42 59 20 00 53 55 | 42 53 43 52 49 42 45 20 |E BY .SU|BSCRIBE |
|000004b0| 42 59 20 00 00 00 22 25 | 31 22 00 00 00 53 55 42 |BY ..."%|1"...SUB|
|000004c0| 53 43 52 49 42 45 20 42 | 59 00 00 00 00 00 00 00 |SCRIBE B|Y.......|
|000004d0| 4e 55 4c 4c 00 00 00 00 | 00 00 00 00 00 00 00 00 |NULL....|........|
|000004e0| 00 41 64 64 20 74 6f 20 | 41 64 64 72 65 73 73 20 |.Add to |Address |
|000004f0| 4c 69 73 74 00 44 69 61 | 6c 6f 67 20 43 61 70 74 |List.Dia|log Capt|
|00000500| 69 6f 6e 00 00 41 73 79 | 6e 63 52 65 61 64 00 41 |ion..Asy|ncRead.A|
|00000510| 73 79 6e 63 57 72 69 74 | 65 00 43 61 63 68 65 52 |syncWrit|e.CacheR|
|00000520| 65 61 64 49 6e 64 49 6e | 74 00 43 61 63 68 65 52 |eadIndIn|t.CacheR|
|00000530| 65 61 64 49 6e 64 4c 65 | 61 66 00 43 61 63 68 65 |eadIndLe|af.Cache|
|00000540| 52 65 61 64 00 43 61 63 | 68 65 52 65 61 64 54 61 |Read.Cac|heReadTa|
|00000550| 62 6c 65 00 43 61 63 68 | 65 57 72 69 74 65 00 43 |ble.Cach|eWrite.C|
|00000560| 68 6b 70 74 00 43 68 6b | 70 74 46 6c 75 73 68 00 |hkpt.Chk|ptFlush.|
|00000570| 43 6f 6d 6d 69 74 46 69 | 6c 65 00 43 6f 6e 74 52 |CommitFi|le.ContR|
|00000580| 65 71 00 43 75 72 72 49 | 4f 00 43 75 72 72 52 65 |eq.CurrI|O.CurrRe|
|00000590| 61 64 00 43 75 72 72 57 | 72 69 74 65 00 44 69 73 |ad.CurrW|rite.Dis|
|000005a0| 6b 52 65 61 64 49 6e 74 | 49 6e 74 00 44 69 73 6b |kReadInt|Int.Disk|
|000005b0| 52 65 61 64 49 6e 64 4c | 65 61 66 00 44 69 73 6b |ReadIndL|eaf.Disk|
|000005c0| 52 65 61 64 00 44 69 73 | 6b 53 79 6e 63 52 65 61 |Read.Dis|kSyncRea|
|000005d0| 64 00 44 69 73 6b 57 61 | 69 74 57 72 69 74 65 00 |d.DiskWa|itWrite.|
|000005e0| 44 69 73 6b 52 65 61 64 | 54 61 62 6c 65 00 44 69 |DiskRead|Table.Di|
|000005f0| 73 6b 57 61 69 74 52 65 | 61 64 00 44 69 73 6b 57 |skWaitRe|ad.DiskW|
|00000600| 61 69 74 57 72 69 74 65 | 00 44 69 73 6b 57 72 69 |aitWrite|.DiskWri|
|00000610| 74 65 00 45 78 74 65 6e | 64 44 42 57 72 69 74 65 |te.Exten|dDBWrite|
|00000620| 00 45 78 74 65 6e 64 54 | 65 6d 70 57 72 69 74 65 |.ExtendT|empWrite|
|00000630| 00 46 72 65 65 57 72 69 | 74 65 43 75 72 72 00 46 |.FreeWri|teCurr.F|
|00000640| 72 65 65 57 72 69 74 65 | 50 75 73 68 00 46 75 6c |reeWrite|Push.Ful|
|00000650| 6c 43 6f 6d 70 61 72 65 | 00 49 64 6c 65 43 68 65 |lCompare|.IdleChe|
|00000660| 63 6b 00 49 64 6c 65 43 | 68 6b 54 69 6d 65 00 49 |ck.IdleC|hkTime.I|
|00000670| 64 6c 65 57 72 69 74 65 | 00 49 6e 64 41 64 64 00 |dleWrite|.IndAdd.|
|00000680| 49 6e 64 4c 6f 6f 6b 75 | 70 00 4d 61 78 49 4f 00 |IndLooku|p.MaxIO.|
|00000690| 4d 61 78 52 65 61 64 00 | 4d 61 78 57 72 69 74 65 |MaxRead.|MaxWrite|
|000006a0| 00 50 65 6e 64 69 6e 67 | 52 65 71 00 52 65 61 64 |.Pending|Req.Read|
|000006b0| 48 69 6e 74 00 52 65 71 | 00 55 6e 73 63 68 52 65 |Hint.Req|.UnschRe|
|000006c0| 71 00 56 6f 6c 75 6e 74 | 61 72 79 42 6c 6f 63 6b |q.Volunt|aryBlock|
|000006d0| 00 57 61 69 74 52 65 61 | 64 43 6d 70 00 57 61 69 |.WaitRea|dCmp.Wai|
|000006e0| 74 52 65 61 64 4f 70 74 | 00 57 61 69 74 52 65 61 |tReadOpt|.WaitRea|
|000006f0| 64 55 6e 6b 6e 00 00 00 | 28 27 25 31 27 29 00 28 |dUnkn...|('%1').(|
|00000700| 27 25 31 27 29 00 22 25 | 31 22 00 00 00 00 00 00 |'%1')."%|1"......|
|00000710| 00 00 28 27 25 31 27 29 | 00 28 27 25 31 27 29 00 |..('%1')|.('%1').|
|00000720| 00 00 00 00 63 6f 70 79 | 00 25 31 5f 25 32 00 53 |....copy|.%1_%2.S|
|00000730| 45 4c 45 43 54 20 2a 20 | 46 52 4f 4d 20 22 25 31 |ELECT * |FROM "%1|
|00000740| 22 2e 22 25 32 22 00 22 | 25 31 22 2e 22 25 32 22 |"."%2"."|%1"."%2"|
|00000750| 00 00 2c 00 53 59 53 54 | 45 4d 00 00 00 00 00 00 |..,.SYST|EM......|
|00000760| 53 59 53 54 45 4d 00 00 | 73 63 68 69 6c 69 74 65 |SYSTEM..|schilite|
|00000770| 2e 64 6c 6c 00 43 48 45 | 43 4b 28 20 20 20 29 00 |.dll.CHE|CK( ).|
|00000780| 00 61 6e 64 28 00 0d 0a | 00 00 00 00 2a 00 20 00 |.and(...|....*. .|
|00000790| 00 00 00 00 7c 00 2a 00 | 2d 2d 00 7c 00 00 00 00 |....|.*.|--.|....|
|000007a0| 73 63 68 69 6c 69 74 65 | 2e 64 6c 6c 00 73 63 68 |schilite|.dll.sch|
|000007b0| 69 6c 69 74 65 2e 64 6c | 6c 00 42 45 46 4f 52 45 |ilite.dl|l.BEFORE|
|000007c0| 00 41 46 54 45 52 00 44 | 45 4c 45 54 45 00 49 4e |.AFTER.D|ELETE.IN|
|000007d0| 53 45 52 54 00 55 50 44 | 41 54 45 00 52 45 53 4f |SERT.UPD|ATE.RESO|
|000007e0| 4c 56 45 00 55 50 44 41 | 54 45 20 4f 46 20 25 31 |LVE.UPDA|TE OF %1|
|000007f0| 00 43 52 45 41 54 45 20 | 54 52 49 47 47 45 52 20 |.CREATE |TRIGGER |
|00000800| 22 25 31 22 20 25 32 20 | 25 33 0d 0a 09 4f 52 44 |"%1" %2 |%3...ORD|
|00000810| 45 52 20 25 34 20 4f 4e | 20 25 35 0d 0a 00 09 46 |ER %4 ON| %5....F|
|00000820| 4f 52 20 45 41 43 48 20 | 52 4f 57 0d 0a 00 09 46 |OR EACH |ROW....F|
|00000830| 4f 52 20 45 41 43 48 20 | 53 54 41 54 45 4d 45 4e |OR EACH |STATEMEN|
|00000840| 54 0d 0a 00 09 5b 20 57 | 48 45 4e 28 20 73 65 61 |T....[ W|HEN( sea|
|00000850| 72 63 68 5f 63 6f 6e 64 | 69 74 69 6f 6e 20 29 20 |rch_cond|ition ) |
|00000860| 5d 0d 0a 42 45 47 49 4e | 0d 0a 09 3b 0d 0a 45 4e |]..BEGIN|...;..EN|
|00000870| 44 00 09 5b 20 52 45 46 | 45 52 45 4e 43 49 4e 47 |D..[ REF|ERENCING|
|00000880| 20 4f 4c 44 20 41 53 20 | 6f 6c 64 5f 6e 61 6d 65 | OLD AS |old_name|
|00000890| 20 5d 0d 0a 00 2c 20 00 | 09 5b 20 52 45 46 45 52 | ]..., .|.[ REFER|
|000008a0| 45 4e 43 49 4e 47 20 4e | 45 57 20 41 53 20 6e 65 |ENCING N|EW AS ne|
|000008b0| 77 5f 6e 61 6d 65 20 5d | 0d 0a 00 09 20 20 20 20 |w_name ]|.... |
|000008c0| 20 20 20 20 20 20 20 20 | 5b 20 4e 45 57 20 41 53 | |[ NEW AS|
|000008d0| 20 6e 65 77 5f 6e 61 6d | 65 20 5d 0d 0a 00 2c 20 | new_nam|e ]..., |
|000008e0| 00 09 52 45 46 45 52 45 | 4e 43 49 4e 47 20 5b 20 |..REFERE|NCING [ |
|000008f0| 4f 4c 44 20 41 53 20 6f | 6c 64 5f 6e 61 6d 65 20 |OLD AS o|ld_name |
|00000900| 5d 0d 0a 00 09 20 20 20 | 20 20 20 20 20 20 20 20 |].... | |
|00000910| 20 5b 20 4e 45 57 20 41 | 53 20 6e 65 77 5f 6e 61 | [ NEW A|S new_na|
|00000920| 6d 65 20 5d 0d 0a 00 09 | 20 20 20 20 20 20 20 20 |me ]....| |
|00000930| 20 20 20 20 5b 20 52 45 | 4d 4f 54 45 20 41 53 20 | [ RE|MOTE AS |
|00000940| 72 65 6d 6f 74 65 5f 6e | 61 6d 65 20 5d 0d 0a 00 |remote_n|ame ]...|
|00000950| 09 52 45 46 45 52 45 4e | 43 49 4e 47 20 5b 20 4f |.REFEREN|CING [ O|
|00000960| 4c 44 20 41 53 20 6f 6c | 64 5f 6e 61 6d 65 20 5d |LD AS ol|d_name ]|
|00000970| 0d 0a 00 09 20 20 20 20 | 20 20 20 20 20 20 20 20 |.... | |
|00000980| 5b 20 4e 45 57 20 41 53 | 20 6e 65 77 5f 6e 61 6d |[ NEW AS| new_nam|
|00000990| 65 20 5d 0d 0a 00 09 20 | 20 20 20 20 20 20 20 20 |e ].... | |
|000009a0| 20 20 20 5b 20 52 45 4d | 4f 54 45 20 41 53 20 72 | [ REM|OTE AS r|
|000009b0| 65 6d 6f 74 65 5f 6e 61 | 6d 65 20 5d 0d 0a 00 20 |emote_na|me ]... |
|000009c0| 09 0d 0a 00 20 09 0d 0a | 00 43 52 45 41 54 45 00 |.... ...|.CREATE.|
|000009d0| 41 4c 54 45 52 00 54 52 | 49 47 47 45 52 00 20 09 |ALTER.TR|IGGER. .|
|000009e0| 0d 0a 00 00 2c 20 00 2c | 20 00 00 00 2c 20 00 2c |...., .,| ..., .,|
|000009f0| 20 00 00 00 2c 20 00 2c | 20 00 00 00 73 63 68 69 | ..., .,| ...schi|
|00000a00| 6c 69 74 65 2e 64 6c 6c | 00 43 48 45 43 4b 28 20 |lite.dll|.CHECK( |
|00000a10| 20 20 29 00 00 00 00 00 | 00 00 00 00 22 25 31 22 | ).....|...."%1"|
|00000a20| 2e 22 25 32 22 00 00 00 | 25 31 20 28 25 32 29 00 |."%2"...|%1 (%2).|
|00000a30| 00 00 00 00 63 6f 70 79 | 00 25 31 5f 25 32 00 53 |....copy|.%1_%2.S|
|00000a40| 45 4c 45 43 54 20 2a 20 | 46 52 4f 4d 20 22 25 31 |ELECT * |FROM "%1|
|00000a50| 22 2e 22 25 32 22 00 73 | 63 68 69 6c 69 74 65 2e |"."%2".s|chilite.|
|00000a60| 64 6c 6c 00 00 73 63 68 | 69 6c 69 74 65 2e 64 6c |dll..sch|ilite.dl|
|00000a70| 6c 00 00 00 2c 20 00 0d | 0a 00 29 2e 00 2e 00 20 |l..., ..|..).... |
|00000a80| 00 29 2e 00 2c 20 00 0d | 0a 00 2e 28 00 2e 00 00 |.).., ..|...(....|
|00000a90| 00 20 09 0d 0a 00 20 09 | 0d 0a 00 20 09 0d 0a 28 |. .... .|... ...(|
|00000aa0| 00 43 52 45 41 54 45 00 | 41 4c 54 45 52 00 56 49 |.CREATE.|ALTER.VI|
|00000ab0| 45 57 00 43 52 45 41 54 | 45 20 56 49 45 57 20 2f |EW.CREAT|E VIEW /|
|00000ac0| 2a 20 63 72 65 61 74 6f | 72 2e 20 2a 2f 20 6e 61 |* creato|r. */ na|
|00000ad0| 6d 65 20 28 20 2f 2a 20 | 76 69 65 77 20 63 6f 6c |me ( /* |view col|
|00000ae0| 75 6d 6e 20 6e 61 6d 65 | 2c 2e 2e 2e 20 2a 2f 20 |umn name|,... */ |
|00000af0| 29 0d 0a 41 53 20 73 65 | 6c 65 63 74 2d 77 69 74 |)..AS se|lect-wit|
|00000b00| 68 6f 75 74 2d 6f 72 64 | 65 72 2d 62 79 00 43 52 |hout-ord|er-by.CR|
|00000b10| 45 41 54 45 20 56 49 45 | 57 20 22 00 22 2e 22 00 |EATE VIE|W ".".".|
|00000b20| 22 20 28 20 2f 2a 20 76 | 69 65 77 20 63 6f 6c 75 |" ( /* v|iew colu|
|00000b30| 6d 6e 20 6e 61 6d 65 2c | 2e 2e 2e 20 2a 2f 20 29 |mn name,|... */ )|
|00000b40| 0d 0a 00 41 53 20 53 45 | 4c 45 43 54 20 00 0d 0a |...AS SE|LECT ...|
|00000b50| 46 52 4f 4d 20 00 2f 2a | 20 74 61 62 6c 65 20 63 |FROM ./*| table c|
|00000b60| 6f 6c 75 6d 6e 20 6e 61 | 6d 65 2c 2e 2e 2e 20 2a |olumn na|me,... *|
|00000b70| 2f 00 2f 2a 20 74 61 62 | 6c 65 20 6e 61 6d 65 2c |/./* tab|le name,|
|00000b80| 2e 2e 2e 20 2a 2f 00 22 | 00 00 00 00 00 00 00 00 |... */."|........|
|00000b90| 20 28 00 29 00 20 28 00 | 29 00 29 00 2e 00 20 28 | (.). (.|).)... (|
|00000ba0| 00 00 00 00 7c 00 2a 00 | 2d 2d 00 7c 00 00 00 00 |....|.*.|--.|....|
|00000bb0| 21 00 25 31 25 21 25 32 | 00 25 31 2e 25 32 00 00 |!.%1%!%2|.%1.%2..|
|00000bc0| 00 00 43 6f 6e 6e 65 63 | 74 69 6f 6e 20 50 61 72 |..Connec|tion Par|
|00000bd0| 61 6d 65 74 65 72 73 00 | 25 64 00 25 78 00 25 6f |ameters.|%d.%x.%o|
|00000be0| 00 25 6c 64 00 25 6c 78 | 00 25 6c 6f 00 25 6c 75 |.%ld.%lx|.%lo.%lu|
|00000bf0| 00 00 00 00 53 51 4c 20 | 43 65 6e 74 72 61 6c 00 |....SQL |Central.|
|00000c00| 4f 75 74 20 6f 66 20 6d | 65 6d 6f 72 79 00 00 00 |Out of m|emory...|
|00000c10| 55 6e 66 72 65 65 64 20 | 62 6c 6f 63 6b 3a 20 73 |Unfreed |block: s|
|00000c20| 74 61 6d 70 65 64 20 69 | 6e 20 66 69 6c 65 20 25 |tamped i|n file %|
|00000c30| 73 2c 20 6c 69 6e 65 20 | 25 64 00 55 4e 4b 4e 4f |s, line |%d.UNKNO|
|00000c40| 57 4e 00 68 3a 5c 73 72 | 63 5c 64 62 5c 75 74 69 |WN.h:\sr|c\db\uti|
|00000c50| 6c 73 5c 63 6f 6e 66 69 | 67 5c 63 66 67 6c 69 73 |ls\confi|g\cfglis|
|00000c60| 74 2e 68 70 70 00 68 3a | 5c 73 72 63 5c 64 62 5c |t.hpp.h:|\src\db\|
|00000c70| 75 74 69 6c 73 5c 63 6f | 6e 66 69 67 5c 63 66 67 |utils\co|nfig\cfg|
|00000c80| 61 72 72 61 79 2e 68 70 | 70 00 68 3a 5c 73 72 63 |array.hp|p.h:\src|
|00000c90| 5c 64 62 5c 75 74 69 6c | 73 5c 63 6f 6e 66 69 67 |\db\util|s\config|
|00000ca0| 5c 63 66 67 61 72 72 61 | 79 2e 68 70 70 00 68 3a |\cfgarra|y.hpp.h:|
|00000cb0| 5c 73 72 63 5c 64 62 5c | 75 74 69 6c 73 5c 63 6f |\src\db\|utils\co|
|00000cc0| 6e 66 69 67 5c 63 66 67 | 61 72 72 61 79 2e 68 70 |nfig\cfg|array.hp|
|00000cd0| 70 00 68 3a 5c 73 72 63 | 5c 64 62 5c 75 74 69 6c |p.h:\src|\db\util|
|00000ce0| 73 5c 63 6f 6e 66 69 67 | 5c 63 66 67 61 72 72 61 |s\config|\cfgarra|
|00000cf0| 79 2e 68 70 70 00 68 3a | 5c 73 72 63 5c 64 62 5c |y.hpp.h:|\src\db\|
|00000d00| 75 74 69 6c 73 5c 63 6f | 6e 66 69 67 5c 63 66 67 |utils\co|nfig\cfg|
|00000d10| 61 72 72 61 79 2e 68 70 | 70 00 68 3a 5c 73 72 63 |array.hp|p.h:\src|
|00000d20| 5c 64 62 5c 75 74 69 6c | 73 5c 63 6f 6e 66 69 67 |\db\util|s\config|
|00000d30| 5c 63 66 67 61 72 72 61 | 79 2e 68 70 70 00 68 3a |\cfgarra|y.hpp.h:|
|00000d40| 5c 73 72 63 5c 64 62 5c | 75 74 69 6c 73 5c 63 6f |\src\db\|utils\co|
|00000d50| 6e 66 69 67 5c 63 66 67 | 61 72 72 61 79 2e 68 70 |nfig\cfg|array.hp|
|00000d60| 70 00 68 3a 5c 73 72 63 | 5c 64 62 5c 75 74 69 6c |p.h:\src|\db\util|
|00000d70| 73 5c 63 6f 6e 66 69 67 | 5c 63 66 67 61 72 72 61 |s\config|\cfgarra|
|00000d80| 79 2e 68 70 70 00 68 3a | 5c 73 72 63 5c 64 62 5c |y.hpp.h:|\src\db\|
|00000d90| 75 74 69 6c 73 5c 63 6f | 6e 66 69 67 5c 63 66 67 |utils\co|nfig\cfg|
|00000da0| 61 72 72 61 79 2e 68 70 | 70 00 68 3a 5c 73 72 63 |array.hp|p.h:\src|
|00000db0| 5c 64 62 5c 75 74 69 6c | 73 5c 63 6f 6e 66 69 67 |\db\util|s\config|
|00000dc0| 5c 63 66 67 61 72 72 61 | 79 2e 68 70 70 00 68 3a |\cfgarra|y.hpp.h:|
|00000dd0| 5c 73 72 63 5c 64 62 5c | 75 74 69 6c 73 5c 63 6f |\src\db\|utils\co|
|00000de0| 6e 66 69 67 5c 63 66 67 | 61 72 72 61 79 2e 68 70 |nfig\cfg|array.hp|
|00000df0| 70 00 68 3a 5c 73 72 63 | 5c 64 62 5c 75 74 69 6c |p.h:\src|\db\util|
|00000e00| 73 5c 63 6f 6e 66 69 67 | 5c 63 66 67 61 72 72 61 |s\config|\cfgarra|
|00000e10| 79 2e 68 70 70 00 68 3a | 5c 73 72 63 5c 64 62 5c |y.hpp.h:|\src\db\|
|00000e20| 75 74 69 6c 73 5c 63 6f | 6e 66 69 67 5c 63 66 67 |utils\co|nfig\cfg|
|00000e30| 61 72 72 61 79 2e 68 70 | 70 00 68 3a 5c 73 72 63 |array.hp|p.h:\src|
|00000e40| 5c 64 62 5c 75 74 69 6c | 73 5c 63 6f 6e 66 69 67 |\db\util|s\config|
|00000e50| 5c 63 66 67 61 72 72 61 | 79 2e 68 70 70 00 68 3a |\cfgarra|y.hpp.h:|
|00000e60| 5c 73 72 63 5c 64 62 5c | 75 74 69 6c 73 5c 63 6f |\src\db\|utils\co|
|00000e70| 6e 66 69 67 5c 63 66 67 | 61 72 72 61 79 2e 68 70 |nfig\cfg|array.hp|
|00000e80| 70 00 68 3a 5c 73 72 63 | 5c 64 62 5c 75 74 69 6c |p.h:\src|\db\util|
|00000e90| 73 5c 63 6f 6e 66 69 67 | 5c 63 66 67 61 72 72 61 |s\config|\cfgarra|
|00000ea0| 79 2e 68 70 70 00 00 00 | 00 00 00 00 00 53 45 4c |y.hpp...|.....SEL|
|00000eb0| 45 43 54 20 70 75 62 6c | 69 63 61 74 69 6f 6e 5f |ECT publ|ication_|
|00000ec0| 69 64 2c 20 72 65 6d 61 | 72 6b 73 20 46 52 4f 4d |id, rema|rks FROM|
|00000ed0| 20 53 59 53 50 55 42 4c | 49 43 41 54 49 4f 4e 20 | SYSPUBL|ICATION |
|00000ee0| 57 48 45 52 45 20 70 75 | 62 6c 69 63 61 74 69 6f |WHERE pu|blicatio|
|00000ef0| 6e 5f 6e 61 6d 65 20 3d | 20 27 25 31 27 20 41 4e |n_name =| '%1' AN|
|00000f00| 44 20 63 72 65 61 74 6f | 72 20 3d 20 28 53 45 4c |D creato|r = (SEL|
|00000f10| 45 43 54 20 75 73 65 72 | 5f 69 64 20 46 52 4f 4d |ECT user|_id FROM|
|00000f20| 20 53 59 53 55 53 45 52 | 50 45 52 4d 53 20 57 48 | SYSUSER|PERMS WH|
|00000f30| 45 52 45 20 75 73 65 72 | 5f 6e 61 6d 65 20 3d 20 |ERE user|_name = |
|00000f40| 27 25 32 27 29 00 41 4c | 54 45 52 20 50 55 42 4c |'%2').AL|TER PUBL|
|00000f50| 49 43 41 54 49 4f 4e 20 | 22 25 31 22 2e 22 25 32 |ICATION |"%1"."%2|
|00000f60| 22 20 52 45 4e 41 4d 45 | 20 22 25 33 22 00 43 4f |" RENAME| "%3".CO|
|00000f70| 4d 4d 45 4e 54 20 4f 4e | 20 50 55 42 4c 49 43 41 |MMENT ON| PUBLICA|
|00000f80| 54 49 4f 4e 20 22 25 31 | 22 2e 22 25 32 22 20 49 |TION "%1|"."%2" I|
|00000f90| 53 20 22 25 33 22 00 41 | 4c 54 45 52 20 50 55 42 |S "%3".A|LTER PUB|
|00000fa0| 4c 49 43 41 54 49 4f 4e | 20 22 25 31 22 2e 22 25 |LICATION| "%1"."%|
|00000fb0| 32 22 20 41 44 44 20 25 | 33 00 41 4c 54 45 52 20 |2" ADD %|3.ALTER |
|00000fc0| 50 55 42 4c 49 43 41 54 | 49 4f 4e 20 22 25 31 22 |PUBLICAT|ION "%1"|
|00000fd0| 2e 22 25 32 22 20 4d 4f | 44 49 46 59 20 25 33 00 |."%2" MO|DIFY %3.|
|00000fe0| 41 4c 54 45 52 20 50 55 | 42 4c 49 43 41 54 49 4f |ALTER PU|BLICATIO|
|00000ff0| 4e 20 22 25 31 22 2e 22 | 25 32 22 20 44 45 4c 45 |N "%1"."|%2" DELE|
|00001000| 54 45 20 54 41 42 4c 45 | 20 22 25 33 22 00 43 52 |TE TABLE| "%3".CR|
|00001010| 45 41 54 45 20 53 55 42 | 53 43 52 49 50 54 49 4f |EATE SUB|SCRIPTIO|
|00001020| 4e 20 54 4f 20 22 25 31 | 22 2e 22 25 32 22 25 33 |N TO "%1|"."%2"%3|
|00001030| 20 46 4f 52 20 25 34 00 | 28 27 25 31 27 29 00 00 | FOR %4.|('%1')..|
|00001040| 44 52 4f 50 20 53 55 42 | 53 43 52 49 50 54 49 4f |DROP SUB|SCRIPTIO|
|00001050| 4e 20 54 4f 20 22 25 31 | 22 2e 22 25 32 22 25 33 |N TO "%1|"."%2"%3|
|00001060| 20 46 4f 52 20 25 34 00 | 28 27 25 31 27 29 00 00 | FOR %4.|('%1')..|
|00001070| 53 54 41 52 54 20 53 55 | 42 53 43 52 49 50 54 49 |START SU|BSCRIPTI|
|00001080| 4f 4e 20 54 4f 20 22 25 | 31 22 2e 22 25 32 22 25 |ON TO "%|1"."%2"%|
|00001090| 33 20 46 4f 52 20 25 34 | 00 28 27 25 31 27 29 00 |3 FOR %4|.('%1').|
|000010a0| 00 53 45 4c 45 43 54 20 | 70 75 62 6c 69 63 61 74 |.SELECT |publicat|
|000010b0| 69 6f 6e 5f 6e 61 6d 65 | 2c 20 28 53 45 4c 45 43 |ion_name|, (SELEC|
|000010c0| 54 20 75 73 65 72 5f 6e | 61 6d 65 20 46 52 4f 4d |T user_n|ame FROM|
|000010d0| 20 53 59 53 55 53 45 52 | 50 45 52 4d 53 20 57 48 | SYSUSER|PERMS WH|
|000010e0| 45 52 45 20 75 73 65 72 | 5f 69 64 20 3d 20 63 72 |ERE user|_id = cr|
|000010f0| 65 61 74 6f 72 29 2c 20 | 72 65 6d 61 72 6b 73 20 |eator), |remarks |
|00001100| 46 52 4f 4d 20 53 59 53 | 50 55 42 4c 49 43 41 54 |FROM SYS|PUBLICAT|
|00001110| 49 4f 4e 00 43 52 45 41 | 54 45 20 50 55 42 4c 49 |ION.CREA|TE PUBLI|
|00001120| 43 41 54 49 4f 4e 20 22 | 25 31 22 2e 22 25 32 22 |CATION "|%1"."%2"|
|00001130| 20 28 20 25 33 20 29 00 | 43 4f 4d 4d 45 4e 54 20 | ( %3 ).|COMMENT |
|00001140| 4f 4e 20 50 55 42 4c 49 | 43 41 54 49 4f 4e 20 22 |ON PUBLI|CATION "|
|00001150| 25 31 22 2e 22 25 32 22 | 20 49 53 20 22 25 33 22 |%1"."%2"| IS "%3"|
|00001160| 00 53 45 4c 45 43 54 20 | 6e 61 6d 65 20 3d 20 28 |.SELECT |name = (|
|00001170| 53 45 4c 45 43 54 20 70 | 75 62 6c 69 63 61 74 69 |SELECT p|ublicati|
|00001180| 6f 6e 5f 6e 61 6d 65 20 | 46 52 4f 4d 20 53 59 53 |on_name |FROM SYS|
|00001190| 50 55 42 4c 49 43 41 54 | 49 4f 4e 20 42 20 57 48 |PUBLICAT|ION B WH|
|000011a0| 45 52 45 20 42 2e 70 75 | 62 6c 69 63 61 74 69 6f |ERE B.pu|blicatio|
|000011b0| 6e 5f 69 64 20 3d 20 41 | 2e 70 75 62 6c 69 63 61 |n_id = A|.publica|
|000011c0| 74 69 6f 6e 5f 69 64 29 | 2c 20 28 49 46 20 73 74 |tion_id)|, (IF st|
|000011d0| 61 72 74 65 64 20 49 53 | 20 4e 4f 54 20 4e 55 4c |arted IS| NOT NUL|
|000011e0| 4c 20 54 48 45 4e 20 27 | 59 27 20 45 4c 53 45 20 |L THEN '|Y' ELSE |
|000011f0| 27 4e 27 20 45 4e 44 49 | 46 29 2c 20 73 75 62 73 |'N' ENDI|F), subs|
|00001200| 63 72 69 62 65 5f 62 79 | 20 46 52 4f 4d 20 53 59 |cribe_by| FROM SY|
|00001210| 53 53 55 42 53 43 52 49 | 50 54 49 4f 4e 20 41 20 |SSUBSCRI|PTION A |
|00001220| 57 48 45 52 45 20 41 2e | 75 73 65 72 5f 69 64 20 |WHERE A.|user_id |
|00001230| 3d 20 28 53 45 4c 45 43 | 54 20 75 73 65 72 5f 69 |= (SELEC|T user_i|
|00001240| 64 20 46 52 4f 4d 20 53 | 59 53 55 53 45 52 50 45 |d FROM S|YSUSERPE|
|00001250| 52 4d 53 20 57 48 45 52 | 45 20 75 73 65 72 5f 6e |RMS WHER|E user_n|
|00001260| 61 6d 65 20 3d 20 27 25 | 31 27 29 20 4f 52 44 45 |ame = '%|1') ORDE|
|00001270| 52 20 42 59 20 6e 61 6d | 65 00 28 27 25 31 27 29 |R BY nam|e.('%1')|
|00001280| 00 44 52 4f 50 20 53 55 | 42 53 43 52 49 50 54 49 |.DROP SU|BSCRIPTI|
|00001290| 4f 4e 20 54 4f 20 22 25 | 31 22 25 32 20 46 4f 52 |ON TO "%|1"%2 FOR|
|000012a0| 20 22 25 33 22 00 00 53 | 54 41 52 54 20 53 55 42 | "%3"..S|TART SUB|
|000012b0| 53 43 52 49 50 54 49 4f | 4e 20 54 4f 20 25 31 20 |SCRIPTIO|N TO %1 |
|000012c0| 46 4f 52 20 25 32 00 53 | 54 4f 50 20 53 55 42 53 |FOR %2.S|TOP SUBS|
|000012d0| 43 52 49 50 54 49 4f 4e | 20 54 4f 20 25 31 20 46 |CRIPTION| TO %1 F|
|000012e0| 4f 52 20 25 32 00 53 59 | 4e 43 48 52 4f 4e 49 5a |OR %2.SY|NCHRONIZ|
|000012f0| 45 20 53 55 42 53 43 52 | 49 50 54 49 4f 4e 20 54 |E SUBSCR|IPTION T|
|00001300| 4f 20 25 31 20 46 4f 52 | 20 25 32 00 53 45 4c 45 |O %1 FOR| %2.SELE|
|00001310| 43 54 20 28 53 45 4c 45 | 43 54 20 75 73 65 72 5f |CT (SELE|CT user_|
|00001320| 6e 61 6d 65 20 46 52 4f | 4d 20 53 59 53 55 53 45 |name FRO|M SYSUSE|
|00001330| 52 50 45 52 4d 53 20 41 | 20 57 48 45 52 45 20 41 |RPERMS A| WHERE A|
|00001340| 2e 75 73 65 72 5f 69 64 | 20 3d 20 42 2e 75 73 65 |.user_id| = B.use|
|00001350| 72 5f 69 64 29 2c 20 28 | 49 46 20 73 74 61 72 74 |r_id), (|IF start|
|00001360| 65 64 20 49 53 20 4e 4f | 54 20 4e 55 4c 4c 20 54 |ed IS NO|T NULL T|
|00001370| 48 45 4e 20 27 59 27 20 | 45 4c 53 45 20 27 4e 27 |HEN 'Y' |ELSE 'N'|
|00001380| 20 45 4e 44 49 46 29 2c | 20 73 75 62 73 63 72 69 | ENDIF),| subscri|
|00001390| 62 65 5f 62 79 20 46 52 | 4f 4d 20 53 59 53 53 55 |be_by FR|OM SYSSU|
|000013a0| 42 53 43 52 49 50 54 49 | 4f 4e 20 42 20 4a 4f 49 |BSCRIPTI|ON B JOI|
|000013b0| 4e 20 53 59 53 50 55 42 | 4c 49 43 41 54 49 4f 4e |N SYSPUB|LICATION|
|000013c0| 20 57 48 45 52 45 20 70 | 75 62 6c 69 63 61 74 69 | WHERE p|ublicati|
|000013d0| 6f 6e 5f 6e 61 6d 65 20 | 3d 20 27 25 31 27 00 53 |on_name |= '%1'.S|
|000013e0| 45 4c 45 43 54 20 70 75 | 62 6c 69 63 61 74 69 6f |ELECT pu|blicatio|
|000013f0| 6e 5f 6e 61 6d 65 2c 20 | 28 53 45 4c 45 43 54 20 |n_name, |(SELECT |
|00001400| 75 73 65 72 5f 6e 61 6d | 65 20 46 52 4f 4d 20 53 |user_nam|e FROM S|
|00001410| 59 53 55 53 45 52 50 45 | 52 4d 53 20 57 48 45 52 |YSUSERPE|RMS WHER|
|00001420| 45 20 75 73 65 72 5f 69 | 64 20 3d 20 41 2e 63 72 |E user_i|d = A.cr|
|00001430| 65 61 74 6f 72 29 2c 20 | 72 65 6d 61 72 6b 73 20 |eator), |remarks |
|00001440| 46 52 4f 4d 20 53 59 53 | 50 55 42 4c 49 43 41 54 |FROM SYS|PUBLICAT|
|00001450| 49 4f 4e 20 41 00 44 52 | 4f 50 20 50 55 42 4c 49 |ION A.DR|OP PUBLI|
|00001460| 43 41 54 49 4f 4e 20 22 | 25 31 22 2e 22 25 32 22 |CATION "|%1"."%2"|
|00001470| 00 00 00 00 55 6e 6b 6e | 6f 77 6e 20 64 61 74 61 |....Unkn|own data|
|00001480| 62 61 73 65 20 65 72 72 | 6f 72 00 00 73 74 61 63 |base err|or..stac|
|00001490| 6b 20 64 61 74 61 20 68 | 61 73 20 62 65 65 6e 20 |k data h|as been |
|000014a0| 63 6f 72 72 75 70 74 65 | 64 21 00 76 69 6f 6c 61 |corrupte|d!.viola|
|000014b0| 74 69 6f 6e 20 6f 66 20 | 66 75 6e 63 74 69 6f 6e |tion of |function|
|000014c0| 20 65 78 63 65 70 74 69 | 6f 6e 20 73 70 65 63 69 | excepti|on speci|
|000014d0| 66 69 63 61 74 69 6f 6e | 21 00 74 68 72 6f 77 20 |fication|!.throw |
|000014e0| 77 68 69 6c 65 20 22 74 | 65 72 6d 69 6e 61 74 65 |while "t|erminate|
|000014f0| 22 20 66 75 6e 63 74 69 | 6f 6e 20 61 63 74 69 76 |" functi|on activ|
|00001500| 65 21 00 74 68 72 6f 77 | 20 64 75 72 69 6e 67 20 |e!.throw| during |
|00001510| 64 65 73 74 72 75 63 74 | 6f 72 20 77 68 69 6c 65 |destruct|or while|
|00001520| 20 75 6e 77 69 6e 64 69 | 6e 67 20 73 74 61 63 6b | unwindi|ng stack|
|00001530| 20 74 6f 20 63 61 74 63 | 68 20 65 78 63 65 70 74 | to catc|h except|
|00001540| 69 6f 6e 21 00 74 68 72 | 6f 77 20 77 68 69 6c 65 |ion!.thr|ow while|
|00001550| 20 22 74 65 72 6d 69 6e | 61 74 65 22 20 66 75 6e | "termin|ate" fun|
|00001560| 63 74 69 6f 6e 20 61 63 | 74 69 76 65 21 00 74 68 |ction ac|tive!.th|
|00001570| 72 6f 77 20 64 75 72 69 | 6e 67 20 63 6f 6e 73 74 |row duri|ng const|
|00001580| 72 75 63 74 69 6f 6e 20 | 6f 66 20 65 78 63 65 70 |ruction |of excep|
|00001590| 74 69 6f 6e 21 00 74 68 | 72 6f 77 20 64 75 72 69 |tion!.th|row duri|
|000015a0| 6e 67 20 64 65 73 74 72 | 75 63 74 6f 72 20 66 6f |ng destr|uctor fo|
|000015b0| 72 20 68 61 6e 64 6c 65 | 64 20 65 78 63 65 70 74 |r handle|d except|
|000015c0| 69 6f 6e 21 00 72 65 2d | 74 68 72 6f 77 20 77 68 |ion!.re-|throw wh|
|000015d0| 65 6e 20 6e 6f 20 65 78 | 63 65 70 74 69 6f 6e 20 |en no ex|ception |
|000015e0| 68 61 6e 64 6c 65 72 20 | 61 63 74 69 76 65 21 00 |handler |active!.|
|000015f0| 6e 6f 20 68 61 6e 64 6c | 65 72 20 61 63 74 69 76 |no handl|er activ|
|00001600| 65 20 74 6f 20 63 61 74 | 63 68 20 74 68 72 6f 77 |e to cat|ch throw|
|00001610| 6e 20 6f 62 6a 65 63 74 | 21 00 72 65 2d 74 68 72 |n object|!.re-thr|
|00001620| 6f 77 20 77 68 65 6e 20 | 6e 6f 20 65 78 63 65 70 |ow when |no excep|
|00001630| 74 69 6f 6e 20 68 61 6e | 64 6c 65 72 20 61 63 74 |tion han|dler act|
|00001640| 69 76 65 21 00 6e 6f 20 | 68 61 6e 64 6c 65 72 20 |ive!.no |handler |
|00001650| 61 63 74 69 76 65 20 74 | 6f 20 63 61 74 63 68 20 |active t|o catch |
|00001660| 74 68 72 6f 77 6e 20 6f | 62 6a 65 63 74 21 00 73 |thrown o|bject!.s|
|00001670| 79 73 74 65 6d 20 65 78 | 63 65 70 74 69 6f 6e 21 |ystem ex|ception!|
|00001680| 20 63 6f 64 65 20 3d 20 | 30 78 30 30 30 30 30 30 | code = |0x000000|
|00001690| 30 30 00 00 70 75 72 65 | 20 76 69 72 74 75 61 6c |00..pure| virtual|
|000016a0| 20 66 75 6e 63 74 69 6f | 6e 20 63 61 6c 6c 65 64 | functio|n called|
|000016b0| 21 00 00 00 4e 59 49 00 | 4e 59 49 00 4e 59 49 00 |!...NYI.|NYI.NYI.|
|000016c0| 00 00 00 00 63 6f 6d 70 | 69 6c 65 72 20 65 72 72 |....comp|iler err|
|000016d0| 6f 72 3a 20 65 6c 69 6d | 69 6e 61 74 65 64 20 76 |or: elim|inated v|
|000016e0| 69 72 74 75 61 6c 20 66 | 75 6e 63 74 69 6f 6e 20 |irtual f|unction |
|000016f0| 63 61 6c 6c 21 00 00 00 | 75 6e 64 65 66 69 6e 65 |call!...|undefine|
|00001700| 64 20 63 6f 6e 73 74 72 | 75 63 74 6f 72 20 6f 72 |d constr|uctor or|
|00001710| 20 64 65 73 74 72 75 63 | 74 6f 72 20 63 61 6c 6c | destruc|tor call|
|00001720| 65 64 21 00 00 2c 20 00 | 22 00 22 00 00 2c 20 00 |ed!.., .|".".., .|
|00001730| 53 45 4c 45 43 54 20 63 | 6f 6c 75 6d 6e 5f 6e 61 |SELECT c|olumn_na|
|00001740| 6d 65 2c 20 28 53 45 4c | 45 43 54 20 64 6f 6d 61 |me, (SEL|ECT doma|
|00001750| 69 6e 5f 6e 61 6d 65 20 | 46 52 4f 4d 20 53 59 53 |in_name |FROM SYS|
|00001760| 44 4f 4d 41 49 4e 20 58 | 20 57 48 45 52 45 20 58 |DOMAIN X| WHERE X|
|00001770| 2e 64 6f 6d 61 69 6e 5f | 69 64 20 3d 20 53 59 53 |.domain_|id = SYS|
|00001780| 43 4f 4c 55 4d 4e 2e 64 | 6f 6d 61 69 6e 5f 69 64 |COLUMN.d|omain_id|
|00001790| 29 2c 20 28 53 45 4c 45 | 43 54 20 74 79 70 65 5f |), (SELE|CT type_|
|000017a0| 6e 61 6d 65 20 46 52 4f | 4d 20 53 59 53 55 53 45 |name FRO|M SYSUSE|
|000017b0| 52 54 59 50 45 20 57 48 | 45 52 45 20 74 79 70 65 |RTYPE WH|ERE type|
|000017c0| 5f 69 64 20 3d 20 75 73 | 65 72 5f 74 79 70 65 29 |_id = us|er_type)|
|000017d0| 2c 20 77 69 64 74 68 2c | 20 73 63 61 6c 65 2c 20 |, width,| scale, |
|000017e0| 72 65 6d 61 72 6b 73 2c | 20 22 64 65 66 61 75 6c |remarks,| "defaul|
|000017f0| 74 22 2c 20 6e 75 6c 6c | 73 2c 20 28 53 45 4c 45 |t", null|s, (SELE|
|00001800| 43 54 20 63 6f 75 6e 74 | 28 2a 29 20 46 52 4f 4d |CT count|(*) FROM|
|00001810| 20 53 59 53 49 4e 44 45 | 58 20 69 78 20 57 48 45 | SYSINDE|X ix WHE|
|00001820| 52 45 20 74 61 62 6c 65 | 5f 69 64 20 3d 20 25 31 |RE table|_id = %1|
|00001830| 20 61 6e 64 20 22 55 6e | 69 71 75 65 22 20 3d 20 | and "Un|ique" = |
|00001840| 27 55 27 20 41 4e 44 20 | 31 20 3d 20 28 53 45 4c |'U' AND |1 = (SEL|
|00001850| 45 43 54 20 63 6f 75 6e | 74 28 2a 29 20 46 52 4f |ECT coun|t(*) FRO|
|00001860| 4d 20 53 59 53 49 58 43 | 4f 4c 20 59 20 4a 4f 49 |M SYSIXC|OL Y JOI|
|00001870| 4e 20 53 59 53 43 4f 4c | 55 4d 4e 20 41 20 57 48 |N SYSCOL|UMN A WH|
|00001880| 45 52 45 20 59 2e 74 61 | 62 6c 65 5f 69 64 20 3d |ERE Y.ta|ble_id =|
|00001890| 20 69 78 2e 74 61 62 6c | 65 5f 69 64 20 41 4e 44 | ix.tabl|e_id AND|
|000018a0| 20 69 6e 64 65 78 5f 69 | 64 20 3d 20 69 78 2e 69 | index_i|d = ix.i|
|000018b0| 6e 64 65 78 5f 69 64 20 | 41 4e 44 20 41 2e 63 6f |ndex_id |AND A.co|
|000018c0| 6c 75 6d 6e 5f 6e 61 6d | 65 20 3d 20 63 6f 6c 75 |lumn_nam|e = colu|
|000018d0| 6d 6e 5f 6e 61 6d 65 20 | 41 4e 44 20 59 2e 63 6f |mn_name |AND Y.co|
|000018e0| 6c 75 6d 6e 5f 69 64 20 | 3d 20 53 59 53 43 4f 4c |lumn_id |= SYSCOL|
|000018f0| 55 4d 4e 2e 63 6f 6c 75 | 6d 6e 5f 69 64 29 20 41 |UMN.colu|mn_id) A|
|00001900| 4e 44 20 30 20 3d 20 28 | 53 45 4c 45 43 54 20 63 |ND 0 = (|SELECT c|
|00001910| 6f 75 6e 74 28 2a 29 20 | 46 52 4f 4d 20 53 59 53 |ount(*) |FROM SYS|
|00001920| 49 58 43 4f 4c 20 5a 20 | 4a 4f 49 4e 20 53 59 53 |IXCOL Z |JOIN SYS|
|00001930| 43 4f 4c 55 4d 4e 20 42 | 20 57 48 45 52 45 20 5a |COLUMN B| WHERE Z|
|00001940| 2e 74 61 62 6c 65 5f 69 | 64 20 3d 20 69 78 2e 74 |.table_i|d = ix.t|
|00001950| 61 62 6c 65 5f 69 64 20 | 41 4e 44 20 69 6e 64 65 |able_id |AND inde|
|00001960| 78 5f 69 64 20 3d 20 69 | 78 2e 69 6e 64 65 78 5f |x_id = i|x.index_|
|00001970| 69 64 20 41 4e 44 20 42 | 2e 63 6f 6c 75 6d 6e 5f |id AND B|.column_|
|00001980| 6e 61 6d 65 20 3d 20 63 | 6f 6c 75 6d 6e 5f 6e 61 |name = c|olumn_na|
|00001990| 6d 65 20 41 4e 44 20 5a | 2e 63 6f 6c 75 6d 6e 5f |me AND Z|.column_|
|000019a0| 69 64 20 3c 3e 20 53 59 | 53 43 4f 4c 55 4d 4e 2e |id <> SY|SCOLUMN.|
|000019b0| 63 6f 6c 75 6d 6e 5f 69 | 64 29 29 2c 20 70 6b 65 |column_i|d)), pke|
|000019c0| 79 2c 20 22 63 68 65 63 | 6b 22 20 46 52 4f 4d 20 |y, "chec|k" FROM |
|000019d0| 53 59 53 43 4f 4c 55 4d | 4e 20 57 48 45 52 45 20 |SYSCOLUM|N WHERE |
|000019e0| 74 61 62 6c 65 5f 69 64 | 20 3d 20 25 31 20 4f 52 |table_id| = %1 OR|
|000019f0| 44 45 52 20 42 59 20 63 | 6f 6c 75 6d 6e 5f 69 64 |DER BY c|olumn_id|
|00001a00| 00 53 45 4c 45 43 54 20 | 63 6f 6c 75 6d 6e 5f 6e |.SELECT |column_n|
|00001a10| 61 6d 65 2c 20 28 53 45 | 4c 45 43 54 20 64 6f 6d |ame, (SE|LECT dom|
|00001a20| 61 69 6e 5f 6e 61 6d 65 | 20 46 52 4f 4d 20 53 59 |ain_name| FROM SY|
|00001a30| 53 44 4f 4d 41 49 4e 20 | 58 20 57 48 45 52 45 20 |SDOMAIN |X WHERE |
|00001a40| 58 2e 64 6f 6d 61 69 6e | 5f 69 64 20 3d 20 53 59 |X.domain|_id = SY|
|00001a50| 53 43 4f 4c 55 4d 4e 2e | 64 6f 6d 61 69 6e 5f 69 |SCOLUMN.|domain_i|
|00001a60| 64 29 2c 20 4e 55 4c 4c | 2c 20 77 69 64 74 68 2c |d), NULL|, width,|
|00001a70| 20 73 63 61 6c 65 2c 20 | 72 65 6d 61 72 6b 73 2c | scale, |remarks,|
|00001a80| 20 22 64 65 66 61 75 6c | 74 22 2c 20 6e 75 6c 6c | "defaul|t", null|
|00001a90| 73 2c 20 28 53 45 4c 45 | 43 54 20 63 6f 75 6e 74 |s, (SELE|CT count|
|00001aa0| 28 2a 29 20 46 52 4f 4d | 20 53 59 53 49 4e 44 45 |(*) FROM| SYSINDE|
|00001ab0| 58 20 69 78 20 57 48 45 | 52 45 20 74 61 62 6c 65 |X ix WHE|RE table|
|00001ac0| 5f 69 64 20 3d 20 25 31 | 20 61 6e 64 20 22 55 6e |_id = %1| and "Un|
|00001ad0| 69 71 75 65 22 20 3d 20 | 27 55 27 20 41 4e 44 20 |ique" = |'U' AND |
|00001ae0| 31 20 3d 20 28 53 45 4c | 45 43 54 20 63 6f 75 6e |1 = (SEL|ECT coun|
|00001af0| 74 28 2a 29 20 46 52 4f | 4d 20 53 59 53 49 58 43 |t(*) FRO|M SYSIXC|
|00001b00| 4f 4c 20 59 20 4a 4f 49 | 4e 20 53 59 53 43 4f 4c |OL Y JOI|N SYSCOL|
|00001b10| 55 4d 4e 20 41 20 57 48 | 45 52 45 20 59 2e 74 61 |UMN A WH|ERE Y.ta|
|00001b20| 62 6c 65 5f 69 64 20 3d | 20 69 78 2e 74 61 62 6c |ble_id =| ix.tabl|
|00001b30| 65 5f 69 64 20 41 4e 44 | 20 69 6e 64 65 78 5f 69 |e_id AND| index_i|
|00001b40| 64 20 3d 20 69 78 2e 69 | 6e 64 65 78 5f 69 64 20 |d = ix.i|ndex_id |
|00001b50| 41 4e 44 20 41 2e 63 6f | 6c 75 6d 6e 5f 6e 61 6d |AND A.co|lumn_nam|
|00001b60| 65 20 3d 20 63 6f 6c 75 | 6d 6e 5f 6e 61 6d 65 20 |e = colu|mn_name |
|00001b70| 41 4e 44 20 59 2e 63 6f | 6c 75 6d 6e 5f 69 64 20 |AND Y.co|lumn_id |
|00001b80| 3d 20 53 59 53 43 4f 4c | 55 4d 4e 2e 63 6f 6c 75 |= SYSCOL|UMN.colu|
|00001b90| 6d 6e 5f 69 64 29 20 41 | 4e 44 20 30 20 3d 20 28 |mn_id) A|ND 0 = (|
|00001ba0| 53 45 4c 45 43 54 20 63 | 6f 75 6e 74 28 2a 29 20 |SELECT c|ount(*) |
|00001bb0| 46 52 4f 4d 20 53 59 53 | 49 58 43 4f 4c 20 5a 20 |FROM SYS|IXCOL Z |
|00001bc0| 4a 4f 49 4e 20 53 59 53 | 43 4f 4c 55 4d 4e 20 42 |JOIN SYS|COLUMN B|
|00001bd0| 20 57 48 45 52 45 20 5a | 2e 74 61 62 6c 65 5f 69 | WHERE Z|.table_i|
|00001be0| 64 20 3d 20 69 78 2e 74 | 61 62 6c 65 5f 69 64 20 |d = ix.t|able_id |
|00001bf0| 41 4e 44 20 69 6e 64 65 | 78 5f 69 64 20 3d 20 69 |AND inde|x_id = i|
|00001c00| 78 2e 69 6e 64 65 78 5f | 69 64 20 41 4e 44 20 42 |x.index_|id AND B|
|00001c10| 2e 63 6f 6c 75 6d 6e 5f | 6e 61 6d 65 20 3d 20 63 |.column_|name = c|
|00001c20| 6f 6c 75 6d 6e 5f 6e 61 | 6d 65 20 41 4e 44 20 5a |olumn_na|me AND Z|
|00001c30| 2e 63 6f 6c 75 6d 6e 5f | 69 64 20 3c 3e 20 53 59 |.column_|id <> SY|
|00001c40| 53 43 4f 4c 55 4d 4e 2e | 63 6f 6c 75 6d 6e 5f 69 |SCOLUMN.|column_i|
|00001c50| 64 29 29 2c 20 70 6b 65 | 79 2c 20 4e 55 4c 4c 20 |d)), pke|y, NULL |
|00001c60| 46 52 4f 4d 20 53 59 53 | 43 4f 4c 55 4d 4e 20 57 |FROM SYS|COLUMN W|
|00001c70| 48 45 52 45 20 74 61 62 | 6c 65 5f 69 64 20 3d 20 |HERE tab|le_id = |
|00001c80| 25 31 20 4f 52 44 45 52 | 20 42 59 20 63 6f 6c 75 |%1 ORDER| BY colu|
|00001c90| 6d 6e 5f 69 64 00 30 00 | 4e 00 59 00 20 4e 4f 54 |mn_id.0.|N.Y. NOT|
|00001ca0| 20 4e 55 4c 4c 00 20 55 | 4e 49 51 55 45 00 20 44 | NULL. U|NIQUE. D|
|00001cb0| 45 46 41 55 4c 54 20 25 | 31 00 22 25 31 22 20 25 |EFAULT %|1."%1" %|
|00001cc0| 32 20 00 27 25 31 27 00 | 20 00 41 4c 54 45 52 20 |2 .'%1'.| .ALTER |
|00001cd0| 54 41 42 4c 45 20 25 31 | 20 44 45 4c 45 54 45 20 |TABLE %1| DELETE |
|00001ce0| 22 25 32 22 00 41 4c 54 | 45 52 20 54 41 42 4c 45 |"%2".ALT|ER TABLE|
|00001cf0| 20 22 25 31 22 2e 22 25 | 32 22 20 41 44 44 20 25 | "%1"."%|2" ADD %|
|00001d00| 33 00 20 28 0d 0a 00 43 | 48 45 43 4b 00 43 4f 4d |3. (...C|HECK.COM|
|00001d10| 4d 45 4e 54 20 4f 4e 20 | 43 4f 4c 55 4d 4e 20 25 |MENT ON |COLUMN %|
|00001d20| 31 2e 22 25 32 22 20 49 | 53 20 22 25 33 22 00 43 |1."%2" I|S "%3".C|
|00001d30| 4f 4d 4d 45 4e 54 20 4f | 4e 20 43 4f 4c 55 4d 4e |OMMENT O|N COLUMN|
|00001d40| 20 25 31 2e 22 25 32 22 | 20 49 53 20 4e 55 4c 4c | %1."%2"| IS NULL|
|00001d50| 00 4d 4f 44 49 46 59 20 | 22 25 31 22 20 00 43 48 |.MODIFY |"%1" .CH|
|00001d60| 45 43 4b 20 4e 55 4c 4c | 00 4d 4f 44 49 46 59 20 |ECK NULL|.MODIFY |
|00001d70| 22 25 31 22 20 25 32 00 | 4d 4f 44 49 46 59 20 22 |"%1" %2.|MODIFY "|
|00001d80| 25 31 22 20 44 45 46 41 | 55 4c 54 20 25 32 00 4e |%1" DEFA|ULT %2.N|
|00001d90| 55 4c 4c 00 4e 4f 54 20 | 4e 55 4c 4c 00 4d 4f 44 |ULL.NOT |NULL.MOD|
|00001da0| 49 46 59 20 22 25 31 22 | 20 25 32 00 00 2c 20 00 |IFY "%1"| %2.., .|
|00001db0| 00 2c 20 00 27 25 31 27 | 00 00 00 00 43 65 6e 74 |., .'%1'|....Cent|
|00001dc0| 65 72 00 43 65 6e 74 65 | 72 00 43 65 6e 74 65 72 |er.Cente|r.Center|
|00001dd0| 00 53 51 4c 20 43 65 6e | 74 72 61 6c 00 4f 75 74 |.SQL Cen|tral.Out|
|00001de0| 20 6f 66 20 6d 65 6d 6f | 72 79 00 43 65 6e 74 65 | of memo|ry.Cente|
|00001df0| 72 00 43 65 6e 74 65 72 | 00 53 51 4c 20 43 65 6e |r.Center|.SQL Cen|
|00001e00| 74 72 61 6c 00 4f 75 74 | 20 6f 66 20 6d 65 6d 6f |tral.Out| of memo|
|00001e10| 72 79 00 00 42 75 74 74 | 6f 6e 00 00 00 00 00 53 |ry..Butt|on.....S|
|00001e20| 45 4c 45 43 54 20 74 61 | 62 6c 65 5f 6e 61 6d 65 |ELECT ta|ble_name|
|00001e30| 2c 20 28 53 45 4c 45 43 | 54 20 75 73 65 72 5f 6e |, (SELEC|T user_n|
|00001e40| 61 6d 65 20 46 52 4f 4d | 20 53 59 53 55 53 45 52 |ame FROM| SYSUSER|
|00001e50| 50 45 52 4d 53 20 57 48 | 45 52 45 20 75 73 65 72 |PERMS WH|ERE user|
|00001e60| 5f 69 64 20 3d 20 41 2e | 63 72 65 61 74 6f 72 29 |_id = A.|creator)|
|00001e70| 2c 20 28 53 45 4c 45 43 | 54 20 64 62 73 70 61 63 |, (SELEC|T dbspac|
|00001e80| 65 5f 6e 61 6d 65 20 46 | 52 4f 4d 20 53 59 53 46 |e_name F|ROM SYSF|
|00001e90| 49 4c 45 20 57 48 45 52 | 45 20 53 59 53 46 49 4c |ILE WHER|E SYSFIL|
|00001ea0| 45 2e 66 69 6c 65 5f 69 | 64 20 3d 20 41 2e 66 69 |E.file_i|d = A.fi|
|00001eb0| 6c 65 5f 69 64 29 2c 20 | 72 65 6d 61 72 6b 73 2c |le_id), |remarks,|
|00001ec0| 20 28 49 46 20 74 61 62 | 6c 65 5f 74 79 70 65 20 | (IF tab|le_type |
|00001ed0| 3d 20 27 42 41 53 45 27 | 20 54 48 45 4e 20 27 4e |= 'BASE'| THEN 'N|
|00001ee0| 27 20 45 4c 53 45 20 27 | 59 27 20 45 4e 44 49 46 |' ELSE '|Y' ENDIF|
|00001ef0| 29 20 46 52 4f 4d 20 53 | 59 53 54 41 42 4c 45 20 |) FROM S|YSTABLE |
|00001f00| 41 20 57 48 45 52 45 20 | 74 61 62 6c 65 5f 69 64 |A WHERE |table_id|
|00001f10| 20 3d 20 25 31 00 53 45 | 4c 45 43 54 20 74 61 62 | = %1.SE|LECT tab|
|00001f20| 6c 65 5f 69 64 2c 20 72 | 65 6d 61 72 6b 73 2c 20 |le_id, r|emarks, |
|00001f30| 28 53 45 4c 45 43 54 20 | 64 62 73 70 61 63 65 5f |(SELECT |dbspace_|
|00001f40| 6e 61 6d 65 20 46 52 4f | 4d 20 53 59 53 46 49 4c |name FRO|M SYSFIL|
|00001f50| 45 20 57 48 45 52 45 20 | 53 59 53 46 49 4c 45 2e |E WHERE |SYSFILE.|
|00001f60| 66 69 6c 65 5f 69 64 20 | 3d 20 53 59 53 54 41 42 |file_id |= SYSTAB|
|00001f70| 4c 45 2e 66 69 6c 65 5f | 69 64 29 2c 20 28 49 46 |LE.file_|id), (IF|
|00001f80| 20 74 61 62 6c 65 5f 74 | 79 70 65 20 3d 20 27 42 | table_t|ype = 'B|
|00001f90| 41 53 45 27 20 54 48 45 | 4e 20 27 4e 27 20 45 4c |ASE' THE|N 'N' EL|
|00001fa0| 53 45 20 27 59 27 20 45 | 4e 44 49 46 29 2c 20 6c |SE 'Y' E|NDIF), l|
|00001fb0| 61 73 74 5f 70 61 67 65 | 20 46 52 4f 4d 20 53 59 |ast_page| FROM SY|
|00001fc0| 53 54 41 42 4c 45 20 57 | 48 45 52 45 20 74 61 62 |STABLE W|HERE tab|
|00001fd0| 6c 65 5f 6e 61 6d 65 20 | 3d 20 27 25 31 27 20 41 |le_name |= '%1' A|
|00001fe0| 4e 44 20 63 72 65 61 74 | 6f 72 20 3d 20 28 53 45 |ND creat|or = (SE|
|00001ff0| 4c 45 43 54 20 75 73 65 | 72 5f 69 64 20 46 52 4f |LECT use|r_id FRO|
|00002000| 4d 20 53 59 53 55 53 45 | 52 50 45 52 4d 53 20 57 |M SYSUSE|RPERMS W|
|00002010| 48 45 52 45 20 75 73 65 | 72 5f 6e 61 6d 65 20 3d |HERE use|r_name =|
|00002020| 20 27 25 32 27 29 00 53 | 45 4c 45 43 54 20 28 53 | '%2').S|ELECT (S|
|00002030| 45 4c 45 43 54 20 64 62 | 73 70 61 63 65 5f 6e 61 |ELECT db|space_na|
|00002040| 6d 65 20 46 52 4f 4d 20 | 53 59 53 46 49 4c 45 20 |me FROM |SYSFILE |
|00002050| 57 48 45 52 45 20 53 59 | 53 46 49 4c 45 2e 66 69 |WHERE SY|SFILE.fi|
|00002060| 6c 65 5f 69 64 20 3d 20 | 53 59 53 54 41 42 4c 45 |le_id = |SYSTABLE|
|00002070| 2e 66 69 6c 65 5f 69 64 | 29 2c 20 28 49 46 20 74 |.file_id|), (IF t|
|00002080| 61 62 6c 65 5f 74 79 70 | 65 20 3d 20 27 42 41 53 |able_typ|e = 'BAS|
|00002090| 45 27 20 54 48 45 4e 20 | 27 4e 27 20 45 4c 53 45 |E' THEN |'N' ELSE|
|000020a0| 20 27 59 27 20 45 4e 44 | 49 46 29 2c 20 6c 61 73 | 'Y' END|IF), las|
|000020b0| 74 5f 70 61 67 65 20 46 | 52 4f 4d 20 53 59 53 54 |t_page F|ROM SYST|
|000020c0| 41 42 4c 45 20 57 48 45 | 52 45 20 74 61 62 6c 65 |ABLE WHE|RE table|
|000020d0| 5f 69 64 20 3d 20 25 31 | 00 22 25 31 22 2e 22 25 |_id = %1|."%1"."%|
|000020e0| 32 22 00 53 45 4c 45 43 | 54 20 2a 20 46 52 4f 4d |2".SELEC|T * FROM|
|000020f0| 20 25 31 00 53 45 4c 45 | 43 54 20 77 69 64 74 68 | %1.SELE|CT width|
|00002100| 2c 20 28 53 45 4c 45 43 | 54 20 64 6f 6d 61 69 6e |, (SELEC|T domain|
|00002110| 5f 6e 61 6d 65 20 46 52 | 4f 4d 20 53 59 53 44 4f |_name FR|OM SYSDO|
|00002120| 4d 41 49 4e 20 57 48 45 | 52 45 20 61 2e 64 6f 6d |MAIN WHE|RE a.dom|
|00002130| 61 69 6e 5f 69 64 20 3d | 20 64 6f 6d 61 69 6e 5f |ain_id =| domain_|
|00002140| 69 64 29 20 46 52 4f 4d | 20 53 59 53 43 4f 4c 55 |id) FROM| SYSCOLU|
|00002150| 4d 4e 20 61 20 57 48 45 | 52 45 20 74 61 62 6c 65 |MN a WHE|RE table|
|00002160| 5f 69 64 20 3d 20 25 31 | 00 4c 4f 4e 47 20 56 41 |_id = %1|.LONG VA|
|00002170| 52 43 48 41 52 00 4c 4f | 4e 47 20 42 49 4e 41 52 |RCHAR.LO|NG BINAR|
|00002180| 59 00 4e 55 4d 45 52 49 | 43 00 53 45 4c 45 43 54 |Y.NUMERI|C.SELECT|
|00002190| 20 72 6f 6c 65 20 46 52 | 4f 4d 20 53 59 53 46 4f | role FR|OM SYSFO|
|000021a0| 52 45 49 47 4e 4b 45 59 | 20 57 48 45 52 45 20 66 |REIGNKEY| WHERE f|
|000021b0| 6f 72 65 69 67 6e 5f 74 | 61 62 6c 65 5f 69 64 20 |oreign_t|able_id |
|000021c0| 3d 20 25 31 00 53 45 4c | 45 43 54 20 41 2e 69 6e |= %1.SEL|ECT A.in|
|000021d0| 64 65 78 5f 69 64 2c 20 | 28 53 45 4c 45 43 54 20 |dex_id, |(SELECT |
|000021e0| 63 6f 6c 75 6d 6e 5f 6e | 61 6d 65 20 46 52 4f 4d |column_n|ame FROM|
|000021f0| 20 53 59 53 43 4f 4c 55 | 4d 4e 20 57 48 45 52 45 | SYSCOLU|MN WHERE|
|00002200| 20 53 59 53 43 4f 4c 55 | 4d 4e 2e 63 6f 6c 75 6d | SYSCOLU|MN.colum|
|00002210| 6e 5f 69 64 20 3d 20 41 | 2e 63 6f 6c 75 6d 6e 5f |n_id = A|.column_|
|00002220| 69 64 20 41 4e 44 20 74 | 61 62 6c 65 5f 69 64 20 |id AND t|able_id |
|00002230| 3d 20 58 2e 74 61 62 6c | 65 5f 69 64 20 29 20 46 |= X.tabl|e_id ) F|
|00002240| 52 4f 4d 20 53 59 53 49 | 58 43 4f 4c 20 41 20 4a |ROM SYSI|XCOL A J|
|00002250| 4f 49 4e 20 53 59 53 49 | 4e 44 45 58 20 58 20 57 |OIN SYSI|NDEX X W|
|00002260| 48 45 52 45 20 58 2e 74 | 61 62 6c 65 5f 69 64 20 |HERE X.t|able_id |
|00002270| 3d 20 25 31 20 41 4e 44 | 20 41 2e 69 6e 64 65 78 |= %1 AND| A.index|
|00002280| 5f 69 64 20 3d 20 58 2e | 69 6e 64 65 78 5f 69 64 |_id = X.|index_id|
|00002290| 20 41 4e 44 20 22 75 6e | 69 71 75 65 22 20 3d 20 | AND "un|ique" = |
|000022a0| 27 55 27 20 4f 52 44 45 | 52 20 42 59 20 41 2e 69 |'U' ORDE|R BY A.i|
|000022b0| 6e 64 65 78 5f 69 64 2c | 20 41 2e 73 65 71 75 65 |ndex_id,| A.seque|
|000022c0| 6e 63 65 00 43 4f 4d 4d | 45 4e 54 20 4f 4e 20 54 |nce.COMM|ENT ON T|
|000022d0| 41 42 4c 45 20 25 31 20 | 49 53 20 22 25 32 22 00 |ABLE %1 |IS "%2".|
|000022e0| 41 4c 54 45 52 20 54 41 | 42 4c 45 20 25 31 20 52 |ALTER TA|BLE %1 R|
|000022f0| 45 4e 41 4d 45 20 22 25 | 32 22 00 44 52 4f 50 20 |ENAME "%|2".DROP |
|00002300| 54 41 42 4c 45 20 25 31 | 00 43 52 45 41 54 45 20 |TABLE %1|.CREATE |
|00002310| 54 41 42 4c 45 20 22 25 | 31 22 2e 22 25 32 22 20 |TABLE "%|1"."%2" |
|00002320| 28 20 22 5f 5f 64 75 6d | 6d 79 5f 5f 22 20 69 6e |( "__dum|my__" in|
|00002330| 74 65 67 65 72 20 29 20 | 00 49 4e 20 22 25 31 22 |teger ) |.IN "%1"|
|00002340| 00 41 4c 54 45 52 20 54 | 41 42 4c 45 20 22 25 31 |.ALTER T|ABLE "%1|
|00002350| 22 2e 22 25 32 22 20 44 | 45 4c 45 54 45 20 22 5f |"."%2" D|ELETE "_|
|00002360| 5f 64 75 6d 6d 79 5f 5f | 22 00 53 59 53 54 45 4d |_dummy__|".SYSTEM|
|00002370| 00 00 53 45 4c 45 43 54 | 20 63 6f 75 6e 74 20 46 |..SELECT| count F|
|00002380| 52 4f 4d 20 53 59 53 54 | 41 42 4c 45 20 57 48 45 |ROM SYST|ABLE WHE|
|00002390| 52 45 20 74 61 62 6c 65 | 5f 69 64 20 3d 20 25 31 |RE table|_id = %1|
|000023a0| 00 4e 00 47 00 47 52 41 | 4e 54 20 25 31 20 4f 4e |.N.G.GRA|NT %1 ON|
|000023b0| 20 25 32 20 54 4f 20 25 | 33 00 22 00 2c 00 20 57 | %2 TO %|3.".,. W|
|000023c0| 49 54 48 20 47 52 41 4e | 54 20 4f 50 54 49 4f 4e |ITH GRAN|T OPTION|
|000023d0| 00 52 45 56 4f 4b 45 20 | 25 31 20 4f 4e 20 25 32 |.REVOKE |%1 ON %2|
|000023e0| 20 46 52 4f 4d 20 25 33 | 00 41 4c 4c 00 22 00 2c | FROM %3|.ALL.".,|
|000023f0| 00 43 52 45 41 54 45 20 | 54 41 42 4c 45 20 22 25 |.CREATE |TABLE "%|
|00002400| 31 22 2e 22 25 32 22 20 | 28 00 2c 0d 0a 00 29 00 |1"."%2" |(.,...).|
|00002410| 41 4c 54 45 52 20 54 41 | 42 4c 45 20 25 31 20 44 |ALTER TA|BLE %1 D|
|00002420| 45 4c 45 54 45 20 50 52 | 49 4d 41 52 59 20 4b 45 |ELETE PR|IMARY KE|
|00002430| 59 00 41 4c 54 45 52 20 | 54 41 42 4c 45 20 25 31 |Y.ALTER |TABLE %1|
|00002440| 20 41 44 44 20 50 52 49 | 4d 41 52 59 20 4b 45 59 | ADD PRI|MARY KEY|
|00002450| 20 28 20 25 32 20 29 00 | 53 45 4c 45 43 54 20 76 | ( %2 ).|SELECT v|
|00002460| 69 65 77 5f 64 65 66 20 | 46 52 4f 4d 20 53 59 53 |iew_def |FROM SYS|
|00002470| 54 41 42 4c 45 20 57 48 | 45 52 45 20 74 61 62 6c |TABLE WH|ERE tabl|
|00002480| 65 5f 69 64 20 3d 20 25 | 31 00 41 4c 54 45 52 20 |e_id = %|1.ALTER |
|00002490| 54 41 42 4c 45 20 25 31 | 20 44 45 4c 45 54 45 20 |TABLE %1| DELETE |
|000024a0| 43 48 45 43 4b 00 41 4c | 54 45 52 20 54 41 42 4c |CHECK.AL|TER TABL|
|000024b0| 45 20 25 31 20 41 44 44 | 20 25 32 00 20 41 4c 54 |E %1 ADD| %2. ALT|
|000024c0| 45 52 20 54 41 42 4c 45 | 20 25 31 20 41 44 44 20 |ER TABLE| %1 ADD |
|000024d0| 25 32 20 46 4f 52 45 49 | 47 4e 20 4b 45 59 20 22 |%2 FOREI|GN KEY "|
|000024e0| 25 33 22 20 25 34 20 52 | 45 46 45 52 45 4e 43 45 |%3" %4 R|EFERENCE|
|000024f0| 53 20 25 35 20 25 36 20 | 25 37 20 25 38 20 00 4f |S %5 %6 |%7 %8 .O|
|00002500| 4e 20 55 50 44 41 54 45 | 20 25 31 00 4f 4e 20 44 |N UPDATE| %1.ON D|
|00002510| 45 4c 45 54 45 20 25 31 | 00 52 45 53 54 52 49 43 |ELETE %1|.RESTRIC|
|00002520| 54 00 43 41 53 43 41 44 | 45 00 53 45 54 20 4e 55 |T.CASCAD|E.SET NU|
|00002530| 4c 4c 00 53 45 54 20 44 | 45 46 41 55 4c 54 00 4e |LL.SET D|EFAULT.N|
|00002540| 4f 54 20 4e 55 4c 4c 00 | 43 48 45 43 4b 20 4f 4e |OT NULL.|CHECK ON|
|00002550| 20 43 4f 4d 4d 49 54 00 | 43 4f 4d 4d 45 4e 54 20 | COMMIT.|COMMENT |
|00002560| 4f 4e 20 46 4f 52 45 49 | 47 4e 20 4b 45 59 20 25 |ON FOREI|GN KEY %|
|00002570| 31 2e 22 25 32 22 20 49 | 53 20 22 25 33 22 00 00 |1."%2" I|S "%3"..|
|00002580| 41 4c 54 45 52 20 54 41 | 42 4c 45 20 25 31 20 41 |ALTER TA|BLE %1 A|
|00002590| 44 44 20 25 32 20 00 41 | 4c 54 45 52 20 54 41 42 |DD %2 .A|LTER TAB|
|000025a0| 4c 45 20 25 31 20 52 45 | 4e 41 4d 45 20 22 25 32 |LE %1 RE|NAME "%2|
|000025b0| 22 20 54 4f 20 22 25 33 | 22 00 41 4c 54 45 52 20 |" TO "%3|".ALTER |
|000025c0| 54 41 42 4c 45 20 25 31 | 20 41 44 44 20 55 4e 49 |TABLE %1| ADD UNI|
|000025d0| 51 55 45 28 20 22 25 32 | 22 20 29 00 41 4c 54 45 |QUE( "%2|" ).ALTE|
|000025e0| 52 20 54 41 42 4c 45 20 | 25 31 20 44 45 4c 45 54 |R TABLE |%1 DELET|
|000025f0| 45 20 55 4e 49 51 55 45 | 28 20 22 25 32 22 20 29 |E UNIQUE|( "%2" )|
|00002600| 00 41 4c 54 45 52 20 54 | 41 42 4c 45 20 25 31 20 |.ALTER T|ABLE %1 |
|00002610| 25 32 00 41 4c 54 45 52 | 20 54 41 42 4c 45 20 25 |%2.ALTER| TABLE %|
|00002620| 31 20 25 32 00 53 45 4c | 45 43 54 20 63 6f 75 6e |1 %2.SEL|ECT coun|
|00002630| 74 28 2a 29 20 46 52 4f | 4d 20 53 59 53 54 41 42 |t(*) FRO|M SYSTAB|
|00002640| 4c 45 20 4a 4f 49 4e 20 | 53 59 53 55 53 45 52 50 |LE JOIN |SYSUSERP|
|00002650| 45 52 4d 53 20 4f 4e 20 | 63 72 65 61 74 6f 72 20 |ERMS ON |creator |
|00002660| 3d 20 75 73 65 72 5f 69 | 64 20 57 48 45 52 45 20 |= user_i|d WHERE |
|00002670| 74 61 62 6c 65 5f 6e 61 | 6d 65 20 3d 20 27 25 31 |table_na|me = '%1|
|00002680| 27 20 41 4e 44 20 75 73 | 65 72 5f 6e 61 6d 65 20 |' AND us|er_name |
|00002690| 3d 20 27 25 32 27 00 43 | 52 45 41 54 45 20 54 41 |= '%2'.C|REATE TA|
|000026a0| 42 4c 45 20 25 31 20 28 | 20 22 5f 5f 64 75 6d 6d |BLE %1 (| "__dumm|
|000026b0| 79 5f 5f 22 20 69 6e 74 | 65 67 65 72 20 29 20 00 |y__" int|eger ) .|
|000026c0| 49 4e 20 22 25 31 22 00 | 41 4c 54 45 52 20 54 41 |IN "%1".|ALTER TA|
|000026d0| 42 4c 45 20 25 31 20 44 | 45 4c 45 54 45 20 22 5f |BLE %1 D|ELETE "_|
|000026e0| 5f 64 75 6d 6d 79 5f 5f | 22 00 22 25 31 22 2e 22 |_dummy__|"."%1"."|
|000026f0| 25 32 22 00 53 59 53 54 | 45 4d 00 00 43 52 45 41 |%2".SYST|EM..CREA|
|00002700| 54 45 20 47 4c 4f 42 41 | 4c 20 54 45 4d 50 4f 52 |TE GLOBA|L TEMPOR|
|00002710| 41 52 59 20 54 41 42 4c | 45 20 25 31 20 28 20 22 |ARY TABL|E %1 ( "|
|00002720| 5f 5f 64 75 6d 6d 79 5f | 5f 22 20 69 6e 74 65 67 |__dummy_|_" integ|
|00002730| 65 72 20 29 20 00 4f 4e | 20 43 4f 4d 4d 49 54 20 |er ) .ON| COMMIT |
|00002740| 44 45 4c 45 54 45 20 52 | 4f 57 53 00 4f 4e 20 43 |DELETE R|OWS.ON C|
|00002750| 4f 4d 4d 49 54 20 50 52 | 45 53 45 52 56 45 20 52 |OMMIT PR|ESERVE R|
|00002760| 4f 57 53 00 41 4c 54 45 | 52 20 54 41 42 4c 45 20 |OWS.ALTE|R TABLE |
|00002770| 25 31 20 44 45 4c 45 54 | 45 20 22 5f 5f 64 75 6d |%1 DELET|E "__dum|
|00002780| 6d 79 5f 5f 22 00 22 25 | 31 22 2e 22 25 32 22 00 |my__"."%|1"."%2".|
|00002790| 00 43 4f 4d 4d 45 4e 54 | 20 4f 4e 20 54 41 42 4c |.COMMENT| ON TABL|
|000027a0| 45 20 25 31 20 49 53 20 | 22 25 32 22 00 53 45 4c |E %1 IS |"%2".SEL|
|000027b0| 45 43 54 20 74 61 62 6c | 65 5f 6e 61 6d 65 2c 20 |ECT tabl|e_name, |
|000027c0| 75 73 65 72 5f 6e 61 6d | 65 2c 20 53 59 53 54 41 |user_nam|e, SYSTA|
|000027d0| 42 4c 45 2e 72 65 6d 61 | 72 6b 73 2c 20 74 61 62 |BLE.rema|rks, tab|
|000027e0| 6c 65 5f 69 64 2c 20 28 | 49 46 20 74 61 62 6c 65 |le_id, (|IF table|
|000027f0| 5f 74 79 70 65 20 3d 20 | 27 42 41 53 45 27 20 54 |_type = |'BASE' T|
|00002800| 48 45 4e 20 27 4e 27 20 | 45 4c 53 45 20 27 59 27 |HEN 'N' |ELSE 'Y'|
|00002810| 20 45 4e 44 49 46 29 20 | 46 52 4f 4d 20 53 59 53 | ENDIF) |FROM SYS|
|00002820| 54 41 42 4c 45 20 4a 4f | 49 4e 20 53 59 53 55 53 |TABLE JO|IN SYSUS|
|00002830| 45 52 50 45 52 4d 53 20 | 57 48 45 52 45 20 28 74 |ERPERMS |WHERE (t|
|00002840| 61 62 6c 65 5f 74 79 70 | 65 20 3d 20 27 42 41 53 |able_typ|e = 'BAS|
|00002850| 45 27 20 4f 52 20 74 61 | 62 6c 65 5f 74 79 70 65 |E' OR ta|ble_type|
|00002860| 20 3d 20 27 47 42 4c 20 | 54 45 4d 50 27 29 20 41 | = 'GBL |TEMP') A|
|00002870| 4e 44 20 63 72 65 61 74 | 6f 72 20 4e 4f 54 20 49 |ND creat|or NOT I|
|00002880| 4e 20 28 53 45 4c 45 43 | 54 20 63 72 65 61 74 6f |N (SELEC|T creato|
|00002890| 72 20 46 52 4f 4d 20 64 | 62 78 5f 66 69 6c 74 65 |r FROM d|bx_filte|
|000028a0| 72 5f 6c 69 73 74 29 20 | 4f 52 44 45 52 20 42 59 |r_list) |ORDER BY|
|000028b0| 20 74 61 62 6c 65 5f 6e | 61 6d 65 00 53 45 4c 45 | table_n|ame.SELE|
|000028c0| 43 54 20 75 73 65 72 5f | 6e 61 6d 65 2c 20 75 73 |CT user_|name, us|
|000028d0| 65 72 5f 67 72 6f 75 70 | 2c 20 73 65 6c 65 63 74 |er_group|, select|
|000028e0| 61 75 74 68 2c 20 69 6e | 73 65 72 74 61 75 74 68 |auth, in|sertauth|
|000028f0| 2c 20 64 65 6c 65 74 65 | 61 75 74 68 2c 20 75 70 |, delete|auth, up|
|00002900| 64 61 74 65 61 75 74 68 | 2c 20 61 6c 74 65 72 61 |dateauth|, altera|
|00002910| 75 74 68 2c 20 72 65 66 | 65 72 65 6e 63 65 61 75 |uth, ref|erenceau|
|00002920| 74 68 2c 20 28 20 73 65 | 6c 65 63 74 20 73 75 6d |th, ( se|lect sum|
|00002930| 28 20 64 69 73 74 69 6e | 63 74 20 70 72 69 76 69 |( distin|ct privi|
|00002940| 6c 65 67 65 5f 74 79 70 | 65 20 29 20 66 72 6f 6d |lege_typ|e ) from|
|00002950| 20 53 59 53 43 4f 4c 50 | 45 52 4d 20 77 68 65 72 | SYSCOLP|ERM wher|
|00002960| 65 20 53 59 53 43 4f 4c | 50 45 52 4d 2e 74 61 62 |e SYSCOL|PERM.tab|
|00002970| 6c 65 5f 69 64 20 3d 20 | 53 59 53 54 41 42 4c 45 |le_id = |SYSTABLE|
|00002980| 50 45 52 4d 2e 74 74 61 | 62 6c 65 5f 69 64 20 61 |PERM.tta|ble_id a|
|00002990| 6e 64 20 75 73 65 72 5f | 69 64 20 3d 20 67 72 61 |nd user_|id = gra|
|000029a0| 6e 74 65 65 20 29 20 46 | 52 4f 4d 20 53 59 53 54 |ntee ) F|ROM SYST|
|000029b0| 41 42 4c 45 50 45 52 4d | 20 4a 4f 49 4e 20 53 59 |ABLEPERM| JOIN SY|
|000029c0| 53 55 53 45 52 50 45 52 | 4d 53 20 67 72 61 6e 74 |SUSERPER|MS grant|
|000029d0| 65 65 20 57 48 45 52 45 | 20 75 73 65 72 5f 69 64 |ee WHERE| user_id|
|000029e0| 20 3d 20 67 72 61 6e 74 | 65 65 20 41 4e 44 20 74 | = grant|ee AND t|
|000029f0| 74 61 62 6c 65 5f 69 64 | 20 3d 20 25 31 20 4f 52 |table_id| = %1 OR|
|00002a00| 44 45 52 20 42 59 20 75 | 73 65 72 5f 67 72 6f 75 |DER BY u|ser_grou|
|00002a10| 70 20 64 65 73 63 2c 20 | 67 72 61 6e 74 65 65 00 |p desc, |grantee.|
|00002a20| 53 45 4c 45 43 54 20 75 | 73 65 72 5f 6e 61 6d 65 |SELECT u|ser_name|
|00002a30| 2c 20 75 73 65 72 5f 67 | 72 6f 75 70 2c 20 73 65 |, user_g|roup, se|
|00002a40| 6c 65 63 74 61 75 74 68 | 2c 20 69 6e 73 65 72 74 |lectauth|, insert|
|00002a50| 61 75 74 68 2c 20 64 65 | 6c 65 74 65 61 75 74 68 |auth, de|leteauth|
|00002a60| 2c 20 75 70 64 61 74 65 | 61 75 74 68 2c 20 61 6c |, update|auth, al|
|00002a70| 74 65 72 61 75 74 68 2c | 20 72 65 66 65 72 65 6e |terauth,| referen|
|00002a80| 63 65 61 75 74 68 2c 20 | 28 20 69 66 20 75 70 64 |ceauth, |( if upd|
|00002a90| 61 74 65 63 6f 6c 73 20 | 3d 20 27 59 27 20 74 68 |atecols |= 'Y' th|
|00002aa0| 65 6e 20 38 20 65 6c 73 | 65 20 30 20 65 6e 64 69 |en 8 els|e 0 endi|
|00002ab0| 66 20 29 20 46 52 4f 4d | 20 53 59 53 54 41 42 4c |f ) FROM| SYSTABL|
|00002ac0| 45 50 45 52 4d 20 4a 4f | 49 4e 20 53 59 53 55 53 |EPERM JO|IN SYSUS|
|00002ad0| 45 52 50 45 52 4d 53 20 | 67 72 61 6e 74 65 65 20 |ERPERMS |grantee |
|00002ae0| 57 48 45 52 45 20 75 73 | 65 72 5f 69 64 20 3d 20 |WHERE us|er_id = |
|00002af0| 67 72 61 6e 74 65 65 20 | 41 4e 44 20 74 74 61 62 |grantee |AND ttab|
|00002b00| 6c 65 5f 69 64 20 3d 20 | 25 31 20 4f 52 44 45 52 |le_id = |%1 ORDER|
|00002b10| 20 42 59 20 75 73 65 72 | 5f 67 72 6f 75 70 20 64 | BY user|_group d|
|00002b20| 65 73 63 2c 20 67 72 61 | 6e 74 65 65 00 44 52 4f |esc, gra|ntee.DRO|
|00002b30| 50 20 54 41 42 4c 45 20 | 22 25 31 22 2e 22 25 32 |P TABLE |"%1"."%2|
|00002b40| 22 00 00 00 00 00 00 00 | 25 73 25 73 00 25 73 25 |".......|%s%s.%s%|
|00002b50| 73 00 66 6f 6f 00 77 65 | 64 69 74 00 45 64 69 74 |s.foo.we|dit.Edit|
|00002b60| 00 73 63 6c 61 6e 67 25 | 73 2e 64 6c 6c 00 43 6f |.sclang%|s.dll.Co|
|00002b70| 75 6c 64 20 6e 6f 74 20 | 6c 6f 61 64 20 6c 61 6e |uld not |load lan|
|00002b80| 67 75 61 67 65 20 44 4c | 4c 20 27 25 73 27 2e 00 |guage DL|L '%s'..|
|00002b90| 53 51 4c 20 43 65 6e 74 | 72 61 6c 00 00 53 79 73 |SQL Cent|ral..Sys|
|00002ba0| 4c 69 73 74 56 69 65 77 | 33 32 00 73 63 73 61 25 |ListView|32.scsa%|
|00002bb0| 31 2e 68 6c 70 00 73 63 | 73 61 2e 68 6c 70 00 44 |1.hlp.sc|sa.hlp.D|
|00002bc0| 62 78 4d 6f 64 65 6c 65 | 73 73 50 72 6f 70 00 00 |bxModele|ssProp..|
|00002bd0| 53 4d 41 4c 4c 49 4e 54 | 00 49 4e 54 45 47 45 52 |SMALLINT|.INTEGER|
|00002be0| 00 46 4c 4f 41 54 00 44 | 4f 55 42 4c 45 00 4e 55 |.FLOAT.D|OUBLE.NU|
|00002bf0| 4d 45 52 49 43 00 44 41 | 54 45 00 54 49 4d 45 00 |MERIC.DA|TE.TIME.|
|00002c00| 54 49 4d 45 53 54 41 4d | 50 00 43 48 41 52 00 56 |TIMESTAM|P.CHAR.V|
|00002c10| 41 52 43 48 41 52 00 4c | 4f 4e 47 20 56 41 52 43 |ARCHAR.L|ONG VARC|
|00002c20| 48 41 52 00 4c 4f 4e 47 | 20 42 49 4e 41 52 59 00 |HAR.LONG| BINARY.|
|00002c30| 54 49 4e 59 49 4e 54 00 | 6e 75 6c 6c 00 61 75 74 |TINYINT.|null.aut|
|00002c40| 6f 69 6e 63 72 65 6d 65 | 6e 74 00 63 75 72 72 65 |oincreme|nt.curre|
|00002c50| 6e 74 20 74 69 6d 65 00 | 63 75 72 72 65 6e 74 20 |nt time.|current |
|00002c60| 74 69 6d 65 73 74 61 6d | 70 00 63 75 72 72 65 6e |timestam|p.curren|
|00002c70| 74 20 64 61 74 65 00 25 | 31 28 20 25 32 20 29 00 |t date.%|1( %2 ).|
|00002c80| 25 31 28 20 25 32 2c 20 | 25 33 20 29 00 63 75 72 |%1( %2, |%3 ).cur|
|00002c90| 72 65 6e 74 20 64 61 74 | 65 00 63 75 72 72 65 6e |rent dat|e.curren|
|00002ca0| 74 20 74 69 6d 65 00 63 | 75 72 72 65 6e 74 20 74 |t time.c|urrent t|
|00002cb0| 69 6d 65 73 74 61 6d 70 | 00 63 75 72 72 65 6e 74 |imestamp|.current|
|00002cc0| 20 75 73 65 72 00 63 75 | 72 72 65 6e 74 20 64 61 | user.cu|rrent da|
|00002cd0| 74 61 62 61 73 65 00 63 | 75 72 72 65 6e 74 20 70 |tabase.c|urrent p|
|00002ce0| 75 62 6c 69 73 68 65 72 | 00 63 75 72 72 65 6e 74 |ublisher|.current|
|00002cf0| 20 64 61 74 65 00 63 75 | 72 72 65 6e 74 20 74 69 | date.cu|rrent ti|
|00002d00| 6d 65 00 63 75 72 72 65 | 6e 74 20 74 69 6d 65 73 |me.curre|nt times|
|00002d10| 74 61 6d 70 00 61 75 74 | 6f 69 6e 63 72 65 6d 65 |tamp.aut|oincreme|
|00002d20| 6e 74 00 49 4e 53 45 52 | 54 20 49 4e 54 4f 20 64 |nt.INSER|T INTO d|
|00002d30| 62 78 5f 64 6f 6d 61 69 | 6e 73 5f 74 65 6d 70 20 |bx_domai|ns_temp |
|00002d40| 53 45 4c 45 43 54 20 44 | 49 53 54 49 4e 43 54 20 |SELECT D|ISTINCT |
|00002d50| 64 6f 6d 61 69 6e 5f 6e | 61 6d 65 2c 20 4e 55 4c |domain_n|ame, NUL|
|00002d60| 4c 2c 20 64 6f 6d 61 69 | 6e 5f 6e 61 6d 65 20 46 |L, domai|n_name F|
|00002d70| 52 4f 4d 20 53 59 53 44 | 4f 4d 41 49 4e 20 00 53 |ROM SYSD|OMAIN .S|
|00002d80| 45 4c 45 43 54 20 64 6f | 6d 61 69 6e 2c 20 75 73 |ELECT do|main, us|
|00002d90| 65 72 5f 6e 61 6d 65 20 | 46 52 4f 4d 20 64 62 78 |er_name |FROM dbx|
|00002da0| 5f 64 6f 6d 61 69 6e 73 | 5f 74 65 6d 70 20 4f 52 |_domains|_temp OR|
|00002db0| 44 45 52 20 42 59 20 6e | 61 6d 65 00 53 45 4c 45 |DER BY n|ame.SELE|
|00002dc0| 43 54 20 63 6f 75 6e 74 | 28 44 49 53 54 49 4e 43 |CT count|(DISTINC|
|00002dd0| 54 20 64 6f 6d 61 69 6e | 5f 6e 61 6d 65 29 20 46 |T domain|_name) F|
|00002de0| 52 4f 4d 20 53 59 53 44 | 4f 4d 41 49 4e 00 53 45 |ROM SYSD|OMAIN.SE|
|00002df0| 4c 45 43 54 20 73 65 74 | 74 69 6e 67 20 46 52 4f |LECT set|ting FRO|
|00002e00| 4d 20 53 59 53 4f 50 54 | 49 4f 4e 20 57 48 45 52 |M SYSOPT|ION WHER|
|00002e10| 45 20 22 6f 70 74 69 6f | 6e 22 20 3d 20 27 44 61 |E "optio|n" = 'Da|
|00002e20| 74 65 5f 66 6f 72 6d 61 | 74 27 20 41 4e 44 20 75 |te_forma|t' AND u|
|00002e30| 73 65 72 5f 69 64 20 3d | 20 28 53 45 4c 45 43 54 |ser_id =| (SELECT|
|00002e40| 20 75 73 65 72 5f 69 64 | 20 46 52 4f 4d 20 53 59 | user_id| FROM SY|
|00002e50| 53 55 53 45 52 50 45 52 | 4d 53 20 57 48 45 52 45 |SUSERPER|MS WHERE|
|00002e60| 20 75 73 65 72 5f 6e 61 | 6d 65 20 3d 20 27 50 55 | user_na|me = 'PU|
|00002e70| 42 4c 49 43 27 29 00 53 | 45 4c 45 43 54 20 73 65 |BLIC').S|ELECT se|
|00002e80| 74 74 69 6e 67 20 46 52 | 4f 4d 20 53 59 53 4f 50 |tting FR|OM SYSOP|
|00002e90| 54 49 4f 4e 20 57 48 45 | 52 45 20 22 6f 70 74 69 |TION WHE|RE "opti|
|00002ea0| 6f 6e 22 20 3d 20 27 54 | 69 6d 65 5f 66 6f 72 6d |on" = 'T|ime_form|
|00002eb0| 61 74 27 20 41 4e 44 20 | 75 73 65 72 5f 69 64 20 |at' AND |user_id |
|00002ec0| 3d 20 28 53 45 4c 45 43 | 54 20 75 73 65 72 5f 69 |= (SELEC|T user_i|
|00002ed0| 64 20 46 52 4f 4d 20 53 | 59 53 55 53 45 52 50 45 |d FROM S|YSUSERPE|
|00002ee0| 52 4d 53 20 57 48 45 52 | 45 20 75 73 65 72 5f 6e |RMS WHER|E user_n|
|00002ef0| 61 6d 65 20 3d 20 27 50 | 55 42 4c 49 43 27 29 00 |ame = 'P|UBLIC').|
|00002f00| 53 45 4c 45 43 54 20 73 | 65 74 74 69 6e 67 20 46 |SELECT s|etting F|
|00002f10| 52 4f 4d 20 53 59 53 4f | 50 54 49 4f 4e 20 57 48 |ROM SYSO|PTION WH|
|00002f20| 45 52 45 20 22 6f 70 74 | 69 6f 6e 22 20 3d 20 27 |ERE "opt|ion" = '|
|00002f30| 54 69 6d 65 73 74 61 6d | 70 5f 66 6f 72 6d 61 74 |Timestam|p_format|
|00002f40| 27 20 41 4e 44 20 75 73 | 65 72 5f 69 64 20 3d 20 |' AND us|er_id = |
|00002f50| 28 53 45 4c 45 43 54 20 | 75 73 65 72 5f 69 64 20 |(SELECT |user_id |
|00002f60| 46 52 4f 4d 20 53 59 53 | 55 53 45 52 50 45 52 4d |FROM SYS|USERPERM|
|00002f70| 53 20 57 48 45 52 45 20 | 75 73 65 72 5f 6e 61 6d |S WHERE |user_nam|
|00002f80| 65 20 3d 20 27 50 55 42 | 4c 49 43 27 29 00 00 00 |e = 'PUB|LIC')...|
|00002f90| 49 4e 54 45 47 45 52 00 | 53 45 4c 45 43 54 20 77 |INTEGER.|SELECT w|
|00002fa0| 69 64 74 68 2c 20 73 63 | 61 6c 65 2c 20 74 79 70 |idth, sc|ale, typ|
|00002fb0| 65 5f 69 64 2c 20 6e 75 | 6c 6c 73 2c 20 22 64 65 |e_id, nu|lls, "de|
|00002fc0| 66 61 75 6c 74 22 2c 20 | 22 63 68 65 63 6b 22 2c |fault", |"check",|
|00002fd0| 20 28 53 45 4c 45 43 54 | 20 75 73 65 72 5f 6e 61 | (SELECT| user_na|
|00002fe0| 6d 65 20 46 52 4f 4d 20 | 53 59 53 55 53 45 52 50 |me FROM |SYSUSERP|
|00002ff0| 45 52 4d 53 20 57 48 45 | 52 45 20 75 73 65 72 5f |ERMS WHE|RE user_|
|00003000| 69 64 20 3d 20 63 72 65 | 61 74 6f 72 29 20 46 52 |id = cre|ator) FR|
|00003010| 4f 4d 20 53 59 53 55 53 | 45 52 54 59 50 45 20 57 |OM SYSUS|ERTYPE W|
|00003020| 48 45 52 45 20 74 79 70 | 65 5f 6e 61 6d 65 20 3d |HERE typ|e_name =|
|00003030| 20 27 25 31 27 00 00 00 | 53 45 4c 45 43 54 20 74 | '%1'...|SELECT t|
|00003040| 79 70 65 5f 6e 61 6d 65 | 2c 20 28 53 45 4c 45 43 |ype_name|, (SELEC|
|00003050| 54 20 64 6f 6d 61 69 6e | 5f 6e 61 6d 65 20 46 52 |T domain|_name FR|
|00003060| 4f 4d 20 53 59 53 44 4f | 4d 41 49 4e 20 42 20 57 |OM SYSDO|MAIN B W|
|00003070| 48 45 52 45 20 41 2e 64 | 6f 6d 61 69 6e 5f 69 64 |HERE A.d|omain_id|
|00003080| 20 3d 20 42 2e 64 6f 6d | 61 69 6e 5f 69 64 29 2c | = B.dom|ain_id),|
|00003090| 20 77 69 64 74 68 2c 20 | 73 63 61 6c 65 20 46 52 | width, |scale FR|
|000030a0| 4f 4d 20 53 59 53 55 53 | 45 52 54 59 50 45 20 41 |OM SYSUS|ERTYPE A|
|000030b0| 20 57 48 45 52 45 20 63 | 72 65 61 74 6f 72 20 4e | WHERE c|reator N|
|000030c0| 4f 54 20 49 4e 20 28 53 | 45 4c 45 43 54 20 63 72 |OT IN (S|ELECT cr|
|000030d0| 65 61 74 6f 72 20 46 52 | 4f 4d 20 64 62 78 5f 66 |eator FR|OM dbx_f|
|000030e0| 69 6c 74 65 72 5f 6c 69 | 73 74 29 00 43 52 45 41 |ilter_li|st).CREA|
|000030f0| 54 45 20 44 4f 4d 41 49 | 4e 20 22 25 31 22 20 25 |TE DOMAI|N "%1" %|
|00003100| 32 20 00 4e 55 4c 4c 20 | 00 4e 4f 54 20 4e 55 4c |2 .NULL |.NOT NUL|
|00003110| 4c 20 00 44 45 46 41 55 | 4c 54 20 27 25 31 27 20 |L .DEFAU|LT '%1' |
|00003120| 00 44 45 46 41 55 4c 54 | 20 25 31 20 00 53 45 4c |.DEFAULT| %1 .SEL|
|00003130| 45 43 54 20 74 79 70 65 | 5f 6e 61 6d 65 20 46 52 |ECT type|_name FR|
|00003140| 4f 4d 20 53 59 53 55 53 | 45 52 54 59 50 45 20 57 |OM SYSUS|ERTYPE W|
|00003150| 48 45 52 45 20 74 79 70 | 65 5f 6e 61 6d 65 20 3d |HERE typ|e_name =|
|00003160| 20 27 25 31 27 00 44 52 | 4f 50 20 44 4f 4d 41 49 | '%1'.DR|OP DOMAI|
|00003170| 4e 20 22 25 31 22 00 53 | 45 4c 45 43 54 20 44 49 |N "%1".S|ELECT DI|
|00003180| 53 54 49 4e 43 54 20 64 | 6f 6d 61 69 6e 5f 6e 61 |STINCT d|omain_na|
|00003190| 6d 65 2c 20 4e 55 4c 4c | 20 46 52 4f 4d 20 53 59 |me, NULL| FROM SY|
|000031a0| 53 44 4f 4d 41 49 4e 20 | 00 53 45 4c 45 43 54 20 |SDOMAIN |.SELECT |
|000031b0| 64 6f 6d 61 69 6e 2c 20 | 75 73 65 72 5f 6e 61 6d |domain, |user_nam|
|000031c0| 65 20 46 52 4f 4d 20 64 | 62 78 5f 64 6f 6d 61 69 |e FROM d|bx_domai|
|000031d0| 6e 73 5f 74 65 6d 70 20 | 4f 52 44 45 52 20 42 59 |ns_temp |ORDER BY|
|000031e0| 20 6e 61 6d 65 00 49 4e | 53 45 52 54 20 49 4e 54 | name.IN|SERT INT|
|000031f0| 4f 20 64 62 78 5f 64 6f | 6d 61 69 6e 73 5f 74 65 |O dbx_do|mains_te|
|00003200| 6d 70 20 53 45 4c 45 43 | 54 20 44 49 53 54 49 4e |mp SELEC|T DISTIN|
|00003210| 43 54 20 64 6f 6d 61 69 | 6e 5f 6e 61 6d 65 2c 20 |CT domai|n_name, |
|00003220| 4e 55 4c 4c 2c 20 64 6f | 6d 61 69 6e 5f 6e 61 6d |NULL, do|main_nam|
|00003230| 65 20 46 52 4f 4d 20 53 | 59 53 44 4f 4d 41 49 4e |e FROM S|YSDOMAIN|
|00003240| 20 55 4e 49 4f 4e 20 41 | 4c 4c 20 53 45 4c 45 43 | UNION A|LL SELEC|
|00003250| 54 20 28 53 45 4c 45 43 | 54 20 64 6f 6d 61 69 6e |T (SELEC|T domain|
|00003260| 5f 6e 61 6d 65 20 46 52 | 4f 4d 20 53 59 53 44 4f |_name FR|OM SYSDO|
|00003270| 4d 41 49 4e 20 57 48 45 | 52 45 20 64 6f 6d 61 69 |MAIN WHE|RE domai|
|00003280| 6e 5f 69 64 20 3d 20 58 | 2e 64 6f 6d 61 69 6e 5f |n_id = X|.domain_|
|00003290| 69 64 29 2c 20 74 79 70 | 65 5f 6e 61 6d 65 2c 20 |id), typ|e_name, |
|000032a0| 74 79 70 65 5f 6e 61 6d | 65 20 46 52 4f 4d 20 53 |type_nam|e FROM S|
|000032b0| 59 53 55 53 45 52 54 59 | 50 45 20 58 20 00 53 45 |YSUSERTY|PE X .SE|
|000032c0| 4c 45 43 54 20 63 6f 75 | 6e 74 28 44 49 53 54 49 |LECT cou|nt(DISTI|
|000032d0| 4e 43 54 20 64 6f 6d 61 | 69 6e 5f 6e 61 6d 65 29 |NCT doma|in_name)|
|000032e0| 20 2b 20 31 20 46 52 4f | 4d 20 53 59 53 44 4f 4d | + 1 FRO|M SYSDOM|
|000032f0| 41 49 4e 00 53 45 4c 45 | 43 54 20 63 6f 75 6e 74 |AIN.SELE|CT count|
|00003300| 28 2a 29 20 46 52 4f 4d | 20 53 59 53 55 53 45 52 |(*) FROM| SYSUSER|
|00003310| 54 59 50 45 00 44 45 43 | 4c 41 52 45 20 4c 4f 43 |TYPE.DEC|LARE LOC|
|00003320| 41 4c 20 54 45 4d 50 4f | 52 41 52 59 20 54 41 42 |AL TEMPO|RARY TAB|
|00003330| 4c 45 20 64 62 78 5f 64 | 6f 6d 61 69 6e 73 5f 74 |LE dbx_d|omains_t|
|00003340| 65 6d 70 28 20 64 6f 6d | 61 69 6e 20 63 68 61 72 |emp( dom|ain char|
|00003350| 28 35 30 29 2c 20 75 73 | 65 72 5f 6e 61 6d 65 20 |(50), us|er_name |
|00003360| 63 68 61 72 28 35 30 29 | 2c 20 6e 61 6d 65 20 63 |char(50)|, name c|
|00003370| 68 61 72 28 35 30 29 20 | 29 20 4f 4e 20 43 4f 4d |har(50) |) ON COM|
|00003380| 4d 49 54 20 50 52 45 53 | 45 52 56 45 20 52 4f 57 |MIT PRES|ERVE ROW|
|00003390| 53 00 44 52 4f 50 20 54 | 41 42 4c 45 20 64 62 78 |S.DROP T|ABLE dbx|
|000033a0| 5f 64 6f 6d 61 69 6e 73 | 5f 74 65 6d 70 00 00 00 |_domains|_temp...|
|000033b0| 00 00 59 00 00 00 00 00 | 22 00 2c 00 25 31 28 25 |..Y.....|".,.%1(%|
|000033c0| 32 29 00 00 2c 00 73 65 | 6c 65 63 74 20 63 6f 6c |2)..,.se|lect col|
|000033d0| 75 6d 6e 5f 6e 61 6d 65 | 2c 20 28 69 66 20 63 6f |umn_name|, (if co|
|000033e0| 6c 75 6d 6e 5f 69 64 20 | 69 6e 28 20 73 65 6c 65 |lumn_id |in( sele|
|000033f0| 63 74 20 63 6f 6c 75 6d | 6e 5f 69 64 20 66 72 6f |ct colum|n_id fro|
|00003400| 6d 20 53 59 53 43 4f 4c | 50 45 52 4d 20 77 68 65 |m SYSCOL|PERM whe|
|00003410| 72 65 20 53 59 53 43 4f | 4c 50 45 52 4d 2e 74 61 |re SYSCO|LPERM.ta|
|00003420| 62 6c 65 5f 69 64 20 3d | 20 53 59 53 54 41 42 4c |ble_id =| SYSTABL|
|00003430| 45 2e 74 61 62 6c 65 5f | 69 64 20 61 6e 64 20 70 |E.table_|id and p|
|00003440| 72 69 76 69 6c 65 67 65 | 5f 74 79 70 65 20 3d 20 |rivilege|_type = |
|00003450| 25 31 20 61 6e 64 20 67 | 72 61 6e 74 65 65 20 3d |%1 and g|rantee =|
|00003460| 20 28 73 65 6c 65 63 74 | 20 75 73 65 72 5f 69 64 | (select| user_id|
|00003470| 20 66 72 6f 6d 20 53 59 | 53 55 53 45 52 50 45 52 | from SY|SUSERPER|
|00003480| 4d 53 20 77 68 65 72 65 | 20 75 73 65 72 5f 6e 61 |MS where| user_na|
|00003490| 6d 65 20 3d 20 27 25 34 | 27 29 20 29 20 74 68 65 |me = '%4|') ) the|
|000034a0| 6e 20 27 59 27 20 65 6c | 73 65 20 27 4e 27 20 65 |n 'Y' el|se 'N' e|
|000034b0| 6e 64 69 66 20 29 2c 20 | 28 69 66 20 63 6f 6c 75 |ndif ), |(if colu|
|000034c0| 6d 6e 5f 69 64 20 69 6e | 28 20 73 65 6c 65 63 74 |mn_id in|( select|
|000034d0| 20 63 6f 6c 75 6d 6e 5f | 69 64 20 66 72 6f 6d 20 | column_|id from |
|000034e0| 53 59 53 43 4f 4c 50 45 | 52 4d 20 77 68 65 72 65 |SYSCOLPE|RM where|
|000034f0| 20 53 59 53 43 4f 4c 50 | 45 52 4d 2e 74 61 62 6c | SYSCOLP|ERM.tabl|
|00003500| 65 5f 69 64 20 3d 20 53 | 59 53 54 41 42 4c 45 2e |e_id = S|YSTABLE.|
|00003510| 74 61 62 6c 65 5f 69 64 | 20 61 6e 64 20 70 72 69 |table_id| and pri|
|00003520| 76 69 6c 65 67 65 5f 74 | 79 70 65 20 3d 20 25 31 |vilege_t|ype = %1|
|00003530| 20 61 6e 64 20 67 72 61 | 6e 74 65 65 20 3d 20 28 | and gra|ntee = (|
|00003540| 73 65 6c 65 63 74 20 75 | 73 65 72 5f 69 64 20 66 |select u|ser_id f|
|00003550| 72 6f 6d 20 53 59 53 55 | 53 45 52 50 45 52 4d 53 |rom SYSU|SERPERMS|
|00003560| 20 77 68 65 72 65 20 75 | 73 65 72 5f 6e 61 6d 65 | where u|ser_name|
|00003570| 20 3d 20 27 25 34 27 20 | 29 20 61 6e 64 20 69 73 | = '%4' |) and is|
|00003580| 5f 67 72 61 6e 74 61 62 | 6c 65 20 3d 20 27 59 27 |_grantab|le = 'Y'|
|00003590| 20 29 20 74 68 65 6e 20 | 27 59 27 20 65 6c 73 65 | ) then |'Y' else|
|000035a0| 20 27 4e 27 20 65 6e 64 | 69 66 20 29 20 66 72 6f | 'N' end|if ) fro|
|000035b0| 6d 20 53 59 53 43 4f 4c | 55 4d 4e 20 6a 6f 69 6e |m SYSCOL|UMN join|
|000035c0| 20 53 59 53 54 41 42 4c | 45 20 6a 6f 69 6e 20 53 | SYSTABL|E join S|
|000035d0| 59 53 55 53 45 52 50 45 | 52 4d 53 20 77 68 65 72 |YSUSERPE|RMS wher|
|000035e0| 65 20 74 61 62 6c 65 5f | 6e 61 6d 65 20 3d 20 27 |e table_|name = '|
|000035f0| 25 32 27 20 61 6e 64 20 | 75 73 65 72 5f 6e 61 6d |%2' and |user_nam|
|00003600| 65 20 3d 20 27 25 33 27 | 20 6f 72 64 65 72 20 62 |e = '%3'| order b|
|00003610| 79 20 53 59 53 43 4f 4c | 55 4d 4e 2e 63 6f 6c 75 |y SYSCOL|UMN.colu|
|00003620| 6d 6e 5f 6e 61 6d 65 00 | 73 65 6c 65 63 74 20 63 |mn_name.|select c|
|00003630| 6f 6c 75 6d 6e 5f 6e 61 | 6d 65 2c 20 28 69 66 20 |olumn_na|me, (if |
|00003640| 25 31 20 3d 20 38 20 61 | 6e 64 20 63 6f 6c 75 6d |%1 = 8 a|nd colum|
|00003650| 6e 5f 69 64 20 69 6e 28 | 20 73 65 6c 65 63 74 20 |n_id in(| select |
|00003660| 63 6f 6c 75 6d 6e 5f 69 | 64 20 66 72 6f 6d 20 53 |column_i|d from S|
|00003670| 59 53 43 4f 4c 50 45 52 | 4d 20 77 68 65 72 65 20 |YSCOLPER|M where |
|00003680| 53 59 53 43 4f 4c 50 45 | 52 4d 2e 74 61 62 6c 65 |SYSCOLPE|RM.table|
|00003690| 5f 69 64 20 3d 20 53 59 | 53 54 41 42 4c 45 2e 74 |_id = SY|STABLE.t|
|000036a0| 61 62 6c 65 5f 69 64 20 | 61 6e 64 20 67 72 61 6e |able_id |and gran|
|000036b0| 74 65 65 20 3d 20 28 73 | 65 6c 65 63 74 20 75 73 |tee = (s|elect us|
|000036c0| 65 72 5f 69 64 20 66 72 | 6f 6d 20 53 59 53 55 53 |er_id fr|om SYSUS|
|000036d0| 45 52 50 45 52 4d 53 20 | 77 68 65 72 65 20 75 73 |ERPERMS |where us|
|000036e0| 65 72 5f 6e 61 6d 65 20 | 3d 20 27 25 34 27 29 20 |er_name |= '%4') |
|000036f0| 29 20 74 68 65 6e 20 27 | 59 27 20 65 6c 73 65 20 |) then '|Y' else |
|00003700| 27 4e 27 20 65 6e 64 69 | 66 20 29 2c 20 27 4e 27 |'N' endi|f ), 'N'|
|00003710| 20 66 72 6f 6d 20 53 59 | 53 43 4f 4c 55 4d 4e 20 | from SY|SCOLUMN |
|00003720| 6a 6f 69 6e 20 53 59 53 | 54 41 42 4c 45 20 6a 6f |join SYS|TABLE jo|
|00003730| 69 6e 20 53 59 53 55 53 | 45 52 50 45 52 4d 53 20 |in SYSUS|ERPERMS |
|00003740| 77 68 65 72 65 20 74 61 | 62 6c 65 5f 6e 61 6d 65 |where ta|ble_name|
|00003750| 20 3d 20 27 25 32 27 20 | 61 6e 64 20 75 73 65 72 | = '%2' |and user|
|00003760| 5f 6e 61 6d 65 20 3d 20 | 27 25 33 27 20 6f 72 64 |_name = |'%3' ord|
|00003770| 65 72 20 62 79 20 53 59 | 53 43 4f 4c 55 4d 4e 2e |er by SY|SCOLUMN.|
|00003780| 63 6f 6c 75 6d 6e 5f 6e | 61 6d 65 00 41 4c 54 45 |column_n|ame.ALTE|
|00003790| 52 00 44 45 4c 45 54 45 | 00 49 4e 53 45 52 54 00 |R.DELETE|.INSERT.|
|000037a0| 52 45 46 45 52 45 4e 43 | 45 53 00 53 45 4c 45 43 |REFERENC|ES.SELEC|
|000037b0| 54 00 55 50 44 41 54 45 | 00 00 00 00 44 52 4f 50 |T.UPDATE|....DROP|
|000037c0| 20 43 4f 4e 4e 45 43 54 | 49 4f 4e 20 25 31 00 53 | CONNECT|ION %1.S|
|000037d0| 45 4c 45 43 54 20 63 6f | 6e 6e 65 63 74 69 6f 6e |ELECT co|nnection|
|000037e0| 5f 70 72 6f 70 65 72 74 | 79 28 20 27 25 31 27 2c |_propert|y( '%1',|
|000037f0| 20 25 32 20 29 00 55 73 | 65 72 49 64 00 4e 61 6d | %2 ).Us|erId.Nam|
|00003800| 65 00 44 42 4e 75 6d 62 | 65 72 00 46 69 6c 65 00 |e.DBNumb|er.File.|
|00003810| 43 6f 6d 6d 4c 69 6e 6b | 00 4c 6f 67 4e 61 6d 65 |CommLink|.LogName|
|00003820| 00 43 6f 6e 6e 43 6f 75 | 6e 74 00 4e 6f 64 65 41 |.ConnCou|nt.NodeA|
|00003830| 64 64 72 65 73 73 00 53 | 45 4c 45 43 54 20 64 62 |ddress.S|ELECT db|
|00003840| 5f 70 72 6f 70 65 72 74 | 79 28 27 25 31 27 29 00 |_propert|y('%1').|
|00003850| 53 45 4c 45 43 54 20 63 | 6f 6e 6e 65 63 74 69 6f |SELECT c|onnectio|
|00003860| 6e 5f 70 72 6f 70 65 72 | 74 79 28 27 4e 75 6d 62 |n_proper|ty('Numb|
|00003870| 65 72 27 29 00 53 45 4c | 45 43 54 20 6e 65 78 74 |er').SEL|ECT next|
|00003880| 5f 63 6f 6e 6e 65 63 74 | 69 6f 6e 28 20 25 31 20 |_connect|ion( %1 |
|00003890| 29 00 53 45 4c 45 43 54 | 20 63 6f 6e 6e 65 63 74 |).SELECT| connect|
|000038a0| 69 6f 6e 5f 70 72 6f 70 | 65 72 74 79 28 20 27 55 |ion_prop|erty( 'U|
|000038b0| 73 65 72 49 64 27 2c 20 | 25 31 20 29 00 00 00 00 |serId', |%1 )....|
|000038c0| 34 2e 30 00 35 2e 30 00 | 53 45 4c 45 43 54 20 2a |4.0.5.0.|SELECT *|
|000038d0| 20 46 52 4f 4d 20 53 59 | 53 54 41 42 4c 45 00 30 | FROM SY|STABLE.0|
|000038e0| 00 53 45 4c 45 43 54 20 | 2a 20 46 52 4f 4d 20 53 |.SELECT |* FROM S|
|000038f0| 59 53 55 53 45 52 50 45 | 52 4d 00 22 25 31 22 2e |YSUSERPE|RM."%1".|
|00003900| 22 25 32 22 00 43 52 45 | 41 54 45 20 53 54 41 54 |"%2".CRE|ATE STAT|
|00003910| 49 53 54 49 43 53 00 2e | 00 22 00 2e 00 22 00 30 |ISTICS..|."...".0|
|00003920| 00 30 00 50 41 53 53 54 | 48 52 4f 55 47 48 20 00 |.0.PASST|HROUGH .|
|00003930| 50 41 53 53 54 48 52 4f | 55 47 48 20 4f 4e 4c 59 |PASSTHRO|UGH ONLY|
|00003940| 20 00 46 4f 52 20 22 25 | 31 22 00 46 4f 52 20 53 | .FOR "%|1".FOR S|
|00003950| 55 42 53 43 52 49 50 54 | 49 4f 4e 20 54 4f 20 25 |UBSCRIPT|ION TO %|
|00003960| 31 00 50 41 53 53 54 48 | 52 4f 55 47 48 20 53 54 |1.PASSTH|ROUGH ST|
|00003970| 4f 50 00 53 45 4c 45 43 | 54 20 6e 65 78 74 5f 64 |OP.SELEC|T next_d|
|00003980| 61 74 61 62 61 73 65 28 | 25 31 29 00 53 45 4c 45 |atabase(|%1).SELE|
|00003990| 43 54 20 64 62 5f 70 72 | 6f 70 65 72 74 79 28 20 |CT db_pr|operty( |
|000039a0| 27 41 6c 69 61 73 27 2c | 20 25 31 20 29 00 53 45 |'Alias',| %1 ).SE|
|000039b0| 4c 45 43 54 20 64 62 5f | 70 72 6f 70 65 72 74 79 |LECT db_|property|
|000039c0| 28 20 27 43 6f 6e 6e 43 | 6f 75 6e 74 27 2c 20 25 |( 'ConnC|ount', %|
|000039d0| 31 20 29 00 53 45 4c 45 | 43 54 20 64 62 5f 70 72 |1 ).SELE|CT db_pr|
|000039e0| 6f 70 65 72 74 79 28 20 | 27 41 6c 69 61 73 27 2c |operty( |'Alias',|
|000039f0| 20 25 31 20 29 2c 20 64 | 62 5f 70 72 6f 70 65 72 | %1 ), d|b_proper|
|00003a00| 74 79 28 20 27 46 69 6c | 65 27 2c 20 25 32 20 29 |ty( 'Fil|e', %2 )|
|00003a10| 2c 20 64 62 5f 70 72 6f | 70 65 72 74 79 28 20 27 |, db_pro|perty( '|
|00003a20| 43 6f 6e 6e 43 6f 75 6e | 74 27 2c 20 25 33 20 29 |ConnCoun|t', %3 )|
|00003a30| 2c 20 64 62 5f 70 72 6f | 70 65 72 74 79 28 20 27 |, db_pro|perty( '|
|00003a40| 50 61 67 65 53 69 7a 65 | 27 2c 20 25 34 20 29 2c |PageSize|', %4 ),|
|00003a50| 20 64 62 5f 70 72 6f 70 | 65 72 74 79 28 20 27 4c | db_prop|erty( 'L|
|00003a60| 6f 67 4e 61 6d 65 27 2c | 20 25 35 20 29 00 73 65 |ogName',| %5 ).se|
|00003a70| 6c 65 63 74 20 40 40 76 | 65 72 73 69 6f 6e 20 66 |lect @@v|ersion f|
|00003a80| 72 6f 6d 20 44 55 4d 4d | 59 00 73 65 6c 65 63 74 |rom DUMM|Y.select|
|00003a90| 20 64 61 74 61 62 61 73 | 65 5f 76 65 72 73 69 6f | databas|e_versio|
|00003aa0| 6e 20 66 72 6f 6d 20 53 | 59 53 2e 53 59 53 49 4e |n from S|YS.SYSIN|
|00003ab0| 46 4f 00 44 45 43 4c 41 | 52 45 20 4c 4f 43 41 4c |FO.DECLA|RE LOCAL|
|00003ac0| 20 54 45 4d 50 4f 52 41 | 52 59 20 54 41 42 4c 45 | TEMPORA|RY TABLE|
|00003ad0| 20 64 62 78 5f 66 69 6c | 74 65 72 5f 6c 69 73 74 | dbx_fil|ter_list|
|00003ae0| 20 28 20 63 72 65 61 74 | 6f 72 20 69 6e 74 20 29 | ( creat|or int )|
|00003af0| 20 4f 4e 20 43 4f 4d 4d | 49 54 20 50 52 45 53 45 | ON COMM|IT PRESE|
|00003b00| 52 56 45 20 52 4f 57 53 | 00 49 4e 53 45 52 54 20 |RVE ROWS|.INSERT |
|00003b10| 49 4e 54 4f 20 64 62 78 | 5f 66 69 6c 74 65 72 5f |INTO dbx|_filter_|
|00003b20| 6c 69 73 74 28 20 22 63 | 72 65 61 74 6f 72 22 20 |list( "c|reator" |
|00003b30| 29 20 56 41 4c 55 45 53 | 28 20 25 31 20 29 00 44 |) VALUES|( %1 ).D|
|00003b40| 45 4c 45 54 45 20 46 52 | 4f 4d 20 64 62 78 5f 66 |ELETE FR|OM dbx_f|
|00003b50| 69 6c 74 65 72 5f 6c 69 | 73 74 20 57 48 45 52 45 |ilter_li|st WHERE|
|00003b60| 20 22 63 72 65 61 74 6f | 72 22 20 3d 20 25 31 00 | "creato|r" = %1.|
|00003b70| 43 4f 4d 4d 49 54 00 53 | 45 4c 45 43 54 20 63 72 |COMMIT.S|ELECT cr|
|00003b80| 65 61 74 6f 72 20 46 52 | 4f 4d 20 53 59 53 54 41 |eator FR|OM SYSTA|
|00003b90| 42 4c 45 20 57 48 45 52 | 45 20 74 61 62 6c 65 5f |BLE WHER|E table_|
|00003ba0| 6e 61 6d 65 20 3d 20 27 | 52 6f 77 47 65 6e 65 72 |name = '|RowGener|
|00003bb0| 61 74 6f 72 27 00 00 00 | 73 65 6c 65 63 74 20 63 |ator'...|select c|
|00003bc0| 6f 6e 6e 65 63 74 69 6f | 6e 5f 70 72 6f 70 65 72 |onnectio|n_proper|
|00003bd0| 74 79 28 27 25 31 27 2c | 20 25 32 29 00 73 65 6c |ty('%1',| %2).sel|
|00003be0| 65 63 74 20 70 72 6f 70 | 65 72 74 79 5f 64 65 73 |ect prop|erty_des|
|00003bf0| 63 72 69 70 74 69 6f 6e | 28 27 25 31 27 29 00 73 |cription|('%1').s|
|00003c00| 65 6c 65 63 74 20 70 72 | 6f 70 65 72 74 79 28 27 |elect pr|operty('|
|00003c10| 25 31 27 29 00 41 73 79 | 6e 63 32 52 65 61 64 00 |%1').Asy|nc2Read.|
|00003c20| 41 73 79 6e 63 52 65 61 | 64 00 41 73 79 6e 63 57 |AsyncRea|d.AsyncW|
|00003c30| 72 69 74 65 00 42 6c 6f | 63 6b 65 64 4f 6e 00 43 |rite.Blo|ckedOn.C|
|00003c40| 61 63 68 65 52 65 61 64 | 00 43 61 63 68 65 52 65 |acheRead|.CacheRe|
|00003c50| 61 64 49 6e 64 49 6e 74 | 00 43 61 63 68 65 52 65 |adIndInt|.CacheRe|
|00003c60| 61 64 49 6e 64 4c 65 61 | 66 00 43 61 63 68 65 52 |adIndLea|f.CacheR|
|00003c70| 65 61 64 54 61 62 6c 65 | 00 43 61 63 68 65 57 72 |eadTable|.CacheWr|
|00003c80| 69 74 65 00 43 6f 6d 6d | 69 74 00 43 6f 6d 6d 4c |ite.Comm|it.CommL|
|00003c90| 69 6e 6b 00 43 6f 6e 6e | 52 65 71 00 43 75 72 72 |ink.Conn|Req.Curr|
|00003ca0| 54 61 73 6b 53 77 69 74 | 63 68 00 43 75 72 73 6f |TaskSwit|ch.Curso|
|00003cb0| 72 00 43 75 72 73 6f 72 | 4f 70 65 6e 00 44 42 4e |r.Cursor|Open.DBN|
|00003cc0| 75 6d 62 65 72 00 44 69 | 73 6b 52 65 61 64 00 44 |umber.Di|skRead.D|
|00003cd0| 69 73 6b 52 65 61 64 49 | 6e 64 49 6e 74 00 44 69 |iskReadI|ndInt.Di|
|00003ce0| 73 6b 52 65 61 64 49 6e | 64 4c 65 61 66 00 44 69 |skReadIn|dLeaf.Di|
|00003cf0| 73 6b 52 65 61 64 54 61 | 62 6c 65 00 44 69 73 6b |skReadTa|ble.Disk|
|00003d00| 53 79 6e 63 52 65 61 64 | 00 44 69 73 6b 53 79 6e |SyncRead|.DiskSyn|
|00003d10| 63 57 72 69 74 65 00 44 | 69 73 6b 57 61 69 74 52 |cWrite.D|iskWaitR|
|00003d20| 65 61 64 00 44 69 73 6b | 57 61 69 74 57 72 69 74 |ead.Disk|WaitWrit|
|00003d30| 65 00 44 69 73 6b 57 72 | 69 74 65 00 46 75 6c 6c |e.DiskWr|ite.Full|
|00003d40| 43 6f 6d 70 61 72 65 00 | 48 69 6e 74 55 73 65 64 |Compare.|HintUsed|
|00003d50| 00 49 6e 64 41 64 64 00 | 49 6e 64 4c 6f 6f 6b 75 |.IndAdd.|IndLooku|
|00003d60| 70 00 4c 61 73 74 49 64 | 6c 65 00 4c 61 73 74 52 |p.LastId|le.LastR|
|00003d70| 65 71 54 69 6d 65 00 4c | 6f 67 46 72 65 65 43 6f |eqTime.L|ogFreeCo|
|00003d80| 6d 6d 69 74 00 4c 6f 67 | 52 65 77 72 69 74 65 00 |mmit.Log|Rewrite.|
|00003d90| 4c 6f 67 57 72 69 74 65 | 00 4e 61 6d 65 00 4e 6f |LogWrite|.Name.No|
|00003da0| 64 65 41 64 64 72 65 73 | 73 00 4e 75 6d 62 65 72 |deAddres|s.Number|
|00003db0| 00 50 6f 72 74 00 50 72 | 65 70 53 74 6d 74 00 50 |.Port.Pr|epStmt.P|
|00003dc0| 72 6f 63 65 73 73 54 69 | 6d 65 00 52 65 61 64 48 |rocessTi|me.ReadH|
|00003dd0| 69 6e 74 00 52 65 71 54 | 79 70 65 00 52 6c 62 6b |int.ReqT|ype.Rlbk|
|00003de0| 00 53 79 6e 63 57 72 69 | 74 65 43 68 6b 70 74 00 |.SyncWri|teChkpt.|
|00003df0| 53 79 6e 63 57 72 69 74 | 65 45 78 74 65 6e 64 00 |SyncWrit|eExtend.|
|00003e00| 53 79 6e 63 57 72 69 74 | 65 46 72 65 65 43 75 72 |SyncWrit|eFreeCur|
|00003e10| 72 00 53 79 6e 63 57 72 | 69 74 65 46 72 65 65 50 |r.SyncWr|iteFreeP|
|00003e20| 75 73 68 00 53 79 6e 63 | 57 72 69 74 65 4c 6f 67 |ush.Sync|WriteLog|
|00003e30| 00 53 79 6e 63 57 72 69 | 74 65 52 6c 62 6b 00 53 |.SyncWri|teRlbk.S|
|00003e40| 79 6e 63 57 72 69 74 65 | 55 6e 6b 6e 00 54 61 73 |yncWrite|Unkn.Tas|
|00003e50| 6b 53 77 69 74 63 68 00 | 54 61 73 6b 53 77 69 74 |kSwitch.|TaskSwit|
|00003e60| 63 68 43 68 65 63 6b 00 | 55 6e 63 6f 6d 6d 69 74 |chCheck.|Uncommit|
|00003e70| 4f 70 00 55 73 65 72 69 | 64 00 56 6f 6c 75 6e 74 |Op.Useri|d.Volunt|
|00003e80| 61 72 79 42 6c 6f 63 6b | 00 57 61 69 74 52 65 61 |aryBlock|.WaitRea|
|00003e90| 64 43 6d 70 00 57 61 69 | 74 52 65 61 64 4f 70 74 |dCmp.Wai|tReadOpt|
|00003ea0| 00 57 61 69 74 52 65 61 | 64 53 79 73 00 57 61 69 |.WaitRea|dSys.Wai|
|00003eb0| 74 52 65 61 64 54 65 6d | 70 00 57 61 69 74 52 65 |tReadTem|p.WaitRe|
|00003ec0| 61 64 55 6e 6b 6e 00 00 | 53 45 4c 45 43 54 20 2a |adUnkn..|SELECT *|
|00003ed0| 20 46 52 4f 4d 20 53 59 | 53 54 41 42 4c 45 00 53 | FROM SY|STABLE.S|
|00003ee0| 45 4c 45 43 54 20 64 62 | 5f 70 72 6f 70 65 72 74 |ELECT db|_propert|
|00003ef0| 79 28 20 27 25 31 27 2c | 20 27 25 32 27 20 29 00 |y( '%1',| '%2' ).|
|00003f00| 53 45 4c 45 43 54 20 64 | 62 5f 69 64 28 29 00 50 |SELECT d|b_id().P|
|00003f10| 61 67 65 53 69 7a 65 00 | 43 6f 6e 6e 43 6f 75 6e |ageSize.|ConnCoun|
|00003f20| 74 00 4c 6f 67 4e 61 6d | 65 00 4c 6f 67 4d 69 72 |t.LogNam|e.LogMir|
|00003f30| 72 6f 72 46 69 6c 65 00 | 53 45 4c 45 43 54 20 70 |rorFile.|SELECT p|
|00003f40| 61 67 65 5f 73 69 7a 65 | 20 46 52 4f 4d 20 53 59 |age_size| FROM SY|
|00003f50| 53 49 4e 46 4f 00 53 45 | 4c 45 43 54 20 64 65 66 |SINFO.SE|LECT def|
|00003f60| 61 75 6c 74 5f 63 6f 6c | 6c 61 74 69 6f 6e 20 46 |ault_col|lation F|
|00003f70| 52 4f 4d 20 53 59 53 49 | 4e 46 4f 00 53 45 4c 45 |ROM SYSI|NFO.SELE|
|00003f80| 43 54 20 65 6e 63 72 79 | 70 74 69 6f 6e 20 46 52 |CT encry|ption FR|
|00003f90| 4f 4d 20 53 59 53 49 4e | 46 4f 00 53 45 4c 45 43 |OM SYSIN|FO.SELEC|
|00003fa0| 54 20 62 6c 61 6e 6b 5f | 70 61 64 64 69 6e 67 20 |T blank_|padding |
|00003fb0| 46 52 4f 4d 20 53 59 53 | 49 4e 46 4f 00 53 45 4c |FROM SYS|INFO.SEL|
|00003fc0| 45 43 54 20 63 61 73 65 | 5f 73 65 6e 73 69 74 69 |ECT case|_sensiti|
|00003fd0| 76 69 74 79 20 46 52 4f | 4d 20 53 59 53 49 4e 46 |vity FRO|M SYSINF|
|00003fe0| 4f 00 53 45 4c 45 43 54 | 20 63 6f 6c 6c 61 74 69 |O.SELECT| collati|
|00003ff0| 6f 6e 5f 6e 61 6d 65 20 | 46 52 4f 4d 20 53 59 53 |on_name |FROM SYS|
|00004000| 43 4f 4c 4c 41 54 49 4f | 4e 20 57 48 45 52 45 20 |COLLATIO|N WHERE |
|00004010| 63 6f 6c 6c 61 74 69 6f | 6e 5f 6c 61 62 65 6c 20 |collatio|n_label |
|00004020| 3d 20 27 25 31 27 00 38 | 35 30 00 53 45 4c 45 43 |= '%1'.8|50.SELEC|
|00004030| 54 20 43 55 52 52 45 4e | 54 20 50 55 42 4c 49 53 |T CURREN|T PUBLIS|
|00004040| 48 45 52 00 52 45 56 4f | 4b 45 20 50 55 42 4c 49 |HER.REVO|KE PUBLI|
|00004050| 53 48 20 46 52 4f 4d 20 | 22 25 31 22 00 47 52 41 |SH FROM |"%1".GRA|
|00004060| 4e 54 20 50 55 42 4c 49 | 53 48 20 54 4f 20 22 25 |NT PUBLI|SH TO "%|
|00004070| 31 22 00 00 53 45 4c 45 | 43 54 20 75 73 65 72 5f |1"..SELE|CT user_|
|00004080| 6e 61 6d 65 20 46 52 4f | 4d 20 53 59 53 55 53 45 |name FRO|M SYSUSE|
|00004090| 52 50 45 52 4d 53 20 4b | 45 59 20 4a 4f 49 4e 20 |RPERMS K|EY JOIN |
|000040a0| 53 59 53 52 45 4d 4f 54 | 45 55 53 45 52 20 57 48 |SYSREMOT|EUSER WH|
|000040b0| 45 52 45 20 63 6f 6e 73 | 6f 6c 69 64 61 74 65 20 |ERE cons|olidate |
|000040c0| 3d 20 27 59 27 00 53 45 | 4c 45 43 54 20 63 6f 75 |= 'Y'.SE|LECT cou|
|000040d0| 6e 74 28 2a 29 20 46 52 | 4f 4d 20 53 59 53 53 55 |nt(*) FR|OM SYSSU|
|000040e0| 42 53 43 52 49 50 54 49 | 4f 4e 00 53 45 4c 45 43 |BSCRIPTI|ON.SELEC|
|000040f0| 54 20 63 6f 75 6e 74 28 | 2a 29 20 46 52 4f 4d 20 |T count(|*) FROM |
|00004100| 53 59 53 52 45 4d 4f 54 | 45 55 53 45 52 00 53 45 |SYSREMOT|EUSER.SE|
|00004110| 4c 45 43 54 20 63 6f 75 | 6e 74 28 2a 29 20 46 52 |LECT cou|nt(*) FR|
|00004120| 4f 4d 20 53 59 53 53 55 | 42 53 43 52 49 50 54 49 |OM SYSSU|BSCRIPTI|
|00004130| 4f 4e 20 57 48 45 52 45 | 20 73 74 61 72 74 65 64 |ON WHERE| started|
|00004140| 20 49 53 20 4e 4f 54 20 | 4e 55 4c 4c 00 73 65 6c | IS NOT |NULL.sel|
|00004150| 65 63 74 20 43 55 52 52 | 45 4e 54 20 44 41 54 41 |ect CURR|ENT DATA|
|00004160| 42 41 53 45 20 66 72 6f | 6d 20 44 55 4d 4d 59 00 |BASE fro|m DUMMY.|
|00004170| 53 45 4c 45 43 54 20 64 | 65 66 61 75 6c 74 5f 63 |SELECT d|efault_c|
|00004180| 6f 6c 6c 61 74 69 6f 6e | 20 46 52 4f 4d 20 53 59 |ollation| FROM SY|
|00004190| 53 49 4e 46 4f 00 53 45 | 4c 45 43 54 20 63 6f 6e |SINFO.SE|LECT con|
|000041a0| 6e 65 63 74 69 6f 6e 5f | 70 72 6f 70 65 72 74 79 |nection_|property|
|000041b0| 28 20 27 4e 75 6d 62 65 | 72 27 20 29 00 00 00 00 |( 'Numbe|r' )....|
|000041c0| 49 44 44 5f 57 49 5a 50 | 47 5f 42 41 43 4b 55 50 |IDD_WIZP|G_BACKUP|
|000041d0| 31 00 00 49 44 44 5f 57 | 49 5a 50 47 5f 42 41 43 |1..IDD_W|IZPG_BAC|
|000041e0| 4b 55 50 32 00 49 44 44 | 5f 57 49 5a 50 47 5f 42 |KUP2.IDD|_WIZPG_B|
|000041f0| 41 43 4b 55 50 33 00 5c | 00 49 44 44 5f 57 49 5a |ACKUP3.\|.IDD_WIZ|
|00004200| 50 47 5f 42 41 43 4b 55 | 50 34 00 49 44 44 5f 57 |PG_BACKU|P4.IDD_W|
|00004210| 49 5a 50 47 5f 42 41 43 | 4b 55 50 35 00 55 49 44 |IZPG_BAC|KUP5.UID|
|00004220| 3d 25 31 3b 50 57 44 3d | 25 32 3b 44 42 46 3d 25 |=%1;PWD=|%2;DBF=%|
|00004230| 33 00 55 49 44 3d 25 31 | 3b 50 57 44 3d 25 32 3b |3.UID=%1|;PWD=%2;|
|00004240| 44 42 4e 3d 25 33 00 55 | 49 44 3d 25 31 3b 50 57 |DBN=%3.U|ID=%1;PW|
|00004250| 44 3d 25 32 3b 44 42 4e | 3d 25 33 3b 45 4e 47 3d |D=%2;DBN|=%3;ENG=|
|00004260| 25 34 00 44 42 58 42 61 | 63 6b 75 70 57 69 7a 61 |%4.DBXBa|ckupWiza|
|00004270| 72 64 00 49 44 44 5f 42 | 4b 57 49 5a 5f 53 54 41 |rd.IDD_B|KWIZ_STA|
|00004280| 54 5f 57 4e 44 00 00 00 | 49 44 44 5f 55 4c 57 49 |T_WND...|IDD_ULWI|
|00004290| 5a 5f 50 41 47 45 31 00 | 00 00 49 44 44 5f 55 4c |Z_PAGE1.|..IDD_UL|
|000042a0| 57 49 5a 5f 50 41 47 45 | 32 00 49 44 44 5f 55 4c |WIZ_PAGE|2.IDD_UL|
|000042b0| 57 49 5a 5f 50 41 47 45 | 33 00 2e 73 71 6c 00 49 |WIZ_PAGE|3..sql.I|
|000042c0| 44 44 5f 55 4c 57 49 5a | 5f 50 41 47 45 34 00 49 |DD_ULWIZ|_PAGE4.I|
|000042d0| 44 44 5f 55 4c 57 49 5a | 5f 50 41 47 45 35 00 00 |DD_ULWIZ|_PAGE5..|
|000042e0| 5c 00 49 44 44 5f 55 4c | 57 49 5a 5f 50 41 47 45 |\.IDD_UL|WIZ_PAGE|
|000042f0| 36 00 44 42 4f 00 49 44 | 44 5f 55 4c 57 49 5a 5f |6.DBO.ID|D_ULWIZ_|
|00004300| 50 41 47 45 37 00 00 44 | 42 58 55 6e 6c 6f 61 64 |PAGE7..D|BXUnload|
|00004310| 57 69 7a 61 72 64 00 49 | 44 44 5f 55 4c 57 49 5a |Wizard.I|DD_ULWIZ|
|00004320| 5f 53 54 41 54 5f 57 4e | 44 00 55 49 44 3d 25 73 |_STAT_WN|D.UID=%s|
|00004330| 3b 50 57 44 3d 25 73 3b | 44 42 46 3d 25 73 3b 00 |;PWD=%s;|DBF=%s;.|
|00004340| 55 49 44 3d 25 73 3b 50 | 57 44 3d 25 73 3b 44 42 |UID=%s;P|WD=%s;DB|
|00004350| 4e 3d 25 73 3b 45 4e 47 | 3d 25 73 3b 00 55 49 44 |N=%s;ENG|=%s;.UID|
|00004360| 3d 25 73 3b 50 57 44 3d | 25 73 3b 44 42 4e 3d 25 |=%s;PWD=|%s;DBN=%|
|00004370| 73 3b 00 00 44 42 4f 00 | 00 49 44 44 5f 56 41 4c |s;..DBO.|.IDD_VAL|
|00004380| 49 44 5f 53 54 41 54 5f | 44 49 41 4c 4f 47 00 00 |ID_STAT_|DIALOG..|
|00004390| 49 44 44 5f 45 58 57 49 | 5a 5f 50 41 47 45 31 00 |IDD_EXWI|Z_PAGE1.|
|000043a0| 00 49 44 44 5f 45 58 57 | 49 5a 5f 50 41 47 45 32 |.IDD_EXW|IZ_PAGE2|
|000043b0| 00 49 44 44 5f 45 58 57 | 49 5a 5f 50 41 47 45 33 |.IDD_EXW|IZ_PAGE3|
|000043c0| 00 53 51 4c 20 43 65 6e | 74 72 61 6c 00 4e 6f 74 |.SQL Cen|tral.Not|
|000043d0| 20 59 65 74 20 49 6d 70 | 6c 65 6d 65 6e 74 65 64 | Yet Imp|lemented|
|000043e0| 00 49 44 44 5f 45 58 57 | 49 5a 5f 50 41 47 45 34 |.IDD_EXW|IZ_PAGE4|
|000043f0| 00 2e 64 62 00 2e 6c 6f | 67 00 49 44 44 5f 45 58 |..db..lo|g.IDD_EX|
|00004400| 57 49 5a 5f 50 41 47 45 | 35 00 49 44 44 5f 45 58 |WIZ_PAGE|5.IDD_EX|
|00004410| 57 49 5a 5f 50 41 47 45 | 36 00 44 42 4f 00 49 44 |WIZ_PAGE|6.DBO.ID|
|00004420| 44 5f 45 58 57 49 5a 5f | 50 41 47 45 37 00 2e 73 |D_EXWIZ_|PAGE7..s|
|00004430| 71 6c 00 49 44 44 5f 45 | 58 57 49 5a 5f 50 41 47 |ql.IDD_E|XWIZ_PAG|
|00004440| 45 38 00 49 44 44 5f 45 | 58 57 49 5a 5f 50 41 47 |E8.IDD_E|XWIZ_PAG|
|00004450| 45 39 00 00 5c 00 49 44 | 44 5f 45 58 57 49 5a 5f |E9..\.ID|D_EXWIZ_|
|00004460| 50 41 47 45 31 30 00 44 | 42 58 45 78 74 72 61 63 |PAGE10.D|BXExtrac|
|00004470| 74 57 69 7a 61 72 64 00 | 00 49 44 44 5f 45 58 57 |tWizard.|.IDD_EXW|
|00004480| 49 5a 5f 44 4c 47 00 44 | 42 4f 00 00 55 49 44 3d |IZ_DLG.D|BO..UID=|
|00004490| 25 73 3b 50 57 44 3d 25 | 73 3b 44 42 4e 3d 25 73 |%s;PWD=%|s;DBN=%s|
|000044a0| 3b 45 4e 47 3d 25 73 3b | 00 55 49 44 3d 25 73 3b |;ENG=%s;|.UID=%s;|
|000044b0| 50 57 44 3d 25 73 3b 44 | 42 46 3d 25 73 3b 00 00 |PWD=%s;D|BF=%s;..|
|000044c0| 55 49 44 3d 64 62 61 3b | 50 57 44 3d 73 71 6c 3b |UID=dba;|PWD=sql;|
|000044d0| 44 42 46 3d 25 31 3b 00 | 49 53 51 4c 20 2d 63 20 |DBF=%1;.|ISQL -c |
|000044e0| 22 25 31 22 20 72 65 61 | 64 20 25 32 00 00 00 00 |"%1" rea|d %2....|
|000044f0| 59 65 73 00 4e 6f 00 00 | 00 3b 00 5f 5f 64 62 78 |Yes.No..|.;.__dbx|
|00004500| 25 6c 75 25 6c 75 00 55 | 49 44 3d 25 31 00 50 57 |%lu%lu.U|ID=%1.PW|
|00004510| 44 3d 25 31 00 44 42 4e | 3d 25 31 00 45 4e 47 3d |D=%1.DBN|=%1.ENG=|
|00004520| 25 31 00 44 42 46 3d 25 | 31 00 53 74 61 72 74 3d |%1.DBF=%|1.Start=|
|00004530| 25 31 00 43 4f 4e 3d 25 | 31 00 41 75 74 6f 53 74 |%1.CON=%|1.AutoSt|
|00004540| 6f 70 3d 25 31 00 00 00 | 49 44 44 5f 57 49 5a 50 |op=%1...|IDD_WIZP|
|00004550| 47 5f 43 52 45 41 54 45 | 31 00 2e 64 62 00 49 44 |G_CREATE|1..db.ID|
|00004560| 44 5f 57 49 5a 50 47 5f | 43 52 45 41 54 45 32 00 |D_WIZPG_|CREATE2.|
|00004570| 2e 6c 6f 67 00 00 49 44 | 44 5f 57 49 5a 50 47 5f |.log..ID|D_WIZPG_|
|00004580| 43 52 45 41 54 45 33 00 | 2e 6d 6c 67 00 00 49 44 |CREATE3.|.mlg..ID|
|00004590| 44 5f 57 49 5a 50 47 5f | 43 52 45 41 54 45 34 00 |D_WIZPG_|CREATE4.|
|000045a0| 44 42 4f 00 49 44 44 5f | 57 49 5a 50 47 5f 43 52 |DBO.IDD_|WIZPG_CR|
|000045b0| 45 41 54 45 35 00 49 44 | 44 5f 57 49 5a 50 47 5f |EATE5.ID|D_WIZPG_|
|000045c0| 43 52 45 41 54 45 36 00 | 20 28 00 29 00 49 44 44 |CREATE6.| (.).IDD|
|000045d0| 5f 57 49 5a 50 47 5f 43 | 52 45 41 54 45 37 00 44 |_WIZPG_C|REATE7.D|
|000045e0| 42 58 43 72 65 61 74 65 | 57 69 7a 61 72 64 00 49 |BXCreate|Wizard.I|
|000045f0| 44 44 5f 43 52 57 49 5a | 5f 4d 53 47 5f 57 4e 44 |DD_CRWIZ|_MSG_WND|
|00004600| 00 00 44 42 4f 00 44 42 | 46 3d 25 31 3b 44 42 4e |..DBO.DB|F=%1;DBN|
|00004610| 3d 25 32 3b 45 4e 47 3d | 25 33 3b 55 49 44 3d 44 |=%2;ENG=|%3;UID=D|
|00004620| 42 41 3b 50 57 44 3d 53 | 51 4c 00 00 49 44 44 5f |BA;PWD=S|QL..IDD_|
|00004630| 45 52 57 49 5a 5f 50 41 | 47 45 31 00 00 00 00 49 |ERWIZ_PA|GE1....I|
|00004640| 44 44 5f 45 52 57 49 5a | 5f 50 41 47 45 32 00 00 |DD_ERWIZ|_PAGE2..|
|00004650| 00 00 49 44 44 5f 45 52 | 57 49 5a 5f 50 41 47 45 |..IDD_ER|WIZ_PAGE|
|00004660| 33 00 00 00 49 44 44 5f | 43 50 57 49 5a 5f 50 41 |3...IDD_|CPWIZ_PA|
|00004670| 47 45 31 00 49 44 44 5f | 43 50 57 49 5a 5f 50 41 |GE1.IDD_|CPWIZ_PA|
|00004680| 47 45 32 00 2e 63 64 62 | 00 2e 63 64 62 00 49 44 |GE2..cdb|..cdb.ID|
|00004690| 44 5f 43 50 57 49 5a 5f | 50 41 47 45 33 00 44 42 |D_CPWIZ_|PAGE3.DB|
|000046a0| 58 43 6f 6d 70 72 65 73 | 73 57 69 7a 61 72 64 00 |XCompres|sWizard.|
|000046b0| 49 44 44 5f 43 50 57 49 | 5a 5f 53 54 41 54 5f 57 |IDD_CPWI|Z_STAT_W|
|000046c0| 4e 44 00 44 42 58 44 42 | 43 6f 6d 70 49 6e 66 6f |ND.DBXDB|CompInfo|
|000046d0| 00 49 44 44 5f 43 50 57 | 49 5a 5f 43 4f 4d 50 49 |.IDD_CPW|IZ_COMPI|
|000046e0| 4e 46 4f 00 49 44 44 5f | 43 57 57 49 5a 5f 50 41 |NFO.IDD_|CWWIZ_PA|
|000046f0| 47 45 31 00 49 44 44 5f | 43 57 57 49 5a 5f 50 41 |GE1.IDD_|CWWIZ_PA|
|00004700| 47 45 32 00 2e 77 72 74 | 00 2e 77 72 74 00 49 44 |GE2..wrt|..wrt.ID|
|00004710| 44 5f 43 57 57 49 5a 5f | 50 41 47 45 33 00 2e 77 |D_CWWIZ_|PAGE3..w|
|00004720| 6c 67 00 00 2e 77 6c 67 | 00 49 44 44 5f 43 57 57 |lg...wlg|.IDD_CWW|
|00004730| 49 5a 5f 50 41 47 45 34 | 00 2e 6d 77 6c 00 00 00 |IZ_PAGE4|..mwl...|
|00004740| 2e 6d 77 6c 00 49 44 44 | 5f 43 57 57 49 5a 5f 50 |.mwl.IDD|_CWWIZ_P|
|00004750| 41 47 45 35 00 0a 00 00 | 49 44 44 5f 54 54 57 49 |AGE5....|IDD_TTWI|
|00004760| 5a 5f 50 41 47 45 31 00 | 49 44 44 5f 54 54 57 49 |Z_PAGE1.|IDD_TTWI|
|00004770| 5a 5f 50 41 47 45 32 00 | 2e 73 71 6c 00 2e 73 71 |Z_PAGE2.|.sql..sq|
|00004780| 6c 00 2e 73 71 6c 00 49 | 44 44 5f 54 54 57 49 5a |l..sql.I|DD_TTWIZ|
|00004790| 5f 50 41 47 45 33 00 49 | 44 44 5f 54 54 57 49 5a |_PAGE3.I|DD_TTWIZ|
|000047a0| 5f 50 41 47 45 34 00 54 | 4c 4f 47 5f 55 53 45 52 |_PAGE4.T|LOG_USER|
|000047b0| 53 00 00 2c 00 23 23 23 | 44 42 58 52 45 41 44 55 |S..,.###|DBXREADU|
|000047c0| 53 45 52 4c 49 53 54 23 | 23 23 00 49 44 44 5f 54 |SERLIST#|##.IDD_T|
|000047d0| 54 57 49 5a 5f 50 41 47 | 45 35 00 49 44 44 5f 54 |TWIZ_PAG|E5.IDD_T|
|000047e0| 54 57 49 5a 5f 50 41 47 | 45 36 00 44 42 58 54 72 |TWIZ_PAG|E6.DBXTr|
|000047f0| 61 6e 73 6c 61 74 65 57 | 69 7a 61 72 64 00 53 54 |anslateW|izard.ST|
|00004800| 41 54 55 53 5f 44 49 41 | 4c 4f 47 00 49 44 44 5f |ATUS_DIA|LOG.IDD_|
|00004810| 55 43 57 49 5a 5f 50 41 | 47 45 31 00 49 44 44 5f |UCWIZ_PA|GE1.IDD_|
|00004820| 55 43 57 49 5a 5f 50 41 | 47 45 32 00 2e 64 62 00 |UCWIZ_PA|GE2..db.|
|00004830| 2e 64 62 00 49 44 44 5f | 55 43 57 49 5a 5f 50 41 |.db.IDD_|UCWIZ_PA|
|00004840| 47 45 33 00 44 42 58 55 | 6e 63 6f 6d 70 72 65 73 |GE3.DBXU|ncompres|
|00004850| 73 57 69 7a 61 72 64 00 | 49 44 44 5f 55 43 57 49 |sWizard.|IDD_UCWI|
|00004860| 5a 5f 53 54 41 54 5f 57 | 4e 44 00 00 49 44 44 5f |Z_STAT_W|ND..IDD_|
|00004870| 55 50 57 49 5a 5f 50 41 | 47 45 31 00 00 49 44 44 |UPWIZ_PA|GE1..IDD|
|00004880| 5f 55 50 57 49 5a 5f 50 | 41 47 45 32 00 49 44 44 |_UPWIZ_P|AGE2.IDD|
|00004890| 5f 55 50 57 49 5a 5f 50 | 41 47 45 33 00 44 42 4f |_UPWIZ_P|AGE3.DBO|
|000048a0| 00 00 44 42 4f 00 55 49 | 44 3d 25 31 3b 50 57 44 |..DBO.UI|D=%1;PWD|
|000048b0| 3d 25 32 3b 00 49 44 44 | 5f 55 50 57 49 5a 5f 44 |=%2;.IDD|_UPWIZ_D|
|000048c0| 4c 47 00 44 42 46 3d 00 | 44 42 4e 3d 25 31 3b 45 |LG.DBF=.|DBN=%1;E|
|000048d0| 4e 47 3d 25 32 3b 00 44 | 42 58 55 70 67 72 61 64 |NG=%2;.D|BXUpgrad|
|000048e0| 65 57 69 7a 61 72 64 00 | 49 44 44 5f 43 4c 57 49 |eWizard.|IDD_CLWI|
|000048f0| 5a 5f 50 41 47 45 31 00 | 49 44 44 5f 43 4c 57 49 |Z_PAGE1.|IDD_CLWI|
|00004900| 5a 5f 50 41 47 45 32 00 | 49 44 44 5f 43 4c 57 49 |Z_PAGE2.|IDD_CLWI|
|00004910| 5a 5f 50 41 47 45 33 00 | 2e 77 6c 67 00 2e 6c 6f |Z_PAGE3.|.wlg..lo|
|00004920| 67 00 00 2e 77 6c 67 00 | 2e 6c 6f 67 00 49 44 44 |g...wlg.|.log.IDD|
|00004930| 5f 43 4c 57 49 5a 5f 50 | 41 47 45 34 00 49 44 44 |_CLWIZ_P|AGE4.IDD|
|00004940| 5f 43 4c 57 49 5a 5f 50 | 41 47 45 35 00 2e 6d 77 |_CLWIZ_P|AGE5..mw|
|00004950| 6c 00 2e 6d 6c 67 00 00 | 2e 6d 77 6c 00 2e 6d 6c |l..mlg..|.mwl..ml|
|00004960| 67 00 49 44 44 5f 43 4c | 57 49 5a 5f 50 41 47 45 |g.IDD_CL|WIZ_PAGE|
|00004970| 36 00 0a 00 0a 00 00 00 | 43 4f 4d 42 4f 42 4f 58 |6.......|COMBOBOX|
|00004980| 00 00 00 00 2c 20 00 00 | 2c 20 00 22 00 22 00 41 |...., ..|, .".".A|
|00004990| 4c 54 45 52 20 54 41 42 | 4c 45 20 25 31 20 41 44 |LTER TAB|LE %1 AD|
|000049a0| 44 20 55 4e 49 51 55 45 | 28 20 25 32 20 29 00 41 |D UNIQUE|( %2 ).A|
|000049b0| 4c 54 45 52 20 54 41 42 | 4c 45 20 25 31 20 44 45 |LTER TAB|LE %1 DE|
|000049c0| 4c 45 54 45 20 55 4e 49 | 51 55 45 28 20 25 32 20 |LETE UNI|QUE( %2 |
|000049d0| 29 00 00 00 41 4c 54 45 | 52 20 54 41 42 4c 45 20 |)...ALTE|R TABLE |
|000049e0| 25 31 20 41 44 44 20 25 | 32 20 46 4f 52 45 49 47 |%1 ADD %|2 FOREIG|
|000049f0| 4e 20 4b 45 59 20 22 25 | 33 22 20 25 34 20 52 45 |N KEY "%|3" %4 RE|
|00004a00| 46 45 52 45 4e 43 45 53 | 20 25 35 20 25 36 20 25 |FERENCES| %5 %6 %|
|00004a10| 37 20 25 38 00 4f 4e 20 | 55 50 44 41 54 45 20 25 |7 %8.ON |UPDATE %|
|00004a20| 31 00 4f 4e 20 44 45 4c | 45 54 45 20 25 31 00 52 |1.ON DEL|ETE %1.R|
|00004a30| 45 53 54 52 49 43 54 00 | 43 41 53 43 41 44 45 00 |ESTRICT.|CASCADE.|
|00004a40| 53 45 54 20 4e 55 4c 4c | 00 53 45 54 20 44 45 46 |SET NULL|.SET DEF|
|00004a50| 41 55 4c 54 00 20 43 48 | 45 43 4b 20 4f 4e 20 43 |AULT. CH|ECK ON C|
|00004a60| 4f 4d 4d 49 54 00 4e 4f | 54 20 4e 55 4c 4c 00 00 |OMMIT.NO|T NULL..|
|00004a70| 41 4c 54 45 52 20 54 41 | 42 4c 45 20 25 31 20 41 |ALTER TA|BLE %1 A|
|00004a80| 44 44 20 25 32 20 46 4f | 52 45 49 47 4e 20 4b 45 |DD %2 FO|REIGN KE|
|00004a90| 59 20 22 25 33 22 20 25 | 34 20 52 45 46 45 52 45 |Y "%3" %|4 REFERE|
|00004aa0| 4e 43 45 53 20 25 35 20 | 25 36 20 25 37 20 25 38 |NCES %5 |%6 %7 %8|
|00004ab0| 00 4f 4e 20 55 50 44 41 | 54 45 20 25 31 00 4f 4e |.ON UPDA|TE %1.ON|
|00004ac0| 20 44 45 4c 45 54 45 20 | 25 31 00 52 45 53 54 52 | DELETE |%1.RESTR|
|00004ad0| 49 43 54 00 43 41 53 43 | 41 44 45 00 53 45 54 20 |ICT.CASC|ADE.SET |
|00004ae0| 4e 55 4c 4c 00 53 45 54 | 20 44 45 46 41 55 4c 54 |NULL.SET| DEFAULT|
|00004af0| 00 20 43 48 45 43 4b 20 | 4f 4e 20 43 4f 4d 4d 49 |. CHECK |ON COMMI|
|00004b00| 54 00 4e 4f 54 20 4e 55 | 4c 4c 00 00 28 20 25 31 |T.NOT NU|LL..( %1|
|00004b10| 20 29 00 2c 20 00 22 00 | 22 00 53 45 4c 45 43 54 | )., .".|".SELECT|
|00004b20| 20 63 68 65 63 6b 5f 6f | 6e 5f 63 6f 6d 6d 69 74 | check_o|n_commit|
|00004b30| 2c 20 6e 75 6c 6c 73 2c | 20 28 53 45 4c 45 43 54 |, nulls,| (SELECT|
|00004b40| 20 72 65 66 65 72 65 6e | 74 69 61 6c 5f 61 63 74 | referen|tial_act|
|00004b50| 69 6f 6e 20 46 52 4f 4d | 20 53 59 53 54 52 49 47 |ion FROM| SYSTRIG|
|00004b60| 47 45 52 20 57 48 45 52 | 45 20 53 59 53 54 52 49 |GER WHER|E SYSTRI|
|00004b70| 47 47 45 52 2e 66 6f 72 | 65 69 67 6e 5f 74 61 62 |GGER.for|eign_tab|
|00004b80| 6c 65 5f 69 64 20 3d 20 | 41 2e 66 6f 72 65 69 67 |le_id = |A.foreig|
|00004b90| 6e 5f 74 61 62 6c 65 5f | 69 64 20 41 4e 44 20 53 |n_table_|id AND S|
|00004ba0| 59 53 54 52 49 47 47 45 | 52 2e 66 6f 72 65 69 67 |YSTRIGGE|R.foreig|
|00004bb0| 6e 5f 6b 65 79 5f 69 64 | 20 3d 20 41 2e 66 6f 72 |n_key_id| = A.for|
|00004bc0| 65 69 67 6e 5f 6b 65 79 | 5f 69 64 20 41 4e 44 20 |eign_key|_id AND |
|00004bd0| 65 76 65 6e 74 20 3d 20 | 27 44 27 29 2c 20 28 53 |event = |'D'), (S|
|00004be0| 45 4c 45 43 54 20 72 65 | 66 65 72 65 6e 74 69 61 |ELECT re|ferentia|
|00004bf0| 6c 5f 61 63 74 69 6f 6e | 20 46 52 4f 4d 20 53 59 |l_action| FROM SY|
|00004c00| 53 54 52 49 47 47 45 52 | 20 57 48 45 52 45 20 53 |STRIGGER| WHERE S|
|00004c10| 59 53 54 52 49 47 47 45 | 52 2e 66 6f 72 65 69 67 |YSTRIGGE|R.foreig|
|00004c20| 6e 5f 74 61 62 6c 65 5f | 69 64 20 3d 20 41 2e 66 |n_table_|id = A.f|
|00004c30| 6f 72 65 69 67 6e 5f 74 | 61 62 6c 65 5f 69 64 20 |oreign_t|able_id |
|00004c40| 41 4e 44 20 53 59 53 54 | 52 49 47 47 45 52 2e 66 |AND SYST|RIGGER.f|
|00004c50| 6f 72 65 69 67 6e 5f 6b | 65 79 5f 69 64 20 3d 20 |oreign_k|ey_id = |
|00004c60| 41 2e 66 6f 72 65 69 67 | 6e 5f 6b 65 79 5f 69 64 |A.foreig|n_key_id|
|00004c70| 20 41 4e 44 20 65 76 65 | 6e 74 20 3d 20 27 43 27 | AND eve|nt = 'C'|
|00004c80| 29 20 46 52 4f 4d 20 53 | 59 53 46 4f 52 45 49 47 |) FROM S|YSFOREIG|
|00004c90| 4e 4b 45 59 20 41 20 57 | 48 45 52 45 20 66 6f 72 |NKEY A W|HERE for|
|00004ca0| 65 69 67 6e 5f 74 61 62 | 6c 65 5f 69 64 20 3d 20 |eign_tab|le_id = |
|00004cb0| 25 31 20 41 4e 44 20 66 | 6f 72 65 69 67 6e 5f 6b |%1 AND f|oreign_k|
|00004cc0| 65 79 5f 69 64 20 3d 20 | 25 32 00 59 00 59 00 43 |ey_id = |%2.Y.Y.C|
|00004cd0| 00 44 00 4e 00 43 00 44 | 00 4e 00 53 45 4c 45 43 |.D.N.C.D|.N.SELEC|
|00004ce0| 54 20 28 53 45 4c 45 43 | 54 20 63 6f 6c 75 6d 6e |T (SELEC|T column|
|00004cf0| 5f 6e 61 6d 65 20 46 52 | 4f 4d 20 53 59 53 43 4f |_name FR|OM SYSCO|
|00004d00| 4c 55 4d 4e 20 57 48 45 | 52 45 20 63 6f 6c 75 6d |LUMN WHE|RE colum|
|00004d10| 6e 5f 69 64 20 3d 20 42 | 2e 66 6f 72 65 69 67 6e |n_id = B|.foreign|
|00004d20| 5f 63 6f 6c 75 6d 6e 5f | 69 64 20 41 4e 44 20 74 |_column_|id AND t|
|00004d30| 61 62 6c 65 5f 69 64 20 | 3d 20 42 2e 66 6f 72 65 |able_id |= B.fore|
|00004d40| 69 67 6e 5f 74 61 62 6c | 65 5f 69 64 29 2c 20 63 |ign_tabl|e_id), c|
|00004d50| 6f 6c 75 6d 6e 5f 6e 61 | 6d 65 20 46 52 4f 4d 20 |olumn_na|me FROM |
|00004d60| 28 53 59 53 46 4f 52 45 | 49 47 4e 4b 45 59 20 41 |(SYSFORE|IGNKEY A|
|00004d70| 20 4a 4f 49 4e 20 53 59 | 53 46 4b 43 4f 4c 20 42 | JOIN SY|SFKCOL B|
|00004d80| 29 20 4a 4f 49 4e 20 53 | 59 53 43 4f 4c 55 4d 4e |) JOIN S|YSCOLUMN|
|00004d90| 20 43 20 6f 6e 20 70 72 | 69 6d 61 72 79 5f 74 61 | C on pr|imary_ta|
|00004da0| 62 6c 65 5f 69 64 20 3d | 20 74 61 62 6c 65 5f 69 |ble_id =| table_i|
|00004db0| 64 20 57 48 45 52 45 20 | 41 2e 66 6f 72 65 69 67 |d WHERE |A.foreig|
|00004dc0| 6e 5f 74 61 62 6c 65 5f | 69 64 20 3d 20 25 31 20 |n_table_|id = %1 |
|00004dd0| 41 4e 44 20 42 2e 70 72 | 69 6d 61 72 79 5f 63 6f |AND B.pr|imary_co|
|00004de0| 6c 75 6d 6e 5f 69 64 20 | 3d 20 63 6f 6c 75 6d 6e |lumn_id |= column|
|00004df0| 5f 69 64 20 41 4e 44 20 | 42 2e 66 6f 72 65 69 67 |_id AND |B.foreig|
|00004e00| 6e 5f 6b 65 79 5f 69 64 | 20 3d 25 32 20 4f 52 44 |n_key_id| =%2 ORD|
|00004e10| 45 52 20 42 59 20 42 2e | 66 6f 72 65 69 67 6e 5f |ER BY B.|foreign_|
|00004e20| 63 6f 6c 75 6d 6e 5f 69 | 64 00 41 4c 54 45 52 20 |column_i|d.ALTER |
|00004e30| 54 41 42 4c 45 20 25 31 | 20 44 45 4c 45 54 45 20 |TABLE %1| DELETE |
|00004e40| 46 4f 52 45 49 47 4e 20 | 4b 45 59 20 22 25 32 22 |FOREIGN |KEY "%2"|
|00004e50| 00 43 4f 4d 4d 45 4e 54 | 20 4f 4e 20 46 4f 52 45 |.COMMENT| ON FORE|
|00004e60| 49 47 4e 20 4b 45 59 20 | 25 31 2e 22 25 32 22 20 |IGN KEY |%1."%2" |
|00004e70| 49 53 20 22 25 33 22 00 | 43 4f 4d 4d 45 4e 54 20 |IS "%3".|COMMENT |
|00004e80| 4f 4e 20 46 4f 52 45 49 | 47 4e 20 4b 45 59 20 25 |ON FOREI|GN KEY %|
|00004e90| 31 2e 22 25 32 22 20 49 | 53 20 4e 55 4c 4c 00 41 |1."%2" I|S NULL.A|
|00004ea0| 4c 54 45 52 20 54 41 42 | 4c 45 20 25 31 20 44 45 |LTER TAB|LE %1 DE|
|00004eb0| 4c 45 54 45 20 46 4f 52 | 45 49 47 4e 20 4b 45 59 |LETE FOR|EIGN KEY|
|00004ec0| 20 22 25 32 22 00 53 45 | 4c 45 43 54 20 72 6f 6c | "%2".SE|LECT rol|
|00004ed0| 65 2c 20 72 65 6d 61 72 | 6b 73 2c 20 66 6f 72 65 |e, remar|ks, fore|
|00004ee0| 69 67 6e 5f 6b 65 79 5f | 69 64 2c 20 70 72 69 6d |ign_key_|id, prim|
|00004ef0| 61 72 79 5f 74 61 62 6c | 65 5f 69 64 20 46 52 4f |ary_tabl|e_id FRO|
|00004f00| 4d 20 53 59 53 46 4f 52 | 45 49 47 4e 4b 45 59 20 |M SYSFOR|EIGNKEY |
|00004f10| 57 48 45 52 45 20 66 6f | 72 65 69 67 6e 5f 74 61 |WHERE fo|reign_ta|
|00004f20| 62 6c 65 5f 69 64 20 3d | 20 25 31 00 53 45 4c 45 |ble_id =| %1.SELE|
|00004f30| 43 54 20 74 61 62 6c 65 | 5f 6e 61 6d 65 2c 20 28 |CT table|_name, (|
|00004f40| 53 45 4c 45 43 54 20 75 | 73 65 72 5f 6e 61 6d 65 |SELECT u|ser_name|
|00004f50| 20 46 52 4f 4d 20 53 59 | 53 55 53 45 52 50 45 52 | FROM SY|SUSERPER|
|00004f60| 4d 53 20 6a 6f 69 6e 20 | 53 59 53 54 41 42 4c 45 |MS join |SYSTABLE|
|00004f70| 20 4f 4e 20 75 73 65 72 | 5f 69 64 20 3d 20 63 72 | ON user|_id = cr|
|00004f80| 65 61 74 6f 72 20 57 48 | 45 52 45 20 74 61 62 6c |eator WH|ERE tabl|
|00004f90| 65 5f 69 64 20 3d 20 25 | 31 29 2c 20 53 59 53 54 |e_id = %|1), SYST|
|00004fa0| 41 42 4c 45 2e 72 65 6d | 61 72 6b 73 2c 20 28 49 |ABLE.rem|arks, (I|
|00004fb0| 46 20 74 61 62 6c 65 5f | 74 79 70 65 20 3d 20 27 |F table_|type = '|
|00004fc0| 42 41 53 45 27 20 54 48 | 45 4e 20 27 4e 27 20 45 |BASE' TH|EN 'N' E|
|00004fd0| 4c 53 45 20 27 59 27 20 | 45 4e 44 49 46 29 20 46 |LSE 'Y' |ENDIF) F|
|00004fe0| 52 4f 4d 20 53 59 53 54 | 41 42 4c 45 20 6a 6f 69 |ROM SYST|ABLE joi|
|00004ff0| 6e 20 53 59 53 46 4f 52 | 45 49 47 4e 4b 45 59 20 |n SYSFOR|EIGNKEY |
|00005000| 4f 4e 20 74 61 62 6c 65 | 5f 69 64 20 3d 20 66 6f |ON table|_id = fo|
|00005010| 72 65 69 67 6e 5f 74 61 | 62 6c 65 5f 69 64 20 57 |reign_ta|ble_id W|
|00005020| 48 45 52 45 20 70 72 69 | 6d 61 72 79 5f 74 61 62 |HERE pri|mary_tab|
|00005030| 6c 65 5f 69 64 20 3d 20 | 25 32 00 00 20 00 20 00 |le_id = |%2.. . .|
|00005040| 00 22 00 2c 00 22 00 2c | 00 59 00 47 00 47 00 59 |.".,.".,|.Y.G.G.Y|
|00005050| 00 47 00 47 00 20 57 49 | 54 48 20 47 52 41 4e 54 |.G.G. WI|TH GRANT|
|00005060| 20 4f 50 54 49 4f 4e 00 | 41 4c 4c 00 45 58 45 43 | OPTION.|ALL.EXEC|
|00005070| 55 54 45 00 45 58 45 43 | 55 54 45 00 22 00 2c 00 |UTE.EXEC|UTE.".,.|
|00005080| 22 00 2c 00 53 45 4c 45 | 43 54 20 2a 20 46 52 4f |".,.SELE|CT * FRO|
|00005090| 4d 20 53 59 53 55 53 45 | 52 50 45 52 4d 53 20 57 |M SYSUSE|RPERMS W|
|000050a0| 48 45 52 45 20 75 73 65 | 72 5f 6e 61 6d 65 20 3d |HERE use|r_name =|
|000050b0| 20 27 25 31 27 00 22 00 | 2c 00 73 65 6c 65 63 74 | '%1'.".|,.select|
|000050c0| 20 75 73 65 72 5f 6e 61 | 6d 65 2c 20 72 65 6d 61 | user_na|me, rema|
|000050d0| 72 6b 73 2c 20 75 73 65 | 72 5f 67 72 6f 75 70 2c |rks, use|r_group,|
|000050e0| 20 28 49 46 20 45 58 49 | 53 54 53 28 53 45 4c 45 | (IF EXI|STS(SELE|
|000050f0| 43 54 20 61 64 64 72 65 | 73 73 20 46 52 4f 4d 20 |CT addre|ss FROM |
|00005100| 53 59 53 52 45 4d 4f 54 | 45 55 53 45 52 20 42 20 |SYSREMOT|EUSER B |
|00005110| 57 48 45 52 45 20 41 2e | 75 73 65 72 5f 69 64 20 |WHERE A.|user_id |
|00005120| 3d 20 42 2e 75 73 65 72 | 5f 69 64 20 41 4e 44 20 |= B.user|_id AND |
|00005130| 70 75 62 6c 69 73 68 61 | 75 74 68 20 3d 20 27 4e |publisha|uth = 'N|
|00005140| 27 29 20 54 48 45 4e 20 | 27 59 27 20 45 4c 53 45 |') THEN |'Y' ELSE|
|00005150| 20 27 4e 27 20 45 4e 44 | 49 46 29 2c 20 70 75 62 | 'N' END|IF), pub|
|00005160| 6c 69 73 68 61 75 74 68 | 20 66 72 6f 6d 20 53 59 |lishauth| from SY|
|00005170| 53 55 53 45 52 50 45 52 | 4d 53 20 41 20 77 68 65 |SUSERPER|MS A whe|
|00005180| 72 65 20 75 73 65 72 5f | 6e 61 6d 65 20 3c 3e 20 |re user_|name <> |
|00005190| 27 53 59 53 27 20 6f 72 | 64 65 72 20 62 79 20 75 |'SYS' or|der by u|
|000051a0| 73 65 72 5f 67 72 6f 75 | 70 20 64 65 73 63 2c 20 |ser_grou|p desc, |
|000051b0| 75 73 65 72 5f 6e 61 6d | 65 00 73 65 6c 65 63 74 |user_nam|e.select|
|000051c0| 20 75 73 65 72 5f 6e 61 | 6d 65 2c 20 72 65 6d 61 | user_na|me, rema|
|000051d0| 72 6b 73 2c 20 75 73 65 | 72 5f 67 72 6f 75 70 2c |rks, use|r_group,|
|000051e0| 20 27 4e 27 2c 20 27 4e | 27 66 72 6f 6d 20 53 59 | 'N', 'N|'from SY|
|000051f0| 53 55 53 45 52 50 45 52 | 4d 53 20 77 68 65 72 65 |SUSERPER|MS where|
|00005200| 20 75 73 65 72 5f 6e 61 | 6d 65 20 3c 3e 20 27 53 | user_na|me <> 'S|
|00005210| 59 53 27 20 6f 72 64 65 | 72 20 62 79 20 75 73 65 |YS' orde|r by use|
|00005220| 72 5f 67 72 6f 75 70 20 | 64 65 73 63 2c 20 75 73 |r_group |desc, us|
|00005230| 65 72 5f 6e 61 6d 65 00 | 53 45 4c 45 43 54 20 75 |er_name.|SELECT u|
|00005240| 73 65 72 5f 6e 61 6d 65 | 2c 20 72 65 6d 61 72 6b |ser_name|, remark|
|00005250| 73 20 46 52 4f 4d 20 53 | 59 53 55 53 45 52 50 45 |s FROM S|YSUSERPE|
|00005260| 52 4d 53 20 57 48 45 52 | 45 20 28 75 73 65 72 5f |RMS WHER|E (user_|
|00005270| 69 64 20 4e 4f 54 20 49 | 4e 20 28 53 45 4c 45 43 |id NOT I|N (SELEC|
|00005280| 54 20 75 73 65 72 5f 69 | 64 20 46 52 4f 4d 20 53 |T user_i|d FROM S|
|00005290| 59 53 52 45 4d 4f 54 45 | 55 53 45 52 29 20 4f 52 |YSREMOTE|USER) OR|
|000052a0| 20 70 75 62 6c 69 73 68 | 61 75 74 68 20 3d 20 27 | publish|auth = '|
|000052b0| 59 27 29 20 41 4e 44 20 | 75 73 65 72 5f 6e 61 6d |Y') AND |user_nam|
|000052c0| 65 20 3c 3e 20 27 53 59 | 53 27 00 73 65 6c 65 63 |e <> 'SY|S'.selec|
|000052d0| 74 20 75 73 65 72 5f 69 | 64 2c 20 75 73 65 72 5f |t user_i|d, user_|
|000052e0| 6e 61 6d 65 2c 20 70 61 | 73 73 77 6f 72 64 2c 20 |name, pa|ssword, |
|000052f0| 72 65 73 6f 75 72 63 65 | 61 75 74 68 2c 64 62 61 |resource|auth,dba|
|00005300| 61 75 74 68 2c 20 75 73 | 65 72 5f 67 72 6f 75 70 |auth, us|er_group|
|00005310| 2c 20 72 65 6d 61 72 6b | 73 2c 20 28 53 45 4c 45 |, remark|s, (SELE|
|00005320| 43 54 20 74 79 70 65 5f | 6e 61 6d 65 20 46 52 4f |CT type_|name FRO|
|00005330| 4d 20 53 59 53 52 45 4d | 4f 54 45 55 53 45 52 20 |M SYSREM|OTEUSER |
|00005340| 42 20 4b 45 59 20 4a 4f | 49 4e 20 53 59 53 52 45 |B KEY JO|IN SYSRE|
|00005350| 4d 4f 54 45 54 59 50 45 | 20 57 48 45 52 45 20 42 |MOTETYPE| WHERE B|
|00005360| 2e 75 73 65 72 5f 69 64 | 20 3d 20 41 2e 75 73 65 |.user_id| = A.use|
|00005370| 72 5f 69 64 29 2c 20 28 | 53 45 4c 45 43 54 20 61 |r_id), (|SELECT a|
|00005380| 64 64 72 65 73 73 20 46 | 52 4f 4d 20 53 59 53 52 |ddress F|ROM SYSR|
|00005390| 45 4d 4f 54 45 55 53 45 | 52 20 42 20 57 48 45 52 |EMOTEUSE|R B WHER|
|000053a0| 45 20 42 2e 75 73 65 72 | 5f 69 64 20 3d 20 41 2e |E B.user|_id = A.|
|000053b0| 75 73 65 72 5f 69 64 29 | 2c 20 28 53 45 4c 45 43 |user_id)|, (SELEC|
|000053c0| 54 20 66 72 65 71 75 65 | 6e 63 79 20 46 52 4f 4d |T freque|ncy FROM|
|000053d0| 20 53 59 53 52 45 4d 4f | 54 45 55 53 45 52 20 42 | SYSREMO|TEUSER B|
|000053e0| 20 57 48 45 52 45 20 42 | 2e 75 73 65 72 5f 69 64 | WHERE B|.user_id|
|000053f0| 20 3d 20 41 2e 75 73 65 | 72 5f 69 64 29 2c 20 28 | = A.use|r_id), (|
|00005400| 53 45 4c 45 43 54 20 44 | 41 54 45 46 4f 52 4d 41 |SELECT D|ATEFORMA|
|00005410| 54 28 73 65 6e 64 5f 74 | 69 6d 65 2c 20 27 68 68 |T(send_t|ime, 'hh|
|00005420| 3a 6d 6d 27 29 20 46 52 | 4f 4d 20 53 59 53 52 45 |:mm') FR|OM SYSRE|
|00005430| 4d 4f 54 45 55 53 45 52 | 20 42 20 57 48 45 52 45 |MOTEUSER| B WHERE|
|00005440| 20 42 2e 75 73 65 72 5f | 69 64 20 3d 20 41 2e 75 | B.user_|id = A.u|
|00005450| 73 65 72 5f 69 64 29 2c | 20 28 53 45 4c 45 43 54 |ser_id),| (SELECT|
|00005460| 20 63 6f 6e 73 6f 6c 69 | 64 61 74 65 20 46 52 4f | consoli|date FRO|
|00005470| 4d 20 53 59 53 52 45 4d | 4f 54 45 55 53 45 52 20 |M SYSREM|OTEUSER |
|00005480| 42 20 57 48 45 52 45 20 | 42 2e 75 73 65 72 5f 69 |B WHERE |B.user_i|
|00005490| 64 20 3d 20 41 2e 75 73 | 65 72 5f 69 64 29 2c 20 |d = A.us|er_id), |
|000054a0| 70 75 62 6c 69 73 68 61 | 75 74 68 2c 20 72 65 6d |publisha|uth, rem|
|000054b0| 6f 74 65 64 62 61 61 75 | 74 68 20 66 72 6f 6d 20 |otedbaau|th from |
|000054c0| 53 59 53 55 53 45 52 50 | 45 52 4d 20 41 20 77 68 |SYSUSERP|ERM A wh|
|000054d0| 65 72 65 20 75 73 65 72 | 5f 6e 61 6d 65 20 3d 20 |ere user|_name = |
|000054e0| 27 25 31 27 00 73 65 6c | 65 63 74 20 75 73 65 72 |'%1'.sel|ect user|
|000054f0| 5f 69 64 2c 20 75 73 65 | 72 5f 6e 61 6d 65 2c 20 |_id, use|r_name, |
|00005500| 4e 55 4c 4c 2c 20 72 65 | 73 6f 75 72 63 65 61 75 |NULL, re|sourceau|
|00005510| 74 68 2c 64 62 61 61 75 | 74 68 2c 20 75 73 65 72 |th,dbaau|th, user|
|00005520| 5f 67 72 6f 75 70 2c 20 | 72 65 6d 61 72 6b 73 2c |_group, |remarks,|
|00005530| 20 28 53 45 4c 45 43 54 | 20 74 79 70 65 5f 6e 61 | (SELECT| type_na|
|00005540| 6d 65 20 46 52 4f 4d 20 | 53 59 53 52 45 4d 4f 54 |me FROM |SYSREMOT|
|00005550| 45 55 53 45 52 20 42 20 | 4b 45 59 20 4a 4f 49 4e |EUSER B |KEY JOIN|
|00005560| 20 53 59 53 52 45 4d 4f | 54 45 54 59 50 45 20 57 | SYSREMO|TETYPE W|
|00005570| 48 45 52 45 20 42 2e 75 | 73 65 72 5f 69 64 20 3d |HERE B.u|ser_id =|
|00005580| 20 41 2e 75 73 65 72 5f | 69 64 29 2c 20 28 53 45 | A.user_|id), (SE|
|00005590| 4c 45 43 54 20 61 64 64 | 72 65 73 73 20 46 52 4f |LECT add|ress FRO|
|000055a0| 4d 20 53 59 53 52 45 4d | 4f 54 45 55 53 45 52 20 |M SYSREM|OTEUSER |
|000055b0| 42 20 57 48 45 52 45 20 | 42 2e 75 73 65 72 5f 69 |B WHERE |B.user_i|
|000055c0| 64 20 3d 20 41 2e 75 73 | 65 72 5f 69 64 29 2c 20 |d = A.us|er_id), |
|000055d0| 28 53 45 4c 45 43 54 20 | 66 72 65 71 75 65 6e 63 |(SELECT |frequenc|
|000055e0| 79 20 46 52 4f 4d 20 53 | 59 53 52 45 4d 4f 54 45 |y FROM S|YSREMOTE|
|000055f0| 55 53 45 52 20 42 20 57 | 48 45 52 45 20 42 2e 75 |USER B W|HERE B.u|
|00005600| 73 65 72 5f 69 64 20 3d | 20 41 2e 75 73 65 72 5f |ser_id =| A.user_|
|00005610| 69 64 29 2c 20 28 53 45 | 4c 45 43 54 20 44 41 54 |id), (SE|LECT DAT|
|00005620| 45 46 4f 52 4d 41 54 28 | 73 65 6e 64 5f 74 69 6d |EFORMAT(|send_tim|
|00005630| 65 2c 20 27 68 68 3a 6d | 6d 27 29 20 46 52 4f 4d |e, 'hh:m|m') FROM|
|00005640| 20 53 59 53 52 45 4d 4f | 54 45 55 53 45 52 20 42 | SYSREMO|TEUSER B|
|00005650| 20 57 48 45 52 45 20 42 | 2e 75 73 65 72 5f 69 64 | WHERE B|.user_id|
|00005660| 20 3d 20 41 2e 75 73 65 | 72 5f 69 64 29 2c 20 28 | = A.use|r_id), (|
|00005670| 53 45 4c 45 43 54 20 63 | 6f 6e 73 6f 6c 69 64 61 |SELECT c|onsolida|
|00005680| 74 65 20 46 52 4f 4d 20 | 53 59 53 52 45 4d 4f 54 |te FROM |SYSREMOT|
|00005690| 45 55 53 45 52 20 42 20 | 57 48 45 52 45 20 42 2e |EUSER B |WHERE B.|
|000056a0| 75 73 65 72 5f 69 64 20 | 3d 20 41 2e 75 73 65 72 |user_id |= A.user|
|000056b0| 5f 69 64 29 2c 20 70 75 | 62 6c 69 73 68 61 75 74 |_id), pu|blishaut|
|000056c0| 68 2c 20 72 65 6d 6f 74 | 65 64 62 61 61 75 74 68 |h, remot|edbaauth|
|000056d0| 20 66 72 6f 6d 20 53 59 | 53 55 53 45 52 50 45 52 | from SY|SUSERPER|
|000056e0| 4d 53 20 41 20 77 68 65 | 72 65 20 75 73 65 72 5f |MS A whe|re user_|
|000056f0| 6e 61 6d 65 20 3d 20 27 | 25 31 27 00 73 65 6c 65 |name = '|%1'.sele|
|00005700| 63 74 20 75 73 65 72 5f | 69 64 2c 20 75 73 65 72 |ct user_|id, user|
|00005710| 5f 6e 61 6d 65 2c 20 70 | 61 73 73 77 6f 72 64 2c |_name, p|assword,|
|00005720| 20 72 65 73 6f 75 72 63 | 65 61 75 74 68 2c 64 62 | resourc|eauth,db|
|00005730| 61 61 75 74 68 2c 20 75 | 73 65 72 5f 67 72 6f 75 |aauth, u|ser_grou|
|00005740| 70 2c 20 72 65 6d 61 72 | 6b 73 2c 20 4e 55 4c 4c |p, remar|ks, NULL|
|00005750| 2c 20 4e 55 4c 4c 2c 20 | 4e 55 4c 4c 2c 20 4e 55 |, NULL, |NULL, NU|
|00005760| 4c 4c 2c 20 4e 55 4c 4c | 2c 20 27 4e 27 2c 20 27 |LL, NULL|, 'N', '|
|00005770| 4e 27 66 72 6f 6d 20 53 | 59 53 55 53 45 52 50 45 |N'from S|YSUSERPE|
|00005780| 52 4d 20 41 20 77 68 65 | 72 65 20 75 73 65 72 5f |RM A whe|re user_|
|00005790| 6e 61 6d 65 20 3d 20 27 | 25 31 27 00 73 65 6c 65 |name = '|%1'.sele|
|000057a0| 63 74 20 75 73 65 72 5f | 69 64 2c 20 75 73 65 72 |ct user_|id, user|
|000057b0| 5f 6e 61 6d 65 2c 20 4e | 55 4c 4c 2c 20 72 65 73 |_name, N|ULL, res|
|000057c0| 6f 75 72 63 65 61 75 74 | 68 2c 64 62 61 61 75 74 |ourceaut|h,dbaaut|
|000057d0| 68 2c 20 75 73 65 72 5f | 67 72 6f 75 70 2c 20 72 |h, user_|group, r|
|000057e0| 65 6d 61 72 6b 73 2c 20 | 4e 55 4c 4c 2c 20 4e 55 |emarks, |NULL, NU|
|000057f0| 4c 4c 2c 20 4e 55 4c 4c | 2c 20 4e 55 4c 4c 2c 20 |LL, NULL|, NULL, |
|00005800| 4e 55 4c 4c 2c 20 27 4e | 27 2c 20 27 4e 27 66 72 |NULL, 'N|', 'N'fr|
|00005810| 6f 6d 20 53 59 53 55 53 | 45 52 50 45 52 4d 53 20 |om SYSUS|ERPERMS |
|00005820| 41 20 77 68 65 72 65 20 | 75 73 65 72 5f 6e 61 6d |A where |user_nam|
|00005830| 65 20 3d 20 27 25 31 27 | 00 72 65 76 6f 6b 65 20 |e = '%1'|.revoke |
|00005840| 63 6f 6e 6e 65 63 74 20 | 66 72 6f 6d 20 25 31 00 |connect |from %1.|
|00005850| 47 52 41 4e 54 20 43 4f | 4e 4e 45 43 54 20 54 4f |GRANT CO|NNECT TO|
|00005860| 20 22 25 31 22 20 49 44 | 45 4e 54 49 46 49 45 44 | "%1" ID|ENTIFIED|
|00005870| 20 42 59 20 27 25 32 27 | 00 47 52 41 4e 54 20 43 | BY '%2'|.GRANT C|
|00005880| 4f 4e 4e 45 43 54 20 54 | 4f 20 22 25 31 22 00 43 |ONNECT T|O "%1".C|
|00005890| 4f 4d 4d 45 4e 54 20 4f | 4e 20 55 53 45 52 20 22 |OMMENT O|N USER "|
|000058a0| 25 31 22 20 69 73 20 22 | 25 32 22 00 43 4f 4d 4d |%1" is "|%2".COMM|
|000058b0| 45 4e 54 20 4f 4e 20 55 | 53 45 52 20 22 25 31 22 |ENT ON U|SER "%1"|
|000058c0| 20 69 73 20 4e 55 4c 4c | 00 47 52 41 4e 54 20 44 | is NULL|.GRANT D|
|000058d0| 42 41 20 54 4f 20 22 25 | 31 22 00 52 45 56 4f 4b |BA TO "%|1".REVOK|
|000058e0| 45 20 44 42 41 20 46 52 | 4f 4d 20 22 25 31 22 00 |E DBA FR|OM "%1".|
|000058f0| 47 52 41 4e 54 20 52 45 | 53 4f 55 52 43 45 20 54 |GRANT RE|SOURCE T|
|00005900| 4f 20 22 25 31 22 00 52 | 45 56 4f 4b 45 20 52 45 |O "%1".R|EVOKE RE|
|00005910| 53 4f 55 52 43 45 20 46 | 52 4f 4d 20 22 25 31 22 |SOURCE F|ROM "%1"|
|00005920| 00 47 52 41 4e 54 20 47 | 52 4f 55 50 20 54 4f 20 |.GRANT G|ROUP TO |
|00005930| 22 25 31 22 00 52 45 56 | 4f 4b 45 20 47 52 4f 55 |"%1".REV|OKE GROU|
|00005940| 50 20 46 52 4f 4d 20 22 | 25 31 22 00 47 52 41 4e |P FROM "|%1".GRAN|
|00005950| 54 20 52 45 4d 4f 54 45 | 20 44 42 41 20 54 4f 20 |T REMOTE| DBA TO |
|00005960| 22 25 31 22 00 52 45 56 | 4f 4b 45 20 52 45 4d 4f |"%1".REV|OKE REMO|
|00005970| 54 45 20 44 42 41 20 46 | 52 4f 4d 20 22 25 31 22 |TE DBA F|ROM "%1"|
|00005980| 00 47 52 41 4e 54 20 4d | 45 4d 42 45 52 53 48 49 |.GRANT M|EMBERSHI|
|00005990| 50 20 49 4e 20 47 52 4f | 55 50 20 25 31 20 54 4f |P IN GRO|UP %1 TO|
|000059a0| 20 22 25 32 22 00 52 45 | 56 4f 4b 45 20 4d 45 4d | "%2".RE|VOKE MEM|
|000059b0| 42 45 52 53 48 49 50 20 | 49 4e 20 47 52 4f 55 50 |BERSHIP |IN GROUP|
|000059c0| 20 25 31 20 46 52 4f 4d | 20 22 25 32 22 00 67 72 | %1 FROM| "%2".gr|
|000059d0| 61 6e 74 20 25 31 20 6f | 6e 20 25 32 20 74 6f 20 |ant %1 o|n %2 to |
|000059e0| 22 25 33 22 00 72 65 76 | 6f 6b 65 20 25 31 20 6f |"%3".rev|oke %1 o|
|000059f0| 6e 20 25 32 20 66 72 6f | 6d 20 22 25 33 22 00 73 |n %2 fro|m "%3".s|
|00005a00| 65 6c 65 63 74 20 67 72 | 6f 75 70 5f 6e 61 6d 65 |elect gr|oup_name|
|00005a10| 2c 20 72 65 6d 61 72 6b | 73 20 66 72 6f 6d 20 53 |, remark|s from S|
|00005a20| 59 53 47 52 4f 55 50 53 | 2c 20 53 59 53 55 53 45 |YSGROUPS|, SYSUSE|
|00005a30| 52 50 45 52 4d 53 20 77 | 68 65 72 65 20 6d 65 6d |RPERMS w|here mem|
|00005a40| 62 65 72 5f 6e 61 6d 65 | 20 3d 20 27 25 31 27 20 |ber_name| = '%1' |
|00005a50| 61 6e 64 20 67 72 6f 75 | 70 5f 6e 61 6d 65 20 3d |and grou|p_name =|
|00005a60| 20 75 73 65 72 5f 6e 61 | 6d 65 20 61 6e 64 20 67 | user_na|me and g|
|00005a70| 72 6f 75 70 5f 6e 61 6d | 65 20 3c 3e 20 27 53 59 |roup_nam|e <> 'SY|
|00005a80| 53 27 20 6f 72 64 65 72 | 20 62 79 20 67 72 6f 75 |S' order| by grou|
|00005a90| 70 5f 6e 61 6d 65 00 73 | 65 6c 65 63 74 20 74 61 |p_name.s|elect ta|
|00005aa0| 62 6c 65 5f 6e 61 6d 65 | 2c 20 53 59 53 55 53 45 |ble_name|, SYSUSE|
|00005ab0| 52 50 45 52 4d 53 2e 75 | 73 65 72 5f 6e 61 6d 65 |RPERMS.u|ser_name|
|00005ac0| 2c 20 73 65 6c 65 63 74 | 61 75 74 68 2c 20 69 6e |, select|auth, in|
|00005ad0| 73 65 72 74 61 75 74 68 | 2c 20 64 65 6c 65 74 65 |sertauth|, delete|
|00005ae0| 61 75 74 68 2c 20 75 70 | 64 61 74 65 61 75 74 68 |auth, up|dateauth|
|00005af0| 2c 20 61 6c 74 65 72 61 | 75 74 68 2c 20 72 65 66 |, altera|uth, ref|
|00005b00| 65 72 65 6e 63 65 61 75 | 74 68 2c 20 28 20 73 65 |erenceau|th, ( se|
|00005b10| 6c 65 63 74 20 73 75 6d | 28 20 64 69 73 74 69 6e |lect sum|( distin|
|00005b20| 63 74 20 70 72 69 76 69 | 6c 65 67 65 5f 74 79 70 |ct privi|lege_typ|
|00005b30| 65 20 29 20 66 72 6f 6d | 20 53 59 53 43 4f 4c 50 |e ) from| SYSCOLP|
|00005b40| 45 52 4d 20 77 68 65 72 | 65 20 53 59 53 43 4f 4c |ERM wher|e SYSCOL|
|00005b50| 50 45 52 4d 2e 74 61 62 | 6c 65 5f 69 64 20 3d 20 |PERM.tab|le_id = |
|00005b60| 74 2e 74 61 62 6c 65 5f | 69 64 20 61 6e 64 20 53 |t.table_|id and S|
|00005b70| 59 53 55 53 45 52 50 45 | 52 4d 53 2e 75 73 65 72 |YSUSERPE|RMS.user|
|00005b80| 5f 69 64 20 3d 20 67 72 | 61 6e 74 65 65 20 29 20 |_id = gr|antee ) |
|00005b90| 66 72 6f 6d 20 53 59 53 | 54 41 42 4c 45 20 74 20 |from SYS|TABLE t |
|00005ba0| 6a 6f 69 6e 20 53 59 53 | 55 53 45 52 50 45 52 4d |join SYS|USERPERM|
|00005bb0| 53 20 6c 65 66 74 20 6f | 75 74 65 72 20 6a 6f 69 |S left o|uter joi|
|00005bc0| 6e 20 28 53 59 53 54 41 | 42 4c 45 50 45 52 4d 20 |n (SYSTA|BLEPERM |
|00005bd0| 74 70 20 3d 3d 20 53 59 | 53 55 53 45 52 50 45 52 |tp == SY|SUSERPER|
|00005be0| 4d 53 20 75 70 20 6f 6e | 20 67 72 61 6e 74 65 65 |MS up on| grantee|
|00005bf0| 20 3d 20 75 70 2e 75 73 | 65 72 5f 69 64 29 20 6f | = up.us|er_id) o|
|00005c00| 6e 20 74 70 2e 73 74 61 | 62 6c 65 5f 69 64 20 3d |n tp.sta|ble_id =|
|00005c10| 20 74 2e 74 61 62 6c 65 | 5f 69 64 20 61 6e 64 20 | t.table|_id and |
|00005c20| 75 70 2e 75 73 65 72 5f | 6e 61 6d 65 20 3d 20 27 |up.user_|name = '|
|00005c30| 25 31 27 20 77 68 65 72 | 65 20 74 61 62 6c 65 5f |%1' wher|e table_|
|00005c40| 74 79 70 65 20 3d 20 27 | 42 41 53 45 27 20 61 6e |type = '|BASE' an|
|00005c50| 64 20 28 53 59 53 55 53 | 45 52 50 45 52 4d 53 2e |d (SYSUS|ERPERMS.|
|00005c60| 75 73 65 72 5f 6e 61 6d | 65 20 6e 6f 74 20 69 6e |user_nam|e not in|
|00005c70| 20 28 27 44 42 4f 27 2c | 27 53 59 53 27 29 20 29 | ('DBO',|'SYS') )|
|00005c80| 20 6f 72 64 65 72 20 62 | 79 20 74 61 62 6c 65 5f | order b|y table_|
|00005c90| 6e 61 6d 65 2c 20 63 72 | 65 61 74 6f 72 20 00 73 |name, cr|eator .s|
|00005ca0| 65 6c 65 63 74 20 74 61 | 62 6c 65 5f 6e 61 6d 65 |elect ta|ble_name|
|00005cb0| 2c 20 53 59 53 55 53 45 | 52 50 45 52 4d 53 2e 75 |, SYSUSE|RPERMS.u|
|00005cc0| 73 65 72 5f 6e 61 6d 65 | 2c 20 73 65 6c 65 63 74 |ser_name|, select|
|00005cd0| 61 75 74 68 2c 20 69 6e | 73 65 72 74 61 75 74 68 |auth, in|sertauth|
|00005ce0| 2c 20 64 65 6c 65 74 65 | 61 75 74 68 2c 20 75 70 |, delete|auth, up|
|00005cf0| 64 61 74 65 61 75 74 68 | 2c 20 61 6c 74 65 72 61 |dateauth|, altera|
|00005d00| 75 74 68 2c 20 72 65 66 | 65 72 65 6e 63 65 61 75 |uth, ref|erenceau|
|00005d10| 74 68 2c 20 28 20 69 66 | 20 75 70 64 61 74 65 63 |th, ( if| updatec|
|00005d20| 6f 6c 73 20 3d 20 27 59 | 27 20 74 68 65 6e 20 38 |ols = 'Y|' then 8|
|00005d30| 20 65 6c 73 65 20 30 20 | 65 6e 64 69 66 20 29 20 | else 0 |endif ) |
|00005d40| 66 72 6f 6d 20 53 59 53 | 54 41 42 4c 45 20 74 20 |from SYS|TABLE t |
|00005d50| 6a 6f 69 6e 20 53 59 53 | 55 53 45 52 50 45 52 4d |join SYS|USERPERM|
|00005d60| 53 20 6c 65 66 74 20 6f | 75 74 65 72 20 6a 6f 69 |S left o|uter joi|
|00005d70| 6e 20 28 53 59 53 54 41 | 42 4c 45 50 45 52 4d 20 |n (SYSTA|BLEPERM |
|00005d80| 74 70 20 3d 3d 20 53 59 | 53 55 53 45 52 50 45 52 |tp == SY|SUSERPER|
|00005d90| 4d 53 20 75 70 20 6f 6e | 20 67 72 61 6e 74 65 65 |MS up on| grantee|
|00005da0| 20 3d 20 75 70 2e 75 73 | 65 72 5f 69 64 29 20 6f | = up.us|er_id) o|
|00005db0| 6e 20 74 70 2e 73 74 61 | 62 6c 65 5f 69 64 20 3d |n tp.sta|ble_id =|
|00005dc0| 20 74 2e 74 61 62 6c 65 | 5f 69 64 20 61 6e 64 20 | t.table|_id and |
|00005dd0| 75 70 2e 75 73 65 72 5f | 6e 61 6d 65 20 3d 20 27 |up.user_|name = '|
|00005de0| 25 31 27 20 77 68 65 72 | 65 20 74 61 62 6c 65 5f |%1' wher|e table_|
|00005df0| 74 79 70 65 20 3d 20 27 | 42 41 53 45 27 20 61 6e |type = '|BASE' an|
|00005e00| 64 20 28 53 59 53 55 53 | 45 52 50 45 52 4d 53 2e |d (SYSUS|ERPERMS.|
|00005e10| 75 73 65 72 5f 6e 61 6d | 65 20 6e 6f 74 20 69 6e |user_nam|e not in|
|00005e20| 20 28 27 44 42 4f 27 2c | 27 53 59 53 27 29 20 29 | ('DBO',|'SYS') )|
|00005e30| 20 6f 72 64 65 72 20 62 | 79 20 74 61 62 6c 65 5f | order b|y table_|
|00005e40| 6e 61 6d 65 2c 20 63 72 | 65 61 74 6f 72 20 00 73 |name, cr|eator .s|
|00005e50| 65 6c 65 63 74 20 74 61 | 62 6c 65 5f 6e 61 6d 65 |elect ta|ble_name|
|00005e60| 2c 20 53 59 53 55 53 45 | 52 50 45 52 4d 53 2e 75 |, SYSUSE|RPERMS.u|
|00005e70| 73 65 72 5f 6e 61 6d 65 | 2c 20 73 65 6c 65 63 74 |ser_name|, select|
|00005e80| 61 75 74 68 2c 20 69 6e | 73 65 72 74 61 75 74 68 |auth, in|sertauth|
|00005e90| 2c 20 64 65 6c 65 74 65 | 61 75 74 68 2c 20 75 70 |, delete|auth, up|
|00005ea0| 64 61 74 65 61 75 74 68 | 2c 20 61 6c 74 65 72 61 |dateauth|, altera|
|00005eb0| 75 74 68 2c 20 72 65 66 | 65 72 65 6e 63 65 61 75 |uth, ref|erenceau|
|00005ec0| 74 68 2c 20 28 20 73 65 | 6c 65 63 74 20 73 75 6d |th, ( se|lect sum|
|00005ed0| 28 20 64 69 73 74 69 6e | 63 74 20 70 72 69 76 69 |( distin|ct privi|
|00005ee0| 6c 65 67 65 5f 74 79 70 | 65 20 29 20 66 72 6f 6d |lege_typ|e ) from|
|00005ef0| 20 53 59 53 43 4f 4c 50 | 45 52 4d 20 77 68 65 72 | SYSCOLP|ERM wher|
|00005f00| 65 20 53 59 53 43 4f 4c | 50 45 52 4d 2e 74 61 62 |e SYSCOL|PERM.tab|
|00005f10| 6c 65 5f 69 64 20 3d 20 | 74 2e 74 61 62 6c 65 5f |le_id = |t.table_|
|00005f20| 69 64 20 61 6e 64 20 53 | 59 53 55 53 45 52 50 45 |id and S|YSUSERPE|
|00005f30| 52 4d 53 2e 75 73 65 72 | 5f 69 64 20 3d 20 67 72 |RMS.user|_id = gr|
|00005f40| 61 6e 74 65 65 20 29 20 | 66 72 6f 6d 20 53 59 53 |antee ) |from SYS|
|00005f50| 54 41 42 4c 45 20 74 20 | 6a 6f 69 6e 20 53 59 53 |TABLE t |join SYS|
|00005f60| 55 53 45 52 50 45 52 4d | 53 20 6c 65 66 74 20 6f |USERPERM|S left o|
|00005f70| 75 74 65 72 20 6a 6f 69 | 6e 20 28 53 59 53 54 41 |uter joi|n (SYSTA|
|00005f80| 42 4c 45 50 45 52 4d 20 | 74 70 20 3d 3d 20 53 59 |BLEPERM |tp == SY|
|00005f90| 53 55 53 45 52 50 45 52 | 4d 53 20 75 70 20 6f 6e |SUSERPER|MS up on|
|00005fa0| 20 67 72 61 6e 74 65 65 | 20 3d 20 75 70 2e 75 73 | grantee| = up.us|
|00005fb0| 65 72 5f 69 64 29 20 6f | 6e 20 74 70 2e 73 74 61 |er_id) o|n tp.sta|
|00005fc0| 62 6c 65 5f 69 64 20 3d | 20 74 2e 74 61 62 6c 65 |ble_id =| t.table|
|00005fd0| 5f 69 64 20 61 6e 64 20 | 75 70 2e 75 73 65 72 5f |_id and |up.user_|
|00005fe0| 6e 61 6d 65 20 3d 20 27 | 25 31 27 20 77 68 65 72 |name = '|%1' wher|
|00005ff0| 65 20 74 61 62 6c 65 5f | 74 79 70 65 20 3d 20 27 |e table_|type = '|
|00006000| 56 49 45 57 27 20 61 6e | 64 20 28 53 59 53 55 53 |VIEW' an|d (SYSUS|
|00006010| 45 52 50 45 52 4d 53 2e | 75 73 65 72 5f 6e 61 6d |ERPERMS.|user_nam|
|00006020| 65 20 6e 6f 74 20 69 6e | 20 28 27 44 42 4f 27 2c |e not in| ('DBO',|
|00006030| 27 53 59 53 27 29 20 29 | 20 6f 72 64 65 72 20 62 |'SYS') )| order b|
|00006040| 79 20 74 61 62 6c 65 5f | 6e 61 6d 65 2c 20 63 72 |y table_|name, cr|
|00006050| 65 61 74 6f 72 20 00 73 | 65 6c 65 63 74 20 74 61 |eator .s|elect ta|
|00006060| 62 6c 65 5f 6e 61 6d 65 | 2c 20 53 59 53 55 53 45 |ble_name|, SYSUSE|
|00006070| 52 50 45 52 4d 53 2e 75 | 73 65 72 5f 6e 61 6d 65 |RPERMS.u|ser_name|
|00006080| 2c 20 73 65 6c 65 63 74 | 61 75 74 68 2c 20 69 6e |, select|auth, in|
|00006090| 73 65 72 74 61 75 74 68 | 2c 20 64 65 6c 65 74 65 |sertauth|, delete|
|000060a0| 61 75 74 68 2c 20 75 70 | 64 61 74 65 61 75 74 68 |auth, up|dateauth|
|000060b0| 2c 20 61 6c 74 65 72 61 | 75 74 68 2c 20 72 65 66 |, altera|uth, ref|
|000060c0| 65 72 65 6e 63 65 61 75 | 74 68 2c 20 28 20 69 66 |erenceau|th, ( if|
|000060d0| 20 75 70 64 61 74 65 63 | 6f 6c 73 20 3d 20 27 59 | updatec|ols = 'Y|
|000060e0| 27 20 74 68 65 6e 20 38 | 20 65 6c 73 65 20 30 20 |' then 8| else 0 |
|000060f0| 65 6e 64 69 66 20 29 20 | 66 72 6f 6d 20 53 59 53 |endif ) |from SYS|
|00006100| 54 41 42 4c 45 20 74 20 | 6a 6f 69 6e 20 53 59 53 |TABLE t |join SYS|
|00006110| 55 53 45 52 50 45 52 4d | 53 20 6c 65 66 74 20 6f |USERPERM|S left o|
|00006120| 75 74 65 72 20 6a 6f 69 | 6e 20 28 53 59 53 54 41 |uter joi|n (SYSTA|
|00006130| 42 4c 45 50 45 52 4d 20 | 74 70 20 3d 3d 20 53 59 |BLEPERM |tp == SY|
|00006140| 53 55 53 45 52 50 45 52 | 4d 53 20 75 70 20 6f 6e |SUSERPER|MS up on|
|00006150| 20 67 72 61 6e 74 65 65 | 20 3d 20 75 70 2e 75 73 | grantee| = up.us|
|00006160| 65 72 5f 69 64 29 20 6f | 6e 20 74 70 2e 73 74 61 |er_id) o|n tp.sta|
|00006170| 62 6c 65 5f 69 64 20 3d | 20 74 2e 74 61 62 6c 65 |ble_id =| t.table|
|00006180| 5f 69 64 20 61 6e 64 20 | 75 70 2e 75 73 65 72 5f |_id and |up.user_|
|00006190| 6e 61 6d 65 20 3d 20 27 | 25 31 27 20 77 68 65 72 |name = '|%1' wher|
|000061a0| 65 20 74 61 62 6c 65 5f | 74 79 70 65 20 3d 20 27 |e table_|type = '|
|000061b0| 56 49 45 57 27 20 61 6e | 64 20 28 53 59 53 55 53 |VIEW' an|d (SYSUS|
|000061c0| 45 52 50 45 52 4d 53 2e | 75 73 65 72 5f 6e 61 6d |ERPERMS.|user_nam|
|000061d0| 65 20 6e 6f 74 20 69 6e | 20 28 27 44 42 4f 27 2c |e not in| ('DBO',|
|000061e0| 27 53 59 53 27 29 20 29 | 20 6f 72 64 65 72 20 62 |'SYS') )| order b|
|000061f0| 79 20 74 61 62 6c 65 5f | 6e 61 6d 65 2c 20 63 72 |y table_|name, cr|
|00006200| 65 61 74 6f 72 20 00 73 | 65 6c 65 63 74 20 70 72 |eator .s|elect pr|
|00006210| 6f 63 5f 6e 61 6d 65 2c | 20 75 73 65 72 5f 6e 61 |oc_name,| user_na|
|00006220| 6d 65 2c 20 28 20 73 65 | 6c 65 63 74 20 69 66 20 |me, ( se|lect if |
|00006230| 70 72 6f 63 5f 69 64 20 | 69 6e 20 28 20 73 65 6c |proc_id |in ( sel|
|00006240| 65 63 74 20 70 72 6f 63 | 5f 69 64 20 66 72 6f 6d |ect proc|_id from|
|00006250| 20 53 59 53 50 52 4f 43 | 50 45 52 4d 20 6a 6f 69 | SYSPROC|PERM joi|
|00006260| 6e 20 53 59 53 55 53 45 | 52 50 45 52 4d 53 20 77 |n SYSUSE|RPERMS w|
|00006270| 68 65 72 65 20 75 73 65 | 72 5f 6e 61 6d 65 20 3d |here use|r_name =|
|00006280| 20 27 25 31 27 29 20 74 | 68 65 6e 20 27 59 27 20 | '%1') t|hen 'Y' |
|00006290| 65 6c 73 65 20 27 4e 27 | 20 65 6e 64 69 66 20 66 |else 'N'| endif f|
|000062a0| 72 6f 6d 20 44 55 4d 4d | 59 20 29 20 66 72 6f 6d |rom DUMM|Y ) from|
|000062b0| 20 53 59 53 50 52 4f 43 | 45 44 55 52 45 20 6a 6f | SYSPROC|EDURE jo|
|000062c0| 69 6e 20 53 59 53 55 53 | 45 52 50 45 52 4d 53 20 |in SYSUS|ERPERMS |
|000062d0| 77 68 65 72 65 20 28 53 | 59 53 55 53 45 52 50 45 |where (S|YSUSERPE|
|000062e0| 52 4d 53 2e 75 73 65 72 | 5f 6e 61 6d 65 20 6e 6f |RMS.user|_name no|
|000062f0| 74 20 69 6e 20 28 27 44 | 42 4f 27 2c 27 53 59 53 |t in ('D|BO','SYS|
|00006300| 27 29 20 29 20 6f 72 64 | 65 72 20 62 79 20 70 72 |') ) ord|er by pr|
|00006310| 6f 63 5f 6e 61 6d 65 00 | 73 65 6c 65 63 74 20 75 |oc_name.|select u|
|00006320| 73 65 72 5f 6e 61 6d 65 | 2c 20 72 65 6d 61 72 6b |ser_name|, remark|
|00006330| 73 20 66 72 6f 6d 20 53 | 59 53 55 53 45 52 50 45 |s from S|YSUSERPE|
|00006340| 52 4d 53 20 77 68 65 72 | 65 20 75 73 65 72 5f 67 |RMS wher|e user_g|
|00006350| 72 6f 75 70 20 3d 20 27 | 59 27 20 61 6e 64 20 75 |roup = '|Y' and u|
|00006360| 73 65 72 5f 6e 61 6d 65 | 20 3c 3e 20 27 53 59 53 |ser_name| <> 'SYS|
|00006370| 27 20 6f 72 64 65 72 20 | 62 79 20 75 73 65 72 5f |' order |by user_|
|00006380| 6e 61 6d 65 00 47 52 41 | 4e 54 20 4d 45 4d 42 45 |name.GRA|NT MEMBE|
|00006390| 52 53 48 49 50 20 49 4e | 20 47 52 4f 55 50 20 22 |RSHIP IN| GROUP "|
|000063a0| 25 31 22 20 54 4f 20 25 | 32 00 52 45 56 4f 4b 45 |%1" TO %|2.REVOKE|
|000063b0| 20 4d 45 4d 42 45 52 53 | 48 49 50 20 49 4e 20 47 | MEMBERS|HIP IN G|
|000063c0| 52 4f 55 50 20 22 25 31 | 22 20 46 52 4f 4d 20 25 |ROUP "%1|" FROM %|
|000063d0| 32 00 73 65 6c 65 63 74 | 20 53 59 53 47 52 4f 55 |2.select| SYSGROU|
|000063e0| 50 53 2e 6d 65 6d 62 65 | 72 5f 6e 61 6d 65 2c 20 |PS.membe|r_name, |
|000063f0| 41 2e 72 65 6d 61 72 6b | 73 2c 20 41 2e 75 73 65 |A.remark|s, A.use|
+--------+-------------------------+-------------------------+--------+--------+
Only 25.0 KB of data is shown above.
