HDTenEightyP/NetNews huggingface dataset:
Organization: Appropriate Roles for Technology
Followup-To: poster

The subject pretty much says it all....  Purely hypothetically, of course:

If you were about to have a custom application dumped on you by folks who
won't even reveal the DBMS upon which it's built, but you happened to know
that the target platform would be a NetWare LAN of MS-DOS boxes, and you
further happened to have heard that a database debugging tool called Pocket Dot
had been used, what would that tell you about the DBMS or other
tools used to create the app?  Who makes Pocket Dot, for that matter?

I'm still losing news with some regularity, so replies by email would be
greatly appreciated.  (I have a new disk installed, now just need time to
reconfigure....)  I will summarize if there is interest.

Thanks!
-- 
Chap Flack                Whatever was required to be done, the Circumlocution
chap@art-sy.detroit.mi.us Office was beforehand with all the public departments
                          in the art of perceiving--HOW NOT TO DO IT.  -Dickens
Nothing I say represents Appropriate Roles for Technology unless I say it does.
From: thongt@iti.gov.sg (Thong Tiong (SE))
Newsgroups: comp.databases
Subject: dbase IV format file
Date: 14 Oct 92 00:43:17 GMT
Reply-To: thongt@iti.gov.sg
Organization: Information Technology Institute, National Computer Board, S'pore

hi all

I am new to dbase IV and I am using V1.5 now.

I am a format file to do multi record editing on a
file called customer, as shown below

USE customer
SET FORMAT TO cust_fmt
EDIT
SET FORMAT TO

However, I need to perform some commands after each record is
edited. Where should I insert the commands? Adding them in the
format file don't seem to work.

Any help is much appreciated.


Choo Thong Tiong
(thongt@iti.gov.sg)
From: jlg@naucse.cse.nau.edu (James Gibson)
Newsgroups: comp.databases
Subject: RBASE:  Does is still exist as a development platform?
Date: 13 Oct 92 17:06:25 GMT
Organization: Northern Arizona University, Flagstaff AZ

I am developing various databases for use in agricultural
areas.  My current development system is RBASE for DOS
(I am working on a 486 and developing for other such systems).
I find it extremely flexible and powerful as a database 
development system.

My question is I do not see RBASE covered in most database
journals that I have read and have not seen it mentioned 
in comp.databases.  I also cannot seem to find books covering
RBASE in most bookstores catering to developers.  Is RBASE
considered a "good" development system by the industry and 
do any of comp.database readers use any of the RBASE products?

My interest is because I would like to develop on a platform the
industry considers a "standard" one to avoid problems in development
in the future.

PLease e-mail any responses to this post to me, Jim Gibson at:

      jlg@naucse.cse.nau.edu

Thanks!

Jim Gibson 
Newsgroups: comp.databases
From: dcs@neutron.chem.yale.edu (Dave Schweisguth)
Subject: Looking for PD personal DBMs
Organization: Yale University
X-Newsreader: TIN [version 1.1 PL6]
Date: Thu, 15 Oct 1992 12:20:27 GMT

Hi all,

Can anyone suggest a rich public-domain Unix DBM suitable for a single-person
project with a fairly small amount of data? We're making some stabs at
automated nucleic acid NMR assignment, so we want to manage datasets with some
hundreds of entries. We'll need flexible format reading (for data import from
stupid inflexible programs), screen-oriented data entry and browsing, and
very flexible scripting for manipulation. We will NOT need distributed or
multi-user capabilities.

Things like Postgres are overkill, but things like jinx (a screen-oriented Perl
DBMS) aren't quite powerful enough, barring lots of rewriting. It would need to
run on SGI IRIX 4.0.x. Perl would be fine.

Please mail; I'll post a summary.

TIA,

--
| Dave Schweisguth   Yale MB&B & Chemistry   Email: dcs@neutron.chem.yale.edu |
| Lab phone: 203-432-5208      Fax: 203-432-6144     Home phone: 203-624-3866 |
Newsgroups: comp.databases
From: blaine@banana.fedex.com (blaine robertson)
Subject: simple (maybe) SQL question
Organization: Federal Express Corp.
Distribution: comp
Date: Fri, 9 Oct 1992 18:58:32 GMT

