/ PC Pro 1999 July / DPPCPRO0799.ISO / Extras / OTalk98 / SCSQLANY.DL_ / SCSQLANY.DL / DGROUP

< prev

MacOS 8.1

Win98

DOS

view JSON data

view as text

+--------+-------------------------+-------------------------+--------+--------+
|00000000| 01 01 01 00 64 62 6c 35 | 30 74 2e 64 6c 6c 00 64 |....dbl5|0t.dll.d|
|00000010| 62 5f 61 75 74 68 65 6e | 74 69 63 61 74 65 00 00 |b_authen|ticate..|
|00000020| 0a 0a 00 0a 0a 00 0a 0a | 00 0a 0a 00 00 00 00 00 |........|........|
|00000030| 00 00 00 00 25 31 20 28 | 25 32 29 00 25 31 20 28 |....%1 (|%2).%1 (|
|00000040| 25 32 29 00 25 31 20 28 | 25 32 29 00 25 31 20 28 |%2).%1 (|%2).%1 (|
|00000050| 25 32 29 00 00 73 63 68 | 69 6c 69 74 65 2e 64 6c |%2)..sch|ilite.dl|
|00000060| 6c 00 43 48 45 43 4b 20 | 28 20 20 20 29 00 43 48 |l.CHECK |(   ).CH|
|00000070| 45 43 4b 20 28 20 20 20 | 29 00 43 48 45 43 4b 20 |ECK (   |).CHECK |
|00000080| 28 20 20 20 29 00 00 00 | 00 00 00 00 49 6e 74 65 |(   )...|....Inte|
|00000090| 67 72 61 74 65 64 4c 6f | 67 69 6e 43 6f 6e 66 69 |gratedLo|ginConfi|
|000000a0| 67 00 59 45 53 00 4e 4f | 00 00 79 65 73 00 6e 6f |g.YES.NO|..yes.no|
|000000b0| 00 49 6e 74 65 67 72 61 | 74 65 64 4c 6f 67 69 6e |.Integra|tedLogin|
|000000c0| 43 6f 6e 66 69 67 00 59 | 45 53 00 59 45 53 00 4e |Config.Y|ES.YES.N|
|000000d0| 4f 00 00 00 00 00 00 00 | 5c 00 00 5c 00 25 31 20 |O.......|\..\.%1 |
|000000e0| 28 25 32 29 00 50 55 42 | 4c 49 43 00 34 2e 30 00 |(%2).PUB|LIC.4.0.|
|000000f0| 35 2e 30 00 35 2e 30 2e | 30 32 00 35 2e 30 2e 30 |5.0.5.0.|02.5.0.0|
|00000100| 33 00 35 2e 35 2e 30 33 | 00 36 2e 30 00 20 00 00 |3.5.5.03|.6.0. ..|
|00000110| 00 00 49 4d 30 35 30 2e | 45 58 45 00 49 4d 36 30 |..IM050.|EXE.IM60|
|00000120| 2e 45 58 45 00 00 00 00 | 00 00 00 00 00 00 00 00 |.EXE....|........|
|00000130| 25 31 20 28 25 32 29 00 | 25 31 20 28 25 32 29 00 |%1 (%2).|%1 (%2).|
|00000140| 25 31 20 28 25 32 29 00 | 00 00 00 00 00 00 00 00 |%1 (%2).|........|
|00000150| 00 00 00 00 25 31 20 28 | 25 32 29 00 43 4f 4e 4e |....%1 (|%2).CONN|
|00000160| 45 43 54 20 55 53 49 4e | 47 20 27 25 31 27 00 25 |ECT USIN|G '%1'.%|
|00000170| 31 20 2d 64 20 22 3b 22 | 20 2d 63 20 22 25 32 22 |1 -d ";"| -c "%2"|
|00000180| 00 49 73 71 6c 44 62 78 | 54 61 67 00 49 73 71 6c |.IsqlDbx|Tag.Isql|
|00000190| 44 62 78 49 64 6c 65 00 | 69 73 71 6c 2e 65 78 65 |DbxIdle.|isql.exe|
|000001a0| 00 00 00 00 00 00 4e 45 | 54 41 50 49 33 32 2e 44 |......NE|TAPI32.D|
|000001b0| 4c 4c 00 4e 65 74 55 73 | 65 72 45 6e 75 6d 00 4e |LL.NetUs|erEnum.N|
|000001c0| 65 74 41 70 69 42 75 66 | 66 65 72 46 72 65 65 00 |etApiBuf|ferFree.|
|000001d0| 59 00 59 00 59 00 00 4c | 6f 67 69 6e 5f 6d 6f 64 |Y.Y.Y..L|ogin_mod|
|000001e0| 65 00 50 55 42 4c 49 43 | 00 00 4e 45 54 41 50 49 |e.PUBLIC|..NETAPI|
|000001f0| 33 32 2e 44 4c 4c 00 4e | 65 74 55 73 65 72 45 6e |32.DLL.N|etUserEn|
|00000200| 75 6d 00 4e 65 74 41 70 | 69 42 75 66 66 65 72 46 |um.NetAp|iBufferF|
|00000210| 72 65 65 00 00 00 00 00 | 7c 00 7c 00 2d 2d 00 7c |ree.....||.|.--.||
|00000220| 00 7c 00 2d 2d 00 2a 00 | 00 00 27 00 27 00 50 55 |.|.--.*.|..'.'.PU|
|00000230| 42 4c 49 43 00 00 00 00 | 63 6f 70 79 00 25 31 5f |BLIC....|copy.%1_|
|00000240| 25 32 00 00 00 00 00 73 | 63 68 69 6c 69 74 65 2e |%2.....s|chilite.|
|00000250| 64 6c 6c 00 73 63 73 61 | 69 6e 64 74 2e 64 6c 6c |dll.scsa|indt.dll|
|00000260| 00 00 73 63 68 69 6c 69 | 74 65 2e 64 6c 6c 00 73 |..schili|te.dll.s|
|00000270| 63 73 61 69 6e 64 74 2e | 64 6c 6c 00 00 00 00 00 |csaindt.|dll.....|
|00000280| 20 00 3b 0a 00 00 00 00 | 20 09 0d 0a 00 20 09 0d | .;.....| .... ..|
|00000290| 0a 00 20 09 0d 0a 28 00 | 43 52 45 41 54 45 00 41 |.. ...(.|CREATE.A|
|000002a0| 4c 54 45 52 00 50 52 4f | 43 45 44 55 52 45 00 46 |LTER.PRO|CEDURE.F|
|000002b0| 55 4e 43 54 49 4f 4e 00 | 43 52 45 41 54 45 20 50 |UNCTION.|CREATE P|
|000002c0| 52 4f 43 45 44 55 52 45 | 20 5b 63 72 65 61 74 6f |ROCEDURE| [creato|
|000002d0| 72 2e 5d 22 70 72 6f 63 | 5f 6e 61 6d 65 22 20 28 |r.]"proc|_name" (|
|000002e0| 20 2f 2a 20 70 61 72 61 | 6d 65 74 65 72 73 2c 2e | /* para|meters,.|
|000002f0| 2e 2e 20 2a 2f 20 29 0d | 0a 2f 2a 20 52 45 53 55 |.. */ ).|./* RESU|
|00000300| 4c 54 20 28 20 63 6f 6c | 75 6d 6e 2d 6e 61 6d 65 |LT ( col|umn-name|
|00000310| 2c 2e 2e 2e 20 29 20 2a | 2f 0d 0a 42 45 47 49 4e |,... ) *|/..BEGIN|
|00000320| 0d 0a 20 20 20 20 20 20 | 20 3b 0d 0a 45 4e 44 00 |..      | ;..END.|
|00000330| 43 52 45 41 54 45 20 50 | 52 4f 43 45 44 55 52 45 |CREATE P|ROCEDURE|
|00000340| 20 22 00 22 2e 22 00 22 | 0d 0a 20 2f 2a 20 28 20 | "."."."|.. /* ( |
|00000350| 40 70 61 72 61 6d 65 74 | 65 72 5f 6e 61 6d 65 20 |@paramet|er_name |
|00000360| 64 61 74 61 74 79 70 65 | 20 5b 3d 20 64 65 66 61 |datatype| [= defa|
|00000370| 75 6c 74 5d 20 5b 6f 75 | 74 70 75 74 5d 2c 20 2e |ult] [ou|tput], .|
|00000380| 2e 2e 20 29 20 2a 2f 20 | 00 0d 0a 41 53 0d 0a 00 |.. ) */ |...AS...|
|00000390| 42 45 47 49 4e 0d 0a 0d | 0a 45 4e 44 00 22 20 20 |BEGIN...|.END."  |
|000003a0| 28 20 2f 2a 20 70 61 72 | 61 6d 65 74 65 72 73 2c |( /* par|ameters,|
|000003b0| 2e 2e 2e 20 2a 2f 20 29 | 0d 0a 00 42 45 47 49 4e |... */ )|...BEGIN|
|000003c0| 0d 0a 20 20 20 20 20 20 | 20 3b 0d 0a 45 4e 44 00 |..      | ;..END.|
|000003d0| 2f 2a 20 52 45 53 55 4c | 54 20 28 20 63 6f 6c 75 |/* RESUL|T ( colu|
|000003e0| 6d 6e 2d 6e 61 6d 65 2c | 2e 2e 2e 20 29 20 2a 2f |mn-name,|... ) */|
|000003f0| 0d 0a 00 57 61 74 63 6f | 6d 2d 53 51 4c 00 54 72 |...Watco|m-SQL.Tr|
|00000400| 61 6e 73 61 63 74 2d 53 | 51 4c 00 43 52 45 41 54 |ansact-S|QL.CREAT|
|00000410| 45 20 46 55 4e 43 54 49 | 4f 4e 20 5b 63 72 65 61 |E FUNCTI|ON [crea|
|00000420| 74 6f 72 2e 5d 22 66 75 | 6e 63 5f 6e 61 6d 65 22 |tor.]"fu|nc_name"|
|00000430| 20 28 20 2f 2a 20 70 61 | 72 61 6d 65 74 65 72 73 | ( /* pa|rameters|
|00000440| 2c 2e 2e 2e 20 2a 2f 20 | 29 0d 0a 52 45 54 55 52 |,... */ |)..RETUR|
|00000450| 4e 53 20 2f 2a 20 72 65 | 74 75 72 6e 20 74 79 70 |NS /* re|turn typ|
|00000460| 65 20 2a 2f 0d 0a 42 45 | 47 49 4e 0d 0a 09 44 45 |e */..BE|GIN...DE|
|00000470| 43 4c 41 52 45 20 2f 2a | 72 65 74 75 72 6e 20 6e |CLARE /*|return n|
|00000480| 61 6d 65 20 2a 2f 20 2f | 2a 20 72 65 74 75 72 6e |ame */ /|* return|
|00000490| 20 74 79 70 65 20 2a 2f | 3b 0d 0a 09 52 45 54 55 | type */|;...RETU|
|000004a0| 52 4e 20 28 2f 2a 20 72 | 65 74 75 72 6e 20 6e 61 |RN (/* r|eturn na|
|000004b0| 6d 65 20 2a 2f 29 3b 0d | 0a 45 4e 44 00 43 52 45 |me */);.|.END.CRE|
|000004c0| 41 54 45 20 46 55 4e 43 | 54 49 4f 4e 20 22 00 52 |ATE FUNC|TION ".R|
|000004d0| 45 54 55 52 4e 53 20 25 | 31 0d 0a 00 2f 2a 20 72 |ETURNS %|1.../* r|
|000004e0| 65 74 75 72 6e 20 74 79 | 70 65 20 2a 2f 00 42 45 |eturn ty|pe */.BE|
|000004f0| 47 49 4e 0d 0a 00 09 44 | 45 43 4c 41 52 45 20 00 |GIN....D|ECLARE .|
|00000500| 09 52 45 54 55 52 4e 20 | 28 25 31 29 3b 0a 0d 00 |.RETURN |(%1);...|
|00000510| 2f 2a 20 72 65 74 75 72 | 6e 20 6e 61 6d 65 20 2a |/* retur|n name *|
|00000520| 2f 00 45 4e 44 0d 0a 00 | 52 45 53 55 4d 45 20 41 |/.END...|RESUME A|
|00000530| 4c 4c 3b 0d 0a 00 22 00 | 2c 20 00 22 00 2c 20 00 |LL;...".|, ."., .|
|00000540| 43 52 45 41 54 45 20 56 | 41 52 49 41 42 4c 45 20 |CREATE V|ARIABLE |
|00000550| 22 25 31 22 20 25 32 3b | 0d 0a 00 43 41 4c 4c 20 |"%1" %2;|...CALL |
|00000560| 22 25 31 22 2e 22 25 32 | 22 28 20 25 33 20 29 3b |"%1"."%2|"( %3 );|
|00000570| 0d 0a 00 53 45 4c 45 43 | 54 20 22 25 31 22 28 20 |...SELEC|T "%1"( |
|00000580| 25 32 20 29 20 46 52 4f | 4d 20 44 55 4d 4d 59 3b |%2 ) FRO|M DUMMY;|
|00000590| 0d 0a 00 53 45 4c 45 43 | 54 20 22 25 31 22 20 46 |...SELEC|T "%1" F|
|000005a0| 52 4f 4d 20 44 55 4d 4d | 59 3b 0d 0a 00 44 52 4f |ROM DUMM|Y;...DRO|
|000005b0| 50 20 56 41 52 49 41 42 | 4c 45 20 22 25 31 22 3b |P VARIAB|LE "%1";|
|000005c0| 0d 0a 00 53 45 54 20 22 | 25 31 22 20 3d 20 25 32 |...SET "|%1" = %2|
|000005d0| 3b 0d 0a 00 53 45 54 20 | 4f 50 54 49 4f 4e 20 4f |;...SET |OPTION O|
|000005e0| 6e 5f 65 72 72 6f 72 20 | 3d 20 27 63 6f 6e 74 69 |n_error |= 'conti|
|000005f0| 6e 75 65 27 3b 0d 0a 00 | 53 45 54 20 4f 50 54 49 |nue';...|SET OPTI|
|00000600| 4f 4e 20 4f 6e 5f 65 72 | 72 6f 72 20 3d 20 27 70 |ON On_er|ror = 'p|
|00000610| 72 6f 6d 70 74 27 3b 0d | 0a 00 25 25 20 25 31 0d |rompt';.|..%% %1.|
|00000620| 0a 00 00 00 00 00 00 00 | 00 00 00 00 73 63 68 69 |........|....schi|
|00000630| 6c 69 74 65 2e 64 6c 6c | 00 53 45 4c 45 43 54 00 |lite.dll|.SELECT.|
|00000640| 53 45 4c 45 43 54 00 00 | 00 43 52 45 41 54 45 20 |SELECT..|.CREATE |
|00000650| 50 52 4f 43 45 44 55 52 | 45 20 22 00 22 2e 22 00 |PROCEDUR|E ".".".|
|00000660| 22 20 20 28 20 2f 2a 20 | 70 61 72 61 6d 65 74 65 |"  ( /* |paramete|
|00000670| 72 73 2c 2e 2e 2e 20 2a | 2f 20 29 0d 0a 00 42 45 |rs,... *|/ )...BE|
|00000680| 47 49 4e 0d 0a 20 20 20 | 20 20 20 20 3b 0d 0a 45 |GIN..   |    ;..E|
|00000690| 4e 44 00 2f 2a 20 52 45 | 53 55 4c 54 20 28 20 63 |ND./* RE|SULT ( c|
|000006a0| 6f 6c 75 6d 6e 2d 6e 61 | 6d 65 2c 2e 2e 2e 20 29 |olumn-na|me,... )|
|000006b0| 20 2a 2f 0d 0a 00 00 00 | 20 28 20 00 20 7c 20 00 | */.....| ( . | .|
|000006c0| 20 29 00 00 73 63 68 69 | 6c 69 74 65 2e 64 6c 6c | )..schi|lite.dll|
|000006d0| 00 00 00 25 31 20 28 25 | 32 29 00 57 48 45 52 45 |...%1 (%|2).WHERE|
|000006e0| 20 00 57 48 45 52 45 20 | 00 00 57 48 45 52 45 20 | .WHERE |..WHERE |
|000006f0| 00 53 55 42 53 43 52 49 | 42 45 20 42 59 20 00 53 |.SUBSCRI|BE BY .S|
|00000700| 55 42 53 43 52 49 42 45 | 20 42 59 20 00 00 00 22 |UBSCRIBE| BY ..."|
|00000710| 25 31 22 00 00 00 00 00 | 25 31 20 28 25 32 29 00 |%1".....|%1 (%2).|
|00000720| 00 00 00 00 4e 55 4c 4c | 00 00 00 00 25 31 20 28 |....NULL|....%1 (|
|00000730| 25 32 29 00 49 44 44 5f | 57 41 54 5f 44 42 53 57 |%2).IDD_|WAT_DBSW|
|00000740| 49 5a 5f 50 41 47 45 31 | 00 00 00 00 00 41 73 79 |IZ_PAGE1|.....Asy|
|00000750| 6e 63 52 65 61 64 00 41 | 73 79 6e 63 57 72 69 74 |ncRead.A|syncWrit|
|00000760| 65 00 43 61 63 68 65 48 | 69 74 73 00 43 61 63 68 |e.CacheH|its.Cach|
|00000770| 65 52 65 61 64 49 6e 64 | 49 6e 74 00 43 61 63 68 |eReadInd|Int.Cach|
|00000780| 65 52 65 61 64 49 6e 64 | 4c 65 61 66 00 43 61 63 |eReadInd|Leaf.Cac|
|00000790| 68 65 52 65 61 64 00 43 | 61 63 68 65 52 65 61 64 |heRead.C|acheRead|
|000007a0| 54 61 62 6c 65 00 43 61 | 63 68 65 57 72 69 74 65 |Table.Ca|cheWrite|
|000007b0| 00 43 68 6b 70 74 00 43 | 68 6b 70 74 46 6c 75 73 |.Chkpt.C|hkptFlus|
|000007c0| 68 00 43 6f 6d 6d 69 74 | 46 69 6c 65 00 43 6f 6e |h.Commit|File.Con|
|000007d0| 74 52 65 71 00 43 75 72 | 72 49 4f 00 43 75 72 72 |tReq.Cur|rIO.Curr|
|000007e0| 52 65 61 64 00 43 75 72 | 72 57 72 69 74 65 00 44 |Read.Cur|rWrite.D|
|000007f0| 69 73 6b 52 65 61 64 49 | 6e 74 49 6e 74 00 44 69 |iskReadI|ntInt.Di|
|00000800| 73 6b 52 65 61 64 49 6e | 64 4c 65 61 66 00 44 69 |skReadIn|dLeaf.Di|
|00000810| 73 6b 52 65 61 64 00 44 | 69 73 6b 53 79 6e 63 52 |skRead.D|iskSyncR|
|00000820| 65 61 64 00 44 69 73 6b | 57 61 69 74 57 72 69 74 |ead.Disk|WaitWrit|
|00000830| 65 00 44 69 73 6b 52 65 | 61 64 54 61 62 6c 65 00 |e.DiskRe|adTable.|
|00000840| 44 69 73 6b 57 61 69 74 | 52 65 61 64 00 44 69 73 |DiskWait|Read.Dis|
|00000850| 6b 57 61 69 74 57 72 69 | 74 65 00 44 69 73 6b 57 |kWaitWri|te.DiskW|
|00000860| 72 69 74 65 00 45 78 74 | 65 6e 64 44 42 57 72 69 |rite.Ext|endDBWri|
|00000870| 74 65 00 45 78 74 65 6e | 64 54 65 6d 70 57 72 69 |te.Exten|dTempWri|
|00000880| 74 65 00 46 72 65 65 57 | 72 69 74 65 43 75 72 72 |te.FreeW|riteCurr|
|00000890| 00 46 72 65 65 57 72 69 | 74 65 50 75 73 68 00 46 |.FreeWri|tePush.F|
|000008a0| 75 6c 6c 43 6f 6d 70 61 | 72 65 00 49 64 6c 65 43 |ullCompa|re.IdleC|
|000008b0| 68 65 63 6b 00 49 64 6c | 65 43 68 6b 54 69 6d 65 |heck.Idl|eChkTime|
|000008c0| 00 49 64 6c 65 57 72 69 | 74 65 00 49 6e 64 41 64 |.IdleWri|te.IndAd|
|000008d0| 64 00 49 6e 64 4c 6f 6f | 6b 75 70 00 4c 6f 63 6b |d.IndLoo|kup.Lock|
|000008e0| 54 61 62 6c 65 50 61 67 | 65 73 00 4d 61 69 6e 48 |TablePag|es.MainH|
|000008f0| 65 61 70 50 61 67 65 73 | 00 4d 61 78 49 4f 00 4d |eapPages|.MaxIO.M|
|00000900| 61 78 52 65 61 64 00 4d | 61 78 57 72 69 74 65 00 |axRead.M|axWrite.|
|00000910| 50 65 6e 64 69 6e 67 52 | 65 71 00 52 65 61 64 48 |PendingR|eq.ReadH|
|00000920| 69 6e 74 00 52 65 71 00 | 55 6e 73 63 68 52 65 71 |int.Req.|UnschReq|
|00000930| 00 56 6f 6c 75 6e 74 61 | 72 79 42 6c 6f 63 6b 00 |.Volunta|ryBlock.|
|00000940| 57 61 69 74 52 65 61 64 | 43 6d 70 00 57 61 69 74 |WaitRead|Cmp.Wait|
|00000950| 52 65 61 64 4f 70 74 00 | 57 61 69 74 52 65 61 64 |ReadOpt.|WaitRead|
|00000960| 55 6e 6b 6e 00 00 00 00 | 28 27 25 31 27 29 00 28 |Unkn....|('%1').(|
|00000970| 27 25 31 27 29 00 22 25 | 31 22 00 00 00 00 00 00 |'%1')."%|1"......|
|00000980| 00 00 28 27 25 31 27 29 | 00 28 27 25 31 27 29 00 |..('%1')|.('%1').|
|00000990| 00 00 00 00 63 6f 70 79 | 00 25 31 5f 25 32 00 53 |....copy|.%1_%2.S|
|000009a0| 45 4c 45 43 54 20 2a 20 | 46 52 4f 4d 20 22 25 31 |ELECT * |FROM "%1|
|000009b0| 22 2e 22 25 32 22 00 53 | 45 4c 45 43 54 20 2a 20 |"."%2".S|ELECT * |
|000009c0| 46 52 4f 4d 20 25 31 2e | 25 32 00 22 25 31 22 2e |FROM %1.|%2."%1".|
|000009d0| 22 25 32 22 00 00 2c 00 | 25 31 2e 25 32 2e 25 33 |"%2"..,.|%1.%2.%3|
|000009e0| 2e 25 34 2e 25 35 00 25 | 31 2e 25 32 2e 25 33 2e |.%4.%5.%|1.%2.%3.|
|000009f0| 25 34 2e 25 35 00 5f 63 | 6f 70 79 00 59 00 00 00 |%4.%5._c|opy.Y...|
|00000a00| 57 61 74 44 72 61 67 44 | 72 6f 70 00 57 61 74 44 |WatDragD|rop.WatD|
|00000a10| 72 61 67 44 72 6f 70 00 | 25 31 2e 25 32 2e 25 33 |ragDrop.|%1.%2.%3|
|00000a20| 2e 25 34 2e 25 35 00 00 | 00 00 00 00 53 59 53 54 |.%4.%5..|....SYST|
|00000a30| 45 4d 00 00 73 63 68 69 | 6c 69 74 65 2e 64 6c 6c |EM..schi|lite.dll|
|00000a40| 00 43 48 45 43 4b 28 20 | 20 20 29 00 00 61 6e 64 |.CHECK( |  )..and|
|00000a50| 28 00 0d 0a 00 00 00 00 | 2a 00 20 00 00 00 00 00 |(.......|*. .....|
|00000a60| 44 42 58 43 72 65 61 74 | 65 53 65 72 76 69 63 65 |DBXCreat|eService|
|00000a70| 73 46 6f 6c 64 65 72 00 | 73 63 73 76 6d 6e 2e 64 |sFolder.|scsvmn.d|
|00000a80| 6c 6c 00 00 7c 00 2a 00 | 2d 2d 00 7c 00 00 00 00 |ll..|.*.|--.|....|
|00000a90| 73 63 68 69 6c 69 74 65 | 2e 64 6c 6c 00 73 63 73 |schilite|.dll.scs|
|00000aa0| 61 69 6e 64 74 2e 64 6c | 6c 00 73 63 68 69 6c 69 |aindt.dl|l.schili|
|00000ab0| 74 65 2e 64 6c 6c 00 73 | 63 73 61 69 6e 64 74 2e |te.dll.s|csaindt.|
|00000ac0| 64 6c 6c 00 42 45 46 4f | 52 45 00 41 46 54 45 52 |dll.BEFO|RE.AFTER|
|00000ad0| 00 44 45 4c 45 54 45 00 | 49 4e 53 45 52 54 00 55 |.DELETE.|INSERT.U|
|00000ae0| 50 44 41 54 45 00 52 45 | 53 4f 4c 56 45 00 55 50 |PDATE.RE|SOLVE.UP|
|00000af0| 44 41 54 45 20 4f 46 20 | 25 31 00 43 52 45 41 54 |DATE OF |%1.CREAT|
|00000b00| 45 20 54 52 49 47 47 45 | 52 20 22 25 31 22 20 25 |E TRIGGE|R "%1" %|
|00000b10| 32 20 25 33 0d 0a 09 4f | 52 44 45 52 20 25 34 20 |2 %3...O|RDER %4 |
|00000b20| 4f 4e 20 25 35 0d 0a 00 | 09 46 4f 52 20 45 41 43 |ON %5...|.FOR EAC|
|00000b30| 48 20 52 4f 57 0d 0a 00 | 09 46 4f 52 20 45 41 43 |H ROW...|.FOR EAC|
|00000b40| 48 20 53 54 41 54 45 4d | 45 4e 54 0d 0a 00 09 5b |H STATEM|ENT....[|
|00000b50| 20 57 48 45 4e 28 20 73 | 65 61 72 63 68 5f 63 6f | WHEN( s|earch_co|
|00000b60| 6e 64 69 74 69 6f 6e 20 | 29 20 5d 0d 0a 42 45 47 |ndition |) ]..BEG|
|00000b70| 49 4e 0d 0a 00 09 3b 0d | 0a 45 4e 44 00 20 20 20 |IN....;.|.END.   |
|00000b80| 20 49 46 20 28 6e 65 77 | 5f 6e 61 6d 65 2e 5b 63 | IF (new|_name.[c|
|00000b90| 6f 6c 75 6d 6e 5f 6e 61 | 6d 65 5d 20 49 53 20 4e |olumn_na|me] IS N|
|00000ba0| 55 4c 4c 20 4f 52 0d 0a | 20 20 20 20 20 20 20 20 |ULL OR..|        |
|00000bb0| 6f 6c 64 5f 6e 61 6d 65 | 2e 5b 63 6f 6c 75 6d 6e |old_name|.[column|
|00000bc0| 5f 6e 61 6d 65 5d 20 3c | 20 6e 65 77 5f 6e 61 6d |_name] <| new_nam|
|00000bd0| 65 2e 5b 63 6f 6c 75 6d | 6e 5f 6e 61 6d 65 5d 29 |e.[colum|n_name])|
|00000be0| 0d 0a 20 20 20 20 20 20 | 20 20 20 20 20 20 54 48 |..      |      TH|
|00000bf0| 45 4e 20 53 45 54 20 6e | 65 77 5f 76 61 6c 2e 5b |EN SET n|ew_val.[|
|00000c00| 63 6f 6c 75 6d 6e 5f 6e | 61 6d 65 5d 20 3d 20 6f |column_n|ame] = o|
|00000c10| 6c 64 5f 76 61 6c 2e 5b | 63 6f 6c 75 6d 6e 5f 6e |ld_val.[|column_n|
|00000c20| 61 6d 65 5d 0d 0a 20 20 | 20 20 45 4e 44 20 49 46 |ame]..  |  END IF|
|00000c30| 0d 0a 45 4e 44 00 20 20 | 20 20 49 46 20 28 6e 65 |..END.  |  IF (ne|
|00000c40| 77 5f 6e 61 6d 65 2e 5b | 63 6f 6c 75 6d 6e 5f 6e |w_name.[|column_n|
|00000c50| 61 6d 65 5d 20 49 53 20 | 4e 55 4c 4c 20 4f 52 0d |ame] IS |NULL OR.|
|00000c60| 0a 20 20 20 20 20 20 20 | 20 6f 6c 64 5f 6e 61 6d |.       | old_nam|
|00000c70| 65 2e 5b 63 6f 6c 75 6d | 6e 5f 6e 61 6d 65 5d 20 |e.[colum|n_name] |
|00000c80| 3e 20 6e 65 77 5f 6e 61 | 6d 65 2e 5b 63 6f 6c 75 |> new_na|me.[colu|
|00000c90| 6d 6e 5f 6e 61 6d 65 5d | 29 0d 0a 20 20 20 20 20 |mn_name]|)..     |
|00000ca0| 20 20 20 20 20 20 20 54 | 48 45 4e 20 53 45 54 20 |       T|HEN SET |
|00000cb0| 6e 65 77 5f 6e 61 6d 65 | 2e 5b 63 6f 6c 75 6d 6e |new_name|.[column|
|00000cc0| 5f 6e 61 6d 65 5d 20 3d | 20 6f 6c 64 5f 6e 61 6d |_name] =| old_nam|
|00000cd0| 65 2e 5b 63 6f 6c 75 6d | 6e 5f 6e 61 6d 65 5d 0d |e.[colum|n_name].|
|00000ce0| 0a 20 20 20 20 45 4e 44 | 20 49 46 0d 0a 45 4e 44 |.    END| IF..END|
|00000cf0| 00 20 20 20 20 49 46 20 | 28 6e 65 77 5f 6e 61 6d |.    IF |(new_nam|
|00000d00| 65 2e 5b 63 6f 6c 75 6d | 6e 5f 6e 61 6d 65 5d 20 |e.[colum|n_name] |
|00000d10| 49 53 20 4e 4f 54 20 4e | 55 4c 4c 20 41 4e 44 0d |IS NOT N|ULL AND.|
|00000d20| 0a 20 20 20 20 20 20 20 | 20 6f 6c 64 5f 6e 61 6d |.       | old_nam|
|00000d30| 65 2e 5b 63 6f 6c 75 6d | 6e 5f 6e 61 6d 65 5d 20 |e.[colum|n_name] |
|00000d40| 49 53 20 4e 4f 54 20 4e | 55 4c 4c 29 0d 0a 20 20 |IS NOT N|ULL)..  |
|00000d50| 20 20 20 20 20 20 20 20 | 20 20 54 48 45 4e 20 53 |        |  THEN S|
|00000d60| 45 54 20 6e 65 77 5f 6e | 61 6d 65 2e 5b 63 6f 6c |ET new_n|ame.[col|
|00000d70| 75 6d 6e 5f 6e 61 6d 65 | 5d 20 3d 0d 0a 20 20 20 |umn_name|] =..   |
|00000d80| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 28 6f 6c |        |     (ol|
|00000d90| 64 5f 6e 61 6d 65 2e 5b | 63 6f 6c 75 6d 6e 5f 6e |d_name.[|column_n|
|00000da0| 61 6d 65 5d 20 2b 20 6e | 65 77 5f 6e 61 6d 65 2e |ame] + n|ew_name.|
|00000db0| 5b 63 6f 6c 75 6d 6e 5f | 6e 61 6d 65 5d 29 20 2f |[column_|name]) /|
|00000dc0| 20 32 0d 0a 20 20 20 20 | 45 4c 53 45 0d 0a 20 20 | 2..    |ELSE..  |
|00000dd0| 20 20 20 20 20 20 2f 2a | 20 49 66 20 65 69 74 68 |      /*| If eith|
|00000de0| 65 72 20 74 68 65 20 6e | 65 77 20 6f 72 20 6f 6c |er the n|ew or ol|
|00000df0| 64 20 76 61 6c 75 65 20 | 63 6f 75 6c 64 20 62 65 |d value |could be|
|00000e00| 20 4e 55 4c 4c 2c 20 68 | 61 6e 64 6c 65 20 74 68 | NULL, h|andle th|
|00000e10| 61 74 0d 0a 20 20 20 20 | 20 20 20 20 20 2a 20 63 |at..    |     * c|
|00000e20| 61 73 65 20 68 65 72 65 | 2e 0d 0a 20 20 20 20 20 |ase here|...     |
|00000e30| 20 20 20 20 2a 2f 0d 0a | 20 20 20 20 45 4e 44 20 |    */..|    END |
|00000e40| 49 46 0d 0a 45 4e 44 00 | 20 20 20 20 49 46 20 28 |IF..END.|    IF (|
|00000e50| 6e 65 77 5f 6e 61 6d 65 | 2e 5b 63 6f 6c 75 6d 6e |new_name|.[column|
|00000e60| 5f 6e 61 6d 65 5d 20 49 | 53 20 4e 4f 54 20 4e 55 |_name] I|S NOT NU|
|00000e70| 4c 4c 20 41 4e 44 0d 0a | 20 20 20 20 20 20 20 20 |LL AND..|        |
|00000e80| 6f 6c 64 5f 6e 61 6d 65 | 2e 5b 63 6f 6c 75 6d 6e |old_name|.[column|
|00000e90| 5f 6e 61 6d 65 5d 20 49 | 53 20 4e 4f 54 20 4e 55 |_name] I|S NOT NU|
|00000ea0| 4c 4c 20 41 4e 44 0d 0a | 20 20 20 20 20 20 20 20 |LL AND..|        |
|00000eb0| 72 65 6d 6f 74 65 5f 76 | 61 6c 2e 5b 63 6f 6c 75 |remote_v|al.[colu|
|00000ec0| 6d 6e 5f 6e 61 6d 65 5d | 20 49 53 20 4e 4f 54 20 |mn_name]| IS NOT |
|00000ed0| 4e 55 4c 4c 29 20 54 48 | 45 4e 0d 0a 20 20 20 20 |NULL) TH|EN..    |
|00000ee0| 20 20 20 20 20 20 20 20 | 53 45 54 20 6e 65 77 5f |        |SET new_|
|00000ef0| 6e 61 6d 65 2e 5b 63 6f | 6c 75 6d 6e 5f 6e 61 6d |name.[co|lumn_nam|
|00000f00| 65 5d 20 3d 20 6f 6c 64 | 5f 6e 61 6d 65 2e 5b 63 |e] = old|_name.[c|
|00000f10| 6f 6c 75 6d 6e 5f 6e 61 | 6d 65 5d 20 2b 0d 0a 20 |olumn_na|me] +.. |
|00000f20| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 28 |        |       (|
|00000f30| 6e 65 77 5f 6e 61 6d 65 | 2e 5b 63 6f 6c 75 6d 6e |new_name|.[column|
|00000f40| 5f 6e 61 6d 65 5d 20 2d | 20 72 65 6d 6f 74 65 5f |_name] -| remote_|
|00000f50| 76 61 6c 2e 5b 63 6f 6c | 75 6d 6e 5f 6e 61 6d 65 |val.[col|umn_name|
|00000f60| 5d 29 0d 0a 20 20 20 20 | 45 4c 53 45 0d 0a 20 20 |])..    |ELSE..  |
|00000f70| 20 20 20 20 20 20 2f 2a | 20 44 6f 20 61 6e 79 20 |      /*| Do any |
|00000f80| 68 61 6e 64 6c 69 6e 67 | 20 6f 66 20 70 6f 73 73 |handling| of poss|
|00000f90| 69 62 6c 65 20 4e 55 4c | 4c 20 76 61 6c 75 65 73 |ible NUL|L values|
|00000fa0| 20 68 65 72 65 20 2a 2f | 0d 0a 20 20 20 20 45 4e | here */|..    EN|
|00000fb0| 44 20 49 46 0d 0a 45 4e | 44 00 20 20 20 20 2f 2a |D IF..EN|D.    /*|
|00000fc0| 20 57 65 20 64 6f 6e 27 | 74 20 6e 65 65 64 20 74 | We don'|t need t|
|00000fd0| 6f 20 64 6f 20 61 6e 79 | 74 68 69 6e 67 20 68 65 |o do any|thing he|
|00000fe0| 72 65 2c 20 73 69 6e 63 | 65 20 6e 65 77 5f 6e 61 |re, sinc|e new_na|
|00000ff0| 6d 65 0d 0a 20 20 20 20 | 20 2a 20 61 6c 72 65 61 |me..    | * alrea|
|00001000| 64 79 20 63 6f 6e 74 61 | 69 6e 73 20 74 68 65 20 |dy conta|ins the |
|00001010| 76 61 6c 75 65 20 74 68 | 61 74 20 77 65 20 77 61 |value th|at we wa|
|00001020| 6e 74 20 69 74 20 74 6f | 20 63 6f 6e 74 61 69 6e |nt it to| contain|
|00001030| 2e 0d 0a 20 20 20 20 20 | 2a 2f 0d 0a 45 4e 44 00 |...     |*/..END.|
|00001040| 20 20 20 20 2f 2a 20 6f | 6e 65 20 66 6f 72 20 65 |    /* o|ne for e|
|00001050| 61 63 68 20 63 6f 6c 75 | 6d 6e 20 2a 2f 0d 0a 20 |ach colu|mn */.. |
|00001060| 20 20 20 53 45 54 20 6e | 65 77 5f 6e 61 6d 65 2e |   SET n|ew_name.|
|00001070| 5b 63 6f 6c 31 5d 3d 6f | 6c 64 5f 6e 61 6d 65 2e |[col1]=o|ld_name.|
|00001080| 5b 63 6f 6c 31 5d 3b 0d | 0a 20 20 20 20 53 45 54 |[col1];.|.    SET|
|00001090| 20 6e 65 77 5f 6e 61 6d | 65 2e 5b 63 6f 6c 32 5d | new_nam|e.[col2]|
|000010a0| 3d 6f 6c 64 5f 6e 61 6d | 65 2e 5b 63 6f 6c 32 5d |=old_nam|e.[col2]|
|000010b0| 3b 0d 0a 20 20 20 20 53 | 45 54 20 6e 65 77 5f 6e |;..    S|ET new_n|
|000010c0| 61 6d 65 2e 5b 63 6f 6c | 33 5d 3d 6f 6c 64 5f 6e |ame.[col|3]=old_n|
|000010d0| 61 6d 65 2e 5b 63 6f 6c | 33 5d 3b 0d 0a 45 4e 44 |ame.[col|3];..END|
|000010e0| 00 20 20 20 20 2f 2a 20 | 52 65 71 75 69 72 65 73 |.    /* |Requires|
|000010f0| 20 61 20 63 6f 6c 75 6d | 6e 2c 20 5b 74 69 6d 65 | a colum|n, [time|
|00001100| 73 74 61 6d 70 5d 2c 20 | 77 68 69 63 68 20 63 6f |stamp], |which co|
|00001110| 6e 74 61 69 6e 73 20 61 | 20 74 69 6d 65 73 74 61 |ntains a| timesta|
|00001120| 6d 70 2e 0d 0a 20 20 20 | 20 20 2a 20 47 6f 69 6e |mp...   |  * Goin|
|00001130| 67 20 74 6f 20 61 73 73 | 75 6d 65 20 74 68 61 74 |g to ass|ume that|
|00001140| 20 74 68 65 20 74 69 6d | 65 73 74 61 6d 70 20 63 | the tim|estamp c|
|00001150| 6f 6c 73 20 61 72 65 20 | 6e 6f 74 20 6e 75 6c 6c |ols are |not null|
|00001160| 0d 0a 20 20 20 20 20 2a | 20 73 69 6e 63 65 20 74 |..     *| since t|
|00001170| 68 65 79 20 73 68 6f 75 | 6c 64 20 62 65 20 64 6f |hey shou|ld be do|
|00001180| 6e 65 20 62 79 20 61 20 | 74 72 69 67 67 65 72 20 |ne by a |trigger |
|00001190| 61 6e 79 77 61 79 73 0d | 0a 20 20 20 20 20 2a 2f |anyways.|.     */|
|000011a0| 0d 0a 20 20 20 20 20 49 | 46 20 28 6f 6c 64 5f 6e |..     I|F (old_n|
|000011b0| 61 6d 65 2e 5b 74 69 6d | 65 73 74 61 6d 70 5d 20 |ame.[tim|estamp] |
|000011c0| 3e 20 6e 65 77 5f 6e 61 | 6d 65 2e 5b 74 69 6d 65 |> new_na|me.[time|
|000011d0| 73 74 61 6d 70 5d 29 20 | 54 48 45 4e 0d 0a 20 20 |stamp]) |THEN..  |
|000011e0| 20 20 20 20 20 20 20 53 | 45 54 20 6e 65 77 5f 6e |       S|ET new_n|
|000011f0| 61 6d 65 2e 5b 63 6f 6c | 75 6d 6e 5f 6e 61 6d 65 |ame.[col|umn_name|
|00001200| 5d 20 3d 20 6f 6c 64 5f | 6e 61 6d 65 2e 5b 63 6f |] = old_|name.[co|
|00001210| 6c 75 6d 6e 5f 6e 61 6d | 65 5d 3b 0d 0a 20 20 20 |lumn_nam|e];..   |
|00001220| 20 20 45 4e 44 20 49 46 | 0d 0a 45 4e 44 00 20 20 |  END IF|..END.  |
|00001230| 20 20 2f 2a 20 52 65 71 | 75 69 72 65 73 20 61 20 |  /* Req|uires a |
|00001240| 63 6f 6c 75 6d 6e 2c 20 | 5b 74 69 6d 65 73 74 61 |column, |[timesta|
|00001250| 6d 70 5d 2c 20 77 68 69 | 63 68 20 63 6f 6e 74 61 |mp], whi|ch conta|
|00001260| 69 6e 73 20 61 20 74 69 | 6d 65 73 74 61 6d 70 2e |ins a ti|mestamp.|
|00001270| 0d 0a 20 20 20 20 20 2a | 20 47 6f 69 6e 67 20 74 |..     *| Going t|
|00001280| 6f 20 61 73 73 75 6d 65 | 20 74 68 61 74 20 74 68 |o assume| that th|
|00001290| 65 20 74 69 6d 65 73 74 | 61 6d 70 20 63 6f 6c 73 |e timest|amp cols|
|000012a0| 20 61 72 65 20 6e 6f 74 | 20 6e 75 6c 6c 0d 0a 20 | are not| null.. |
|000012b0| 20 20 20 20 2a 20 73 69 | 6e 63 65 20 74 68 65 79 |    * si|nce they|
|000012c0| 20 73 68 6f 75 6c 64 20 | 62 65 20 64 6f 6e 65 20 | should |be done |
|000012d0| 62 79 20 61 20 74 72 69 | 67 67 65 72 20 61 6e 79 |by a tri|gger any|
|000012e0| 77 61 79 73 0d 0a 20 20 | 20 20 20 2a 2f 0d 0a 20 |ways..  |   */.. |
|000012f0| 20 20 20 49 46 20 28 6f | 6c 64 5f 6e 61 6d 65 2e |   IF (o|ld_name.|
|00001300| 5b 74 69 6d 65 73 74 61 | 6d 70 5d 20 3c 20 6e 65 |[timesta|mp] < ne|
|00001310| 77 5f 6e 61 6d 65 2e 5b | 74 69 6d 65 73 74 61 6d |w_name.[|timestam|
|00001320| 70 5d 29 20 54 48 45 4e | 0d 0a 20 20 20 20 20 20 |p]) THEN|..      |
|00001330| 20 20 53 45 54 20 6e 65 | 77 5f 6e 61 6d 65 2e 5b |  SET ne|w_name.[|
|00001340| 63 6f 6c 75 6d 6e 5f 6e | 61 6d 65 5d 20 3d 20 6f |column_n|ame] = o|
|00001350| 6c 64 5f 6e 61 6d 65 2e | 5b 63 6f 6c 75 6d 6e 5f |ld_name.|[column_|
|00001360| 6e 61 6d 65 5d 3b 0d 0a | 20 20 20 20 45 4e 44 20 |name];..|    END |
|00001370| 49 46 0d 0a 45 4e 44 00 | 09 5b 20 52 45 46 45 52 |IF..END.|.[ REFER|
|00001380| 45 4e 43 49 4e 47 20 4f | 4c 44 20 41 53 20 6f 6c |ENCING O|LD AS ol|
|00001390| 64 5f 6e 61 6d 65 20 5d | 0d 0a 00 2c 20 00 09 5b |d_name ]|..., ..[|
|000013a0| 20 52 45 46 45 52 45 4e | 43 49 4e 47 20 4e 45 57 | REFEREN|CING NEW|
|000013b0| 20 41 53 20 6e 65 77 5f | 6e 61 6d 65 20 5d 0d 0a | AS new_|name ]..|
|000013c0| 00 09 20 20 20 20 20 20 | 20 20 20 20 20 20 5b 20 |..      |      [ |
|000013d0| 4e 45 57 20 41 53 20 6e | 65 77 5f 6e 61 6d 65 20 |NEW AS n|ew_name |
|000013e0| 5d 0d 0a 00 2c 20 00 09 | 52 45 46 45 52 45 4e 43 |]..., ..|REFERENC|
|000013f0| 49 4e 47 20 5b 20 4f 4c | 44 20 41 53 20 6f 6c 64 |ING [ OL|D AS old|
|00001400| 5f 6e 61 6d 65 20 5d 0d | 0a 00 09 20 20 20 20 20 |_name ].|...     |
|00001410| 20 20 20 20 20 20 20 5b | 20 4e 45 57 20 41 53 20 |       [| NEW AS |
|00001420| 6e 65 77 5f 6e 61 6d 65 | 20 5d 0d 0a 00 09 20 20 |new_name| ]....  |
|00001430| 20 20 20 20 20 20 20 20 | 20 20 5b 20 52 45 4d 4f |        |  [ REMO|
|00001440| 54 45 20 41 53 20 72 65 | 6d 6f 74 65 5f 6e 61 6d |TE AS re|mote_nam|
|00001450| 65 20 5d 0d 0a 00 09 52 | 45 46 45 52 45 4e 43 49 |e ]....R|EFERENCI|
|00001460| 4e 47 20 5b 20 4f 4c 44 | 20 41 53 20 6f 6c 64 5f |NG [ OLD| AS old_|
|00001470| 6e 61 6d 65 20 5d 0d 0a | 00 09 20 20 20 20 20 20 |name ]..|..      |
|00001480| 20 20 20 20 20 20 5b 20 | 4e 45 57 20 41 53 20 6e |      [ |NEW AS n|
|00001490| 65 77 5f 6e 61 6d 65 20 | 5d 0d 0a 00 09 20 20 20 |ew_name |]....   |
|000014a0| 20 20 20 20 20 20 20 20 | 20 5b 20 52 45 4d 4f 54 |        | [ REMOT|
|000014b0| 45 20 41 53 20 72 65 6d | 6f 74 65 5f 6e 61 6d 65 |E AS rem|ote_name|
|000014c0| 20 5d 0d 0a 00 20 09 0d | 0a 00 20 09 0d 0a 00 43 | ]... ..|.. ....C|
|000014d0| 52 45 41 54 45 00 41 4c | 54 45 52 00 54 52 49 47 |REATE.AL|TER.TRIG|
|000014e0| 47 45 52 00 20 09 0d 0a | 00 00 00 00 2c 20 00 2c |GER. ...|...., .,|
|000014f0| 20 00 00 00 2c 20 00 2c | 20 00 00 00 2c 20 00 2c | ..., .,| ..., .,|
|00001500| 20 00 00 00 00 4f 6e 00 | 25 31 20 25 32 00 73 63 | ....On.|%1 %2.sc|
|00001510| 68 69 6c 69 74 65 2e 64 | 6c 6c 00 00 00 00 00 00 |hilite.d|ll......|
|00001520| 4f 6e 00 00 43 48 45 43 | 4b 28 20 20 20 29 00 73 |On..CHEC|K(   ).s|
|00001530| 63 68 69 6c 69 74 65 2e | 64 6c 6c 00 00 00 00 00 |chilite.|dll.....|
|00001540| 00 00 00 00 22 25 31 22 | 2e 22 25 32 22 00 00 00 |...."%1"|."%2"...|
|00001550| 50 55 42 4c 49 43 00 00 | 25 31 20 28 25 32 29 00 |PUBLIC..|%1 (%2).|
|00001560| 00 00 00 00 63 6f 70 79 | 00 25 31 5f 25 32 00 53 |....copy|.%1_%2.S|
|00001570| 45 4c 45 43 54 20 2a 20 | 46 52 4f 4d 20 22 25 31 |ELECT * |FROM "%1|
|00001580| 22 2e 22 25 32 22 00 53 | 45 4c 45 43 54 20 2a 20 |"."%2".S|ELECT * |
|00001590| 46 52 4f 4d 20 25 31 2e | 25 32 00 73 63 68 69 6c |FROM %1.|%2.schil|
|000015a0| 69 74 65 2e 64 6c 6c 00 | 73 63 73 61 69 6e 64 74 |ite.dll.|scsaindt|
|000015b0| 2e 64 6c 6c 00 00 73 63 | 68 69 6c 69 74 65 2e 64 |.dll..sc|hilite.d|
|000015c0| 6c 6c 00 73 63 73 61 69 | 6e 64 74 2e 64 6c 6c 00 |ll.scsai|ndt.dll.|
|000015d0| 00 00 2c 20 00 0d 0a 00 | 29 2e 00 2e 00 20 00 29 |.., ....|).... .)|
|000015e0| 2e 00 2c 20 00 0d 0a 00 | 2e 28 00 2e 00 00 00 20 |.., ....|.(..... |
|000015f0| 09 0d 0a 00 20 09 0d 0a | 00 20 09 0d 0a 28 00 43 |.... ...|. ...(.C|
|00001600| 52 45 41 54 45 00 41 4c | 54 45 52 00 56 49 45 57 |REATE.AL|TER.VIEW|
|00001610| 00 43 52 45 41 54 45 20 | 56 49 45 57 20 2f 2a 20 |.CREATE |VIEW /* |
|00001620| 63 72 65 61 74 6f 72 2e | 20 2a 2f 20 6e 61 6d 65 |creator.| */ name|
|00001630| 20 28 20 2f 2a 20 76 69 | 65 77 20 63 6f 6c 75 6d | ( /* vi|ew colum|
|00001640| 6e 20 6e 61 6d 65 2c 2e | 2e 2e 20 2a 2f 20 29 0d |n name,.|.. */ ).|
|00001650| 0a 41 53 20 73 65 6c 65 | 63 74 2d 77 69 74 68 6f |.AS sele|ct-witho|
|00001660| 75 74 2d 6f 72 64 65 72 | 2d 62 79 00 43 52 45 41 |ut-order|-by.CREA|
|00001670| 54 45 20 56 49 45 57 20 | 22 00 22 2e 22 00 22 20 |TE VIEW |"."."." |
|00001680| 28 20 2f 2a 20 76 69 65 | 77 20 63 6f 6c 75 6d 6e |( /* vie|w column|
|00001690| 20 6e 61 6d 65 2c 2e 2e | 2e 20 2a 2f 20 29 0d 0a | name,..|. */ )..|
|000016a0| 00 41 53 20 53 45 4c 45 | 43 54 20 00 0d 0a 46 52 |.AS SELE|CT ...FR|
|000016b0| 4f 4d 20 00 2f 2a 20 74 | 61 62 6c 65 20 63 6f 6c |OM ./* t|able col|
|000016c0| 75 6d 6e 20 6e 61 6d 65 | 2c 2e 2e 2e 20 2a 2f 00 |umn name|,... */.|
|000016d0| 2f 2a 20 74 61 62 6c 65 | 20 6e 61 6d 65 2c 2e 2e |/* table| name,..|
|000016e0| 2e 20 2a 2f 00 22 00 00 | 00 00 00 00 20 28 00 29 |. */."..|.... (.)|
|000016f0| 00 20 28 00 29 00 29 00 | 2e 00 20 28 00 00 00 00 |. (.).).|.. (....|
|00001700| 7c 00 2a 00 2d 2d 00 7c | 00 00 00 00 00 25 31 2e ||.*.--.||.....%1.|
|00001710| 25 32 2e 25 33 2e 25 34 | 2e 25 35 00 00 00 53 59 |%2.%3.%4|.%5...SY|
|00001720| 53 00 69 6e 74 65 67 65 | 72 00 00 00 00 00 00 00 |S.intege|r.......|
|00001730| 00 00 00 00 00 00 00 00 | 00 59 00 4e 00 4e 00 00 |........|.Y.N.N..|
|00001740| 22 25 31 22 2e 22 25 32 | 22 00 00 00 53 59 53 54 |"%1"."%2|"...SYST|
|00001750| 45 4d 00 53 59 53 54 45 | 4d 00 00 00 44 00 62 00 |EM.SYSTE|M...D.b.|
|00001760| 78 00 44 00 72 00 61 00 | 67 00 48 00 65 00 61 00 |x.D.r.a.|g.H.e.a.|
|00001770| 64 00 65 00 72 00 00 00 | 57 00 61 00 74 00 44 00 |d.e.r...|W.a.t.D.|
|00001780| 72 00 61 00 67 00 44 00 | 72 00 6f 00 70 00 00 00 |r.a.g.D.|r.o.p...|
|00001790| 21 00 25 31 25 21 25 32 | 00 25 31 2e 25 32 00 00 |!.%1%!%2|.%1.%2..|
|000017a0| 00 00 59 45 53 00 35 2e | 35 2e 30 34 20 42 75 69 |..YES.5.|5.04 Bui|
|000017b0| 6c 64 20 23 31 39 30 30 | 00 43 6f 6e 6e 65 63 74 |ld #1900|.Connect|
|000017c0| 69 6f 6e 20 50 61 72 61 | 6d 65 74 65 72 73 00 00 |ion Para|meters..|
|000017d0| 00 00 00 00 25 64 00 25 | 78 00 25 6f 00 25 6c 64 |....%d.%|x.%o.%ld|
|000017e0| 00 25 6c 78 00 25 6c 6f | 00 25 6c 75 00 00 00 00 |.%lx.%lo|.%lu....|
|000017f0| 53 79 62 61 73 65 20 43 | 65 6e 74 72 61 6c 00 4f |Sybase C|entral.O|
|00001800| 75 74 20 6f 66 20 6d 65 | 6d 6f 72 79 00 00 00 00 |ut of me|mory....|
|00001810| 00 00 41 4c 54 45 52 20 | 50 55 42 4c 49 43 41 54 |..ALTER |PUBLICAT|
|00001820| 49 4f 4e 20 22 25 31 22 | 2e 22 25 32 22 20 52 45 |ION "%1"|."%2" RE|
|00001830| 4e 41 4d 45 20 22 25 33 | 22 00 43 4f 4d 4d 45 4e |NAME "%3|".COMMEN|
|00001840| 54 20 4f 4e 20 50 55 42 | 4c 49 43 41 54 49 4f 4e |T ON PUB|LICATION|
|00001850| 20 22 25 31 22 2e 22 25 | 32 22 20 49 53 20 22 25 | "%1"."%|2" IS "%|
|00001860| 33 22 00 41 4c 54 45 52 | 20 50 55 42 4c 49 43 41 |3".ALTER| PUBLICA|
|00001870| 54 49 4f 4e 20 22 25 31 | 22 2e 22 25 32 22 20 41 |TION "%1|"."%2" A|
|00001880| 44 44 20 25 33 00 41 4c | 54 45 52 20 50 55 42 4c |DD %3.AL|TER PUBL|
|00001890| 49 43 41 54 49 4f 4e 20 | 22 25 31 22 2e 22 25 32 |ICATION |"%1"."%2|
|000018a0| 22 20 4d 4f 44 49 46 59 | 20 25 33 00 41 4c 54 45 |" MODIFY| %3.ALTE|
|000018b0| 52 20 50 55 42 4c 49 43 | 41 54 49 4f 4e 20 22 25 |R PUBLIC|ATION "%|
|000018c0| 31 22 2e 22 25 32 22 20 | 44 45 4c 45 54 45 20 54 |1"."%2" |DELETE T|
|000018d0| 41 42 4c 45 20 22 25 33 | 22 00 43 52 45 41 54 45 |ABLE "%3|".CREATE|
|000018e0| 20 53 55 42 53 43 52 49 | 50 54 49 4f 4e 20 54 4f | SUBSCRI|PTION TO|
|000018f0| 20 22 25 31 22 2e 22 25 | 32 22 25 33 20 46 4f 52 | "%1"."%|2"%3 FOR|
|00001900| 20 25 34 00 28 27 25 31 | 27 29 00 00 44 52 4f 50 | %4.('%1|')..DROP|
|00001910| 20 53 55 42 53 43 52 49 | 50 54 49 4f 4e 20 54 4f | SUBSCRI|PTION TO|
|00001920| 20 22 25 31 22 2e 22 25 | 32 22 25 33 20 46 4f 52 | "%1"."%|2"%3 FOR|
|00001930| 20 25 34 00 28 27 25 31 | 27 29 00 00 53 54 41 52 | %4.('%1|')..STAR|
|00001940| 54 20 53 55 42 53 43 52 | 49 50 54 49 4f 4e 20 54 |T SUBSCR|IPTION T|
|00001950| 4f 20 22 25 31 22 2e 22 | 25 32 22 25 33 20 46 4f |O "%1"."|%2"%3 FO|
|00001960| 52 20 25 34 00 28 27 25 | 31 27 29 00 00 20 44 45 |R %4.('%|1').. DE|
|00001970| 53 43 00 31 00 43 52 45 | 41 54 45 20 50 55 42 4c |SC.1.CRE|ATE PUBL|
|00001980| 49 43 41 54 49 4f 4e 20 | 22 25 31 22 2e 22 25 32 |ICATION |"%1"."%2|
|00001990| 22 20 28 20 25 33 20 29 | 00 43 4f 4d 4d 45 4e 54 |" ( %3 )|.COMMENT|
|000019a0| 20 4f 4e 20 50 55 42 4c | 49 43 41 54 49 4f 4e 20 | ON PUBL|ICATION |
|000019b0| 22 25 31 22 2e 22 25 32 | 22 20 49 53 20 22 25 33 |"%1"."%2|" IS "%3|
|000019c0| 22 00 53 45 4c 45 43 54 | 20 6e 61 6d 65 20 3d 20 |".SELECT| name = |
|000019d0| 28 53 45 4c 45 43 54 20 | 70 75 62 6c 69 63 61 74 |(SELECT |publicat|
|000019e0| 69 6f 6e 5f 6e 61 6d 65 | 20 46 52 4f 4d 20 53 59 |ion_name| FROM SY|
|000019f0| 53 2e 53 59 53 50 55 42 | 4c 49 43 41 54 49 4f 4e |S.SYSPUB|LICATION|
|00001a00| 20 42 20 57 48 45 52 45 | 20 42 2e 70 75 62 6c 69 | B WHERE| B.publi|
|00001a10| 63 61 74 69 6f 6e 5f 69 | 64 20 3d 20 41 2e 70 75 |cation_i|d = A.pu|
|00001a20| 62 6c 69 63 61 74 69 6f | 6e 5f 69 64 29 2c 20 28 |blicatio|n_id), (|
|00001a30| 49 46 20 73 74 61 72 74 | 65 64 20 49 53 20 4e 4f |IF start|ed IS NO|
|00001a40| 54 20 4e 55 4c 4c 20 54 | 48 45 4e 20 27 59 27 20 |T NULL T|HEN 'Y' |
|00001a50| 45 4c 53 45 20 27 4e 27 | 20 45 4e 44 49 46 29 2c |ELSE 'N'| ENDIF),|
|00001a60| 20 73 75 62 73 63 72 69 | 62 65 5f 62 79 20 46 52 | subscri|be_by FR|
|00001a70| 4f 4d 20 53 59 53 2e 53 | 59 53 53 55 42 53 43 52 |OM SYS.S|YSSUBSCR|
|00001a80| 49 50 54 49 4f 4e 20 41 | 20 57 48 45 52 45 20 41 |IPTION A| WHERE A|
|00001a90| 2e 75 73 65 72 5f 69 64 | 20 3d 20 28 53 45 4c 45 |.user_id| = (SELE|
|00001aa0| 43 54 20 75 73 65 72 5f | 69 64 20 46 52 4f 4d 20 |CT user_|id FROM |
|00001ab0| 53 59 53 2e 53 59 53 55 | 53 45 52 50 45 52 4d 53 |SYS.SYSU|SERPERMS|
|00001ac0| 20 57 48 45 52 45 20 75 | 73 65 72 5f 6e 61 6d 65 | WHERE u|ser_name|
|00001ad0| 20 3d 20 27 25 31 27 29 | 20 4f 52 44 45 52 20 42 | = '%1')| ORDER B|
|00001ae0| 59 20 6e 61 6d 65 00 28 | 27 25 31 27 29 00 44 52 |Y name.(|'%1').DR|
|00001af0| 4f 50 20 53 55 42 53 43 | 52 49 50 54 49 4f 4e 20 |OP SUBSC|RIPTION |
|00001b00| 54 4f 20 22 25 31 22 25 | 32 20 46 4f 52 20 22 25 |TO "%1"%|2 FOR "%|
|00001b10| 33 22 00 00 53 54 41 52 | 54 20 53 55 42 53 43 52 |3"..STAR|T SUBSCR|
|00001b20| 49 50 54 49 4f 4e 20 54 | 4f 20 25 31 20 46 4f 52 |IPTION T|O %1 FOR|
|00001b30| 20 25 32 00 53 54 4f 50 | 20 53 55 42 53 43 52 49 | %2.STOP| SUBSCRI|
|00001b40| 50 54 49 4f 4e 20 54 4f | 20 25 31 20 46 4f 52 20 |PTION TO| %1 FOR |
|00001b50| 25 32 00 53 59 4e 43 48 | 52 4f 4e 49 5a 45 20 53 |%2.SYNCH|RONIZE S|
|00001b60| 55 42 53 43 52 49 50 54 | 49 4f 4e 20 54 4f 20 25 |UBSCRIPT|ION TO %|
|00001b70| 31 20 46 4f 52 20 25 32 | 00 53 45 4c 45 43 54 20 |1 FOR %2|.SELECT |
|00001b80| 28 53 45 4c 45 43 54 20 | 75 73 65 72 5f 6e 61 6d |(SELECT |user_nam|
|00001b90| 65 20 46 52 4f 4d 20 53 | 59 53 2e 53 59 53 55 53 |e FROM S|YS.SYSUS|
|00001ba0| 45 52 50 45 52 4d 53 20 | 41 20 57 48 45 52 45 20 |ERPERMS |A WHERE |
|00001bb0| 41 2e 75 73 65 72 5f 69 | 64 20 3d 20 42 2e 75 73 |A.user_i|d = B.us|
|00001bc0| 65 72 5f 69 64 29 2c 20 | 28 49 46 20 73 74 61 72 |er_id), |(IF star|
|00001bd0| 74 65 64 20 49 53 20 4e | 4f 54 20 4e 55 4c 4c 20 |ted IS N|OT NULL |
|00001be0| 54 48 45 4e 20 27 59 27 | 20 45 4c 53 45 20 27 4e |THEN 'Y'| ELSE 'N|
|00001bf0| 27 20 45 4e 44 49 46 29 | 2c 20 73 75 62 73 63 72 |' ENDIF)|, subscr|
|00001c00| 69 62 65 5f 62 79 20 46 | 52 4f 4d 20 53 59 53 2e |ibe_by F|ROM SYS.|
|00001c10| 53 59 53 53 55 42 53 43 | 52 49 50 54 49 4f 4e 20 |SYSSUBSC|RIPTION |
|00001c20| 42 20 4a 4f 49 4e 20 53 | 59 53 2e 53 59 53 50 55 |B JOIN S|YS.SYSPU|
|00001c30| 42 4c 49 43 41 54 49 4f | 4e 20 57 48 45 52 45 20 |BLICATIO|N WHERE |
|00001c40| 70 75 62 6c 69 63 61 74 | 69 6f 6e 5f 6e 61 6d 65 |publicat|ion_name|
|00001c50| 20 3d 20 27 25 31 27 00 | 44 52 4f 50 20 50 55 42 | = '%1'.|DROP PUB|
|00001c60| 4c 49 43 41 54 49 4f 4e | 20 22 25 31 22 2e 22 25 |LICATION| "%1"."%|
|00001c70| 32 22 00 53 45 4c 45 43 | 54 20 63 6f 75 6e 74 28 |2".SELEC|T count(|
|00001c80| 2a 29 20 46 52 4f 4d 20 | 53 59 53 2e 53 59 53 50 |*) FROM |SYS.SYSP|
|00001c90| 55 42 4c 49 43 41 54 49 | 4f 4e 00 53 45 4c 45 43 |UBLICATI|ON.SELEC|
|00001ca0| 54 20 70 75 62 6c 69 63 | 61 74 69 6f 6e 5f 6e 61 |T public|ation_na|
|00001cb0| 6d 65 2c 20 28 53 45 4c | 45 43 54 20 75 73 65 72 |me, (SEL|ECT user|
|00001cc0| 5f 6e 61 6d 65 20 46 52 | 4f 4d 20 53 59 53 2e 53 |_name FR|OM SYS.S|
|00001cd0| 59 53 55 53 45 52 50 45 | 52 4d 53 20 57 48 45 52 |YSUSERPE|RMS WHER|
|00001ce0| 45 20 75 73 65 72 5f 69 | 64 20 3d 20 63 72 65 61 |E user_i|d = crea|
|00001cf0| 74 6f 72 29 2c 20 72 65 | 6d 61 72 6b 73 20 46 52 |tor), re|marks FR|
|00001d00| 4f 4d 20 53 59 53 2e 53 | 59 53 50 55 42 4c 49 43 |OM SYS.S|YSPUBLIC|
|00001d10| 41 54 49 4f 4e 20 4f 52 | 44 45 52 20 42 59 20 25 |ATION OR|DER BY %|
|00001d20| 31 00 53 45 4c 45 43 54 | 20 70 75 62 6c 69 63 61 |1.SELECT| publica|
|00001d30| 74 69 6f 6e 5f 69 64 2c | 20 50 2e 72 65 6d 61 72 |tion_id,| P.remar|
|00001d40| 6b 73 2c 20 75 73 65 72 | 5f 6e 61 6d 65 20 46 52 |ks, user|_name FR|
|00001d50| 4f 4d 20 53 59 53 2e 53 | 59 53 50 55 42 4c 49 43 |OM SYS.S|YSPUBLIC|
|00001d60| 41 54 49 4f 4e 20 50 20 | 4a 4f 49 4e 20 53 59 53 |ATION P |JOIN SYS|
|00001d70| 2e 53 59 53 55 53 45 52 | 50 45 52 4d 53 20 4f 4e |.SYSUSER|PERMS ON|
|00001d80| 20 63 72 65 61 74 6f 72 | 20 3d 20 75 73 65 72 5f | creator| = user_|
|00001d90| 69 64 20 57 48 45 52 45 | 20 70 75 62 6c 69 63 61 |id WHERE| publica|
|00001da0| 74 69 6f 6e 5f 6e 61 6d | 65 20 3d 20 27 25 31 27 |tion_nam|e = '%1'|
|00001db0| 00 53 45 4c 45 43 54 20 | 70 75 62 6c 69 63 61 74 |.SELECT |publicat|
|00001dc0| 69 6f 6e 5f 69 64 2c 20 | 50 2e 72 65 6d 61 72 6b |ion_id, |P.remark|
|00001dd0| 73 2c 20 75 73 65 72 5f | 6e 61 6d 65 20 46 52 4f |s, user_|name FRO|
|00001de0| 4d 20 53 59 53 2e 53 59 | 53 50 55 42 4c 49 43 41 |M SYS.SY|SPUBLICA|
|00001df0| 54 49 4f 4e 20 50 20 4a | 4f 49 4e 20 53 59 53 2e |TION P J|OIN SYS.|
|00001e00| 53 59 53 55 53 45 52 50 | 45 52 4d 53 20 4f 4e 20 |SYSUSERP|ERMS ON |
|00001e10| 63 72 65 61 74 6f 72 20 | 3d 20 75 73 65 72 5f 69 |creator |= user_i|
|00001e20| 64 20 57 48 45 52 45 20 | 70 75 62 6c 69 63 61 74 |d WHERE |publicat|
|00001e30| 69 6f 6e 5f 6e 61 6d 65 | 20 3d 20 27 25 31 27 20 |ion_name| = '%1' |
|00001e40| 41 4e 44 20 75 73 65 72 | 5f 6e 61 6d 65 20 3d 20 |AND user|_name = |
|00001e50| 27 25 32 27 00 00 00 00 | 55 6e 6b 6e 6f 77 6e 20 |'%2'....|Unknown |
|00001e60| 64 61 74 61 62 61 73 65 | 20 65 72 72 6f 72 00 00 |database| error..|
|00001e70| 73 74 61 63 6b 20 64 61 | 74 61 20 68 61 73 20 62 |stack da|ta has b|
|00001e80| 65 65 6e 20 63 6f 72 72 | 75 70 74 65 64 21 00 76 |een corr|upted!.v|
|00001e90| 69 6f 6c 61 74 69 6f 6e | 20 6f 66 20 66 75 6e 63 |iolation| of func|
|00001ea0| 74 69 6f 6e 20 65 78 63 | 65 70 74 69 6f 6e 20 73 |tion exc|eption s|
|00001eb0| 70 65 63 69 66 69 63 61 | 74 69 6f 6e 21 00 74 68 |pecifica|tion!.th|
|00001ec0| 72 6f 77 20 77 68 69 6c | 65 20 22 74 65 72 6d 69 |row whil|e "termi|
|00001ed0| 6e 61 74 65 22 20 66 75 | 6e 63 74 69 6f 6e 20 61 |nate" fu|nction a|
|00001ee0| 63 74 69 76 65 21 00 74 | 68 72 6f 77 20 64 75 72 |ctive!.t|hrow dur|
|00001ef0| 69 6e 67 20 64 65 73 74 | 72 75 63 74 6f 72 20 77 |ing dest|ructor w|
|00001f00| 68 69 6c 65 20 75 6e 77 | 69 6e 64 69 6e 67 20 73 |hile unw|inding s|
|00001f10| 74 61 63 6b 20 74 6f 20 | 63 61 74 63 68 20 65 78 |tack to |catch ex|
|00001f20| 63 65 70 74 69 6f 6e 21 | 00 74 68 72 6f 77 20 77 |ception!|.throw w|
|00001f30| 68 69 6c 65 20 22 74 65 | 72 6d 69 6e 61 74 65 22 |hile "te|rminate"|
|00001f40| 20 66 75 6e 63 74 69 6f | 6e 20 61 63 74 69 76 65 | functio|n active|
|00001f50| 21 00 74 68 72 6f 77 20 | 64 75 72 69 6e 67 20 63 |!.throw |during c|
|00001f60| 6f 6e 73 74 72 75 63 74 | 69 6f 6e 20 6f 66 20 65 |onstruct|ion of e|
|00001f70| 78 63 65 70 74 69 6f 6e | 21 00 74 68 72 6f 77 20 |xception|!.throw |
|00001f80| 64 75 72 69 6e 67 20 64 | 65 73 74 72 75 63 74 6f |during d|estructo|
|00001f90| 72 20 66 6f 72 20 68 61 | 6e 64 6c 65 64 20 65 78 |r for ha|ndled ex|
|00001fa0| 63 65 70 74 69 6f 6e 21 | 00 72 65 2d 74 68 72 6f |ception!|.re-thro|
|00001fb0| 77 20 77 68 65 6e 20 6e | 6f 20 65 78 63 65 70 74 |w when n|o except|
|00001fc0| 69 6f 6e 20 68 61 6e 64 | 6c 65 72 20 61 63 74 69 |ion hand|ler acti|
|00001fd0| 76 65 21 00 6e 6f 20 68 | 61 6e 64 6c 65 72 20 61 |ve!.no h|andler a|
|00001fe0| 63 74 69 76 65 20 74 6f | 20 63 61 74 63 68 20 74 |ctive to| catch t|
|00001ff0| 68 72 6f 77 6e 20 6f 62 | 6a 65 63 74 21 00 72 65 |hrown ob|ject!.re|
|00002000| 2d 74 68 72 6f 77 20 77 | 68 65 6e 20 6e 6f 20 65 |-throw w|hen no e|
|00002010| 78 63 65 70 74 69 6f 6e | 20 68 61 6e 64 6c 65 72 |xception| handler|
|00002020| 20 61 63 74 69 76 65 21 | 00 6e 6f 20 68 61 6e 64 | active!|.no hand|
|00002030| 6c 65 72 20 61 63 74 69 | 76 65 20 74 6f 20 63 61 |ler acti|ve to ca|
|00002040| 74 63 68 20 74 68 72 6f | 77 6e 20 6f 62 6a 65 63 |tch thro|wn objec|
|00002050| 74 21 00 73 79 73 74 65 | 6d 20 65 78 63 65 70 74 |t!.syste|m except|
|00002060| 69 6f 6e 21 20 63 6f 64 | 65 20 3d 20 30 78 30 30 |ion! cod|e = 0x00|
|00002070| 30 30 30 30 30 30 00 00 | 70 75 72 65 20 76 69 72 |000000..|pure vir|
|00002080| 74 75 61 6c 20 66 75 6e | 63 74 69 6f 6e 20 63 61 |tual fun|ction ca|
|00002090| 6c 6c 65 64 21 00 00 00 | 4e 59 49 00 4e 59 49 00 |lled!...|NYI.NYI.|
|000020a0| 4e 59 49 00 00 00 00 00 | 63 6f 6d 70 69 6c 65 72 |NYI.....|compiler|
|000020b0| 20 65 72 72 6f 72 3a 20 | 65 6c 69 6d 69 6e 61 74 | error: |eliminat|
|000020c0| 65 64 20 76 69 72 74 75 | 61 6c 20 66 75 6e 63 74 |ed virtu|al funct|
|000020d0| 69 6f 6e 20 63 61 6c 6c | 21 00 00 00 75 6e 64 65 |ion call|!...unde|
|000020e0| 66 69 6e 65 64 20 63 6f | 6e 73 74 72 75 63 74 6f |fined co|nstructo|
|000020f0| 72 20 6f 72 20 64 65 73 | 74 72 75 63 74 6f 72 20 |r or des|tructor |
|00002100| 63 61 6c 6c 65 64 21 00 | 22 00 00 00 59 00 4e 00 |called!.|"...Y.N.|
|00002110| 53 45 54 20 54 45 4d 50 | 4f 52 41 52 59 20 4f 50 |SET TEMP|ORARY OP|
|00002120| 54 49 4f 4e 20 52 4f 57 | 5f 43 4f 55 4e 54 53 20 |TION ROW|_COUNTS |
|00002130| 3d 20 27 4f 4e 27 00 53 | 45 54 20 54 45 4d 50 4f |= 'ON'.S|ET TEMPO|
|00002140| 52 41 52 59 20 4f 50 54 | 49 4f 4e 20 52 4f 57 5f |RARY OPT|ION ROW_|
|00002150| 43 4f 55 4e 54 53 20 3d | 20 27 4f 46 46 27 00 00 |COUNTS =| 'OFF'..|
|00002160| 43 65 6e 74 65 72 00 43 | 65 6e 74 65 72 00 43 65 |Center.C|enter.Ce|
|00002170| 6e 74 65 72 00 53 79 62 | 61 73 65 20 43 65 6e 74 |nter.Syb|ase Cent|
|00002180| 72 61 6c 00 4f 75 74 20 | 6f 66 20 6d 65 6d 6f 72 |ral.Out |of memor|
|00002190| 79 00 43 65 6e 74 65 72 | 00 43 65 6e 74 65 72 00 |y.Center|.Center.|
|000021a0| 53 79 62 61 73 65 20 43 | 65 6e 74 72 61 6c 00 4f |Sybase C|entral.O|
|000021b0| 75 74 20 6f 66 20 6d 65 | 6d 6f 72 79 00 00 42 75 |ut of me|mory..Bu|
|000021c0| 74 74 6f 6e 00 00 00 00 | 00 34 2e 30 00 35 2e 35 |tton....|.4.0.5.5|
|000021d0| 2e 30 33 00 35 2e 30 00 | 59 45 53 00 53 45 4c 45 |.03.5.0.|YES.SELE|
|000021e0| 43 54 20 2a 20 46 52 4f | 4d 20 53 59 53 2e 53 59 |CT * FRO|M SYS.SY|
|000021f0| 53 54 41 42 4c 45 00 53 | 45 4c 45 43 54 20 75 73 |STABLE.S|ELECT us|
|00002200| 65 72 5f 6e 61 6d 65 28 | 29 00 53 45 4c 45 43 54 |er_name(|).SELECT|
|00002210| 20 2a 20 46 52 4f 4d 20 | 53 59 53 2e 53 59 53 55 | * FROM |SYS.SYSU|
|00002220| 53 45 52 50 45 52 4d 00 | 22 25 31 22 2e 22 25 32 |SERPERM.|"%1"."%2|
|00002230| 22 00 43 52 45 41 54 45 | 20 53 54 41 54 49 53 54 |".CREATE| STATIST|
|00002240| 49 43 53 00 2e 00 22 00 | 2e 00 22 00 50 41 53 53 |ICS...".|..".PASS|
|00002250| 54 48 52 4f 55 47 48 20 | 00 50 41 53 53 54 48 52 |THROUGH |.PASSTHR|
|00002260| 4f 55 47 48 20 4f 4e 4c | 59 20 00 46 4f 52 20 22 |OUGH ONL|Y .FOR "|
|00002270| 25 31 22 00 46 4f 52 20 | 53 55 42 53 43 52 49 50 |%1".FOR |SUBSCRIP|
|00002280| 54 49 4f 4e 20 54 4f 20 | 25 31 00 50 41 53 53 54 |TION TO |%1.PASST|
|00002290| 48 52 4f 55 47 48 20 53 | 54 4f 50 00 53 45 4c 45 |HROUGH S|TOP.SELE|
|000022a0| 43 54 20 6e 65 78 74 5f | 64 61 74 61 62 61 73 65 |CT next_|database|
|000022b0| 28 25 31 29 00 70 72 69 | 6e 74 27 27 00 53 45 4c |(%1).pri|nt''.SEL|
|000022c0| 45 43 54 20 64 62 5f 70 | 72 6f 70 65 72 74 79 28 |ECT db_p|roperty(|
|000022d0| 20 27 41 6c 69 61 73 27 | 2c 20 25 31 20 29 00 53 | 'Alias'|, %1 ).S|
|000022e0| 45 4c 45 43 54 20 64 62 | 5f 70 72 6f 70 65 72 74 |ELECT db|_propert|
|000022f0| 79 28 20 27 43 6f 6e 6e | 43 6f 75 6e 74 27 2c 20 |y( 'Conn|Count', |
|00002300| 25 31 20 29 00 53 45 4c | 45 43 54 20 64 62 5f 70 |%1 ).SEL|ECT db_p|
|00002310| 72 6f 70 65 72 74 79 28 | 20 27 41 6c 69 61 73 27 |roperty(| 'Alias'|
|00002320| 2c 20 25 31 20 29 2c 20 | 64 62 5f 70 72 6f 70 65 |, %1 ), |db_prope|
|00002330| 72 74 79 28 20 27 46 69 | 6c 65 27 2c 20 25 32 20 |rty( 'Fi|le', %2 |
|00002340| 29 2c 20 64 62 5f 70 72 | 6f 70 65 72 74 79 28 20 |), db_pr|operty( |
|00002350| 27 43 6f 6e 6e 43 6f 75 | 6e 74 27 2c 20 25 33 20 |'ConnCou|nt', %3 |
|00002360| 29 2c 20 64 62 5f 70 72 | 6f 70 65 72 74 79 28 20 |), db_pr|operty( |
|00002370| 27 50 61 67 65 53 69 7a | 65 27 2c 20 25 34 20 29 |'PageSiz|e', %4 )|
|00002380| 2c 20 64 62 5f 70 72 6f | 70 65 72 74 79 28 20 27 |, db_pro|perty( '|
|00002390| 4c 6f 67 4e 61 6d 65 27 | 2c 20 25 35 20 29 00 59 |LogName'|, %5 ).Y|
|000023a0| 00 53 59 53 00 44 42 4f | 00 46 69 6c 74 65 72 43 |.SYS.DBO|.FilterC|
|000023b0| 6f 6e 66 69 67 00 24 00 | 24 00 24 00 46 69 6c 74 |onfig.$.|$.$.Filt|
|000023c0| 65 72 43 6f 6e 66 69 67 | 00 00 73 65 6c 65 63 74 |erConfig|..select|
|000023d0| 20 40 40 76 65 72 73 69 | 6f 6e 20 66 72 6f 6d 20 | @@versi|on from |
|000023e0| 53 59 53 2e 44 55 4d 4d | 59 00 73 65 6c 65 63 74 |SYS.DUMM|Y.select|
|000023f0| 20 64 61 74 61 62 61 73 | 65 5f 76 65 72 73 69 6f | databas|e_versio|
|00002400| 6e 20 66 72 6f 6d 20 53 | 59 53 2e 53 59 53 49 4e |n from S|YS.SYSIN|
|00002410| 46 4f 00 73 65 6c 65 63 | 74 20 2a 20 66 72 6f 6d |FO.selec|t * from|
|00002420| 20 53 59 53 2e 53 59 53 | 4c 4f 47 49 4e 00 44 45 | SYS.SYS|LOGIN.DE|
|00002430| 43 4c 41 52 45 20 4c 4f | 43 41 4c 20 54 45 4d 50 |CLARE LO|CAL TEMP|
|00002440| 4f 52 41 52 59 20 54 41 | 42 4c 45 20 64 62 78 5f |ORARY TA|BLE dbx_|
|00002450| 66 69 6c 74 65 72 5f 6c | 69 73 74 20 28 20 63 72 |filter_l|ist ( cr|
|00002460| 65 61 74 6f 72 20 69 6e | 74 20 29 20 4f 4e 20 43 |eator in|t ) ON C|
|00002470| 4f 4d 4d 49 54 20 50 52 | 45 53 45 52 56 45 20 52 |OMMIT PR|ESERVE R|
|00002480| 4f 57 53 00 44 45 4c 45 | 54 45 20 46 52 4f 4d 20 |OWS.DELE|TE FROM |
|00002490| 64 62 78 5f 66 69 6c 74 | 65 72 5f 6c 69 73 74 00 |dbx_filt|er_list.|
|000024a0| 49 4e 53 45 52 54 20 49 | 4e 54 4f 20 64 62 78 5f |INSERT I|NTO dbx_|
|000024b0| 66 69 6c 74 65 72 5f 6c | 69 73 74 28 20 22 63 72 |filter_l|ist( "cr|
|000024c0| 65 61 74 6f 72 22 20 29 | 20 56 41 4c 55 45 53 28 |eator" )| VALUES(|
|000024d0| 20 25 31 20 29 00 73 65 | 6c 65 63 74 20 28 20 69 | %1 ).se|lect ( i|
|000024e0| 66 20 25 31 20 69 6e 20 | 28 20 73 65 6c 65 63 74 |f %1 in |( select|
|000024f0| 20 63 72 65 61 74 6f 72 | 20 66 72 6f 6d 20 64 62 | creator| from db|
|00002500| 78 5f 66 69 6c 74 65 72 | 5f 6c 69 73 74 20 29 20 |x_filter|_list ) |
|00002510| 74 68 65 6e 20 27 59 27 | 20 65 6c 73 65 20 27 4e |then 'Y'| else 'N|
|00002520| 27 20 65 6e 64 69 66 20 | 29 00 53 45 4c 45 43 54 |' endif |).SELECT|
|00002530| 20 75 73 65 72 5f 69 64 | 20 66 72 6f 6d 20 53 59 | user_id| from SY|
|00002540| 53 2e 53 59 53 55 53 45 | 52 50 45 52 4d 53 20 57 |S.SYSUSE|RPERMS W|
|00002550| 48 45 52 45 20 75 73 65 | 72 5f 6e 61 6d 65 20 3d |HERE use|r_name =|
|00002560| 20 27 25 31 27 00 53 45 | 4c 45 43 54 20 75 73 65 | '%1'.SE|LECT use|
|00002570| 72 5f 6e 61 6d 65 20 66 | 72 6f 6d 20 53 59 53 2e |r_name f|rom SYS.|
|00002580| 53 59 53 55 53 45 52 50 | 45 52 4d 53 20 57 48 45 |SYSUSERP|ERMS WHE|
|00002590| 52 45 20 75 73 65 72 5f | 69 64 20 3d 20 27 25 31 |RE user_|id = '%1|
|000025a0| 27 00 53 45 4c 45 43 54 | 20 2a 20 66 72 6f 6d 20 |'.SELECT| * from |
|000025b0| 64 62 78 5f 66 69 6c 74 | 65 72 5f 6c 69 73 74 00 |dbx_filt|er_list.|
|000025c0| 43 4f 4d 4d 49 54 00 52 | 4f 4c 4c 42 41 43 4b 00 |COMMIT.R|OLLBACK.|
|000025d0| 53 45 4c 45 43 54 20 63 | 72 65 61 74 6f 72 20 46 |SELECT c|reator F|
|000025e0| 52 4f 4d 20 53 59 53 2e | 53 59 53 54 41 42 4c 45 |ROM SYS.|SYSTABLE|
|000025f0| 20 57 48 45 52 45 20 74 | 61 62 6c 65 5f 6e 61 6d | WHERE t|able_nam|
|00002600| 65 20 3d 20 27 52 6f 77 | 47 65 6e 65 72 61 74 6f |e = 'Row|Generato|
|00002610| 72 27 00 53 45 4c 45 43 | 54 20 43 55 52 52 45 4e |r'.SELEC|T CURREN|
|00002620| 54 20 55 53 45 52 00 51 | 75 6f 74 65 64 5f 69 64 |T USER.Q|uoted_id|
|00002630| 65 6e 74 69 66 69 65 72 | 00 4f 4e 00 4f 46 46 00 |entifier|.ON.OFF.|
|00002640| 00 2c 20 00 22 00 22 00 | 00 2c 20 00 53 45 4c 45 |., .".".|., .SELE|
|00002650| 43 54 20 63 6f 6c 75 6d | 6e 5f 6e 61 6d 65 2c 20 |CT colum|n_name, |
|00002660| 28 53 45 4c 45 43 54 20 | 64 6f 6d 61 69 6e 5f 6e |(SELECT |domain_n|
|00002670| 61 6d 65 20 46 52 4f 4d | 20 53 59 53 2e 53 59 53 |ame FROM| SYS.SYS|
|00002680| 44 4f 4d 41 49 4e 20 58 | 20 57 48 45 52 45 20 58 |DOMAIN X| WHERE X|
|00002690| 2e 64 6f 6d 61 69 6e 5f | 69 64 20 3d 20 53 59 53 |.domain_|id = SYS|
|000026a0| 2e 53 59 53 43 4f 4c 55 | 4d 4e 2e 64 6f 6d 61 69 |.SYSCOLU|MN.domai|
|000026b0| 6e 5f 69 64 29 2c 20 28 | 53 45 4c 45 43 54 20 74 |n_id), (|SELECT t|
|000026c0| 79 70 65 5f 6e 61 6d 65 | 20 46 52 4f 4d 20 53 59 |ype_name| FROM SY|
|000026d0| 53 2e 53 59 53 55 53 45 | 52 54 59 50 45 20 57 48 |S.SYSUSE|RTYPE WH|
|000026e0| 45 52 45 20 74 79 70 65 | 5f 69 64 20 3d 20 75 73 |ERE type|_id = us|
|000026f0| 65 72 5f 74 79 70 65 29 | 2c 20 77 69 64 74 68 2c |er_type)|, width,|
|00002700| 20 73 63 61 6c 65 2c 20 | 72 65 6d 61 72 6b 73 2c | scale, |remarks,|
|00002710| 20 22 64 65 66 61 75 6c | 74 22 2c 20 6e 75 6c 6c | "defaul|t", null|
|00002720| 73 2c 20 28 53 45 4c 45 | 43 54 20 63 6f 75 6e 74 |s, (SELE|CT count|
|00002730| 28 2a 29 20 46 52 4f 4d | 20 53 59 53 2e 53 59 53 |(*) FROM| SYS.SYS|
|00002740| 49 4e 44 45 58 20 69 78 | 20 57 48 45 52 45 20 74 |INDEX ix| WHERE t|
|00002750| 61 62 6c 65 5f 69 64 20 | 3d 20 25 31 20 61 6e 64 |able_id |= %1 and|
|00002760| 20 22 75 6e 69 71 75 65 | 22 20 3d 20 27 55 27 20 | "unique|" = 'U' |
|00002770| 41 4e 44 20 31 20 3d 20 | 28 53 45 4c 45 43 54 20 |AND 1 = |(SELECT |
|00002780| 63 6f 75 6e 74 28 2a 29 | 20 46 52 4f 4d 20 53 59 |count(*)| FROM SY|
|00002790| 53 2e 53 59 53 49 58 43 | 4f 4c 20 59 20 4a 4f 49 |S.SYSIXC|OL Y JOI|
|000027a0| 4e 20 53 59 53 2e 53 59 | 53 43 4f 4c 55 4d 4e 20 |N SYS.SY|SCOLUMN |
|000027b0| 41 20 57 48 45 52 45 20 | 59 2e 74 61 62 6c 65 5f |A WHERE |Y.table_|
|000027c0| 69 64 20 3d 20 69 78 2e | 74 61 62 6c 65 5f 69 64 |id = ix.|table_id|
|000027d0| 20 41 4e 44 20 69 6e 64 | 65 78 5f 69 64 20 3d 20 | AND ind|ex_id = |
|000027e0| 69 78 2e 69 6e 64 65 78 | 5f 69 64 20 41 4e 44 20 |ix.index|_id AND |
|000027f0| 41 2e 63 6f 6c 75 6d 6e | 5f 6e 61 6d 65 20 3d 20 |A.column|_name = |
|00002800| 63 6f 6c 75 6d 6e 5f 6e | 61 6d 65 20 41 4e 44 20 |column_n|ame AND |
|00002810| 59 2e 63 6f 6c 75 6d 6e | 5f 69 64 20 3d 20 53 59 |Y.column|_id = SY|
|00002820| 53 2e 53 59 53 43 4f 4c | 55 4d 4e 2e 63 6f 6c 75 |S.SYSCOL|UMN.colu|
|00002830| 6d 6e 5f 69 64 29 20 41 | 4e 44 20 30 20 3d 20 28 |mn_id) A|ND 0 = (|
|00002840| 53 45 4c 45 43 54 20 63 | 6f 75 6e 74 28 2a 29 20 |SELECT c|ount(*) |
|00002850| 46 52 4f 4d 20 53 59 53 | 2e 53 59 53 49 58 43 4f |FROM SYS|.SYSIXCO|
|00002860| 4c 20 5a 20 4a 4f 49 4e | 20 53 59 53 2e 53 59 53 |L Z JOIN| SYS.SYS|
|00002870| 43 4f 4c 55 4d 4e 20 42 | 20 57 48 45 52 45 20 5a |COLUMN B| WHERE Z|
|00002880| 2e 74 61 62 6c 65 5f 69 | 64 20 3d 20 69 78 2e 74 |.table_i|d = ix.t|
|00002890| 61 62 6c 65 5f 69 64 20 | 41 4e 44 20 69 6e 64 65 |able_id |AND inde|
|000028a0| 78 5f 69 64 20 3d 20 69 | 78 2e 69 6e 64 65 78 5f |x_id = i|x.index_|
|000028b0| 69 64 20 41 4e 44 20 42 | 2e 63 6f 6c 75 6d 6e 5f |id AND B|.column_|
|000028c0| 6e 61 6d 65 20 3d 20 63 | 6f 6c 75 6d 6e 5f 6e 61 |name = c|olumn_na|
|000028d0| 6d 65 20 41 4e 44 20 5a | 2e 63 6f 6c 75 6d 6e 5f |me AND Z|.column_|
|000028e0| 69 64 20 3c 3e 20 53 59 | 53 2e 53 59 53 43 4f 4c |id <> SY|S.SYSCOL|
|000028f0| 55 4d 4e 2e 63 6f 6c 75 | 6d 6e 5f 69 64 29 29 2c |UMN.colu|mn_id)),|
|00002900| 20 70 6b 65 79 2c 20 22 | 63 68 65 63 6b 22 2c 20 | pkey, "|check", |
|00002910| 63 6f 6c 75 6d 6e 5f 69 | 64 20 46 52 4f 4d 20 53 |column_i|d FROM S|
|00002920| 59 53 2e 53 59 53 43 4f | 4c 55 4d 4e 20 57 48 45 |YS.SYSCO|LUMN WHE|
|00002930| 52 45 20 74 61 62 6c 65 | 5f 69 64 20 3d 20 25 31 |RE table|_id = %1|
|00002940| 20 4f 52 44 45 52 20 42 | 59 20 63 6f 6c 75 6d 6e | ORDER B|Y column|
|00002950| 5f 69 64 00 53 45 4c 45 | 43 54 20 63 6f 6c 75 6d |_id.SELE|CT colum|
|00002960| 6e 5f 6e 61 6d 65 2c 20 | 28 53 45 4c 45 43 54 20 |n_name, |(SELECT |
|00002970| 64 6f 6d 61 69 6e 5f 6e | 61 6d 65 20 46 52 4f 4d |domain_n|ame FROM|
|00002980| 20 53 59 53 2e 53 59 53 | 44 4f 4d 41 49 4e 20 58 | SYS.SYS|DOMAIN X|
|00002990| 20 57 48 45 52 45 20 58 | 2e 64 6f 6d 61 69 6e 5f | WHERE X|.domain_|
|000029a0| 69 64 20 3d 20 53 59 53 | 2e 53 59 53 43 4f 4c 55 |id = SYS|.SYSCOLU|
|000029b0| 4d 4e 2e 64 6f 6d 61 69 | 6e 5f 69 64 29 2c 20 4e |MN.domai|n_id), N|
|000029c0| 55 4c 4c 2c 20 77 69 64 | 74 68 2c 20 73 63 61 6c |ULL, wid|th, scal|
|000029d0| 65 2c 20 72 65 6d 61 72 | 6b 73 2c 20 22 64 65 66 |e, remar|ks, "def|
|000029e0| 61 75 6c 74 22 2c 20 6e | 75 6c 6c 73 2c 20 28 53 |ault", n|ulls, (S|
|000029f0| 45 4c 45 43 54 20 63 6f | 75 6e 74 28 2a 29 20 46 |ELECT co|unt(*) F|
|00002a00| 52 4f 4d 20 53 59 53 2e | 53 59 53 49 4e 44 45 58 |ROM SYS.|SYSINDEX|
|00002a10| 20 69 78 20 57 48 45 52 | 45 20 74 61 62 6c 65 5f | ix WHER|E table_|
|00002a20| 69 64 20 3d 20 25 31 20 | 61 6e 64 20 22 75 6e 69 |id = %1 |and "uni|
|00002a30| 71 75 65 22 20 3d 20 27 | 55 27 20 41 4e 44 20 31 |que" = '|U' AND 1|
|00002a40| 20 3d 20 28 53 45 4c 45 | 43 54 20 63 6f 75 6e 74 | = (SELE|CT count|
|00002a50| 28 2a 29 20 46 52 4f 4d | 20 53 59 53 2e 53 59 53 |(*) FROM| SYS.SYS|
|00002a60| 49 58 43 4f 4c 20 59 20 | 4a 4f 49 4e 20 53 59 53 |IXCOL Y |JOIN SYS|
|00002a70| 2e 53 59 53 43 4f 4c 55 | 4d 4e 20 41 20 57 48 45 |.SYSCOLU|MN A WHE|
|00002a80| 52 45 20 59 2e 74 61 62 | 6c 65 5f 69 64 20 3d 20 |RE Y.tab|le_id = |
|00002a90| 69 78 2e 74 61 62 6c 65 | 5f 69 64 20 41 4e 44 20 |ix.table|_id AND |
|00002aa0| 69 6e 64 65 78 5f 69 64 | 20 3d 20 69 78 2e 69 6e |index_id| = ix.in|
|00002ab0| 64 65 78 5f 69 64 20 41 | 4e 44 20 41 2e 63 6f 6c |dex_id A|ND A.col|
|00002ac0| 75 6d 6e 5f 6e 61 6d 65 | 20 3d 20 63 6f 6c 75 6d |umn_name| = colum|
|00002ad0| 6e 5f 6e 61 6d 65 20 41 | 4e 44 20 59 2e 63 6f 6c |n_name A|ND Y.col|
|00002ae0| 75 6d 6e 5f 69 64 20 3d | 20 53 59 53 2e 53 59 53 |umn_id =| SYS.SYS|
|00002af0| 43 4f 4c 55 4d 4e 2e 63 | 6f 6c 75 6d 6e 5f 69 64 |COLUMN.c|olumn_id|
|00002b00| 29 20 41 4e 44 20 30 20 | 3d 20 28 53 45 4c 45 43 |) AND 0 |= (SELEC|
|00002b10| 54 20 63 6f 75 6e 74 28 | 2a 29 20 46 52 4f 4d 20 |T count(|*) FROM |
|00002b20| 53 59 53 2e 53 59 53 49 | 58 43 4f 4c 20 5a 20 4a |SYS.SYSI|XCOL Z J|
|00002b30| 4f 49 4e 20 53 59 53 2e | 53 59 53 43 4f 4c 55 4d |OIN SYS.|SYSCOLUM|
|00002b40| 4e 20 42 20 57 48 45 52 | 45 20 5a 2e 74 61 62 6c |N B WHER|E Z.tabl|
|00002b50| 65 5f 69 64 20 3d 20 69 | 78 2e 74 61 62 6c 65 5f |e_id = i|x.table_|
|00002b60| 69 64 20 41 4e 44 20 69 | 6e 64 65 78 5f 69 64 20 |id AND i|ndex_id |
|00002b70| 3d 20 69 78 2e 69 6e 64 | 65 78 5f 69 64 20 41 4e |= ix.ind|ex_id AN|
|00002b80| 44 20 42 2e 63 6f 6c 75 | 6d 6e 5f 6e 61 6d 65 20 |D B.colu|mn_name |
|00002b90| 3d 20 63 6f 6c 75 6d 6e | 5f 6e 61 6d 65 20 41 4e |= column|_name AN|
|00002ba0| 44 20 5a 2e 63 6f 6c 75 | 6d 6e 5f 69 64 20 3c 3e |D Z.colu|mn_id <>|
|00002bb0| 20 53 59 53 2e 53 59 53 | 43 4f 4c 55 4d 4e 2e 63 | SYS.SYS|COLUMN.c|
|00002bc0| 6f 6c 75 6d 6e 5f 69 64 | 29 29 2c 20 70 6b 65 79 |olumn_id|)), pkey|
|00002bd0| 2c 20 4e 55 4c 4c 2c 20 | 63 6f 6c 75 6d 6e 5f 69 |, NULL, |column_i|
|00002be0| 64 20 46 52 4f 4d 20 53 | 59 53 2e 53 59 53 43 4f |d FROM S|YS.SYSCO|
|00002bf0| 4c 55 4d 4e 20 57 48 45 | 52 45 20 74 61 62 6c 65 |LUMN WHE|RE table|
|00002c00| 5f 69 64 20 3d 20 25 31 | 20 4f 52 44 45 52 20 42 |_id = %1| ORDER B|
|00002c10| 59 20 63 6f 6c 75 6d 6e | 5f 69 64 00 30 00 4e 00 |Y column|_id.0.N.|
|00002c20| 59 00 20 4e 55 4c 4c 00 | 20 4e 4f 54 20 4e 55 4c |Y. NULL.| NOT NUL|
|00002c30| 4c 00 20 55 4e 49 51 55 | 45 00 20 44 45 46 41 55 |L. UNIQU|E. DEFAU|
|00002c40| 4c 54 20 25 31 00 22 25 | 31 22 20 25 32 20 00 20 |LT %1."%|1" %2 . |
|00002c50| 00 41 4c 54 45 52 20 54 | 41 42 4c 45 20 25 31 20 |.ALTER T|ABLE %1 |
|00002c60| 44 45 4c 45 54 45 20 22 | 25 32 22 00 41 4c 54 45 |DELETE "|%2".ALTE|
|00002c70| 52 20 54 41 42 4c 45 20 | 22 25 31 22 2e 22 25 32 |R TABLE |"%1"."%2|
|00002c80| 22 20 41 44 44 20 25 33 | 00 20 28 0d 0a 00 43 48 |" ADD %3|. (...CH|
|00002c90| 45 43 4b 00 43 4f 4d 4d | 45 4e 54 20 4f 4e 20 43 |ECK.COMM|ENT ON C|
|00002ca0| 4f 4c 55 4d 4e 20 25 31 | 2e 22 25 32 22 20 49 53 |OLUMN %1|."%2" IS|
|00002cb0| 20 22 25 33 22 00 43 4f | 4d 4d 45 4e 54 20 4f 4e | "%3".CO|MMENT ON|
|00002cc0| 20 43 4f 4c 55 4d 4e 20 | 25 31 2e 22 25 32 22 20 | COLUMN |%1."%2" |
|00002cd0| 49 53 20 4e 55 4c 4c 00 | 4d 4f 44 49 46 59 20 22 |IS NULL.|MODIFY "|
|00002ce0| 25 31 22 20 00 43 48 45 | 43 4b 20 4e 55 4c 4c 00 |%1" .CHE|CK NULL.|
|00002cf0| 4d 4f 44 49 46 59 20 22 | 25 31 22 20 25 32 00 4d |MODIFY "|%1" %2.M|
|00002d00| 4f 44 49 46 59 20 22 25 | 31 22 20 44 45 46 41 55 |ODIFY "%|1" DEFAU|
|00002d10| 4c 54 20 25 32 00 4e 55 | 4c 4c 00 4e 4f 54 20 4e |LT %2.NU|LL.NOT N|
|00002d20| 55 4c 4c 00 4d 4f 44 49 | 46 59 20 22 25 31 22 20 |ULL.MODI|FY "%1" |
|00002d30| 25 32 00 00 2c 20 00 00 | 2c 20 00 53 45 4c 45 43 |%2.., ..|, .SELEC|
|00002d40| 54 20 2a 20 46 52 4f 4d | 20 25 31 20 57 48 45 52 |T * FROM| %1 WHER|
|00002d50| 45 20 22 25 32 22 20 49 | 53 20 4e 55 4c 4c 00 41 |E "%2" I|S NULL.A|
|00002d60| 4c 54 45 52 20 54 41 42 | 4c 45 20 25 31 20 4d 4f |LTER TAB|LE %1 MO|
|00002d70| 44 49 46 59 20 22 25 32 | 22 20 25 33 00 41 4c 54 |DIFY "%2|" %3.ALT|
|00002d80| 45 52 20 54 41 42 4c 45 | 20 25 31 20 52 45 4e 41 |ER TABLE| %1 RENA|
|00002d90| 4d 45 20 22 25 32 22 20 | 54 4f 20 22 25 33 22 00 |ME "%2" |TO "%3".|
|00002da0| 41 4c 54 45 52 20 54 41 | 42 4c 45 20 25 31 20 4d |ALTER TA|BLE %1 M|
|00002db0| 4f 44 49 46 59 20 22 25 | 32 22 20 25 33 00 4e 55 |ODIFY "%|2" %3.NU|
|00002dc0| 4c 4c 00 4e 4f 54 20 4e | 55 4c 4c 00 41 4c 54 45 |LL.NOT N|ULL.ALTE|
|00002dd0| 52 20 54 41 42 4c 45 20 | 25 31 20 41 44 44 20 55 |R TABLE |%1 ADD U|
|00002de0| 4e 49 51 55 45 28 20 22 | 25 32 22 20 29 00 41 4c |NIQUE( "|%2" ).AL|
|00002df0| 54 45 52 20 54 41 42 4c | 45 20 25 31 20 44 45 4c |TER TABL|E %1 DEL|
|00002e00| 45 54 45 20 55 4e 49 51 | 55 45 28 20 22 25 32 22 |ETE UNIQ|UE( "%2"|
|00002e10| 20 29 00 41 4c 54 45 52 | 20 54 41 42 4c 45 20 25 | ).ALTER| TABLE %|
|00002e20| 31 20 4d 4f 44 49 46 59 | 20 22 25 32 22 20 44 45 |1 MODIFY| "%2" DE|
|00002e30| 46 41 55 4c 54 20 25 33 | 00 4e 55 4c 4c 00 41 4c |FAULT %3|.NULL.AL|
|00002e40| 54 45 52 20 54 41 42 4c | 45 20 25 31 20 4d 4f 44 |TER TABL|E %1 MOD|
|00002e50| 49 46 59 20 22 25 32 22 | 20 25 33 00 43 48 45 43 |IFY "%2"| %3.CHEC|
|00002e60| 4b 20 4e 55 4c 4c 00 41 | 4c 54 45 52 20 54 41 42 |K NULL.A|LTER TAB|
|00002e70| 4c 45 20 25 31 20 25 32 | 00 20 44 45 53 43 00 20 |LE %1 %2|. DESC. |
|00002e80| 4f 52 44 45 52 20 42 59 | 20 25 33 00 20 41 4e 44 |ORDER BY| %3. AND|
|00002e90| 20 63 6f 6c 75 6d 6e 5f | 6e 61 6d 65 20 3d 20 27 | column_|name = '|
|00002ea0| 25 33 27 00 41 4c 54 45 | 52 20 54 41 42 4c 45 20 |%3'.ALTE|R TABLE |
|00002eb0| 22 25 31 22 2e 22 25 32 | 22 20 41 44 44 20 25 33 |"%1"."%2|" ADD %3|
|00002ec0| 20 00 53 45 4c 45 43 54 | 20 28 53 45 4c 45 43 54 | .SELECT| (SELECT|
|00002ed0| 20 64 6f 6d 61 69 6e 5f | 6e 61 6d 65 20 46 52 4f | domain_|name FRO|
|00002ee0| 4d 20 53 59 53 2e 53 59 | 53 44 4f 4d 41 49 4e 20 |M SYS.SY|SDOMAIN |
|00002ef0| 58 20 57 48 45 52 45 20 | 58 2e 64 6f 6d 61 69 6e |X WHERE |X.domain|
|00002f00| 5f 69 64 20 3d 20 53 43 | 2e 64 6f 6d 61 69 6e 5f |_id = SC|.domain_|
|00002f10| 69 64 29 2c 20 28 53 45 | 4c 45 43 54 20 74 79 70 |id), (SE|LECT typ|
|00002f20| 65 5f 6e 61 6d 65 20 46 | 52 4f 4d 20 53 59 53 2e |e_name F|ROM SYS.|
|00002f30| 53 59 53 55 53 45 52 54 | 59 50 45 20 57 48 45 52 |SYSUSERT|YPE WHER|
|00002f40| 45 20 74 79 70 65 5f 69 | 64 20 3d 20 75 73 65 72 |E type_i|d = user|
|00002f50| 5f 74 79 70 65 29 2c 20 | 77 69 64 74 68 2c 20 73 |_type), |width, s|
|00002f60| 63 61 6c 65 2c 20 72 65 | 6d 61 72 6b 73 2c 20 22 |cale, re|marks, "|
|00002f70| 64 65 66 61 75 6c 74 22 | 2c 20 6e 75 6c 6c 73 2c |default"|, nulls,|
|00002f80| 20 28 53 45 4c 45 43 54 | 20 63 6f 75 6e 74 28 2a | (SELECT| count(*|
|00002f90| 29 20 46 52 4f 4d 20 53 | 59 53 2e 53 59 53 49 4e |) FROM S|YS.SYSIN|
|00002fa0| 44 45 58 20 69 78 20 57 | 48 45 52 45 20 74 61 62 |DEX ix W|HERE tab|
|00002fb0| 6c 65 5f 69 64 20 3d 20 | 53 43 2e 74 61 62 6c 65 |le_id = |SC.table|
|00002fc0| 5f 69 64 20 61 6e 64 20 | 22 75 6e 69 71 75 65 22 |_id and |"unique"|
|00002fd0| 20 3d 20 27 55 27 20 41 | 4e 44 20 31 20 3d 20 28 | = 'U' A|ND 1 = (|
|00002fe0| 53 45 4c 45 43 54 20 63 | 6f 75 6e 74 28 2a 29 20 |SELECT c|ount(*) |
|00002ff0| 46 52 4f 4d 20 53 59 53 | 2e 53 59 53 49 58 43 4f |FROM SYS|.SYSIXCO|
|00003000| 4c 20 59 20 4a 4f 49 4e | 20 53 59 53 2e 53 59 53 |L Y JOIN| SYS.SYS|
|00003010| 43 4f 4c 55 4d 4e 20 41 | 20 57 48 45 52 45 20 59 |COLUMN A| WHERE Y|
|00003020| 2e 74 61 62 6c 65 5f 69 | 64 20 3d 20 69 78 2e 74 |.table_i|d = ix.t|
|00003030| 61 62 6c 65 5f 69 64 20 | 41 4e 44 20 69 6e 64 65 |able_id |AND inde|
|00003040| 78 5f 69 64 20 3d 20 69 | 78 2e 69 6e 64 65 78 5f |x_id = i|x.index_|
|00003050| 69 64 20 41 4e 44 20 41 | 2e 63 6f 6c 75 6d 6e 5f |id AND A|.column_|
|00003060| 6e 61 6d 65 20 3d 20 63 | 6f 6c 75 6d 6e 5f 6e 61 |name = c|olumn_na|
|00003070| 6d 65 20 41 4e 44 20 59 | 2e 63 6f 6c 75 6d 6e 5f |me AND Y|.column_|
|00003080| 69 64 20 3d 20 53 43 2e | 63 6f 6c 75 6d 6e 5f 69 |id = SC.|column_i|
|00003090| 64 29 20 41 4e 44 20 30 | 20 3d 20 28 53 45 4c 45 |d) AND 0| = (SELE|
|000030a0| 43 54 20 63 6f 75 6e 74 | 28 2a 29 20 46 52 4f 4d |CT count|(*) FROM|
|000030b0| 20 53 59 53 2e 53 59 53 | 49 58 43 4f 4c 20 5a 20 | SYS.SYS|IXCOL Z |
|000030c0| 4a 4f 49 4e 20 53 59 53 | 2e 53 59 53 43 4f 4c 55 |JOIN SYS|.SYSCOLU|
|000030d0| 4d 4e 20 42 20 57 48 45 | 52 45 20 5a 2e 74 61 62 |MN B WHE|RE Z.tab|
|000030e0| 6c 65 5f 69 64 20 3d 20 | 69 78 2e 74 61 62 6c 65 |le_id = |ix.table|
|000030f0| 5f 69 64 20 41 4e 44 20 | 69 6e 64 65 78 5f 69 64 |_id AND |index_id|
|00003100| 20 3d 20 69 78 2e 69 6e | 64 65 78 5f 69 64 20 41 | = ix.in|dex_id A|
|00003110| 4e 44 20 42 2e 63 6f 6c | 75 6d 6e 5f 6e 61 6d 65 |ND B.col|umn_name|
|00003120| 20 3d 20 63 6f 6c 75 6d | 6e 5f 6e 61 6d 65 20 41 | = colum|n_name A|
|00003130| 4e 44 20 5a 2e 63 6f 6c | 75 6d 6e 5f 69 64 20 3c |ND Z.col|umn_id <|
|00003140| 3e 20 53 43 2e 63 6f 6c | 75 6d 6e 5f 69 64 29 29 |> SC.col|umn_id))|
|00003150| 2c 20 70 6b 65 79 2c 20 | 63 6f 6c 75 6d 6e 5f 69 |, pkey, |column_i|
|00003160| 64 2c 20 22 63 68 65 63 | 6b 22 20 46 52 4f 4d 20 |d, "chec|k" FROM |
|00003170| 53 59 53 2e 53 59 53 43 | 4f 4c 55 4d 4e 20 53 43 |SYS.SYSC|OLUMN SC|
|00003180| 20 57 48 45 52 45 20 74 | 61 62 6c 65 5f 69 64 20 | WHERE t|able_id |
|00003190| 3d 20 25 31 20 41 4e 44 | 20 63 6f 6c 75 6d 6e 5f |= %1 AND| column_|
|000031a0| 6e 61 6d 65 20 3d 20 27 | 25 32 27 00 53 45 4c 45 |name = '|%2'.SELE|
|000031b0| 43 54 20 28 53 45 4c 45 | 43 54 20 64 6f 6d 61 69 |CT (SELE|CT domai|
|000031c0| 6e 5f 6e 61 6d 65 20 46 | 52 4f 4d 20 53 59 53 2e |n_name F|ROM SYS.|
|000031d0| 53 59 53 44 4f 4d 41 49 | 4e 20 58 20 57 48 45 52 |SYSDOMAI|N X WHER|
|000031e0| 45 20 58 2e 64 6f 6d 61 | 69 6e 5f 69 64 20 3d 20 |E X.doma|in_id = |
|000031f0| 53 43 2e 64 6f 6d 61 69 | 6e 5f 69 64 29 2c 20 4e |SC.domai|n_id), N|
|00003200| 55 4c 4c 2c 20 77 69 64 | 74 68 2c 20 73 63 61 6c |ULL, wid|th, scal|
|00003210| 65 2c 20 72 65 6d 61 72 | 6b 73 2c 20 22 64 65 66 |e, remar|ks, "def|
|00003220| 61 75 6c 74 22 2c 20 6e | 75 6c 6c 73 2c 20 28 53 |ault", n|ulls, (S|
|00003230| 45 4c 45 43 54 20 63 6f | 75 6e 74 28 2a 29 20 46 |ELECT co|unt(*) F|
|00003240| 52 4f 4d 20 53 59 53 2e | 53 59 53 49 4e 44 45 58 |ROM SYS.|SYSINDEX|
|00003250| 20 69 78 20 57 48 45 52 | 45 20 74 61 62 6c 65 5f | ix WHER|E table_|
|00003260| 69 64 20 3d 20 53 43 2e | 74 61 62 6c 65 5f 69 64 |id = SC.|table_id|
|00003270| 20 61 6e 64 20 22 75 6e | 69 71 75 65 22 20 3d 20 | and "un|ique" = |
|00003280| 27 55 27 20 41 4e 44 20 | 31 20 3d 20 28 53 45 4c |'U' AND |1 = (SEL|
|00003290| 45 43 54 20 63 6f 75 6e | 74 28 2a 29 20 46 52 4f |ECT coun|t(*) FRO|
|000032a0| 4d 20 53 59 53 2e 53 59 | 53 49 58 43 4f 4c 20 59 |M SYS.SY|SIXCOL Y|
|000032b0| 20 4a 4f 49 4e 20 53 59 | 53 2e 53 59 53 43 4f 4c | JOIN SY|S.SYSCOL|
|000032c0| 55 4d 4e 20 41 20 57 48 | 45 52 45 20 59 2e 74 61 |UMN A WH|ERE Y.ta|
|000032d0| 62 6c 65 5f 69 64 20 3d | 20 69 78 2e 74 61 62 6c |ble_id =| ix.tabl|
|000032e0| 65 5f 69 64 20 41 4e 44 | 20 69 6e 64 65 78 5f 69 |e_id AND| index_i|
|000032f0| 64 20 3d 20 69 78 2e 69 | 6e 64 65 78 5f 69 64 20 |d = ix.i|ndex_id |
|00003300| 41 4e 44 20 41 2e 63 6f | 6c 75 6d 6e 5f 6e 61 6d |AND A.co|lumn_nam|
|00003310| 65 20 3d 20 63 6f 6c 75 | 6d 6e 5f 6e 61 6d 65 20 |e = colu|mn_name |
|00003320| 41 4e 44 20 59 2e 63 6f | 6c 75 6d 6e 5f 69 64 20 |AND Y.co|lumn_id |
|00003330| 3d 20 53 43 2e 63 6f 6c | 75 6d 6e 5f 69 64 29 20 |= SC.col|umn_id) |
|00003340| 41 4e 44 20 30 20 3d 20 | 28 53 45 4c 45 43 54 20 |AND 0 = |(SELECT |
|00003350| 63 6f 75 6e 74 28 2a 29 | 20 46 52 4f 4d 20 53 59 |count(*)| FROM SY|
|00003360| 53 2e 53 59 53 49 58 43 | 4f 4c 20 5a 20 4a 4f 49 |S.SYSIXC|OL Z JOI|
|00003370| 4e 20 53 59 53 2e 53 59 | 53 43 4f 4c 55 4d 4e 20 |N SYS.SY|SCOLUMN |
|00003380| 42 20 57 48 45 52 45 20 | 5a 2e 74 61 62 6c 65 5f |B WHERE |Z.table_|
|00003390| 69 64 20 3d 20 69 78 2e | 74 61 62 6c 65 5f 69 64 |id = ix.|table_id|
|000033a0| 20 41 4e 44 20 69 6e 64 | 65 78 5f 69 64 20 3d 20 | AND ind|ex_id = |
|000033b0| 69 78 2e 69 6e 64 65 78 | 5f 69 64 20 41 4e 44 20 |ix.index|_id AND |
|000033c0| 42 2e 63 6f 6c 75 6d 6e | 5f 6e 61 6d 65 20 3d 20 |B.column|_name = |
|000033d0| 63 6f 6c 75 6d 6e 5f 6e | 61 6d 65 20 41 4e 44 20 |column_n|ame AND |
|000033e0| 5a 2e 63 6f 6c 75 6d 6e | 5f 69 64 20 3c 3e 20 53 |Z.column|_id <> S|
|000033f0| 43 2e 63 6f 6c 75 6d 6e | 5f 69 64 29 29 2c 20 70 |C.column|_id)), p|
|00003400| 6b 65 79 2c 20 63 6f 6c | 75 6d 6e 5f 69 64 2c 20 |key, col|umn_id, |
|00003410| 4e 55 4c 4c 20 46 52 4f | 4d 20 53 59 53 2e 53 59 |NULL FRO|M SYS.SY|
|00003420| 53 43 4f 4c 55 4d 4e 20 | 53 43 20 57 48 45 52 45 |SCOLUMN |SC WHERE|
|00003430| 20 74 61 62 6c 65 5f 69 | 64 20 3d 20 25 31 20 41 | table_i|d = %1 A|
|00003440| 4e 44 20 63 6f 6c 75 6d | 6e 5f 6e 61 6d 65 20 3d |ND colum|n_name =|
|00003450| 20 27 25 32 27 00 53 45 | 4c 45 43 54 20 63 6f 6c | '%2'.SE|LECT col|
|00003460| 75 6d 6e 5f 6e 61 6d 65 | 2c 20 20 28 53 45 4c 45 |umn_name|,  (SELE|
|00003470| 43 54 20 64 6f 6d 61 69 | 6e 5f 6e 61 6d 65 20 46 |CT domai|n_name F|
|00003480| 52 4f 4d 20 53 59 53 2e | 53 59 53 44 4f 4d 41 49 |ROM SYS.|SYSDOMAI|
|00003490| 4e 20 58 20 57 48 45 52 | 45 20 58 2e 64 6f 6d 61 |N X WHER|E X.doma|
|000034a0| 69 6e 5f 69 64 20 3d 20 | 53 59 53 2e 53 59 53 43 |in_id = |SYS.SYSC|
|000034b0| 4f 4c 55 4d 4e 2e 64 6f | 6d 61 69 6e 5f 69 64 29 |OLUMN.do|main_id)|
|000034c0| 2c 20 72 65 6d 61 72 6b | 73 2c 20 77 69 64 74 68 |, remark|s, width|
|000034d0| 2c 20 73 63 61 6c 65 2c | 20 70 6b 65 79 2c 20 63 |, scale,| pkey, c|
|000034e0| 6f 6c 75 6d 6e 5f 69 64 | 20 46 52 4f 4d 20 53 59 |olumn_id| FROM SY|
|000034f0| 53 2e 53 59 53 43 4f 4c | 55 4d 4e 20 57 48 45 52 |S.SYSCOL|UMN WHER|
|00003500| 45 20 74 61 62 6c 65 5f | 69 64 20 3d 20 28 53 45 |E table_|id = (SE|
|00003510| 4c 45 43 54 20 74 61 62 | 6c 65 5f 69 64 20 46 52 |LECT tab|le_id FR|
|00003520| 4f 4d 20 53 59 53 2e 53 | 59 53 54 41 42 4c 45 20 |OM SYS.S|YSTABLE |
|00003530| 57 48 45 52 45 20 74 61 | 62 6c 65 5f 6e 61 6d 65 |WHERE ta|ble_name|
|00003540| 20 3d 20 27 25 31 27 20 | 41 4e 44 20 63 72 65 61 | = '%1' |AND crea|
|00003550| 74 6f 72 20 3d 20 28 53 | 45 4c 45 43 54 20 75 73 |tor = (S|ELECT us|
|00003560| 65 72 5f 69 64 20 46 52 | 4f 4d 20 53 59 53 2e 53 |er_id FR|OM SYS.S|
|00003570| 59 53 55 53 45 52 50 45 | 52 4d 53 20 57 48 45 52 |YSUSERPE|RMS WHER|
|00003580| 45 20 75 73 65 72 5f 6e | 61 6d 65 20 3d 20 27 25 |E user_n|ame = '%|
|00003590| 32 27 29 20 29 20 00 41 | 4c 54 45 52 20 54 41 42 |2') ) .A|LTER TAB|
|000035a0| 4c 45 20 22 25 31 22 2e | 22 25 32 22 20 44 45 4c |LE "%1".|"%2" DEL|
|000035b0| 45 54 45 20 22 25 33 22 | 00 53 45 4c 45 43 54 20 |ETE "%3"|.SELECT |
|000035c0| 63 6f 75 6e 74 28 2a 29 | 20 46 52 4f 4d 20 53 59 |count(*)| FROM SY|
|000035d0| 53 2e 53 59 53 43 4f 4c | 55 4d 4e 20 57 48 45 52 |S.SYSCOL|UMN WHER|
|000035e0| 45 20 74 61 62 6c 65 5f | 69 64 20 3d 20 28 53 45 |E table_|id = (SE|
|000035f0| 4c 45 43 54 20 74 61 62 | 6c 65 5f 69 64 20 46 52 |LECT tab|le_id FR|
|00003600| 4f 4d 20 53 59 53 2e 53 | 59 53 54 41 42 4c 45 20 |OM SYS.S|YSTABLE |
|00003610| 57 48 45 52 45 20 74 61 | 62 6c 65 5f 6e 61 6d 65 |WHERE ta|ble_name|
|00003620| 20 3d 20 27 25 31 27 20 | 41 4e 44 20 63 72 65 61 | = '%1' |AND crea|
|00003630| 74 6f 72 20 3d 20 28 53 | 45 4c 45 43 54 20 75 73 |tor = (S|ELECT us|
|00003640| 65 72 5f 69 64 20 46 52 | 4f 4d 20 53 59 53 2e 53 |er_id FR|OM SYS.S|
|00003650| 59 53 55 53 45 52 50 45 | 52 4d 53 20 57 48 45 52 |YSUSERPE|RMS WHER|
|00003660| 45 20 75 73 65 72 5f 6e | 61 6d 65 20 3d 20 27 25 |E user_n|ame = '%|
|00003670| 32 27 29 20 29 20 00 00 | 25 73 25 73 00 25 73 25 |2') ) ..|%s%s.%s%|
|00003680| 73 00 66 6f 6f 00 77 65 | 64 69 74 00 65 6e 00 43 |s.foo.we|dit.en.C|
|00003690| 6f 75 6c 64 20 6e 6f 74 | 20 6c 6f 61 64 20 6c 61 |ould not| load la|
|000036a0| 6e 67 75 61 67 65 20 44 | 4c 4c 20 27 25 73 27 2e |nguage D|LL '%s'.|
|000036b0| 00 53 79 62 61 73 65 20 | 43 65 6e 74 72 61 6c 00 |.Sybase |Central.|
|000036c0| 53 6f 66 74 77 61 72 65 | 5c 53 79 62 61 73 65 00 |Software|\Sybase.|
|000036d0| 00 53 79 73 4c 69 73 74 | 56 69 65 77 33 32 00 73 |.SysList|View32.s|
|000036e0| 63 73 61 25 31 2e 68 6c | 70 00 73 63 73 61 2e 68 |csa%1.hl|p.scsa.h|
|000036f0| 6c 70 00 73 63 73 73 25 | 31 2e 68 6c 70 00 73 63 |lp.scss%|1.hlp.sc|
|00003700| 73 73 2e 68 6c 70 00 73 | 63 25 31 2e 68 6c 70 00 |ss.hlp.s|c%1.hlp.|
|00003710| 73 63 2e 68 6c 70 00 3a | 00 73 63 6a 69 74 30 31 |sc.hlp.:|.scjit01|
|00003720| 2e 64 6c 6c 00 73 63 77 | 69 74 30 31 2e 64 6c 6c |.dll.scw|it01.dll|
|00003730| 00 5f 77 65 64 69 74 5f | 64 6c 6c 5f 69 6e 69 74 |._wedit_|dll_init|
|00003740| 40 34 00 5f 77 65 64 69 | 74 5f 64 6c 6c 5f 64 6f |@4._wedi|t_dll_do|
|00003750| 6e 65 40 34 00 4c 61 6e | 67 75 61 67 65 00 44 62 |ne@4.Lan|guage.Db|
|00003760| 78 4d 6f 64 65 6c 65 73 | 73 50 72 6f 70 00 00 00 |xModeles|sProp...|
|00003770| 00 00 00 00 6e 75 6c 6c | 00 61 75 74 6f 69 6e 63 |....null|.autoinc|
|00003780| 72 65 6d 65 6e 74 00 63 | 75 72 72 65 6e 74 20 74 |rement.c|urrent t|
|00003790| 69 6d 65 00 63 75 72 72 | 65 6e 74 20 74 69 6d 65 |ime.curr|ent time|
|000037a0| 73 74 61 6d 70 00 74 69 | 6d 65 73 74 61 6d 70 00 |stamp.ti|mestamp.|
|000037b0| 63 75 72 72 65 6e 74 20 | 64 61 74 65 00 53 4d 41 |current |date.SMA|
|000037c0| 4c 4c 49 4e 54 00 49 4e | 54 45 47 45 52 00 46 4c |LLINT.IN|TEGER.FL|
|000037d0| 4f 41 54 00 44 4f 55 42 | 4c 45 00 4e 55 4d 45 52 |OAT.DOUB|LE.NUMER|
|000037e0| 49 43 00 44 41 54 45 00 | 54 49 4d 45 00 54 49 4d |IC.DATE.|TIME.TIM|
|000037f0| 45 53 54 41 4d 50 00 43 | 48 41 52 00 56 41 52 43 |ESTAMP.C|HAR.VARC|
|00003800| 48 41 52 00 4c 4f 4e 47 | 20 56 41 52 43 48 41 52 |HAR.LONG| VARCHAR|
|00003810| 00 4c 4f 4e 47 20 42 49 | 4e 41 52 59 00 54 49 4e |.LONG BI|NARY.TIN|
|00003820| 59 49 4e 54 00 42 49 4e | 41 52 59 00 27 25 31 27 |YINT.BIN|ARY.'%1'|
|00003830| 00 25 31 20 28 20 25 32 | 2c 20 25 33 20 29 00 25 |.%1 ( %2|, %3 ).%|
|00003840| 31 20 28 20 25 32 20 29 | 00 63 75 72 72 65 6e 74 |1 ( %2 )|.current|
|00003850| 20 64 61 74 65 00 63 75 | 72 72 65 6e 74 20 74 69 | date.cu|rrent ti|
|00003860| 6d 65 00 63 75 72 72 65 | 6e 74 20 74 69 6d 65 73 |me.curre|nt times|
|00003870| 74 61 6d 70 00 74 69 6d | 65 73 74 61 6d 70 00 63 |tamp.tim|estamp.c|
|00003880| 75 72 72 65 6e 74 20 75 | 73 65 72 00 63 75 72 72 |urrent u|ser.curr|
|00003890| 65 6e 74 20 64 61 74 61 | 62 61 73 65 00 63 75 72 |ent data|base.cur|
|000038a0| 72 65 6e 74 20 70 75 62 | 6c 69 73 68 65 72 00 63 |rent pub|lisher.c|
|000038b0| 75 72 72 65 6e 74 20 64 | 61 74 65 00 63 75 72 72 |urrent d|ate.curr|
|000038c0| 65 6e 74 20 74 69 6d 65 | 00 63 75 72 72 65 6e 74 |ent time|.current|
|000038d0| 20 74 69 6d 65 73 74 61 | 6d 70 00 74 69 6d 65 73 | timesta|mp.times|
|000038e0| 74 61 6d 70 00 61 75 74 | 6f 69 6e 63 72 65 6d 65 |tamp.aut|oincreme|
|000038f0| 6e 74 00 63 75 72 72 65 | 6e 74 20 75 73 65 72 00 |nt.curre|nt user.|
|00003900| 63 75 72 72 65 6e 74 20 | 64 61 74 61 62 61 73 65 |current |database|
|00003910| 00 63 75 72 72 65 6e 74 | 20 70 75 62 6c 69 73 68 |.current| publish|
|00003920| 65 72 00 63 75 72 72 65 | 6e 74 20 64 61 74 65 00 |er.curre|nt date.|
|00003930| 63 75 72 72 65 6e 74 20 | 74 69 6d 65 00 63 75 72 |current |time.cur|
|00003940| 72 65 6e 74 20 74 69 6d | 65 73 74 61 6d 70 00 74 |rent tim|estamp.t|
|00003950| 69 6d 65 73 74 61 6d 70 | 00 61 75 74 6f 69 6e 63 |imestamp|.autoinc|
|00003960| 72 65 6d 65 6e 74 00 49 | 4e 53 45 52 54 20 49 4e |rement.I|NSERT IN|
|00003970| 54 4f 20 64 62 78 5f 64 | 6f 6d 61 69 6e 73 5f 74 |TO dbx_d|omains_t|
|00003980| 65 6d 70 20 53 45 4c 45 | 43 54 20 44 49 53 54 49 |emp SELE|CT DISTI|
|00003990| 4e 43 54 20 64 6f 6d 61 | 69 6e 5f 6e 61 6d 65 2c |NCT doma|in_name,|
|000039a0| 20 4e 55 4c 4c 2c 20 64 | 6f 6d 61 69 6e 5f 6e 61 | NULL, d|omain_na|
|000039b0| 6d 65 20 46 52 4f 4d 20 | 53 59 53 2e 53 59 53 44 |me FROM |SYS.SYSD|
|000039c0| 4f 4d 41 49 4e 20 00 53 | 45 4c 45 43 54 20 64 6f |OMAIN .S|ELECT do|
|000039d0| 6d 61 69 6e 2c 20 75 73 | 65 72 5f 6e 61 6d 65 20 |main, us|er_name |
|000039e0| 46 52 4f 4d 20 64 62 78 | 5f 64 6f 6d 61 69 6e 73 |FROM dbx|_domains|
|000039f0| 5f 74 65 6d 70 20 4f 52 | 44 45 52 20 42 59 20 6e |_temp OR|DER BY n|
|00003a00| 61 6d 65 00 53 45 4c 45 | 43 54 20 63 6f 75 6e 74 |ame.SELE|CT count|
|00003a10| 28 44 49 53 54 49 4e 43 | 54 20 64 6f 6d 61 69 6e |(DISTINC|T domain|
|00003a20| 5f 6e 61 6d 65 29 20 46 | 52 4f 4d 20 53 59 53 2e |_name) F|ROM SYS.|
|00003a30| 53 59 53 44 4f 4d 41 49 | 4e 00 53 45 4c 45 43 54 |SYSDOMAI|N.SELECT|
|00003a40| 20 73 65 74 74 69 6e 67 | 20 46 52 4f 4d 20 53 59 | setting| FROM SY|
|00003a50| 53 2e 53 59 53 4f 50 54 | 49 4f 4e 20 57 48 45 52 |S.SYSOPT|ION WHER|
|00003a60| 45 20 22 6f 70 74 69 6f | 6e 22 20 3d 20 27 44 61 |E "optio|n" = 'Da|
|00003a70| 74 65 5f 66 6f 72 6d 61 | 74 27 20 41 4e 44 20 75 |te_forma|t' AND u|
|00003a80| 73 65 72 5f 69 64 20 3d | 20 28 53 45 4c 45 43 54 |ser_id =| (SELECT|
|00003a90| 20 75 73 65 72 5f 69 64 | 20 46 52 4f 4d 20 53 59 | user_id| FROM SY|
|00003aa0| 53 2e 53 59 53 55 53 45 | 52 50 45 52 4d 53 20 57 |S.SYSUSE|RPERMS W|
|00003ab0| 48 45 52 45 20 75 73 65 | 72 5f 6e 61 6d 65 20 3d |HERE use|r_name =|
|00003ac0| 20 27 50 55 42 4c 49 43 | 27 29 00 53 45 4c 45 43 | 'PUBLIC|').SELEC|
|00003ad0| 54 20 73 65 74 74 69 6e | 67 20 46 52 4f 4d 20 53 |T settin|g FROM S|
|00003ae0| 59 53 2e 53 59 53 4f 50 | 54 49 4f 4e 20 57 48 45 |YS.SYSOP|TION WHE|
|00003af0| 52 45 20 22 6f 70 74 69 | 6f 6e 22 20 3d 20 27 54 |RE "opti|on" = 'T|
|00003b00| 69 6d 65 5f 66 6f 72 6d | 61 74 27 20 41 4e 44 20 |ime_form|at' AND |
|00003b10| 75 73 65 72 5f 69 64 20 | 3d 20 28 53 45 4c 45 43 |user_id |= (SELEC|
|00003b20| 54 20 75 73 65 72 5f 69 | 64 20 46 52 4f 4d 20 53 |T user_i|d FROM S|
|00003b30| 59 53 2e 53 59 53 55 53 | 45 52 50 45 52 4d 53 20 |YS.SYSUS|ERPERMS |
|00003b40| 57 48 45 52 45 20 75 73 | 65 72 5f 6e 61 6d 65 20 |WHERE us|er_name |
|00003b50| 3d 20 27 50 55 42 4c 49 | 43 27 29 00 53 45 4c 45 |= 'PUBLI|C').SELE|
|00003b60| 43 54 20 73 65 74 74 69 | 6e 67 20 46 52 4f 4d 20 |CT setti|ng FROM |
|00003b70| 53 59 53 2e 53 59 53 4f | 50 54 49 4f 4e 20 57 48 |SYS.SYSO|PTION WH|
|00003b80| 45 52 45 20 22 6f 70 74 | 69 6f 6e 22 20 3d 20 27 |ERE "opt|ion" = '|
|00003b90| 54 69 6d 65 73 74 61 6d | 70 5f 66 6f 72 6d 61 74 |Timestam|p_format|
|00003ba0| 27 20 41 4e 44 20 75 73 | 65 72 5f 69 64 20 3d 20 |' AND us|er_id = |
|00003bb0| 28 53 45 4c 45 43 54 20 | 75 73 65 72 5f 69 64 20 |(SELECT |user_id |
|00003bc0| 46 52 4f 4d 20 53 59 53 | 2e 53 59 53 55 53 45 52 |FROM SYS|.SYSUSER|
|00003bd0| 50 45 52 4d 53 20 57 48 | 45 52 45 20 75 73 65 72 |PERMS WH|ERE user|
|00003be0| 5f 6e 61 6d 65 20 3d 20 | 27 50 55 42 4c 49 43 27 |_name = |'PUBLIC'|
|00003bf0| 29 00 00 00 49 4e 54 45 | 47 45 52 00 4f 6e 00 53 |)...INTE|GER.On.S|
|00003c00| 45 4c 45 43 54 20 28 53 | 45 4c 45 43 54 20 61 2e |ELECT (S|ELECT a.|
|00003c10| 64 6f 6d 61 69 6e 5f 6e | 61 6d 65 20 46 52 4f 4d |domain_n|ame FROM|
|00003c20| 20 53 59 53 2e 53 59 53 | 44 4f 4d 41 49 4e 20 61 | SYS.SYS|DOMAIN a|
|00003c30| 20 57 48 45 52 45 20 61 | 2e 64 6f 6d 61 69 6e 5f | WHERE a|.domain_|
|00003c40| 69 64 20 3d 20 62 2e 64 | 6f 6d 61 69 6e 5f 69 64 |id = b.d|omain_id|
|00003c50| 29 2c 20 77 69 64 74 68 | 2c 20 73 63 61 6c 65 2c |), width|, scale,|
|00003c60| 20 74 79 70 65 5f 69 64 | 2c 20 6e 75 6c 6c 73 2c | type_id|, nulls,|
|00003c70| 20 22 64 65 66 61 75 6c | 74 22 2c 20 22 63 68 65 | "defaul|t", "che|
|00003c80| 63 6b 22 2c 20 28 53 45 | 4c 45 43 54 20 75 73 65 |ck", (SE|LECT use|
|00003c90| 72 5f 6e 61 6d 65 20 46 | 52 4f 4d 20 53 59 53 2e |r_name F|ROM SYS.|
|00003ca0| 53 59 53 55 53 45 52 50 | 45 52 4d 53 20 57 48 45 |SYSUSERP|ERMS WHE|
|00003cb0| 52 45 20 75 73 65 72 5f | 69 64 20 3d 20 63 72 65 |RE user_|id = cre|
|00003cc0| 61 74 6f 72 29 20 46 52 | 4f 4d 20 53 59 53 2e 53 |ator) FR|OM SYS.S|
|00003cd0| 59 53 55 53 45 52 54 59 | 50 45 20 62 20 57 48 45 |YSUSERTY|PE b WHE|
|00003ce0| 52 45 20 74 79 70 65 5f | 6e 61 6d 65 20 3d 20 27 |RE type_|name = '|
|00003cf0| 25 31 27 00 4f 6e 00 00 | 00 53 45 4c 45 43 54 20 |%1'.On..|.SELECT |
|00003d00| 74 79 70 65 5f 6e 61 6d | 65 2c 20 28 53 45 4c 45 |type_nam|e, (SELE|
|00003d10| 43 54 20 64 6f 6d 61 69 | 6e 5f 6e 61 6d 65 20 46 |CT domai|n_name F|
|00003d20| 52 4f 4d 20 53 59 53 2e | 53 59 53 44 4f 4d 41 49 |ROM SYS.|SYSDOMAI|
|00003d30| 4e 20 42 20 57 48 45 52 | 45 20 41 2e 64 6f 6d 61 |N B WHER|E A.doma|
|00003d40| 69 6e 5f 69 64 20 3d 20 | 42 2e 64 6f 6d 61 69 6e |in_id = |B.domain|
|00003d50| 5f 69 64 29 2c 20 22 63 | 68 65 63 6b 22 2c 20 77 |_id), "c|heck", w|
|00003d60| 69 64 74 68 2c 20 73 63 | 61 6c 65 20 46 52 4f 4d |idth, sc|ale FROM|
|00003d70| 20 53 59 53 2e 53 59 53 | 55 53 45 52 54 59 50 45 | SYS.SYS|USERTYPE|
|00003d80| 20 41 20 4f 52 44 45 52 | 20 42 59 20 25 31 20 00 | A ORDER| BY %1 .|
|00003d90| 20 44 45 53 43 00 31 00 | 43 52 45 41 54 45 20 44 | DESC.1.|CREATE D|
|00003da0| 4f 4d 41 49 4e 20 22 25 | 31 22 20 25 32 20 00 4e |OMAIN "%|1" %2 .N|
|00003db0| 55 4c 4c 20 00 4e 4f 54 | 20 4e 55 4c 4c 20 00 44 |ULL .NOT| NULL .D|
|00003dc0| 45 46 41 55 4c 54 20 25 | 31 20 00 53 45 4c 45 43 |EFAULT %|1 .SELEC|
|00003dd0| 54 20 74 79 70 65 5f 6e | 61 6d 65 20 46 52 4f 4d |T type_n|ame FROM|
|00003de0| 20 53 59 53 2e 53 59 53 | 55 53 45 52 54 59 50 45 | SYS.SYS|USERTYPE|
|00003df0| 20 57 48 45 52 45 20 74 | 79 70 65 5f 6e 61 6d 65 | WHERE t|ype_name|
|00003e00| 20 3d 20 27 25 31 27 00 | 44 52 4f 50 20 44 4f 4d | = '%1'.|DROP DOM|
|00003e10| 41 49 4e 20 22 25 31 22 | 00 53 45 4c 45 43 54 20 |AIN "%1"|.SELECT |
|00003e20| 63 6f 75 6e 74 28 2a 29 | 20 46 52 4f 4d 20 53 59 |count(*)| FROM SY|
|00003e30| 53 2e 53 59 53 55 53 45 | 52 54 59 50 45 00 53 45 |S.SYSUSE|RTYPE.SE|
|00003e40| 4c 45 43 54 20 44 49 53 | 54 49 4e 43 54 20 64 6f |LECT DIS|TINCT do|
|00003e50| 6d 61 69 6e 5f 6e 61 6d | 65 2c 20 4e 55 4c 4c 20 |main_nam|e, NULL |
|00003e60| 46 52 4f 4d 20 53 59 53 | 2e 53 59 53 44 4f 4d 41 |FROM SYS|.SYSDOMA|
|00003e70| 49 4e 20 00 53 45 4c 45 | 43 54 20 64 6f 6d 61 69 |IN .SELE|CT domai|
|00003e80| 6e 2c 20 75 73 65 72 5f | 6e 61 6d 65 20 46 52 4f |n, user_|name FRO|
|00003e90| 4d 20 64 62 78 5f 64 6f | 6d 61 69 6e 73 5f 74 65 |M dbx_do|mains_te|
|00003ea0| 6d 70 20 4f 52 44 45 52 | 20 42 59 20 6e 61 6d 65 |mp ORDER| BY name|
|00003eb0| 00 49 4e 53 45 52 54 20 | 49 4e 54 4f 20 64 62 78 |.INSERT |INTO dbx|
|00003ec0| 5f 64 6f 6d 61 69 6e 73 | 5f 74 65 6d 70 20 53 45 |_domains|_temp SE|
|00003ed0| 4c 45 43 54 20 44 49 53 | 54 49 4e 43 54 20 64 6f |LECT DIS|TINCT do|
|00003ee0| 6d 61 69 6e 5f 6e 61 6d | 65 2c 20 4e 55 4c 4c 2c |main_nam|e, NULL,|
|00003ef0| 20 64 6f 6d 61 69 6e 5f | 6e 61 6d 65 20 46 52 4f | domain_|name FRO|
|00003f00| 4d 20 53 59 53 2e 53 59 | 53 44 4f 4d 41 49 4e 20 |M SYS.SY|SDOMAIN |
|00003f10| 55 4e 49 4f 4e 20 41 4c | 4c 20 53 45 4c 45 43 54 |UNION AL|L SELECT|
|00003f20| 20 28 53 45 4c 45 43 54 | 20 64 6f 6d 61 69 6e 5f | (SELECT| domain_|
|00003f30| 6e 61 6d 65 20 46 52 4f | 4d 20 53 59 53 2e 53 59 |name FRO|M SYS.SY|
|00003f40| 53 44 4f 4d 41 49 4e 20 | 57 48 45 52 45 20 64 6f |SDOMAIN |WHERE do|
|00003f50| 6d 61 69 6e 5f 69 64 20 | 3d 20 58 2e 64 6f 6d 61 |main_id |= X.doma|
|00003f60| 69 6e 5f 69 64 29 2c 20 | 74 79 70 65 5f 6e 61 6d |in_id), |type_nam|
|00003f70| 65 2c 20 74 79 70 65 5f | 6e 61 6d 65 20 46 52 4f |e, type_|name FRO|
|00003f80| 4d 20 53 59 53 2e 53 59 | 53 55 53 45 52 54 59 50 |M SYS.SY|SUSERTYP|
|00003f90| 45 20 58 20 00 53 45 4c | 45 43 54 20 63 6f 75 6e |E X .SEL|ECT coun|
|00003fa0| 74 28 44 49 53 54 49 4e | 43 54 20 64 6f 6d 61 69 |t(DISTIN|CT domai|
|00003fb0| 6e 5f 6e 61 6d 65 29 20 | 2b 20 31 20 46 52 4f 4d |n_name) |+ 1 FROM|
|00003fc0| 20 53 59 53 2e 53 59 53 | 44 4f 4d 41 49 4e 00 53 | SYS.SYS|DOMAIN.S|
|00003fd0| 45 4c 45 43 54 20 63 6f | 75 6e 74 28 2a 29 20 46 |ELECT co|unt(*) F|
|00003fe0| 52 4f 4d 20 53 59 53 2e | 53 59 53 55 53 45 52 54 |ROM SYS.|SYSUSERT|
|00003ff0| 59 50 45 00 44 45 43 4c | 41 52 45 20 4c 4f 43 41 |YPE.DECL|ARE LOCA|
|00004000| 4c 20 54 45 4d 50 4f 52 | 41 52 59 20 54 41 42 4c |L TEMPOR|ARY TABL|
|00004010| 45 20 64 62 78 5f 64 6f | 6d 61 69 6e 73 5f 74 65 |E dbx_do|mains_te|
|00004020| 6d 70 28 20 64 6f 6d 61 | 69 6e 20 63 68 61 72 28 |mp( doma|in char(|
|00004030| 35 30 29 2c 20 75 73 65 | 72 5f 6e 61 6d 65 20 63 |50), use|r_name c|
|00004040| 68 61 72 28 35 30 29 20 | 4e 55 4c 4c 2c 20 6e 61 |har(50) |NULL, na|
|00004050| 6d 65 20 63 68 61 72 28 | 35 30 29 20 29 20 4f 4e |me char(|50) ) ON|
|00004060| 20 43 4f 4d 4d 49 54 20 | 50 52 45 53 45 52 56 45 | COMMIT |PRESERVE|
|00004070| 20 52 4f 57 53 00 44 52 | 4f 50 20 54 41 42 4c 45 | ROWS.DR|OP TABLE|
|00004080| 20 64 62 78 5f 64 6f 6d | 61 69 6e 73 5f 74 65 6d | dbx_dom|ains_tem|
|00004090| 70 00 00 00 00 00 53 45 | 4c 45 43 54 20 74 61 62 |p.....SE|LECT tab|
|000040a0| 6c 65 5f 69 64 2c 20 72 | 65 6d 61 72 6b 73 2c 20 |le_id, r|emarks, |
|000040b0| 28 53 45 4c 45 43 54 20 | 64 62 73 70 61 63 65 5f |(SELECT |dbspace_|
|000040c0| 6e 61 6d 65 20 46 52 4f | 4d 20 53 59 53 2e 53 59 |name FRO|M SYS.SY|
|000040d0| 53 46 49 4c 45 20 57 48 | 45 52 45 20 53 59 53 2e |SFILE WH|ERE SYS.|
|000040e0| 53 59 53 46 49 4c 45 2e | 66 69 6c 65 5f 69 64 20 |SYSFILE.|file_id |
|000040f0| 3d 20 41 2e 66 69 6c 65 | 5f 69 64 29 2c 20 28 49 |= A.file|_id), (I|
|00004100| 46 20 74 61 62 6c 65 5f | 74 79 70 65 20 3d 20 27 |F table_|type = '|
|00004110| 42 41 53 45 27 20 54 48 | 45 4e 20 27 4e 27 20 45 |BASE' TH|EN 'N' E|
|00004120| 4c 53 45 20 27 59 27 20 | 45 4e 44 49 46 29 2c 20 |LSE 'Y' |ENDIF), |
|00004130| 6c 61 73 74 5f 70 61 67 | 65 2c 20 28 53 45 4c 45 |last_pag|e, (SELE|
|00004140| 43 54 20 75 73 65 72 5f | 6e 61 6d 65 20 46 52 4f |CT user_|name FRO|
|00004150| 4d 20 53 59 53 2e 53 59 | 53 55 53 45 52 50 45 52 |M SYS.SY|SUSERPER|
|00004160| 4d 53 20 57 48 45 52 45 | 20 75 73 65 72 5f 69 64 |MS WHERE| user_id|
|00004170| 20 3d 20 41 2e 63 72 65 | 61 74 6f 72 29 2c 20 76 | = A.cre|ator), v|
|00004180| 69 65 77 5f 64 65 66 20 | 46 52 4f 4d 20 53 59 53 |iew_def |FROM SYS|
|00004190| 2e 53 59 53 54 41 42 4c | 45 20 41 20 57 48 45 52 |.SYSTABL|E A WHER|
|000041a0| 45 20 74 61 62 6c 65 5f | 6e 61 6d 65 20 3d 20 27 |E table_|name = '|
|000041b0| 25 31 27 20 00 41 4e 44 | 20 63 72 65 61 74 6f 72 |%1' .AND| creator|
|000041c0| 20 3d 20 28 53 45 4c 45 | 43 54 20 75 73 65 72 5f | = (SELE|CT user_|
|000041d0| 69 64 20 46 52 4f 4d 20 | 53 59 53 2e 53 59 53 55 |id FROM |SYS.SYSU|
|000041e0| 53 45 52 50 45 52 4d 53 | 20 57 48 45 52 45 20 75 |SERPERMS| WHERE u|
|000041f0| 73 65 72 5f 6e 61 6d 65 | 20 3d 20 27 25 31 27 29 |ser_name| = '%1')|
|00004200| 00 53 45 4c 45 43 54 20 | 28 53 45 4c 45 43 54 20 |.SELECT |(SELECT |
|00004210| 64 62 73 70 61 63 65 5f | 6e 61 6d 65 20 46 52 4f |dbspace_|name FRO|
|00004220| 4d 20 53 59 53 2e 53 59 | 53 46 49 4c 45 20 57 48 |M SYS.SY|SFILE WH|
|00004230| 45 52 45 20 53 59 53 2e | 53 59 53 46 49 4c 45 2e |ERE SYS.|SYSFILE.|
|00004240| 66 69 6c 65 5f 69 64 20 | 3d 20 53 59 53 2e 53 59 |file_id |= SYS.SY|
|00004250| 53 54 41 42 4c 45 2e 66 | 69 6c 65 5f 69 64 29 2c |STABLE.f|ile_id),|
|00004260| 20 28 49 46 20 74 61 62 | 6c 65 5f 74 79 70 65 20 | (IF tab|le_type |
|00004270| 3d 20 27 42 41 53 45 27 | 20 54 48 45 4e 20 27 4e |= 'BASE'| THEN 'N|
|00004280| 27 20 45 4c 53 45 20 27 | 59 27 20 45 4e 44 49 46 |' ELSE '|Y' ENDIF|
|00004290| 29 2c 20 6c 61 73 74 5f | 70 61 67 65 2c 20 76 69 |), last_|page, vi|
|000042a0| 65 77 5f 64 65 66 20 46 | 52 4f 4d 20 53 59 53 2e |ew_def F|ROM SYS.|
|000042b0| 53 59 53 54 41 42 4c 45 | 20 57 48 45 52 45 20 74 |SYSTABLE| WHERE t|
|000042c0| 61 62 6c 65 5f 69 64 20 | 3d 20 25 31 00 22 25 31 |able_id |= %1."%1|
|000042d0| 22 2e 22 25 32 22 00 22 | 25 31 22 00 22 25 31 22 |"."%2"."|%1"."%1"|
|000042e0| 2e 22 25 32 22 00 53 45 | 4c 45 43 54 20 49 46 20 |."%2".SE|LECT IF |
|000042f0| 45 58 49 53 54 53 20 28 | 53 45 4c 45 43 54 20 2a |EXISTS (|SELECT *|
|00004300| 20 46 52 4f 4d 20 25 31 | 20 29 20 54 48 45 4e 20 | FROM %1| ) THEN |
|00004310| 27 4e 27 20 45 4c 53 45 | 20 27 59 27 20 45 4e 44 |'N' ELSE| 'Y' END|
|00004320| 49 46 20 46 52 4f 4d 20 | 44 55 4d 4d 59 00 59 00 |IF FROM |DUMMY.Y.|
|00004330| 53 45 4c 45 43 54 20 77 | 69 64 74 68 2c 20 28 53 |SELECT w|idth, (S|
|00004340| 45 4c 45 43 54 20 64 6f | 6d 61 69 6e 5f 6e 61 6d |ELECT do|main_nam|
|00004350| 65 20 46 52 4f 4d 20 53 | 59 53 2e 53 59 53 44 4f |e FROM S|YS.SYSDO|
|00004360| 4d 41 49 4e 20 57 48 45 | 52 45 20 61 2e 64 6f 6d |MAIN WHE|RE a.dom|
|00004370| 61 69 6e 5f 69 64 20 3d | 20 64 6f 6d 61 69 6e 5f |ain_id =| domain_|
|00004380| 69 64 29 20 46 52 4f 4d | 20 53 59 53 2e 53 59 53 |id) FROM| SYS.SYS|
|00004390| 43 4f 4c 55 4d 4e 20 61 | 20 57 48 45 52 45 20 74 |COLUMN a| WHERE t|
|000043a0| 61 62 6c 65 5f 69 64 20 | 3d 20 25 31 00 4c 4f 4e |able_id |= %1.LON|
|000043b0| 47 20 56 41 52 43 48 41 | 52 00 4c 4f 4e 47 20 42 |G VARCHA|R.LONG B|
|000043c0| 49 4e 41 52 59 00 4e 55 | 4d 45 52 49 43 00 53 45 |INARY.NU|MERIC.SE|
|000043d0| 4c 45 43 54 20 41 2e 69 | 6e 64 65 78 5f 69 64 2c |LECT A.i|ndex_id,|
|000043e0| 20 28 53 45 4c 45 43 54 | 20 63 6f 6c 75 6d 6e 5f | (SELECT| column_|
|000043f0| 6e 61 6d 65 20 46 52 4f | 4d 20 53 59 53 2e 53 59 |name FRO|M SYS.SY|
|00004400| 53 43 4f 4c 55 4d 4e 20 | 57 48 45 52 45 20 53 59 |SCOLUMN |WHERE SY|
|00004410| 53 2e 53 59 53 43 4f 4c | 55 4d 4e 2e 63 6f 6c 75 |S.SYSCOL|UMN.colu|
|00004420| 6d 6e 5f 69 64 20 3d 20 | 41 2e 63 6f 6c 75 6d 6e |mn_id = |A.column|
|00004430| 5f 69 64 20 41 4e 44 20 | 74 61 62 6c 65 5f 69 64 |_id AND |table_id|
|00004440| 20 3d 20 58 2e 74 61 62 | 6c 65 5f 69 64 20 29 20 | = X.tab|le_id ) |
|00004450| 46 52 4f 4d 20 53 59 53 | 2e 53 59 53 49 58 43 4f |FROM SYS|.SYSIXCO|
|00004460| 4c 20 41 20 4a 4f 49 4e | 20 53 59 53 2e 53 59 53 |L A JOIN| SYS.SYS|
|00004470| 49 4e 44 45 58 20 58 20 | 57 48 45 52 45 20 58 2e |INDEX X |WHERE X.|
|00004480| 74 61 62 6c 65 5f 69 64 | 20 3d 20 25 31 20 41 4e |table_id| = %1 AN|
|00004490| 44 20 41 2e 69 6e 64 65 | 78 5f 69 64 20 3d 20 58 |D A.inde|x_id = X|
|000044a0| 2e 69 6e 64 65 78 5f 69 | 64 20 41 4e 44 20 22 75 |.index_i|d AND "u|
|000044b0| 6e 69 71 75 65 22 20 3d | 20 27 55 27 20 4f 52 44 |nique" =| 'U' ORD|
|000044c0| 45 52 20 42 59 20 41 2e | 69 6e 64 65 78 5f 69 64 |ER BY A.|index_id|
|000044d0| 2c 20 41 2e 73 65 71 75 | 65 6e 63 65 00 43 4f 4d |, A.sequ|ence.COM|
|000044e0| 4d 45 4e 54 20 4f 4e 20 | 54 41 42 4c 45 20 25 31 |MENT ON |TABLE %1|
|000044f0| 20 49 53 20 22 25 32 22 | 00 41 4c 54 45 52 20 54 | IS "%2"|.ALTER T|
|00004500| 41 42 4c 45 20 25 31 20 | 52 45 4e 41 4d 45 20 22 |ABLE %1 |RENAME "|
|00004510| 25 32 22 00 53 45 4c 45 | 43 54 20 63 6f 75 6e 74 |%2".SELE|CT count|
|00004520| 20 46 52 4f 4d 20 53 59 | 53 2e 53 59 53 54 41 42 | FROM SY|S.SYSTAB|
|00004530| 4c 45 20 57 48 45 52 45 | 20 74 61 62 6c 65 5f 69 |LE WHERE| table_i|
|00004540| 64 20 3d 20 25 31 00 4e | 00 47 00 47 52 41 4e 54 |d = %1.N|.G.GRANT|
|00004550| 20 25 31 20 4f 4e 20 25 | 32 20 54 4f 20 25 33 00 | %1 ON %|2 TO %3.|
|00004560| 22 00 2c 00 20 57 49 54 | 48 20 47 52 41 4e 54 20 |".,. WIT|H GRANT |
|00004570| 4f 50 54 49 4f 4e 00 52 | 45 56 4f 4b 45 20 25 31 |OPTION.R|EVOKE %1|
|00004580| 20 4f 4e 20 25 32 20 46 | 52 4f 4d 20 25 33 00 41 | ON %2 F|ROM %3.A|
|00004590| 4c 4c 00 22 00 2c 00 43 | 52 45 41 54 45 20 54 41 |LL.".,.C|REATE TA|
|000045a0| 42 4c 45 20 25 31 20 28 | 20 25 32 20 00 43 52 45 |BLE %1 (| %2 .CRE|
|000045b0| 41 54 45 20 47 4c 4f 42 | 41 4c 20 54 45 4d 50 4f |ATE GLOB|AL TEMPO|
|000045c0| 52 41 52 59 20 54 41 42 | 4c 45 20 25 31 20 28 20 |RARY TAB|LE %1 ( |
|000045d0| 25 32 20 00 44 45 43 4c | 41 52 45 20 4c 4f 43 41 |%2 .DECL|ARE LOCA|
|000045e0| 4c 20 54 45 4d 50 4f 52 | 41 52 59 20 54 41 42 4c |L TEMPOR|ARY TABL|
|000045f0| 45 20 25 31 20 28 20 25 | 32 20 00 20 4f 4e 20 22 |E %1 ( %|2 . ON "|
|00004600| 25 31 22 00 20 4f 4e 20 | 43 4f 4d 4d 49 54 20 25 |%1". ON |COMMIT %|
|00004610| 31 20 52 4f 57 53 00 2c | 20 50 52 49 4d 41 52 59 |1 ROWS.,| PRIMARY|
|00004620| 20 4b 45 59 28 20 25 31 | 20 29 20 00 22 25 31 22 | KEY( %1| ) ."%1"|
|00004630| 2e 22 25 32 22 00 2c 20 | 00 2c 20 00 22 00 22 00 |."%2"., |., .".".|
|00004640| 44 45 4c 45 54 45 00 50 | 52 45 53 45 52 56 45 00 |DELETE.P|RESERVE.|
|00004650| 2c 20 55 4e 49 51 55 45 | 28 20 00 20 29 00 2c 20 |, UNIQUE|( . )., |
|00004660| 00 29 20 00 41 4c 54 45 | 52 20 54 41 42 4c 45 20 |.) .ALTE|R TABLE |
|00004670| 25 31 20 44 45 4c 45 54 | 45 20 50 52 49 4d 41 52 |%1 DELET|E PRIMAR|
|00004680| 59 20 4b 45 59 00 22 00 | 22 2c 20 00 22 00 2c 20 |Y KEY.".|", ."., |
|00004690| 00 41 4c 54 45 52 20 54 | 41 42 4c 45 20 25 31 20 |.ALTER T|ABLE %1 |
|000046a0| 44 45 4c 45 54 45 20 43 | 48 45 43 4b 00 00 41 4c |DELETE C|HECK..AL|
|000046b0| 54 45 52 20 54 41 42 4c | 45 20 25 31 20 41 44 44 |TER TABL|E %1 ADD|
|000046c0| 20 25 32 00 41 4c 54 45 | 52 20 54 41 42 4c 45 20 | %2.ALTE|R TABLE |
|000046d0| 25 31 20 41 44 44 20 25 | 32 20 00 53 45 4c 45 43 |%1 ADD %|2 .SELEC|
|000046e0| 54 20 63 6f 75 6e 74 28 | 2a 29 20 46 52 4f 4d 20 |T count(|*) FROM |
|000046f0| 25 31 00 53 59 53 00 20 | 44 45 53 43 00 31 00 53 |%1.SYS. |DESC.1.S|
|00004700| 45 4c 45 43 54 20 63 6f | 75 6e 74 28 2a 29 20 46 |ELECT co|unt(*) F|
|00004710| 52 4f 4d 20 53 59 53 2e | 53 59 53 54 41 42 4c 45 |ROM SYS.|SYSTABLE|
|00004720| 20 4a 4f 49 4e 20 53 59 | 53 2e 53 59 53 55 53 45 | JOIN SY|S.SYSUSE|
|00004730| 52 50 45 52 4d 53 20 4f | 4e 20 63 72 65 61 74 6f |RPERMS O|N creato|
|00004740| 72 20 3d 20 75 73 65 72 | 5f 69 64 20 57 48 45 52 |r = user|_id WHER|
|00004750| 45 20 74 61 62 6c 65 5f | 6e 61 6d 65 20 3d 20 27 |E table_|name = '|
|00004760| 25 31 27 20 41 4e 44 20 | 75 73 65 72 5f 6e 61 6d |%1' AND |user_nam|
|00004770| 65 20 3d 20 27 25 32 27 | 00 43 4f 4d 4d 45 4e 54 |e = '%2'|.COMMENT|
|00004780| 20 4f 4e 20 54 41 42 4c | 45 20 25 31 20 49 53 20 | ON TABL|E %1 IS |
|00004790| 22 25 32 22 00 44 52 4f | 50 20 54 41 42 4c 45 20 |"%2".DRO|P TABLE |
|000047a0| 22 25 31 22 00 53 45 4c | 45 43 54 20 74 61 62 6c |"%1".SEL|ECT tabl|
|000047b0| 65 5f 6e 61 6d 65 2c 20 | 75 73 65 72 5f 6e 61 6d |e_name, |user_nam|
|000047c0| 65 2c 20 54 2e 72 65 6d | 61 72 6b 73 2c 20 74 61 |e, T.rem|arks, ta|
|000047d0| 62 6c 65 5f 69 64 2c 20 | 28 49 46 20 74 61 62 6c |ble_id, |(IF tabl|
|000047e0| 65 5f 74 79 70 65 20 3d | 20 27 42 41 53 45 27 20 |e_type =| 'BASE' |
|000047f0| 54 48 45 4e 20 27 4e 27 | 20 45 4c 53 45 20 27 59 |THEN 'N'| ELSE 'Y|
|00004800| 27 20 45 4e 44 49 46 29 | 2c 20 28 53 45 4c 45 43 |' ENDIF)|, (SELEC|
|00004810| 54 20 63 6f 75 6e 74 28 | 2a 29 20 46 52 4f 4d 20 |T count(|*) FROM |
|00004820| 53 59 53 2e 53 59 53 43 | 4f 4c 55 4d 4e 20 43 20 |SYS.SYSC|OLUMN C |
|00004830| 57 48 45 52 45 20 43 2e | 74 61 62 6c 65 5f 69 64 |WHERE C.|table_id|
|00004840| 20 3d 20 54 2e 74 61 62 | 6c 65 5f 69 64 29 2c 20 | = T.tab|le_id), |
|00004850| 28 49 46 20 63 6f 75 6e | 74 20 3d 20 30 20 54 48 |(IF coun|t = 0 TH|
|00004860| 45 4e 20 27 59 27 20 45 | 4c 53 45 20 27 4e 27 20 |EN 'Y' E|LSE 'N' |
|00004870| 45 4e 44 49 46 29 20 46 | 52 4f 4d 20 53 59 53 2e |ENDIF) F|ROM SYS.|
|00004880| 53 59 53 54 41 42 4c 45 | 20 54 20 4a 4f 49 4e 20 |SYSTABLE| T JOIN |
|00004890| 53 59 53 2e 53 59 53 55 | 53 45 52 50 45 52 4d 53 |SYS.SYSU|SERPERMS|
|000048a0| 20 57 48 45 52 45 20 28 | 74 61 62 6c 65 5f 74 79 | WHERE (|table_ty|
|000048b0| 70 65 20 3d 20 27 42 41 | 53 45 27 20 4f 52 20 74 |pe = 'BA|SE' OR t|
|000048c0| 61 62 6c 65 5f 74 79 70 | 65 20 3d 20 27 47 42 4c |able_typ|e = 'GBL|
|000048d0| 20 54 45 4d 50 27 29 20 | 41 4e 44 20 63 72 65 61 | TEMP') |AND crea|
|000048e0| 74 6f 72 20 4e 4f 54 20 | 49 4e 20 28 53 45 4c 45 |tor NOT |IN (SELE|
|000048f0| 43 54 20 63 72 65 61 74 | 6f 72 20 46 52 4f 4d 20 |CT creat|or FROM |
|00004900| 64 62 78 5f 66 69 6c 74 | 65 72 5f 6c 69 73 74 29 |dbx_filt|er_list)|
|00004910| 20 4f 52 44 45 52 20 42 | 59 20 25 31 00 53 45 4c | ORDER B|Y %1.SEL|
|00004920| 45 43 54 20 74 61 62 6c | 65 5f 6e 61 6d 65 2c 20 |ECT tabl|e_name, |
|00004930| 75 73 65 72 5f 6e 61 6d | 65 2c 20 53 59 53 2e 53 |user_nam|e, SYS.S|
|00004940| 59 53 54 41 42 4c 45 2e | 72 65 6d 61 72 6b 73 2c |YSTABLE.|remarks,|
|00004950| 20 74 61 62 6c 65 5f 69 | 64 2c 20 28 49 46 20 74 | table_i|d, (IF t|
|00004960| 61 62 6c 65 5f 74 79 70 | 65 20 3d 20 27 42 41 53 |able_typ|e = 'BAS|
|00004970| 45 27 20 54 48 45 4e 20 | 27 4e 27 20 45 4c 53 45 |E' THEN |'N' ELSE|
|00004980| 20 27 59 27 20 45 4e 44 | 49 46 29 2c 20 28 49 46 | 'Y' END|IF), (IF|
|00004990| 20 75 73 65 72 5f 6e 61 | 6d 65 20 3d 20 27 53 59 | user_na|me = 'SY|
|000049a0| 53 27 20 4f 52 20 75 73 | 65 72 5f 6e 61 6d 65 20 |S' OR us|er_name |
|000049b0| 3d 20 27 64 62 6f 27 20 | 54 48 45 4e 20 27 59 27 |= 'dbo' |THEN 'Y'|
|000049c0| 20 45 4c 53 45 20 27 4e | 27 20 45 4e 44 49 46 29 | ELSE 'N|' ENDIF)|
|000049d0| 20 46 52 4f 4d 20 53 59 | 53 2e 53 59 53 54 41 42 | FROM SY|S.SYSTAB|
|000049e0| 4c 45 20 4a 4f 49 4e 20 | 53 59 53 2e 53 59 53 55 |LE JOIN |SYS.SYSU|
|000049f0| 53 45 52 50 45 52 4d 53 | 20 57 48 45 52 45 20 28 |SERPERMS| WHERE (|
|00004a00| 74 61 62 6c 65 5f 74 79 | 70 65 20 3d 20 27 42 41 |table_ty|pe = 'BA|
|00004a10| 53 45 27 20 4f 52 20 74 | 61 62 6c 65 5f 74 79 70 |SE' OR t|able_typ|
|00004a20| 65 20 3d 20 27 47 42 4c | 20 54 45 4d 50 27 29 20 |e = 'GBL| TEMP') |
|00004a30| 4f 52 44 45 52 20 42 59 | 20 74 61 62 6c 65 5f 6e |ORDER BY| table_n|
|00004a40| 61 6d 65 00 53 45 4c 45 | 43 54 20 63 6f 75 6e 74 |ame.SELE|CT count|
|00004a50| 28 2a 29 20 46 52 4f 4d | 20 53 59 53 2e 53 59 53 |(*) FROM| SYS.SYS|
|00004a60| 54 41 42 4c 45 20 57 48 | 45 52 45 20 28 74 61 62 |TABLE WH|ERE (tab|
|00004a70| 6c 65 5f 74 79 70 65 20 | 3d 20 27 42 41 53 45 27 |le_type |= 'BASE'|
|00004a80| 20 4f 52 20 74 61 62 6c | 65 5f 74 79 70 65 20 3d | OR tabl|e_type =|
|00004a90| 20 27 47 42 4c 20 54 45 | 4d 50 27 29 20 00 53 45 | 'GBL TE|MP') .SE|
|00004aa0| 4c 45 43 54 20 63 6f 75 | 6e 74 28 2a 29 20 46 52 |LECT cou|nt(*) FR|
|00004ab0| 4f 4d 20 53 59 53 2e 53 | 59 53 54 41 42 4c 45 20 |OM SYS.S|YSTABLE |
|00004ac0| 4a 4f 49 4e 20 53 59 53 | 2e 53 59 53 55 53 45 52 |JOIN SYS|.SYSUSER|
|00004ad0| 50 45 52 4d 53 20 57 48 | 45 52 45 20 28 74 61 62 |PERMS WH|ERE (tab|
|00004ae0| 6c 65 5f 74 79 70 65 20 | 3d 20 27 42 41 53 45 27 |le_type |= 'BASE'|
|00004af0| 20 4f 52 20 74 61 62 6c | 65 5f 74 79 70 65 20 3d | OR tabl|e_type =|
|00004b00| 20 27 47 42 4c 20 54 45 | 4d 50 27 29 20 41 4e 44 | 'GBL TE|MP') AND|
|00004b10| 20 63 72 65 61 74 6f 72 | 20 4e 4f 54 20 49 4e 20 | creator| NOT IN |
|00004b20| 28 53 45 4c 45 43 54 20 | 63 72 65 61 74 6f 72 20 |(SELECT |creator |
|00004b30| 46 52 4f 4d 20 64 62 78 | 5f 66 69 6c 74 65 72 5f |FROM dbx|_filter_|
|00004b40| 6c 69 73 74 29 00 53 45 | 4c 45 43 54 20 75 73 65 |list).SE|LECT use|
|00004b50| 72 5f 6e 61 6d 65 2c 20 | 75 73 65 72 5f 67 72 6f |r_name, |user_gro|
|00004b60| 75 70 2c 20 73 65 6c 65 | 63 74 61 75 74 68 2c 20 |up, sele|ctauth, |
|00004b70| 69 6e 73 65 72 74 61 75 | 74 68 2c 20 64 65 6c 65 |insertau|th, dele|
|00004b80| 74 65 61 75 74 68 2c 20 | 75 70 64 61 74 65 61 75 |teauth, |updateau|
|00004b90| 74 68 2c 20 61 6c 74 65 | 72 61 75 74 68 2c 20 72 |th, alte|rauth, r|
|00004ba0| 65 66 65 72 65 6e 63 65 | 61 75 74 68 2c 20 28 20 |eference|auth, ( |
|00004bb0| 73 65 6c 65 63 74 20 73 | 75 6d 28 20 64 69 73 74 |select s|um( dist|
|00004bc0| 69 6e 63 74 20 70 72 69 | 76 69 6c 65 67 65 5f 74 |inct pri|vilege_t|
|00004bd0| 79 70 65 20 29 20 66 72 | 6f 6d 20 53 59 53 2e 53 |ype ) fr|om SYS.S|
|00004be0| 59 53 43 4f 4c 50 45 52 | 4d 20 77 68 65 72 65 20 |YSCOLPER|M where |
|00004bf0| 53 59 53 2e 53 59 53 43 | 4f 4c 50 45 52 4d 2e 74 |SYS.SYSC|OLPERM.t|
|00004c00| 61 62 6c 65 5f 69 64 20 | 3d 20 53 59 53 2e 53 59 |able_id |= SYS.SY|
|00004c10| 53 54 41 42 4c 45 50 45 | 52 4d 2e 74 74 61 62 6c |STABLEPE|RM.ttabl|
|00004c20| 65 5f 69 64 20 61 6e 64 | 20 75 73 65 72 5f 69 64 |e_id and| user_id|
|00004c30| 20 3d 20 67 72 61 6e 74 | 65 65 20 29 20 46 52 4f | = grant|ee ) FRO|
|00004c40| 4d 20 53 59 53 2e 53 59 | 53 54 41 42 4c 45 50 45 |M SYS.SY|STABLEPE|
|00004c50| 52 4d 20 4a 4f 49 4e 20 | 53 59 53 2e 53 59 53 55 |RM JOIN |SYS.SYSU|
|00004c60| 53 45 52 50 45 52 4d 53 | 20 67 72 61 6e 74 65 65 |SERPERMS| grantee|
|00004c70| 20 57 48 45 52 45 20 75 | 73 65 72 5f 69 64 20 3d | WHERE u|ser_id =|
|00004c80| 20 67 72 61 6e 74 65 65 | 20 41 4e 44 20 74 74 61 | grantee| AND tta|
|00004c90| 62 6c 65 5f 69 64 20 3d | 20 25 31 20 4f 52 44 45 |ble_id =| %1 ORDE|
|00004ca0| 52 20 42 59 20 75 73 65 | 72 5f 67 72 6f 75 70 20 |R BY use|r_group |
|00004cb0| 64 65 73 63 2c 20 67 72 | 61 6e 74 65 65 00 53 45 |desc, gr|antee.SE|
|00004cc0| 4c 45 43 54 20 75 73 65 | 72 5f 6e 61 6d 65 2c 20 |LECT use|r_name, |
|00004cd0| 75 73 65 72 5f 67 72 6f | 75 70 2c 20 73 65 6c 65 |user_gro|up, sele|
|00004ce0| 63 74 61 75 74 68 2c 20 | 69 6e 73 65 72 74 61 75 |ctauth, |insertau|
|00004cf0| 74 68 2c 20 64 65 6c 65 | 74 65 61 75 74 68 2c 20 |th, dele|teauth, |
|00004d00| 75 70 64 61 74 65 61 75 | 74 68 2c 20 61 6c 74 65 |updateau|th, alte|
|00004d10| 72 61 75 74 68 2c 20 72 | 65 66 65 72 65 6e 63 65 |rauth, r|eference|
|00004d20| 61 75 74 68 2c 20 28 20 | 69 66 20 75 70 64 61 74 |auth, ( |if updat|
|00004d30| 65 63 6f 6c 73 20 3d 20 | 27 59 27 20 74 68 65 6e |ecols = |'Y' then|
|00004d40| 20 38 20 65 6c 73 65 20 | 30 20 65 6e 64 69 66 20 | 8 else |0 endif |
|00004d50| 29 20 46 52 4f 4d 20 53 | 59 53 2e 53 59 53 54 41 |) FROM S|YS.SYSTA|
|00004d60| 42 4c 45 50 45 52 4d 20 | 4a 4f 49 4e 20 53 59 53 |BLEPERM |JOIN SYS|
|00004d70| 2e 53 59 53 55 53 45 52 | 50 45 52 4d 53 20 67 72 |.SYSUSER|PERMS gr|
|00004d80| 61 6e 74 65 65 20 57 48 | 45 52 45 20 75 73 65 72 |antee WH|ERE user|
|00004d90| 5f 69 64 20 3d 20 67 72 | 61 6e 74 65 65 20 41 4e |_id = gr|antee AN|
|00004da0| 44 20 74 74 61 62 6c 65 | 5f 69 64 20 3d 20 25 31 |D ttable|_id = %1|
|00004db0| 20 4f 52 44 45 52 20 42 | 59 20 75 73 65 72 5f 67 | ORDER B|Y user_g|
|00004dc0| 72 6f 75 70 20 64 65 73 | 63 2c 20 67 72 61 6e 74 |roup des|c, grant|
|00004dd0| 65 65 00 53 45 4c 45 43 | 54 20 75 73 65 72 5f 6e |ee.SELEC|T user_n|
|00004de0| 61 6d 65 2c 20 75 73 65 | 72 5f 67 72 6f 75 70 2c |ame, use|r_group,|
|00004df0| 20 73 65 6c 65 63 74 61 | 75 74 68 2c 20 69 6e 73 | selecta|uth, ins|
|00004e00| 65 72 74 61 75 74 68 2c | 20 64 65 6c 65 74 65 61 |ertauth,| deletea|
|00004e10| 75 74 68 2c 20 75 70 64 | 61 74 65 61 75 74 68 2c |uth, upd|ateauth,|
|00004e20| 20 61 6c 74 65 72 61 75 | 74 68 2c 20 72 65 66 65 | alterau|th, refe|
|00004e30| 72 65 6e 63 65 61 75 74 | 68 2c 20 28 20 73 65 6c |renceaut|h, ( sel|
|00004e40| 65 63 74 20 73 75 6d 28 | 20 64 69 73 74 69 6e 63 |ect sum(| distinc|
|00004e50| 74 20 70 72 69 76 69 6c | 65 67 65 5f 74 79 70 65 |t privil|ege_type|
|00004e60| 20 29 20 66 72 6f 6d 20 | 53 59 53 2e 53 59 53 43 | ) from |SYS.SYSC|
|00004e70| 4f 4c 50 45 52 4d 20 77 | 68 65 72 65 20 53 59 53 |OLPERM w|here SYS|
|00004e80| 2e 53 59 53 43 4f 4c 50 | 45 52 4d 2e 74 61 62 6c |.SYSCOLP|ERM.tabl|
|00004e90| 65 5f 69 64 20 3d 20 53 | 59 53 2e 53 59 53 54 41 |e_id = S|YS.SYSTA|
|00004ea0| 42 4c 45 50 45 52 4d 2e | 74 74 61 62 6c 65 5f 69 |BLEPERM.|ttable_i|
|00004eb0| 64 20 61 6e 64 20 75 73 | 65 72 5f 69 64 20 3d 20 |d and us|er_id = |
|00004ec0| 67 72 61 6e 74 65 65 20 | 29 20 46 52 4f 4d 20 53 |grantee |) FROM S|
|00004ed0| 59 53 2e 53 59 53 54 41 | 42 4c 45 50 45 52 4d 20 |YS.SYSTA|BLEPERM |
|00004ee0| 4a 4f 49 4e 20 53 59 53 | 2e 53 59 53 55 53 45 52 |JOIN SYS|.SYSUSER|
|00004ef0| 50 45 52 4d 53 20 67 72 | 61 6e 74 65 65 20 57 48 |PERMS gr|antee WH|
|00004f00| 45 52 45 20 75 73 65 72 | 5f 69 64 20 3d 20 67 72 |ERE user|_id = gr|
|00004f10| 61 6e 74 65 65 20 41 4e | 44 20 74 74 61 62 6c 65 |antee AN|D ttable|
|00004f20| 5f 69 64 20 3d 20 25 31 | 20 41 4e 44 20 75 73 65 |_id = %1| AND use|
|00004f30| 72 5f 6e 61 6d 65 20 3d | 20 27 25 32 27 20 4f 52 |r_name =| '%2' OR|
|00004f40| 44 45 52 20 42 59 20 75 | 73 65 72 5f 67 72 6f 75 |DER BY u|ser_grou|
|00004f50| 70 20 64 65 73 63 2c 20 | 67 72 61 6e 74 65 65 00 |p desc, |grantee.|
|00004f60| 53 45 4c 45 43 54 20 75 | 73 65 72 5f 6e 61 6d 65 |SELECT u|ser_name|
|00004f70| 2c 20 75 73 65 72 5f 67 | 72 6f 75 70 2c 20 73 65 |, user_g|roup, se|
|00004f80| 6c 65 63 74 61 75 74 68 | 2c 20 69 6e 73 65 72 74 |lectauth|, insert|
|00004f90| 61 75 74 68 2c 20 64 65 | 6c 65 74 65 61 75 74 68 |auth, de|leteauth|
|00004fa0| 2c 20 75 70 64 61 74 65 | 61 75 74 68 2c 20 61 6c |, update|auth, al|
|00004fb0| 74 65 72 61 75 74 68 2c | 20 72 65 66 65 72 65 6e |terauth,| referen|
|00004fc0| 63 65 61 75 74 68 2c 20 | 28 20 69 66 20 75 70 64 |ceauth, |( if upd|
|00004fd0| 61 74 65 63 6f 6c 73 20 | 3d 20 27 59 27 20 74 68 |atecols |= 'Y' th|
|00004fe0| 65 6e 20 38 20 65 6c 73 | 65 20 30 20 65 6e 64 69 |en 8 els|e 0 endi|
|00004ff0| 66 20 29 20 46 52 4f 4d | 20 53 59 53 2e 53 59 53 |f ) FROM| SYS.SYS|
|00005000| 54 41 42 4c 45 50 45 52 | 4d 20 4a 4f 49 4e 20 53 |TABLEPER|M JOIN S|
|00005010| 59 53 2e 53 59 53 55 53 | 45 52 50 45 52 4d 53 20 |YS.SYSUS|ERPERMS |
|00005020| 67 72 61 6e 74 65 65 20 | 57 48 45 52 45 20 75 73 |grantee |WHERE us|
|00005030| 65 72 5f 69 64 20 3d 20 | 67 72 61 6e 74 65 65 20 |er_id = |grantee |
|00005040| 41 4e 44 20 74 74 61 62 | 6c 65 5f 69 64 20 3d 20 |AND ttab|le_id = |
|00005050| 25 31 20 41 4e 44 20 75 | 73 65 72 5f 6e 61 6d 65 |%1 AND u|ser_name|
|00005060| 20 3d 20 27 25 32 27 20 | 4f 52 44 45 52 20 42 59 | = '%2' |ORDER BY|
|00005070| 20 75 73 65 72 5f 67 72 | 6f 75 70 20 64 65 73 63 | user_gr|oup desc|
|00005080| 2c 20 67 72 61 6e 74 65 | 65 00 44 52 4f 50 20 54 |, grante|e.DROP T|
|00005090| 41 42 4c 45 20 22 25 31 | 22 2e 22 25 32 22 00 41 |ABLE "%1|"."%2".A|
|000050a0| 4c 54 45 52 20 54 41 42 | 4c 45 20 25 31 20 41 44 |LTER TAB|LE %1 AD|
|000050b0| 44 20 50 52 49 4d 41 52 | 59 20 4b 45 59 20 28 20 |D PRIMAR|Y KEY ( |
|000050c0| 25 32 20 29 00 00 00 00 | 00 00 00 00 22 00 2c 00 |%2 )....|....".,.|
|000050d0| 25 31 28 25 32 29 00 00 | 2c 00 73 65 6c 65 63 74 |%1(%2)..|,.select|
|000050e0| 20 63 6f 6c 75 6d 6e 5f | 6e 61 6d 65 2c 20 28 69 | column_|name, (i|
|000050f0| 66 20 63 6f 6c 75 6d 6e | 5f 69 64 20 69 6e 28 20 |f column|_id in( |
|00005100| 73 65 6c 65 63 74 20 63 | 6f 6c 75 6d 6e 5f 69 64 |select c|olumn_id|
|00005110| 20 66 72 6f 6d 20 53 59 | 53 2e 53 59 53 43 4f 4c | from SY|S.SYSCOL|
|00005120| 50 45 52 4d 20 77 68 65 | 72 65 20 53 59 53 2e 53 |PERM whe|re SYS.S|
|00005130| 59 53 43 4f 4c 50 45 52 | 4d 2e 74 61 62 6c 65 5f |YSCOLPER|M.table_|
|00005140| 69 64 20 3d 20 53 59 53 | 2e 53 59 53 54 41 42 4c |id = SYS|.SYSTABL|
|00005150| 45 2e 74 61 62 6c 65 5f | 69 64 20 61 6e 64 20 70 |E.table_|id and p|
|00005160| 72 69 76 69 6c 65 67 65 | 5f 74 79 70 65 20 3d 20 |rivilege|_type = |
|00005170| 25 31 20 61 6e 64 20 67 | 72 61 6e 74 65 65 20 3d |%1 and g|rantee =|
|00005180| 20 28 73 65 6c 65 63 74 | 20 75 73 65 72 5f 69 64 | (select| user_id|
|00005190| 20 66 72 6f 6d 20 53 59 | 53 2e 53 59 53 55 53 45 | from SY|S.SYSUSE|
|000051a0| 52 50 45 52 4d 53 20 77 | 68 65 72 65 20 75 73 65 |RPERMS w|here use|
|000051b0| 72 5f 6e 61 6d 65 20 3d | 20 27 25 32 27 29 20 29 |r_name =| '%2') )|
|000051c0| 20 74 68 65 6e 20 27 59 | 27 20 65 6c 73 65 20 27 | then 'Y|' else '|
|000051d0| 4e 27 20 65 6e 64 69 66 | 20 29 2c 20 28 69 66 20 |N' endif| ), (if |
|000051e0| 63 6f 6c 75 6d 6e 5f 69 | 64 20 69 6e 28 20 73 65 |column_i|d in( se|
|000051f0| 6c 65 63 74 20 63 6f 6c | 75 6d 6e 5f 69 64 20 66 |lect col|umn_id f|
|00005200| 72 6f 6d 20 53 59 53 2e | 53 59 53 43 4f 4c 50 45 |rom SYS.|SYSCOLPE|
|00005210| 52 4d 20 77 68 65 72 65 | 20 53 59 53 2e 53 59 53 |RM where| SYS.SYS|
|00005220| 43 4f 4c 50 45 52 4d 2e | 74 61 62 6c 65 5f 69 64 |COLPERM.|table_id|
|00005230| 20 3d 20 53 59 53 2e 53 | 59 53 54 41 42 4c 45 2e | = SYS.S|YSTABLE.|
|00005240| 74 61 62 6c 65 5f 69 64 | 20 61 6e 64 20 70 72 69 |table_id| and pri|
|00005250| 76 69 6c 65 67 65 5f 74 | 79 70 65 20 3d 20 25 33 |vilege_t|ype = %3|
|00005260| 20 61 6e 64 20 67 72 61 | 6e 74 65 65 20 3d 20 28 | and gra|ntee = (|
|00005270| 73 65 6c 65 63 74 20 75 | 73 65 72 5f 69 64 20 66 |select u|ser_id f|
|00005280| 72 6f 6d 20 53 59 53 2e | 53 59 53 55 53 45 52 50 |rom SYS.|SYSUSERP|
|00005290| 45 52 4d 53 20 77 68 65 | 72 65 20 75 73 65 72 5f |ERMS whe|re user_|
|000052a0| 6e 61 6d 65 20 3d 20 27 | 25 34 27 20 29 20 61 6e |name = '|%4' ) an|
|000052b0| 64 20 69 73 5f 67 72 61 | 6e 74 61 62 6c 65 20 3d |d is_gra|ntable =|
|000052c0| 20 27 59 27 20 29 20 74 | 68 65 6e 20 27 59 27 20 | 'Y' ) t|hen 'Y' |
|000052d0| 65 6c 73 65 20 27 4e 27 | 20 65 6e 64 69 66 20 29 |else 'N'| endif )|
|000052e0| 20 66 72 6f 6d 20 53 59 | 53 2e 53 59 53 43 4f 4c | from SY|S.SYSCOL|
|000052f0| 55 4d 4e 20 6a 6f 69 6e | 20 53 59 53 2e 53 59 53 |UMN join| SYS.SYS|
|00005300| 54 41 42 4c 45 20 6a 6f | 69 6e 20 53 59 53 2e 53 |TABLE jo|in SYS.S|
|00005310| 59 53 55 53 45 52 50 45 | 52 4d 53 20 77 68 65 72 |YSUSERPE|RMS wher|
|00005320| 65 20 74 61 62 6c 65 5f | 6e 61 6d 65 20 3d 20 27 |e table_|name = '|
|00005330| 25 35 27 20 61 6e 64 20 | 75 73 65 72 5f 6e 61 6d |%5' and |user_nam|
|00005340| 65 20 3d 20 27 25 36 27 | 20 6f 72 64 65 72 20 62 |e = '%6'| order b|
|00005350| 79 20 53 59 53 2e 53 59 | 53 43 4f 4c 55 4d 4e 2e |y SYS.SY|SCOLUMN.|
|00005360| 63 6f 6c 75 6d 6e 5f 6e | 61 6d 65 00 73 65 6c 65 |column_n|ame.sele|
|00005370| 63 74 20 63 6f 6c 75 6d | 6e 5f 6e 61 6d 65 2c 20 |ct colum|n_name, |
|00005380| 28 69 66 20 25 31 20 3d | 20 38 20 61 6e 64 20 63 |(if %1 =| 8 and c|
|00005390| 6f 6c 75 6d 6e 5f 69 64 | 20 69 6e 28 20 73 65 6c |olumn_id| in( sel|
|000053a0| 65 63 74 20 63 6f 6c 75 | 6d 6e 5f 69 64 20 66 72 |ect colu|mn_id fr|
|000053b0| 6f 6d 20 53 59 53 2e 53 | 59 53 43 4f 4c 50 45 52 |om SYS.S|YSCOLPER|
|000053c0| 4d 20 77 68 65 72 65 20 | 53 59 53 2e 53 59 53 43 |M where |SYS.SYSC|
|000053d0| 4f 4c 50 45 52 4d 2e 74 | 61 62 6c 65 5f 69 64 20 |OLPERM.t|able_id |
|000053e0| 3d 20 53 59 53 2e 53 59 | 53 54 41 42 4c 45 2e 74 |= SYS.SY|STABLE.t|
|000053f0| 61 62 6c 65 5f 69 64 20 | 61 6e 64 20 67 72 61 6e |able_id |and gran|
|00005400| 74 65 65 20 3d 20 28 73 | 65 6c 65 63 74 20 75 73 |tee = (s|elect us|
|00005410| 65 72 5f 69 64 20 66 72 | 6f 6d 20 53 59 53 2e 53 |er_id fr|om SYS.S|
|00005420| 59 53 55 53 45 52 50 45 | 52 4d 53 20 77 68 65 72 |YSUSERPE|RMS wher|
|00005430| 65 20 75 73 65 72 5f 6e | 61 6d 65 20 3d 20 27 25 |e user_n|ame = '%|
|00005440| 32 27 29 20 29 20 74 68 | 65 6e 20 27 59 27 20 65 |2') ) th|en 'Y' e|
|00005450| 6c 73 65 20 27 4e 27 20 | 65 6e 64 69 66 20 29 2c |lse 'N' |endif ),|
|00005460| 20 27 4e 27 20 66 72 6f | 6d 20 53 59 53 2e 53 59 | 'N' fro|m SYS.SY|
|00005470| 53 43 4f 4c 55 4d 4e 20 | 6a 6f 69 6e 20 53 59 53 |SCOLUMN |join SYS|
|00005480| 2e 53 59 53 54 41 42 4c | 45 20 6a 6f 69 6e 20 53 |.SYSTABL|E join S|
|00005490| 59 53 2e 53 59 53 55 53 | 45 52 50 45 52 4d 53 20 |YS.SYSUS|ERPERMS |
|000054a0| 77 68 65 72 65 20 74 61 | 62 6c 65 5f 6e 61 6d 65 |where ta|ble_name|
|000054b0| 20 3d 20 27 25 33 27 20 | 61 6e 64 20 75 73 65 72 | = '%3' |and user|
|000054c0| 5f 6e 61 6d 65 20 3d 20 | 27 25 34 27 20 6f 72 64 |_name = |'%4' ord|
|000054d0| 65 72 20 62 79 20 53 59 | 53 2e 53 59 53 43 4f 4c |er by SY|S.SYSCOL|
|000054e0| 55 4d 4e 2e 63 6f 6c 75 | 6d 6e 5f 6e 61 6d 65 00 |UMN.colu|mn_name.|
|000054f0| 41 4c 54 45 52 00 44 45 | 4c 45 54 45 00 49 4e 53 |ALTER.DE|LETE.INS|
|00005500| 45 52 54 00 52 45 46 45 | 52 45 4e 43 45 53 00 53 |ERT.REFE|RENCES.S|
|00005510| 45 4c 45 43 54 00 55 50 | 44 41 54 45 00 00 00 00 |ELECT.UP|DATE....|
|00005520| 20 00 20 00 44 52 4f 50 | 20 43 4f 4e 4e 45 43 54 | . .DROP| CONNECT|
|00005530| 49 4f 4e 20 25 31 00 53 | 45 4c 45 43 54 20 63 6f |ION %1.S|ELECT co|
|00005540| 6e 6e 65 63 74 69 6f 6e | 5f 70 72 6f 70 65 72 74 |nnection|_propert|
|00005550| 79 28 20 27 25 31 27 2c | 20 25 32 20 29 00 55 73 |y( '%1',| %2 ).Us|
|00005560| 65 72 49 64 00 4e 61 6d | 65 00 44 42 4e 75 6d 62 |erId.Nam|e.DBNumb|
|00005570| 65 72 00 46 69 6c 65 00 | 43 6f 6d 6d 4c 69 6e 6b |er.File.|CommLink|
|00005580| 00 4c 6f 67 4e 61 6d 65 | 00 43 6f 6e 6e 43 6f 75 |.LogName|.ConnCou|
|00005590| 6e 74 00 4e 6f 64 65 41 | 64 64 72 65 73 73 00 53 |nt.NodeA|ddress.S|
|000055a0| 45 4c 45 43 54 20 64 62 | 5f 70 72 6f 70 65 72 74 |ELECT db|_propert|
|000055b0| 79 28 27 25 31 27 29 00 | 53 45 4c 45 43 54 20 63 |y('%1').|SELECT c|
|000055c0| 6f 6e 6e 65 63 74 69 6f | 6e 5f 70 72 6f 70 65 72 |onnectio|n_proper|
|000055d0| 74 79 28 27 4e 75 6d 62 | 65 72 27 29 00 53 45 4c |ty('Numb|er').SEL|
|000055e0| 45 43 54 20 6e 65 78 74 | 5f 63 6f 6e 6e 65 63 74 |ECT next|_connect|
|000055f0| 69 6f 6e 28 20 25 31 20 | 29 00 53 45 4c 45 43 54 |ion( %1 |).SELECT|
|00005600| 20 63 6f 6e 6e 65 63 74 | 69 6f 6e 5f 70 72 6f 70 | connect|ion_prop|
|00005610| 65 72 74 79 28 20 27 55 | 73 65 72 49 64 27 2c 20 |erty( 'U|serId', |
|00005620| 25 31 20 29 00 00 00 00 | 73 65 6c 65 63 74 20 63 |%1 )....|select c|
|00005630| 6f 6e 6e 65 63 74 69 6f | 6e 5f 70 72 6f 70 65 72 |onnectio|n_proper|
|00005640| 74 79 28 27 25 31 27 2c | 20 25 32 29 00 73 65 6c |ty('%1',| %2).sel|
|00005650| 65 63 74 20 70 72 6f 70 | 65 72 74 79 5f 64 65 73 |ect prop|erty_des|
|00005660| 63 72 69 70 74 69 6f 6e | 28 27 25 31 27 29 00 73 |cription|('%1').s|
|00005670| 65 6c 65 63 74 20 70 72 | 6f 70 65 72 74 79 28 27 |elect pr|operty('|
|00005680| 25 31 27 29 00 41 73 79 | 6e 63 32 52 65 61 64 00 |%1').Asy|nc2Read.|
|00005690| 41 73 79 6e 63 52 65 61 | 64 00 41 73 79 6e 63 57 |AsyncRea|d.AsyncW|
|000056a0| 72 69 74 65 00 42 6c 6f | 63 6b 65 64 4f 6e 00 43 |rite.Blo|ckedOn.C|
|000056b0| 61 63 68 65 48 69 74 73 | 00 43 61 63 68 65 52 65 |acheHits|.CacheRe|
|000056c0| 61 64 00 43 61 63 68 65 | 52 65 61 64 49 6e 64 49 |ad.Cache|ReadIndI|
|000056d0| 6e 74 00 43 61 63 68 65 | 52 65 61 64 49 6e 64 4c |nt.Cache|ReadIndL|
|000056e0| 65 61 66 00 43 61 63 68 | 65 52 65 61 64 54 61 62 |eaf.Cach|eReadTab|
|000056f0| 6c 65 00 43 61 63 68 65 | 57 72 69 74 65 00 43 6f |le.Cache|Write.Co|
|00005700| 6d 6d 69 74 00 43 6f 6d | 6d 4c 69 6e 6b 00 43 6f |mmit.Com|mLink.Co|
|00005710| 6e 6e 52 65 71 00 43 75 | 72 72 54 61 73 6b 53 77 |nnReq.Cu|rrTaskSw|
|00005720| 69 74 63 68 00 43 75 72 | 73 6f 72 00 43 75 72 73 |itch.Cur|sor.Curs|
|00005730| 6f 72 4f 70 65 6e 00 44 | 42 4e 75 6d 62 65 72 00 |orOpen.D|BNumber.|
|00005740| 44 69 73 6b 52 65 61 64 | 00 44 69 73 6b 52 65 61 |DiskRead|.DiskRea|
|00005750| 64 49 6e 64 49 6e 74 00 | 44 69 73 6b 52 65 61 64 |dIndInt.|DiskRead|
|00005760| 49 6e 64 4c 65 61 66 00 | 44 69 73 6b 52 65 61 64 |IndLeaf.|DiskRead|
|00005770| 54 61 62 6c 65 00 44 69 | 73 6b 53 79 6e 63 52 65 |Table.Di|skSyncRe|
|00005780| 61 64 00 44 69 73 6b 53 | 79 6e 63 57 72 69 74 65 |ad.DiskS|yncWrite|
|00005790| 00 44 69 73 6b 57 61 69 | 74 52 65 61 64 00 44 69 |.DiskWai|tRead.Di|
|000057a0| 73 6b 57 61 69 74 57 72 | 69 74 65 00 44 69 73 6b |skWaitWr|ite.Disk|
|000057b0| 57 72 69 74 65 00 46 75 | 6c 6c 43 6f 6d 70 61 72 |Write.Fu|llCompar|
|000057c0| 65 00 48 69 6e 74 55 73 | 65 64 00 49 6e 64 41 64 |e.HintUs|ed.IndAd|
|000057d0| 64 00 49 6e 64 4c 6f 6f | 6b 75 70 00 4c 61 73 74 |d.IndLoo|kup.Last|
|000057e0| 49 64 6c 65 00 4c 61 73 | 74 52 65 71 54 69 6d 65 |Idle.Las|tReqTime|
|000057f0| 00 4c 6f 63 6b 54 61 62 | 6c 65 50 61 67 65 73 00 |.LockTab|lePages.|
|00005800| 4c 6f 67 46 72 65 65 43 | 6f 6d 6d 69 74 00 4c 6f |LogFreeC|ommit.Lo|
|00005810| 67 52 65 77 72 69 74 65 | 00 4c 6f 67 57 72 69 74 |gRewrite|.LogWrit|
|00005820| 65 00 4e 61 6d 65 00 4e | 6f 64 65 41 64 64 72 65 |e.Name.N|odeAddre|
|00005830| 73 73 00 4e 75 6d 62 65 | 72 00 50 6f 72 74 00 50 |ss.Numbe|r.Port.P|
|00005840| 72 65 70 53 74 6d 74 00 | 50 72 6f 63 65 73 73 54 |repStmt.|ProcessT|
|00005850| 69 6d 65 00 52 65 61 64 | 48 69 6e 74 00 52 65 71 |ime.Read|Hint.Req|
|00005860| 54 79 70 65 00 52 6c 62 | 6b 00 53 79 6e 63 57 72 |Type.Rlb|k.SyncWr|
|00005870| 69 74 65 43 68 6b 70 74 | 00 53 79 6e 63 57 72 69 |iteChkpt|.SyncWri|
|00005880| 74 65 45 78 74 65 6e 64 | 00 53 79 6e 63 57 72 69 |teExtend|.SyncWri|
|00005890| 74 65 46 72 65 65 43 75 | 72 72 00 53 79 6e 63 57 |teFreeCu|rr.SyncW|
|000058a0| 72 69 74 65 46 72 65 65 | 50 75 73 68 00 53 79 6e |riteFree|Push.Syn|
|000058b0| 63 57 72 69 74 65 4c 6f | 67 00 53 79 6e 63 57 72 |cWriteLo|g.SyncWr|
|000058c0| 69 74 65 52 6c 62 6b 00 | 53 79 6e 63 57 72 69 74 |iteRlbk.|SyncWrit|
|000058d0| 65 55 6e 6b 6e 00 54 61 | 73 6b 53 77 69 74 63 68 |eUnkn.Ta|skSwitch|
|000058e0| 00 54 61 73 6b 53 77 69 | 74 63 68 43 68 65 63 6b |.TaskSwi|tchCheck|
|000058f0| 00 55 6e 63 6f 6d 6d 69 | 74 4f 70 00 55 73 65 72 |.Uncommi|tOp.User|
|00005900| 69 64 00 56 6f 6c 75 6e | 74 61 72 79 42 6c 6f 63 |id.Volun|taryBloc|
|00005910| 6b 00 57 61 69 74 52 65 | 61 64 43 6d 70 00 57 61 |k.WaitRe|adCmp.Wa|
|00005920| 69 74 52 65 61 64 4f 70 | 74 00 57 61 69 74 52 65 |itReadOp|t.WaitRe|
|00005930| 61 64 53 79 73 00 57 61 | 69 74 52 65 61 64 54 65 |adSys.Wa|itReadTe|
|00005940| 6d 70 00 57 61 69 74 52 | 65 61 64 55 6e 6b 6e 00 |mp.WaitR|eadUnkn.|
|00005950| 53 45 4c 45 43 54 20 2a | 20 46 52 4f 4d 20 53 59 |SELECT *| FROM SY|
|00005960| 53 2e 53 59 53 54 41 42 | 4c 45 00 34 2e 30 00 35 |S.SYSTAB|LE.4.0.5|
|00005970| 2e 30 00 35 2e 30 2e 30 | 32 00 35 2e 30 2e 30 33 |.0.5.0.0|2.5.0.03|
|00005980| 00 36 2e 30 00 53 45 4c | 45 43 54 20 64 62 5f 70 |.6.0.SEL|ECT db_p|
|00005990| 72 6f 70 65 72 74 79 28 | 20 27 25 31 27 2c 20 27 |roperty(| '%1', '|
|000059a0| 25 32 27 20 29 00 53 45 | 4c 45 43 54 20 64 62 5f |%2' ).SE|LECT db_|
|000059b0| 69 64 28 29 00 50 61 67 | 65 53 69 7a 65 00 43 6f |id().Pag|eSize.Co|
|000059c0| 6e 6e 43 6f 75 6e 74 00 | 4c 6f 67 4e 61 6d 65 00 |nnCount.|LogName.|
|000059d0| 4c 6f 67 4d 69 72 72 6f | 72 46 69 6c 65 00 53 45 |LogMirro|rFile.SE|
|000059e0| 4c 45 43 54 20 70 61 67 | 65 5f 73 69 7a 65 20 46 |LECT pag|e_size F|
|000059f0| 52 4f 4d 20 53 59 53 2e | 53 59 53 49 4e 46 4f 00 |ROM SYS.|SYSINFO.|
|00005a00| 53 45 4c 45 43 54 20 64 | 65 66 61 75 6c 74 5f 63 |SELECT d|efault_c|
|00005a10| 6f 6c 6c 61 74 69 6f 6e | 20 46 52 4f 4d 20 53 59 |ollation| FROM SY|
|00005a20| 53 2e 53 59 53 49 4e 46 | 4f 00 53 45 4c 45 43 54 |S.SYSINF|O.SELECT|
|00005a30| 20 65 6e 63 72 79 70 74 | 69 6f 6e 20 46 52 4f 4d | encrypt|ion FROM|
|00005a40| 20 53 59 53 2e 53 59 53 | 49 4e 46 4f 00 53 45 4c | SYS.SYS|INFO.SEL|
|00005a50| 45 43 54 20 62 6c 61 6e | 6b 5f 70 61 64 64 69 6e |ECT blan|k_paddin|
|00005a60| 67 20 46 52 4f 4d 20 53 | 59 53 2e 53 59 53 49 4e |g FROM S|YS.SYSIN|
|00005a70| 46 4f 00 53 45 4c 45 43 | 54 20 63 61 73 65 5f 73 |FO.SELEC|T case_s|
|00005a80| 65 6e 73 69 74 69 76 69 | 74 79 20 46 52 4f 4d 20 |ensitivi|ty FROM |
|00005a90| 53 59 53 2e 53 59 53 49 | 4e 46 4f 00 53 45 4c 45 |SYS.SYSI|NFO.SELE|
|00005aa0| 43 54 20 63 6f 6c 6c 61 | 74 69 6f 6e 5f 6e 61 6d |CT colla|tion_nam|
|00005ab0| 65 20 46 52 4f 4d 20 53 | 59 53 2e 53 59 53 43 4f |e FROM S|YS.SYSCO|
|00005ac0| 4c 4c 41 54 49 4f 4e 20 | 57 48 45 52 45 20 63 6f |LLATION |WHERE co|
|00005ad0| 6c 6c 61 74 69 6f 6e 5f | 6c 61 62 65 6c 20 3d 20 |llation_|label = |
|00005ae0| 27 25 31 27 00 38 35 30 | 00 53 45 4c 45 43 54 20 |'%1'.850|.SELECT |
|00005af0| 43 55 52 52 45 4e 54 20 | 50 55 42 4c 49 53 48 45 |CURRENT |PUBLISHE|
|00005b00| 52 00 52 45 56 4f 4b 45 | 20 50 55 42 4c 49 53 48 |R.REVOKE| PUBLISH|
|00005b10| 20 46 52 4f 4d 20 22 25 | 31 22 00 47 52 41 4e 54 | FROM "%|1".GRANT|
|00005b20| 20 50 55 42 4c 49 53 48 | 20 54 4f 20 22 25 31 22 | PUBLISH| TO "%1"|
|00005b30| 00 00 53 45 4c 45 43 54 | 20 75 73 65 72 5f 6e 61 |..SELECT| user_na|
|00005b40| 6d 65 20 46 52 4f 4d 20 | 53 59 53 2e 53 59 53 55 |me FROM |SYS.SYSU|
|00005b50| 53 45 52 50 45 52 4d 53 | 20 4b 45 59 20 4a 4f 49 |SERPERMS| KEY JOI|
|00005b60| 4e 20 53 59 53 2e 53 59 | 53 52 45 4d 4f 54 45 55 |N SYS.SY|SREMOTEU|
|00005b70| 53 45 52 20 57 48 45 52 | 45 20 63 6f 6e 73 6f 6c |SER WHER|E consol|
|00005b80| 69 64 61 74 65 20 3d 20 | 27 59 27 00 00 53 45 4c |idate = |'Y'..SEL|
|00005b90| 45 43 54 20 75 73 65 72 | 5f 6e 61 6d 65 20 46 52 |ECT user|_name FR|
|00005ba0| 4f 4d 20 53 59 53 2e 53 | 59 53 55 53 45 52 50 45 |OM SYS.S|YSUSERPE|
|00005bb0| 52 4d 53 20 4b 45 59 20 | 4a 4f 49 4e 20 53 59 53 |RMS KEY |JOIN SYS|
|00005bc0| 2e 53 59 53 52 45 4d 4f | 54 45 55 53 45 52 20 57 |.SYSREMO|TEUSER W|
|00005bd0| 48 45 52 45 20 63 6f 6e | 73 6f 6c 69 64 61 74 65 |HERE con|solidate|
|00005be0| 20 3d 20 27 4e 27 00 53 | 45 4c 45 43 54 20 74 79 | = 'N'.S|ELECT ty|
|00005bf0| 70 65 5f 6e 61 6d 65 2c | 20 70 75 62 6c 69 73 68 |pe_name,| publish|
|00005c00| 65 72 5f 61 64 64 72 65 | 73 73 20 46 52 4f 4d 20 |er_addre|ss FROM |
|00005c10| 53 59 53 2e 53 59 53 52 | 45 4d 4f 54 45 54 59 50 |SYS.SYSR|EMOTETYP|
|00005c20| 45 20 57 48 45 52 45 20 | 74 79 70 65 5f 69 64 20 |E WHERE |type_id |
|00005c30| 3d 20 28 53 45 4c 45 43 | 54 20 74 79 70 65 5f 69 |= (SELEC|T type_i|
|00005c40| 64 20 46 52 4f 4d 20 53 | 59 53 2e 53 59 53 52 45 |d FROM S|YS.SYSRE|
|00005c50| 4d 4f 54 45 55 53 45 52 | 20 57 48 45 52 45 20 75 |MOTEUSER| WHERE u|
|00005c60| 73 65 72 5f 69 64 20 3d | 20 28 53 45 4c 45 43 54 |ser_id =| (SELECT|
|00005c70| 20 75 73 65 72 5f 69 64 | 20 46 52 4f 4d 20 53 59 | user_id| FROM SY|
|00005c80| 53 2e 53 59 53 55 53 45 | 52 50 45 52 4d 53 20 57 |S.SYSUSE|RPERMS W|
|00005c90| 48 45 52 45 20 75 73 65 | 72 5f 6e 61 6d 65 20 3d |HERE use|r_name =|
|00005ca0| 20 27 25 31 27 29 29 00 | 00 00 59 00 53 45 4c 45 | '%1')).|..Y.SELE|
|00005cb0| 43 54 20 63 6f 75 6e 74 | 28 2a 29 20 46 52 4f 4d |CT count|(*) FROM|
|00005cc0| 20 53 59 53 2e 53 59 53 | 53 55 42 53 43 52 49 50 | SYS.SYS|SUBSCRIP|
|00005cd0| 54 49 4f 4e 00 53 45 4c | 45 43 54 20 63 6f 75 6e |TION.SEL|ECT coun|
|00005ce0| 74 28 2a 29 20 46 52 4f | 4d 20 53 59 53 2e 53 59 |t(*) FRO|M SYS.SY|
|00005cf0| 53 52 45 4d 4f 54 45 55 | 53 45 52 00 53 45 4c 45 |SREMOTEU|SER.SELE|
|00005d00| 43 54 20 63 6f 75 6e 74 | 28 2a 29 20 46 52 4f 4d |CT count|(*) FROM|
|00005d10| 20 53 59 53 2e 53 59 53 | 53 55 42 53 43 52 49 50 | SYS.SYS|SUBSCRIP|
|00005d20| 54 49 4f 4e 20 57 48 45 | 52 45 20 73 74 61 72 74 |TION WHE|RE start|
|00005d30| 65 64 20 49 53 20 4e 4f | 54 20 4e 55 4c 4c 00 73 |ed IS NO|T NULL.s|
|00005d40| 65 6c 65 63 74 20 43 55 | 52 52 45 4e 54 20 44 41 |elect CU|RRENT DA|
|00005d50| 54 41 42 41 53 45 20 66 | 72 6f 6d 20 53 59 53 2e |TABASE f|rom SYS.|
|00005d60| 44 55 4d 4d 59 00 53 45 | 4c 45 43 54 20 64 65 66 |DUMMY.SE|LECT def|
|00005d70| 61 75 6c 74 5f 63 6f 6c | 6c 61 74 69 6f 6e 20 46 |ault_col|lation F|
|00005d80| 52 4f 4d 20 53 59 53 2e | 53 59 53 49 4e 46 4f 00 |ROM SYS.|SYSINFO.|
|00005d90| 53 45 4c 45 43 54 20 63 | 6f 6e 6e 65 63 74 69 6f |SELECT c|onnectio|
|00005da0| 6e 5f 70 72 6f 70 65 72 | 74 79 28 20 27 4e 75 6d |n_proper|ty( 'Num|
|00005db0| 62 65 72 27 20 29 00 00 | 00 00 00 00 49 44 44 5f |ber' )..|....IDD_|
|00005dc0| 57 49 5a 50 47 5f 42 41 | 43 4b 55 50 32 00 49 6e |WIZPG_BA|CKUP2.In|
|00005dd0| 74 65 67 72 61 74 65 64 | 4c 6f 67 69 6e 43 6f 6e |tegrated|LoginCon|
|00005de0| 66 69 67 00 56 65 72 69 | 66 79 43 6f 6e 6e 65 63 |fig.Veri|fyConnec|
|00005df0| 74 69 6f 6e 00 00 00 56 | 65 72 69 66 79 43 6f 6e |tion...V|erifyCon|
|00005e00| 6e 65 63 74 69 6f 6e 00 | 49 44 44 5f 57 49 5a 50 |nection.|IDD_WIZP|
|00005e10| 47 5f 42 41 43 4b 55 50 | 33 00 49 44 44 5f 57 49 |G_BACKUP|3.IDD_WI|
|00005e20| 5a 50 47 5f 42 41 43 4b | 55 50 34 00 49 44 44 5f |ZPG_BACK|UP4.IDD_|
|00005e30| 57 49 5a 50 47 5f 42 41 | 43 4b 55 50 35 00 55 49 |WIZPG_BA|CKUP5.UI|
|00005e40| 44 3d 25 31 3b 50 57 44 | 3d 25 32 3b 44 42 46 3d |D=%1;PWD|=%2;DBF=|
|00005e50| 25 33 00 55 49 44 3d 25 | 31 3b 50 57 44 3d 25 32 |%3.UID=%|1;PWD=%2|
|00005e60| 3b 44 42 4e 3d 25 33 00 | 55 49 44 3d 25 31 3b 50 |;DBN=%3.|UID=%1;P|
|00005e70| 57 44 3d 25 32 3b 44 42 | 4e 3d 25 33 3b 45 4e 47 |WD=%2;DB|N=%3;ENG|
|00005e80| 3d 25 34 00 44 42 46 3d | 25 31 3b 49 4e 54 45 47 |=%4.DBF=|%1;INTEG|
|00005e90| 52 41 54 45 44 3d 79 65 | 73 00 44 42 4e 3d 25 31 |RATED=ye|s.DBN=%1|
|00005ea0| 3b 49 4e 54 45 47 52 41 | 54 45 44 3d 79 65 73 00 |;INTEGRA|TED=yes.|
|00005eb0| 44 42 4e 3d 25 31 3b 45 | 4e 47 3d 25 32 3b 49 4e |DBN=%1;E|NG=%2;IN|
|00005ec0| 54 45 47 52 41 54 45 44 | 3d 79 65 73 00 44 42 58 |TEGRATED|=yes.DBX|
|00005ed0| 42 61 63 6b 75 70 57 69 | 7a 61 72 64 00 00 00 49 |BackupWi|zard...I|
|00005ee0| 44 44 5f 42 4b 57 49 5a | 5f 53 54 41 54 5f 57 4e |DD_BKWIZ|_STAT_WN|
|00005ef0| 44 00 00 44 42 42 61 63 | 6b 75 70 00 49 44 44 5f |D..DBBac|kup.IDD_|
|00005f00| 42 4b 57 49 5a 5f 52 55 | 4e 4e 49 4e 47 44 42 50 |BKWIZ_RU|NNINGDBP|
|00005f10| 41 47 45 00 49 44 44 5f | 57 49 5a 50 47 5f 42 41 |AGE.IDD_|WIZPG_BA|
|00005f20| 43 4b 55 50 31 00 00 00 | 49 44 44 5f 55 4c 57 49 |CKUP1...|IDD_ULWI|
|00005f30| 5a 5f 50 41 47 45 31 00 | 00 00 00 00 49 44 44 5f |Z_PAGE1.|....IDD_|
|00005f40| 55 4c 57 49 5a 5f 50 41 | 47 45 32 00 49 6e 74 65 |ULWIZ_PA|GE2.Inte|
|00005f50| 67 72 61 74 65 64 4c 6f | 67 69 6e 43 6f 6e 66 69 |gratedLo|ginConfi|
|00005f60| 67 00 56 65 72 69 66 79 | 43 6f 6e 6e 65 63 74 69 |g.Verify|Connecti|
|00005f70| 6f 6e 00 00 00 56 65 72 | 69 66 79 43 6f 6e 6e 65 |on...Ver|ifyConne|
|00005f80| 63 74 69 6f 6e 00 49 44 | 44 5f 55 4c 57 49 5a 5f |ction.ID|D_ULWIZ_|
|00005f90| 50 41 47 45 33 00 2e 73 | 71 6c 00 49 44 44 5f 55 |PAGE3..s|ql.IDD_U|
|00005fa0| 4c 57 49 5a 5f 50 41 47 | 45 34 00 49 44 44 5f 55 |LWIZ_PAG|E4.IDD_U|
|00005fb0| 4c 57 49 5a 5f 50 41 47 | 45 35 00 00 49 44 44 5f |LWIZ_PAG|E5..IDD_|
|00005fc0| 55 4c 57 49 5a 5f 50 41 | 47 45 36 00 64 62 6f 00 |ULWIZ_PA|GE6.dbo.|
|00005fd0| 49 44 44 5f 55 4c 57 49 | 5a 5f 50 41 47 45 37 00 |IDD_ULWI|Z_PAGE7.|
|00005fe0| 00 49 44 44 5f 55 4c 57 | 49 5a 5f 52 55 4e 4e 49 |.IDD_ULW|IZ_RUNNI|
|00005ff0| 4e 47 44 42 50 41 47 45 | 00 44 42 58 55 6e 6c 6f |NGDBPAGE|.DBXUnlo|
|00006000| 61 64 57 69 7a 61 72 64 | 00 20 28 00 29 00 00 2c |adWizard|. (.)..,|
|00006010| 00 00 00 00 00 44 42 46 | 3d 25 73 3b 49 4e 54 45 |.....DBF|=%s;INTE|
|00006020| 47 52 41 54 45 44 3d 79 | 65 73 3b 00 55 49 44 3d |GRATED=y|es;.UID=|
|00006030| 25 73 3b 50 57 44 3d 25 | 73 3b 44 42 46 3d 25 73 |%s;PWD=%|s;DBF=%s|
|00006040| 3b 00 44 42 4e 3d 25 73 | 3b 45 4e 47 3d 25 73 3b |;.DBN=%s|;ENG=%s;|
|00006050| 49 4e 54 45 47 52 41 54 | 45 44 3d 79 65 73 3b 00 |INTEGRAT|ED=yes;.|
|00006060| 55 49 44 3d 25 73 3b 50 | 57 44 3d 25 73 3b 44 42 |UID=%s;P|WD=%s;DB|
|00006070| 4e 3d 25 73 3b 45 4e 47 | 3d 25 73 3b 00 44 42 4e |N=%s;ENG|=%s;.DBN|
|00006080| 3d 25 73 3b 49 4e 54 45 | 47 52 41 54 45 44 3d 79 |=%s;INTE|GRATED=y|
|00006090| 65 73 00 55 49 44 3d 25 | 73 3b 50 57 44 3d 25 73 |es.UID=%|s;PWD=%s|
|000060a0| 3b 44 42 4e 3d 25 73 3b | 00 00 64 62 6f 00 44 42 |;DBN=%s;|..dbo.DB|
|000060b0| 55 6e 6c 6f 61 64 00 00 | 44 42 58 5f 53 63 72 69 |Unload..|DBX_Scri|
|000060c0| 70 74 43 6f 6e 73 6f 6c | 65 00 00 49 44 44 5f 55 |ptConsol|e..IDD_U|
|000060d0| 4c 57 49 5a 5f 54 41 42 | 4c 45 50 41 47 45 00 00 |LWIZ_TAB|LEPAGE..|
|000060e0| 00 44 42 56 61 6c 69 64 | 61 74 65 00 49 44 44 5f |.DBValid|ate.IDD_|
|000060f0| 56 41 4c 49 44 5f 53 54 | 41 54 5f 44 49 41 4c 4f |VALID_ST|AT_DIALO|
|00006100| 47 00 49 44 44 5f 56 41 | 4c 57 49 5a 5f 50 41 47 |G.IDD_VA|LWIZ_PAG|
|00006110| 45 31 00 49 44 44 5f 56 | 41 4c 57 49 5a 5f 50 41 |E1.IDD_V|ALWIZ_PA|
|00006120| 47 45 32 00 49 6e 74 65 | 67 72 61 74 65 64 4c 6f |GE2.Inte|gratedLo|
|00006130| 67 69 6e 43 6f 6e 66 69 | 67 00 00 00 49 44 44 5f |ginConfi|g...IDD_|
|00006140| 56 41 4c 57 49 5a 5f 50 | 41 47 45 33 00 44 42 46 |VALWIZ_P|AGE3.DBF|
|00006150| 3d 25 73 3b 49 4e 54 45 | 47 52 41 54 45 44 3d 79 |=%s;INTE|GRATED=y|
|00006160| 65 73 00 55 49 44 3d 25 | 73 3b 50 57 44 3d 25 73 |es.UID=%|s;PWD=%s|
|00006170| 3b 44 42 46 3d 25 73 3b | 00 00 00 00 00 49 44 44 |;DBF=%s;|.....IDD|
|00006180| 5f 45 58 57 49 5a 5f 50 | 41 47 45 32 00 49 6e 74 |_EXWIZ_P|AGE2.Int|
|00006190| 65 67 72 61 74 65 64 4c | 6f 67 69 6e 43 6f 6e 66 |egratedL|oginConf|
|000061a0| 69 67 00 00 00 44 42 46 | 3d 25 73 3b 49 4e 54 45 |ig...DBF|=%s;INTE|
|000061b0| 47 52 41 54 45 44 3d 59 | 45 53 00 55 49 44 3d 25 |GRATED=Y|ES.UID=%|
|000061c0| 73 3b 50 57 44 3d 25 73 | 3b 44 42 46 3d 25 73 3b |s;PWD=%s|;DBF=%s;|
|000061d0| 00 49 44 44 5f 45 58 57 | 49 5a 5f 50 41 47 45 33 |.IDD_EXW|IZ_PAGE3|
|000061e0| 00 59 00 00 53 79 62 61 | 73 65 20 43 65 6e 74 72 |.Y..Syba|se Centr|
|000061f0| 61 6c 00 4e 6f 74 20 59 | 65 74 20 49 6d 70 6c 65 |al.Not Y|et Imple|
|00006200| 6d 65 6e 74 65 64 00 49 | 44 44 5f 45 58 57 49 5a |mented.I|DD_EXWIZ|
|00006210| 5f 50 41 47 45 34 00 2e | 64 62 00 2e 6c 6f 67 00 |_PAGE4..|db..log.|
|00006220| 49 44 44 5f 45 58 57 49 | 5a 5f 50 41 47 45 35 00 |IDD_EXWI|Z_PAGE5.|
|00006230| 49 44 44 5f 45 58 57 49 | 5a 5f 50 41 47 45 36 00 |IDD_EXWI|Z_PAGE6.|
|00006240| 64 62 6f 00 49 44 44 5f | 45 58 57 49 5a 5f 50 41 |dbo.IDD_|EXWIZ_PA|
|00006250| 47 45 37 00 2e 73 71 6c | 00 49 44 44 5f 45 58 57 |GE7..sql|.IDD_EXW|
|00006260| 49 5a 5f 50 41 47 45 38 | 00 49 44 44 5f 45 58 57 |IZ_PAGE8|.IDD_EXW|
|00006270| 49 5a 5f 50 41 47 45 39 | 00 00 49 44 44 5f 45 58 |IZ_PAGE9|..IDD_EX|
|00006280| 57 49 5a 5f 50 41 47 45 | 31 30 00 44 42 58 45 78 |WIZ_PAGE|10.DBXEx|
|00006290| 74 72 61 63 74 57 69 7a | 61 72 64 00 00 44 42 58 |tractWiz|ard..DBX|
|000062a0| 5f 53 63 72 69 70 74 43 | 6f 6e 73 6f 6c 65 00 00 |_ScriptC|onsole..|
|000062b0| 00 00 64 62 6f 00 00 44 | 42 43 72 65 61 74 65 00 |..dbo..D|BCreate.|
|000062c0| 00 00 44 42 4e 3d 25 73 | 3b 45 4e 47 3d 25 73 3b |..DBN=%s|;ENG=%s;|
|000062d0| 49 4e 54 45 47 52 41 54 | 45 44 3d 79 65 73 3b 00 |INTEGRAT|ED=yes;.|
|000062e0| 55 49 44 3d 25 73 3b 50 | 57 44 3d 25 73 3b 44 42 |UID=%s;P|WD=%s;DB|
|000062f0| 4e 3d 25 73 3b 45 4e 47 | 3d 25 73 3b 00 55 49 44 |N=%s;ENG|=%s;.UID|
|00006300| 3d 25 73 3b 50 57 44 3d | 25 73 3b 44 42 4e 3d 25 |=%s;PWD=|%s;DBN=%|
|00006310| 73 3b 45 4e 47 3d 25 73 | 3b 00 44 42 46 3d 25 73 |s;ENG=%s|;.DBF=%s|
|00006320| 3b 49 4e 54 45 47 52 41 | 54 45 44 3d 79 65 73 3b |;INTEGRA|TED=yes;|
|00006330| 00 55 49 44 3d 25 73 3b | 50 57 44 3d 25 73 3b 44 |.UID=%s;|PWD=%s;D|
|00006340| 42 46 3d 25 73 3b 00 55 | 49 44 3d 25 73 3b 50 57 |BF=%s;.U|ID=%s;PW|
|00006350| 44 3d 25 73 3b 44 42 46 | 3d 25 73 3b 00 00 44 42 |D=%s;DBF|=%s;..DB|
|00006360| 55 6e 6c 6f 61 64 00 55 | 49 44 3d 44 42 41 3b 50 |Unload.U|ID=DBA;P|
|00006370| 57 44 3d 53 51 4c 3b 44 | 42 46 3d 25 31 3b 00 25 |WD=SQL;D|BF=%1;.%|
|00006380| 33 20 2d 63 20 22 25 31 | 22 20 72 65 61 64 20 25 |3 -c "%1|" read %|
|00006390| 32 00 49 44 44 5f 45 58 | 57 49 5a 5f 50 41 47 45 |2.IDD_EX|WIZ_PAGE|
|000063a0| 31 00 49 44 44 5f 45 58 | 57 49 5a 5f 52 55 4e 4e |1.IDD_EX|WIZ_RUNN|
|000063b0| 49 4e 47 44 42 50 41 47 | 45 00 00 00 59 65 73 00 |INGDBPAG|E...Yes.|
|000063c0| 4e 6f 00 00 64 62 5f 70 | 61 72 73 65 5f 73 74 72 |No..db_p|arse_str|
|000063d0| 69 6e 67 00 64 62 5f 66 | 72 65 65 5f 70 61 72 73 |ing.db_f|ree_pars|
|000063e0| 65 00 00 3b 00 5f 5f 64 | 62 78 25 6c 75 25 6c 75 |e..;.__d|bx%lu%lu|
|000063f0| 00 55 49 44 3d 25 31 00 | 50 57 44 3d 25 31 00 44 |.UID=%1.|PWD=%1.D|
+--------+-------------------------+-------------------------+--------+--------+