HDTenEightyP/NetNews huggingface dataset:
From: sethg@dcatlas.dot.gov (Seth Grimes)
Subject: Re: research Database needed - help!
Organization: U.S Dept. of Transportation
Distribution: usa
Date: Thu, 27 Aug 1992 02:09:19 GMT

ddurbin@is.rpslmc.edu (Dave Durbin) writes:

>I'm looking for a database management system to use to manage data for health
>and aging statistics. This is for a Sun Sparcstation 2. I'm familiar with
>Informix, Sybase, and Oracle, however, these DBMSs cost alot of money and may be
>overkill for what we need to start. 

>1) what are other research (medical and otherwise) areas using to manage data?

>2) what are some decent inexpensive DBMS's for the Sun platform?

You should look into Postgres, available by ftp from the Univ of Calif at
Berkeley.

But I see that you're at an .edu Internet domain.  If you're at an educational
institution you might be able to get a commercial DBMS at a large discount from
commercial prices.  For instance, Ingres, which I use and which runs on Suns
and has better technology but a reputation for being slower than the others
you named (I can't judge), has such discounts.

Seth Grimes, dcatlas!sethg@uunet.uu.net
Automated Sciences Group (U.S. Dept. of Transportation)
From: DEVRIES@NAUVAX.UCC.NAU.EDU (Ernie DeVries)
Newsgroups: comp.databases
Subject: Re: Listing .VAL and SET files HOW?
Date: 3 Sep 92 15:10:02 GMT

>In article <01GOB1CS55QQ0009KU@NAUVAX.UCC.NAU.EDU> DEVRIES@NAUVAX.UCC.NAU.EDU
>(Ernie DeVries) writes:
>>Paralex by Kallista is a commercial product that does this quite well.

>I'm sure that Alan Zenreich and Dan Ehrmann would both be much amused to
>see this: Paralex by Zenreich is from Pal By Example, and Desktop by Dan
>Ehrmann is from Kallista.

Dan is right about this and my apologies for the mix up.  Paralex is the right
product, but Pal By Example is the correct vendor.  This is what I get for
trusting my memory.

Desktop by Kallista has some documentation features that Paralex does not, but
Paralex is the product that I prefer for the need stated in the original
message.
+========================================================+
|     /\                   Ernie DeVries                 |
|    /  \/\      Academic/Personal Computer Services     |
| /\/    \ \/\       DeVries@nauvax.ucc.nau.edu          |
|   Northern Arizona University   "The Mountain Campus"  |
+========================================================+
Newsgroups: comp.databases
From: gulati@access.digex.com (Raj K. Gulati)
Subject: paradox: example elements in an OR expression
Reply-To: gulati@access.digex.com
Organization: Express Access Online Communications, Greenbelt MD USA
Distribution: usa
Date: Thu, 27 Aug 1992 04:24:16 GMT

I recently posted a JOB/CANDIDATE application problem, where the goal
of the query is to match a job with candidates, where the fields in
either could be matching, or blank.

This would be easy if it were not for the restriction that paradox
does not allow example elements to be combined in an OR expression,
for example:  ~123 or BLANK, which then could be placed in all the
fields of both ask tables.

Anyone have any ideas on how to either Query, or PAL program around
this? Help.


-- 
Raj K. Gulati, Unix Technology, M/S MC07B, G.E. INFORMATION SERVICES, 401 North
 Washington Street, Rockville, MD 20850, USA. [QK: RAJ@GEIS] 1-(301)-340-5204
  CompuServe: 70323,1430  Internet: gulati@access.digex.com, GEnie: R.GULATI
  *** This message is submitted with no intended representation of G.E. ***
From: howard@castor.cs.uga.edu (Les Howard)
Newsgroups: comp.databases
Subject: Help needed with a querry
Date: 26 Aug 92 03:18:03 GMT
Article-I.D.: athena.1992Aug26.031803.1055
Distribution: usa
Organization: University of Georgia, Athens
Originator: howard@castor

I am trying to insert items into one field of a table generated by 
concatanating two fields in another table.  Example of desired results.

	TABLE1					 TABLE2
   LOT      LOCATION				 LOTLOC
--------   ----------			        --------
081992	     OpFloor				081992OpFloor
081992	     Warehouse				081992Warehouse
082092	     Warehouse				082090Warehouse

I am envisioning using a querry probably based on something like.
INSERT INTO TABLE2 (LOTLOC) SELECT LOT,LOCATION FROM TABLE1
Does anyone have any good ideas on how to make this work?  
All the fields I want to concatanate are strings.  I am using
SQL in the querry manager from OS/2 1.3.  Please reply to me by 
email as our news feed is occasionally flakey here.

	Thanks,

-- 
===========================================================================
Mr. Leslie P. Howard                    "Mr. Lehrer's muse (is) not    
University of Georgia                    fettered by such inhibiting  
howard@castor.cs.uga.edu                 factors as taste"...New York Times 
Newsgroups: comp.databases
From: rols@tk1003.shearson.com (Roland King)
Subject: Paradox translator/compiler
Organization: Lehman Brothers
Distribution: comp.databases
Date: Fri, 4 Sep 1992 01:31:45 GMT


Somebody I was chatting to a few weeks ago claimed they had seen/ had on a disk somewhere, a
paradox to C translator or maybe a straight paradox compiler.( I think it was the former). I
quizzed him, and he definitely wasn't talking about either Paradox runtime or the Engine. 
Of course, he could neither remember where he'd heard it, nor produce the disk !
SO, have any of you Paradox guys out there ever seen, heard about or used this elusive product.

Please either mail to the group or direct to me at rols@shearson.com with any clues whether
positive or negative.

Thanks in advance .....
					Rols
Newsgroups: comp.databases
From: dbeedle@rs6000.cmp.ilstu.edu (Dave Beedle)
Subject: Biographical/Historical database?
Date: Wed, 26 Aug 1992 19:27:10 GMT
Organization: Illinois State University

   I'm not sure how to describe this but...I've got a user who whould like a 
database system to track biographical and historical type information.  The 
data she has collected does not fit well into the typical database structure; 
some of it does but one part in particular is pretty much free form text.  
This text is biographical or historcal in nature.  I'm familiar with dBase and 
in those terms a  memo  field would be the closest thing.  The probem with 
memo fields is manipulating and printing them out...they are also not big 
enough.  Any body got any ideas as to a database which might handle this kind 
of information best?  Thanks!
-- 
  Dave Beedle                                    Office of Academic Computing
                                                    Illinois State University
  Internet:  dbeedle@rs6000.cmp.ilstu.edu                    136A Julian Hall  
  "Relax, don't worry!  Have a homebrew!"                  Normal, IL   61761
Newsgroups: comp.databases
From: ramirez@IASTATE.EDU (Richard G Ramirez)
Subject: Interfacing OO to relational DBMS??
Reply-To: ramirez@IASTATE.EDU (Richard G Ramirez)
Organization: Iowa State University
Date: Tue, 1 Sep 1992 22:36:25 GMT

Can anybody provide specific information on links
between object-oriented languages and DBMS to
relational (SQL) DBMS?  

I would like to see description of specific classes
and methods.

I am also in the process of buying Actor/Professional
for Windows 3.1 and plan to interface it with 
Quadbase/SQL.  Actor is said to have a collection
of classes for interfacing to SQL, but I would like
information on other systems.
From: wesleyl@genghis.borland.com (Wesley Leung)
Newsgroups: comp.databases
Subject: Re: Inserting charcters in typeahead buffer, DBASEIV
Date: 27 Aug 92 16:15:19 GMT
Article-I.D.: genghis.1992Aug27.161519.24060
Organization: Borland International
Originator: wesleyl@genghis.borland.com

>HI,
>I'm trying to insert characters into the typeahead buffer in a DBASEIV
>application. I'm looking for something that does what the "keyboard"
>command in clipper or foxpro does. Any ideas on this would be greatly
>appreciated. Thank-you.

Have you tried the KEYBOARD command in dBASE IV version 1.1? <g>

Wes,
-- 
Wes,
Xref: sparky comp.databases:6351 comp.unix.aix:9117
From: jmp@sobeco.com (j.pigeon)
Newsgroups: comp.databases,comp.unix.aix
Subject: DBVISTA and lockmngr (errno=22)
Summary: Need help about a nasty error in message queue interface
Keywords: DBVISTA, MSGRCV, AIX
Date: 26 Aug 92 18:03:56 GMT
Organization: Sobeco Ernst & Young


Hi netlander!


	we are experiencing probleme with one of our application:
	
	From the DBVISTA (version 3.20) lockmgr enter in a dead loop
	and send continiously the message "MSGRCV error 22"; according
	errno and msgrcv function, the trouble is an "invalide msgqueueid"
	in the msgrcv system function call.

	Facts:
	1) That append only on AIX (3.2), we have two other platforms
	   (Mips and SCO) where the probleme never occur (same application
	   build around DB-VISTA).

	
	2) The repetition probleme is cause by a slight default in
	   the code from Raima, but the wrong msgqueueid must be a real
	   problem...


	3) It seems there is no relationship between load (number of
	   users connected to the application via the lockmngr) and
	   the problem occurence.


	Questions:
	1) Did somebody experienced such problem? (how did you resolve it?)

	2) Could somebody suggest a way to duplicate the probleme at will?


	Could you email your answer to jmp@sobeco.com.