I need the ability to extract 5 entries from table #1 that currently has
10000 entries in it and then join them with table #2.  

Based upon my limited knowledge of SQL I only know how to join the
entire sum of tables #1 and #2 and then parse out what I need by
'where' statements.  As you can see, the way I'm doing things now is
verryy sloww!!

Any help would be greatly appreciated..
-- 
blaine robertson                | voice:  (901)797-6337
federal express corp            | fax:    (901)797-6388
box 727-2891, memphis, tn 38194 | email:  blaine@banana.dis.fedex.com
Newsgroups: comp.databases,comp.databases.theory
From: marti@nugget.inf.ethz.ch (Robert Marti)
Subject: Re: Passing transaction context in HP Always? Info requested
Keywords: HP Always, transaction context
Organization: Dept. Informatik, Swiss Federal Institute of Technology (ETH), Zurich, CH
Date: Thu, 15 Oct 1992 16:15:41 GMT

In article <Bw5KAG.5uo@immd4.informatik.uni-erlangen.de>,
tk@faui63.informatik.uni-erlangen.de (Thomas Kirsche) writes:
|> In a recent talk, somebody told about a database management system 
|> called "HP Always" (or the like).

I assume you mean "HP Allbase".  This is HP's very own SQL database engine.
 

|> One of its characteristics is the ability to pass the "transaction
|> context" between transactions. That is, for example, the passing of
|> locks or open cursors.  [...]  Is that true?

Sorry, but I have no idea.  But I would certainly be interested to hear
about the features of Allbase.

-- 
Robert Marti                    |  Phone:    +41 1 254 72 60
Informationssysteme             |  FAX:      +41 1 262 39 73
ETH-Zentrum                     |  E-Mail:   marti@inf.ethz.ch
CH-8092 Zurich, Switzerland     |
From: bob@hpwin052.uksr.hp.com (Bob Easton)
Date: Wed, 7 Oct 1992 16:00:15 GMT
Subject: Sybase - batch progs failing...help!
Organization: HP Response Centre, Berkshire, England.
Newsgroups: comp.databases

Hi,

I have a situation where C programs using DB-library routines fail
occassionally and seemingly randomly with an error like
  
            DB-library - read from SQL server failed

before they actually connect to the database.

The programs are on the same machine as the database they access, but
the error message from the operating system is a genaral networking 
error message ("connection reset by peer"). They run sequentially, and 
the failures don't seem to be load-related.

The hardware is Hewlett-Packard (HP9000 S800 at HP-UX 7.0) with Sybase
4.2.

As you may have guessed, I'm not that familiar with Sybase, so any
clues, pointers, etc would be very welcome!

Thanks in advance

Bob
Newsgroups: comp.databases
From: david@datamark.co.nz (David Rowland)
Subject: Re: dbase/clipper help
Date: Mon, 12 Oct 1992 23:33:57 GMT
Organization: Datamark International Ltd.

>John Doe (President)
>--- Mary Doe (VP Sales)
>    --- Joe Dude (Manager of Sales)
>        --- Bob Seaver (SalesMan)
>        --- Jim Dunn (SalesMan)
>--- Billy Bob (VP Marketing)
>--- Steve Morgan (VP to Spare)
>
File Structure: STAFF.DBF

MCODE     Numeric    5   ' Code of imediate manager
ECODE     Numeric    5   ' Code of employee
NAME      Character 30
POSITION  Character 30

INDEX : Manager  KEY : STR(MCODE,5)+STR(ECODE,5)
INDEX : Employee KEY : STR(ECODE,5)

Note: President's PCODE = 0 and ECODE = 1
      All others > Presidents
************************************
PRIVATE tab_cnt
USE Staff INDEX Manager, Employee
SET ORDER TO 2
GO TOP

