HDTenEightyP/NetNews huggingface dataset:
From: isc40004@nusunix1.nus.sg (TAN CHEE YONG)
Subject: Request: Documentation for Requiem
Organization: National University of Singapore
X-Newsreader: TIN [version 1.1 PL6]
Date: Fri, 6 Nov 1992 16:20:48 GMT

Hi,
Can anyone mail me any documentation on Requiem, or tell me where to get
them?
Also, where can I get the most updated copy of Requiem?
Please email.

Thanks,
Tan Chee Yong
National University of Singapore
email:isc40004@nusunix.nus.sg
Xref: sparky comp.databases:7827 comp.databases.oracle:2195 comp.databases.ingres:1881
From: zhang@cs.rochester.edu (Zhang Ju)
Newsgroups: comp.databases,comp.databases.oracle,comp.databases.ingres
Subject: I heard a Rumor about Oracle 7 and Forms
Date: 13 Nov 92 18:47:31 GMT
Organization: Computer Science Department University of Rochester


I heard a rumor which goes that the delay of ORACLE 7 is because of its
incompatibility with Forms 3. So Oracle 7 is actually waiting for Forms 4.


Will Oracle 7 cease to support Forms 3? This makes migration more difficult.


Ju Zhang

zhang@dlbsys.com
From: leilas@ems.cdc.com (Leila Schneberger)
Newsgroups: comp.databases
Subject: Re:Paradox-Setting all fields to same value
Date: 9 Nov 92 16:39:38 GMT
Reply-To: leilas@ems.cdc.com
Organization: Empros Systems International, a division of Ceridian

Thanks to all who replied! I was surprised by the number of ways that
Paradox is able to do this.
In article <30076@nntp_server.ems.cdc.com>, leilas@ems.cdc.com (Leila Schneberger) writes:
|> For each record in a table, I want to set all ocurrences of a field
|> to some value (YearlyDues = "NotPaid"). How do I do this in Paradox?
|> 
 
In QBE (Ask) in field 'YearlyDues', type:

	CHANGETO NotPaid

Press F2.

ps  This is clearly covered in the User Guide under 'Ask'.
--------------------------------

Script - editor -write (or new in 4.0) - Whatevername

edit "Name_of_the_table"
scan
    [yearlydues]="Notpaid"
endscan
do_it!

Then press F10 ang G (as Go)

-------------------------------

	hi, you could do something like:

	aTable = "mytable"

	?? "Enter Init Value: "
	ACCEPT  "A12" TO Value        ; get the value to init with
				      ; must match type in table

	EDIT aTable
	MOVETO[ myfield ]	; move to the field to act upon
	[myfield] = Value	; put into first record in table

	FOR i FROM 1 TO NRECORDS(atable) - 1
		DOWN			; move to next rec
		DITTO
	ENDFOR
	; from PAL guide pg 276

	        
	- ps you could make this into a reusable procedure.
	     also, see PAL User's Guide, pg276 v3.5
		
	save it as a script, and run it on the table, 
	or you could simply record the keystrokes of moving down
	to the next record, then typing ditto.  STop record
	and play the resulting script using repeatplay choice,
	play it the number of records in the table..

-----------------------------

Use any TEXT editor, create a file called "change.sc".

FILE CONTENTS:

edit "tablename"    <-- replace with your table (quotes are necessary)
scan
  [YearlyDues] = "NotPaid"
endscan
do_it!

END OF FILE

In Paradox, use menu commands <Scripts> <Play>, then enter "change"

----------------------------

 That's it!
Newsgroups: comp.databases.theory
From: kamal@cc.gatech.edu (Kamal Karlapalem)
Subject: Public Domain Distributed Relational Database System.
Reply-To: kamal@cc.gatech.edu (Kamal Karlapalem)
Organization: College of Computing / Georgia Tech
Date: Wed, 11 Nov 1992 02:09:02 GMT



Is there any public domain distributed relational database
system which supports 

1). vertical and horizontal fragmentation of relations, 
2). and location transparency?


Thanks,
Kamal.

*******************************************************************************
kamal@cc.gatech.edu                     Kamalakar Karlapalem

Database Research Laboratory,           College Of Computing, 
Georgia Institute Of Technology,        Atlanta, GA 30332-0280.                  
*******************************************************************************
From: gmclarno@gssec.bt.co.uk (Gerry McLarnon)
Newsgroups: comp.databases.theory
Subject: Scalability of Database Systems
Date: 9 Nov 92 16:25:04 GMT
Organization: BT

Hello everyone,

