home *** CD-ROM | disk | FTP | other *** search
open in: 
MacOS 8.1
|
Win98
|
DOS
browse contents |
view JSON data
|
view as text
This file was processed as: SHell self-extracting ARchive
(archive/shar).
| Confidence | Program | Detection | Match Type | Support
|
|---|
| 100%
| dexvert
| SHell self-extracting ARchive (archive/shar)
| magic
| Supported |
| 1%
| dexvert
| Text File (text/txt)
| fallback
| Supported |
| 100%
| file
| ASCII text
| default
| |
| 100%
| checkBytes
| Printable ASCII
| default
| |
| 100%
| perlTextCheck
| Likely Text (Perl)
| default
| |
| 100%
| siegfried
| fmt/329 Shell Archive Format
| default
| |
| 100%
| detectItEasy
| Format: plain text[LF]
| default (weak)
|
|
hex view+--------+-------------------------+-------------------------+--------+--------+
|00000000| 4e 65 77 73 67 72 6f 75 | 70 73 3a 20 63 6f 6d 70 |Newsgrou|ps: comp|
|00000010| 2e 73 6f 75 72 63 65 73 | 2e 6d 69 73 63 0a 46 72 |.sources|.misc.Fr|
|00000020| 6f 6d 3a 20 6d 70 65 70 | 70 6c 65 72 40 69 74 66 |om: mpep|pler@itf|
|00000030| 30 2e 69 74 66 2e 63 68 | 20 28 4d 69 63 68 61 65 |0.itf.ch| (Michae|
|00000040| 6c 20 50 65 70 70 6c 65 | 72 29 0a 53 75 62 6a 65 |l Pepple|r).Subje|
|00000050| 63 74 3a 20 76 33 37 69 | 30 33 34 3a 20 20 73 79 |ct: v37i|034: sy|
|00000060| 62 70 65 72 6c 20 2d 20 | 53 79 62 61 73 65 20 44 |bperl - |Sybase D|
|00000070| 42 2d 6c 69 62 72 61 72 | 79 20 65 78 74 65 6e 73 |B-librar|y extens|
|00000080| 69 6f 6e 73 20 74 6f 20 | 50 65 72 6c 2c 20 76 31 |ions to |Perl, v1|
|00000090| 2e 36 2c 20 50 61 72 74 | 30 32 2f 30 32 0a 4d 65 |.6, Part|02/02.Me|
|000000a0| 73 73 61 67 65 2d 49 44 | 3a 20 3c 31 39 39 33 41 |ssage-ID|: <1993A|
|000000b0| 70 72 32 38 2e 31 36 34 | 31 35 36 2e 31 32 38 32 |pr28.164|156.1282|
|000000c0| 35 40 73 70 61 72 6b 79 | 2e 69 6d 64 2e 73 74 65 |5@sparky|.imd.ste|
|000000d0| 72 6c 69 6e 67 2e 63 6f | 6d 3e 0a 58 2d 4d 64 34 |rling.co|m>.X-Md4|
|000000e0| 2d 53 69 67 6e 61 74 75 | 72 65 3a 20 34 33 32 66 |-Signatu|re: 432f|
|000000f0| 62 62 35 64 38 30 32 37 | 62 37 66 35 36 33 39 63 |bb5d8027|b7f5639c|
|00000100| 35 61 61 65 32 39 63 61 | 36 38 31 31 0a 44 61 74 |5aae29ca|6811.Dat|
|00000110| 65 3a 20 57 65 64 2c 20 | 32 38 20 41 70 72 20 31 |e: Wed, |28 Apr 1|
|00000120| 39 39 33 20 31 36 3a 34 | 31 3a 35 36 20 47 4d 54 |993 16:4|1:56 GMT|
|00000130| 0a 41 70 70 72 6f 76 65 | 64 3a 20 6b 65 6e 74 40 |.Approve|d: kent@|
|00000140| 73 70 61 72 6b 79 2e 69 | 6d 64 2e 73 74 65 72 6c |sparky.i|md.sterl|
|00000150| 69 6e 67 2e 63 6f 6d 0a | 0a 53 75 62 6d 69 74 74 |ing.com.|.Submitt|
|00000160| 65 64 2d 62 79 3a 20 6d | 70 65 70 70 6c 65 72 40 |ed-by: m|peppler@|
|00000170| 69 74 66 30 2e 69 74 66 | 2e 63 68 20 28 4d 69 63 |itf0.itf|.ch (Mic|
|00000180| 68 61 65 6c 20 50 65 70 | 70 6c 65 72 29 0a 50 6f |hael Pep|pler).Po|
|00000190| 73 74 69 6e 67 2d 6e 75 | 6d 62 65 72 3a 20 56 6f |sting-nu|mber: Vo|
|000001a0| 6c 75 6d 65 20 33 37 2c | 20 49 73 73 75 65 20 33 |lume 37,| Issue 3|
|000001b0| 34 0a 41 72 63 68 69 76 | 65 2d 6e 61 6d 65 3a 20 |4.Archiv|e-name: |
|000001c0| 73 79 62 70 65 72 6c 2f | 70 61 72 74 30 32 0a 45 |sybperl/|part02.E|
|000001d0| 6e 76 69 72 6f 6e 6d 65 | 6e 74 3a 20 55 4e 49 58 |nvironme|nt: UNIX|
|000001e0| 2c 20 50 65 72 6c 2c 20 | 53 79 62 61 73 65 0a 53 |, Perl, |Sybase.S|
|000001f0| 75 70 65 72 73 65 64 65 | 73 3a 20 73 79 62 70 65 |upersede|s: sybpe|
|00000200| 72 6c 3a 20 56 6f 6c 75 | 6d 65 20 32 38 2c 20 49 |rl: Volu|me 28, I|
|00000210| 73 73 75 65 20 33 33 0a | 0a 23 21 20 2f 62 69 6e |ssue 33.|.#! /bin|
|00000220| 2f 73 68 0a 23 20 54 68 | 69 73 20 69 73 20 61 20 |/sh.# Th|is is a |
|00000230| 73 68 65 6c 6c 20 61 72 | 63 68 69 76 65 2e 20 20 |shell ar|chive. |
|00000240| 52 65 6d 6f 76 65 20 61 | 6e 79 74 68 69 6e 67 20 |Remove a|nything |
|00000250| 62 65 66 6f 72 65 20 74 | 68 69 73 20 6c 69 6e 65 |before t|his line|
|00000260| 2c 20 74 68 65 6e 20 66 | 65 65 64 20 69 74 0a 23 |, then f|eed it.#|
|00000270| 20 69 6e 74 6f 20 61 20 | 73 68 65 6c 6c 20 76 69 | into a |shell vi|
|00000280| 61 20 22 73 68 20 66 69 | 6c 65 22 20 6f 72 20 73 |a "sh fi|le" or s|
|00000290| 69 6d 69 6c 61 72 2e 20 | 20 54 6f 20 6f 76 65 72 |imilar. | To over|
|000002a0| 77 72 69 74 65 20 65 78 | 69 73 74 69 6e 67 20 66 |write ex|isting f|
|000002b0| 69 6c 65 73 2c 0a 23 20 | 74 79 70 65 20 22 73 68 |iles,.# |type "sh|
|000002c0| 20 66 69 6c 65 20 2d 63 | 22 2e 0a 23 20 43 6f 6e | file -c|"..# Con|
|000002d0| 74 65 6e 74 73 3a 20 20 | 42 55 47 53 20 43 48 41 |tents: |BUGS CHA|
|000002e0| 4e 47 45 53 20 50 41 43 | 4b 49 4e 47 2e 4c 53 54 |NGES PAC|KING.LST|
|000002f0| 20 65 67 2f 52 45 41 44 | 4d 45 20 65 67 2f 63 61 | eg/READ|ME eg/ca|
|00000300| 70 74 75 72 65 2e 70 6c | 0a 23 20 20 20 65 67 2f |pture.pl|.# eg/|
|00000310| 64 62 74 65 78 74 2e 70 | 6c 20 65 67 2f 72 65 70 |dbtext.p|l eg/rep|
|00000320| 6f 72 74 2e 70 6c 20 65 | 67 2f 73 70 61 63 65 2e |ort.pl e|g/space.|
|00000330| 70 6c 20 65 67 2f 73 71 | 6c 2e 70 6c 20 6c 69 62 |pl eg/sq|l.pl lib|
|00000340| 2f 73 79 62 64 62 2e 70 | 68 0a 23 20 20 20 6c 69 |/sybdb.p|h.# li|
|00000350| 62 2f 73 79 62 70 65 72 | 6c 2e 70 6c 20 74 2f 73 |b/sybper|l.pl t/s|
|00000360| 62 65 78 2e 70 6c 0a 23 | 20 57 72 61 70 70 65 64 |bex.pl.#| Wrapped|
|00000370| 20 62 79 20 6b 65 6e 74 | 40 73 70 61 72 6b 79 20 | by kent|@sparky |
|00000380| 6f 6e 20 57 65 64 20 41 | 70 72 20 32 38 20 30 38 |on Wed A|pr 28 08|
|00000390| 3a 34 30 3a 30 38 20 31 | 39 39 33 0a 50 41 54 48 |:40:08 1|993.PATH|
|000003a0| 3d 2f 62 69 6e 3a 2f 75 | 73 72 2f 62 69 6e 3a 2f |=/bin:/u|sr/bin:/|
|000003b0| 75 73 72 2f 75 63 62 3a | 2f 75 73 72 2f 6c 6f 63 |usr/ucb:|/usr/loc|
|000003c0| 61 6c 2f 62 69 6e 3a 2f | 75 73 72 2f 6c 62 69 6e |al/bin:/|usr/lbin|
|000003d0| 20 3b 20 65 78 70 6f 72 | 74 20 50 41 54 48 0a 65 | ; expor|t PATH.e|
|000003e0| 63 68 6f 20 49 66 20 74 | 68 69 73 20 61 72 63 68 |cho If t|his arch|
|000003f0| 69 76 65 20 69 73 20 63 | 6f 6d 70 6c 65 74 65 2c |ive is c|omplete,|
|00000400| 20 79 6f 75 20 77 69 6c | 6c 20 73 65 65 20 74 68 | you wil|l see th|
|00000410| 65 20 66 6f 6c 6c 6f 77 | 69 6e 67 20 6d 65 73 73 |e follow|ing mess|
|00000420| 61 67 65 3a 0a 65 63 68 | 6f 20 27 20 20 20 20 20 |age:.ech|o ' |
|00000430| 20 20 20 20 20 22 73 68 | 61 72 3a 20 45 6e 64 20 | "sh|ar: End |
|00000440| 6f 66 20 61 72 63 68 69 | 76 65 20 32 20 28 6f 66 |of archi|ve 2 (of|
|00000450| 20 32 29 2e 22 27 0a 69 | 66 20 74 65 73 74 20 2d | 2)."'.i|f test -|
|00000460| 66 20 27 42 55 47 53 27 | 20 2d 61 20 22 24 7b 31 |f 'BUGS'| -a "${1|
|00000470| 7d 22 20 21 3d 20 22 2d | 63 22 20 3b 20 74 68 65 |}" != "-|c" ; the|
|00000480| 6e 20 0a 20 20 65 63 68 | 6f 20 73 68 61 72 3a 20 |n . ech|o shar: |
|00000490| 57 69 6c 6c 20 6e 6f 74 | 20 63 6c 6f 62 62 65 72 |Will not| clobber|
|000004a0| 20 65 78 69 73 74 69 6e | 67 20 66 69 6c 65 20 5c | existin|g file \|
|000004b0| 22 27 42 55 47 53 27 5c | 22 0a 65 6c 73 65 0a 20 |"'BUGS'\|".else. |
|000004c0| 20 65 63 68 6f 20 73 68 | 61 72 3a 20 45 78 74 72 | echo sh|ar: Extr|
|000004d0| 61 63 74 69 6e 67 20 5c | 22 27 42 55 47 53 27 5c |acting \|"'BUGS'\|
|000004e0| 22 20 5c 28 32 38 31 38 | 20 63 68 61 72 61 63 74 |" \(2818| charact|
|000004f0| 65 72 73 5c 29 0a 20 20 | 73 65 64 20 22 73 2f 5e |ers\). |sed "s/^|
|00000500| 58 2f 2f 22 20 3e 27 42 | 55 47 53 27 20 3c 3c 27 |X//" >'B|UGS' <<'|
|00000510| 45 4e 44 5f 4f 46 5f 46 | 49 4c 45 27 0a 58 0a 58 |END_OF_F|ILE'.X.X|
|00000520| 09 0a 58 20 20 20 20 54 | 68 65 20 53 79 62 61 73 |..X T|he Sybas|
|00000530| 65 20 44 42 2d 4c 69 62 | 72 61 72 79 20 2d 20 50 |e DB-Lib|rary - P|
|00000540| 65 72 6c 20 73 61 76 65 | 73 74 72 28 29 20 63 6f |erl save|str() co|
|00000550| 6e 66 6c 69 63 74 0a 58 | 20 20 20 20 2d 2d 2d 2d |nflict.X| ----|
|00000560| 2d 2d 2d 2d 2d 2d 2d 2d | 2d 2d 2d 2d 2d 2d 2d 2d |--------|--------|
|00000570| 2d 2d 2d 2d 2d 2d 2d 2d | 2d 2d 2d 2d 2d 2d 2d 2d |--------|--------|
|00000580| 2d 2d 2d 2d 2d 2d 2d 2d | 2d 2d 2d 2d 0a 58 0a 58 |--------|----.X.X|
|00000590| 0a 58 20 20 20 20 41 68 | 21 20 54 68 65 20 6a 6f |.X Ah|! The jo|
|000005a0| 79 73 20 6f 66 20 74 79 | 69 6e 67 20 64 69 66 66 |ys of ty|ing diff|
|000005b0| 65 72 65 6e 74 20 70 61 | 63 6b 61 67 65 73 20 74 |erent pa|ckages t|
|000005c0| 6f 67 65 74 68 65 72 21 | 0a 58 0a 58 20 20 20 20 |ogether!|.X.X |
|000005d0| 42 6f 74 68 20 50 65 72 | 6c 20 61 6e 64 20 44 42 |Both Per|l and DB|
|000005e0| 2d 4c 69 62 72 61 72 79 | 20 68 61 76 65 20 61 20 |-Library| have a |
|000005f0| 66 75 6e 63 74 69 6f 6e | 20 63 61 6c 6c 65 64 20 |function| called |
|00000600| 73 61 76 65 73 74 72 28 | 29 2e 20 54 68 65 0a 58 |savestr(|). The.X|
|00000610| 20 20 20 20 44 42 2d 4c | 69 62 72 61 72 79 20 76 | DB-L|ibrary v|
|00000620| 65 72 73 69 6f 6e 20 69 | 73 20 75 73 65 64 20 69 |ersion i|s used i|
|00000630| 6e 20 64 62 63 6d 64 28 | 29 20 74 6f 20 61 64 64 |n dbcmd(|) to add|
|00000640| 20 61 6e 20 53 51 4c 20 | 63 6f 6d 6d 61 6e 64 20 | an SQL |command |
|00000650| 74 6f 20 74 68 65 0a 58 | 20 20 20 20 6c 69 73 74 |to the.X| list|
|00000660| 20 6f 66 20 63 6f 6d 6d | 61 6e 64 73 20 70 6f 69 | of comm|ands poi|
|00000670| 6e 74 65 64 20 74 6f 20 | 62 79 20 64 70 70 72 6f |nted to |by dppro|
|00000680| 63 2d 3e 64 62 63 6d 64 | 62 75 66 2c 20 61 6e 64 |c->dbcmd|buf, and|
|00000690| 20 69 6e 20 64 62 75 73 | 65 28 29 20 61 73 0a 58 | in dbus|e() as.X|
|000006a0| 20 20 20 20 77 65 6c 6c | 2e 20 4e 6f 77 20 74 68 | well|. Now th|
|000006b0| 65 72 65 20 61 72 65 20 | 73 65 76 65 72 61 6c 20 |ere are |several |
|000006c0| 77 61 79 73 20 74 6f 20 | 77 6f 72 6b 20 61 72 6f |ways to |work aro|
|000006d0| 75 6e 64 20 74 68 69 73 | 20 70 72 6f 62 6c 65 6d |und this| problem|
|000006e0| 2e 0a 58 0a 58 20 20 20 | 20 31 29 20 43 6f 6d 70 |..X.X | 1) Comp|
|000006f0| 69 6c 65 20 73 79 62 70 | 65 72 6c 2e 63 20 77 69 |ile sybp|erl.c wi|
|00000700| 74 68 20 2d 44 42 52 4f | 4b 45 4e 5f 44 42 43 4d |th -DBRO|KEN_DBCM|
|00000710| 44 2e 20 49 27 76 65 20 | 77 72 69 74 74 65 6e 20 |D. I've |written |
|00000720| 73 6f 6d 65 20 63 6f 64 | 65 0a 58 20 20 20 20 20 |some cod|e.X |
|00000730| 20 20 74 68 61 74 20 65 | 6d 75 6c 61 74 65 73 20 | that e|mulates |
|00000740| 63 61 6c 6c 73 20 74 6f | 20 64 62 63 6d 64 28 29 |calls to| dbcmd()|
|00000750| 20 61 6e 64 20 64 62 75 | 73 65 28 29 2e 20 54 68 | and dbu|se(). Th|
|00000760| 69 73 20 77 6f 72 6b 73 | 20 4f 4b 20 6f 6e 20 6d |is works| OK on m|
|00000770| 79 0a 58 20 20 20 20 20 | 20 20 6d 61 63 68 69 6e |y.X | machin|
|00000780| 65 2f 4f 53 2f 56 65 72 | 73 69 6f 6e 20 6f 66 20 |e/OS/Ver|sion of |
|00000790| 50 65 72 6c 2f 56 65 72 | 73 69 6f 6e 20 6f 66 20 |Perl/Ver|sion of |
|000007a0| 44 42 6c 69 62 2c 20 62 | 75 74 20 69 74 20 72 65 |DBlib, b|ut it re|
|000007b0| 6c 69 65 73 20 6f 6e 0a | 58 20 20 20 20 20 20 20 |lies on.|X |
|000007c0| 74 68 65 20 69 6e 74 65 | 72 6e 61 6c 20 73 74 6f |the inte|rnal sto|
|000007d0| 72 69 6e 67 20 6d 65 74 | 68 6f 64 20 75 73 65 64 |ring met|hod used|
|000007e0| 20 62 79 20 44 42 6c 69 | 62 2c 20 61 6e 64 20 74 | by DBli|b, and t|
|000007f0| 68 61 74 20 6d 69 67 68 | 74 0a 58 20 20 20 20 20 |hat migh|t.X |
|00000800| 20 20 63 68 61 6e 67 65 | 20 69 6e 20 74 68 65 20 | change| in the |
|00000810| 66 75 74 75 72 65 2e 0a | 58 0a 58 20 20 20 20 32 |future..|X.X 2|
|00000820| 29 20 52 65 63 6f 6d 70 | 69 6c 65 20 50 65 72 6c |) Recomp|ile Perl|
|00000830| 20 28 73 70 65 63 69 66 | 69 63 61 6c 6c 79 2c 20 | (specif|ically, |
|00000840| 75 70 65 72 6c 2e 6f 20 | 69 6e 20 74 68 65 20 50 |uperl.o |in the P|
|00000850| 65 72 6c 20 73 6f 75 72 | 63 65 0a 58 20 20 20 20 |erl sour|ce.X |
|00000860| 20 20 20 64 69 72 65 63 | 74 6f 72 79 29 20 77 69 | direc|tory) wi|
|00000870| 74 68 20 73 6f 6d 65 20 | 73 75 69 74 61 62 6c 65 |th some |suitable|
|00000880| 20 66 6c 61 67 73 20 28 | 65 67 20 2d 44 73 61 76 | flags (|eg -Dsav|
|00000890| 65 73 74 72 3d 70 5f 73 | 61 76 65 73 74 72 29 2e |estr=p_s|avestr).|
|000008a0| 0a 58 20 20 20 20 20 20 | 20 54 68 69 73 20 64 6f |.X | This do|
|000008b0| 65 73 20 6e 6f 74 20 63 | 72 65 61 74 65 20 61 6e |es not c|reate an|
|000008c0| 79 20 63 6f 6d 70 61 74 | 69 62 69 6c 69 74 79 20 |y compat|ibility |
|000008d0| 70 72 6f 62 6c 65 6d 73 | 2c 20 62 75 74 20 69 73 |problems|, but is|
|000008e0| 20 61 0a 58 20 20 20 20 | 20 20 20 6c 65 6e 67 74 | a.X | lengt|
|000008f0| 68 79 20 70 72 6f 63 65 | 64 75 72 65 2e 0a 58 0a |hy proce|dure..X.|
|00000900| 58 20 20 20 20 33 29 20 | 44 6f 20 73 6f 6d 65 74 |X 3) |Do somet|
|00000910| 68 69 6e 67 20 6c 69 6b | 65 3a 0a 58 20 20 20 20 |hing lik|e:.X |
|00000920| 20 20 20 63 63 20 2d 63 | 20 73 79 62 70 65 72 6c | cc -c| sybperl|
|00000930| 2e 63 0a 58 20 20 20 20 | 20 20 20 6c 64 20 2d 72 |.c.X | ld -r|
|00000940| 20 2d 6f 20 73 79 62 70 | 65 72 6c 32 2e 6f 20 73 | -o sybp|erl2.o s|
|00000950| 79 62 70 65 72 6c 2e 6f | 20 2d 6c 73 79 62 64 62 |ybperl.o| -lsybdb|
|00000960| 0a 58 20 20 20 20 20 20 | 20 5b 65 64 69 74 20 73 |.X | [edit s|
|00000970| 79 62 70 65 72 6c 32 2e | 6f 20 61 6e 64 20 72 65 |ybperl2.|o and re|
|00000980| 70 6c 61 63 65 20 60 5f | 73 61 76 65 73 74 72 27 |place `_|savestr'|
|00000990| 20 77 69 74 68 20 73 6f | 6d 65 74 68 69 6e 67 20 | with so|mething |
|000009a0| 6c 69 6b 65 20 60 5f 73 | 61 76 65 73 74 31 27 5d |like `_s|avest1']|
|000009b0| 0a 58 20 20 20 20 20 20 | 20 63 63 20 2d 6f 20 73 |.X | cc -o s|
|000009c0| 79 62 70 65 72 6c 20 75 | 70 65 72 6c 2e 6f 20 73 |ybperl u|perl.o s|
|000009d0| 79 62 70 65 72 6c 32 2e | 6f 0a 58 20 20 20 20 20 |ybperl2.|o.X |
|000009e0| 20 20 54 68 69 73 20 69 | 73 20 6e 6f 74 20 61 20 | This i|s not a |
|000009f0| 62 61 64 20 73 6f 6c 75 | 74 69 6f 6e 2c 20 62 75 |bad solu|tion, bu|
|00000a00| 74 20 77 6f 6e 27 74 20 | 77 6f 72 6b 20 69 66 20 |t won't |work if |
|00000a10| 79 6f 75 20 68 61 76 65 | 20 73 68 61 72 65 64 0a |you have| shared.|
|00000a20| 58 20 20 20 20 20 20 20 | 6c 69 62 72 61 72 79 20 |X |library |
|00000a30| 76 65 72 73 69 6f 6e 73 | 20 6f 66 20 6c 69 62 73 |versions| of libs|
|00000a40| 79 62 64 62 2e 61 0a 58 | 0a 58 20 20 20 20 34 29 |ybdb.a.X|.X 4)|
|00000a50| 20 45 64 69 74 20 75 70 | 65 72 6c 2e 6f 20 61 6e | Edit up|erl.o an|
|00000a60| 64 20 72 65 70 6c 61 63 | 65 20 73 61 76 65 73 74 |d replac|e savest|
|00000a70| 72 20 77 69 74 68 20 73 | 6f 6d 65 74 68 69 6e 67 |r with s|omething|
|00000a80| 20 65 6c 73 65 2e 20 54 | 68 69 73 20 69 73 0a 58 | else. T|his is.X|
|00000a90| 20 20 20 20 20 20 20 74 | 68 65 20 73 6f 6c 75 74 | t|he solut|
|00000aa0| 69 6f 6e 20 49 27 76 65 | 20 63 68 6f 73 65 6e 20 |ion I've| chosen |
|00000ab0| 61 73 20 74 68 65 20 64 | 65 66 61 75 6c 74 2e 20 |as the d|efault. |
|00000ac0| 49 74 20 69 73 20 72 65 | 6c 61 74 69 76 65 6c 79 |It is re|latively|
|00000ad0| 20 66 61 73 74 2c 0a 58 | 20 20 20 20 20 20 20 64 | fast,.X| d|
|00000ae0| 6f 65 73 20 6e 6f 74 20 | 72 65 6c 79 20 6f 6e 20 |oes not |rely on |
|00000af0| 61 6e 79 20 69 6e 74 65 | 72 6e 61 6c 20 6b 6e 6f |any inte|rnal kno|
|00000b00| 77 6c 65 64 67 65 20 6f | 66 20 44 42 2d 4c 69 62 |wledge o|f DB-Lib|
|00000b10| 72 61 72 79 2c 20 61 6e | 64 20 64 6f 65 73 0a 58 |rary, an|d does.X|
|00000b20| 20 20 20 20 20 20 20 6e | 6f 74 20 72 65 71 75 69 | n|ot requi|
|00000b30| 72 65 20 50 65 72 6c 20 | 74 6f 20 62 65 20 72 65 |re Perl |to be re|
|00000b40| 63 6f 6d 70 69 6c 65 64 | 2e 0a 58 0a 58 20 20 20 |compiled|..X.X |
|00000b50| 20 54 68 65 20 4d 61 6b | 65 66 69 6c 65 20 67 69 | The Mak|efile gi|
|00000b60| 76 65 73 20 73 6f 6d 65 | 20 69 6e 66 6f 72 6d 61 |ves some| informa|
|00000b70| 74 69 6f 6e 20 6f 6e 20 | 68 6f 77 20 74 6f 20 61 |tion on |how to a|
|00000b80| 63 68 69 65 76 65 20 74 | 68 65 73 65 0a 58 20 20 |chieve t|hese.X |
|00000b90| 20 20 64 69 66 66 65 72 | 65 6e 74 20 6f 70 74 69 | differ|ent opti|
|00000ba0| 6f 6e 73 2e 0a 58 20 20 | 20 20 20 20 20 0a 58 20 |ons..X | .X |
|00000bb0| 20 20 20 54 68 61 6e 6b | 73 20 74 6f 20 54 65 65 | Thank|s to Tee|
|00000bc0| 6d 75 20 54 6f 72 6d 61 | 20 66 6f 72 20 70 72 6f |mu Torma| for pro|
|00000bd0| 76 69 64 69 6e 67 20 74 | 68 65 20 69 6e 69 74 69 |viding t|he initi|
|00000be0| 61 6c 20 69 6e 70 75 74 | 20 6f 6e 20 74 68 69 73 |al input| on this|
|00000bf0| 20 70 72 6f 62 6c 65 6d | 2e 20 20 20 20 0a 58 0a | problem|. .X.|
|00000c00| 58 0a 58 0a 58 20 20 20 | 20 53 79 62 70 65 72 6c |X.X.X | Sybperl|
|00000c10| 20 4d 65 6d 6f 72 79 20 | 55 73 61 67 65 0a 58 20 | Memory |Usage.X |
|00000c20| 20 20 20 2d 2d 2d 2d 2d | 2d 2d 2d 2d 2d 2d 2d 2d | -----|--------|
|00000c30| 2d 2d 2d 2d 2d 2d 2d 0a | 58 0a 58 20 20 20 20 54 |-------.|X.X T|
|00000c40| 68 65 20 67 65 6e 65 72 | 61 6c 20 66 6f 72 6d 61 |he gener|al forma|
|00000c50| 74 20 6f 66 20 61 20 53 | 79 62 70 65 72 6c 20 73 |t of a S|ybperl s|
|00000c60| 63 72 69 70 74 20 75 73 | 75 61 6c 6c 79 20 6c 6f |cript us|ually lo|
|00000c70| 6f 6b 73 20 73 6f 6d 65 | 77 68 61 74 20 6c 69 6b |oks some|what lik|
|00000c80| 65 0a 58 20 20 20 20 74 | 68 69 73 3a 0a 58 0a 58 |e.X t|his:.X.X|
|00000c90| 20 20 20 20 23 21 2f 75 | 73 72 2f 6c 6f 63 61 6c | #!/u|sr/local|
|00000ca0| 2f 62 69 6e 2f 73 79 62 | 70 65 72 6c 0a 58 0a 58 |/bin/syb|perl.X.X|
|00000cb0| 20 20 20 20 26 64 62 63 | 6d 64 28 20 71 75 65 72 | &dbc|md( quer|
|00000cc0| 79 20 74 65 78 74 20 29 | 3b 0a 58 20 20 20 20 26 |y text )|;.X &|
|00000cd0| 64 62 73 71 6c 65 78 65 | 63 3b 0a 58 20 20 20 20 |dbsqlexe|c;.X |
|00000ce0| 26 64 62 72 65 73 75 6c | 74 73 3b 0a 58 0a 58 20 |&dbresul|ts;.X.X |
|00000cf0| 20 20 20 77 68 69 6c 65 | 28 40 64 61 74 61 20 3d | while|(@data =|
|00000d00| 20 26 64 62 6e 65 78 74 | 72 6f 77 29 0a 58 20 20 | &dbnext|row).X |
|00000d10| 20 20 7b 0a 58 20 20 20 | 20 20 20 20 70 72 6f 63 | {.X | proc|
|00000d20| 65 73 73 20 64 61 74 61 | 0a 58 20 20 20 20 7d 0a |ess data|.X }.|
|00000d30| 58 0a 58 0a 58 20 20 20 | 20 49 66 20 79 6f 75 20 |X.X.X | If you |
|00000d40| 61 72 65 20 75 73 69 6e | 67 20 61 20 76 65 72 73 |are usin|g a vers|
|00000d50| 69 6f 6e 20 6f 66 20 50 | 65 72 6c 20 70 72 69 6f |ion of P|erl prio|
|00000d60| 72 20 74 6f 20 72 65 6c | 65 61 73 65 20 34 2c 20 |r to rel|ease 4, |
|00000d70| 70 61 74 63 68 6c 65 76 | 65 6c 0a 58 20 20 20 20 |patchlev|el.X |
|00000d80| 33 35 2c 20 74 68 65 6e | 20 74 68 69 73 20 6d 65 |35, then| this me|
|00000d90| 74 68 6f 64 20 77 69 6c | 6c 20 72 65 73 75 6c 74 |thod wil|l result|
|00000da0| 20 69 6e 20 61 20 72 61 | 74 68 65 72 20 69 6d 70 | in a ra|ther imp|
|00000db0| 6f 72 74 61 6e 74 20 6d | 65 6d 6f 72 79 0a 58 20 |ortant m|emory.X |
|00000dc0| 20 20 20 6c 65 61 6b 2e | 20 54 68 65 72 65 20 61 | leak.| There a|
|00000dd0| 72 65 20 74 77 6f 20 77 | 61 79 73 20 61 72 6f 75 |re two w|ays arou|
|00000de0| 6e 64 20 74 68 69 73 20 | 70 72 6f 62 6c 65 6d 3a |nd this |problem:|
|00000df0| 0a 58 0a 58 20 20 20 20 | 31 29 20 55 70 67 72 61 |.X.X |1) Upgra|
|00000e00| 64 65 20 74 6f 20 50 65 | 72 6c 20 34 2c 20 70 61 |de to Pe|rl 4, pa|
|00000e10| 74 63 68 6c 65 76 65 6c | 20 33 35 20 3a 2d 29 0a |tchlevel| 35 :-).|
|00000e20| 58 0a 58 20 20 20 20 32 | 29 20 57 72 69 74 65 20 |X.X 2|) Write |
|00000e30| 61 20 73 75 62 72 6f 75 | 74 69 6e 65 20 74 68 61 |a subrou|tine tha|
|00000e40| 74 20 63 61 6c 6c 73 20 | 26 64 62 6e 65 78 74 72 |t calls |&dbnextr|
|00000e50| 6f 77 20 61 6e 64 20 73 | 74 6f 72 65 73 20 74 68 |ow and s|tores th|
|00000e60| 65 20 72 65 74 75 72 6e | 65 64 0a 58 20 20 20 20 |e return|ed.X |
|00000e70| 20 20 20 61 72 72 61 79 | 20 74 6f 20 61 20 6c 6f | array| to a lo|
|00000e80| 63 61 6c 20 76 61 72 69 | 61 62 6c 65 2c 20 61 6e |cal vari|able, an|
|00000e90| 64 20 77 68 69 63 68 20 | 69 6e 20 74 75 72 6e 20 |d which |in turn |
|00000ea0| 72 65 74 75 72 6e 73 20 | 74 68 61 74 20 61 72 72 |returns |that arr|
|00000eb0| 61 79 20 74 6f 0a 58 20 | 20 20 20 20 20 20 74 68 |ay to.X | th|
|00000ec0| 65 20 6d 61 69 6e 20 77 | 68 69 6c 65 28 29 20 6c |e main w|hile() l|
|00000ed0| 6f 6f 70 2c 20 6c 69 6b | 65 20 73 6f 3a 0a 58 0a |oop, lik|e so:.X.|
|00000ee0| 58 20 20 20 20 73 75 62 | 20 67 65 74 52 6f 77 0a |X sub| getRow.|
|00000ef0| 58 20 20 20 20 7b 0a 58 | 20 20 20 20 20 20 20 20 |X {.X| |
|00000f00| 6c 6f 63 61 6c 28 40 64 | 61 74 61 29 3b 0a 58 0a |local(@d|ata);.X.|
|00000f10| 58 09 40 64 61 74 61 20 | 3d 20 26 64 62 6e 65 78 |X.@data |= &dbnex|
|00000f20| 74 72 6f 77 3b 0a 58 0a | 58 09 40 64 61 74 61 3b |trow;.X.|X.@data;|
|00000f30| 0a 58 20 20 20 20 7d 0a | 58 0a 58 20 20 20 20 77 |.X }.|X.X w|
|00000f40| 68 69 6c 65 28 40 64 61 | 74 61 20 3d 20 26 67 65 |hile(@da|ta = &ge|
|00000f50| 74 52 6f 77 29 0a 58 20 | 20 20 20 7b 0a 58 20 20 |tRow).X | {.X |
|00000f60| 20 20 20 20 20 65 74 63 | 2e 0a 58 20 20 20 20 7d | etc|..X }|
|00000f70| 0a 58 0a 58 0a 58 20 20 | 20 20 54 68 69 73 20 74 |.X.X.X | This t|
|00000f80| 65 63 68 6e 69 71 75 65 | 20 73 68 6f 75 6c 64 20 |echnique| should |
|00000f90| 6b 65 65 70 20 74 68 65 | 20 6d 65 6d 6f 72 79 20 |keep the| memory |
|00000fa0| 75 73 61 67 65 20 6f 66 | 20 53 79 62 70 65 72 6c |usage of| Sybperl|
|00000fb0| 20 74 6f 20 61 0a 58 20 | 20 20 20 6d 61 6e 61 67 | to a.X | manag|
|00000fc0| 65 61 62 6c 65 20 6c 65 | 76 65 6c 2e 0a 58 0a 58 |eable le|vel..X.X|
|00000fd0| 0a 58 0a 58 0a 58 0a 58 | 0a 58 0a 58 0a 58 20 20 |.X.X.X.X|.X.X.X |
|00000fe0| 20 20 50 6c 65 61 73 65 | 20 6c 65 74 20 6d 65 20 | Please| let me |
|00000ff0| 6b 6e 6f 77 20 69 66 20 | 79 6f 75 20 66 69 6e 64 |know if |you find|
|00001000| 20 61 6e 79 20 6f 74 68 | 65 72 20 70 72 6f 62 6c | any oth|er probl|
|00001010| 65 6d 73 20 77 69 74 68 | 20 53 79 62 70 65 72 6c |ems with| Sybperl|
|00001020| 20 73 6f 0a 58 20 20 20 | 20 74 68 61 74 20 49 20 | so.X | that I |
|00001030| 63 61 6e 20 6c 6f 6f 6b | 20 69 6e 74 6f 20 69 74 |can look| into it|
|00001040| 2e 0a 58 0a 58 20 20 20 | 20 54 68 61 6e 6b 20 79 |..X.X | Thank y|
|00001050| 6f 75 2e 0a 58 0a 58 20 | 20 20 20 4d 69 63 68 61 |ou..X.X | Micha|
|00001060| 65 6c 20 50 65 70 70 6c | 65 72 20 20 20 20 3c 6d |el Peppl|er <m|
|00001070| 70 65 70 70 6c 65 72 40 | 69 74 66 2e 63 68 3e 0a |peppler@|itf.ch>.|
|00001080| 58 0a 58 20 20 20 20 0a | 45 4e 44 5f 4f 46 5f 46 |X.X .|END_OF_F|
|00001090| 49 4c 45 0a 20 20 69 66 | 20 74 65 73 74 20 32 38 |ILE. if| test 28|
|000010a0| 31 38 20 2d 6e 65 20 60 | 77 63 20 2d 63 20 3c 27 |18 -ne `|wc -c <'|
|000010b0| 42 55 47 53 27 60 3b 20 | 74 68 65 6e 0a 20 20 20 |BUGS'`; |then. |
|000010c0| 20 65 63 68 6f 20 73 68 | 61 72 3a 20 5c 22 27 42 | echo sh|ar: \"'B|
|000010d0| 55 47 53 27 5c 22 20 75 | 6e 70 61 63 6b 65 64 20 |UGS'\" u|npacked |
|000010e0| 77 69 74 68 20 77 72 6f | 6e 67 20 73 69 7a 65 21 |with wro|ng size!|
|000010f0| 0a 20 20 66 69 0a 20 20 | 23 20 65 6e 64 20 6f 66 |. fi. |# end of|
|00001100| 20 27 42 55 47 53 27 0a | 66 69 0a 69 66 20 74 65 | 'BUGS'.|fi.if te|
|00001110| 73 74 20 2d 66 20 27 43 | 48 41 4e 47 45 53 27 20 |st -f 'C|HANGES' |
|00001120| 2d 61 20 22 24 7b 31 7d | 22 20 21 3d 20 22 2d 63 |-a "${1}|" != "-c|
|00001130| 22 20 3b 20 74 68 65 6e | 20 0a 20 20 65 63 68 6f |" ; then| . echo|
|00001140| 20 73 68 61 72 3a 20 57 | 69 6c 6c 20 6e 6f 74 20 | shar: W|ill not |
|00001150| 63 6c 6f 62 62 65 72 20 | 65 78 69 73 74 69 6e 67 |clobber |existing|
|00001160| 20 66 69 6c 65 20 5c 22 | 27 43 48 41 4e 47 45 53 | file \"|'CHANGES|
|00001170| 27 5c 22 0a 65 6c 73 65 | 0a 20 20 65 63 68 6f 20 |'\".else|. echo |
|00001180| 73 68 61 72 3a 20 45 78 | 74 72 61 63 74 69 6e 67 |shar: Ex|tracting|
|00001190| 20 5c 22 27 43 48 41 4e | 47 45 53 27 5c 22 20 5c | \"'CHAN|GES'\" \|
|000011a0| 28 31 37 38 32 20 63 68 | 61 72 61 63 74 65 72 73 |(1782 ch|aracters|
|000011b0| 5c 29 0a 20 20 73 65 64 | 20 22 73 2f 5e 58 2f 2f |\). sed| "s/^X//|
|000011c0| 22 20 3e 27 43 48 41 4e | 47 45 53 27 20 3c 3c 27 |" >'CHAN|GES' <<'|
|000011d0| 45 4e 44 5f 4f 46 5f 46 | 49 4c 45 27 0a 58 09 53 |END_OF_F|ILE'.X.S|
|000011e0| 79 62 70 65 72 6c 20 43 | 48 41 4e 47 45 53 3a 0a |ybperl C|HANGES:.|
|000011f0| 58 0a 58 09 31 2e 30 30 | 36 09 41 64 64 65 64 20 |X.X.1.00|6.Added |
|00001200| 63 6f 6e 74 72 69 62 75 | 74 65 64 20 70 61 74 63 |contribu|ted patc|
|00001210| 68 65 73 3a 20 26 64 62 | 77 72 69 74 65 74 65 78 |hes: &db|writetex|
|00001220| 74 28 29 2c 0a 58 09 09 | 26 64 62 73 61 66 65 73 |t(),.X..|&dbsafes|
|00001230| 74 72 28 29 20 61 6e 64 | 20 61 20 6d 6f 64 69 66 |tr() and| a modif|
|00001240| 69 65 64 20 26 64 62 6c | 6f 67 69 6e 28 29 2e 0a |ied &dbl|ogin()..|
|00001250| 58 09 09 41 64 64 65 64 | 20 26 64 62 68 61 73 72 |X..Added| &dbhasr|
|00001260| 65 74 73 74 61 74 73 28 | 29 20 61 6e 64 20 26 64 |etstats(|) and &d|
|00001270| 62 72 65 74 73 74 61 74 | 75 73 28 29 2c 20 61 73 |bretstat|us(), as|
|00001280| 20 77 65 6c 6c 20 61 73 | 0a 58 09 09 73 6f 6d 65 | well as|.X..some|
|00001290| 20 63 61 6c 6c 73 20 74 | 6f 20 44 42 6c 69 62 20 | calls t|o DBlib |
|000012a0| 6d 61 63 72 6f 73 20 73 | 75 63 68 20 61 73 20 44 |macros s|uch as D|
|000012b0| 42 43 4d 44 28 29 2c 0a | 58 09 09 44 42 4d 4f 52 |BCMD(),.|X..DBMOR|
|000012c0| 45 43 4d 44 28 29 2c 20 | 65 74 63 2e 0a 58 09 09 |ECMD(), |etc..X..|
|000012d0| 52 65 63 65 69 76 65 64 | 20 61 20 70 61 74 63 68 |Received| a patch|
|000012e0| 20 74 6f 20 65 67 2f 73 | 70 61 63 65 2e 70 6c 20 | to eg/s|pace.pl |
|000012f0| 66 72 6f 6d 20 57 6f 6c | 66 67 61 6e 67 20 52 69 |from Wol|fgang Ri|
|00001300| 63 68 74 65 72 2e 0a 58 | 09 09 43 6f 64 65 20 74 |chter..X|..Code t|
|00001310| 68 61 74 20 77 61 73 20 | 64 65 66 69 6e 65 64 20 |hat was |defined |
|00001320| 74 6f 20 63 6f 6d 70 69 | 6c 65 20 69 66 20 42 52 |to compi|le if BR|
|00001330| 4f 4b 45 52 5f 44 42 43 | 4d 44 20 77 61 73 0a 58 |OKER_DBC|MD was.X|
|00001340| 09 09 64 65 66 69 6e 65 | 64 20 68 61 73 20 62 65 |..define|d has be|
|00001350| 65 6e 20 72 65 6d 6f 76 | 65 64 2e 20 49 74 20 77 |en remov|ed. It w|
|00001360| 61 73 20 6f 6e 6c 79 20 | 61 20 68 61 63 6b 2c 20 |as only |a hack, |
|00001370| 6d 61 6b 69 6e 67 0a 58 | 09 09 75 73 65 20 6f 66 |making.X|..use of|
|00001380| 20 6b 6e 6f 77 6c 65 64 | 67 65 20 6f 66 20 74 68 | knowled|ge of th|
|00001390| 65 20 73 74 72 75 63 74 | 75 72 65 20 6f 66 20 74 |e struct|ure of t|
|000013a0| 68 65 20 44 42 50 52 4f | 43 45 53 53 0a 58 09 09 |he DBPRO|CESS.X..|
|000013b0| 64 61 74 61 20 74 79 70 | 65 2e 0a 58 09 09 41 64 |data typ|e..X..Ad|
|000013c0| 64 65 64 20 74 68 65 20 | 70 6f 73 73 69 62 69 6c |ded the |possibil|
|000013d0| 69 74 79 20 74 6f 20 72 | 65 74 75 72 6e 20 61 6e |ity to r|eturn an|
|000013e0| 20 61 73 73 6f 63 69 61 | 74 69 76 65 20 61 72 72 | associa|tive arr|
|000013f0| 61 79 0a 58 09 09 66 72 | 6f 6d 20 26 64 62 6e 65 |ay.X..fr|om &dbne|
|00001400| 78 74 72 6f 77 2e 0a 58 | 09 09 41 64 64 65 64 20 |xtrow..X|..Added |
|00001410| 73 75 70 70 6f 72 74 20 | 66 6f 72 20 6e 65 77 20 |support |for new |
|00001420| 64 61 74 61 74 79 70 65 | 73 20 28 53 59 42 52 45 |datatype|s (SYBRE|
|00001430| 41 4c 2c 20 53 59 42 44 | 41 54 45 54 49 4d 45 34 |AL, SYBD|ATETIME4|
|00001440| 29 2e 0a 58 09 09 4e 55 | 4c 4c 20 76 61 6c 75 65 |)..X..NU|LL value|
|00001450| 73 20 72 65 74 72 69 65 | 76 65 64 20 75 73 69 6e |s retrie|ved usin|
|00001460| 67 20 26 64 62 6e 65 78 | 74 72 6f 77 20 63 61 6e |g &dbnex|trow can|
|00001470| 20 62 65 20 72 65 74 75 | 72 6e 65 64 0a 58 09 09 | be retu|rned.X..|
|00001480| 61 73 20 27 75 6e 64 65 | 66 27 20 69 6e 73 74 65 |as 'unde|f' inste|
|00001490| 61 64 20 6f 66 20 27 4e | 55 4c 4c 27 20 28 74 68 |ad of 'N|ULL' (th|
|000014a0| 69 73 20 69 73 20 61 20 | 63 6f 6d 70 69 6c 65 2d |is is a |compile-|
|000014b0| 74 69 6d 65 0a 58 09 09 | 6f 70 74 69 6f 6e 29 2e |time.X..|option).|
|000014c0| 0a 58 09 31 2e 30 30 35 | 20 20 20 53 79 62 70 65 |.X.1.005| Sybpe|
|000014d0| 72 6c 20 77 6f 75 6c 64 | 20 63 6f 72 65 20 64 75 |rl would| core du|
|000014e0| 6d 70 20 69 66 20 79 6f | 75 20 75 73 65 64 20 61 |mp if yo|u used a|
|000014f0| 20 75 6e 69 6e 69 74 69 | 61 6c 69 7a 65 64 0a 58 | uniniti|alized.X|
|00001500| 09 20 20 20 20 20 20 20 | 20 44 42 50 52 4f 43 45 |. | DBPROCE|
|00001510| 53 53 2e 0a 58 09 09 41 | 20 73 6f 6c 75 74 69 6f |SS..X..A| solutio|
|00001520| 6e 20 74 6f 20 74 68 65 | 20 73 6f 6d 65 74 69 6d |n to the| sometim|
|00001530| 65 20 70 61 74 68 6f 6c | 6f 67 69 63 61 6c 09 6d |e pathol|ogical.m|
|00001540| 65 6d 6f 72 79 20 75 73 | 61 67 65 0a 58 09 09 6f |emory us|age.X..o|
|00001550| 62 73 65 72 76 65 64 20 | 77 68 65 6e 20 75 73 69 |bserved |when usi|
|00001560| 6e 67 20 61 20 72 65 6c | 65 61 73 65 20 6f 66 20 |ng a rel|ease of |
|00001570| 50 65 72 6c 20 6c 6f 77 | 65 72 20 74 68 61 6e 20 |Perl low|er than |
|00001580| 34 2e 30 33 35 0a 58 09 | 09 69 73 20 61 6c 73 6f |4.035.X.|.is also|
|00001590| 20 64 65 73 63 72 69 62 | 65 64 20 69 6e 20 42 55 | describ|ed in BU|
|000015a0| 47 53 2e 0a 58 09 09 26 | 64 62 6c 6f 67 69 6e 20 |GS..X..&|dblogin |
|000015b0| 6e 6f 77 20 72 65 74 75 | 72 6e 73 20 2d 31 20 69 |now retu|rns -1 i|
|000015c0| 66 20 74 68 65 20 64 62 | 6c 6f 67 69 6e 28 29 20 |f the db|login() |
|000015d0| 6f 72 20 64 62 6f 70 65 | 6e 28 29 0a 58 09 09 63 |or dbope|n().X..c|
|000015e0| 61 6c 6c 73 20 66 61 69 | 6c 2e 0a 58 09 09 41 64 |alls fai|l..X..Ad|
|000015f0| 64 65 64 20 74 68 65 20 | 70 6f 73 73 69 62 69 6c |ded the |possibil|
|00001600| 69 74 79 20 74 6f 20 6c | 6f 67 69 6e 20 74 6f 20 |ity to l|ogin to |
|00001610| 61 20 73 70 65 63 69 66 | 69 63 20 73 65 72 76 65 |a specif|ic serve|
|00001620| 72 0a 58 09 09 77 69 74 | 68 6f 75 74 20 73 65 74 |r.X..wit|hout set|
|00001630| 74 69 6e 67 20 74 68 65 | 20 44 53 51 55 45 52 59 |ting the| DSQUERY|
|00001640| 20 65 6e 76 69 72 6f 6e | 6d 65 6e 74 20 76 61 72 | environ|ment var|
|00001650| 69 61 62 6c 65 2e 0a 58 | 09 09 41 64 64 65 64 20 |iable..X|..Added |
|00001660| 61 20 73 63 72 69 70 74 | 20 74 6f 20 65 78 74 72 |a script| to extr|
|00001670| 61 63 74 20 74 68 65 20 | 69 6e 66 6f 72 6d 61 74 |act the |informat|
|00001680| 69 6f 6e 20 72 65 67 61 | 72 64 69 6e 67 0a 58 09 |ion rega|rding.X.|
|00001690| 09 74 68 65 20 64 61 74 | 61 62 61 73 65 20 66 72 |.the dat|abase fr|
|000016a0| 6f 6d 20 74 68 65 20 64 | 61 74 61 62 61 73 65 73 |om the d|atabases|
|000016b0| 27 20 73 79 73 74 65 6d | 20 74 61 62 6c 65 73 2e |' system| tables.|
|000016c0| 20 53 65 65 0a 58 09 09 | 65 67 2f 64 62 73 63 68 | See.X..|eg/dbsch|
|000016d0| 65 6d 61 2e 70 6c 2e 0a | 58 09 31 2e 30 30 34 09 |ema.pl..|X.1.004.|
|000016e0| 41 64 64 65 64 20 73 75 | 70 70 6f 72 74 20 66 6f |Added su|pport fo|
|000016f0| 72 20 50 65 72 6c 20 62 | 61 73 65 64 20 65 72 72 |r Perl b|ased err|
|00001700| 6f 72 20 61 6e 64 20 6d | 65 73 73 61 67 65 0a 58 |or and m|essage.X|
|00001710| 09 09 68 61 6e 64 6c 65 | 72 73 20 28 61 73 20 6d |..handle|rs (as m|
|00001720| 61 64 65 20 70 6f 73 73 | 69 62 6c 65 20 62 79 20 |ade poss|ible by |
|00001730| 50 65 72 6c 20 34 2e 30 | 31 38 29 2e 20 4d 61 6e |Perl 4.0|18). Man|
|00001740| 79 20 54 68 61 6e 6b 73 | 0a 58 09 09 74 6f 20 54 |y Thanks|.X..to T|
|00001750| 65 65 6d 75 20 54 6f 72 | 6d 61 20 66 6f 72 20 74 |eemu Tor|ma for t|
|00001760| 68 69 73 20 63 6f 64 65 | 2e 0a 58 09 09 41 64 64 |his code|..X..Add|
|00001770| 65 64 20 6c 69 6d 69 74 | 65 64 20 73 75 70 70 6f |ed limit|ed suppo|
|00001780| 72 74 20 66 6f 72 20 53 | 59 42 54 45 58 54 20 64 |rt for S|YBTEXT d|
|00001790| 61 74 61 74 79 70 65 73 | 2e 0a 58 09 09 41 64 64 |atatypes|..X..Add|
|000017a0| 65 64 20 26 64 62 73 74 | 72 63 70 79 28 29 20 74 |ed &dbst|rcpy() t|
|000017b0| 6f 20 72 65 74 72 69 65 | 76 65 20 74 68 65 20 63 |o retrie|ve the c|
|000017c0| 75 72 72 65 6e 74 20 63 | 6f 6d 6d 61 6e 64 20 62 |urrent c|ommand b|
|000017d0| 75 66 66 65 72 2e 0a 58 | 09 09 54 68 65 20 44 42 |uffer..X|..The DB|
|000017e0| 50 52 4f 43 45 53 53 20 | 70 61 72 61 6d 65 74 65 |PROCESS |paramete|
|000017f0| 72 20 74 6f 20 6d 6f 73 | 74 20 26 64 62 2a 28 29 |r to mos|t &db*()|
|00001800| 20 63 61 6c 6c 73 20 63 | 61 6e 20 6e 6f 77 0a 58 | calls c|an now.X|
|00001810| 09 09 62 65 20 6f 6d 69 | 74 74 65 64 3a 20 69 74 |..be omi|tted: it|
|00001820| 20 77 69 6c 6c 20 64 65 | 66 61 75 6c 74 20 74 6f | will de|fault to|
|00001830| 20 74 68 65 20 66 69 72 | 73 74 20 44 42 50 52 4f | the fir|st DBPRO|
|00001840| 43 45 53 53 0a 58 09 09 | 6f 70 65 6e 65 64 20 28 |CESS.X..|opened (|
|00001850| 74 68 65 20 6f 6e 65 20 | 74 68 61 74 20 69 73 20 |the one |that is |
|00001860| 72 65 74 75 72 6e 65 64 | 20 62 79 20 26 64 62 6c |returned| by &dbl|
|00001870| 6f 67 69 6e 28 29 29 2e | 0a 58 09 09 41 64 64 65 |ogin()).|.X..Adde|
|00001880| 64 20 6c 69 62 2f 73 79 | 62 64 62 2e 70 68 0a 58 |d lib/sy|bdb.ph.X|
|00001890| 09 09 41 64 64 65 64 20 | 61 20 63 6f 75 70 6c 65 |..Added |a couple|
|000018a0| 20 6f 66 20 65 78 61 6d | 70 6c 65 20 73 63 72 69 | of exam|ple scri|
|000018b0| 70 74 73 20 69 6e 20 65 | 67 2f 2a 2e 70 6c 2c 20 |pts in e|g/*.pl, |
|000018c0| 63 6f 75 72 74 65 73 79 | 0a 58 09 09 6f 66 20 47 |courtesy|.X..of G|
|000018d0| 69 6a 73 20 4d 6f 73 20 | 28 54 68 61 6e 6b 20 59 |ijs Mos |(Thank Y|
|000018e0| 6f 75 21 29 2e 0a 58 09 | 31 2e 30 30 33 09 42 61 |ou!)..X.|1.003.Ba|
|000018f0| 73 65 20 76 65 72 73 69 | 6f 6e 2e 0a 58 0a 45 4e |se versi|on..X.EN|
|00001900| 44 5f 4f 46 5f 46 49 4c | 45 0a 20 20 69 66 20 74 |D_OF_FIL|E. if t|
|00001910| 65 73 74 20 31 37 38 32 | 20 2d 6e 65 20 60 77 63 |est 1782| -ne `wc|
|00001920| 20 2d 63 20 3c 27 43 48 | 41 4e 47 45 53 27 60 3b | -c <'CH|ANGES'`;|
|00001930| 20 74 68 65 6e 0a 20 20 | 20 20 65 63 68 6f 20 73 | then. | echo s|
|00001940| 68 61 72 3a 20 5c 22 27 | 43 48 41 4e 47 45 53 27 |har: \"'|CHANGES'|
|00001950| 5c 22 20 75 6e 70 61 63 | 6b 65 64 20 77 69 74 68 |\" unpac|ked with|
|00001960| 20 77 72 6f 6e 67 20 73 | 69 7a 65 21 0a 20 20 66 | wrong s|ize!. f|
|00001970| 69 0a 20 20 23 20 65 6e | 64 20 6f 66 20 27 43 48 |i. # en|d of 'CH|
|00001980| 41 4e 47 45 53 27 0a 66 | 69 0a 69 66 20 74 65 73 |ANGES'.f|i.if tes|
|00001990| 74 20 2d 66 20 27 50 41 | 43 4b 49 4e 47 2e 4c 53 |t -f 'PA|CKING.LS|
|000019a0| 54 27 20 2d 61 20 22 24 | 7b 31 7d 22 20 21 3d 20 |T' -a "$|{1}" != |
|000019b0| 22 2d 63 22 20 3b 20 74 | 68 65 6e 20 0a 20 20 65 |"-c" ; t|hen . e|
|000019c0| 63 68 6f 20 73 68 61 72 | 3a 20 57 69 6c 6c 20 6e |cho shar|: Will n|
|000019d0| 6f 74 20 63 6c 6f 62 62 | 65 72 20 65 78 69 73 74 |ot clobb|er exist|
|000019e0| 69 6e 67 20 66 69 6c 65 | 20 5c 22 27 50 41 43 4b |ing file| \"'PACK|
|000019f0| 49 4e 47 2e 4c 53 54 27 | 5c 22 0a 65 6c 73 65 0a |ING.LST'|\".else.|
|00001a00| 20 20 65 63 68 6f 20 73 | 68 61 72 3a 20 45 78 74 | echo s|har: Ext|
|00001a10| 72 61 63 74 69 6e 67 20 | 5c 22 27 50 41 43 4b 49 |racting |\"'PACKI|
|00001a20| 4e 47 2e 4c 53 54 27 5c | 22 20 5c 28 31 31 37 35 |NG.LST'\|" \(1175|
|00001a30| 20 63 68 61 72 61 63 74 | 65 72 73 5c 29 0a 20 20 | charact|ers\). |
|00001a40| 73 65 64 20 22 73 2f 5e | 58 2f 2f 22 20 3e 27 50 |sed "s/^|X//" >'P|
|00001a50| 41 43 4b 49 4e 47 2e 4c | 53 54 27 20 3c 3c 27 45 |ACKING.L|ST' <<'E|
|00001a60| 4e 44 5f 4f 46 5f 46 49 | 4c 45 27 0a 58 0a 58 0a |ND_OF_FI|LE'.X.X.|
|00001a70| 58 09 0a 58 09 54 68 65 | 20 53 79 62 70 65 72 6c |X..X.The| Sybperl|
|00001a80| 20 70 61 63 6b 61 67 65 | 20 73 68 6f 75 6c 64 20 | package| should |
|00001a90| 63 6f 6e 74 61 69 6e 20 | 74 68 65 20 66 6f 6c 6c |contain |the foll|
|00001aa0| 6f 77 69 6e 67 20 66 69 | 6c 65 73 3a 0a 58 0a 58 |owing fi|les:.X.X|
|00001ab0| 0a 58 09 20 20 20 20 50 | 41 43 4b 49 4e 47 2e 4c |.X. P|ACKING.L|
|00001ac0| 53 54 09 20 20 20 20 54 | 68 69 73 20 66 69 6c 65 |ST. T|his file|
|00001ad0| 0a 58 09 20 20 20 20 52 | 45 41 44 4d 45 09 20 20 |.X. R|EADME. |
|00001ae0| 20 20 52 65 61 64 20 4d | 65 21 0a 58 09 20 20 20 | Read M|e!.X. |
|00001af0| 20 42 55 47 53 09 20 20 | 20 20 50 65 72 6c 2f 44 | BUGS. | Perl/D|
|00001b00| 42 2d 6c 69 62 72 61 72 | 79 20 69 6e 63 6f 6d 70 |B-librar|y incomp|
|00001b10| 61 74 69 62 69 6c 69 74 | 79 20 64 65 73 63 72 69 |atibilit|y descri|
|00001b20| 70 74 69 6f 6e 0a 58 09 | 20 20 20 20 43 48 41 4e |ption.X.| CHAN|
|00001b30| 47 45 53 0a 58 09 20 20 | 20 20 4d 61 6b 65 66 69 |GES.X. | Makefi|
|00001b40| 6c 65 0a 58 09 20 20 20 | 20 73 79 62 70 65 72 6c |le.X. | sybperl|
|00001b50| 2e 63 09 20 20 20 20 53 | 79 62 70 65 72 6c 20 73 |.c. S|ybperl s|
|00001b60| 6f 75 72 63 65 0a 58 09 | 20 20 20 20 73 79 62 70 |ource.X.| sybp|
|00001b70| 65 72 6c 2e 31 09 20 20 | 20 20 4d 61 6e 20 70 61 |erl.1. | Man pa|
|00001b80| 67 65 0a 58 09 20 20 20 | 20 70 61 74 63 68 6c 65 |ge.X. | patchle|
|00001b90| 76 65 6c 2e 68 0a 58 09 | 20 20 20 20 74 2f 73 62 |vel.h.X.| t/sb|
|00001ba0| 65 78 2e 70 6c 09 20 20 | 20 20 45 78 61 6d 70 6c |ex.pl. | Exampl|
|00001bb0| 65 20 6f 66 20 73 79 62 | 70 65 72 6c 20 73 63 72 |e of syb|perl scr|
|00001bc0| 69 70 74 0a 58 09 20 20 | 20 20 6c 69 62 2f 73 79 |ipt.X. | lib/sy|
|00001bd0| 62 70 65 72 6c 2e 70 6c | 20 20 41 20 50 65 72 6c |bperl.pl| A Perl|
|00001be0| 20 6c 69 62 72 61 72 79 | 20 66 69 6c 65 2e 0a 58 | library| file..X|
|00001bf0| 09 20 20 20 20 6c 69 62 | 2f 73 79 62 64 62 2e 70 |. lib|/sybdb.p|
|00001c00| 68 20 20 20 20 53 6f 6d | 65 20 6f 66 20 74 68 65 |h Som|e of the|
|00001c10| 20 44 42 2d 4c 69 62 72 | 61 72 79 20 69 6e 63 6c | DB-Libr|ary incl|
|00001c20| 75 64 65 20 66 69 6c 65 | 73 2c 20 72 75 6e 0a 58 |ude file|s, run.X|
|00001c30| 09 09 09 20 20 20 20 74 | 68 72 6f 75 67 68 20 68 |... t|hrough h|
|00001c40| 32 70 68 2e 0a 58 09 20 | 20 20 20 65 67 2f 73 70 |2ph..X. | eg/sp|
|00001c50| 61 63 65 2e 70 6c 09 20 | 20 20 20 48 6f 77 20 6d |ace.pl. | How m|
|00001c60| 75 63 68 20 73 70 61 63 | 65 20 64 6f 65 73 20 79 |uch spac|e does y|
|00001c70| 6f 75 72 20 73 79 62 61 | 73 65 20 64 61 74 61 62 |our syba|se datab|
|00001c80| 61 73 65 73 20 75 73 65 | 3f 0a 58 09 20 20 20 20 |ases use|?.X. |
|00001c90| 65 67 2f 63 61 70 74 75 | 72 65 2e 70 6c 20 20 20 |eg/captu|re.pl |
|00001ca0| 43 72 65 61 74 65 20 61 | 20 74 61 62 6c 65 20 65 |Create a| table e|
|00001cb0| 78 74 72 61 63 74 65 64 | 20 66 72 6f 6d 20 2f 65 |xtracted| from /e|
|00001cc0| 74 63 2f 70 61 73 73 77 | 64 0a 58 09 20 20 20 20 |tc/passw|d.X. |
|00001cd0| 65 67 2f 72 65 70 6f 72 | 74 2e 70 6c 20 20 20 20 |eg/repor|t.pl |
|00001ce0| 52 65 70 6f 72 74 20 66 | 72 6f 6d 20 74 61 62 6c |Report f|rom tabl|
|00001cf0| 65 20 63 72 65 61 74 65 | 64 20 62 79 20 63 61 70 |e create|d by cap|
|00001d00| 74 75 72 65 2e 70 6c 0a | 58 09 20 20 20 20 65 67 |ture.pl.|X. eg|
|00001d10| 2f 73 71 6c 2e 70 6c 09 | 20 20 20 20 55 74 69 6c |/sql.pl.| Util|
|00001d20| 69 74 79 20 72 6f 75 74 | 69 6e 65 73 20 75 73 65 |ity rout|ines use|
|00001d30| 64 20 62 79 20 74 68 65 | 20 61 62 6f 76 65 20 65 |d by the| above e|
|00001d40| 78 61 6d 70 6c 65 20 70 | 72 6f 67 72 61 6d 73 2e |xample p|rograms.|
|00001d50| 0a 58 0a 58 09 20 20 20 | 20 65 67 2f 64 62 74 65 |.X.X. | eg/dbte|
|00001d60| 78 74 2e 70 6c 20 20 20 | 20 45 78 61 6d 70 6c 65 |xt.pl | Example|
|00001d70| 20 6f 66 20 26 64 62 77 | 72 69 74 65 74 65 78 74 | of &dbw|ritetext|
|00001d80| 28 29 20 75 73 61 67 65 | 2e 20 54 68 69 73 0a 58 |() usage|. This.X|
|00001d90| 09 09 09 20 20 20 20 73 | 63 72 69 70 74 20 77 69 |... s|cript wi|
|00001da0| 6c 6c 20 4e 4f 54 20 77 | 6f 72 6b 20 6f 75 74 20 |ll NOT w|ork out |
|00001db0| 6f 66 20 74 68 65 20 62 | 6f 78 2e 20 52 65 61 64 |of the b|ox. Read|
|00001dc0| 0a 58 09 09 09 20 20 20 | 20 74 68 65 20 63 6f 64 |.X... | the cod|
|00001dd0| 65 20 74 6f 20 73 65 65 | 20 77 68 61 74 20 72 65 |e to see| what re|
|00001de0| 71 75 69 72 65 73 20 64 | 6f 69 6e 67 20 66 69 72 |quires d|oing fir|
|00001df0| 73 74 2e 0a 58 0a 58 09 | 20 20 20 20 65 67 2f 64 |st..X.X.| eg/d|
|00001e00| 62 73 63 68 65 6d 61 2e | 70 6c 20 20 43 72 65 61 |bschema.|pl Crea|
|00001e10| 74 65 20 61 6e 20 49 73 | 71 6c 20 73 63 72 69 70 |te an Is|ql scrip|
|00001e20| 74 20 74 68 61 74 20 77 | 69 6c 6c 20 74 6f 0a 58 |t that w|ill to.X|
|00001e30| 09 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 |. | |
|00001e40| 20 20 20 20 20 72 65 63 | 72 65 61 74 65 20 79 6f | rec|reate yo|
|00001e50| 75 72 20 64 61 74 61 62 | 61 73 65 28 73 29 20 73 |ur datab|ase(s) s|
|00001e60| 74 72 75 63 74 75 72 65 | 20 28 64 61 74 61 0a 58 |tructure| (data.X|
|00001e70| 09 09 09 20 20 20 20 74 | 79 70 65 73 2c 20 74 61 |... t|ypes, ta|
|00001e80| 62 6c 65 73 2c 20 69 6e | 64 65 78 65 73 2c 20 72 |bles, in|dexes, r|
|00001e90| 75 6c 65 73 2c 20 64 65 | 66 61 75 6c 74 73 2c 0a |ules, de|faults,.|
|00001ea0| 58 09 09 09 20 20 20 20 | 76 69 65 77 73 2c 20 74 |X... |views, t|
|00001eb0| 72 69 67 67 65 72 73 20 | 61 6e 64 20 73 74 6f 72 |riggers |and stor|
|00001ec0| 65 64 20 70 72 6f 63 65 | 64 75 72 65 73 29 2c 0a |ed proce|dures),.|
|00001ed0| 58 09 09 09 20 20 20 20 | 65 78 74 72 61 63 74 69 |X... |extracti|
|00001ee0| 6e 67 20 74 68 65 20 69 | 6e 66 6f 72 6d 61 74 69 |ng the i|nformati|
|00001ef0| 6f 6e 20 66 72 6f 6d 20 | 74 68 65 0a 58 09 09 09 |on from |the.X...|
|00001f00| 20 20 20 20 64 61 74 61 | 62 61 73 65 27 73 20 73 | data|base's s|
|00001f10| 79 73 74 65 6d 20 74 61 | 62 6c 65 73 2e 0a 58 09 |ystem ta|bles..X.|
|00001f20| 20 20 20 20 0a 45 4e 44 | 5f 4f 46 5f 46 49 4c 45 | .END|_OF_FILE|
|00001f30| 0a 20 20 69 66 20 74 65 | 73 74 20 31 31 37 35 20 |. if te|st 1175 |
|00001f40| 2d 6e 65 20 60 77 63 20 | 2d 63 20 3c 27 50 41 43 |-ne `wc |-c <'PAC|
|00001f50| 4b 49 4e 47 2e 4c 53 54 | 27 60 3b 20 74 68 65 6e |KING.LST|'`; then|
|00001f60| 0a 20 20 20 20 65 63 68 | 6f 20 73 68 61 72 3a 20 |. ech|o shar: |
|00001f70| 5c 22 27 50 41 43 4b 49 | 4e 47 2e 4c 53 54 27 5c |\"'PACKI|NG.LST'\|
|00001f80| 22 20 75 6e 70 61 63 6b | 65 64 20 77 69 74 68 20 |" unpack|ed with |
|00001f90| 77 72 6f 6e 67 20 73 69 | 7a 65 21 0a 20 20 66 69 |wrong si|ze!. fi|
|00001fa0| 0a 20 20 23 20 65 6e 64 | 20 6f 66 20 27 50 41 43 |. # end| of 'PAC|
|00001fb0| 4b 49 4e 47 2e 4c 53 54 | 27 0a 66 69 0a 69 66 20 |KING.LST|'.fi.if |
|00001fc0| 74 65 73 74 20 2d 66 20 | 27 65 67 2f 52 45 41 44 |test -f |'eg/READ|
|00001fd0| 4d 45 27 20 2d 61 20 22 | 24 7b 31 7d 22 20 21 3d |ME' -a "|${1}" !=|
|00001fe0| 20 22 2d 63 22 20 3b 20 | 74 68 65 6e 20 0a 20 20 | "-c" ; |then . |
|00001ff0| 65 63 68 6f 20 73 68 61 | 72 3a 20 57 69 6c 6c 20 |echo sha|r: Will |
|00002000| 6e 6f 74 20 63 6c 6f 62 | 62 65 72 20 65 78 69 73 |not clob|ber exis|
|00002010| 74 69 6e 67 20 66 69 6c | 65 20 5c 22 27 65 67 2f |ting fil|e \"'eg/|
|00002020| 52 45 41 44 4d 45 27 5c | 22 0a 65 6c 73 65 0a 20 |README'\|".else. |
|00002030| 20 65 63 68 6f 20 73 68 | 61 72 3a 20 45 78 74 72 | echo sh|ar: Extr|
|00002040| 61 63 74 69 6e 67 20 5c | 22 27 65 67 2f 52 45 41 |acting \|"'eg/REA|
|00002050| 44 4d 45 27 5c 22 20 5c | 28 31 37 34 31 20 63 68 |DME'\" \|(1741 ch|
|00002060| 61 72 61 63 74 65 72 73 | 5c 29 0a 20 20 73 65 64 |aracters|\). sed|
|00002070| 20 22 73 2f 5e 58 2f 2f | 22 20 3e 27 65 67 2f 52 | "s/^X//|" >'eg/R|
|00002080| 45 41 44 4d 45 27 20 3c | 3c 27 45 4e 44 5f 4f 46 |EADME' <|<'END_OF|
|00002090| 5f 46 49 4c 45 27 0a 58 | 09 40 28 23 29 52 45 41 |_FILE'.X|.@(#)REA|
|000020a0| 44 4d 45 09 31 2e 34 09 | 34 2f 32 2f 39 33 0a 58 |DME.1.4.|4/2/93.X|
|000020b0| 0a 58 0a 58 20 20 20 20 | 54 68 69 73 20 64 69 72 |.X.X |This dir|
|000020c0| 65 63 74 6f 72 79 20 63 | 6f 6e 74 61 69 6e 73 20 |ectory c|ontains |
|000020d0| 61 20 6e 75 6d 62 65 72 | 20 6f 66 20 65 78 61 6d |a number| of exam|
|000020e0| 70 6c 65 20 73 63 72 69 | 70 74 73 20 66 6f 72 20 |ple scri|pts for |
|000020f0| 53 79 62 70 65 72 6c 2e | 0a 58 0a 58 0a 58 20 20 |Sybperl.|.X.X.X |
|00002100| 20 20 0a 58 20 20 20 20 | 73 70 61 63 65 2e 70 6c | .X |space.pl|
|00002110| 09 09 52 65 70 6f 72 74 | 20 74 68 65 20 73 70 61 |..Report| the spa|
|00002120| 63 65 20 75 73 65 64 20 | 62 79 20 79 6f 75 72 20 |ce used |by your |
|00002130| 64 61 74 61 62 61 73 65 | 2e 0a 58 20 20 20 20 63 |database|..X c|
|00002140| 61 70 74 75 72 65 2e 70 | 6c 09 09 43 72 65 61 74 |apture.p|l..Creat|
|00002150| 65 20 61 20 74 61 62 6c | 65 20 77 69 74 68 20 69 |e a tabl|e with i|
|00002160| 6e 66 6f 72 6d 61 74 69 | 6f 6e 20 66 72 6f 6d 0a |nformati|on from.|
|00002170| 58 09 09 09 2f 65 74 63 | 2f 70 61 73 73 77 64 2e |X.../etc|/passwd.|
|00002180| 0a 58 20 20 20 20 72 65 | 70 6f 72 74 2e 70 6c 09 |.X re|port.pl.|
|00002190| 09 52 65 70 6f 72 74 20 | 69 6e 66 6f 72 6d 61 74 |.Report |informat|
|000021a0| 69 6f 6e 20 66 72 6f 6d | 20 74 68 65 20 61 62 6f |ion from| the abo|
|000021b0| 76 65 20 74 61 62 6c 65 | 2e 0a 58 20 20 20 20 73 |ve table|..X s|
|000021c0| 71 6c 2e 70 6c 09 09 55 | 74 69 6c 69 74 79 20 75 |ql.pl..U|tility u|
|000021d0| 73 65 64 20 62 79 20 74 | 68 65 20 61 62 6f 76 65 |sed by t|he above|
|000021e0| 20 74 68 72 65 65 20 73 | 63 72 69 70 74 73 2e 0a | three s|cripts..|
|000021f0| 58 20 20 20 20 64 62 73 | 63 68 65 6d 61 2e 70 6c |X dbs|chema.pl|
|00002200| 09 09 45 78 74 72 61 63 | 74 20 61 6e 20 49 73 71 |..Extrac|t an Isq|
|00002210| 6c 20 73 63 72 69 70 74 | 20 74 6f 20 72 65 2d 63 |l script| to re-c|
|00002220| 72 65 61 74 65 20 61 20 | 64 61 74 61 62 61 73 65 |reate a |database|
|00002230| 0a 58 20 20 20 20 64 62 | 74 65 78 74 2e 70 6c 09 |.X db|text.pl.|
|00002240| 09 41 20 76 65 72 79 20 | 73 69 6d 70 6c 65 20 65 |.A very |simple e|
|00002250| 78 61 6d 70 6c 65 20 6f | 66 20 75 73 61 67 65 20 |xample o|f usage |
|00002260| 6f 66 20 64 62 77 72 69 | 74 65 74 65 78 74 2e 0a |of dbwri|tetext..|
|00002270| 58 09 09 09 52 65 61 64 | 20 74 68 65 20 63 6f 64 |X...Read| the cod|
|00002280| 65 20 62 65 66 6f 72 65 | 20 75 73 69 6e 67 21 0a |e before| using!.|
|00002290| 58 0a 58 0a 58 20 20 20 | 20 0a 58 20 20 20 20 44 |X.X.X | .X D|
|000022a0| 62 73 63 68 65 6d 61 2e | 70 6c 20 44 6f 63 75 6d |bschema.|pl Docum|
|000022b0| 65 6e 74 61 74 69 6f 6e | 3a 0a 58 20 20 20 20 2d |entation|:.X -|
|000022c0| 2d 2d 2d 2d 2d 2d 2d 2d | 2d 2d 2d 2d 2d 2d 2d 2d |--------|--------|
|000022d0| 2d 2d 2d 2d 2d 2d 2d 2d | 2d 0a 58 20 20 20 20 0a |--------|-.X .|
|000022e0| 58 20 20 20 20 54 68 69 | 73 20 69 73 20 61 20 53 |X Thi|s is a S|
|000022f0| 79 62 70 65 72 6c 20 73 | 63 72 69 70 74 20 74 68 |ybperl s|cript th|
|00002300| 61 74 20 65 78 74 72 61 | 63 74 73 20 61 20 53 79 |at extra|cts a Sy|
|00002310| 62 61 73 65 20 64 61 74 | 61 62 61 73 65 20 64 65 |base dat|abase de|
|00002320| 66 69 6e 69 74 69 6f 6e | 0a 58 20 20 20 20 61 6e |finition|.X an|
|00002330| 64 20 63 72 65 61 74 65 | 73 20 61 6e 20 49 73 71 |d create|s an Isq|
|00002340| 6c 20 73 63 72 69 70 74 | 20 74 6f 20 72 65 62 75 |l script| to rebu|
|00002350| 69 6c 64 20 74 68 65 20 | 64 61 74 61 62 61 73 65 |ild the |database|
|00002360| 2e 0a 58 0a 58 20 20 20 | 20 64 62 73 63 68 65 6d |..X.X | dbschem|
|00002370| 61 2e 70 6c 20 69 73 20 | 4e 4f 54 20 61 20 70 72 |a.pl is |NOT a pr|
|00002380| 6f 64 75 63 74 69 6f 6e | 20 73 63 72 69 70 74 2c |oduction| script,|
|00002390| 20 69 6e 20 74 68 65 20 | 73 65 6e 73 65 20 74 68 | in the |sense th|
|000023a0| 61 74 20 69 74 20 64 6f | 65 73 0a 58 20 20 20 20 |at it do|es.X |
|000023b0| 6e 6f 74 20 64 6f 20 41 | 4c 4c 20 74 68 65 20 6e |not do A|LL the n|
|000023c0| 65 63 65 73 73 61 72 79 | 20 77 6f 72 6b 2e 20 54 |ecessary| work. T|
|000023d0| 68 65 20 73 63 72 69 70 | 74 20 74 72 69 65 73 20 |he scrip|t tries |
|000023e0| 74 6f 20 64 6f 20 74 68 | 65 20 72 69 67 68 74 0a |to do th|e right.|
|000023f0| 58 20 20 20 20 74 68 69 | 6e 67 2c 20 62 75 74 20 |X thi|ng, but |
|00002400| 69 6e 20 63 65 72 74 61 | 69 6e 20 63 61 73 65 73 |in certa|in cases|
|00002410| 20 28 6d 61 69 6e 6c 79 | 20 77 68 65 72 65 20 74 | (mainly| where t|
|00002420| 68 65 20 6f 77 6e 65 72 | 20 6f 66 20 61 6e 20 6f |he owner| of an o|
|00002430| 62 6a 65 63 74 0a 58 20 | 20 20 20 69 73 20 6e 6f |bject.X | is no|
|00002440| 74 20 74 68 65 20 44 42 | 4f 29 20 69 74 20 63 72 |t the DB|O) it cr|
|00002450| 65 61 74 65 73 20 61 6e | 20 69 6e 76 61 6c 69 64 |eates an| invalid|
|00002460| 20 6f 72 20 69 6e 63 6f | 72 72 65 63 74 20 49 73 | or inco|rrect Is|
|00002470| 71 6c 20 63 6f 6d 6d 61 | 6e 64 2e 20 49 0a 58 20 |ql comma|nd. I.X |
|00002480| 20 20 20 68 61 76 65 20 | 74 72 69 65 64 20 74 6f | have |tried to|
|00002490| 20 64 65 74 65 63 74 20 | 74 68 65 73 65 20 63 61 | detect |these ca|
|000024a0| 73 65 73 2c 20 61 6e 64 | 20 6c 6f 67 20 74 68 65 |ses, and| log the|
|000024b0| 6d 20 62 6f 74 68 20 74 | 6f 20 73 74 64 6f 75 74 |m both t|o stdout|
|000024c0| 20 61 6e 64 20 74 6f 20 | 61 0a 58 20 20 20 20 66 | and to |a.X f|
|000024d0| 69 6c 65 2c 20 73 6f 20 | 74 68 61 74 20 74 68 65 |ile, so |that the|
|000024e0| 20 73 63 72 69 70 74 20 | 63 61 6e 20 62 65 20 63 | script |can be c|
|000024f0| 6f 72 72 65 63 74 65 64 | 2e 0a 58 20 20 20 20 50 |orrected|..X P|
|00002500| 6c 65 61 73 65 20 6e 6f | 74 65 20 61 6c 73 6f 20 |lease no|te also |
|00002510| 74 68 61 74 20 64 62 73 | 63 68 65 6d 61 2e 70 6c |that dbs|chema.pl|
|00002520| 20 6c 6f 67 73 20 69 6e | 20 74 6f 20 53 79 62 61 | logs in| to Syba|
|00002530| 73 65 20 77 69 74 68 20 | 74 68 65 0a 58 20 20 20 |se with |the.X |
|00002540| 20 64 65 66 61 75 6c 74 | 20 28 55 6e 69 78 29 20 | default| (Unix) |
|00002550| 75 73 65 72 20 69 64 2c | 20 61 6e 64 20 61 20 4e |user id,| and a N|
|00002560| 55 4c 4c 20 70 61 73 73 | 77 6f 72 64 2e 20 54 68 |ULL pass|word. Th|
|00002570| 69 73 20 62 65 68 61 76 | 69 6f 75 72 20 69 73 0a |is behav|iour is.|
|00002580| 58 20 20 20 20 6d 61 79 | 62 65 20 6e 6f 74 20 4f |X may|be not O|
|00002590| 4b 20 66 6f 72 20 79 6f | 75 72 20 73 69 74 65 2e |K for yo|ur site.|
|000025a0| 0a 58 0a 58 20 20 20 20 | 55 73 61 67 65 3a 0a 58 |.X.X |Usage:.X|
|000025b0| 0a 58 20 20 20 20 09 69 | 74 66 31 25 20 64 62 73 |.X .i|tf1% dbs|
|000025c0| 63 68 65 6d 61 2e 70 6c | 20 2d 64 20 65 78 63 61 |chema.pl| -d exca|
|000025d0| 6c 69 62 75 72 20 2d 6f | 20 65 78 63 61 6c 69 62 |libur -o| excalib|
|000025e0| 75 72 2e 69 73 71 6c 20 | 2d 76 0a 58 0a 58 20 20 |ur.isql |-v.X.X |
|000025f0| 20 20 52 75 6e 20 64 62 | 73 63 68 65 6d 61 20 6f | Run db|schema o|
|00002600| 6e 20 64 61 74 61 62 61 | 73 65 20 27 65 78 63 61 |n databa|se 'exca|
|00002610| 6c 69 62 75 72 27 2c 20 | 70 6c 61 63 65 20 74 68 |libur', |place th|
|00002620| 65 20 72 65 73 75 6c 74 | 69 6e 67 20 73 63 72 69 |e result|ing scri|
|00002630| 70 74 0a 58 20 20 20 20 | 69 6e 20 27 65 78 63 61 |pt.X |in 'exca|
|00002640| 6c 69 62 75 72 2e 69 73 | 71 6c 27 20 28 61 6e 64 |libur.is|ql' (and|
|00002650| 20 74 68 65 20 65 72 72 | 6f 72 20 6c 6f 67 20 69 | the err|or log i|
|00002660| 6e 20 27 65 78 63 61 6c | 69 62 75 72 2e 69 73 71 |n 'excal|ibur.isq|
|00002670| 6c 2e 6c 6f 67 27 29 0a | 58 20 20 20 20 61 6e 64 |l.log').|X and|
|00002680| 20 74 75 72 6e 20 6f 6e | 20 76 65 72 62 6f 73 65 | turn on| verbose|
|00002690| 20 6f 75 74 70 75 74 20 | 6f 6e 20 74 68 65 20 63 | output |on the c|
|000026a0| 6f 6e 73 6f 6c 65 2e 20 | 54 68 65 20 64 65 66 61 |onsole. |The defa|
|000026b0| 75 6c 74 20 64 61 74 61 | 62 61 73 65 20 69 73 0a |ult data|base is.|
|000026c0| 58 20 20 20 20 27 6d 61 | 73 74 65 72 27 2c 20 74 |X 'ma|ster', t|
|000026d0| 68 65 20 64 65 66 61 75 | 6c 74 20 6f 75 74 70 75 |he defau|lt outpu|
|000026e0| 74 20 66 69 6c 65 20 69 | 73 20 27 73 63 72 69 70 |t file i|s 'scrip|
|000026f0| 74 2e 69 73 71 6c 27 2e | 0a 58 0a 58 0a 58 20 20 |t.isql'.|.X.X.X |
|00002700| 20 20 49 20 68 6f 70 65 | 20 74 68 69 73 20 77 69 | I hope| this wi|
|00002710| 6c 6c 20 70 72 6f 76 65 | 20 6f 66 20 73 6f 6d 65 |ll prove| of some|
|00002720| 20 75 73 65 2c 20 61 6e | 64 20 49 20 77 6f 75 6c | use, an|d I woul|
|00002730| 64 20 62 65 20 6d 6f 72 | 65 20 74 68 61 6e 20 68 |d be mor|e than h|
|00002740| 61 70 70 79 0a 58 20 20 | 20 20 74 6f 20 68 65 61 |appy.X | to hea|
|00002750| 72 20 6f 66 20 61 6e 79 | 20 69 6d 70 72 6f 76 65 |r of any| improve|
|00002760| 6d 65 6e 74 73 20 3a 2d | 29 0a 58 0a 58 0a 58 20 |ments :-|).X.X.X |
|00002770| 20 20 20 4d 69 63 68 61 | 65 6c 20 50 65 70 70 6c | Micha|el Peppl|
|00002780| 65 72 09 09 6d 70 65 70 | 70 6c 65 72 40 69 74 66 |er..mpep|pler@itf|
|00002790| 2e 63 68 0a 58 0a 45 4e | 44 5f 4f 46 5f 46 49 4c |.ch.X.EN|D_OF_FIL|
|000027a0| 45 0a 20 20 69 66 20 74 | 65 73 74 20 31 37 34 31 |E. if t|est 1741|
|000027b0| 20 2d 6e 65 20 60 77 63 | 20 2d 63 20 3c 27 65 67 | -ne `wc| -c <'eg|
|000027c0| 2f 52 45 41 44 4d 45 27 | 60 3b 20 74 68 65 6e 0a |/README'|`; then.|
|000027d0| 20 20 20 20 65 63 68 6f | 20 73 68 61 72 3a 20 5c | echo| shar: \|
|000027e0| 22 27 65 67 2f 52 45 41 | 44 4d 45 27 5c 22 20 75 |"'eg/REA|DME'\" u|
|000027f0| 6e 70 61 63 6b 65 64 20 | 77 69 74 68 20 77 72 6f |npacked |with wro|
|00002800| 6e 67 20 73 69 7a 65 21 | 0a 20 20 66 69 0a 20 20 |ng size!|. fi. |
|00002810| 23 20 65 6e 64 20 6f 66 | 20 27 65 67 2f 52 45 41 |# end of| 'eg/REA|
|00002820| 44 4d 45 27 0a 66 69 0a | 69 66 20 74 65 73 74 20 |DME'.fi.|if test |
|00002830| 2d 66 20 27 65 67 2f 63 | 61 70 74 75 72 65 2e 70 |-f 'eg/c|apture.p|
|00002840| 6c 27 20 2d 61 20 22 24 | 7b 31 7d 22 20 21 3d 20 |l' -a "$|{1}" != |
|00002850| 22 2d 63 22 20 3b 20 74 | 68 65 6e 20 0a 20 20 65 |"-c" ; t|hen . e|
|00002860| 63 68 6f 20 73 68 61 72 | 3a 20 57 69 6c 6c 20 6e |cho shar|: Will n|
|00002870| 6f 74 20 63 6c 6f 62 62 | 65 72 20 65 78 69 73 74 |ot clobb|er exist|
|00002880| 69 6e 67 20 66 69 6c 65 | 20 5c 22 27 65 67 2f 63 |ing file| \"'eg/c|
|00002890| 61 70 74 75 72 65 2e 70 | 6c 27 5c 22 0a 65 6c 73 |apture.p|l'\".els|
|000028a0| 65 0a 20 20 65 63 68 6f | 20 73 68 61 72 3a 20 45 |e. echo| shar: E|
|000028b0| 78 74 72 61 63 74 69 6e | 67 20 5c 22 27 65 67 2f |xtractin|g \"'eg/|
|000028c0| 63 61 70 74 75 72 65 2e | 70 6c 27 5c 22 20 5c 28 |capture.|pl'\" \(|
|000028d0| 31 36 34 30 20 63 68 61 | 72 61 63 74 65 72 73 5c |1640 cha|racters\|
|000028e0| 29 0a 20 20 73 65 64 20 | 22 73 2f 5e 58 2f 2f 22 |). sed |"s/^X//"|
|000028f0| 20 3e 27 65 67 2f 63 61 | 70 74 75 72 65 2e 70 6c | >'eg/ca|pture.pl|
|00002900| 27 20 3c 3c 27 45 4e 44 | 5f 4f 46 5f 46 49 4c 45 |' <<'END|_OF_FILE|
|00002910| 27 0a 58 23 21 20 2f 75 | 73 72 2f 6c 6f 63 61 6c |'.X#! /u|sr/local|
|00002920| 2f 62 69 6e 2f 73 79 62 | 70 65 72 6c 0a 58 0a 58 |/bin/syb|perl.X.X|
|00002930| 23 0a 58 23 09 40 28 23 | 29 63 61 70 74 75 72 65 |#.X#.@(#|)capture|
|00002940| 2e 70 6c 09 31 2e 31 09 | 36 2f 32 34 2f 39 32 0a |.pl.1.1.|6/24/92.|
|00002950| 58 23 0a 58 0a 58 72 65 | 71 75 69 72 65 20 22 73 |X#.X.Xre|quire "s|
|00002960| 79 62 70 65 72 6c 2e 70 | 6c 22 3b 0a 58 72 65 71 |ybperl.p|l";.Xreq|
|00002970| 75 69 72 65 20 22 73 71 | 6c 2e 70 6c 22 3b 0a 58 |uire "sq|l.pl";.X|
|00002980| 0a 58 23 0a 58 23 20 4c | 6f 67 20 75 73 20 69 6e |.X#.X# L|og us in|
|00002990| 20 74 6f 20 53 79 62 61 | 73 65 2e 0a 58 23 0a 58 | to Syba|se..X#.X|
|000029a0| 24 64 20 3d 20 26 64 62 | 6c 6f 67 69 6e 3b 0a 58 |$d = &db|login;.X|
|000029b0| 0a 58 26 73 71 6c 28 24 | 64 2c 20 22 73 65 74 20 |.X&sql($|d, "set |
|000029c0| 73 74 61 74 69 73 74 69 | 63 73 20 69 6f 20 6f 6e |statisti|cs io on|
|000029d0| 22 29 3b 0a 58 26 73 71 | 6c 28 24 64 2c 20 22 73 |");.X&sq|l($d, "s|
|000029e0| 65 74 20 73 74 61 74 69 | 73 74 69 63 73 20 74 69 |et stati|stics ti|
|000029f0| 6d 65 20 6f 6e 22 29 3b | 0a 58 0a 58 23 0a 58 23 |me on");|.X.X#.X#|
|00002a00| 20 43 6f 75 6e 74 20 74 | 68 65 20 6e 75 6d 62 65 | Count t|he numbe|
|00002a10| 72 20 6f 66 66 20 70 61 | 73 73 77 6f 72 64 20 74 |r off pa|ssword t|
|00002a20| 61 62 6c 65 73 2e 0a 58 | 23 0a 58 40 72 65 73 75 |ables..X|#.X@resu|
|00002a30| 6c 74 73 20 3d 20 26 73 | 71 6c 28 24 64 2c 20 27 |lts = &s|ql($d, '|
|00002a40| 0a 58 09 09 73 65 6c 65 | 63 74 20 63 6f 75 6e 74 |.X..sele|ct count|
|00002a50| 28 2a 29 20 66 72 6f 6d | 20 73 79 73 6f 62 6a 65 |(*) from| sysobje|
|00002a60| 63 74 73 0a 58 09 09 77 | 68 65 72 65 20 6e 61 6d |cts.X..w|here nam|
|00002a70| 65 20 3d 20 22 70 61 73 | 73 77 6f 72 64 22 20 61 |e = "pas|sword" a|
|00002a80| 6e 64 20 74 79 70 65 20 | 3d 20 22 55 22 27 0a 58 |nd type |= "U"'.X|
|00002a90| 09 20 20 20 29 3b 0a 58 | 0a 58 23 0a 58 23 20 49 |. );.X|.X#.X# I|
|00002aa0| 66 20 74 68 65 72 65 20 | 69 73 20 6e 6f 6e 65 20 |f there |is none |
|00002ab0| 63 72 65 61 74 65 20 69 | 74 20 65 6c 73 65 20 74 |create i|t else t|
|00002ac0| 72 75 6e 63 61 74 65 20 | 69 74 2e 0a 58 23 0a 58 |runcate |it..X#.X|
|00002ad0| 69 66 28 40 72 65 73 75 | 6c 74 73 5b 30 5d 20 3d |if(@resu|lts[0] =|
|00002ae0| 3d 20 30 29 20 7b 0a 58 | 09 26 73 71 6c 28 24 64 |= 0) {.X|.&sql($d|
|00002af0| 2c 20 27 0a 58 09 09 63 | 72 65 61 74 65 20 74 61 |, '.X..c|reate ta|
|00002b00| 62 6c 65 20 70 61 73 73 | 77 6f 72 64 28 0a 58 09 |ble pass|word(.X.|
|00002b10| 09 20 20 20 20 75 73 65 | 72 6e 61 6d 65 20 63 68 |. use|rname ch|
|00002b20| 61 72 28 38 29 2c 0a 58 | 09 09 20 20 20 20 75 69 |ar(8),.X|.. ui|
|00002b30| 64 20 69 6e 74 2c 0a 58 | 09 09 20 20 20 20 67 69 |d int,.X|.. gi|
|00002b40| 64 20 69 6e 74 2c 0a 58 | 09 09 20 20 20 20 73 68 |d int,.X|.. sh|
|00002b50| 65 6c 6c 20 76 61 72 63 | 68 61 72 28 33 30 29 2c |ell varc|har(30),|
|00002b60| 0a 58 09 09 20 20 20 20 | 68 6f 6d 65 20 76 61 72 |.X.. |home var|
|00002b70| 63 68 61 72 28 33 30 29 | 0a 58 09 09 29 27 0a 58 |char(30)|.X..)'.X|
|00002b80| 09 29 3b 0a 58 09 70 72 | 69 6e 74 20 22 54 68 65 |.);.X.pr|int "The|
|00002b90| 20 70 61 73 73 77 6f 72 | 64 20 74 61 62 6c 65 20 | passwor|d table |
|00002ba0| 68 61 73 20 62 65 65 6e | 20 63 72 65 61 74 65 64 |has been| created|
|00002bb0| 2e 5c 6e 22 3b 0a 58 7d | 20 65 6c 73 65 20 7b 0a |.\n";.X}| else {.|
|00002bc0| 58 09 26 73 71 6c 28 24 | 64 2c 20 27 74 72 75 6e |X.&sql($|d, 'trun|
|00002bd0| 63 61 74 65 20 74 61 62 | 6c 65 20 70 61 73 73 77 |cate tab|le passw|
|00002be0| 6f 72 64 27 29 3b 0a 58 | 09 70 72 69 6e 74 20 22 |ord');.X|.print "|
|00002bf0| 54 68 65 20 70 61 73 73 | 77 6f 72 64 20 74 61 62 |The pass|word tab|
|00002c00| 6c 65 20 61 6c 72 65 61 | 64 79 20 65 78 69 73 74 |le alrea|dy exist|
|00002c10| 73 2e 20 54 61 62 6c 65 | 20 74 72 75 6e 63 61 74 |s. Table| truncat|
|00002c20| 65 64 21 5c 6e 22 3b 0a | 58 7d 3b 0a 58 0a 58 23 |ed!\n";.|X};.X.X#|
|00002c30| 0a 58 23 20 52 65 61 64 | 20 74 68 65 20 70 61 73 |.X# Read| the pas|
|00002c40| 73 77 6f 72 64 20 65 6e | 74 72 69 65 73 20 61 6e |sword en|tries an|
|00002c50| 64 20 61 64 64 20 74 68 | 65 6d 20 74 6f 20 74 68 |d add th|em to th|
|00002c60| 65 20 64 61 74 61 62 61 | 73 65 2e 0a 58 23 0a 58 |e databa|se..X#.X|
|00002c70| 77 68 69 6c 65 20 28 28 | 24 6e 2c 24 70 2c 24 75 |while ((|$n,$p,$u|
|00002c80| 2c 24 67 2c 24 71 2c 24 | 63 2c 24 67 63 2c 24 64 |,$g,$q,$|c,$gc,$d|
|00002c90| 2c 24 73 29 3d 20 67 65 | 74 70 77 65 6e 74 29 20 |,$s)= ge|tpwent) |
|00002ca0| 7b 0a 58 09 70 72 69 6e | 74 20 22 41 64 64 69 6e |{.X.prin|t "Addin|
|00002cb0| 67 20 24 6e 2e 5c 6e 22 | 3b 0a 58 09 26 73 71 6c |g $n.\n"|;.X.&sql|
|00002cc0| 28 24 64 2c 20 22 0a 58 | 09 09 69 6e 73 65 72 74 |($d, ".X|..insert|
|00002cd0| 20 70 61 73 73 77 6f 72 | 64 0a 58 09 09 76 61 6c | passwor|d.X..val|
|00002ce0| 75 65 73 28 5c 22 24 6e | 5c 22 2c 20 24 75 2c 20 |ues(\"$n|\", $u, |
|00002cf0| 24 67 2c 20 5c 22 24 73 | 5c 22 2c 20 5c 22 24 64 |$g, \"$s|\", \"$d|
|00002d00| 5c 22 29 0a 58 09 09 22 | 0a 58 09 29 3b 0a 58 7d |\").X.."|.X.);.X}|
|00002d10| 3b 0a 58 65 6e 64 70 77 | 65 6e 74 3b 0a 58 0a 58 |;.Xendpw|ent;.X.X|
|00002d20| 23 0a 58 23 20 43 6f 75 | 6e 74 20 74 68 65 20 6e |#.X# Cou|nt the n|
|00002d30| 75 6d 62 65 72 20 6f 66 | 66 20 67 72 6f 75 70 20 |umber of|f group |
|00002d40| 74 61 62 6c 65 73 2e 0a | 58 23 0a 58 40 72 65 73 |tables..|X#.X@res|
|00002d50| 75 6c 74 73 20 3d 20 26 | 73 71 6c 28 24 64 2c 20 |ults = &|sql($d, |
|00002d60| 27 0a 58 09 09 73 65 6c | 65 63 74 20 63 6f 75 6e |'.X..sel|ect coun|
|00002d70| 74 28 2a 29 20 66 72 6f | 6d 20 73 79 73 6f 62 6a |t(*) fro|m sysobj|
|00002d80| 65 63 74 73 0a 58 09 09 | 77 68 65 72 65 20 6e 61 |ects.X..|where na|
|00002d90| 6d 65 20 3d 20 22 67 72 | 6f 75 70 73 22 20 61 6e |me = "gr|oups" an|
|00002da0| 64 20 74 79 70 65 20 3d | 20 22 55 22 27 0a 58 09 |d type =| "U"'.X.|
|00002db0| 20 20 20 29 3b 0a 58 0a | 58 23 0a 58 23 20 49 66 | );.X.|X#.X# If|
|00002dc0| 20 74 68 65 72 65 20 69 | 73 20 6e 6f 6e 65 20 63 | there i|s none c|
|00002dd0| 72 65 61 74 65 20 69 74 | 20 65 6c 73 65 20 74 72 |reate it| else tr|
|00002de0| 75 6e 63 61 74 65 20 69 | 74 2e 0a 58 23 0a 58 69 |uncate i|t..X#.Xi|
|00002df0| 66 28 40 72 65 73 75 6c | 74 73 5b 30 5d 20 3d 3d |f(@resul|ts[0] ==|
|00002e00| 20 30 29 20 7b 0a 58 09 | 26 73 71 6c 28 24 64 2c | 0) {.X.|&sql($d,|
|00002e10| 20 27 0a 58 09 09 63 72 | 65 61 74 65 20 74 61 62 | '.X..cr|eate tab|
|00002e20| 6c 65 20 67 72 6f 75 70 | 73 28 0a 58 09 09 20 20 |le group|s(.X.. |
|00002e30| 20 20 67 72 6f 75 70 6e | 61 6d 65 20 63 68 61 72 | groupn|ame char|
|00002e40| 28 38 29 2c 0a 58 09 09 | 20 20 20 20 67 69 64 20 |(8),.X..| gid |
|00002e50| 69 6e 74 0a 58 09 09 29 | 27 0a 58 09 29 3b 0a 58 |int.X..)|'.X.);.X|
|00002e60| 09 70 72 69 6e 74 20 22 | 54 68 65 20 67 72 6f 75 |.print "|The grou|
|00002e70| 70 73 20 74 61 62 6c 65 | 20 68 61 73 20 62 65 65 |ps table| has bee|
|00002e80| 6e 20 63 72 65 61 74 65 | 64 2e 5c 6e 22 3b 0a 58 |n create|d.\n";.X|
|00002e90| 7d 20 65 6c 73 65 20 7b | 0a 58 09 26 73 71 6c 28 |} else {|.X.&sql(|
|00002ea0| 24 64 2c 20 27 74 72 75 | 6e 63 61 74 65 20 74 61 |$d, 'tru|ncate ta|
|00002eb0| 62 6c 65 20 67 72 6f 75 | 70 73 27 29 3b 0a 58 09 |ble grou|ps');.X.|
|00002ec0| 70 72 69 6e 74 20 22 54 | 68 65 20 67 72 6f 75 70 |print "T|he group|
|00002ed0| 73 20 74 61 62 6c 65 20 | 61 6c 72 65 61 64 79 20 |s table |already |
|00002ee0| 65 78 69 73 74 73 2e 20 | 54 61 62 6c 65 20 74 72 |exists. |Table tr|
|00002ef0| 75 6e 63 61 74 65 64 21 | 5c 6e 22 3b 0a 58 7d 3b |uncated!|\n";.X};|
|00002f00| 0a 58 0a 58 23 0a 58 23 | 20 52 65 61 64 20 74 68 |.X.X#.X#| Read th|
|00002f10| 65 20 67 72 6f 75 70 20 | 65 6e 74 72 69 65 73 20 |e group |entries |
|00002f20| 61 6e 64 20 61 64 64 20 | 74 68 65 6d 20 74 6f 20 |and add |them to |
|00002f30| 74 68 65 20 64 61 74 61 | 62 61 73 65 2e 0a 58 23 |the data|base..X#|
|00002f40| 0a 58 77 68 69 6c 65 20 | 28 28 24 67 6e 2c 24 67 |.Xwhile |(($gn,$g|
|00002f50| 70 2c 24 67 67 2c 24 67 | 6d 29 3d 20 67 65 74 67 |p,$gg,$g|m)= getg|
|00002f60| 72 65 6e 74 29 20 7b 0a | 58 09 70 72 69 6e 74 20 |rent) {.|X.print |
|00002f70| 22 41 64 64 69 6e 67 20 | 67 72 6f 75 70 20 24 67 |"Adding |group $g|
|00002f80| 6e 2e 5c 6e 22 3b 0a 58 | 09 26 73 71 6c 28 24 64 |n.\n";.X|.&sql($d|
|00002f90| 2c 20 22 0a 58 09 09 69 | 6e 73 65 72 74 20 67 72 |, ".X..i|nsert gr|
|00002fa0| 6f 75 70 73 0a 58 09 09 | 76 61 6c 75 65 73 28 5c |oups.X..|values(\|
|00002fb0| 22 24 67 6e 5c 22 2c 20 | 24 67 67 29 0a 58 09 09 |"$gn\", |$gg).X..|
|00002fc0| 22 0a 58 09 29 3b 0a 58 | 7d 3b 0a 58 65 6e 64 67 |".X.);.X|};.Xendg|
|00002fd0| 72 65 6e 74 3b 0a 58 0a | 45 4e 44 5f 4f 46 5f 46 |rent;.X.|END_OF_F|
|00002fe0| 49 4c 45 0a 20 20 69 66 | 20 74 65 73 74 20 31 36 |ILE. if| test 16|
|00002ff0| 34 30 20 2d 6e 65 20 60 | 77 63 20 2d 63 20 3c 27 |40 -ne `|wc -c <'|
|00003000| 65 67 2f 63 61 70 74 75 | 72 65 2e 70 6c 27 60 3b |eg/captu|re.pl'`;|
|00003010| 20 74 68 65 6e 0a 20 20 | 20 20 65 63 68 6f 20 73 | then. | echo s|
|00003020| 68 61 72 3a 20 5c 22 27 | 65 67 2f 63 61 70 74 75 |har: \"'|eg/captu|
|00003030| 72 65 2e 70 6c 27 5c 22 | 20 75 6e 70 61 63 6b 65 |re.pl'\"| unpacke|
|00003040| 64 20 77 69 74 68 20 77 | 72 6f 6e 67 20 73 69 7a |d with w|rong siz|
|00003050| 65 21 0a 20 20 66 69 0a | 20 20 63 68 6d 6f 64 20 |e!. fi.| chmod |
|00003060| 2b 78 20 27 65 67 2f 63 | 61 70 74 75 72 65 2e 70 |+x 'eg/c|apture.p|
|00003070| 6c 27 0a 20 20 23 20 65 | 6e 64 20 6f 66 20 27 65 |l'. # e|nd of 'e|
|00003080| 67 2f 63 61 70 74 75 72 | 65 2e 70 6c 27 0a 66 69 |g/captur|e.pl'.fi|
|00003090| 0a 69 66 20 74 65 73 74 | 20 2d 66 20 27 65 67 2f |.if test| -f 'eg/|
|000030a0| 64 62 74 65 78 74 2e 70 | 6c 27 20 2d 61 20 22 24 |dbtext.p|l' -a "$|
|000030b0| 7b 31 7d 22 20 21 3d 20 | 22 2d 63 22 20 3b 20 74 |{1}" != |"-c" ; t|
|000030c0| 68 65 6e 20 0a 20 20 65 | 63 68 6f 20 73 68 61 72 |hen . e|cho shar|
|000030d0| 3a 20 57 69 6c 6c 20 6e | 6f 74 20 63 6c 6f 62 62 |: Will n|ot clobb|
|000030e0| 65 72 20 65 78 69 73 74 | 69 6e 67 20 66 69 6c 65 |er exist|ing file|
|000030f0| 20 5c 22 27 65 67 2f 64 | 62 74 65 78 74 2e 70 6c | \"'eg/d|btext.pl|
|00003100| 27 5c 22 0a 65 6c 73 65 | 0a 20 20 65 63 68 6f 20 |'\".else|. echo |
|00003110| 73 68 61 72 3a 20 45 78 | 74 72 61 63 74 69 6e 67 |shar: Ex|tracting|
|00003120| 20 5c 22 27 65 67 2f 64 | 62 74 65 78 74 2e 70 6c | \"'eg/d|btext.pl|
|00003130| 27 5c 22 20 5c 28 37 30 | 38 20 63 68 61 72 61 63 |'\" \(70|8 charac|
|00003140| 74 65 72 73 5c 29 0a 20 | 20 73 65 64 20 22 73 2f |ters\). | sed "s/|
|00003150| 5e 58 2f 2f 22 20 3e 27 | 65 67 2f 64 62 74 65 78 |^X//" >'|eg/dbtex|
|00003160| 74 2e 70 6c 27 20 3c 3c | 27 45 4e 44 5f 4f 46 5f |t.pl' <<|'END_OF_|
|00003170| 46 49 4c 45 27 0a 58 23 | 20 20 53 63 72 69 70 74 |FILE'.X#| Script|
|00003180| 20 77 68 69 63 68 20 64 | 65 6d 6f 6e 73 74 72 61 | which d|emonstra|
|00003190| 74 65 73 20 64 62 77 72 | 69 74 65 20 72 6f 75 74 |tes dbwr|ite rout|
|000031a0| 69 6e 65 2e 0a 58 23 0a | 58 23 20 20 49 6e 20 69 |ine..X#.|X# In i|
|000031b0| 73 71 6c 20 64 6f 20 73 | 6f 6d 65 74 68 69 6e 67 |sql do s|omething|
|000031c0| 20 6c 69 6b 65 3a 0a 58 | 23 20 20 20 20 20 20 20 | like:.X|# |
|000031d0| 63 72 65 61 74 65 20 74 | 61 62 6c 65 20 74 65 78 |create t|able tex|
|000031e0| 74 5f 74 61 62 6c 65 20 | 28 74 5f 69 6e 64 65 78 |t_table |(t_index|
|000031f0| 20 69 6e 74 2c 20 74 68 | 65 5f 74 65 78 74 20 74 | int, th|e_text t|
|00003200| 65 78 74 29 0a 58 23 0a | 58 0a 58 72 65 71 75 69 |ext).X#.|X.Xrequi|
|00003210| 72 65 20 22 73 79 62 70 | 65 72 6c 2e 70 6c 22 3b |re "sybp|erl.pl";|
|00003220| 0a 58 72 65 71 75 69 72 | 65 20 22 73 71 6c 2e 70 |.Xrequir|e "sql.p|
|00003230| 6c 22 3b 0a 58 0a 58 24 | 64 20 3d 20 26 64 62 6c |l";.X.X$|d = &dbl|
|00003240| 6f 67 69 6e 3b 0a 58 24 | 64 32 20 3d 20 26 64 62 |ogin;.X$|d2 = &db|
|00003250| 6f 70 65 6e 3b 0a 58 0a | 58 26 73 71 6c 20 28 24 |open;.X.|X&sql ($|
|00003260| 64 2c 20 27 64 65 6c 65 | 74 65 20 66 72 6f 6d 20 |d, 'dele|te from |
|00003270| 74 65 78 74 5f 74 61 62 | 6c 65 27 29 3b 0a 58 26 |text_tab|le');.X&|
|00003280| 73 71 6c 20 28 24 64 2c | 20 27 69 6e 73 65 72 74 |sql ($d,| 'insert|
|00003290| 20 69 6e 74 6f 20 74 65 | 78 74 5f 74 61 62 6c 65 | into te|xt_table|
|000032a0| 20 28 74 5f 69 6e 64 65 | 78 2c 20 74 68 65 5f 74 | (t_inde|x, the_t|
|000032b0| 65 78 74 29 20 76 61 6c | 75 65 73 20 28 35 2c 22 |ext) val|ues (5,"|
|000032c0| 22 29 27 29 3b 0a 58 0a | 58 0a 58 26 64 62 63 6d |")');.X.|X.X&dbcm|
|000032d0| 64 28 24 64 2c 27 73 65 | 6c 65 63 74 20 74 68 65 |d($d,'se|lect the|
|000032e0| 5f 74 65 78 74 2c 20 74 | 5f 69 6e 64 65 78 20 66 |_text, t|_index f|
|000032f0| 72 6f 6d 20 74 65 78 74 | 5f 74 61 62 6c 65 20 77 |rom text|_table w|
|00003300| 68 65 72 65 20 74 5f 69 | 6e 64 65 78 20 3d 20 35 |here t_i|ndex = 5|
|00003310| 27 29 3b 0a 58 26 64 62 | 73 71 6c 65 78 65 63 28 |');.X&db|sqlexec(|
|00003320| 24 64 29 3b 20 20 20 20 | 20 20 20 20 20 20 20 20 |$d); | |
|00003330| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 23 20 65 | | # e|
|00003340| 78 65 63 75 74 65 20 73 | 71 6c 0a 58 0a 58 26 64 |xecute s|ql.X.X&d|
|00003350| 62 72 65 73 75 6c 74 73 | 28 24 64 29 3b 0a 58 40 |bresults|($d);.X@|
|00003360| 64 61 74 61 20 3d 20 26 | 64 62 6e 65 78 74 72 6f |data = &|dbnextro|
|00003370| 77 28 24 64 29 3b 0a 58 | 0a 58 26 64 62 77 72 69 |w($d);.X|.X&dbwri|
|00003380| 74 65 74 65 78 74 20 28 | 24 64 32 2c 20 22 74 65 |tetext (|$d2, "te|
|00003390| 78 74 5f 74 61 62 6c 65 | 2e 74 68 65 5f 74 65 78 |xt_table|.the_tex|
|000033a0| 74 22 2c 20 24 64 2c 20 | 31 2c 20 22 54 68 69 73 |t", $d, |1, "This|
|000033b0| 20 69 73 20 74 65 78 74 | 20 77 68 69 63 68 20 77 | is text| which w|
|000033c0| 61 73 20 61 64 64 65 64 | 20 77 69 74 68 20 53 79 |as added| with Sy|
|000033d0| 62 70 65 72 6c 22 29 3b | 0a 58 0a 58 40 72 65 73 |bperl");|.X.X@res|
|000033e0| 75 6c 74 20 3d 20 26 73 | 71 6c 28 24 64 2c 27 73 |ult = &s|ql($d,'s|
|000033f0| 65 6c 65 63 74 20 74 5f | 69 6e 64 65 78 2c 20 74 |elect t_|index, t|
|00003400| 68 65 5f 74 65 78 74 20 | 66 72 6f 6d 20 74 65 78 |he_text |from tex|
|00003410| 74 5f 74 61 62 6c 65 20 | 77 68 65 72 65 20 74 5f |t_table |where t_|
|00003420| 69 6e 64 65 78 20 3d 20 | 35 27 29 3b 0a 58 0a 58 |index = |5');.X.X|
|00003430| 70 72 69 6e 74 20 40 72 | 65 73 75 6c 74 2c 20 22 |print @r|esult, "|
|00003440| 5c 6e 22 3b 0a 58 0a 58 | 26 64 62 63 6c 6f 73 65 |\n";.X.X|&dbclose|
|00003450| 28 24 64 29 3b 0a 58 0a | 45 4e 44 5f 4f 46 5f 46 |($d);.X.|END_OF_F|
|00003460| 49 4c 45 0a 20 20 69 66 | 20 74 65 73 74 20 37 30 |ILE. if| test 70|
|00003470| 38 20 2d 6e 65 20 60 77 | 63 20 2d 63 20 3c 27 65 |8 -ne `w|c -c <'e|
|00003480| 67 2f 64 62 74 65 78 74 | 2e 70 6c 27 60 3b 20 74 |g/dbtext|.pl'`; t|
|00003490| 68 65 6e 0a 20 20 20 20 | 65 63 68 6f 20 73 68 61 |hen. |echo sha|
|000034a0| 72 3a 20 5c 22 27 65 67 | 2f 64 62 74 65 78 74 2e |r: \"'eg|/dbtext.|
|000034b0| 70 6c 27 5c 22 20 75 6e | 70 61 63 6b 65 64 20 77 |pl'\" un|packed w|
|000034c0| 69 74 68 20 77 72 6f 6e | 67 20 73 69 7a 65 21 0a |ith wron|g size!.|
|000034d0| 20 20 66 69 0a 20 20 23 | 20 65 6e 64 20 6f 66 20 | fi. #| end of |
|000034e0| 27 65 67 2f 64 62 74 65 | 78 74 2e 70 6c 27 0a 66 |'eg/dbte|xt.pl'.f|
|000034f0| 69 0a 69 66 20 74 65 73 | 74 20 2d 66 20 27 65 67 |i.if tes|t -f 'eg|
|00003500| 2f 72 65 70 6f 72 74 2e | 70 6c 27 20 2d 61 20 22 |/report.|pl' -a "|
|00003510| 24 7b 31 7d 22 20 21 3d | 20 22 2d 63 22 20 3b 20 |${1}" !=| "-c" ; |
|00003520| 74 68 65 6e 20 0a 20 20 | 65 63 68 6f 20 73 68 61 |then . |echo sha|
|00003530| 72 3a 20 57 69 6c 6c 20 | 6e 6f 74 20 63 6c 6f 62 |r: Will |not clob|
|00003540| 62 65 72 20 65 78 69 73 | 74 69 6e 67 20 66 69 6c |ber exis|ting fil|
|00003550| 65 20 5c 22 27 65 67 2f | 72 65 70 6f 72 74 2e 70 |e \"'eg/|report.p|
|00003560| 6c 27 5c 22 0a 65 6c 73 | 65 0a 20 20 65 63 68 6f |l'\".els|e. echo|
|00003570| 20 73 68 61 72 3a 20 45 | 78 74 72 61 63 74 69 6e | shar: E|xtractin|
|00003580| 67 20 5c 22 27 65 67 2f | 72 65 70 6f 72 74 2e 70 |g \"'eg/|report.p|
|00003590| 6c 27 5c 22 20 5c 28 37 | 35 33 20 63 68 61 72 61 |l'\" \(7|53 chara|
|000035a0| 63 74 65 72 73 5c 29 0a | 20 20 73 65 64 20 22 73 |cters\).| sed "s|
|000035b0| 2f 5e 58 2f 2f 22 20 3e | 27 65 67 2f 72 65 70 6f |/^X//" >|'eg/repo|
|000035c0| 72 74 2e 70 6c 27 20 3c | 3c 27 45 4e 44 5f 4f 46 |rt.pl' <|<'END_OF|
|000035d0| 5f 46 49 4c 45 27 0a 58 | 23 21 20 2f 75 73 72 2f |_FILE'.X|#! /usr/|
|000035e0| 6c 6f 63 61 6c 2f 62 69 | 6e 2f 73 79 62 70 65 72 |local/bi|n/sybper|
|000035f0| 6c 0a 58 0a 58 23 0a 58 | 23 09 40 28 23 29 72 65 |l.X.X#.X|#.@(#)re|
|00003600| 70 6f 72 74 2e 70 6c 09 | 31 2e 31 09 36 2f 32 34 |port.pl.|1.1.6/24|
|00003610| 2f 39 32 0a 58 23 0a 58 | 0a 58 72 65 71 75 69 72 |/92.X#.X|.Xrequir|
|00003620| 65 20 22 73 79 62 70 65 | 72 6c 2e 70 6c 22 3b 0a |e "sybpe|rl.pl";.|
|00003630| 58 72 65 71 75 69 72 65 | 20 22 73 71 6c 2e 70 6c |Xrequire| "sql.pl|
|00003640| 22 3b 0a 58 0a 58 23 0a | 58 23 20 4c 6f 67 20 75 |";.X.X#.|X# Log u|
|00003650| 73 20 69 6e 20 74 6f 20 | 53 79 62 61 73 65 2e 0a |s in to |Sybase..|
|00003660| 58 23 0a 58 24 64 20 3d | 20 26 64 62 6c 6f 67 69 |X#.X$d =| &dblogi|
|00003670| 6e 3b 0a 58 0a 58 23 0a | 58 23 20 64 65 66 69 6e |n;.X.X#.|X# defin|
|00003680| 65 20 74 68 65 20 66 6f | 72 6d 61 74 0a 58 23 0a |e the fo|rmat.X#.|
|00003690| 58 66 6f 72 6d 61 74 20 | 74 6f 70 3d 0a 58 09 09 |Xformat |top=.X..|
|000036a0| 09 20 50 41 53 53 57 4f | 52 44 20 46 49 4c 45 0a |. PASSWO|RD FILE.|
|000036b0| 58 4c 6f 67 69 6e 20 20 | 20 20 20 20 55 69 64 20 |XLogin | Uid |
|000036c0| 47 72 6f 75 70 20 20 20 | 20 20 20 53 68 65 6c 6c |Group | Shell|
|000036d0| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|000036e0| 20 20 20 48 6f 6d 65 20 | 64 69 72 65 63 74 6f 72 | Home |director|
|000036f0| 79 0a 58 2d 2d 2d 2d 2d | 2d 2d 2d 20 2d 2d 2d 2d |y.X-----|--- ----|
|00003700| 2d 20 2d 2d 2d 2d 2d 2d | 2d 2d 2d 2d 20 2d 2d 2d |- ------|---- ---|
|00003710| 2d 2d 2d 2d 2d 2d 2d 2d | 2d 2d 2d 2d 2d 2d 2d 2d |--------|--------|
|00003720| 2d 2d 2d 2d 20 2d 2d 2d | 2d 2d 2d 2d 2d 2d 2d 2d |---- ---|--------|
|00003730| 2d 2d 2d 2d 2d 2d 2d 2d | 2d 2d 2d 0a 58 2e 20 0a |--------|---.X. .|
|00003740| 58 66 6f 72 6d 61 74 20 | 73 74 64 6f 75 74 3d 0a |Xformat |stdout=.|
|00003750| 58 40 3c 3c 3c 3c 3c 3c | 3c 20 40 3e 3e 3e 3e 20 |X@<<<<<<|< @>>>> |
|00003760| 40 3c 3c 3c 3c 3c 3c 3c | 3c 3c 20 40 3c 3c 3c 3c |@<<<<<<<|<< @<<<<|
|00003770| 3c 3c 3c 3c 3c 3c 3c 3c | 3c 3c 3c 3c 3c 3c 3c 3c |<<<<<<<<|<<<<<<<<|
|00003780| 3c 3c 20 40 3c 3c 3c 3c | 3c 3c 3c 3c 3c 3c 3c 3c |<< @<<<<|<<<<<<<<|
|00003790| 3c 3c 3c 3c 3c 3c 3c 3c | 3c 0a 58 24 6e 2c 20 20 |<<<<<<<<|<.X$n, |
|000037a0| 20 20 20 20 24 75 2c 20 | 20 20 24 67 6e 2c 20 20 | $u, | $gn, |
|000037b0| 20 20 20 20 20 24 73 2c | 20 20 20 20 20 20 20 20 | $s,| |
|000037c0| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 24 64 0a | | $d.|
|000037d0| 58 2e 20 0a 58 0a 58 23 | 0a 58 23 20 53 65 65 20 |X. .X.X#|.X# See |
|000037e0| 69 66 20 65 76 65 72 79 | 74 68 69 6e 67 20 69 73 |if every|thing is|
|000037f0| 20 74 68 65 72 65 2e 0a | 58 23 0a 58 40 72 65 73 | there..|X#.X@res|
|00003800| 75 6c 74 73 20 3d 20 26 | 73 71 6c 28 24 64 2c 20 |ults = &|sql($d, |
|00003810| 27 0a 58 09 73 65 6c 65 | 63 74 20 75 73 65 72 6e |'.X.sele|ct usern|
|00003820| 61 6d 65 2c 20 75 69 64 | 2c 20 69 73 6e 75 6c 6c |ame, uid|, isnull|
|00003830| 28 67 72 6f 75 70 6e 61 | 6d 65 2c 63 6f 6e 76 65 |(groupna|me,conve|
|00003840| 72 74 28 63 68 61 72 2c | 70 2e 67 69 64 29 29 2c |rt(char,|p.gid)),|
|00003850| 20 73 68 65 6c 6c 2c 20 | 68 6f 6d 65 0a 58 09 66 | shell, |home.X.f|
|00003860| 72 6f 6d 20 70 61 73 73 | 77 6f 72 64 20 70 2c 20 |rom pass|word p, |
|00003870| 67 72 6f 75 70 73 20 67 | 0a 58 09 77 68 65 72 65 |groups g|.X.where|
|00003880| 09 70 2e 67 69 64 20 2a | 3d 20 67 2e 67 69 64 0a |.p.gid *|= g.gid.|
|00003890| 58 09 6f 72 64 65 72 20 | 62 79 20 75 69 64 0a 58 |X.order |by uid.X|
|000038a0| 09 27 29 3b 0a 58 66 6f | 72 65 61 63 68 20 24 78 |.');.Xfo|reach $x|
|000038b0| 20 28 40 72 65 73 75 6c | 74 73 29 20 7b 0a 58 09 | (@resul|ts) {.X.|
|000038c0| 28 24 6e 2c 24 75 2c 24 | 67 6e 2c 24 73 2c 24 64 |($n,$u,$|gn,$s,$d|
|000038d0| 29 20 3d 20 73 70 6c 69 | 74 28 22 7e 22 2c 24 78 |) = spli|t("~",$x|
|000038e0| 29 3b 0a 58 09 77 72 69 | 74 65 3b 0a 58 7d 0a 58 |);.X.wri|te;.X}.X|
|000038f0| 0a 45 4e 44 5f 4f 46 5f | 46 49 4c 45 0a 20 20 69 |.END_OF_|FILE. i|
|00003900| 66 20 74 65 73 74 20 37 | 35 33 20 2d 6e 65 20 60 |f test 7|53 -ne `|
|00003910| 77 63 20 2d 63 20 3c 27 | 65 67 2f 72 65 70 6f 72 |wc -c <'|eg/repor|
|00003920| 74 2e 70 6c 27 60 3b 20 | 74 68 65 6e 0a 20 20 20 |t.pl'`; |then. |
|00003930| 20 65 63 68 6f 20 73 68 | 61 72 3a 20 5c 22 27 65 | echo sh|ar: \"'e|
|00003940| 67 2f 72 65 70 6f 72 74 | 2e 70 6c 27 5c 22 20 75 |g/report|.pl'\" u|
|00003950| 6e 70 61 63 6b 65 64 20 | 77 69 74 68 20 77 72 6f |npacked |with wro|
|00003960| 6e 67 20 73 69 7a 65 21 | 0a 20 20 66 69 0a 20 20 |ng size!|. fi. |
|00003970| 63 68 6d 6f 64 20 2b 78 | 20 27 65 67 2f 72 65 70 |chmod +x| 'eg/rep|
|00003980| 6f 72 74 2e 70 6c 27 0a | 20 20 23 20 65 6e 64 20 |ort.pl'.| # end |
|00003990| 6f 66 20 27 65 67 2f 72 | 65 70 6f 72 74 2e 70 6c |of 'eg/r|eport.pl|
|000039a0| 27 0a 66 69 0a 69 66 20 | 74 65 73 74 20 2d 66 20 |'.fi.if |test -f |
|000039b0| 27 65 67 2f 73 70 61 63 | 65 2e 70 6c 27 20 2d 61 |'eg/spac|e.pl' -a|
|000039c0| 20 22 24 7b 31 7d 22 20 | 21 3d 20 22 2d 63 22 20 | "${1}" |!= "-c" |
|000039d0| 3b 20 74 68 65 6e 20 0a | 20 20 65 63 68 6f 20 73 |; then .| echo s|
|000039e0| 68 61 72 3a 20 57 69 6c | 6c 20 6e 6f 74 20 63 6c |har: Wil|l not cl|
|000039f0| 6f 62 62 65 72 20 65 78 | 69 73 74 69 6e 67 20 66 |obber ex|isting f|
|00003a00| 69 6c 65 20 5c 22 27 65 | 67 2f 73 70 61 63 65 2e |ile \"'e|g/space.|
|00003a10| 70 6c 27 5c 22 0a 65 6c | 73 65 0a 20 20 65 63 68 |pl'\".el|se. ech|
|00003a20| 6f 20 73 68 61 72 3a 20 | 45 78 74 72 61 63 74 69 |o shar: |Extracti|
|00003a30| 6e 67 20 5c 22 27 65 67 | 2f 73 70 61 63 65 2e 70 |ng \"'eg|/space.p|
|00003a40| 6c 27 5c 22 20 5c 28 31 | 34 39 34 20 63 68 61 72 |l'\" \(1|494 char|
|00003a50| 61 63 74 65 72 73 5c 29 | 0a 20 20 73 65 64 20 22 |acters\)|. sed "|
|00003a60| 73 2f 5e 58 2f 2f 22 20 | 3e 27 65 67 2f 73 70 61 |s/^X//" |>'eg/spa|
|00003a70| 63 65 2e 70 6c 27 20 3c | 3c 27 45 4e 44 5f 4f 46 |ce.pl' <|<'END_OF|
|00003a80| 5f 46 49 4c 45 27 0a 58 | 23 21 20 2f 75 73 72 2f |_FILE'.X|#! /usr/|
|00003a90| 6c 6f 63 61 6c 2f 62 69 | 6e 2f 73 79 62 70 65 72 |local/bi|n/sybper|
|00003aa0| 6c 0a 58 23 0a 58 23 09 | 40 28 23 29 73 70 61 63 |l.X#.X#.|@(#)spac|
|00003ab0| 65 2e 70 6c 09 31 2e 32 | 09 34 2f 32 2f 39 33 0a |e.pl.1.2|.4/2/93.|
|00003ac0| 58 0a 58 72 65 71 75 69 | 72 65 20 22 73 79 62 70 |X.Xrequi|re "sybp|
|00003ad0| 65 72 6c 2e 70 6c 22 3b | 0a 58 72 65 71 75 69 72 |erl.pl";|.Xrequir|
|00003ae0| 65 20 22 73 71 6c 2e 70 | 6c 22 3b 0a 58 0a 58 23 |e "sql.p|l";.X.X#|
|00003af0| 0a 58 23 20 4c 6f 67 20 | 75 73 20 69 6e 20 74 6f |.X# Log |us in to|
|00003b00| 20 53 79 62 61 73 65 2e | 0a 58 23 0a 58 70 72 69 | Sybase.|.X#.Xpri|
|00003b10| 6e 74 20 22 4e 61 6d 65 | 20 6f 66 20 53 79 62 61 |nt "Name| of Syba|
|00003b20| 73 65 20 73 65 72 76 65 | 72 3a 20 22 3b 0a 58 24 |se serve|r: ";.X$|
|00003b30| 73 65 72 76 65 72 20 3d | 20 3c 3e 3b 20 63 68 6f |server =| <>; cho|
|00003b40| 70 28 24 73 65 72 76 65 | 72 29 3b 0a 58 69 66 28 |p($serve|r);.Xif(|
|00003b50| 24 73 65 72 76 65 72 20 | 6e 65 20 27 27 29 0a 58 |$server |ne '').X|
|00003b60| 7b 0a 58 20 20 20 20 24 | 45 4e 56 7b 27 44 53 51 |{.X $|ENV{'DSQ|
|00003b70| 55 45 52 59 27 7d 20 3d | 20 24 73 65 72 76 65 72 |UERY'} =| $server|
|00003b80| 3b 0a 58 7d 0a 58 65 6c | 73 65 0a 58 7b 0a 58 20 |;.X}.Xel|se.X{.X |
|00003b90| 20 20 20 24 73 65 72 76 | 65 72 20 3d 20 24 45 4e | $serv|er = $EN|
|00003ba0| 56 7b 27 44 53 51 55 45 | 52 59 27 7d 3b 0a 58 7d |V{'DSQUE|RY'};.X}|
|00003bb0| 0a 58 0a 58 70 72 69 6e | 74 20 22 41 64 6d 69 6e |.X.Xprin|t "Admin|
|00003bc0| 69 73 74 72 61 74 69 76 | 65 20 61 63 63 6f 75 6e |istrativ|e accoun|
|00003bd0| 74 20 70 61 73 73 77 6f | 72 64 3a 20 22 3b 0a 58 |t passwo|rd: ";.X|
|00003be0| 65 76 61 6c 20 60 73 74 | 74 79 20 2d 65 63 68 6f |eval `st|ty -echo|
|00003bf0| 60 3b 0a 58 24 73 61 70 | 77 20 3d 20 3c 3e 3b 20 |`;.X$sap|w = <>; |
|00003c00| 63 68 6f 70 28 24 73 61 | 70 77 29 3b 0a 58 65 76 |chop($sa|pw);.Xev|
|00003c10| 61 6c 20 60 73 74 74 79 | 20 65 63 68 6f 60 3b 0a |al `stty| echo`;.|
|00003c20| 58 0a 58 24 64 20 3d 20 | 26 64 62 6c 6f 67 69 6e |X.X$d = |&dblogin|
|00003c30| 28 22 73 61 22 2c 20 24 | 73 61 70 77 29 3b 0a 58 |("sa", $|sapw);.X|
|00003c40| 0a 58 0a 58 24 73 65 72 | 76 65 72 20 3d 20 24 73 |.X.X$ser|ver = $s|
|00003c50| 65 72 76 65 72 20 2e 20 | 27 2e 27 3b 0a 58 0a 58 |erver . |'.';.X.X|
|00003c60| 0a 58 26 73 71 6c 28 24 | 64 2c 20 22 75 73 65 20 |.X&sql($|d, "use |
|00003c70| 6d 61 73 74 65 72 22 29 | 3b 0a 58 40 64 62 73 20 |master")|;.X@dbs |
|00003c80| 3d 20 26 73 71 6c 28 24 | 64 2c 20 22 73 65 6c 65 |= &sql($|d, "sele|
|00003c90| 63 74 20 6e 61 6d 65 20 | 66 72 6f 6d 20 73 79 73 |ct name |from sys|
|00003ca0| 64 61 74 61 62 61 73 65 | 73 20 6f 72 64 65 72 20 |database|s order |
|00003cb0| 62 79 20 6e 61 6d 65 22 | 29 3b 0a 58 0a 58 66 6f |by name"|);.X.Xfo|
|00003cc0| 72 65 61 63 68 20 24 6e | 20 28 40 64 62 73 29 20 |reach $n| (@dbs) |
|00003cd0| 7b 0a 58 20 20 20 20 26 | 73 71 6c 28 24 64 2c 20 |{.X &|sql($d, |
|00003ce0| 22 75 73 65 20 24 6e 22 | 29 3b 0a 58 20 20 20 20 |"use $n"|);.X |
|00003cf0| 24 78 20 3d 20 6a 6f 69 | 6e 28 27 7e 27 2c 20 26 |$x = joi|n('~', &|
|00003d00| 73 71 6c 28 24 64 2c 20 | 27 73 70 5f 73 70 61 63 |sql($d, |'sp_spac|
|00003d10| 65 75 73 65 64 27 29 29 | 3b 0a 58 20 20 20 20 24 |eused'))|;.X $|
|00003d20| 78 20 3d 7e 20 73 2f 20 | 2f 2f 67 3b 0a 58 20 20 |x =~ s/ |//g;.X |
|00003d30| 20 20 24 78 20 3d 7e 20 | 73 2f 4d 42 7c 4b 42 2f | $x =~ |s/MB|KB/|
|00003d40| 2f 67 3b 0a 58 20 20 20 | 20 28 24 6e 61 6d 65 2c |/g;.X | ($name,|
|00003d50| 20 24 73 69 7a 65 2c 20 | 24 72 65 73 2c 20 24 64 | $size, |$res, $d|
|00003d60| 61 74 61 2c 20 24 69 6e | 64 65 78 2c 20 24 66 72 |ata, $in|dex, $fr|
|00003d70| 65 65 20 29 20 3d 20 73 | 70 6c 69 74 28 22 7e 22 |ee ) = s|plit("~"|
|00003d80| 2c 24 78 29 3b 0a 58 20 | 20 20 20 24 75 6e 75 73 |,$x);.X | $unus|
|00003d90| 65 64 20 3d 20 24 73 69 | 7a 65 20 2a 20 31 30 32 |ed = $si|ze * 102|
|00003da0| 34 20 2d 20 24 72 65 73 | 3b 0a 58 20 20 20 20 77 |4 - $res|;.X w|
|00003db0| 72 69 74 65 3b 0a 58 20 | 20 20 20 24 74 73 20 2b |rite;.X | $ts +|
|00003dc0| 3d 20 24 73 69 7a 65 3b | 0a 58 20 20 20 20 24 74 |= $size;|.X $t|
|00003dd0| 72 20 2b 3d 20 24 72 65 | 73 3b 0a 58 20 20 20 20 |r += $re|s;.X |
|00003de0| 24 74 64 20 2b 3d 20 24 | 64 61 74 61 3b 0a 58 20 |$td += $|data;.X |
|00003df0| 20 20 20 24 74 69 20 2b | 3d 20 24 69 6e 64 65 78 | $ti +|= $index|
|00003e00| 3b 0a 58 20 20 20 20 24 | 74 66 20 2b 3d 20 24 66 |;.X $|tf += $f|
|00003e10| 72 65 65 3b 0a 58 7d 0a | 58 0a 58 70 72 69 6e 74 |ree;.X}.|X.Xprint|
|00003e20| 20 27 2d 27 20 78 20 37 | 38 2c 20 22 5c 6e 22 3b | '-' x 7|8, "\n";|
|00003e30| 20 0a 58 24 6e 61 6d 65 | 20 3d 20 27 54 4f 54 41 | .X$name| = 'TOTA|
|00003e40| 4c 27 3b 0a 58 24 73 69 | 7a 65 20 3d 20 24 74 73 |L';.X$si|ze = $ts|
|00003e50| 3b 0a 58 24 72 65 73 20 | 3d 20 24 74 72 3b 0a 58 |;.X$res |= $tr;.X|
|00003e60| 24 64 61 74 61 20 3d 20 | 24 74 64 3b 0a 58 24 69 |$data = |$td;.X$i|
|00003e70| 6e 64 65 78 20 3d 20 24 | 74 69 3b 0a 58 24 66 72 |ndex = $|ti;.X$fr|
|00003e80| 65 65 20 3d 20 24 74 66 | 3b 0a 58 24 75 6e 75 73 |ee = $tf|;.X$unus|
|00003e90| 65 64 20 3d 20 24 73 69 | 7a 65 20 2a 20 31 30 32 |ed = $si|ze * 102|
|00003ea0| 34 20 2d 20 24 72 65 73 | 3b 0a 58 77 72 69 74 65 |4 - $res|;.Xwrite|
|00003eb0| 3b 0a 58 0a 58 66 6f 72 | 6d 61 74 20 74 6f 70 3d |;.X.Xfor|mat top=|
|00003ec0| 0a 58 53 70 61 63 65 20 | 75 73 61 67 65 20 70 65 |.XSpace |usage pe|
|00003ed0| 72 20 64 61 74 61 62 61 | 73 65 20 66 6f 72 20 73 |r databa|se for s|
|00003ee0| 65 72 76 65 72 20 40 3c | 3c 3c 3c 3c 3c 3c 3c 3c |erver @<|<<<<<<<<|
|00003ef0| 3c 3c 3c 3c 3c 3c 0a 58 | 09 09 09 09 20 20 20 20 |<<<<<<.X|.... |
|00003f00| 24 73 65 72 76 65 72 0a | 58 4e 61 6d 65 20 20 20 |$server.|XName |
|00003f10| 20 20 20 20 20 20 20 20 | 20 20 53 69 7a 65 20 20 | | Size |
|00003f20| 20 20 52 65 73 65 72 76 | 65 64 20 20 20 20 20 20 | Reserv|ed |
|00003f30| 20 44 61 74 61 20 20 20 | 20 20 20 49 6e 64 65 78 | Data | Index|
|00003f40| 20 20 20 20 20 20 20 46 | 72 65 65 20 20 20 20 20 | F|ree |
|00003f50| 55 6e 75 73 65 64 0a 58 | 09 20 20 20 20 20 20 20 |Unused.X|. |
|00003f60| 20 20 28 4d 42 29 20 20 | 20 20 20 20 20 20 28 4b | (MB) | (K|
|00003f70| 42 29 20 20 20 20 20 20 | 20 28 4b 42 29 20 20 20 |B) | (KB) |
|00003f80| 20 20 20 20 28 4b 42 29 | 20 20 20 20 20 20 20 28 | (KB)| (|
|00003f90| 4b 42 29 20 20 20 20 20 | 20 20 28 4b 42 29 0a 58 |KB) | (KB).X|
|00003fa0| 2d 2d 2d 2d 2d 2d 2d 2d | 2d 2d 2d 2d 2d 2d 2d 2d |--------|--------|
|00003fb0| 2d 2d 2d 2d 2d 2d 2d 2d | 2d 2d 2d 2d 2d 2d 2d 2d |--------|--------|
|00003fc0| 2d 2d 2d 2d 2d 2d 2d 2d | 2d 2d 2d 2d 2d 2d 2d 2d |--------|--------|
|00003fd0| 2d 2d 2d 2d 2d 2d 2d 2d | 2d 2d 2d 2d 2d 2d 2d 2d |--------|--------|
|00003fe0| 2d 2d 2d 2d 2d 2d 2d 2d | 2d 2d 2d 2d 2d 0a 58 2e |--------|-----.X.|
|00003ff0| 20 0a 58 66 6f 72 6d 61 | 74 20 73 74 64 6f 75 74 | .Xforma|t stdout|
|00004000| 3d 0a 58 40 3c 3c 3c 3c | 3c 3c 3c 3c 3c 20 20 40 |=.X@<<<<|<<<<< @|
|00004010| 3e 3e 3e 3e 3e 3e 3e 3e | 20 20 40 3e 3e 3e 3e 3e |>>>>>>>>| @>>>>>|
|00004020| 3e 3e 3e 3e 20 20 40 3e | 3e 3e 3e 3e 3e 3e 3e 20 |>>>> @>|>>>>>>> |
|00004030| 20 40 3e 3e 3e 3e 3e 3e | 3e 3e 20 20 40 3e 3e 3e | @>>>>>>|>> @>>>|
|00004040| 3e 3e 3e 3e 3e 20 20 40 | 3e 3e 3e 3e 3e 3e 3e 3e |>>>>> @|>>>>>>>>|
|00004050| 0a 58 24 6e 61 6d 65 2c | 20 20 20 20 20 20 24 73 |.X$name,| $s|
|00004060| 69 7a 65 2c 20 20 20 20 | 20 24 72 65 73 2c 20 20 |ize, | $res, |
|00004070| 20 20 20 20 20 24 64 61 | 74 61 2c 20 20 20 20 20 | $da|ta, |
|00004080| 24 69 6e 64 65 78 2c 20 | 20 20 20 24 66 72 65 65 |$index, | $free|
|00004090| 2c 20 20 20 20 20 24 75 | 6e 75 73 65 64 0a 58 2e |, $u|nused.X.|
|000040a0| 20 0a 58 0a 58 0a 45 4e | 44 5f 4f 46 5f 46 49 4c | .X.X.EN|D_OF_FIL|
|000040b0| 45 0a 20 20 69 66 20 74 | 65 73 74 20 31 34 39 34 |E. if t|est 1494|
|000040c0| 20 2d 6e 65 20 60 77 63 | 20 2d 63 20 3c 27 65 67 | -ne `wc| -c <'eg|
|000040d0| 2f 73 70 61 63 65 2e 70 | 6c 27 60 3b 20 74 68 65 |/space.p|l'`; the|
|000040e0| 6e 0a 20 20 20 20 65 63 | 68 6f 20 73 68 61 72 3a |n. ec|ho shar:|
|000040f0| 20 5c 22 27 65 67 2f 73 | 70 61 63 65 2e 70 6c 27 | \"'eg/s|pace.pl'|
|00004100| 5c 22 20 75 6e 70 61 63 | 6b 65 64 20 77 69 74 68 |\" unpac|ked with|
|00004110| 20 77 72 6f 6e 67 20 73 | 69 7a 65 21 0a 20 20 66 | wrong s|ize!. f|
|00004120| 69 0a 20 20 63 68 6d 6f | 64 20 2b 78 20 27 65 67 |i. chmo|d +x 'eg|
|00004130| 2f 73 70 61 63 65 2e 70 | 6c 27 0a 20 20 23 20 65 |/space.p|l'. # e|
|00004140| 6e 64 20 6f 66 20 27 65 | 67 2f 73 70 61 63 65 2e |nd of 'e|g/space.|
|00004150| 70 6c 27 0a 66 69 0a 69 | 66 20 74 65 73 74 20 2d |pl'.fi.i|f test -|
|00004160| 66 20 27 65 67 2f 73 71 | 6c 2e 70 6c 27 20 2d 61 |f 'eg/sq|l.pl' -a|
|00004170| 20 22 24 7b 31 7d 22 20 | 21 3d 20 22 2d 63 22 20 | "${1}" |!= "-c" |
|00004180| 3b 20 74 68 65 6e 20 0a | 20 20 65 63 68 6f 20 73 |; then .| echo s|
|00004190| 68 61 72 3a 20 57 69 6c | 6c 20 6e 6f 74 20 63 6c |har: Wil|l not cl|
|000041a0| 6f 62 62 65 72 20 65 78 | 69 73 74 69 6e 67 20 66 |obber ex|isting f|
|000041b0| 69 6c 65 20 5c 22 27 65 | 67 2f 73 71 6c 2e 70 6c |ile \"'e|g/sql.pl|
|000041c0| 27 5c 22 0a 65 6c 73 65 | 0a 20 20 65 63 68 6f 20 |'\".else|. echo |
|000041d0| 73 68 61 72 3a 20 45 78 | 74 72 61 63 74 69 6e 67 |shar: Ex|tracting|
|000041e0| 20 5c 22 27 65 67 2f 73 | 71 6c 2e 70 6c 27 5c 22 | \"'eg/s|ql.pl'\"|
|000041f0| 20 5c 28 31 37 33 38 20 | 63 68 61 72 61 63 74 65 | \(1738 |characte|
|00004200| 72 73 5c 29 0a 20 20 73 | 65 64 20 22 73 2f 5e 58 |rs\). s|ed "s/^X|
|00004210| 2f 2f 22 20 3e 27 65 67 | 2f 73 71 6c 2e 70 6c 27 |//" >'eg|/sql.pl'|
|00004220| 20 3c 3c 27 45 4e 44 5f | 4f 46 5f 46 49 4c 45 27 | <<'END_|OF_FILE'|
|00004230| 0a 58 23 0a 58 23 09 40 | 28 23 29 73 71 6c 2e 70 |.X#.X#.@|(#)sql.p|
|00004240| 6c 09 31 2e 31 09 36 2f | 32 34 2f 39 32 0a 58 23 |l.1.1.6/|24/92.X#|
|00004250| 0a 58 0a 58 73 75 62 20 | 73 71 6c 20 7b 0a 58 20 |.X.Xsub |sql {.X |
|00004260| 20 20 20 6c 6f 63 61 6c | 28 24 64 62 2c 24 73 71 | local|($db,$sq|
|00004270| 6c 2c 24 73 65 70 29 3d | 40 5f 3b 09 09 09 23 20 |l,$sep)=|@_;...# |
|00004280| 6c 6f 63 61 6c 20 63 6f | 70 79 20 70 61 72 61 6d |local co|py param|
|00004290| 65 74 65 72 73 0a 58 0a | 58 20 20 20 20 24 73 65 |eters.X.|X $se|
|000042a0| 70 20 3d 20 27 7e 27 20 | 75 6e 6c 65 73 73 20 24 |p = '~' |unless $|
|000042b0| 73 65 70 3b 09 09 09 23 | 20 70 72 6f 76 69 64 65 |sep;...#| provide|
|000042c0| 20 64 65 66 61 75 6c 74 | 20 66 6f 72 20 73 65 70 | default| for sep|
|000042d0| 0a 58 0a 58 20 20 20 20 | 40 72 65 73 20 3d 20 28 |.X.X |@res = (|
|000042e0| 29 3b 09 09 09 09 09 23 | 20 63 6c 65 61 72 20 72 |);.....#| clear r|
|000042f0| 65 73 75 6c 74 20 61 72 | 72 61 79 0a 58 0a 58 20 |esult ar|ray.X.X |
|00004300| 20 20 20 26 64 62 63 6d | 64 28 24 64 62 2c 24 73 | &dbcm|d($db,$s|
|00004310| 71 6c 29 3b 09 09 09 09 | 23 20 70 61 73 73 20 73 |ql);....|# pass s|
|00004320| 71 6c 20 74 6f 20 73 65 | 72 76 65 72 0a 58 20 20 |ql to se|rver.X |
|00004330| 20 20 26 64 62 73 71 6c | 65 78 65 63 28 24 64 62 | &dbsql|exec($db|
|00004340| 29 3b 09 09 09 09 23 20 | 65 78 65 63 75 74 65 20 |);....# |execute |
|00004350| 73 71 6c 0a 58 0a 58 20 | 20 20 20 77 68 69 6c 65 |sql.X.X | while|
|00004360| 28 26 64 62 72 65 73 75 | 6c 74 73 28 24 64 62 29 |(&dbresu|lts($db)|
|00004370| 20 21 3d 20 24 4e 4f 5f | 4d 4f 52 45 5f 52 45 53 | != $NO_|MORE_RES|
|00004380| 55 4c 54 53 29 20 7b 09 | 23 20 63 6f 70 79 20 61 |ULTS) {.|# copy a|
|00004390| 6c 6c 20 72 65 73 75 6c | 74 73 0a 58 09 77 68 69 |ll resul|ts.X.whi|
|000043a0| 6c 65 20 28 40 64 61 74 | 61 20 3d 20 26 64 62 6e |le (@dat|a = &dbn|
|000043b0| 65 78 74 72 6f 77 28 24 | 64 62 31 29 29 20 7b 0a |extrow($|db1)) {.|
|000043c0| 58 09 20 20 20 20 70 75 | 73 68 28 40 72 65 73 2c |X. pu|sh(@res,|
|000043d0| 6a 6f 69 6e 28 24 73 65 | 70 2c 40 64 61 74 61 29 |join($se|p,@data)|
|000043e0| 29 3b 0a 58 09 7d 0a 58 | 20 20 20 20 7d 0a 58 0a |);.X.}.X| }.X.|
|000043f0| 58 20 20 20 20 40 72 65 | 73 3b 09 09 09 09 09 23 |X @re|s;.....#|
|00004400| 20 72 65 74 75 72 6e 20 | 74 68 65 20 72 65 73 75 | return |the resu|
|00004410| 6c 74 20 61 72 72 61 79 | 0a 58 7d 0a 58 0a 58 0a |lt array|.X}.X.X.|
|00004420| 58 23 20 4d 65 73 73 61 | 67 65 20 61 6e 64 20 65 |X# Messa|ge and e|
|00004430| 72 72 6f 72 20 68 61 6e | 64 6c 65 72 73 2e 0a 58 |rror han|dlers..X|
|00004440| 0a 58 73 75 62 20 73 71 | 6c 5f 6d 65 73 73 61 67 |.Xsub sq|l_messag|
|00004450| 65 5f 68 61 6e 64 6c 65 | 72 0a 58 7b 0a 58 20 20 |e_handle|r.X{.X |
|00004460| 20 20 6c 6f 63 61 6c 20 | 28 24 64 62 2c 20 24 6d | local |($db, $m|
|00004470| 65 73 73 61 67 65 2c 20 | 24 73 74 61 74 65 2c 20 |essage, |$state, |
|00004480| 24 73 65 76 65 72 69 74 | 79 2c 20 24 74 65 78 74 |$severit|y, $text|
|00004490| 2c 20 24 73 65 72 76 65 | 72 2c 20 24 70 72 6f 63 |, $serve|r, $proc|
|000044a0| 65 64 75 72 65 2c 20 24 | 6c 69 6e 65 29 0a 58 09 |edure, $|line).X.|
|000044b0| 3d 20 40 5f 3b 0a 58 0a | 58 20 20 20 20 69 66 20 |= @_;.X.|X if |
|000044c0| 28 24 73 65 76 65 72 69 | 74 79 20 3e 20 30 29 0a |($severi|ty > 0).|
|000044d0| 58 20 20 20 20 7b 0a 58 | 09 70 72 69 6e 74 20 28 |X {.X|.print (|
|000044e0| 22 53 79 62 61 73 65 20 | 6d 65 73 73 61 67 65 20 |"Sybase |message |
|000044f0| 22 2c 20 24 6d 65 73 73 | 61 67 65 2c 20 22 2c 20 |", $mess|age, ", |
|00004500| 53 65 76 65 72 69 74 79 | 20 22 2c 20 24 73 65 76 |Severity| ", $sev|
|00004510| 65 72 69 74 79 2c 0a 58 | 09 20 20 20 20 20 20 20 |erity,.X|. |
|00004520| 22 2c 20 73 74 61 74 65 | 20 22 2c 20 24 73 74 61 |", state| ", $sta|
|00004530| 74 65 29 3b 0a 58 09 70 | 72 69 6e 74 20 28 22 5c |te);.X.p|rint ("\|
|00004540| 6e 53 65 72 76 65 72 20 | 60 22 2c 20 24 73 65 72 |nServer |`", $ser|
|00004550| 76 65 72 2c 20 22 27 22 | 29 20 69 66 20 64 65 66 |ver, "'"|) if def|
|00004560| 69 6e 65 64 20 28 24 73 | 65 72 76 65 72 29 3b 0a |ined ($s|erver);.|
|00004570| 58 09 70 72 69 6e 74 20 | 28 22 5c 6e 50 72 6f 63 |X.print |("\nProc|
|00004580| 65 64 75 72 65 20 60 22 | 2c 20 24 70 72 6f 63 65 |edure `"|, $proce|
|00004590| 64 75 72 65 2c 20 22 27 | 22 29 20 69 66 20 64 65 |dure, "'|") if de|
|000045a0| 66 69 6e 65 64 20 28 24 | 70 72 6f 63 65 64 75 72 |fined ($|procedur|
|000045b0| 65 29 3b 0a 58 09 70 72 | 69 6e 74 20 28 22 5c 6e |e);.X.pr|int ("\n|
|000045c0| 4c 69 6e 65 20 22 2c 20 | 24 6c 69 6e 65 29 20 69 |Line ", |$line) i|
|000045d0| 66 20 64 65 66 69 6e 65 | 64 20 28 24 6c 69 6e 65 |f define|d ($line|
|000045e0| 29 3b 0a 58 09 70 72 69 | 6e 74 20 28 22 5c 6e 20 |);.X.pri|nt ("\n |
|000045f0| 20 20 20 22 2c 20 24 74 | 65 78 74 2c 20 22 5c 6e | ", $t|ext, "\n|
|00004600| 5c 6e 22 29 3b 0a 58 0a | 58 23 20 26 64 62 73 74 |\n");.X.|X# &dbst|
|00004610| 72 63 70 79 20 72 65 74 | 75 72 6e 73 20 74 68 65 |rcpy ret|urns the|
|00004620| 20 63 6f 6d 6d 61 6e 64 | 20 62 75 66 66 65 72 2e | command| buffer.|
|00004630| 0a 58 0a 58 09 6c 6f 63 | 61 6c 20 28 24 6c 69 6e |.X.X.loc|al ($lin|
|00004640| 65 6e 6f 29 20 3d 20 31 | 3b 09 23 20 0a 58 09 66 |eno) = 1|;.# .X.f|
|00004650| 6f 72 65 61 63 68 20 24 | 72 6f 77 20 28 73 70 6c |oreach $|row (spl|
|00004660| 69 74 20 28 2f 5c 6e 2f | 2c 20 26 64 62 73 74 72 |it (/\n/|, &dbstr|
|00004670| 63 70 79 20 28 24 64 62 | 29 29 29 0a 58 09 7b 0a |cpy ($db|))).X.{.|
|00004680| 58 09 20 20 20 20 70 72 | 69 6e 74 20 28 73 70 72 |X. pr|int (spr|
|00004690| 69 6e 74 66 20 28 22 25 | 35 64 22 2c 20 24 6c 69 |intf ("%|5d", $li|
|000046a0| 6e 65 6e 6f 20 2b 2b 29 | 2c 20 22 3e 20 22 2c 20 |neno ++)|, "> ", |
|000046b0| 24 72 6f 77 2c 20 22 5c | 6e 22 29 3b 0a 58 09 7d |$row, "\|n");.X.}|
|000046c0| 0a 58 20 20 20 20 7d 0a | 58 20 20 20 20 65 6c 73 |.X }.|X els|
|000046d0| 69 66 20 28 24 6d 65 73 | 73 61 67 65 20 3d 3d 20 |if ($mes|sage == |
|000046e0| 30 29 0a 58 20 20 20 20 | 7b 0a 58 09 70 72 69 6e |0).X |{.X.prin|
|000046f0| 74 20 28 24 74 65 78 74 | 2c 20 22 5c 6e 22 29 3b |t ($text|, "\n");|
|00004700| 0a 58 20 20 20 20 7d 0a | 58 20 20 20 20 0a 58 20 |.X }.|X .X |
|00004710| 20 20 20 30 3b 0a 58 7d | 0a 58 0a 58 73 75 62 20 | 0;.X}|.X.Xsub |
|00004720| 73 71 6c 5f 65 72 72 6f | 72 5f 68 61 6e 64 6c 65 |sql_erro|r_handle|
|00004730| 72 20 7b 0a 58 20 20 20 | 20 23 20 43 68 65 63 6b |r {.X | # Check|
|00004740| 20 74 68 65 20 65 72 72 | 6f 72 20 63 6f 64 65 20 | the err|or code |
|00004750| 74 6f 20 73 65 65 20 69 | 66 20 77 65 20 73 68 6f |to see i|f we sho|
|00004760| 75 6c 64 20 72 65 70 6f | 72 74 20 74 68 69 73 2e |uld repo|rt this.|
|00004770| 0a 58 20 20 20 20 69 66 | 20 28 24 5f 5b 32 5d 20 |.X if| ($_[2] |
|00004780| 21 3d 20 26 53 59 42 45 | 53 4d 53 47 29 20 7b 0a |!= &SYBE|SMSG) {.|
|00004790| 58 09 6c 6f 63 61 6c 20 | 28 24 64 62 2c 20 24 73 |X.local |($db, $s|
|000047a0| 65 76 65 72 69 74 79 2c | 20 24 65 72 72 6f 72 2c |everity,| $error,|
|000047b0| 20 24 6f 73 5f 65 72 72 | 6f 72 2c 20 24 65 72 72 | $os_err|or, $err|
|000047c0| 6f 72 5f 6d 73 67 2c 20 | 24 6f 73 5f 65 72 72 6f |or_msg, |$os_erro|
|000047d0| 72 5f 6d 73 67 29 0a 58 | 09 20 20 20 20 3d 20 40 |r_msg).X|. = @|
|000047e0| 5f 3b 0a 58 09 70 72 69 | 6e 74 20 28 22 53 79 62 |_;.X.pri|nt ("Syb|
|000047f0| 61 73 65 20 65 72 72 6f | 72 3a 20 22 2c 20 24 65 |ase erro|r: ", $e|
|00004800| 72 72 6f 72 5f 6d 73 67 | 2c 20 22 5c 6e 22 29 3b |rror_msg|, "\n");|
|00004810| 0a 58 09 70 72 69 6e 74 | 20 28 22 4f 53 20 45 72 |.X.print| ("OS Er|
|00004820| 72 6f 72 3a 20 22 2c 20 | 24 6f 73 5f 65 72 72 6f |ror: ", |$os_erro|
|00004830| 72 5f 6d 73 67 2c 20 22 | 5c 6e 22 29 20 69 66 20 |r_msg, "|\n") if |
|00004840| 64 65 66 69 6e 65 64 20 | 28 24 6f 73 5f 65 72 72 |defined |($os_err|
|00004850| 6f 72 5f 6d 73 67 29 3b | 0a 58 20 20 20 20 7d 0a |or_msg);|.X }.|
|00004860| 58 0a 58 20 20 20 20 26 | 49 4e 54 5f 43 41 4e 43 |X.X &|INT_CANC|
|00004870| 45 4c 3b 0a 58 7d 0a 58 | 0a 58 0a 58 69 66 28 20 |EL;.X}.X|.X.Xif( |
|00004880| 64 65 66 69 6e 65 64 28 | 26 64 62 6d 73 67 68 61 |defined(|&dbmsgha|
|00004890| 6e 64 6c 65 29 29 09 23 | 20 49 73 20 74 68 69 73 |ndle)).#| Is this|
|000048a0| 20 61 20 6d 6f 64 65 72 | 6e 20 76 65 72 73 69 6f | a moder|n versio|
|000048b0| 6e 20 6f 66 20 73 79 62 | 70 65 72 6c 3f 20 3b 2d |n of syb|perl? ;-|
|000048c0| 29 0a 58 7b 0a 58 20 20 | 20 20 26 64 62 6d 73 67 |).X{.X | &dbmsg|
|000048d0| 68 61 6e 64 6c 65 20 28 | 22 73 71 6c 5f 6d 65 73 |handle (|"sql_mes|
|000048e0| 73 61 67 65 5f 68 61 6e | 64 6c 65 72 22 29 3b 20 |sage_han|dler"); |
|000048f0| 23 20 53 6f 6d 65 20 75 | 73 65 72 20 64 65 66 69 |# Some u|ser defi|
|00004900| 6e 65 64 20 65 72 72 6f | 72 20 68 61 6e 64 6c 65 |ned erro|r handle|
|00004910| 72 73 0a 58 20 20 20 20 | 26 64 62 65 72 72 68 61 |rs.X |&dberrha|
|00004920| 6e 64 6c 65 20 28 22 73 | 71 6c 5f 65 72 72 6f 72 |ndle ("s|ql_error|
|00004930| 5f 68 61 6e 64 6c 65 72 | 22 29 3b 0a 58 7d 0a 58 |_handler|");.X}.X|
|00004940| 0a 58 0a 58 31 3b 0a 58 | 0a 45 4e 44 5f 4f 46 5f |.X.X1;.X|.END_OF_|
|00004950| 46 49 4c 45 0a 20 20 69 | 66 20 74 65 73 74 20 31 |FILE. i|f test 1|
|00004960| 37 33 38 20 2d 6e 65 20 | 60 77 63 20 2d 63 20 3c |738 -ne |`wc -c <|
|00004970| 27 65 67 2f 73 71 6c 2e | 70 6c 27 60 3b 20 74 68 |'eg/sql.|pl'`; th|
|00004980| 65 6e 0a 20 20 20 20 65 | 63 68 6f 20 73 68 61 72 |en. e|cho shar|
|00004990| 3a 20 5c 22 27 65 67 2f | 73 71 6c 2e 70 6c 27 5c |: \"'eg/|sql.pl'\|
|000049a0| 22 20 75 6e 70 61 63 6b | 65 64 20 77 69 74 68 20 |" unpack|ed with |
|000049b0| 77 72 6f 6e 67 20 73 69 | 7a 65 21 0a 20 20 66 69 |wrong si|ze!. fi|
|000049c0| 0a 20 20 63 68 6d 6f 64 | 20 2b 78 20 27 65 67 2f |. chmod| +x 'eg/|
|000049d0| 73 71 6c 2e 70 6c 27 0a | 20 20 23 20 65 6e 64 20 |sql.pl'.| # end |
|000049e0| 6f 66 20 27 65 67 2f 73 | 71 6c 2e 70 6c 27 0a 66 |of 'eg/s|ql.pl'.f|
|000049f0| 69 0a 69 66 20 74 65 73 | 74 20 2d 66 20 27 6c 69 |i.if tes|t -f 'li|
|00004a00| 62 2f 73 79 62 64 62 2e | 70 68 27 20 2d 61 20 22 |b/sybdb.|ph' -a "|
|00004a10| 24 7b 31 7d 22 20 21 3d | 20 22 2d 63 22 20 3b 20 |${1}" !=| "-c" ; |
|00004a20| 74 68 65 6e 20 0a 20 20 | 65 63 68 6f 20 73 68 61 |then . |echo sha|
|00004a30| 72 3a 20 57 69 6c 6c 20 | 6e 6f 74 20 63 6c 6f 62 |r: Will |not clob|
|00004a40| 62 65 72 20 65 78 69 73 | 74 69 6e 67 20 66 69 6c |ber exis|ting fil|
|00004a50| 65 20 5c 22 27 6c 69 62 | 2f 73 79 62 64 62 2e 70 |e \"'lib|/sybdb.p|
|00004a60| 68 27 5c 22 0a 65 6c 73 | 65 0a 20 20 65 63 68 6f |h'\".els|e. echo|
|00004a70| 20 73 68 61 72 3a 20 45 | 78 74 72 61 63 74 69 6e | shar: E|xtractin|
|00004a80| 67 20 5c 22 27 6c 69 62 | 2f 73 79 62 64 62 2e 70 |g \"'lib|/sybdb.p|
|00004a90| 68 27 5c 22 20 5c 28 32 | 37 38 38 20 63 68 61 72 |h'\" \(2|788 char|
|00004aa0| 61 63 74 65 72 73 5c 29 | 0a 20 20 73 65 64 20 22 |acters\)|. sed "|
|00004ab0| 73 2f 5e 58 2f 2f 22 20 | 3e 27 6c 69 62 2f 73 79 |s/^X//" |>'lib/sy|
|00004ac0| 62 64 62 2e 70 68 27 20 | 3c 3c 27 45 4e 44 5f 4f |bdb.ph' |<<'END_O|
|00004ad0| 46 5f 46 49 4c 45 27 0a | 58 3b 23 09 40 28 23 29 |F_FILE'.|X;#.@(#)|
|00004ae0| 73 79 62 64 62 2e 70 68 | 09 31 2e 31 09 31 31 2f |sybdb.ph|.1.1.11/|
|00004af0| 38 2f 39 31 0a 58 3b 23 | 0a 58 3b 23 0a 58 0a 58 |8/91.X;#|.X;#.X.X|
|00004b00| 73 75 62 20 53 59 42 45 | 53 59 4e 43 20 7b 32 30 |sub SYBE|SYNC {20|
|00004b10| 30 30 31 3b 7d 0a 58 73 | 75 62 20 53 59 42 45 46 |001;}.Xs|ub SYBEF|
|00004b20| 43 4f 4e 20 7b 32 30 30 | 30 32 3b 7d 0a 58 73 75 |CON {200|02;}.Xsu|
|00004b30| 62 20 53 59 42 45 54 49 | 4d 45 20 7b 32 30 30 30 |b SYBETI|ME {2000|
|00004b40| 33 3b 7d 0a 58 73 75 62 | 20 53 59 42 45 52 45 41 |3;}.Xsub| SYBEREA|
|00004b50| 44 20 7b 32 30 30 30 34 | 3b 7d 0a 58 73 75 62 20 |D {20004|;}.Xsub |
|00004b60| 53 59 42 45 42 55 46 4c | 20 7b 32 30 30 30 35 3b |SYBEBUFL| {20005;|
|00004b70| 7d 0a 58 73 75 62 20 53 | 59 42 45 57 52 49 54 20 |}.Xsub S|YBEWRIT |
|00004b80| 7b 32 30 30 30 36 3b 7d | 0a 58 73 75 62 20 53 59 |{20006;}|.Xsub SY|
|00004b90| 42 45 56 4d 53 20 7b 32 | 30 30 30 37 3b 7d 0a 58 |BEVMS {2|0007;}.X|
|00004ba0| 73 75 62 20 53 59 42 45 | 53 4f 43 4b 20 7b 32 30 |sub SYBE|SOCK {20|
|00004bb0| 30 30 38 3b 7d 0a 58 73 | 75 62 20 53 59 42 45 43 |008;}.Xs|ub SYBEC|
|00004bc0| 4f 4e 4e 20 7b 32 30 30 | 30 39 3b 7d 0a 58 73 75 |ONN {200|09;}.Xsu|
|00004bd0| 62 20 53 59 42 45 4d 45 | 4d 20 7b 32 30 30 31 30 |b SYBEME|M {20010|
|00004be0| 3b 7d 0a 58 73 75 62 20 | 53 59 42 45 44 42 50 53 |;}.Xsub |SYBEDBPS|
|00004bf0| 20 7b 32 30 30 31 31 3b | 7d 0a 58 73 75 62 20 53 | {20011;|}.Xsub S|
|00004c00| 59 42 45 49 4e 54 46 20 | 7b 32 30 30 31 32 3b 7d |YBEINTF |{20012;}|
|00004c10| 0a 58 73 75 62 20 53 59 | 42 45 55 48 53 54 20 7b |.Xsub SY|BEUHST {|
|00004c20| 32 30 30 31 33 3b 7d 0a | 58 73 75 62 20 53 59 42 |20013;}.|Xsub SYB|
|00004c30| 45 50 57 44 20 7b 32 30 | 30 31 34 3b 7d 0a 58 73 |EPWD {20|014;}.Xs|
|00004c40| 75 62 20 53 59 42 45 4f | 50 49 4e 20 7b 32 30 30 |ub SYBEO|PIN {200|
|00004c50| 31 35 3b 7d 0a 58 73 75 | 62 20 53 59 42 45 49 4e |15;}.Xsu|b SYBEIN|
|00004c60| 4c 4e 20 7b 32 30 30 31 | 36 3b 7d 0a 58 73 75 62 |LN {2001|6;}.Xsub|
|00004c70| 20 53 59 42 45 53 45 4f | 46 20 7b 32 30 30 31 37 | SYBESEO|F {20017|
|00004c80| 3b 7d 0a 58 73 75 62 20 | 53 59 42 45 53 4d 53 47 |;}.Xsub |SYBESMSG|
|00004c90| 20 7b 32 30 30 31 38 3b | 7d 0a 58 73 75 62 20 53 | {20018;|}.Xsub S|
|00004ca0| 59 42 45 52 50 4e 44 20 | 7b 32 30 30 31 39 3b 7d |YBERPND |{20019;}|
|00004cb0| 0a 58 73 75 62 20 53 59 | 42 45 42 54 4f 4b 20 7b |.Xsub SY|BEBTOK {|
|00004cc0| 32 30 30 32 30 3b 7d 0a | 58 73 75 62 20 53 59 42 |20020;}.|Xsub SYB|
|00004cd0| 45 49 54 49 4d 20 7b 32 | 30 30 32 31 3b 7d 0a 58 |EITIM {2|0021;}.X|
|00004ce0| 73 75 62 20 53 59 42 45 | 4f 4f 42 20 7b 32 30 30 |sub SYBE|OOB {200|
|00004cf0| 32 32 3b 7d 0a 58 73 75 | 62 20 53 59 42 45 42 54 |22;}.Xsu|b SYBEBT|
|00004d00| 59 50 20 7b 32 30 30 32 | 33 3b 7d 0a 58 73 75 62 |YP {2002|3;}.Xsub|
|00004d10| 20 53 59 42 45 42 4e 43 | 52 20 7b 32 30 30 32 34 | SYBEBNC|R {20024|
|00004d20| 3b 7d 0a 58 73 75 62 20 | 53 59 42 45 49 49 43 4c |;}.Xsub |SYBEIICL|
|00004d30| 20 7b 32 30 30 32 35 3b | 7d 0a 58 73 75 62 20 53 | {20025;|}.Xsub S|
|00004d40| 59 42 45 43 4e 4f 52 20 | 7b 32 30 30 32 36 3b 7d |YBECNOR |{20026;}|
|00004d50| 0a 58 73 75 62 20 53 59 | 42 45 4e 50 52 4d 20 7b |.Xsub SY|BENPRM {|
|00004d60| 32 30 30 32 37 3b 7d 0a | 58 73 75 62 20 53 59 42 |20027;}.|Xsub SYB|
|00004d70| 45 55 56 44 54 20 7b 32 | 30 30 32 38 3b 7d 0a 58 |EUVDT {2|0028;}.X|
|00004d80| 73 75 62 20 53 59 42 45 | 55 46 44 54 20 7b 32 30 |sub SYBE|UFDT {20|
|00004d90| 30 32 39 3b 7d 0a 58 73 | 75 62 20 53 59 42 45 57 |029;}.Xs|ub SYBEW|
|00004da0| 41 49 44 20 7b 32 30 30 | 33 30 3b 7d 0a 58 73 75 |AID {200|30;}.Xsu|
|00004db0| 62 20 53 59 42 45 43 44 | 4e 53 20 7b 32 30 30 33 |b SYBECD|NS {2003|
|00004dc0| 31 3b 7d 0a 58 73 75 62 | 20 53 59 42 45 41 42 4e |1;}.Xsub| SYBEABN|
|00004dd0| 43 20 7b 32 30 30 33 32 | 3b 7d 0a 58 73 75 62 20 |C {20032|;}.Xsub |
|00004de0| 53 59 42 45 41 42 4d 54 | 20 7b 32 30 30 33 33 3b |SYBEABMT| {20033;|
|00004df0| 7d 0a 58 73 75 62 20 53 | 59 42 45 41 42 4e 50 20 |}.Xsub S|YBEABNP |
|00004e00| 7b 32 30 30 33 34 3b 7d | 0a 58 73 75 62 20 53 59 |{20034;}|.Xsub SY|
|00004e10| 42 45 41 41 4d 54 20 7b | 32 30 30 33 35 3b 7d 0a |BEAAMT {|20035;}.|
|00004e20| 58 73 75 62 20 53 59 42 | 45 4e 58 49 44 20 7b 32 |Xsub SYB|ENXID {2|
|00004e30| 30 30 33 36 3b 7d 0a 58 | 73 75 62 20 53 59 42 45 |0036;}.X|sub SYBE|
|00004e40| 52 58 49 44 20 7b 32 30 | 30 33 37 3b 7d 0a 58 73 |RXID {20|037;}.Xs|
|00004e50| 75 62 20 53 59 42 45 49 | 43 4e 20 7b 32 30 30 33 |ub SYBEI|CN {2003|
|00004e60| 38 3b 7d 0a 58 73 75 62 | 20 53 59 42 45 4e 4d 4f |8;}.Xsub| SYBENMO|
|00004e70| 42 20 7b 32 30 30 33 39 | 3b 7d 0a 58 73 75 62 20 |B {20039|;}.Xsub |
|00004e80| 53 59 42 45 41 50 55 54 | 20 7b 32 30 30 34 30 3b |SYBEAPUT| {20040;|
|00004e90| 7d 0a 58 73 75 62 20 53 | 59 42 45 41 53 4e 4c 20 |}.Xsub S|YBEASNL |
|00004ea0| 7b 32 30 30 34 31 3b 7d | 0a 58 73 75 62 20 53 59 |{20041;}|.Xsub SY|
|00004eb0| 42 45 4e 54 4c 4c 20 7b | 32 30 30 34 32 3b 7d 0a |BENTLL {|20042;}.|
|00004ec0| 58 73 75 62 20 53 59 42 | 45 41 53 55 4c 20 7b 32 |Xsub SYB|EASUL {2|
|00004ed0| 30 30 34 33 3b 7d 0a 58 | 73 75 62 20 53 59 42 45 |0043;}.X|sub SYBE|
|00004ee0| 52 44 4e 52 20 7b 32 30 | 30 34 34 3b 7d 0a 58 73 |RDNR {20|044;}.Xs|
|00004ef0| 75 62 20 53 59 42 45 4e | 53 49 50 20 7b 32 30 30 |ub SYBEN|SIP {200|
|00004f00| 34 35 3b 7d 0a 58 73 75 | 62 20 53 59 42 45 41 42 |45;}.Xsu|b SYBEAB|
|00004f10| 4e 56 20 7b 32 30 30 34 | 36 3b 7d 0a 58 73 75 62 |NV {2004|6;}.Xsub|
|00004f20| 20 53 59 42 45 44 44 4e | 45 20 7b 32 30 30 34 37 | SYBEDDN|E {20047|
|00004f30| 3b 7d 0a 58 73 75 62 20 | 53 59 42 45 43 55 46 4c |;}.Xsub |SYBECUFL|
|00004f40| 20 7b 32 30 30 34 38 3b | 7d 0a 58 73 75 62 20 53 | {20048;|}.Xsub S|
|00004f50| 59 42 45 43 4f 46 4c 20 | 7b 32 30 30 34 39 3b 7d |YBECOFL |{20049;}|
|00004f60| 0a 58 73 75 62 20 53 59 | 42 45 43 53 59 4e 20 7b |.Xsub SY|BECSYN {|
|00004f70| 32 30 30 35 30 3b 7d 0a | 58 73 75 62 20 53 59 42 |20050;}.|Xsub SYB|
|00004f80| 45 43 4c 50 52 20 7b 32 | 30 30 35 31 3b 7d 0a 58 |ECLPR {2|0051;}.X|
|00004f90| 73 75 62 20 53 59 42 45 | 43 4e 4f 56 20 7b 32 30 |sub SYBE|CNOV {20|
|00004fa0| 30 35 32 3b 7d 0a 58 73 | 75 62 20 53 59 42 45 52 |052;}.Xs|ub SYBER|
|00004fb0| 44 43 4e 20 7b 32 30 30 | 35 33 3b 7d 0a 58 73 75 |DCN {200|53;}.Xsu|
|00004fc0| 62 20 53 59 42 45 53 46 | 4f 56 20 7b 32 30 30 35 |b SYBESF|OV {2005|
|00004fd0| 34 3b 7d 0a 58 73 75 62 | 20 53 59 42 45 55 4e 54 |4;}.Xsub| SYBEUNT|
|00004fe0| 20 7b 32 30 30 35 35 3b | 7d 0a 58 73 75 62 20 53 | {20055;|}.Xsub S|
|00004ff0| 59 42 45 43 4c 4f 53 20 | 7b 32 30 30 35 36 3b 7d |YBECLOS |{20056;}|
|00005000| 0a 58 73 75 62 20 53 59 | 42 45 55 41 56 45 20 7b |.Xsub SY|BEUAVE {|
|00005010| 32 30 30 35 37 3b 7d 0a | 58 73 75 62 20 53 59 42 |20057;}.|Xsub SYB|
|00005020| 45 55 53 43 54 20 7b 32 | 30 30 35 38 3b 7d 0a 58 |EUSCT {2|0058;}.X|
|00005030| 73 75 62 20 53 59 42 45 | 45 51 56 41 20 7b 32 30 |sub SYBE|EQVA {20|
|00005040| 30 35 39 3b 7d 0a 58 73 | 75 62 20 53 59 42 45 55 |059;}.Xs|ub SYBEU|
|00005050| 44 54 59 20 7b 32 30 30 | 36 30 3b 7d 0a 58 73 75 |DTY {200|60;}.Xsu|
|00005060| 62 20 53 59 42 45 54 53 | 49 54 20 7b 32 30 30 36 |b SYBETS|IT {2006|
|00005070| 31 3b 7d 0a 58 73 75 62 | 20 53 59 42 45 41 55 54 |1;}.Xsub| SYBEAUT|
|00005080| 4e 20 7b 32 30 30 36 32 | 3b 7d 0a 58 73 75 62 20 |N {20062|;}.Xsub |
|00005090| 53 59 42 45 42 44 49 4f | 20 7b 32 30 30 36 33 3b |SYBEBDIO| {20063;|
|000050a0| 7d 0a 58 73 75 62 20 53 | 59 42 45 42 43 4e 54 20 |}.Xsub S|YBEBCNT |
|000050b0| 7b 32 30 30 36 34 3b 7d | 0a 58 73 75 62 20 53 59 |{20064;}|.Xsub SY|
|000050c0| 42 45 49 46 4e 42 20 7b | 32 30 30 36 35 3b 7d 0a |BEIFNB {|20065;}.|
|000050d0| 58 73 75 62 20 53 59 42 | 45 54 54 53 20 7b 32 30 |Xsub SYB|ETTS {20|
|000050e0| 30 36 36 3b 7d 0a 58 73 | 75 62 20 53 59 42 45 4b |066;}.Xs|ub SYBEK|
|000050f0| 42 43 4f 20 7b 32 30 30 | 36 37 3b 7d 0a 58 73 75 |BCO {200|67;}.Xsu|
|00005100| 62 20 53 59 42 45 42 42 | 43 49 20 7b 32 30 30 36 |b SYBEBB|CI {2006|
|00005110| 38 3b 7d 0a 58 73 75 62 | 20 53 59 42 45 4b 42 43 |8;}.Xsub| SYBEKBC|
|00005120| 49 20 7b 32 30 30 36 39 | 3b 7d 0a 58 73 75 62 20 |I {20069|;}.Xsub |
|00005130| 53 59 42 45 42 43 52 45 | 20 7b 32 30 30 37 30 3b |SYBEBCRE| {20070;|
|00005140| 7d 0a 58 73 75 62 20 53 | 59 42 45 54 50 54 4e 20 |}.Xsub S|YBETPTN |
|00005150| 7b 32 30 30 37 31 3b 7d | 0a 58 73 75 62 20 53 59 |{20071;}|.Xsub SY|
|00005160| 42 45 42 43 57 45 20 7b | 32 30 30 37 32 3b 7d 0a |BEBCWE {|20072;}.|
|00005170| 58 73 75 62 20 53 59 42 | 45 42 43 4e 4e 20 7b 32 |Xsub SYB|EBCNN {2|
|00005180| 30 30 37 33 3b 7d 0a 58 | 73 75 62 20 53 59 42 45 |0073;}.X|sub SYBE|
|00005190| 42 43 4f 52 20 7b 32 30 | 30 37 34 3b 7d 0a 58 73 |BCOR {20|074;}.Xs|
|000051a0| 75 62 20 53 59 42 45 42 | 43 49 53 20 7b 32 30 30 |ub SYBEB|CIS {200|
|000051b0| 37 35 3b 7d 0a 58 73 75 | 62 20 53 59 42 45 42 43 |75;}.Xsu|b SYBEBC|
|000051c0| 50 49 20 7b 32 30 30 37 | 36 3b 7d 0a 58 73 75 62 |PI {2007|6;}.Xsub|
|000051d0| 20 53 59 42 45 42 43 50 | 4e 20 7b 32 30 30 37 37 | SYBEBCP|N {20077|
|000051e0| 3b 7d 0a 58 73 75 62 20 | 53 59 42 45 42 43 50 42 |;}.Xsub |SYBEBCPB|
|000051f0| 20 7b 32 30 30 37 38 3b | 7d 0a 58 73 75 62 20 53 | {20078;|}.Xsub S|
|00005200| 59 42 45 56 44 50 54 20 | 7b 32 30 30 37 39 3b 7d |YBEVDPT |{20079;}|
|00005210| 0a 58 73 75 62 20 53 59 | 42 45 42 49 56 49 20 7b |.Xsub SY|BEBIVI {|
|00005220| 32 30 30 38 30 3b 7d 0a | 58 73 75 62 20 53 59 42 |20080;}.|Xsub SYB|
|00005230| 45 42 43 42 43 20 7b 32 | 30 30 38 31 3b 7d 0a 58 |EBCBC {2|0081;}.X|
|00005240| 73 75 62 20 53 59 42 45 | 42 43 46 4f 20 7b 32 30 |sub SYBE|BCFO {20|
|00005250| 30 38 32 3b 7d 0a 58 73 | 75 62 20 53 59 42 45 42 |082;}.Xs|ub SYBEB|
|00005260| 43 56 48 20 7b 32 30 30 | 38 33 3b 7d 0a 58 73 75 |CVH {200|83;}.Xsu|
|00005270| 62 20 53 59 42 45 42 43 | 55 4f 20 7b 32 30 30 38 |b SYBEBC|UO {2008|
|00005280| 34 3b 7d 0a 58 73 75 62 | 20 53 59 42 45 42 43 55 |4;}.Xsub| SYBEBCU|
|00005290| 43 20 7b 32 30 30 38 35 | 3b 7d 0a 58 73 75 62 20 |C {20085|;}.Xsub |
|000052a0| 53 59 42 45 42 55 4f 45 | 20 7b 32 30 30 38 36 3b |SYBEBUOE| {20086;|
|000052b0| 7d 0a 58 73 75 62 20 53 | 59 42 45 42 55 43 45 20 |}.Xsub S|YBEBUCE |
|000052c0| 7b 32 30 30 38 37 3b 7d | 0a 58 73 75 62 20 53 59 |{20087;}|.Xsub SY|
|000052d0| 42 45 42 57 45 46 20 7b | 32 30 30 38 38 3b 7d 0a |BEBWEF {|20088;}.|
|000052e0| 58 73 75 62 20 53 59 42 | 45 41 53 54 46 20 7b 32 |Xsub SYB|EASTF {2|
|000052f0| 30 30 38 39 3b 7d 0a 58 | 73 75 62 20 53 59 42 45 |0089;}.X|sub SYBE|
|00005300| 55 41 43 53 20 7b 32 30 | 30 39 30 3b 7d 0a 58 73 |UACS {20|090;}.Xs|
|00005310| 75 62 20 53 59 42 45 41 | 53 45 43 20 7b 32 30 30 |ub SYBEA|SEC {200|
|00005320| 39 31 3b 7d 0a 58 73 75 | 62 20 53 59 42 45 54 4d |91;}.Xsu|b SYBETM|
|00005330| 54 44 20 7b 32 30 30 39 | 32 3b 7d 0a 58 73 75 62 |TD {2009|2;}.Xsub|
|00005340| 20 53 59 42 45 4e 54 54 | 4e 20 7b 32 30 30 39 33 | SYBENTT|N {20093|
|00005350| 3b 7d 0a 58 73 75 62 20 | 53 59 42 45 44 4e 54 49 |;}.Xsub |SYBEDNTI|
|00005360| 20 7b 32 30 30 39 34 3b | 7d 0a 58 73 75 62 20 53 | {20094;|}.Xsub S|
|00005370| 59 42 45 42 54 4d 54 20 | 7b 32 30 30 39 35 3b 7d |YBEBTMT |{20095;}|
|00005380| 0a 58 73 75 62 20 53 59 | 42 45 4f 52 50 46 20 7b |.Xsub SY|BEORPF {|
|00005390| 32 30 30 39 36 3b 7d 0a | 58 73 75 62 20 53 59 42 |20096;}.|Xsub SYB|
|000053a0| 45 55 56 42 46 20 7b 32 | 30 30 39 37 3b 7d 0a 58 |EUVBF {2|0097;}.X|
|000053b0| 73 75 62 20 53 59 42 45 | 42 55 4f 46 20 7b 32 30 |sub SYBE|BUOF {20|
|000053c0| 30 39 38 3b 7d 0a 58 73 | 75 62 20 53 59 42 45 42 |098;}.Xs|ub SYBEB|
|000053d0| 55 43 46 20 7b 32 30 30 | 39 39 3b 7d 0a 58 73 75 |UCF {200|99;}.Xsu|
|000053e0| 62 20 53 59 42 45 42 52 | 46 46 20 7b 32 30 31 30 |b SYBEBR|FF {2010|
|000053f0| 30 3b 7d 0a 58 73 75 62 | 20 53 59 42 45 42 57 46 |0;}.Xsub| SYBEBWF|
|00005400| 46 20 7b 32 30 31 30 31 | 3b 7d 0a 58 73 75 62 20 |F {20101|;}.Xsub |
|00005410| 53 59 42 45 42 55 44 46 | 20 7b 32 30 31 30 32 3b |SYBEBUDF| {20102;|
|00005420| 7d 0a 58 73 75 62 20 53 | 59 42 45 42 49 48 43 20 |}.Xsub S|YBEBIHC |
|00005430| 7b 32 30 31 30 33 3b 7d | 0a 58 73 75 62 20 53 59 |{20103;}|.Xsub SY|
|00005440| 42 45 42 45 4f 46 20 7b | 32 30 31 30 34 3b 7d 0a |BEBEOF {|20104;}.|
|00005450| 58 73 75 62 20 53 59 42 | 45 42 43 4e 4c 20 7b 32 |Xsub SYB|EBCNL {2|
|00005460| 30 31 30 35 3b 7d 0a 58 | 73 75 62 20 53 59 42 45 |0105;}.X|sub SYBE|
|00005470| 42 43 53 49 20 7b 32 30 | 31 30 36 3b 7d 0a 58 73 |BCSI {20|106;}.Xs|
|00005480| 75 62 20 53 59 42 45 42 | 43 49 54 20 7b 32 30 31 |ub SYBEB|CIT {201|
|00005490| 30 37 3b 7d 0a 58 73 75 | 62 20 53 59 42 45 42 43 |07;}.Xsu|b SYBEBC|
|000054a0| 53 41 20 7b 32 30 31 30 | 38 3b 7d 0a 58 73 75 62 |SA {2010|8;}.Xsub|
|000054b0| 20 53 59 42 45 4e 55 4c | 4c 20 7b 32 30 31 30 39 | SYBENUL|L {20109|
|000054c0| 3b 7d 0a 58 73 75 62 20 | 53 59 42 45 55 4e 41 4d |;}.Xsub |SYBEUNAM|
|000054d0| 20 7b 32 30 31 31 30 3b | 7d 0a 58 73 75 62 20 53 | {20110;|}.Xsub S|
|000054e0| 59 42 45 42 43 52 4f 20 | 7b 32 30 31 31 31 3b 7d |YBEBCRO |{20111;}|
|000054f0| 0a 58 73 75 62 20 53 59 | 42 45 4d 50 4c 4c 20 7b |.Xsub SY|BEMPLL {|
|00005500| 32 30 31 31 32 3b 7d 0a | 58 73 75 62 20 53 59 42 |20112;}.|Xsub SYB|
|00005510| 45 52 50 49 4c 20 7b 32 | 30 31 31 33 3b 7d 0a 58 |ERPIL {2|0113;}.X|
|00005520| 73 75 62 20 53 59 42 45 | 52 50 55 4c 20 7b 32 30 |sub SYBE|RPUL {20|
|00005530| 31 31 34 3b 7d 0a 58 73 | 75 62 20 53 59 42 45 55 |114;}.Xs|ub SYBEU|
|00005540| 4e 4f 50 20 7b 32 30 31 | 31 35 3b 7d 0a 58 73 75 |NOP {201|15;}.Xsu|
|00005550| 62 20 53 59 42 45 43 52 | 4e 43 20 7b 32 30 31 31 |b SYBECR|NC {2011|
|00005560| 36 3b 7d 0a 58 73 75 62 | 20 53 59 42 45 52 54 43 |6;}.Xsub| SYBERTC|
|00005570| 43 20 7b 32 30 31 31 37 | 3b 7d 0a 58 73 75 62 20 |C {20117|;}.Xsub |
|00005580| 53 59 42 45 52 54 53 43 | 20 7b 32 30 31 31 38 3b |SYBERTSC| {20118;|
|00005590| 7d 0a 58 73 75 62 20 53 | 59 42 45 55 43 52 52 20 |}.Xsub S|YBEUCRR |
|000055a0| 7b 32 30 31 31 39 3b 7d | 0a 58 73 75 62 20 53 59 |{20119;}|.Xsub SY|
|000055b0| 42 45 52 50 4e 41 20 7b | 32 30 31 32 30 3b 7d 0a |BERPNA {|20120;}.|
|000055c0| 58 73 75 62 20 53 59 42 | 45 4f 50 4e 41 20 7b 32 |Xsub SYB|EOPNA {2|
|000055d0| 30 31 32 31 3b 7d 0a 58 | 0a 58 73 75 62 20 53 55 |0121;}.X|.Xsub SU|
|000055e0| 43 43 45 45 44 20 7b 31 | 3b 7d 0a 58 73 75 62 20 |CCEED {1|;}.Xsub |
|000055f0| 46 41 49 4c 20 7b 30 3b | 7d 0a 58 0a 58 73 75 62 |FAIL {0;|}.X.Xsub|
|00005600| 20 49 4e 54 5f 45 58 49 | 54 20 7b 30 3b 7d 0a 58 | INT_EXI|T {0;}.X|
|00005610| 73 75 62 20 49 4e 54 5f | 43 4f 4e 54 49 4e 55 45 |sub INT_|CONTINUE|
|00005620| 20 7b 31 3b 7d 0a 58 73 | 75 62 20 49 4e 54 5f 43 | {1;}.Xs|ub INT_C|
|00005630| 41 4e 43 45 4c 20 7b 32 | 3b 7d 0a 58 0a 58 31 3b |ANCEL {2|;}.X.X1;|
|00005640| 0a 58 0a 45 4e 44 5f 4f | 46 5f 46 49 4c 45 0a 20 |.X.END_O|F_FILE. |
|00005650| 20 69 66 20 74 65 73 74 | 20 32 37 38 38 20 2d 6e | if test| 2788 -n|
|00005660| 65 20 60 77 63 20 2d 63 | 20 3c 27 6c 69 62 2f 73 |e `wc -c| <'lib/s|
|00005670| 79 62 64 62 2e 70 68 27 | 60 3b 20 74 68 65 6e 0a |ybdb.ph'|`; then.|
|00005680| 20 20 20 20 65 63 68 6f | 20 73 68 61 72 3a 20 5c | echo| shar: \|
|00005690| 22 27 6c 69 62 2f 73 79 | 62 64 62 2e 70 68 27 5c |"'lib/sy|bdb.ph'\|
|000056a0| 22 20 75 6e 70 61 63 6b | 65 64 20 77 69 74 68 20 |" unpack|ed with |
|000056b0| 77 72 6f 6e 67 20 73 69 | 7a 65 21 0a 20 20 66 69 |wrong si|ze!. fi|
|000056c0| 0a 20 20 23 20 65 6e 64 | 20 6f 66 20 27 6c 69 62 |. # end| of 'lib|
|000056d0| 2f 73 79 62 64 62 2e 70 | 68 27 0a 66 69 0a 69 66 |/sybdb.p|h'.fi.if|
|000056e0| 20 74 65 73 74 20 2d 66 | 20 27 6c 69 62 2f 73 79 | test -f| 'lib/sy|
|000056f0| 62 70 65 72 6c 2e 70 6c | 27 20 2d 61 20 22 24 7b |bperl.pl|' -a "${|
|00005700| 31 7d 22 20 21 3d 20 22 | 2d 63 22 20 3b 20 74 68 |1}" != "|-c" ; th|
|00005710| 65 6e 20 0a 20 20 65 63 | 68 6f 20 73 68 61 72 3a |en . ec|ho shar:|
|00005720| 20 57 69 6c 6c 20 6e 6f | 74 20 63 6c 6f 62 62 65 | Will no|t clobbe|
|00005730| 72 20 65 78 69 73 74 69 | 6e 67 20 66 69 6c 65 20 |r existi|ng file |
|00005740| 5c 22 27 6c 69 62 2f 73 | 79 62 70 65 72 6c 2e 70 |\"'lib/s|ybperl.p|
|00005750| 6c 27 5c 22 0a 65 6c 73 | 65 0a 20 20 65 63 68 6f |l'\".els|e. echo|
|00005760| 20 73 68 61 72 3a 20 45 | 78 74 72 61 63 74 69 6e | shar: E|xtractin|
|00005770| 67 20 5c 22 27 6c 69 62 | 2f 73 79 62 70 65 72 6c |g \"'lib|/sybperl|
|00005780| 2e 70 6c 27 5c 22 20 5c | 28 34 36 34 20 63 68 61 |.pl'\" \|(464 cha|
|00005790| 72 61 63 74 65 72 73 5c | 29 0a 20 20 73 65 64 20 |racters\|). sed |
|000057a0| 22 73 2f 5e 58 2f 2f 22 | 20 3e 27 6c 69 62 2f 73 |"s/^X//"| >'lib/s|
|000057b0| 79 62 70 65 72 6c 2e 70 | 6c 27 20 3c 3c 27 45 4e |ybperl.p|l' <<'EN|
|000057c0| 44 5f 4f 46 5f 46 49 4c | 45 27 0a 58 3b 23 20 09 |D_OF_FIL|E'.X;# .|
|000057d0| 40 28 23 29 73 79 62 70 | 65 72 6c 2e 70 6c 09 31 |@(#)sybp|erl.pl.1|
|000057e0| 2e 32 09 31 31 2f 32 35 | 2f 39 31 0a 58 0a 58 3b |.2.11/25|/91.X.X;|
|000057f0| 23 20 54 68 69 73 20 66 | 69 6c 65 2c 20 77 68 65 |# This f|ile, whe|
|00005800| 6e 20 69 6e 74 65 72 70 | 72 65 74 65 64 2c 20 73 |n interp|reted, s|
|00005810| 65 74 73 20 74 68 65 20 | 61 70 70 72 6f 70 72 69 |ets the |appropri|
|00005820| 61 74 65 20 65 6e 76 69 | 72 6f 6e 6d 65 6e 74 0a |ate envi|ronment.|
|00005830| 58 3b 23 20 76 61 72 69 | 61 62 6c 65 73 20 66 6f |X;# vari|ables fo|
|00005840| 72 20 53 79 62 61 73 65 | 27 73 20 75 73 65 20 44 |r Sybase|'s use D|
|00005850| 42 2d 4c 69 62 72 61 72 | 79 20 26 20 69 73 71 6c |B-Librar|y & isql|
|00005860| 2e 0a 58 3b 23 0a 58 3b | 23 20 75 73 61 67 65 3a |..X;#.X;|# usage:|
|00005870| 0a 58 3b 23 09 72 65 71 | 75 69 72 65 20 27 73 79 |.X;#.req|uire 'sy|
|00005880| 62 70 65 72 6c 2e 70 6c | 27 3b 0a 58 3b 23 0a 58 |bperl.pl|';.X;#.X|
|00005890| 3b 23 20 57 65 20 64 6f | 6e 27 74 20 73 65 74 20 |;# We do|n't set |
|000058a0| 74 68 65 20 65 6e 76 69 | 72 6f 6e 6d 65 6e 74 20 |the envi|ronment |
|000058b0| 69 66 20 69 74 20 69 73 | 20 61 6c 72 65 61 64 79 |if it is| already|
|000058c0| 20 73 65 74 2e 0a 58 0a | 58 72 65 71 75 69 72 65 | set..X.|Xrequire|
|000058d0| 20 27 73 79 62 64 62 2e | 70 68 27 3b 0a 58 0a 58 | 'sybdb.|ph';.X.X|
|000058e0| 24 45 4e 56 7b 27 53 59 | 42 41 53 45 27 7d 20 3d |$ENV{'SY|BASE'} =|
|000058f0| 20 22 2f 75 73 72 2f 6c | 6f 63 61 6c 2f 73 79 62 | "/usr/l|ocal/syb|
|00005900| 61 73 65 22 20 75 6e 6c | 65 73 73 20 24 45 4e 56 |ase" unl|ess $ENV|
|00005910| 7b 27 53 59 42 41 53 45 | 27 7d 3b 0a 58 24 45 4e |{'SYBASE|'};.X$EN|
|00005920| 56 7b 27 44 53 51 55 45 | 52 59 27 7d 3d 20 22 53 |V{'DSQUE|RY'}= "S|
|00005930| 59 42 41 53 45 22 20 75 | 6e 6c 65 73 73 20 24 45 |YBASE" u|nless $E|
|00005940| 4e 56 7b 27 44 53 51 55 | 45 52 59 27 7d 3b 0a 58 |NV{'DSQU|ERY'};.X|
|00005950| 24 45 4e 56 7b 27 50 41 | 54 48 27 7d 3d 22 24 45 |$ENV{'PA|TH'}="$E|
|00005960| 4e 56 7b 27 50 41 54 48 | 27 7d 3a 24 45 4e 56 7b |NV{'PATH|'}:$ENV{|
|00005970| 27 53 59 42 41 53 45 27 | 7d 2f 62 69 6e 22 20 75 |'SYBASE'|}/bin" u|
|00005980| 6e 6c 65 73 73 20 24 45 | 4e 56 7b 27 50 41 54 48 |nless $E|NV{'PATH|
|00005990| 27 7d 20 3d 7e 20 2f 24 | 45 4e 56 7b 27 53 59 42 |'} =~ /$|ENV{'SYB|
|000059a0| 41 53 45 27 7d 2f 3b 0a | 58 0a 58 0a 45 4e 44 5f |ASE'}/;.|X.X.END_|
|000059b0| 4f 46 5f 46 49 4c 45 0a | 20 20 69 66 20 74 65 73 |OF_FILE.| if tes|
|000059c0| 74 20 34 36 34 20 2d 6e | 65 20 60 77 63 20 2d 63 |t 464 -n|e `wc -c|
|000059d0| 20 3c 27 6c 69 62 2f 73 | 79 62 70 65 72 6c 2e 70 | <'lib/s|ybperl.p|
|000059e0| 6c 27 60 3b 20 74 68 65 | 6e 0a 20 20 20 20 65 63 |l'`; the|n. ec|
|000059f0| 68 6f 20 73 68 61 72 3a | 20 5c 22 27 6c 69 62 2f |ho shar:| \"'lib/|
|00005a00| 73 79 62 70 65 72 6c 2e | 70 6c 27 5c 22 20 75 6e |sybperl.|pl'\" un|
|00005a10| 70 61 63 6b 65 64 20 77 | 69 74 68 20 77 72 6f 6e |packed w|ith wron|
|00005a20| 67 20 73 69 7a 65 21 0a | 20 20 66 69 0a 20 20 23 |g size!.| fi. #|
|00005a30| 20 65 6e 64 20 6f 66 20 | 27 6c 69 62 2f 73 79 62 | end of |'lib/syb|
|00005a40| 70 65 72 6c 2e 70 6c 27 | 0a 66 69 0a 69 66 20 74 |perl.pl'|.fi.if t|
|00005a50| 65 73 74 20 2d 66 20 27 | 74 2f 73 62 65 78 2e 70 |est -f '|t/sbex.p|
|00005a60| 6c 27 20 2d 61 20 22 24 | 7b 31 7d 22 20 21 3d 20 |l' -a "$|{1}" != |
|00005a70| 22 2d 63 22 20 3b 20 74 | 68 65 6e 20 0a 20 20 65 |"-c" ; t|hen . e|
|00005a80| 63 68 6f 20 73 68 61 72 | 3a 20 57 69 6c 6c 20 6e |cho shar|: Will n|
|00005a90| 6f 74 20 63 6c 6f 62 62 | 65 72 20 65 78 69 73 74 |ot clobb|er exist|
|00005aa0| 69 6e 67 20 66 69 6c 65 | 20 5c 22 27 74 2f 73 62 |ing file| \"'t/sb|
|00005ab0| 65 78 2e 70 6c 27 5c 22 | 0a 65 6c 73 65 0a 20 20 |ex.pl'\"|.else. |
|00005ac0| 65 63 68 6f 20 73 68 61 | 72 3a 20 45 78 74 72 61 |echo sha|r: Extra|
|00005ad0| 63 74 69 6e 67 20 5c 22 | 27 74 2f 73 62 65 78 2e |cting \"|'t/sbex.|
|00005ae0| 70 6c 27 5c 22 20 5c 28 | 34 39 37 34 20 63 68 61 |pl'\" \(|4974 cha|
|00005af0| 72 61 63 74 65 72 73 5c | 29 0a 20 20 73 65 64 20 |racters\|). sed |
|00005b00| 22 73 2f 5e 58 2f 2f 22 | 20 3e 27 74 2f 73 62 65 |"s/^X//"| >'t/sbe|
|00005b10| 78 2e 70 6c 27 20 3c 3c | 27 45 4e 44 5f 4f 46 5f |x.pl' <<|'END_OF_|
|00005b20| 46 49 4c 45 27 0a 58 23 | 21 2e 2e 2f 73 79 62 70 |FILE'.X#|!../sybp|
|00005b30| 65 72 6c 0a 58 0a 58 0a | 58 40 6e 75 6c 20 3d 20 |erl.X.X.|X@nul = |
|00005b40| 28 27 6e 6f 74 20 6e 75 | 6c 6c 27 2c 27 6e 75 6c |('not nu|ll','nul|
|00005b50| 6c 27 29 3b 0a 58 40 73 | 79 73 64 62 20 3d 20 28 |l');.X@s|ysdb = (|
|00005b60| 27 6d 61 73 74 65 72 27 | 2c 20 27 6d 6f 64 65 6c |'master'|, 'model|
|00005b70| 27 2c 20 27 74 65 6d 70 | 64 62 27 29 3b 0a 58 0a |', 'temp|db');.X.|
|00005b80| 58 72 65 71 75 69 72 65 | 20 22 2e 2e 2f 6c 69 62 |Xrequire| "../lib|
|00005b90| 2f 73 79 62 70 65 72 6c | 2e 70 6c 22 3b 0a 58 72 |/sybperl|.pl";.Xr|
|00005ba0| 65 71 75 69 72 65 20 22 | 2e 2e 2f 6c 69 62 2f 73 |equire "|../lib/s|
|00005bb0| 79 62 64 62 2e 70 68 22 | 3b 0a 58 0a 58 70 72 69 |ybdb.ph"|;.X.Xpri|
|00005bc0| 6e 74 20 22 53 79 62 70 | 65 72 6c 20 76 65 72 73 |nt "Sybp|erl vers|
|00005bd0| 69 6f 6e 20 24 53 79 62 | 70 65 72 6c 56 65 72 5c |ion $Syb|perlVer\|
|00005be0| 6e 5c 6e 22 3b 0a 58 0a | 58 70 72 69 6e 74 20 22 |n\n";.X.|Xprint "|
|00005bf0| 54 68 69 73 20 73 63 72 | 69 70 74 20 74 65 73 74 |This scr|ipt test|
|00005c00| 73 20 73 6f 6d 65 20 6f | 66 20 73 79 62 70 65 72 |s some o|f sybper|
|00005c10| 6c 27 73 20 66 75 6e 63 | 74 69 6f 6e 73 2c 20 61 |l's func|tions, a|
|00005c20| 6e 64 20 70 72 69 6e 74 | 73 20 6f 75 74 5c 6e 22 |nd print|s out\n"|
|00005c30| 3b 0a 58 70 72 69 6e 74 | 20 22 64 65 73 63 72 69 |;.Xprint| "descri|
|00005c40| 70 74 69 6f 6e 20 6f 66 | 20 74 68 65 20 64 61 74 |ption of| the dat|
|00005c50| 61 62 61 73 65 73 20 74 | 68 61 74 20 61 72 65 20 |abases t|hat are |
|00005c60| 64 65 66 69 6e 65 64 20 | 69 6e 20 79 6f 75 72 20 |defined |in your |
|00005c70| 53 79 62 61 73 65 5c 6e | 22 3b 0a 58 70 72 69 6e |Sybase\n|";.Xprin|
|00005c80| 74 20 22 64 61 74 61 73 | 65 72 76 65 72 2e 5c 6e |t "datas|erver.\n|
|00005c90| 5c 6e 22 3b 0a 58 0a 58 | 0a 58 24 64 62 70 72 6f |\n";.X.X|.X$dbpro|
|00005ca0| 63 20 3d 20 26 64 62 6c | 6f 67 69 6e 28 22 73 61 |c = &dbl|ogin("sa|
|00005cb0| 22 29 3b 09 23 20 4c 6f | 67 69 6e 20 74 6f 20 73 |");.# Lo|gin to s|
|00005cc0| 79 62 61 73 65 0a 58 26 | 64 62 6d 73 67 68 61 6e |ybase.X&|dbmsghan|
|00005cd0| 64 6c 65 20 28 22 6d 65 | 73 73 61 67 65 5f 68 61 |dle ("me|ssage_ha|
|00005ce0| 6e 64 6c 65 72 22 29 3b | 20 23 20 53 6f 6d 65 20 |ndler");| # Some |
|00005cf0| 75 73 65 72 20 64 65 66 | 69 6e 65 64 20 65 72 72 |user def|ined err|
|00005d00| 6f 72 20 68 61 6e 64 6c | 65 72 73 0a 58 26 64 62 |or handl|ers.X&db|
|00005d10| 65 72 72 68 61 6e 64 6c | 65 20 28 22 65 72 72 6f |errhandl|e ("erro|
|00005d20| 72 5f 68 61 6e 64 6c 65 | 72 22 29 3b 0a 58 0a 58 |r_handle|r");.X.X|
|00005d30| 24 64 62 70 72 6f 63 32 | 20 3d 20 26 64 62 6f 70 |$dbproc2| = &dbop|
|00005d40| 65 6e 3b 09 09 23 20 47 | 65 74 20 61 20 73 65 63 |en;..# G|et a sec|
|00005d50| 6f 6e 64 20 64 62 70 72 | 6f 63 65 73 73 2c 20 73 |ond dbpr|ocess, s|
|00005d60| 6f 20 74 68 61 74 20 77 | 65 20 63 61 6e 20 73 65 |o that w|e can se|
|00005d70| 6c 65 63 74 20 66 72 6f | 6d 20 73 65 76 65 72 61 |lect fro|m severa|
|00005d80| 6c 0a 58 20 20 20 20 20 | 20 20 20 20 20 20 20 20 |l.X | |
|00005d90| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|00005da0| 20 20 20 23 20 63 68 61 | 6e 65 6c 73 20 73 69 6d | # cha|nels sim|
|00005db0| 75 6c 74 61 6e 65 6f 75 | 73 6c 79 2e 20 57 65 20 |ultaneou|sly. We |
|00005dc0| 63 6f 75 6c 64 20 63 6f | 64 65 20 74 68 69 6e 67 |could co|de thing|
|00005dd0| 73 20 73 6f 20 74 68 61 | 74 20 74 68 69 73 0a 58 |s so tha|t this.X|
|00005de0| 09 09 09 09 23 20 66 65 | 61 74 75 72 65 20 69 73 |....# fe|ature is|
|00005df0| 20 75 6e 6e 65 63 65 73 | 73 61 72 79 2c 20 62 75 | unneces|sary, bu|
|00005e00| 74 20 69 74 27 73 20 67 | 6f 6f 64 20 74 6f 20 65 |t it's g|ood to e|
|00005e10| 78 65 72 63 69 73 65 20 | 69 74 2e 0a 58 0a 58 09 |xercise |it..X.X.|
|00005e20| 09 09 09 23 20 46 69 72 | 73 74 2c 20 66 69 6e 64 |...# Fir|st, find|
|00005e30| 20 6f 75 74 20 77 68 61 | 74 20 64 61 74 61 62 61 | out wha|t databa|
|00005e40| 73 65 73 20 65 78 69 73 | 74 3a 0a 58 26 64 62 63 |ses exis|t:.X&dbc|
|00005e50| 6d 64 28 24 64 62 70 72 | 6f 63 2c 20 22 73 65 6c |md($dbpr|oc, "sel|
|00005e60| 65 63 74 20 6e 61 6d 65 | 20 66 72 6f 6d 20 73 79 |ect name| from sy|
|00005e70| 73 64 61 74 61 62 61 73 | 65 73 20 6f 72 64 65 72 |sdatabas|es order|
|00005e80| 20 62 79 20 63 72 64 61 | 74 65 5c 6e 22 29 3b 0a | by crda|te\n");.|
|00005e90| 58 26 64 62 73 71 6c 65 | 78 65 63 28 24 64 62 70 |X&dbsqle|xec($dbp|
|00005ea0| 72 6f 63 29 3b 0a 58 26 | 64 62 72 65 73 75 6c 74 |roc);.X&|dbresult|
|00005eb0| 73 28 24 64 62 70 72 6f | 63 29 3b 0a 58 0a 58 64 |s($dbpro|c);.X.Xd|
|00005ec0| 61 74 61 62 61 73 65 3a | 20 77 68 69 6c 65 28 28 |atabase:| while((|
|00005ed0| 40 64 62 20 3d 20 26 64 | 62 6e 65 78 74 72 6f 77 |@db = &d|bnextrow|
|00005ee0| 28 24 64 62 70 72 6f 63 | 29 29 29 0a 58 7b 0a 58 |($dbproc|))).X{.X|
|00005ef0| 20 20 20 20 66 6f 72 65 | 61 63 68 20 24 6e 6d 20 | fore|ach $nm |
|00005f00| 28 40 73 79 73 64 62 29 | 0a 58 20 20 20 20 7b 0a |(@sysdb)|.X {.|
|00005f10| 58 09 69 66 28 24 64 62 | 5b 30 5d 20 3d 7e 20 2f |X.if($db|[0] =~ /|
|00005f20| 24 6e 6d 2f 29 0a 58 09 | 7b 0a 58 09 20 20 20 20 |$nm/).X.|{.X. |
|00005f30| 70 72 69 6e 74 20 22 27 | 24 64 62 5b 30 5d 27 20 |print "'|$db[0]' |
|00005f40| 69 73 20 61 20 73 79 73 | 74 65 6d 20 64 61 74 61 |is a sys|tem data|
|00005f50| 62 61 73 65 5c 6e 22 3b | 0a 58 09 20 20 20 20 6e |base\n";|.X. n|
|00005f60| 65 78 74 20 64 61 74 61 | 62 61 73 65 3b 0a 58 09 |ext data|base;.X.|
|00005f70| 7d 0a 58 20 20 20 20 7d | 0a 58 20 20 20 20 70 72 |}.X }|.X pr|
|00005f80| 69 6e 74 20 22 46 69 6e | 64 69 6e 67 20 75 73 65 |int "Fin|ding use|
|00005f90| 72 20 74 61 62 6c 65 73 | 20 69 6e 20 75 73 65 72 |r tables| in user|
|00005fa0| 20 64 61 74 61 62 61 73 | 65 20 24 64 62 5b 30 5d | databas|e $db[0]|
|00005fb0| 2e 2e 2e 22 3b 0a 58 0a | 58 20 20 20 20 26 64 62 |...";.X.|X &db|
|00005fc0| 63 6d 64 28 24 64 62 70 | 72 6f 63 32 2c 20 22 73 |cmd($dbp|roc2, "s|
|00005fd0| 65 6c 65 63 74 20 6f 2e | 6e 61 6d 65 2c 20 75 2e |elect o.|name, u.|
|00005fe0| 6e 61 6d 65 2c 20 6f 2e | 69 64 5c 6e 22 29 3b 20 |name, o.|id\n"); |
|00005ff0| 23 20 0a 58 20 20 20 20 | 26 64 62 63 6d 64 28 24 |# .X |&dbcmd($|
|00006000| 64 62 70 72 6f 63 32 2c | 20 22 66 72 6f 6d 20 24 |dbproc2,| "from $|
|00006010| 64 62 5b 30 5d 2e 64 62 | 6f 2e 73 79 73 6f 62 6a |db[0].db|o.sysobj|
|00006020| 65 63 74 73 20 6f 2c 20 | 24 64 62 5b 30 5d 2e 64 |ects o, |$db[0].d|
|00006030| 62 6f 2e 73 79 73 75 73 | 65 72 73 20 75 5c 6e 22 |bo.sysus|ers u\n"|
|00006040| 29 3b 0a 58 20 20 20 20 | 26 64 62 63 6d 64 28 24 |);.X |&dbcmd($|
|00006050| 64 62 70 72 6f 63 32 2c | 20 22 77 68 65 72 65 20 |dbproc2,| "where |
|00006060| 6f 2e 74 79 70 65 20 3d | 20 27 55 27 20 61 6e 64 |o.type =| 'U' and|
|00006070| 20 75 2e 75 69 64 20 3d | 20 6f 2e 75 69 64 5c 6e | u.uid =| o.uid\n|
|00006080| 22 29 3b 0a 58 20 20 20 | 20 26 64 62 63 6d 64 28 |");.X | &dbcmd(|
|00006090| 24 64 62 70 72 6f 63 32 | 2c 20 22 6f 72 64 65 72 |$dbproc2|, "order|
|000060a0| 20 62 79 20 6f 2e 6e 61 | 6d 65 5c 6e 22 29 3b 0a | by o.na|me\n");.|
|000060b0| 58 0a 58 20 20 20 20 26 | 64 62 73 71 6c 65 78 65 |X.X &|dbsqlexe|
|000060c0| 63 28 24 64 62 70 72 6f | 63 32 29 3b 0a 58 20 20 |c($dbpro|c2);.X |
|000060d0| 20 20 26 64 62 72 65 73 | 75 6c 74 73 28 24 64 62 | &dbres|ults($db|
|000060e0| 70 72 6f 63 32 29 3b 0a | 58 0a 58 20 20 20 20 77 |proc2);.|X.X w|
|000060f0| 68 69 6c 65 28 28 40 64 | 61 74 20 3d 20 26 64 62 |hile((@d|at = &db|
|00006100| 6e 65 78 74 72 6f 77 28 | 24 64 62 70 72 6f 63 32 |nextrow(|$dbproc2|
|00006110| 29 29 29 0a 58 20 20 20 | 20 7b 0a 58 09 24 74 61 |))).X | {.X.$ta|
|00006120| 62 20 3d 20 6a 6f 69 6e | 28 27 40 27 2c 20 40 64 |b = join|('@', @d|
|00006130| 61 74 29 3b 09 23 20 53 | 61 76 65 20 74 68 65 20 |at);.# S|ave the |
|00006140| 69 6e 66 6f 72 6d 61 74 | 69 6f 6e 0a 58 09 70 75 |informat|ion.X.pu|
|00006150| 73 68 28 40 74 61 62 6c | 65 73 2c 20 24 74 61 62 |sh(@tabl|es, $tab|
|00006160| 29 3b 09 23 20 66 6f 72 | 20 6c 61 74 65 72 20 75 |);.# for| later u|
|00006170| 73 65 2e 2e 2e 0a 58 20 | 20 20 20 7d 0a 58 20 20 |se....X | }.X |
|00006180| 20 20 70 72 69 6e 74 20 | 22 44 6f 6e 65 2e 5c 6e | print |"Done.\n|
|00006190| 22 3b 0a 58 0a 58 20 20 | 20 20 70 72 69 6e 74 20 |";.X.X | print |
|000061a0| 22 46 69 6e 64 69 6e 67 | 20 75 73 65 72 20 64 65 |"Finding| user de|
|000061b0| 66 69 6e 65 64 20 64 61 | 74 61 74 79 70 65 73 20 |fined da|tatypes |
|000061c0| 69 6e 20 64 61 74 61 62 | 61 73 65 20 24 64 62 5b |in datab|ase $db[|
|000061d0| 30 5d 2e 2e 2e 5c 6e 22 | 3b 0a 58 0a 58 20 20 20 |0]...\n"|;.X.X |
|000061e0| 20 26 64 62 63 6d 64 28 | 24 64 62 70 72 6f 63 32 | &dbcmd(|$dbproc2|
|000061f0| 2c 20 22 73 65 6c 65 63 | 74 20 73 2e 6c 65 6e 67 |, "selec|t s.leng|
|00006200| 74 68 2c 73 75 62 73 74 | 72 69 6e 67 28 73 2e 6e |th,subst|ring(s.n|
|00006210| 61 6d 65 2c 31 2c 33 30 | 29 2c 73 75 62 73 74 72 |ame,1,30|),substr|
|00006220| 69 6e 67 28 73 74 2e 6e | 61 6d 65 2c 31 2c 33 30 |ing(st.n|ame,1,30|
|00006230| 29 5c 6e 22 29 3b 0a 58 | 20 20 20 20 26 64 62 63 |)\n");.X| &dbc|
|00006240| 6d 64 28 24 64 62 70 72 | 6f 63 32 2c 20 22 66 72 |md($dbpr|oc2, "fr|
|00006250| 6f 6d 20 24 64 62 5b 30 | 5d 2e 64 62 6f 2e 73 79 |om $db[0|].dbo.sy|
|00006260| 73 74 79 70 65 73 20 73 | 2c 20 24 64 62 5b 30 5d |stypes s|, $db[0]|
|00006270| 2e 64 62 6f 2e 73 79 73 | 74 79 70 65 73 20 73 74 |.dbo.sys|types st|
|00006280| 5c 6e 22 29 3b 0a 58 20 | 20 20 20 26 64 62 63 6d |\n");.X | &dbcm|
|00006290| 64 28 24 64 62 70 72 6f | 63 32 2c 20 22 77 68 65 |d($dbpro|c2, "whe|
|000062a0| 72 65 20 20 73 74 2e 74 | 79 70 65 20 3d 20 73 2e |re st.t|ype = s.|
|000062b0| 74 79 70 65 5c 6e 22 29 | 3b 0a 58 20 20 20 20 26 |type\n")|;.X &|
|000062c0| 64 62 63 6d 64 28 24 64 | 62 70 72 6f 63 32 2c 20 |dbcmd($d|bproc2, |
|000062d0| 22 61 6e 64 20 73 2e 75 | 73 65 72 74 79 70 65 20 |"and s.u|sertype |
|000062e0| 3e 20 31 30 30 20 61 6e | 64 20 73 74 2e 75 73 65 |> 100 an|d st.use|
|000062f0| 72 74 79 70 65 20 3c 20 | 31 30 30 20 61 6e 64 20 |rtype < |100 and |
|00006300| 73 74 2e 75 73 65 72 74 | 79 70 65 20 21 3d 20 31 |st.usert|ype != 1|
|00006310| 38 5c 6e 22 29 3b 0a 58 | 20 20 20 20 26 64 62 73 |8\n");.X| &dbs|
|00006320| 71 6c 65 78 65 63 28 24 | 64 62 70 72 6f 63 32 29 |qlexec($|dbproc2)|
|00006330| 3b 0a 58 20 20 20 20 26 | 64 62 72 65 73 75 6c 74 |;.X &|dbresult|
|00006340| 73 28 24 64 62 70 72 6f | 63 32 29 3b 0a 58 0a 58 |s($dbpro|c2);.X.X|
|00006350| 20 20 20 20 77 68 69 6c | 65 28 28 40 64 61 74 20 | whil|e((@dat |
|00006360| 3d 20 26 64 62 6e 65 78 | 74 72 6f 77 28 24 64 62 |= &dbnex|trow($db|
|00006370| 70 72 6f 63 32 29 29 29 | 0a 58 20 20 20 20 7b 0a |proc2)))|.X {.|
|00006380| 58 09 70 72 69 6e 74 20 | 22 73 70 5f 61 64 64 74 |X.print |"sp_addt|
|00006390| 79 70 65 20 24 64 61 74 | 5b 31 5d 2c 22 3b 0a 58 |ype $dat|[1],";.X|
|000063a0| 09 69 66 20 28 24 64 61 | 74 5b 32 5d 20 3d 7e 20 |.if ($da|t[2] =~ |
|000063b0| 2f 63 68 61 72 7c 62 69 | 6e 61 72 79 2f 29 0a 58 |/char|bi|nary/).X|
|000063c0| 09 7b 0a 58 09 20 20 20 | 20 70 72 69 6e 74 20 22 |.{.X. | print "|
|000063d0| 27 24 64 61 74 5b 32 5d | 28 24 64 61 74 5b 30 5d |'$dat[2]|($dat[0]|
|000063e0| 29 27 22 3b 0a 58 09 7d | 0a 58 09 65 6c 73 65 0a |)'";.X.}|.X.else.|
|000063f0| 58 09 7b 0a 58 09 20 20 | 20 20 70 72 69 6e 74 20 |X.{.X. | print |
+--------+-------------------------+-------------------------+--------+--------+
Only 25.0 KB of data is shown above.