? ALLTRIM(Staff->name) + " (" + ALLTRIM(Staff->position) + ")"
Rec_loop(Staff->ecode, 4)

RETURN
************************************

FUNCTION Rec_loop
PARAMETER mcode, space_cnt
PRIVATE Recno

SET ORDER TO 1
SEEK STR(M->mcode,5)

DO WHILE M->mcode = Staff->mcode AND NOT EOF()
    ? REPLICATE(" ", M->space_cnt) + "----" + ;
      ALLTRIM(Staff->name) + " (" + ;
      ALLTRIM(Staff->position) + ")"
    M->recno = RECNO()
    Rec_loop(Staff->ecode, M->space_cnt + 4)
    GO M->recno
    SKIP
ENDDO

RETURN 1

*************************************

That is all there is to it.  I haven't tested this out but I did use 
something like it for a program I once did.

By the way, it works by calling the function recursively and creates
private values of the varibles it uses for each call.
-- 
| David Rowland       | The British are using New Zealanders.  They must |
| Datamark Intl Ltd   | really mean business !                           |
| Wellington          |      -  General Rommel During Northern African   |
| NEW ZEALAND         |         Campaign WWII.                           |
Newsgroups: comp.databases,comp.databases.informix,comp.databases.ingres,comp.databases.oracle,comp.databases.theory
From: bjtong@spectrum.cs.unsw.oz.au (Banchong Harangsri)
Subject: Looking for Distributed INGRES Optimizer
Reply-To: bjtong@spectrum.cs.unsw.oz.au (Banchong Harangsri)
Organization: none
Date: Wed, 7 Oct 1992 11:44:10 GMT

Hi all,

Is there anyone implementing the distributed INGRES optimizer?
I need it to do some experimentation on the distributed
database. Any relevant information to point me to the likely
direction would be appreciated. 

Thank you very much.
banchong

 _--_|\  Banchong Harangsri (bjtong@cs.unsw.oz.au)
/      \ Fax:    +61-2-313-7987                      
\_.--._* Office: Computer Science, University of New South Wales,
      v          PO Box 1, Kensington, Australia, 2033          
         Home:   5/12 Blenheim st., Randwick, NSW 2031       
         Ph:     (02)-399-6542
Newsgroups: comp.databases
From: ekeland@boeygen.nr.no (Anders Ekeland)
Subject: Paradox questions
Organization: /nr/boeygen/u2/ekeland/.organization
Date: Fri, 9 Oct 1992 11:15:53 GMT

I have *.db files with fields that show when students at started, their exams
and so on. My first problem:

1) a, and not a 

One table with student id. and entrance date, one table with
student id. and exams. I want to create one table of those with exams
and those without. I am able to get a new table where entrance date
and exams are joined(each student has one ore more rows depending on
number of exams), but I am not able the to get a seperate tabel of
those without exams. I mark the student id. with F5 <a> in the
entrance date table and write "not <a>" in the exams file. Mostly
Paradox complains about "not enough diskspace to complete operation" even thoug the tables are less than 0.5 Mb and there is 30-40 Mb of free disk space. And such a set operation should be trivial?

2) Second problem: the inclusion operator !

I am trying to join the stud.id+entrancedate table with a table of
students registration cards (subject this semester, subjects next
semester, planned final degree etc). Due to faulty registration
routines, there are not registration cards for all students, but
should I not get all students and theire possible registration data if
I use the ! operator in the student.id field in the
student.id+entrance date table? Of the 12326 students I am not able to get more
than 11784 in the answer table? How does this happen? Any cure?

I am using Paradox 3.0.  


Newsgroups: comp.databases,comp.databases.theory
From: tk@faui63.informatik.uni-erlangen.de (Thomas Kirsche)
Subject: Passing transaction context in HP Always? Info requested
Organization: CSD., University of Erlangen, Germany
Date: Thu, 15 Oct 1992 07:47:04 GMT
Keywords: HP Always, transaction context


Hi database experts,