Thanks for your help.

PS:	I call Raima, but they were not really helpfull,
	- "Never seens such a problem"
	- "Will have a new release for AIX someday"
	- "Call you later a soon we have new data"



-- 

Jean-Marc Pigeon
jmp@sobeco.com, jmp@comback.uucp
Newsgroups: comp.databases
From: schansen@amc.com (Scott Hansen)
Subject: dbFast.
Organization: Applied Microsystems, Redmond, WA
Date: Thu, 27 Aug 1992 18:35:43 GMT

>> If you can wait a little while, Clipper will be coming out for Windows.  I'm
>> not sure exactly when, but I think CA is still going forward with the Windows
>> version of Clipper.  I know Nantucket was rolling along with it before the 
>> buy out...Anybody out there heard different?

>Will CA really support two products that have the same target group?
>DbFast was supposed a tool to convert Dbase and Clipper applications
>to Windows! And they seem to support dbFast (Version 2.0 is expected
>for the near future). I will try to check it out, and as soon I get
>more information, I will post it.

I recently read where CA stated the future of dbfast and Clipper.
The migration path indicated they would merge into a single product
"Aspen" (Clipper for Windows).  This is the project which Nantucket
has been working on for the past three years...

-Scott
-- 
==============================================================================
Scott Hansen (schansen@amc.com)           Sysop...:  The Crystal Chip 
Applied Microsystems Corporation          BBS.....:  (206) 226-6550    
Redmond, Washington  98073                Voice...:  (206) 882-5322
Xref: sparky comp.databases:6411 comp.unix.sysv386:13737 comp.unix.misc:3414 comp.unix.questions:10477 comp.unix.programmer:4479 comp.windows.x.apps:866
From: jamesc@genghis.borland.com (James Chuang )
Newsgroups: comp.databases,comp.unix.sysv386,comp.unix.misc,comp.unix.questions,comp.unix.programmer,bnr.unix,comp.windows.x.apps
Subject: Re: XBASE Unix database
Date: 28 Aug 92 17:01:05 GMT
Article-I.D.: genghis.1992Aug28.170105.1874
Distribution: usa
Organization: Borland International
Originator: jamesc@genghis.borland.com