at present I am looking at the issues involved with scaling up small/medium sized database systems and, in particular, the problems involved in introducing large scale databases into an open systems environment. If you have any  problems, solutions, theories, etc, or references to work in this area, then I would be grateful if you would pass them onto me.

Thanks Gerry.
From: john@mikejag.wimsey.bc.ca (John A. Green)
Newsgroups: comp.databases.theory
Subject: Re: computers in literature
Date: 10 Nov 92 05:34:43 GMT
Article-I.D.: mikejag.1992Nov10.053443.23231
Organization: mikejag (mike) is a private system in Vancouver, BC, Canada

In article <9NOV199215281054@adpdp2.lanl.gov> 108116@adpdp2.lanl.gov (108116) writes:
>Be sure to check-out "The Man Who Sold the Moon" by R. Heinlein.  It will by in
>Sci. FIc.  To me, it's the best description of computer potential in literature.

Darn; it's been a while since I read "The Man Who Sold the Moon", but
I can't remember there being a computer in it.

Another book by Heinlein, "The Moon is a Harsh Mistress", has my all
time favourite computer in it, "Mike".  (Note the name of my system *8-)

Mike was a computer on the moon that got so big that it got to be
sentient.

Isn't there a project somewhere in the States where they are working on
AI by using the same sort of idea?  They just keep feeding this huge
computer all kinds of data all day, every day, let it chug away at night
to draw conclusions, and then they analyze the conclusions that it drew.

Does anyone know of any information about this project is available
anywhere on The Net?
-- 
John A Green                           PROGRESS programmer at large   
john@mikejag.wimsey.bc.ca              Vancouver, Canada
Newsgroups: comp.databases.theory
From: giber@pollux.cs.uga.edu (Carolyn Giberson)
Subject: Re: computers in literature
Originator: giber@pollux
Organization: University of Georgia, Athens
Date: Mon, 9 Nov 1992 12:48:47 GMT

Article: 575 of comp.databases.theory
Subject: Human Computers....

>Hello all:

>I need some help....  I'm looking for examples in fiction literature
>of super sophisticated communicative computers a la HAL. That is,
>computers that talk and communicate like humans.  I'm not so much 
>interested in those instances where it's a robot that cannot be
>distinguished from a human being as in computers sounding human without
>being almost totally human-like....  .

>Thanks in advance.
>Ahmed 

You might want to check out "The Ship Who Sang" by Anne McCaffrey.

Carolyn Giberson
University of Georgia

Newsgroups: comp.databases.theory
From: 108116@adpdp2.lanl.gov (108116)
Newsgroups: comp.databases.theory
Subject: Re: computers in literature
Date: 9 Nov 92 22:28:00 GMT
Article-I.D.: adpdp2.9NOV199215281054
Organization: Los Alamos National Laboratory, EMVAX
News-Software: VAX/VMS VNEWS 1.41

> 
>>I need some help....  I'm looking for examples in fiction literature
>>of super sophisticated communicative computers a la HAL. That is,
>>computers that talk and communicate like humans.  I'm not so much 
>>interested in those instances where it's a robot that cannot be
>>distinguished from a human being as in computers sounding human without
>>being almost totally human-like....  .

Be sure to check-out "The Man Who Sold the Moon" by R. Heinlein.  It will by in
Sci. FIc.  To me, it's the best description of computer potential in literature.

2nd best is "The Adolescence of P-1" by ????.  This should be in Sci. FIc. but
is often mis-filed in psychology!

Heather Albright
e-mail: 108116@em.lanl.gov
Compuserve: 76350,3151
Newsgroups: comp.databases
From: mickan@rossinc.com (Michael J. Andrew)
Subject: Involuntary rollbacks....does your dbms do this?
Organization: Ross Systems, Inc.
Date: Wed, 4 Nov 1992 01:53:43 GMT

My "problem" relates to Ingres.  What I need to know is, does this behaviour
extend to other databases in general.  Right now I know the answer is
"no" for Rdb.


Symptom:

    OPEN cursor C on table T1
    FETCH from C
    FETCH from C
    FETCH from C
    ...			(no problem so far)
    FETCH from C
    INSERT to table T2	( this insert fails, due to having a duplicate
			      primary key, or index values, or whatever the
			      right dbms term it!)
			(This is the correct behavior for the application)
    FETCH from C

    The last fetch fails, with the message "Cursor not open"


Diagnosis:

    Ingres performs a ROLLBACK whenever an attempt is made to perform
    an INSERT which fails.


Discussion:

This makes no sense to me.  This code came from a file based application
which is using an algorithm to find an empty slot in a "table" by attempting
to write records (which may be duplicates with existing ones) until
a write finally succeeds (after changing some of the index values).