in a recent talk, somebody told about a database management system 
called "HP Always" (or the like). One of its characteristics is the ability 
to pass the "transaction context" between transactions. That is, for example, 
the passing of locks or open cursors.

Is that true? Does anybody know "HP Always"? Or any other dbms that allows
to pass a transaction context? Where to get more information?

Any hint is really appreciated. Thanx in advance.

Thomas

Thomas Kirsche                  kirsche@informatik.uni-erlangen.de
Dept. of Computer Sciences VI   
Database Systems                Phone: + 9131 - 857899
Martensstrasse 3                FAX:   + 9131 - 32090
D-8520 Erlangen
Germany
Thomas Kirsche                  kirsche@informatik.uni-erlangen.de
Dept. of Computer Sciences VI   
Database Systems                Phone: intl. + 9131 - 857899
Martensstrasse 3                FAX:   intl. + 9131 - 32090
D-8520 Erlangen
Germany
From: pev2235@summa.tamu.edu (EL JEFE)
Newsgroups: comp.databases
Subject: Help Looking for National Phonebook
Date: 15 Oct 92 15:37:00 GMT
Article-I.D.: summa.15OCT199210374557
Organization: Texas A&M University, Academic Computing Services
News-Software: VAX/VMS VNEWS 1.41


	I've never posted to this group before so excuse if this does not belong
here. But, I'm looking for a copy of the National Phonebook on database. Or if 
anyone knows of an on-line system which offers the National Phone book, I would 
really appreciate it. I mainly work on internet, so I'm looking for sites that
our avaliable through telnet. Since I don't usually read this group I would 
appreciate it if responces could be e-mailed directly to me.

       Thanks in advance,   
				Paul 
				e-mail: pev2235@summa.tamu.edu
From: TONY@SLACVM.SLAC.STANFORD.EDU (Tony Roder)
Newsgroups: comp.databases
Subject: Re: Alpha 4 Help
Date: 8 Oct 92 17:53:10 GMT
Organization: Stanford Linear Accelerator Center

In article <92281.150508NU035609@NDSUVM1.BITNET>, R.C.(Chuck) Solly
<NU035609@NDSUVM1.BITNET> says:
>
>I'm using Alpha 4 V.2 to create a database with some unusual
>characteristics (I think) and Alpha Tech Support is not helping
>at all.
>My problem is that I must post data from a transaction database
>composed of daily invoices, to any of 25 Master databases. The post
>is triggered by a line on the invoice that contains the "dealer id".
>
>Alpha 4 contains a "trigger script" which allows me to do the posting
>when the user saves the record. The problem is that I am not familar
>enough with the Alpha 4 command structure to figure out how to set
>each dealer id to a variable and then dump each line to the appropriate
>database.
>I figure that there MUST be an Alpha 4 expert out there somewhere who
>can get me started...
>
>Any help will be greatly appreciated!!
>
>Chuck

I would also appreciate learning how to do that, and would therefore
encourage public posting rather than e-mail....


-----------------------------------
Tony Roder, speaking his mind .....
Newsgroups: comp.databases
From: chim@is.s.u-tokyo.ac.jp (IM Chol Hong)
Subject: Help : R-tree library
Organization: Dept. of Information Science, Univ. of Tokyo, Japan.
Distribution: comp.databases
Date: Fri, 16 Oct 1992 02:59:35 GMT

I am looking for public domain R-tree library runnable on Unix.
Any helps are appreciated.
--
University of Tokyo
Im Cholhong
E-mail chim@is.s.u-tokyo.ac.jp
Newsgroups: comp.databases
From: fredg@ariel.yorku.ca (Fredrick Gonsalves)
Subject: Re: Public Domain OODMS ??
Originator: fredg@c11.ariel.yorku.ca
Organization: York University, Toronto, Canada
Distribution: york
Date: Tue, 13 Oct 1992 20:16:24 GMT