How about the real thing? dBase IV version 1.1 is availables for:
Sun Sparc
Sun 3
SCO Unix
RS6000/AIX
VAX/VMS
MAC
and MSDOS, of course.  The Latest DOS version is 1.5.

I hope I didn't forget a platform....

jamesc

<#include disclaimer.h>
Newsgroups: comp.databases,comp.databases.theory,comp.databases.oracle
From: v045100@otis1.stortek.com (Jennifer Farnham)
Subject: Subscribe to Newsgroup/ Table Driven Reports
Reply-To: v045100@otis1.UUCP (Jennifer Farnham)
Organization: Storage Technology Corp.
Date: Wed, 2 Sep 1992 21:34:57 GMT


Two Questions:

1. How do you subscribe to this newsgroup via
   email?

2. Has anyone developed a Table Driven Reporting
   System? If so, could I possibly see design,
   or tables?  Currently , we have ours
   hard coded into Sql*Forms and we want to make
   it more dynamic.

Thanks,

Jennifer Farnham
"v045100@query.stortek.com"
Boulder, Colorado


Newsgroups: comp.databases
From: cyj9h@csissun12.ee.Virginia.EDU (Charles Y. Choi)
Subject: Yet Another Simple (?) Question on Paradox
Keywords: Unique Record Field, Paradox
Organization: University of Virginia
Distribution: na
Date: Mon, 31 Aug 1992 19:58:06 GMT