Is there something in ANSI which requires this behaviour, or is this a
quirky Ingres thing?

What does your database do?
-- 
--------------------------------------------------------------
Michael J. Andrew	Ross Systems Inc.	(415) 593 2500
..!fernwood!rossix!mick
mick@rossinc.com
Newsgroups: comp.databases,comp.databases.ingres,comp.databases.oracle,comp.databases.sybase,comp.databases.informix
From: sethg@dcatlas.dot.gov (Seth Grimes)
Subject: Re: Ingres questions followup
Organization: U.S Dept. of Transportation
Distribution: usa
Date: Thu, 12 Nov 1992 03:18:22 GMT

thompson@stars.gsfc.nasa.gov (William Thompson, code 682.1, x2040) writes:

>  It appears
>that this is true even on VAX machines, where text files have traditionally
>been restricted to 255 characters per line.

Huh?  If there was such a restriction, it hasn't been around in a while.
Perhaps you're thinking about the former limitations of some of the editors
in handling wide lines, which don't (for all practical purposes) exist any more.

Seth Grimes, dcatlas!sethg@uunet.uu.net
Automated Sciences Group (U.S. Dept. of Transportation)
Newsgroups: comp.databases
From: crisp@ecsvax.uncecs.edu (Russ Crisp)
Subject: CA Clipper 5.01a fix..  Anyone got it to work??
Keywords: CA Clipper
Organization: UNC Educational Computing Service
Date: Thu, 12 Nov 1992 21:46:12 GMT


Greetings.
We got the two update .exe's from compuserve, and after
vegging around for the better part of the day, got it
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..

Has anyone out there got the upgrade from CA?  How
did it work for you?

Thanks for all advice!
Russ Crisp
Western Carolina University
Newsgroups: comp.databases
From: les@chinet.chi.il.us (Leslie Mikesell)
Subject: Re: Help!-searching FOXPRO string fields
Organization: Chinet - Public Access UNIX
Date: Thu, 12 Nov 1992 20:59:32 GMT

In article <92317.100703JBC103@psuvm.psu.edu> <JBC103@psuvm.psu.edu> writes:
>We are currently evaluating FOXPRO (for DOS-I don't think windows version is
>out yet).  One problem we're having is searching alphanumeric (string) fields.
>We want to be able to match part of the field, ie. if the field contains
>the words "Student address list" we may want to search for every record with
>the word "address".  In Paradox, we would search for "..address..", but we
>haven't been able to find a similar function in Foxpro.  Any help would be
>appreciated.

One way is the $ operator used as <expC1> $ <expC2> which returns true
if <expC1> is contained in <expC2>
 LIST FOR 'address' $ lower(data_fld)
 (or LOCATE FOR, etc.)

Or you can use an SQL select where _ is a single unknown character, % is
a sequence of unknown characters:
 SELECT * ;
  FROM table;
  WHERE tabel.data_fld like "%address%";
  INTO CURSOR QUERY
(or WHERE lower(table.data_fld) LIKE "%address%"; if you want upper/lower)

Les Mikesell
  les@chinet.chi.il.us
From: dinesh@pyramid.COM (Dinesh Jalisatgi)
Newsgroups: comp.databases
Subject: How to get field of the record while in Browse mode.
Date: 7 Nov 92 01:21:48 GMT
Distribution: usa
Organization: Pyramid Technology Corporation, Mountain View, California
NNTP-Posting-Host: shadow.eng.pyramid.com


 Hi,

 Can  DBASE IV guru help me on this problem.  I am viewing a database file in the bROWSE mode

 Is there any way I can have access to the field of the record I am currently viewing. The reason I need

 this because by using the ON KEY COMMAND and the present field I am planning to do a few

 operations on another database file. e.g If you have two database files one with SSNO and Name, the 

 second file contains SSNO. address, employee status etc. While the user is Browsing through the

 first database file he wants to get more info on a particular persom so he enters say Shift-F5. At that

 time the procedure in ON KEY LABEL DO command should get the field of the record the user
 
 was viewing and get the data from the second file. I talked with DBASE support and they told me 

 that there was no way to get the field of the record. Does anybody have solution to this problem.

 Thanks.

 Dinesh.
Newsgroups: comp.databases
From: dhepner@cup.hp.com (Dan Hepner)
Subject: Re: What is X/Open Distributed Transaction Processing
Date: Thu, 12 Nov 1992 00:42:34 GMT
Organization: Hewlett-Packard
X-Newsreader: Tin 1.1scd1 PL4

Subject: Re: What is X/Open Distributed Transaction Processing

>What is X/Open Distributed Transaction Processing?