In article <1992Oct7.081950.9945@ucc.su.OZ.AU>, joe@archsci.arch.su.oz.au (Joe Nappa) writes:
>> Yes...yet another request for the addresses of ftp sites holding
>> OODMS (yawn!). Can anyone out there help? Preferably it should be
>> SQL based, but not necessarily. Does anyone know where I can get
>> my eager hands on "Gemstone", Orion, or ODEODE? What's OBST like?
>> 
>> Gratefully yours,
>> 
>> -- 
>> Joe Nappa                  *Lisa: "These talking dinosaurs are more real than * 
>> joe@archsci.arch.su.edu.au *       most real families on TV"                  *
>> Dept. of Architec. Science *Bart: "It's like they saw our lives & put it right*
>> Uni. of Sydney, AUSTRALIA  *       up on screen"  (from Fox's "The Simpsons") *

Cany you also E-mail me the FTP ADDRESS also

FredG
YorkU, Canada
From: adye@boi.hp.com (Alan Dye)
Newsgroups: comp.databases
Subject: Re: RBASE:  Does is still exist as a development platform?
Date: 13 Oct 92 21:10:54 GMT
Organization: Hewlett-Packard / Boise, Idaho
X-Newsreader: TIN [version 1.1.4 PL6]


I certainly wouldn't worry about it going away any time in the near future.

The way I see it, Borland bought dBase and Paradox, Microsoft bought
Foxpro, if Microrim gets in too much trouble, I'm quite sure that there
are enough 'large' software houses out there that would be happy to
buy up a database package instead of developing it.  It will be around
for some time to come, regardless of who owns it.  