Here's a question that I've yet to figure out.  When creating a new record,
how can you get a field in that record (say ID) to automatically be filled
in with the record number?  For example
____________________________________________________________
Rec. #  |   ID   |  First   |  Last | ...
------------------------------------------------------------
   1    |   1    |  Jane    | Smith |
------------------------------------------------------------
   2    |   2    |   Bob    | Frank |
------------------------------------------------------------
   3    |   3    |  Mary    |  Jane |
            ^
	As each new record in this table is generated, an ID number is
	generated.  A problem though is if you enter a blank record.  If you
	write a macro that reads the record number and inserts it into ID
	during EDIT mode, when you save the table, the synchronization
	between the record number and the ID is lost.

_____________________________________EDIT___________________
Rec. #  |   ID   |  First   |  Last | ...
------------------------------------------------------------
   1    |   1    |  Jane    | Smith |
------------------------------------------------------------
   2    |        |          |       |
------------------------------------------------------------
   3    |   3    |  Mary    |  Jane |

After saving...
_____________________________________MAIN___________________
Rec. #  |   ID   |  First   |  Last | ...
------------------------------------------------------------
   1    |   1    |  Jane    | Smith |
------------------------------------------------------------
   2    |   3    |  Mary    |  Jane |


So what do I want?  All I really want to do is have an automated
way of generating a unique ID for each record period.

Can anybody here help?

Thanks!


-Charles Y. Choi
cyj9h@Virginia.EDU
-- 
"What a morning!  Birds, fish, frogs, and humans!"
                                      -Maya the Bee
Xref: sparky comp.databases:6488 bit.listserv.dbase-l:892
From: michaelh@g2syd.genasys.com.au (Michael Haldey)
Newsgroups: comp.databases,bit.listserv.dbase-l
Subject: Re: Clipper: Backup/Restore routines for BIG files...
Date: 2 Sep 92 00:12:49 GMT
Organization: Genasys II, Sydney, Australia

In article <1992Sep1.114959.11104@cs.tu-berlin.de> schli@cs.tu-berlin.de (Wolfram Schlickenrieder) writes:
>
>	Hi there...
>
>	I'm stuck: I wanted to write a backup & restore routine for an
>	application I wrote before, but I have got a few data bases
>	which are HUGE (2-4MB) and therefore won't fit on a single
>	disc. Has anyone out there done that before from within a
>	Clipper application (without using "run backup ..." of
>	course)? 
>
>	Any help is appreciated...
>
>	...Wolfram

This is how I did it.
I read .dbf file as a binary file and then copied it to several
sequentional floppy disks with arch file names <root_name>.00; ...01 etc. 
In the beginning there was a binary header with the length of the file, 
original name, 'continue' flags etc.

This could be done within the Clipper application. But there were some
problems: 1. you can not provide error (i.e. CRC) control; 2. you can
not realize which type of floppy disk do you have; 3. it is quite slow,
because you can not control the buffering.

At the end we switched to the C routine which did all the things. By the
way, if you use a packing program ( pkzip or similar ) it will reduces 
your .dbf to 30-70% of the original size. It is especially important if 
you have a 'rare' filled .dbf with 0's or blanks (in one of my application 
pkzip reduced file from 200k to 15k). (Of course, you have to either buy 
the program for every copy you sell or write a clone using published 
formats of the packed file).

