HDTenEightyP/NetNews huggingface dataset:
From: sms@cocamrd.mel.cocam.oz.au (Steve Szalla)
Newsgroups: comp.databases.sybase
Subject: Re: Sybase/ Microsoft Server Differance
Date: 8 Nov 92 23:59:33 GMT
Organization: Co-Cam Computer Group, Oz

In article <BwuMvG.5Iy@cs.columbia.edu> lcc5@cs.columbia.edu ( Eric Chang) writes:
> <stuff deleted>
>
>(4) I remenber there's an article in DBMS Magazine ( around summer) discussing this..
>
>Eric

The article Eric refers to is in the July 92 issue of DBMS (winter here :-)). 
It also says that MS SQL Server 4.2 is still a 16-bit implementation 
whereas Sybase's are 32-bit.
-- 
 /~~` /~~\   /~~` /|  /|  /|   Steve Szalla    sms@cocamrd.mel.cocam.oz.au
|    |    |-|    /-| / | / |   Co-Cam Computer Group   Tel: +61 3 286 3456
 \__, \__/   \_ /  |/  |/  |   Melbourne, Australia    Fax: +61 3 417 7857
Newsgroups: comp.databases.sybase
From: jdn@skylinx.sa.com (John D. Nguyen)
Subject: Report writer for Sybase
Organization: Scientific Atlanta, Inc.
Distribution: us
Date: Thu, 12 Nov 92 16:55:47 GMT

I was just wondering, what is the best report writer to use with Sybase
SQL Server version 4.x?  If anyone know of a good and easy one to use
please let me know.

Thanks in advance,

