home *** CD-ROM | disk | FTP | other *** search
/ Internet File Formats / InternetFileFormatsCD.bin / text / latex / mac / alpha.6.0.sit / Tcl / SystemCode / sql.tcl < prev    next >
MacBinary  |  1995-06-11  |  5.6 KB  |  [TEXT/ALFA]

open in: MacOS 8.1     |     Win98     |     DOS

browse contents    |     view JSON data     |     view as text


This file was processed as: MacBinary (archive/macBinary).

ConfidenceProgramDetectionMatch TypeSupport
10% dexvert MacBinary (archive/macBinary) fallback Supported
1% dexvert Text File (text/txt) fallback Supported
100% file MacBinary II, inited, Sun Jun 11 23:26:55 1995, modified Sun Jun 11 23:26:55 1995, creator Alpha editor, type ASCII, 5112 bytes "sql.tcl" , at 0x1478 442 bytes resource default (weak)
99% file data default
74% TrID Macintosh plain text (MacBinary) default
25% TrID MacBinary 2 default (weak)
100% siegfried fmt/1762 MacBinary (II) default
100% lsar MacBinary default


id metadata
keyvalue
macFileType[TEXT]
macFileCreator[ALFA]



hex view
+--------+-------------------------+-------------------------+--------+--------+
|00000000| 00 07 73 71 6c 2e 74 63 | 6c 00 00 00 00 00 00 00 |..sql.tc|l.......|
|00000010| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000020| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000030| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000040| 00 54 45 58 54 41 4c 46 | 41 01 00 00 00 00 00 00 |.TEXTALF|A.......|
|00000050| 00 00 00 00 00 13 f8 00 | 00 01 ba ac 01 64 7f ac |........|.....d..|
|00000060| 01 64 7f 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |.d......|........|
|00000070| 00 00 00 00 00 00 00 00 | 00 00 81 81 d4 07 00 00 |........|........|
|00000080| 0d 23 23 23 23 23 23 23 | 23 23 23 23 23 23 23 23 |.#######|########|
|00000090| 23 23 23 23 23 23 23 23 | 23 23 23 23 23 23 23 23 |########|########|
|000000a0| 23 23 23 23 23 23 23 23 | 23 23 23 23 23 23 23 23 |########|########|
|000000b0| 23 23 23 23 23 23 23 23 | 23 23 23 23 23 23 23 23 |########|########|
|000000c0| 23 23 23 23 23 23 23 23 | 23 23 23 23 23 23 0d 23 |########|######.#|
|000000d0| 20 20 20 46 49 4c 45 3a | 20 73 71 6c 2e 74 63 6c | FILE:| sql.tcl|
|000000e0| 0d 23 2d 2d 2d 2d 2d 2d | 2d 2d 2d 2d 2d 2d 2d 2d |.#------|--------|
|000000f0| 2d 2d 2d 2d 2d 2d 2d 2d | 2d 2d 2d 2d 2d 2d 2d 2d |--------|--------|
|00000100| 2d 2d 2d 2d 2d 2d 2d 2d | 2d 2d 2d 2d 2d 2d 2d 2d |--------|--------|
|00000110| 2d 2d 2d 2d 2d 2d 2d 2d | 2d 2d 2d 2d 2d 2d 2d 2d |--------|--------|
|00000120| 2d 2d 2d 2d 2d 2d 2d 2d | 2d 2d 2d 2d 2d 2d 0d 23 |--------|------.#|
|00000130| 20 41 55 54 48 4f 52 3a | 20 20 20 20 20 4a 6f 65 | AUTHOR:| Joe|
|00000140| 6c 20 44 2e 20 45 6c 6b | 69 6e 73 0d 23 20 20 20 |l D. Elk|ins.# |
|00000150| 20 20 6f 66 20 20 20 20 | 20 20 4e 65 77 20 4d 65 | of | New Me|
|00000160| 64 69 61 2c 20 49 6e 63 | 2e 0d 23 20 20 20 20 20 |dia, Inc|..# |
|00000170| 20 20 20 20 20 20 20 20 | 32 30 30 20 53 6f 75 74 | |200 Sout|
|00000180| 68 20 4d 65 72 69 64 69 | 61 6e 2c 20 53 74 65 2e |h Meridi|an, Ste.|
|00000190| 20 32 32 30 0d 23 20 20 | 20 20 20 20 20 20 20 20 | 220.# | |
|000001a0| 20 20 20 49 6e 64 69 61 | 6e 61 70 6f 6c 69 73 2c | India|napolis,|
|000001b0| 20 49 4e 20 34 36 32 32 | 35 0d 23 0d 23 20 69 6e | IN 4622|5.#.# in|
|000001c0| 74 65 72 6e 65 74 3a 20 | 20 20 6a 64 65 6c 6b 69 |ternet: | jdelki|
|000001d0| 6e 73 40 69 71 75 65 73 | 74 2e 6e 65 74 20 20 28 |ns@iques|t.net (|
|000001e0| 70 72 65 66 65 72 72 65 | 64 29 0d 23 20 63 6f 6d |preferre|d).# com|
|000001f0| 70 75 73 65 72 76 65 3a | 20 37 32 35 33 31 2c 33 |puserve:| 72531,3|
|00000200| 31 34 0d 23 20 41 4f 4c | 3a 20 20 20 20 20 20 20 |14.# AOL|: |
|00000210| 20 6a 64 65 6c 6b 69 6e | 73 0d 23 0d 23 20 20 20 | jdelkin|s.#.# |
|00000220| 43 6f 70 79 72 69 67 68 | 74 20 a9 20 31 39 39 34 |Copyrigh|t . 1994|
|00000230| 2d 31 39 39 35 20 62 79 | 20 4a 6f 65 6c 20 44 2e |-1995 by| Joel D.|
|00000240| 20 45 6c 6b 69 6e 73 0d | 23 20 20 20 41 6c 6c 20 | Elkins.|# All |
|00000250| 72 69 67 68 74 73 20 72 | 65 73 65 72 76 65 64 2e |rights r|eserved.|
|00000260| 0d 23 23 23 23 23 23 23 | 23 23 23 23 23 23 23 23 |.#######|########|
|00000270| 23 23 23 23 23 23 23 23 | 23 23 23 23 23 23 23 23 |########|########|
|00000280| 23 23 23 23 23 23 23 23 | 23 23 23 23 23 23 23 23 |########|########|
|00000290| 23 23 23 23 23 23 23 23 | 23 23 23 23 23 23 23 23 |########|########|
|000002a0| 23 23 23 23 23 23 23 23 | 23 23 23 23 23 23 0d 23 |########|######.#|
|000002b0| 0d 23 20 20 41 6c 70 68 | 61 20 6d 6f 64 65 20 66 |.# Alph|a mode f|
|000002c0| 6f 72 20 53 51 4c 20 61 | 6e 64 20 4f 72 61 63 6c |or SQL a|nd Oracl|
|000002d0| 65 27 73 20 50 4c 2f 53 | 51 4c 20 70 72 6f 67 72 |e's PL/S|QL progr|
|000002e0| 61 6d 6d 69 6e 67 20 6c | 61 6e 67 75 61 67 65 0d |amming l|anguage.|
|000002f0| 23 20 20 43 6f 6e 76 65 | 72 74 73 20 53 51 4c 20 |# Conve|rts SQL |
|00000300| 61 6e 64 20 50 4c 2f 53 | 51 4c 20 6b 65 79 77 6f |and PL/S|QL keywo|
|00000310| 72 64 73 20 74 6f 20 75 | 70 70 65 72 63 61 73 65 |rds to u|ppercase|
|00000320| 20 6f 6e 20 74 68 65 20 | 66 6c 79 20 61 6e 64 20 | on the |fly and |
|00000330| 63 6f 6c 6f 72 69 7a 65 | 73 0d 23 0d 23 23 23 23 |colorize|s.#.####|
|00000340| 23 23 23 23 23 23 23 23 | 23 23 23 23 23 23 23 23 |########|########|
|00000350| 23 23 23 23 23 23 23 23 | 23 23 23 23 23 23 23 23 |########|########|
|00000360| 23 23 23 23 23 23 23 23 | 23 23 23 23 23 23 23 23 |########|########|
|00000370| 23 23 23 23 23 23 23 23 | 23 23 23 23 23 23 23 23 |########|########|
|00000380| 23 23 23 23 23 23 23 23 | 23 0d 23 20 48 49 53 54 |########|#.# HIST|
|00000390| 4f 52 59 0d 23 20 20 20 | 20 20 20 20 20 20 20 20 |ORY.# | |
|000003a0| 20 20 20 20 20 20 20 0d | 23 20 6d 6f 64 69 66 69 | .|# modifi|
|000003b0| 65 64 20 77 68 6f 20 72 | 65 76 20 72 65 61 73 6f |ed who r|ev reaso|
|000003c0| 6e 0d 23 20 2d 2d 2d 2d | 2d 2d 2d 2d 20 2d 2d 2d |n.# ----|---- ---|
|000003d0| 20 2d 2d 2d 20 2d 2d 2d | 2d 2d 2d 20 0d 23 20 37 | --- ---|--- .# 7|
|000003e0| 2f 32 39 2f 39 34 20 20 | 4a 44 45 20 31 2e 30 20 |/29/94 |JDE 1.0 |
|000003f0| 4f 72 69 67 69 6e 61 6c | 20 0d 23 20 32 2f 38 2f |Original| .# 2/8/|
|00000400| 39 35 20 20 20 4a 44 45 | 20 31 2e 31 20 41 64 64 |95 JDE| 1.1 Add|
|00000410| 65 64 20 65 6c 65 63 74 | 55 70 70 65 72 20 66 6f |ed elect|Upper fo|
|00000420| 72 20 74 61 62 2c 20 63 | 72 2c 20 61 6e 64 20 27 |r tab, c|r, and '|
|00000430| 3b 27 0d 23 23 23 23 23 | 23 23 23 23 23 23 23 23 |;'.#####|########|
|00000440| 23 23 23 23 23 23 23 23 | 23 23 23 23 23 23 23 23 |########|########|
|00000450| 23 23 23 23 23 23 23 23 | 23 23 23 23 23 23 23 23 |########|########|
|00000460| 23 23 23 23 23 23 23 23 | 23 23 23 23 23 23 23 23 |########|########|
|00000470| 23 23 23 23 23 23 23 23 | 23 23 23 23 23 23 23 23 |########|########|
|00000480| 0d 0d 70 72 6f 63 20 64 | 75 6d 6d 79 53 51 4c 20 |..proc d|ummySQL |
|00000490| 7b 7d 20 7b 7d 0d 0d 23 | 23 23 23 23 23 23 23 23 |{} {}..#|########|
|000004a0| 23 23 23 23 23 23 23 23 | 23 23 23 23 23 23 23 23 |########|########|
|000004b0| 23 23 23 23 23 23 23 23 | 23 23 23 23 23 23 23 23 |########|########|
|000004c0| 23 23 23 23 23 23 23 23 | 23 23 23 23 23 23 23 23 |########|########|
|000004d0| 23 23 23 23 23 23 23 23 | 23 23 23 23 23 23 23 23 |########|########|
|000004e0| 23 23 23 23 0d 23 20 50 | 4c 2f 53 51 4c 20 6d 6f |####.# P|L/SQL mo|
|000004f0| 64 65 20 62 79 20 4a 6f | 65 6c 20 44 2e 20 45 6c |de by Jo|el D. El|
|00000500| 6b 69 6e 73 0d 23 23 23 | 23 23 23 23 23 23 23 23 |kins.###|########|
|00000510| 23 23 23 23 23 23 23 23 | 23 23 23 23 23 23 23 23 |########|########|
|00000520| 23 23 23 23 23 23 23 23 | 23 23 23 23 23 23 23 23 |########|########|
|00000530| 23 23 23 23 23 23 23 23 | 23 23 23 23 23 23 23 23 |########|########|
|00000540| 23 23 23 23 23 23 23 23 | 23 23 23 23 23 23 23 23 |########|########|
|00000550| 23 23 0d 6c 61 70 70 65 | 6e 64 20 6d 6f 64 65 73 |##.lappe|nd modes|
|00000560| 20 53 51 4c 0d 73 65 74 | 20 6d 6f 64 65 4d 65 6e | SQL.set| modeMen|
|00000570| 75 73 28 53 51 4c 29 09 | 09 09 09 09 09 7b 20 7d |us(SQL).|.....{ }|
|00000580| 0d 73 65 74 20 64 75 6d | 6d 79 50 72 6f 63 28 53 |.set dum|myProc(S|
|00000590| 51 4c 29 09 09 09 09 09 | 09 64 75 6d 6d 79 53 51 |QL).....|.dummySQ|
|000005a0| 4c 0d 6c 61 70 70 65 6e | 64 20 6d 6f 64 65 53 75 |L.lappen|d modeSu|
|000005b0| 66 66 69 78 65 73 09 09 | 09 09 09 7b 2a 2e 73 71 |ffixes..|...{*.sq|
|000005c0| 6c 7d 20 7b 20 73 65 74 | 20 77 69 6e 4d 6f 64 65 |l} { set| winMode|
|000005d0| 20 53 51 4c 20 7d 0d 6c | 61 70 70 65 6e 64 20 6d | SQL }.l|append m|
|000005e0| 6f 64 65 53 75 66 66 69 | 78 65 73 09 09 09 09 09 |odeSuffi|xes.....|
|000005f0| 7b 2a 2e 53 51 4c 7d 20 | 7b 20 73 65 74 20 77 69 |{*.SQL} |{ set wi|
|00000600| 6e 4d 6f 64 65 20 53 51 | 4c 20 7d 0d 6c 61 70 70 |nMode SQ|L }.lapp|
|00000610| 65 6e 64 20 6d 6f 64 65 | 53 75 66 66 69 78 65 73 |end mode|Suffixes|
|00000620| 09 09 09 09 09 7b 2a 2e | 70 6b 67 7d 09 7b 20 73 |.....{*.|pkg}.{ s|
|00000630| 65 74 20 77 69 6e 4d 6f | 64 65 20 53 51 4c 20 7d |et winMo|de SQL }|
|00000640| 0d 6e 65 77 4d 6f 64 65 | 56 61 72 09 53 51 4c 20 |.newMode|Var.SQL |
|00000650| 09 65 6c 65 63 52 42 72 | 61 63 65 09 09 09 7b 30 |.elecRBr|ace...{0|
|00000660| 7d 09 31 0d 6e 65 77 4d | 6f 64 65 56 61 72 09 53 |}.1.newM|odeVar.S|
|00000670| 51 4c 20 09 65 6c 65 63 | 74 72 69 63 53 65 6d 69 |QL .elec|tricSemi|
|00000680| 09 09 7b 31 7d 09 31 0d | 6e 65 77 4d 6f 64 65 56 |..{1}.1.|newModeV|
|00000690| 61 72 09 53 51 4c 09 09 | 77 6f 72 64 42 72 65 61 |ar.SQL..|wordBrea|
|000006a0| 6b 09 09 09 7b 28 5c 24 | 29 3f 5b 61 2d 7a 41 2d |k...{(\$|)?[a-zA-|
|000006b0| 5a 30 2d 39 5f 5d 2b 7d | 20 30 0d 6e 65 77 4d 6f |Z0-9_]+}| 0.newMo|
|000006c0| 64 65 56 61 72 09 53 51 | 4c 09 09 70 72 65 66 69 |deVar.SQ|L..prefi|
|000006d0| 78 53 74 72 69 6e 67 09 | 09 7b 2d 2d 7d 20 30 0d |xString.|.{--} 0.|
|000006e0| 6e 65 77 4d 6f 64 65 56 | 61 72 09 53 51 4c 09 09 |newModeV|ar.SQL..|
|000006f0| 65 6c 65 63 4c 42 72 61 | 63 65 09 09 09 7b 30 7d |elecLBra|ce...{0}|
|00000700| 20 31 0d 6e 65 77 4d 6f | 64 65 56 61 72 09 53 51 | 1.newMo|deVar.SQ|
|00000710| 4c 09 09 77 6f 72 64 57 | 72 61 70 09 09 09 7b 30 |L..wordW|rap...{0|
|00000720| 7d 20 31 0d 6e 65 77 4d | 6f 64 65 56 61 72 09 53 |} 1.newM|odeVar.S|
|00000730| 51 4c 09 09 66 75 6e 63 | 45 78 70 72 09 09 09 7b |QL..func|Expr...{|
|00000740| 28 50 52 4f 43 45 44 55 | 52 45 7c 46 55 4e 43 54 |(PROCEDU|RE|FUNCT|
|00000750| 49 4f 4e 29 5b 20 5c 74 | 5d 2b 28 5b 61 2d 7a 41 |ION)[ \t|]+([a-zA|
|00000760| 2d 5a 30 2d 39 5f 5d 2b | 29 7d 20 30 0d 6e 65 77 |-Z0-9_]+|)} 0.new|
|00000770| 4d 6f 64 65 56 61 72 09 | 53 51 4c 09 09 77 6f 72 |ModeVar.|SQL..wor|
|00000780| 64 42 72 65 61 6b 50 72 | 65 66 61 63 65 09 7b 5b |dBreakPr|eface.{[|
|00000790| 5e 61 2d 7a 41 2d 5a 30 | 2d 39 5f 5c 24 5d 7d 20 |^a-zA-Z0|-9_\$]} |
|000007a0| 30 0d 6e 65 77 4d 6f 64 | 65 56 61 72 09 53 51 4c |0.newMod|eVar.SQL|
|000007b0| 09 09 6f 70 74 69 6f 6e | 49 73 4d 65 74 61 09 09 |..option|IsMeta..|
|000007c0| 7b 30 7d 20 31 0d 0d 73 | 65 74 20 73 71 6c 4b 65 |{0} 1..s|et sqlKe|
|000007d0| 79 77 6f 72 64 73 20 7b | 0d 09 41 42 4f 52 54 20 |ywords {|..ABORT |
|000007e0| 41 43 43 45 50 54 20 41 | 43 43 45 53 53 20 41 4c |ACCEPT A|CCESS AL|
|000007f0| 54 45 52 20 41 4e 44 20 | 41 52 52 41 59 20 41 52 |TER AND |ARRAY AR|
|00000800| 52 41 59 4c 45 4e 20 41 | 53 20 41 53 53 45 52 54 |RAYLEN A|S ASSERT|
|00000810| 20 41 54 20 41 56 47 20 | 42 45 47 49 4e 20 42 45 | AT AVG |BEGIN BE|
|00000820| 54 57 45 45 4e 20 42 4f | 44 59 0d 09 43 41 53 45 |TWEEN BO|DY..CASE|
|00000830| 20 43 4f 4c 55 4d 4e 53 | 20 43 4f 4d 4d 49 54 20 | COLUMNS| COMMIT |
|00000840| 43 4f 4e 53 54 41 4e 54 | 20 43 4f 55 4e 54 20 43 |CONSTANT| COUNT C|
|00000850| 52 45 41 54 45 20 43 55 | 52 53 4f 52 20 44 45 43 |REATE CU|RSOR DEC|
|00000860| 4c 41 52 45 20 44 45 46 | 41 55 4c 54 20 44 45 46 |LARE DEF|AULT DEF|
|00000870| 49 4e 49 54 49 4f 4e 0d | 09 44 45 4c 45 54 45 20 |INITION.|.DELETE |
|00000880| 44 45 53 43 20 44 49 53 | 50 4f 53 45 20 44 49 53 |DESC DIS|POSE DIS|
|00000890| 54 49 4e 43 54 20 44 4f | 20 44 52 4f 50 20 45 4c |TINCT DO| DROP EL|
|000008a0| 53 45 20 45 4c 53 49 46 | 20 45 4e 44 20 45 4e 54 |SE ELSIF| END ENT|
|000008b0| 52 59 20 45 58 43 45 50 | 54 49 4f 4e 20 45 58 49 |RY EXCEP|TION EXI|
|000008c0| 53 54 53 20 45 58 49 54 | 0d 09 46 41 4c 53 45 20 |STS EXIT|..FALSE |
|000008d0| 46 45 54 43 48 20 46 4f | 52 20 46 52 4f 4d 20 46 |FETCH FO|R FROM F|
|000008e0| 55 4e 43 54 49 4f 4e 20 | 47 4f 54 4f 20 49 46 20 |UNCTION |GOTO IF |
|000008f0| 49 4e 20 49 4e 53 45 52 | 54 20 49 4e 54 45 52 53 |IN INSER|T INTERS|
|00000900| 45 43 54 20 49 4e 54 4f | 20 49 53 20 4c 49 4b 45 |ECT INTO| IS LIKE|
|00000910| 20 4c 4f 4f 50 20 4d 41 | 58 20 4d 49 4e 0d 09 4d | LOOP MA|X MIN..M|
|00000920| 49 4e 55 53 20 4d 4f 44 | 20 4e 45 57 20 4f 46 20 |INUS MOD| NEW OF |
|00000930| 4f 4e 20 4f 50 45 4e 20 | 4f 52 20 4f 55 54 20 50 |ON OPEN |OR OUT P|
|00000940| 41 43 4b 41 47 45 20 50 | 41 52 54 49 54 49 4f 4e |ACKAGE P|ARTITION|
|00000950| 20 50 4f 53 49 54 49 56 | 45 20 50 52 41 47 4d 41 | POSITIV|E PRAGMA|
|00000960| 20 50 52 49 56 41 54 45 | 0d 09 50 52 4f 43 45 44 | PRIVATE|..PROCED|
|00000970| 55 52 45 20 50 55 42 4c | 49 43 20 52 41 4e 47 45 |URE PUBL|IC RANGE|
|00000980| 20 52 45 43 4f 52 44 20 | 52 45 4d 20 52 45 50 4c | RECORD |REM REPL|
|00000990| 41 43 45 20 52 45 54 55 | 52 4e 20 52 4f 4c 4c 42 |ACE RETU|RN ROLLB|
|000009a0| 41 43 4b 20 52 4f 57 54 | 59 50 45 20 52 55 4e 20 |ACK ROWT|YPE RUN |
|000009b0| 53 41 56 45 50 4f 49 4e | 54 0d 09 53 45 4c 45 43 |SAVEPOIN|T..SELEC|
|000009c0| 54 20 53 45 54 20 53 49 | 5a 45 20 53 54 41 52 54 |T SET SI|ZE START|
|000009d0| 20 53 54 44 44 45 56 20 | 53 55 4d 20 54 48 45 4e | STDDEV |SUM THEN|
|000009e0| 20 54 4f 20 54 59 50 45 | 20 55 4e 49 4f 4e 20 55 | TO TYPE| UNION U|
|000009f0| 4e 49 51 55 45 20 55 50 | 44 41 54 45 20 55 53 45 |NIQUE UP|DATE USE|
|00000a00| 20 56 41 4c 55 45 53 0d | 09 56 41 52 49 41 4e 43 | VALUES.|.VARIANC|
|00000a10| 45 20 57 48 45 4e 20 57 | 48 45 52 45 20 57 48 49 |E WHEN W|HERE WHI|
|00000a20| 4c 45 20 57 49 54 48 20 | 58 4f 52 0d 7d 0d 23 23 |LE WITH |XOR.}.##|
|00000a30| 23 09 4a 75 73 74 20 63 | 6f 6c 6f 72 69 7a 65 20 |#.Just c|olorize |
|00000a40| 75 70 70 65 72 63 61 73 | 65 20 6b 65 79 77 6f 72 |uppercas|e keywor|
|00000a50| 64 73 0d 23 09 61 62 6f | 72 74 20 61 63 63 65 70 |ds.#.abo|rt accep|
|00000a60| 74 20 61 63 63 65 73 73 | 20 61 6c 74 65 72 20 61 |t access| alter a|
|00000a70| 6e 64 20 61 72 72 61 79 | 20 61 72 72 61 79 6c 65 |nd array| arrayle|
|00000a80| 6e 20 61 73 20 61 73 73 | 65 72 74 20 61 74 20 61 |n as ass|ert at a|
|00000a90| 76 67 20 62 65 67 69 6e | 20 62 65 74 77 65 65 6e |vg begin| between|
|00000aa0| 20 62 6f 64 79 0d 23 09 | 63 61 73 65 20 63 6f 6c | body.#.|case col|
|00000ab0| 75 6d 6e 73 20 63 6f 6d | 6d 69 74 20 63 6f 6e 73 |umns com|mit cons|
|00000ac0| 74 61 6e 74 20 63 6f 75 | 6e 74 20 63 72 65 61 74 |tant cou|nt creat|
|00000ad0| 65 20 63 75 72 73 6f 72 | 20 64 65 63 6c 61 72 65 |e cursor| declare|
|00000ae0| 20 64 65 66 61 75 6c 74 | 20 64 65 66 69 6e 69 74 | default| definit|
|00000af0| 69 6f 6e 0d 23 09 64 65 | 6c 65 74 65 20 64 65 73 |ion.#.de|lete des|
|00000b00| 63 20 64 69 73 70 6f 73 | 65 20 64 69 73 74 69 6e |c dispos|e distin|
|00000b10| 63 74 20 64 6f 20 64 72 | 6f 70 20 65 6c 73 65 20 |ct do dr|op else |
|00000b20| 65 6c 73 69 66 20 65 6e | 64 20 65 6e 74 72 79 20 |elsif en|d entry |
|00000b30| 65 78 63 65 70 74 69 6f | 6e 20 65 78 69 73 74 73 |exceptio|n exists|
|00000b40| 20 65 78 69 74 0d 23 09 | 66 61 6c 73 65 20 66 65 | exit.#.|false fe|
|00000b50| 74 63 68 20 66 6f 72 20 | 66 72 6f 6d 20 66 75 6e |tch for |from fun|
|00000b60| 63 74 69 6f 6e 20 67 6f | 74 6f 20 69 66 20 69 6e |ction go|to if in|
|00000b70| 20 69 6e 73 65 72 74 20 | 69 6e 74 65 72 73 65 63 | insert |intersec|
|00000b80| 74 20 69 6e 74 6f 20 69 | 73 20 6c 69 6b 65 20 6c |t into i|s like l|
|00000b90| 6f 6f 70 20 6d 61 78 20 | 6d 69 6e 0d 23 09 6d 69 |oop max |min.#.mi|
|00000ba0| 6e 75 73 20 6d 6f 64 20 | 6e 65 77 20 6f 66 20 6f |nus mod |new of o|
|00000bb0| 6e 20 6f 70 65 6e 20 6f | 72 20 6f 75 74 20 70 61 |n open o|r out pa|
|00000bc0| 63 6b 61 67 65 20 70 61 | 72 74 69 74 69 6f 6e 20 |ckage pa|rtition |
|00000bd0| 70 6f 73 69 74 69 76 65 | 20 70 72 61 67 6d 61 20 |positive| pragma |
|00000be0| 70 72 69 76 61 74 65 0d | 23 09 70 72 6f 63 65 64 |private.|#.proced|
|00000bf0| 75 72 65 20 70 75 62 6c | 69 63 20 72 61 6e 67 65 |ure publ|ic range|
|00000c00| 20 72 65 63 6f 72 64 20 | 72 65 6d 20 72 65 70 6c | record |rem repl|
|00000c10| 61 63 65 20 72 65 74 75 | 72 6e 20 72 6f 6c 6c 62 |ace retu|rn rollb|
|00000c20| 61 63 6b 20 72 6f 77 74 | 79 70 65 20 72 75 6e 20 |ack rowt|ype run |
|00000c30| 73 61 76 65 70 6f 69 6e | 74 0d 23 09 73 65 6c 65 |savepoin|t.#.sele|
|00000c40| 63 74 20 73 65 74 20 73 | 69 7a 65 20 73 74 61 72 |ct set s|ize star|
|00000c50| 74 20 73 74 64 64 65 76 | 20 73 75 6d 20 74 68 65 |t stddev| sum the|
|00000c60| 6e 20 74 6f 20 74 79 70 | 65 20 75 6e 69 6f 6e 20 |n to typ|e union |
|00000c70| 75 6e 69 71 75 65 20 75 | 70 64 61 74 65 20 75 73 |unique u|pdate us|
|00000c80| 65 20 76 61 6c 75 65 73 | 0d 23 09 76 61 72 69 61 |e values|.#.varia|
|00000c90| 6e 63 65 20 77 68 65 6e | 20 77 68 65 72 65 20 77 |nce when| where w|
|00000ca0| 68 69 6c 65 20 77 69 74 | 68 20 78 6f 72 0d 23 23 |hile wit|h xor.##|
|00000cb0| 23 0d 72 65 67 4d 6f 64 | 65 4b 65 79 77 6f 72 64 |#.regMod|eKeyword|
|00000cc0| 73 20 2d 65 20 7b 2d 2d | 7d 20 2d 62 20 7b 2f 2a |s -e {--|} -b {/*|
|00000cd0| 7d 20 7b 2a 2f 7d 20 2d | 63 20 72 65 64 20 2d 6b |} {*/} -|c red -k|
|00000ce0| 20 62 6c 75 65 20 53 51 | 4c 20 24 73 71 6c 4b 65 | blue SQ|L $sqlKe|
|00000cf0| 79 77 6f 72 64 73 0d 75 | 6e 73 65 74 20 73 71 6c |ywords.u|nset sql|
|00000d00| 4b 65 79 77 6f 72 64 73 | 0d 23 3d 3d 3d 3d 3d 3d |Keywords|.#======|
|00000d10| 3d 3d 3d 3d 3d 3d 3d 3d | 3d 3d 3d 3d 3d 3d 3d 3d |========|========|
|00000d20| 3d 3d 3d 3d 3d 3d 3d 3d | 3d 3d 3d 3d 3d 3d 3d 3d |========|========|
|00000d30| 3d 3d 3d 3d 3d 3d 3d 3d | 3d 3d 3d 3d 3d 3d 3d 3d |========|========|
|00000d40| 3d 3d 3d 3d 3d 3d 3d 3d | 3d 3d 3d 3d 3d 3d 3d 3d |========|========|
|00000d50| 3d 3d 3d 3d 3d 3d 3d 3d | 3d 3d 0d 0d 63 61 74 63 |========|==..catc|
|00000d60| 68 20 7b 75 6e 73 65 74 | 20 70 6c 53 71 6c 4b 65 |h {unset| plSqlKe|
|00000d70| 79 77 6f 72 64 73 7d 0d | 0d 6c 61 70 70 65 6e 64 |ywords}.|.lappend|
|00000d80| 20 70 6c 53 71 6c 4b 65 | 79 77 6f 72 64 73 20 5c | plSqlKe|ywords \|
|00000d90| 0d 09 61 62 6f 72 74 20 | 61 63 63 65 70 74 20 61 |..abort |accept a|
|00000da0| 63 63 65 73 73 20 61 6c | 74 65 72 20 61 6e 64 20 |ccess al|ter and |
|00000db0| 61 72 72 61 79 20 61 72 | 72 61 79 6c 65 6e 20 61 |array ar|raylen a|
|00000dc0| 73 20 61 73 73 65 72 74 | 20 61 74 20 61 76 67 20 |s assert| at avg |
|00000dd0| 62 65 67 69 6e 20 62 65 | 74 77 65 65 6e 20 62 6f |begin be|tween bo|
|00000de0| 64 79 20 5c 0d 09 63 61 | 73 65 20 63 6f 6c 75 6d |dy \..ca|se colum|
|00000df0| 6e 73 20 63 6f 6d 6d 69 | 74 20 63 6f 6e 73 74 61 |ns commi|t consta|
|00000e00| 6e 74 20 63 6f 75 6e 74 | 20 63 72 65 61 74 65 20 |nt count| create |
|00000e10| 63 75 72 73 6f 72 20 64 | 65 63 6c 61 72 65 20 64 |cursor d|eclare d|
|00000e20| 65 66 61 75 6c 74 20 64 | 65 66 69 6e 69 74 69 6f |efault d|efinitio|
|00000e30| 6e 20 5c 0d 09 64 65 6c | 65 74 65 20 64 65 73 63 |n \..del|ete desc|
|00000e40| 20 64 69 73 70 6f 73 65 | 20 64 69 73 74 69 6e 63 | dispose| distinc|
|00000e50| 74 20 64 6f 20 64 72 6f | 70 20 65 6c 73 65 20 65 |t do dro|p else e|
|00000e60| 6c 73 69 66 20 65 6e 64 | 20 65 6e 74 72 79 20 65 |lsif end| entry e|
|00000e70| 78 63 65 70 74 69 6f 6e | 20 65 78 69 73 74 73 20 |xception| exists |
|00000e80| 65 78 69 74 20 5c 0d 09 | 66 61 6c 73 65 20 66 65 |exit \..|false fe|
|00000e90| 74 63 68 20 66 6f 72 20 | 66 72 6f 6d 20 66 75 6e |tch for |from fun|
|00000ea0| 63 74 69 6f 6e 20 67 6f | 74 6f 20 69 66 20 69 6e |ction go|to if in|
|00000eb0| 20 69 6e 73 65 72 74 20 | 69 6e 74 65 72 73 65 63 | insert |intersec|
|00000ec0| 74 20 69 6e 74 6f 20 69 | 73 20 6c 69 6b 65 20 6c |t into i|s like l|
|00000ed0| 6f 6f 70 20 6d 61 78 20 | 6d 69 6e 20 5c 0d 09 6d |oop max |min \..m|
|00000ee0| 69 6e 75 73 20 6d 6f 64 | 20 6e 65 77 20 6f 66 20 |inus mod| new of |
|00000ef0| 6f 6e 20 6f 70 65 6e 20 | 6f 72 20 6f 75 74 20 70 |on open |or out p|
|00000f00| 61 63 6b 61 67 65 20 70 | 61 72 74 69 74 69 6f 6e |ackage p|artition|
|00000f10| 20 70 6f 73 69 74 69 76 | 65 20 70 72 61 67 6d 61 | positiv|e pragma|
|00000f20| 20 70 72 69 76 61 74 65 | 20 5c 0d 09 70 72 6f 63 | private| \..proc|
|00000f30| 65 64 75 72 65 20 70 75 | 62 6c 69 63 20 72 61 6e |edure pu|blic ran|
|00000f40| 67 65 20 72 65 63 6f 72 | 64 20 72 65 6d 20 72 65 |ge recor|d rem re|
|00000f50| 70 6c 61 63 65 20 72 65 | 74 75 72 6e 20 72 6f 6c |place re|turn rol|
|00000f60| 6c 62 61 63 6b 20 72 6f | 77 74 79 70 65 20 72 75 |lback ro|wtype ru|
|00000f70| 6e 20 73 61 76 65 70 6f | 69 6e 74 20 5c 0d 09 73 |n savepo|int \..s|
|00000f80| 65 6c 65 63 74 20 73 65 | 74 20 73 69 7a 65 20 73 |elect se|t size s|
|00000f90| 74 61 72 74 20 73 74 64 | 64 65 76 20 73 75 6d 20 |tart std|dev sum |
|00000fa0| 74 68 65 6e 20 74 6f 20 | 74 79 70 65 20 75 6e 69 |then to |type uni|
|00000fb0| 6f 6e 20 75 6e 69 71 75 | 65 20 75 70 64 61 74 65 |on uniqu|e update|
|00000fc0| 20 75 73 65 20 76 61 6c | 75 65 73 20 5c 0d 09 76 | use val|ues \..v|
|00000fd0| 61 72 69 61 6e 63 65 20 | 77 68 65 6e 20 77 68 65 |ariance |when whe|
|00000fe0| 72 65 20 77 68 69 6c 65 | 20 77 69 74 68 20 78 6f |re while| with xo|
|00000ff0| 72 0d 0d 0d 70 72 6f 63 | 20 65 6c 65 63 74 55 70 |r...proc| electUp|
|00001000| 70 65 72 20 7b 63 68 61 | 72 7d 20 7b 0d 09 67 6c |per {cha|r} {..gl|
|00001010| 6f 62 61 6c 20 70 6c 53 | 71 6c 4b 65 79 77 6f 72 |obal plS|qlKeywor|
|00001020| 64 73 0d 09 0d 09 73 65 | 74 20 61 20 5b 67 65 74 |ds....se|t a [get|
|00001030| 50 6f 73 5d 0d 09 62 61 | 63 6b 77 61 72 64 57 6f |Pos]..ba|ckwardWo|
|00001040| 72 64 0d 09 73 65 74 20 | 62 20 5b 67 65 74 50 6f |rd..set |b [getPo|
|00001050| 73 5d 0d 09 0d 09 23 6d | 61 6b 65 20 73 75 72 65 |s]....#m|ake sure|
|00001060| 20 77 65 27 72 65 20 6e | 6f 74 20 69 6e 20 61 20 | we're n|ot in a |
|00001070| 63 6f 6d 6d 65 6e 74 0d | 09 62 65 67 69 6e 6e 69 |comment.|.beginni|
|00001080| 6e 67 4f 66 4c 69 6e 65 | 0d 09 73 65 74 20 63 6f |ngOfLine|..set co|
|00001090| 6d 6d 65 6e 74 53 65 61 | 72 63 68 20 7b 28 5e 5b |mmentSea|rch {(^[|
|000010a0| 20 5c 74 5d 2a 72 65 6d | 5b 20 5c 74 5d 2b 29 7c | \t]*rem|[ \t]+)||
|000010b0| 28 5e 5b 20 5c 74 5d 2a | 52 45 4d 5b 20 5c 74 5d |(^[ \t]*|REM[ \t]|
|000010c0| 2b 29 7c 2d 2d 7d 0d 09 | 69 66 20 7b 5b 63 61 74 |+)|--}..|if {[cat|
|000010d0| 63 68 20 7b 73 65 61 72 | 63 68 20 2d 72 20 31 20 |ch {sear|ch -r 1 |
|000010e0| 2d 66 20 31 20 2d 6c 20 | 24 62 20 2d 2d 20 24 63 |-f 1 -l |$b -- $c|
|000010f0| 6f 6d 6d 65 6e 74 53 65 | 61 72 63 68 20 5b 67 65 |ommentSe|arch [ge|
|00001100| 74 50 6f 73 5d 7d 5d 20 | 21 3d 20 30 7d 20 7b 0d |tPos]}] |!= 0} {.|
|00001110| 09 09 23 69 66 20 6e 6f | 74 2c 20 6d 61 6b 65 20 |..#if no|t, make |
|00001120| 74 68 65 20 77 6f 72 64 | 20 75 70 70 65 72 63 61 |the word| upperca|
|00001130| 73 65 20 69 66 20 69 74 | 27 73 20 61 20 6b 65 79 |se if it|'s a key|
|00001140| 77 6f 72 64 0d 09 09 73 | 65 74 20 63 6d 64 20 5b |word...s|et cmd [|
|00001150| 67 65 74 54 65 78 74 20 | 24 62 20 24 61 5d 0d 09 |getText |$b $a]..|
|00001160| 09 67 6f 74 6f 20 24 62 | 0d 09 09 69 66 20 7b 5b |.goto $b|...if {[|
|00001170| 6c 73 65 61 72 63 68 20 | 2d 65 78 61 63 74 20 24 |lsearch |-exact $|
|00001180| 70 6c 53 71 6c 4b 65 79 | 77 6f 72 64 73 20 24 63 |plSqlKey|words $c|
|00001190| 6d 64 5d 20 3e 3d 20 30 | 7d 20 7b 0d 09 09 09 75 |md] >= 0|} {....u|
|000011a0| 70 63 61 73 65 57 6f 72 | 64 0d 09 09 7d 0d 09 7d |pcaseWor|d...}..}|
|000011b0| 0d 09 67 6f 74 6f 20 24 | 61 0d 09 69 66 20 7b 20 |..goto $|a..if { |
|000011c0| 30 20 3d 3d 20 5b 73 74 | 72 69 6e 67 20 63 6f 6d |0 == [st|ring com|
|000011d0| 70 61 72 65 20 24 63 68 | 61 72 20 22 5c 72 22 5d |pare $ch|ar "\r"]|
|000011e0| 20 7d 20 7b 0d 09 09 63 | 61 72 72 69 61 67 65 52 | } {...c|arriageR|
|000011f0| 65 74 75 72 6e 0d 09 7d | 20 65 6c 73 65 20 7b 0d |eturn..}| else {.|
|00001200| 09 09 69 6e 73 65 72 74 | 54 65 78 74 20 24 63 68 |..insert|Text $ch|
|00001210| 61 72 0d 09 7d 0d 7d 0d | 0d 62 69 6e 64 20 27 5c |ar..}.}.|.bind '\|
|00001220| 20 27 20 7b 65 6c 65 63 | 74 55 70 70 65 72 20 22 | ' {elec|tUpper "|
|00001230| 5c 20 22 7d 20 22 53 51 | 4c 22 0d 62 69 6e 64 20 |\ "} "SQ|L".bind |
|00001240| 27 5c 74 27 20 7b 65 6c | 65 63 74 55 70 70 65 72 |'\t' {el|ectUpper|
|00001250| 20 22 5c 74 22 7d 20 22 | 53 51 4c 22 0d 62 69 6e | "\t"} "|SQL".bin|
|00001260| 64 20 27 5c 72 27 20 7b | 65 6c 65 63 74 55 70 70 |d '\r' {|electUpp|
|00001270| 65 72 20 22 5c 72 22 7d | 20 22 53 51 4c 22 0d 62 |er "\r"}| "SQL".b|
|00001280| 69 6e 64 20 27 5c 3b 27 | 20 7b 65 6c 65 63 74 55 |ind '\;'| {electU|
|00001290| 70 70 65 72 20 22 5c 3b | 22 7d 20 22 53 51 4c 22 |pper "\;|"} "SQL"|
|000012a0| 0d 0d 70 72 6f 63 20 53 | 51 4c 4d 61 72 6b 46 69 |..proc S|QLMarkFi|
|000012b0| 6c 65 20 7b 7d 20 7b 0d | 09 67 6c 6f 62 61 6c 20 |le {} {.|.global |
|000012c0| 53 51 4c 6d 6f 64 65 56 | 61 72 73 0d 09 73 65 74 |SQLmodeV|ars..set|
|000012d0| 20 70 6f 73 20 30 0d 09 | 77 68 69 6c 65 20 7b 21 | pos 0..|while {!|
|000012e0| 5b 63 61 74 63 68 20 7b | 73 65 61 72 63 68 20 2d |[catch {|search -|
|000012f0| 66 20 31 20 2d 72 20 31 | 20 2d 6d 20 30 20 2d 69 |f 1 -r 1| -m 0 -i|
|00001300| 20 30 20 24 53 51 4c 6d | 6f 64 65 56 61 72 73 28 | 0 $SQLm|odeVars(|
|00001310| 66 75 6e 63 45 78 70 72 | 29 20 24 70 6f 73 7d 20 |funcExpr|) $pos} |
|00001320| 72 65 73 5d 7d 20 7b 0d | 09 09 73 65 74 20 73 74 |res]} {.|..set st|
|00001330| 61 72 74 20 5b 6c 69 6e | 64 65 78 20 24 72 65 73 |art [lin|dex $res|
|00001340| 20 30 5d 0d 09 09 73 65 | 74 20 65 6e 64 20 5b 6c | 0]...se|t end [l|
|00001350| 69 6e 64 65 78 20 24 72 | 65 73 20 31 5d 0d 09 09 |index $r|es 1]...|
|00001360| 73 65 74 20 74 65 78 74 | 20 5b 6c 69 6e 64 65 78 |set text| [lindex|
|00001370| 20 5b 67 65 74 54 65 78 | 74 20 24 73 74 61 72 74 | [getTex|t $start|
|00001380| 20 24 65 6e 64 5d 20 31 | 5d 0d 09 09 73 65 74 20 | $end] 1|]...set |
|00001390| 70 6f 73 20 24 65 6e 64 | 0d 09 09 73 65 74 20 69 |pos $end|...set i|
|000013a0| 6e 64 73 28 24 74 65 78 | 74 29 20 22 24 73 74 61 |nds($tex|t) "$sta|
|000013b0| 72 74 20 24 65 6e 64 22 | 0d 09 7d 0d 09 0d 09 69 |rt $end"|..}....i|
|000013c0| 66 20 7b 5b 69 6e 66 6f | 20 65 78 69 73 74 73 20 |f {[info| exists |
|000013d0| 69 6e 64 73 5d 7d 20 7b | 0d 09 09 66 6f 72 65 61 |inds]} {|...forea|
|000013e0| 63 68 20 66 20 5b 6c 73 | 6f 72 74 20 5b 61 72 72 |ch f [ls|ort [arr|
|000013f0| 61 79 20 6e 61 6d 65 73 | 20 69 6e 64 73 5d 5d 20 |ay names| inds]] |
|00001400| 7b 0d 09 09 09 73 65 74 | 4e 61 6d 65 64 4d 61 72 |{....set|NamedMar|
|00001410| 6b 20 24 66 20 5b 6c 69 | 6e 65 53 74 61 72 74 20 |k $f [li|neStart |
|00001420| 5b 6c 69 6e 65 53 74 61 | 72 74 20 5b 6c 69 6e 64 |[lineSta|rt [lind|
|00001430| 65 78 20 24 69 6e 64 73 | 28 24 66 29 20 30 5d 5d |ex $inds|($f) 0]]|
|00001440| 20 2d 20 31 5d 20 5b 6c | 69 6e 64 65 78 20 24 69 | - 1] [l|index $i|
|00001450| 6e 64 73 28 24 66 29 20 | 30 5d 20 5b 6c 69 6e 64 |nds($f) |0] [lind|
|00001460| 65 78 20 24 69 6e 64 73 | 28 24 66 29 20 31 5d 0d |ex $inds|($f) 1].|
|00001470| 09 09 7d 0d 09 7d 0d 7d | 00 00 00 00 00 00 00 00 |..}..}.}|........|
|00001480| 00 00 01 00 00 00 01 78 | 00 00 00 78 00 00 00 42 |.......x|...x...B|
|00001490| 32 35 39 32 0d 20 48 65 | 61 70 20 7a 6f 6e 65 73 |2592. He|ap zones|
|000014a0| 0d 20 20 33 32 20 20 30 | 30 30 30 32 30 30 30 20 |. 32 0|0002000 |
|000014b0| 07 73 71 6c 2e 74 63 6c | 02 00 00 00 54 45 58 54 |.sql.tcl|....TEXT|
|000014c0| 41 4c 46 41 00 00 00 00 | 00 00 00 00 00 01 06 0c |ALFA....|........|
|000014d0| 00 00 54 45 58 54 41 4c | 46 41 00 00 00 00 00 00 |..TEXTAL|FA......|
|000014e0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000014f0| 00 00 ac 01 2c 3f 00 00 | 13 f8 00 00 01 ba 33 0d |....,?..|......3.|
|00001500| 20 20 33 32 20 20 20 30 | 30 31 41 41 45 45 43 20 | 32 0|01AAEEC |
|00001510| 74 6f 20 30 30 31 43 44 | 31 43 33 0d 20 20 33 32 |to 001CD|1C3. 32|
|00001520| 20 20 20 30 30 32 36 30 | 44 46 43 20 74 6f 20 30 | 00260|DFC to 0|
|00001530| 30 32 36 31 39 46 33 0d | 20 20 33 32 20 20 20 30 |02619F3.| 32 0|
|00001540| 30 32 36 33 33 35 43 20 | 74 6f 20 30 30 32 36 44 |026335C |to 0026D|
|00001550| 30 39 33 0d 20 20 33 32 | 20 20 20 30 30 33 31 36 |093. 32| 00316|
|00001560| 45 44 43 20 74 6f 20 30 | 30 33 34 36 33 35 33 0d |EDC to 0|0346353.|
|00001570| 20 20 33 32 20 20 30 30 | 39 33 46 35 46 30 20 74 | 32 00|93F5F0 t|
|00001580| 00 00 00 28 00 02 00 00 | 04 02 00 00 04 02 09 64 |...(....|.......d|
|00001590| 75 6d 6d 79 53 51 4c 00 | 00 00 0f 74 00 00 0f 74 |ummySQL.|...t...t|
|000015a0| 0b 65 6c 65 63 74 55 70 | 70 65 72 00 00 00 00 48 |.electUp|per....H|
|000015b0| 00 09 4d 6f 6e 61 63 6f | 00 05 af a0 00 00 15 ac |..Monaco|........|
|000015c0| 00 fe 3d 1c 01 1c e3 70 | 24 00 04 44 01 60 a7 38 |..=....p|$..D.`.8|
|000015d0| 00 24 00 04 00 04 00 28 | 00 02 02 5c 02 00 00 28 |.$.....(|...\...(|
|000015e0| 00 02 02 5c 02 00 ac 01 | 2c 41 00 00 00 00 00 00 |...\....|,A......|
|000015f0| 00 00 00 00 00 00 01 00 | 00 00 01 00 00 00 01 78 |........|.......x|
|00001600| 00 00 00 78 00 00 00 42 | 00 fc b3 68 15 ac 00 00 |...x...B|...h....|
|00001610| 00 1c 00 3e 00 00 4d 50 | 53 52 00 01 00 0a 03 ef |...>..MP|SR......|
|00001620| 00 00 00 00 00 00 00 00 | 00 00 03 ed ff ff 00 00 |........|........|
|00001630| 00 2c 01 05 b9 7c 03 74 | 61 62 00 00 00 00 00 00 |.,...|.t|ab......|
|00001640| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001650| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001660| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001670| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
+--------+-------------------------+-------------------------+--------+--------+