A set of interface definitions which support distributed applications
doing transaction processing.

>It may be of some use to us here.
>We are working on a distributed database project.

Check out RDA, or SQL access.  These are standards in
support of distributed databases.  Actually, most RDBMS
vendors already have reasonable distributed database
products.

The essential difference is what you can send to the remote
site, and what kind of processing you can do at the remote
site.

With a distributed application, you can send whatever you
like to the remote site, which is received by an arbitrarily
complex program, usually written in C or Cobol.

With a distributed database, you can send SQL statements
to the remote site.  You may have the opportunity to
write complex "stored procedures" in a proprietary
stored procedure language, and invoke these procedures
with an SQL statement.

Dan Hepner
Newsgroups: comp.databases,comp.databases.ingres
From: sethg@dcatlas.dot.gov (Seth Grimes)
Subject: Re: Ingres questions
Organization: U.S Dept. of Transportation
Distribution: usa
Date: Wed, 11 Nov 1992 18:00:40 GMT

thompson@stars.gsfc.nasa.gov (William Thompson, code 682.1, x2040) writes:

>First of all, I understand that Ingres has a limit of ~2000 bytes per record.
>I know they have a way to incorporate large text fields in the database, but
>what about the situation where one just has a large number of different fields,
>none of which is large by itself, but the total sum is greater than 2000?  The
>salesman claimed this wasn't a problem, but he couldn't explain why.  Has
>anybody run into this problem, or know of a way to get around it?  Is it a real
>problem with Ingres?

I don't know of any workaround other than vertically partitioning your tables.
On the other hand, Ingres 6.5 to be released in the spring will support BLOBs
and presumably remove the 2000-byte limit (based on Ingres's current page
size of 2048 bytes) on general fields.

>What about importing and exporting text files?  This is something that's going
>to be important for us.  Are there any limitations involved with Ingres and
>importing/exporting text files?  Are there problems doing this in a VMS
>environment?

No problems at all once you get used to the formatting conventions of the
COPY command.

>Another question I have is about row level locking.  Somebody I was talking to
>claimed that Ingres does not have row level locking.  However, since his only
>real experience is with the old public-domain version, I'm somewhat dubious
>about this claim.  Is this true, or just a rumor?

No, it doesn't, but then I think rll is important only in a heavy-traffic
transaction processing environment.  Basic Ingres locking is page level, 
with escalation as needed.  Of course, you get rll if your rows take up
most of a data page.  :-)  Do you really need it?

Seth Grimes, dcatlas!sethg@uunet.uu.net
Automated Sciences Group (U.S. Dept. of Transportation)
From: an662@cleveland.Freenet.Edu (Michael Leach)
Newsgroups: comp.databases
Subject: Clipper and Windows
Date: 14 Nov 1992 00:04:05 GMT
Organization: Case Western Reserve University, Cleveland, Ohio (USA)
NNTP-Posting-Host: hela.ins.cwru.edu


I've had the 5.01a upgrade for about a month and it seems to be
a _little_ more stable than 5.01.  The EXE's seem to be a little
faster and an index with a 180 character index key doesn't crap 
out anymore.  As for more stable under Windows, I don't recommend
closing the DOS session without properly exiting the Clipper apps.
Just telling Windows that you're through with the session and
to forcibly shut it down will do the same thing as rebooting 
the computer - trash any indexes you have open and maybe corrupt
the .dbf as well.  The only way to prevent this is to change
to a Windows-aware language or product that Windows can tell 
to shut itself down.  CA's Aspen (or CA-Visual Objects for
Clipper, the official name) *should* do it.  But who believes
Clipper-related hype after Nantucket said 5.0 (not 5.01) would
be the answer to all of our hopes and dreams...

Mike Leach
an662@cleveland.freenet.edu
leacmj@morekypr.bitnet
leachmj@uc.edu
Newsgroups: comp.databases
From: rkinder@iat.holonet.net (Robert J. Kinder)
Subject: Re: Paradox engine & dbase framework
Organization: HoloNet (BBS: 510-704-1058)
Distribution: comp.databases
Date: Sat, 7 Nov 1992 18:29:58 GMT

anders@ipcsun1.his.se (Anders Eklund) writes:
: 
: Hi there folks!
: 
:   I have a question about Paradox engine & database framework.
: What I have heard this framework are some object classes. I
: wonder how well these classes encapsulates the use of the
: relational database as an object database. I would appreciate
: any answer
: 
: Thanks in advance
: Anders
: --
: 
: 
: ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
:          ___
:         /   /       /                --  Anders Eklund  anders@his.se --
:        /__ /___ ___/___ ___ ___      --  Connectionist Research Group --
:       /   //  //  //__//   /__       --  Computer Science  Department --
:     _/   //  //__//__ /   ___/       --  University of Skovde, Sweden --
: 
: ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