My 0.02
Michael
-- 
Michael Haldey  |  Genasys II Pty Ltd
                |  13th Level, 33 Berry St, North Sydney, NSW, Australia
                |  Phone:    +61-2-954-2878 (-9930 FAX)
                |  Internet: michaelh@g2syd.genasys.com.au
Newsgroups: comp.databases
From: dbeedle@rs6000.cmp.ilstu.edu (Dave Beedle)
Subject: DBASEIV: Display won't work?
Date: Fri, 04 Sep 1992 15:37:11 GMT
Organization: Illinois State University

   Hi all!  If got a problem with a dbase program which work fine under 
dbaseIII plus.  Under dbase IV (1.5) a display command won't work from within 
the program.  HTe command has the form

        display off name, address, phone for &srchfld.

   &srchfld is a macro with something like t0=" " .and. t1=" " .and. t2=" "

  I can enter the command from the dot prompt and all goes well but it seems 
as if the program just ignores the display command.  There are records in the 
database which meet the search criteria. 

   Is this a problem folks have had?  Is there a fix?

Thanks!
-- 
  Dave Beedle                                    Office of Academic Computing
                                                    Illinois State University
  Internet:  dbeedle@rs6000.cmp.ilstu.edu                    136A Julian Hall  
  "Relax, don't worry!  Have a homebrew!"                  Normal, IL   61761
Newsgroups: comp.databases
From: vv@mbunix.mitre.org (Ventrone)
Subject: Re: Standard for Data Dictionary
Organization: The MITRE Corporation, Bedford, MA
Date: Tue, 1 Sep 1992 16:43:09 GMT

In article <wai.715319293@csuvax1> wai@csuvax1.csu.murdoch.edu.au (Julian Wai) writes:
>Hi,
>
>Is there a standard for data dictionary?  Any information, references are
>appreciated.
>
>Thanks in advance
>julian
>wai@csuvax1.csu.murdoch.edu.au

The only DD standard that I am aware of is IRDS, which is defined in several
ANSI standards:  the Information Model, Command Language Interface 
(X3.138-1988) and a Services Interface (X3.185-1992).  You might also check
an article that appeared in Comm. of the ACM by Daniel Dolk & Robert Kirsch,
"A Relational Info. Resource Dictionary System", Vol. 30 No. 1, Jan 87.

-- 
   Vince Ventrone
   The MITRE Corporation       "...In my opinion, there's nothing in this
   Bedford, MA 01730           world beats a '52 Vincent
   vav@mitre.org               and a redheaded girl."  -- Richard Thompson
From: mikes@ars2.uucp (Mike Schlosser)
Subject: Has any one heard of FOCUS ?
Organization: Automated Retail Systems, Seattle, Wa
Date: Thu, 27 Aug 1992 20:56:53 GMT
Keywords: FOCUS

The heading says it all.

Its a database system that runs on DOS and other systems, which, I don't know.

Any info would be helpful.

Thanks in advance.

Mike Schlosser

-- 
  Mike Schlosser <mikes@ars2.UUCP> |Voice:(206)325-8922| AI: The Art Of Making
  Automated Retail Sys., Seattle   |FAX  :(206)325-9127|     Computers As 
  R & D,  Programmer/Analyst       |Standard Disclaimer|     Stupid As Humans.
From: lapworth@mizar.usc.edu (Bill Lapworth)
Newsgroups: comp.databases
Subject: Your Clipper 5.01 code wanted
Date: 4 Sep 1992 10:03:02 -0700
Organization: University of Southern California, Los Angeles, CA
NNTP-Posting-Host: mizar.usc.edu

I'm an experienced dBase programmer who has been doing non-stop Clipper
for 3 months, and love it.  However, I work in a one-person shop, so
there is nobody else's code to learn from. (Yeah, I know about books,
have Rick Spence's, but I want to see other people's use of the
language).

I'd like a sampling of your frequently used routines( prefer < 500
lines and self contained - not a fragment of something else).
The more elegent the better, the weirder the better!

Go ahead, flood my mailbox.
Newsgroups: comp.databases,comp.databases.theory,comp.databases.oracle
From: chill@cc.curtin.edu.au
Subject: Windows DAL client wanted for VAX/VMS RDB Database
Organization: Curtin University of Technology
Date: Wed, 2 Sep 1992 01:13:19 GMT