John N.
.---------------------------------.-----------------------------------.
|   . |     John D. Nguyen        : "Watch out                        |
|   |(||)   Melbourne,  FL        :  You might get what you're after" |
|  `        (407) 255-3160        :                                   |
|       jdn@skylinx.sa.com        :                 - Talking Heads - |
`---------------------------------^-----------------------------------'
-- 
.---------------------------------.-----------------------------------.
|   . |     John D. Nguyen        :  "Lawyers, I suppose, were        |
|   |(||)   Melbourne,  FL        :   children once"                  |
|  `        (407) 255-3160        :                                   |
Newsgroups: comp.databases.sybase
From: chris@tartarus.uchicago.edu (Chris Johnston)
Subject: Re: Hiding a password while dumping
Organization: AM Investors, Chicago
Date: Thu, 12 Nov 1992 17:43:54 GMT

    I use a sun sparc.  On my system 'ps -eww' will display all the
environment variables including the one with the dump passwd.  However
 'isql -Ppassword' will show up in ps as
 'isql -P        '.  This is because isql replaces the password with 
blanks.  This only lets the bad guys see the length of your password.

    Something like 'isql -Usa -P`cat /.secret/sydumppw`' would
probably be most secure.

    I wouldn't trust the following since it creates a file in /tmp
isql -Usa << ReDiReCt
`cat /.secret/sdumppw`
use DB
 etc...
ReDiReCt

cj
312-786-4889

Newsgroups: comp.databases.sybase
From: thf@zelator.in-berlin.de (Thomas Funke)
Subject: Re: Sybase contact fee unfair?
Reply-To: thf@zelator.in-berlin.de (Thomas Funke)
Organization: NNU Corp. - NeXT is Not UN*X
Date: Tue, 10 Nov 1992 21:18:40 GMT

In article <wolfgang.721330801@sfu.ca> wolfgang@fraser.sfu.ca (Wolfgang  
Richter) writes:
> Funny you should mention it. Like other Sybase customers, we sometimes
> get calls from people thinking of buying the product. I just had a call
> the other day and told the person at the other end that though Sybase
> was a good product (with compiled procs, triggers, etc), make sure to
> watch out for the contact fee. As he was from a small company, I wonder
> if he is going to become a customer? I kind of doubt it.

I recently did a large project on a RS6000/AIX for a company which involved a  
good database. I really recommended SYBASE to them, but after they have talked  
to SYBASE sales-people, they wanted about 20000 US$ for a SQL-Server and  
DB-Library. PLUS those expensive support fees.

Finally, really to my regret, they decided to use INGRES which costed about  
half the price and included telephone support. Sigh !

-- 
------------------------------------------------------------------
Thomas Funke  ** E-mail: thf@zelator.in-berlin.de
NeXT-Developer * Unix-Consultant
------------------------------------------------------------------
From: slater@phx.mcd.mot.com (Rob Slater)
Subject: PD DB Clients?
Summary: Query for Public Domain Data Base Clients
Keywords: Public Domain Data Base Client-Server
Organization: Motorola Computer Group, Tempe, Az.
Date: Thu, 5 Nov 1992 21:59:25 GMT

	I am just starting a project which will include a database of
information.  I would like the information in the database to be available
to anyone who wants it.  (I.e. it will be on a computer that has both
internet and modem access.)

	My proposal is to have the database and the database engine sit
on a UNIX server.  Then I would like to distribute public domain software
that could run on a Mac, IBM PC, or a UNIX box.  I would perfer a Public
Domain database engine, but I have the budget to buy one.  But the Public
Domain client software is a must.  My users will be college students and
such and will not have money to pay for software.

	Any advice or recommendations would be helpful.

-- 
 Rob Slater                                     | "Real events do not have
 Software Engineer -- Core Technologies         |  endings;  only  stories
 Motorola Computer Division                     |  about them do"
 Internet: slater@phx.mcd.mot.com               |    -- Peter Galvin
From: glenn@sw.stratus.com (Glenn Butler)
Newsgroups: comp.databases
Subject: Re: CA Clipper 5.01a fix..  Anyone got it to work??
Keywords: CA Clipper
Date: 13 Nov 92 16:41:11 GMT
Organization: Stratus Computer, Inc.
NNTP-Posting-Host: clueless.sw.stratus.com


> to install successfully.  The only bad part about our
> experience here today is that it didn't fix the problem
> with the report generator, which is why we started this
> whole mess anyway..
> 
> Specifically, our problem with the report generator
> is that it will not produce a summary report, nor will
> it eject pages between sort groups.  Not a really major
> problem endangering our business objectives, but very
> frustrating..
> 

Russ, 


You have all the source code for both the report writer and the runtime report
system.  I haven't used the features you've talked about, but I have substantially
modified both peices of the report system for other reasons, and found it quite
easy to modify and change.  I'll bet one of your engineers could fix both those
problems in 1-2 hours of poking around, probably less time than it took you to
get and install the update...

Glenn
From: an662@cleveland.Freenet.Edu (Michael Leach)
Newsgroups: comp.databases
Subject: Clipper and FlexFile
Date: 7 Nov 1992 23:40:50 GMT
Organization: Case Western Reserve University, Cleveland, Ohio (USA)
NNTP-Posting-Host: hela.ins.cwru.edu


Brian,
FlexFile is an add-on for Clipper that uses a different
format for the .DBV than Clipper uses for .DBTs.  dBase, FoxPro,
and 'normal' Clipper programs can't access this file.  FlexFile
keeps a Character field in the database with a pointer into the
.DBV file.  As far as I know, there is no version for dBase
or FoxPro.  You should still be able to access the .DBF from dBase
or whatever, but not the memos.  FlexFile uses an extremely 
efficient method for storing its data.  It uses very small block
sizes (instead of Clipper's 512 bytes) and keeps a header of 
some sort that lists unused blocks (created as data is modified)
so they can be reused.  You might want to contact Ganahl Software
and see if they do have a version for dBase.  The only other
alternative would be to have a custom program written that
will let you browse the .DBF/.DBV pair.

Mike Leach
Programmer/Analyst
University of Cincinnati
leachmj@uc.edu
leacmj@morekypr.bitnet
an662@cleveland.freenet.edu
From: wefuchs@faui63.informatik.uni-erlangen.de (Werner Fuchs )
Newsgroups: comp.databases
Subject: Re: Clipper 5.01 left over locks
Date: Fri, 13 Nov 1992 10:34:50 GMT
Organization: CSD, University of Erlangen, Germany
NNTP-Posting-Host: faui63.informatik.uni-erlangen.de

paulb@cs.man.ac.uk (Paul Bean) writes:

>I have a program which is to run on both a network and single user.  I
>use the locks.prg supplied with clipper to do the appropriate locking
>for me.  I have one version so I do the locking even if it is on a
>single user dos machine.  I was running it single user yesterday (Dos
>5.01 by the way) when it keeled over with not enough memory.  I
>removed a couple of drivers so that there was enough memory for it to
>run and went in again, however when the program came to open the dbfs
>that were exclusively locked when it went down it could not
>open them(in shared mode).  I presumed that the lock information was
>held in the dbfs so I deleted these and went to a backup.  However
>when I tried to run the program it still wouldn't let me open the
>previously locked files.  I tried moving everything to a new
>directory,still no joy.  I have tried ringing Computer Associates who
>could not suggest anything.  Does anyone know where the lock
>information is held ? and how I can get rid of it.  This is becoming a
>real pain.

>Thanks in advance Paul 

As far as I know, the locking information is held by DOS SHARE or
by the Networking Software (on DOS Peer-to-Peer Networks like
Netware Lite by DOS SHARE at the Server). I had a similar problem
at Netware Lite when a Client running a Clipper application crashed.
The only way to get rid of the locks was restarting the Server. 
"Real" Networks should detect if a client crashes and free all locks,
but SHARE does not.
If You are running SHARE at Your single user station, try to reboot 
before starting Your Clipper application again (and delete SHARE
from Your AUTOEXEC.BAT).

Werner
--------------------------------------------------------------------------
|   Werner Fuchs   |   Universitaet Erlangen - Nuernberg   |   Germany   |
|       wefuchs@cip.informatik.uni-erlangen.de  |  Tel. 09131/26415      |
--------------------------------------------------------------------------
Newsgroups: comp.databases
From: lindsey@tincup.enet.dec.com (Randy Lindsey)
Subject: Re: Help (another try, with text this time)
Organization: Colorado Software Solutions, Inc.
Date: Thu, 5 Nov 1992 18:59:43 GMT


In article <1992Oct30.024155.5404@u.washington.edu>, elgreco@carson.u.washington.edu (Jared Vogt) writes...
> 
>The following questions maybe an exercise in meta-ignorance.
>I am looking for a database to organize various sorts 
>information, where I can create a simple search screen to
>look for that information by keyword using boolean logic.
>For example, I would like to enter all of my paper files by 
>keyword so that I could just stick any new piece of 
>information in the next sequential file and enter its
>contents in a database where I could subsequently search for
>its location.  By doing this, i am hoping to simplify my 
>seartch process for various peices of information.  It would
>encompass not only paper files, but informatoin of all 
>sorts, so that when I want to find, say, everything that I
>have (paper files, computer documents, magazine articles)
>that has to do with "x+y," the database using logic would
>search for all instances of "x+y," and list them out.  Is
>this a simple database feature?  If my above explination was 
>totally lame, maybe an existing example would help.  I want 
>to create something with the same searching mechanism as 
>Medline, or just about any other online or CD-rom database.
>I currently have Foxpro, but have not yet delved into it.  
>Another consideration.  I would like to have some interface
>in Windows if possible.  I have come accross a couple of 
>shareware viewers, that appear to allow me to search my 
>Foxpro files in Windows, but they did not have any provision 
>for logic.  Do ones with logic exist?  Do I just need a 
>Windows DB?
>Thanks in advance for any suggestions or help.
>Jared
>vango@u.washington.edu

Yes, this is a simple thing for a database to do.  Depending
upon the sophistication of the searching logic, almost any
database could do it, even the simple file manager ones.

Since you have Foxpro, try using it.  Basically, you want
to add a record to the database for every keyword in each
file/document/article/etc.  Then, you can inquire by keyword
and it will list every record that has that keyword, giving
the file number that you need to go find it.  You can get
more sophisticated, but this will do the basic retrieval.

Foxpro for Windows will be coming along (they've said before
the end of the year, probably wouldn't slip more than a month
or two), so you can upgrade to that and should be able to
use what you've already set up.

Randy Lindsey
Newsgroups: comp.databases
From: rkinder@iat.holonet.net (Robert J. Kinder)
Subject: Re: Bar Codes and Paradox
Organization: HoloNet (BBS: 510-704-1058)
Distribution: usa
Date: Tue, 10 Nov 1992 01:03:37 GMT

A Bar Code reader normally plugs in series with the keyboard to the PC. 
It acts as a ghost typist and Paradox doesn't have the slightest idea a
bar code reader is in use.  The numbers and letters that appear underneath
the bar code are xmitted as if they were typed by hand.

Look in the back of Byte or PC Magazine for Bar Code readers and call for
free info.  The hardware manufacturer will describe the interface fully
and usually supplies bar code printing software for the PC.  Real easy to use.

-- 
// ------------------------------------------------------------------------
// rkinder@holonet.net            International Software Solutions, Inc.  -
// Robert J. Kinder, Jr.                             Boca Raton, Florida  -
//                                                        1-800-788-4774  -
Newsgroups: comp.databases
From: mccon@ssdd475a.erim.org (Joe McConnell)
Subject: Re: PC Rbase Question
In-reply-to: mnewson@memstvx1.memst.edu's message of 6 Nov 92 10:42:41 -0600
Organization: Environmental Research Institute of Michigan, Ann Arbor, Michigan
Date: 9 Nov 92 17:14:44

Use the powerful Gateway capability that comes with Rbase.  It's in 
your documentation.
--
Joe McConnell  | Opinions expressed are the   | Don't blame me!  I voted for
mccon@erim.org | author's, not the employer's.| Stephen Maturin!
From: mnewson@memstvx1.memst.edu
Newsgroups: comp.databases
Subject: PC Rbase Question
Date: 6 Nov 92 04:42:41 GMT
Article-I.D.: memstvx1.1992Nov6.104241.3999
Organization: Memphis State University

I would like to know is there a way to convert a RBase table (version 3.0)
to ASCII format and if so what are the commands?


Thank you for your help
Merna Newson
Memphis State University
Memphis, TN
MNEWSON@MEMSTVX1.MEMST.EDU  (Internet Address)
Xref: sparky comp.databases:7716 comp.databases.theory:601
From: hughes@swine.cs.uiuc.edu (Eric Hughes)
Newsgroups: comp.databases,comp.databases.theory
Subject: Re: 001 Benchmark
Date: 9 Nov 92 18:01:53 GMT
Article-I.D.: m.1992Nov9.180153.8723
Organization: University of Illinois, Dept. of Comp. Sci., Urbana, IL

socrates@npac.syr.edu (Socrates Costicoglou) writes:

>Can anybody provide details of 001 Benchmark (Cattel & Skeen).

Their article is in ACM Trans. on Database Systems, May, 1990.
From: an662@cleveland.Freenet.Edu (Michael Leach)
Newsgroups: comp.databases
Subject: Clipper 5.01 record/file locks
Date: 7 Nov 1992 23:33:05 GMT
Organization: Case Western Reserve University, Cleveland, Ohio (USA)
NNTP-Posting-Host: hela.ins.cwru.edu


Paul,
I don't know where the record/file lock information is
held in Clipper files, but I've had single user apps
with the networking locks crash in a variety of ways and never
had problems accessing them when the pc/app/whatever recovered.
It's possible that the computer and/or DOS has the file locked
and not Clipper.  I don't use file locks if I can help it 
because they can trash the data if the app. crashes with the
file locked.  Try copying the data file and the EXE to a
different directory on the same pc and see if the problem
persists.

Mike Leach
Programmer/Analyst
University of Cincinnati
leachmj@uc.edu
leacmj@morekypr.bitnet
an662@cleveland.freenet.edu
From: rhaven@cruzio.santa-cruz.ca.us
Newsgroups: comp.databases
Subject: Re: Paradox 4.0 speed (?)
Summary: Paradox speed & NET
Date: Fri, 06 Nov 92 19:29:09 PST
Reply-To: rhaven@cruzio.santa-cruz.ca.us




Try using the command line argument "-codepool nnnn" and try different
numbers for "nnnn".  800 - 1200 is a good range.  If you were doing things
interactively, you wouldn't see any slowdown at all.

The NET files for Paradox 3.5 and Paradox 4.0 are different.  They can
exist in the same directory, but the directories they control cannot
overlap; you can't have 3.5 and 4.0 access data objects in the same
directory at the same time (they can take turns).

The delays in network access is one of the things Paradox 4.0 addresses.

Cheers
From: hsr4@vax.oxford.ac.uk
Newsgroups: comp.databases
Subject: Re: dbase III+ vs. dbase IV
Date: 11 Nov 92 14:44:58 GMT
Followup-To: micro.dbms
Organization: Oxford University VAX 6620

In article <1992Nov10.134148.7092@ecsvax.uncecs.edu>, dgm@ecsvax.uncecs.edu (Debby Morley) writes:
> 
> I am curious as to why so many people have held onto and prefer dbase III+ to
> the newer dbase IV.  Can someone please summarize the differences in these
> two (DOS) products for me?

I can tell you why the researchers in my unit held on to III+ instead of
migrating to IV (apart from the bugs, that is :)) - time is precious.  We are
under constant pressure to prepare and analyse data and feed the results back
up the line; we cannot afford the luxury of learning a new system (and if
you've become accustomed to III+, IV is not friendly at all) because we don't
have the time.

In an ideal world, we'd be able to take several weeks out to become as
familiar with IV as we are with III+, and then benefit from the superior speed
of IV.  However... well, you know the rest.

This answer may also be applied to the question: Why do typists still use QWERTY
when there are much more efficient systems available ?

III+ works well enough for us anyway - there is no need to upgrade to IV because
there are no advantages which are significant enough for us (there might be for
others, naturally).

We do have IV (I bought a copy with a view to persuading others to acclimatise
themselves, but there is never any time).

If I ever set up another unit's computing facilities from scratch and can take
staff who do not already have a skill base on which to draw, then I'll look
further afield - but not to IV, which is not currently the pick of the bunch :)
(with apologies to Cy at Borland).

Peter Brooks
Computing Officer
Health Services Research Unit
Newsgroups: comp.databases
From: Cy Shuster <cy@borland.com>
Subject: Re: dbase III+ vs. dbase IV
X-Xxmessage-Id: <A727EDEC0E010A2D@cy3.borland.com>
X-Xxdate: Thu, 12 Nov 92 19:18:04 GMT
Organization: Borland International
X-Useragent: Nuntius v1.1.1d10
Date: Thu, 12 Nov 1992 19:16:11 GMT

In article <1992Nov10.134148.7092@ecsvax.uncecs.edu>, dgm@ecsvax.uncecs.edu 
(Debby Morley) writes:
> 
> I am curious as to why so many people have held onto and prefer dbase III+
to
> the newer dbase IV.  Can someone please summarize the differences in these
> two (DOS) products for me?

BIAS ALERT: I work for Borland, on dBASE IV.

The most useful distinction today is in the amount of resources each
requires: III+ works fine on systems all the way back to XTs; IV works best
on newer systems. III+ can run on floppy-only systems; IV requires a hard
disk. 

Many people held on to III+ when IV came out back in '88 because of many
problems with the first release. But since then, there's been dBASE IV 1.1
and now 1.5, released in February this year by Borland. III+ was first
released in '85, practically the Bronze Age of microcomputing -- and people
wonder why it doesn't support extended memory!

If you are new to dBASE, and have a 286 or better machine and a couple of meg
free on your hard disk, I recommend dBASE IV: there have been major
improvements that make life easier for both the first-time user as well as
the experienced programmer. I see many comments from people on our CompuServe
forum who are coming over from III+ and find using the menus in the Control
Center they can easily create applications. If money's tight or your disk is
full, go for III+: you can upgrade later on, and both your data and your
programs will be compatible (the IV language is almost 100% a superset of
III+).

--Cy--                    (no offense taken, Peter!)

DISCLAIMER: My opinions only, not the company's!
Organization: University of Illinois at Chicago
Date: Thursday, 5 Nov 1992 10:02:39 CST
From: <U23176@uicvm.uic.edu>
Newsgroups: comp.databases
Subject: Clipper Internal error 1210?

I have a database file with more than 80000 records and 15 indexes. I make
sure that all 15 indexes are active everytime I update the database and
the said indexes are being reindexed every night. When we append records to the
database, it works fine; but whenever we update a field which is a key to one o
f the indexes, it sometimes gives us Internal error 1210. I tried setting order
to 0 and i thought it worked but yesterday same thing happened. Our application
is running in Novell LAN environment.  Please help!!!! I'm very desperate about
fixing this problem.  Thanks in advance.
Newsgroups: comp.databases,comp.databases.sybase
From: julies@ssf-corp.dhl.com (Julie Stephens)
Subject: help needed on sybase stored procedure
Date: Sat, 14 Nov 1992 00:03:17 GMT
Organization: DHL Worldwide Express, Redwood City, Calif., USA

I'm attempting to create a generic Sybase stored procedure which will
accept up to 254 input parameters.  Within the stored procedure
I would like to determine how many parameters were passed to the
stored procedure & process them.  To accomplish this, I'd like to
have a loop which creates input parm names on the fly & retrieve 
the values stored in those input parameters. Can this be done?

Here is an example of what I'm trying to do.  The problem here is
clear (see WHILE clause).  The program will evaluate the temporary
variable @argName--not the input parameter @arg1. 

	CREATE PROC processArguments
		@arg1	varchar(255),
		@arg2	varchar(255),
		@arg3	varchar(255),
		...
		@arg254 varchar(255)
	AS
	DECLARE @argName varchar(30)
	DECLARE @argInt  int

	ProcessArguments:
	SELECT @argInt = 1
	SELECT @argName = '@arg1'

	WHILE @argName IS NOT NULL
	  BEGIN
	    (blah, blah, blah)
	    SELECT @argInt = @argInt + 1
	    SELECT @argName = '@arg' + (SELECT CONVERT(char(3), @argInt))
	  END

Thanks!

Julie Stephens
-- 
Systems Arch., DHL Airways, Inc., 333 Twin Dolphin Dr, Redwood City, CA 94065
INET: julies@ssfarch.attmail.com  UUNET: uunet!ssfarch!julies
VOICE: (415) 802-4694	FAX: (415) 593-1689

Newsgroups: comp.databases