(The question now, is who will buy it if it does go on the block...
  Microsoft? -Microrim is located on the corner of their corporate 
  campus- Lotus? -they don't have a database package, a glaringly 
  obvious ommission for such a large software house- WordPerfect?
  -They could sure use something besides dataperfect-  Enquiring minds
  should feel free to speculate.  However, I AM NOT SAYING THAT MICRORIM
  IS GOING TO BE BOUGHT OUT.  I'M NOT EVEN SAYING THAT THERE IS A REMOTE
  POSSIBILITY.  These remarks are just an obeservation on my part.  
  They don't represent the views of my employer.)

Alan

--
___________________________________________________________________________
Alan W. Dye   PHONE: (208) 323-6167        adye%hpdmd48.boi@hp.com
                FAX: (208) 323-6344        71053,1301@compuserve.com
    
Software Applications Specialist           "Cleverness is its own reward."
Hewlett Packard Boise Site Operations  
Information Systems Group                  #include <disclaim.h>
From: dnl@convex.is.macsch.com (David Lombard)
Newsgroups: comp.databases
Subject: Re: We need dBaseIV help!
Date: 12 Oct 92 23:44:54 GMT
Organization: MacNeal-Schwendler Corp.


A trivia question:

	Was 1900 a leap year?

A non-trivial answer:

	NO!

	The divisible by 4 test DOES NOT apply to century years.
	You must use divisible by 400 for those.  Try `cal 2 1900'
	as shown below:

		   February 1900
 		S  M Tu  W Th  F  S
	                    1  2  3
                4  5  6  7  8  9 10
               11 12 13 14 15 16 17
               18 19 20 21 22 23 24
               25 26 27 28



Regards,
DNL
******************************************************************************
*                  MY COMMENT == MY OPINION != ANYONE ELSES                  *
******************************************************************************
* David N. Lombard                               The MacNeal-Schwendler Corp *
* dnl@macsch.com                                 815 Colorado Blvd           *
* (213) 259-4911 FAX: (213) 259-3838             Los Angeles, CA  90041      *
******************************************************************************
From: rhaven@cruzio.santa-cruz.ca.us
Newsgroups: comp.databases
Subject: Re: Paradox 4.0 is SLOWER !! (Why)
Summary: How to tune paradox 4.0
Date: Tue, 06 Oct 92 23:24:28 PDT
Reply-To: rhaven@cruzio.santa-cruz.ca.us
Distribution: comp



Paradox 4.0 is much faster than 3.5 in a 4mb + RAM environment.  If you are
running with 2mb, try using the -codepool command line switch described in
the documentation with numbers like 500 or so.

High leverage features are: removal of Form Lock; dirty Queries; improved
LOCATE (PREV, BESTMATCH, FIRST, LAST); viewing tables in secondary index
order; and, in Standard UI, multiple tables/forms/queries/canvases onscreen
at once.
Newsgroups: comp.databases
Subject: Re: RDB vs. OODB: Designing a queue
From: j_ohearn@dsg4.dse.beckman.com ()
Date: 13 Oct 92 15:34:42 GMT
Distribution: world

In <1ahv74INNjfr@agate.berkeley.edu> mao@triplerock.CS.Berkeley.EDU (Mike Olson) writes:

>In <1992Sep30.202315.9819@bony1.bony.com>, richieb@bony1.bony.com (Richard
>Bielak) describes a particular data modelling problem he wanted to solve.
>he says:

>> In a earlier positing I mentioned that we were unable to design a
>> queue, using a relational database, and that this was the reason for
>> moving to OODB.

>and then follows it with a good description of the problem he wanted
>to solve.

>i've stated before, and want to reiterate, that this is NOT a problem
>with the relational model.  if you have an extensible system, then you
>can write code to manage a queue with high-concurrency locking.  bielat
>succeeded in doing so in his oodb because he could write the queue data
>type himself, *not* because he had inheritance, message-passing, and
>polymorphic functions.

It seems to me that the issue here is that the solution in terms of
a relational database was neither as obvious nor as intuitive as the
OODB solution.  This also would imply that the OO solution was most
likely easier to document and inspect due its more abstract nature (the
relational solution appears to be more of a kludge).

Thanks for listening.

Jim O'Hearn
Software Engineer
Beckman Instruments, Inc.
Newsgroups: comp.sys.ibm.pc.software,comp.databases,rec.music.classical
From: stefan@sinus.stgt.sub.org (Stefan Bechtold)
Subject: Database program for DOS wanted
Organization: Sinus Stuttgart, Germany
Date: Thu, 15 Oct 1992 17:14:50 GMT

Hi !

I'm looking for a public domain database program which runs 
under MS-DOS.

My problem is the following:

I have many CDs,tapes and records. I want to put them in a 
database. But I also want to have my scores etc. in this
database.
In the end I want to look after a certain piece of a composer and
want to see if I have the score/CD...

The system should also have the ability of searching some other
components (like players,date,length.....). 

Does somebody have the same requirements ? How did you solve it ?


Thank you for any respond,
Stefan




-- 
+ Stefan Bechtold # stefanb@delos.stgt.sub.org # Voice +49 711 813240 +
++++++++sed nemo potuit tangere: merda fuit ! (Martial III 17)+++++++++
From: andrew@drawing.adelaide.edu.au (Andrew Trotter)
Newsgroups: comp.databases
Subject: P.D Databases
Date: 9 Oct 92 07:53:01 GMT
Reply-To: andrew@drawing.adelaide.edu.au (Andrew Trotter)
Organization: University of Adelaide
NNTP-Posting-Host: moe-gw.drawing.adelaide.edu.au

--
I'm new to this news thing but I am interested in relational data bases
with sql, similar to Informix, etc. Are there any public domain data bsaes
with this type of capability.

Infact I would be interested in any database (public domain at present)
that is compilable for Unix, DOS and Apple. This is most likely
impossible but you can only ask.

I need this as is to be one of two interfaces for a graphically and 
texturally driven Facilities Management system.

Any polite pointers will be received with thanks, others will be ignored.

Thanks in advance.

*********************************************************************
***  Andrew Trotter                  *		email :-	  ***
***  CADD Manager. Buildings Branch  *				  ***
***  University of Adelaide          * andrew@moe.adelaide.edu.au ***
***  P.O. Box 498.		     ********************************
***  ADELAIDE S.A. 5000	      	     *	  Phone (08) 228 5900	  ***
*********************************************************************
Newsgroups: comp.databases,comp.misc,comp.sys.ibm.pc.misc