The Database Frameworks saves a *lot* of time and code over a direct
interface with the Paradox Engine 3.0.  Using a C++ class library to
handle the Engine interface is much more clearer and productive.  You
might also be interested in HorC++Power (pronounced horsepower), which
uses embedded PAL statements in your C++ program.  I believe this is much
more intuitive and easier than the abstract Database Framework interface. 
But then again, I wrote HorC++Power.  Check the last issue of Paradox
Informant or call ISSI at (407) 997-1612.
-- 
// ------------------------------------------------------------------------
// rkinder@holonet.net            International Software Solutions, Inc.  -
// Robert J. Kinder, Jr.                             Boca Raton, Florida  -
//                                                        1-800-788-4774  -
Newsgroups: comp.databases
From: joet@dcatlas.dot.gov (Joe Trott)
Subject: Re: PARADOX question
Keywords: PATADOX
Organization: U.S Dept. of Transportation
Date: Wed, 4 Nov 1992 18:59:38 GMT

elin@digi.lonestar.org (Eddy Lin) writes:

>Does anybody know how to do this in PAL.

>I am in form edit mode editing a linked multiple-table. The detail 
>table has multiple records. When a specific field in the detail table
>is entered, for example a serial number, I want to be able to find
>the serial number in other table and import the description about
>this serial number into the current record of the detail table.
>PARADOX seems doesn't allow query operation when it is in the edit
>mode. Although I might be able to search for the serial number
>after I call FRMKEY to switch to table view. But when I switch back to
>the form edit mode, do I lose the cursor position ? (Remember the 
>cursor was in one of the records of the detail table). 

>I think unable to perform query in the edit mode is a serial 
>weakness. Any Comment ?

Use a TableLookup to get the information out of the second table.  Edit the
detail table using the imbedded form, then specify the table lookup under Val
checking.  In fact, if you use HelpAndFill, the person entering the data
can choose the desired serial number off a table-view list.
The only disadvantage of this method is that the serial numbers to be
entered must _already_ exist in the lookup table, because only s/n-s from
that table will be valid entries.

-JTT

Newsgroups: comp.databases
From: Peter.Weekes@bbs.actrix.gen.nz
Subject: PARADOX users group ?
Organization: Actrix Information Exchange
Date: Thu, 12 Nov 1992 11:16:16 GMT

I've been contacted by someone who wants to know if there is a PDOX users
group. He can't get newsgroups, but is there an email group where all mail
sent to one address is automatically sent to all subscribers, like UNDERCOVER
for the stones ?

Thanks

Peter
-- 
Peter Weekes          PARADOX Consultant             |
Box 7163              Parasitologist                 | 
Wellington South      Epidemiologist                 |   
New Zealand           Peter.Weekes@bbs.actrix.gen.nz |           
Newsgroups: comp.databases,comp.org.sug,comp.sources.wanted,comp.sys.sun.apps,comp.sys.sun.wanted
From: et@monowave.com (E. Y.L. Tsiang)
Subject: need reliable ndbm
Reply-To: monowave!et@uunet.uu.net
Organization: Monowave Corporation
Date: Thu, 5 Nov 1992 23:19:22 GMT



PROBLEMS:
========
I am using the SUNOS 4.1.1 version of ndbm - a utility for managing key/content pairs
in a data base.  The attractive points about ndbm are 1)its simplicity, 2)its claim
that it can handle a billion blocks and 3)fast file system access.

In attempting to use ndbm for a non-trivial database - about 20000 key/content pairs
so far in testing, (some content filling an entire block), I have found ndbm

	1) to lose data apparently from not flushing its cache even by dbm_close time,
	   (this apparently avoidable by an immediate dbm_fetch after
	    a dbm_store)

	2) to trash its key hasher such that dbm_nextkey eventually gets fixated
	   on one key, causing endless looping in iterating through the database
	   - with concurrent loss of data.  ( I have found no work-around for this.)

Since I anticipate using ndbm eventually for a database of possibly 1M blocks, 
I am looking for a reliable ndbm.

QUESTIONS:
=========
Has anybody encountered similar problems?

Is there a fixed-up version I can obtain/purchase for SUNOS 4.1.1?

Are there more-or-less plug-compatible ndbm work-alikes available publicly or commercially?

Are there sources for ndbm work-alikes available publicly or commercially?



I would appreciate replies either by email or follow-up.  If the problems are resolved,
and if there is sufficient interest, I will post the resolution.

Thanks in advance.