I need help on DAL (Database Access Language) client software for Windows 3.1.

We have a DAL server software on our VAX/VMS system. I have successfully
accessed RDB databases on that system via DAL protocol from a Mac running
MS-Excel v4 and also DataPrism under Mac System Software v7.

Since a majority of our administrative staff (for whom we would like to
develop DAL client applications) have PC+Win 3.1, I have to find a client 
package which enables me to do on a PC what I've already done on the Macs.

DAL client software is included in the Mac OS, so one just needs a user
interface (Excel/dataPrism), a network link (Appletalk or Ethertalk) 
and you're away.

Can anyone advise me of software that does what I want? I gather that
Blythe's Omnis 7+ for Windows does provide links to DAL servers, but comes
at an appallingly high cost for a single license. 

Unless there's some cheaper software options, it would be cheaper and easier 
for us to sell off the PCs and buy Macintoshes through the 
University Consortium and get DAL access by default(!)

Other information: most PCs are running DOS 5, Windows 3.1, networked via
Novell 3.11 over an ethernet which is also linked to the VAX. (I am hoping
that DAL client software will be smart enough not to need Digital's
Pathworks for DOS networking software, since we have by and large
left it in favour of the faster and smaller Novell software)

Thanks in advance for any assistance you may be able to offer!

Ian Hill
Curtin University of Technology
Western Australia
From: trrgre03@uctvax.uct.ac.za
Newsgroups: comp.databases
Subject: CodeBase++ database class library
Date: 2 Sep 92 09:02:07 +0200
Organization: University of Cape Town

I was wondering if anyone can help me.

I have heard about a C++ class library for accessing dBase IV datafiles and
index files, called CodeBase++ (as distinct from Codebase).

Has anyone had experience with CodeBase++, or have any information about it. I
would appreciate any comments.

Also, I would be very grateful if someone could post me some example code that
makes use of the libraries. This would probably be very useful for getting an
overview of how CodeBase++ does things.

Any responses would be very much appreciated (preferably e-mail), especially
example code.

Thanks in advance,

Gregory Torrance
trrgre03@uctvax.uct.ac.za

Newsgroups: comp.databases
From: mccon@ssdd475a.erim.org (Joe McConnell)
Subject: Re: Simple Question on Paradox
In-reply-to: naren@tekig5.pen.tek.com's message of 25 Aug 92 06:27:19 GMT
Organization: Environmental Research Institute of Michigan, Ann Arbor, Michigan
Date: 25 Aug 92 17:22:19

Depends on what you mean by "merge two tables."

If you mean append the contents of one table to another, identically
structured, table, see Tools, More, Add, Users's Guide, Page 211.

If you mean a join of some kind, see your User's Guide, Pages 44 to 106.

--
Joe McConnell  | Opinions expressed are the   | People like Ross Perot made
mccon@erim.org | author's, not the employer's.| this country what it is today.
From: clements@athena.cs.uga.edu (Brian Clements)
Newsgroups: comp.databases
Subject: PD Client Softare of Sun4
Date: 27 Aug 92 15:32:49 GMT
Article-I.D.: athena.1992Aug27.153249.29004
Distribution: usa
Organization: University of Georgia, Athens


I am looking for some SQL software to run on my Sun4 that will connect
to a SQL server on a local VAX.  I tried using ARCHIE but had no
success.

Does anyone know of a anymous FTP site that has something?

				Thankyou in Advance,
				Brian

----------------------------------------------------------------
brian@cosmic.cosmic.uga.edu        COSMIC
clements@athena.cs.uga.edu         (706)542-3265
Newsgroups: comp.databases
From: tomho@microunity.com (Tom Ho)
Subject: client/server technology
Organization: MicroUnity Systems Engineering, Inc.
Distribution: ca
Date: Wed, 26 Aug 1992 17:34:14 GMT

Hi netters:

I am interested in learning more about the client/server technology.  Could someone suggest any books/articles about the subject.  Thanks much.
--
     Tom Ho       tomho@microunity.com       (408) 734-8100
Newsgroups: comp.databases,bit.listserv.dbase-l