HDTenEightyP/NetNews huggingface dataset:
From: mdonalds@monu6.cc.monash.edu.au (Michael Donaldson)
Subject: Multiple Thread Database Access (OS/2)
Summary: Request for informations
Keywords: OS/2 threads database
Organization: Monash University, Caulfield Campus
Date: Thu, 23 Jul 1992 01:07:11 GMT

I was wondering whether anyone out there has accessed OS/2's database
manager, from multiple threads, under OS/2.  If so I would like to
hear from you.

Please drop me a line,

Michael Donaldson.
mdonalds@monu6.cc.monash.edu.au

Newsgroups: comp.databases
From: u734120@bruny.cc.utas.edu.au (John Lamp)
Subject: Re: text > dbase.dbf
Organization: University of Tasmania, Australia.
Date: Tue, 28 Jul 1992 05:07:58 GMT

Jim_Sollows@mindlink.bc.ca (Jim Sollows) writes:

>Is there any way to take a text file of data and transfer it into a dbase IV
>DBF file?

APPEND FROM <file name> SDF

used to work fine in dBase III, have never (thankfully) had to use dBase IV
(or for that matter dBase III recently), but it should be there, it's their
only import command.

SDF assumes fields in double quotes and separated by commas - the old BASIC
format.

It is possible to modify that - RTFM.

--
John Lamp                   e-mail: u734120@bruny.cc.utas.edu.au   _--_|\
Comcare Australia                                                 /      \
GPO Box 9905                Phone:                +61 02 23 1366  \_.--._/
Hobart TAS 7001             Fax:                  +61 02 34 5685        v
From: rlalwani@hpcupt1.cup.hp.com (Rajesh Lalwani)
Newsgroups: comp.databases
Subject: Re: Upgrading Paradox
Date: 23 Jul 92 20:47:16 GMT
Organization: Hewlett Packard, Cupertino

As far as I know PARADOX has never changed the format of the database files
until 3.5.  According to Borland, Paradox 4.0 is the first time, and 
hopefully the last time, that they will change the format.

-- Rajesh Lalwani
From: prabakar@hal.COM (Prabakar Sundarrajan)
Newsgroups: comp.databases
Subject: Use of threads in databases
Date: 28 Jul 92 18:06:54 GMT
Organization: HaL Computer Systems, Inc.
NNTP-Posting-Host: mayur.hal.com

In this article, I use the term "thread" loosely, to stand for both
library level threads and OS provided ones which have also been called
light weight processes.

I'd like to explore how different databases are planning to use the
various thread models that are emerging.  Some are
provided by operating systems and some are provided as co-routine libraries
on top of the operating system.  Some database systems e.g., SYBASE use
their CICS like threads mechanism within their servers.  Typically the
client processes are not multi-threaded.  (I'd like to know counter
examples).

The following thread models are of primary interest, but I'd like to
see discussions of any other model(s) that might be of interest to
the DB community:

- POSIX
- SVR4 ES/MP
- OSF/1
- SunOS 5.0 (Solaris 2.0 OS)
- OSF DCE
- Transarc ENCINA's BDE

The starter issues are:

- What are the thread models in use by databases and what are planned ones?
- Will database products use threads provided by operating systems?
- How will the DB community deal with the multiple incompatible interfaces?
- If threads share memory extensively, high performance SMP's will impose
  a high cost of thread migration among the processors due to cache effects/
  This processor affinity phenomenon has been observed in performance
  measurements of *multi-process* workloads on SMPs.
- How are / will thread models be used on non-shared-memory MP machines
- Problems related to using the thread model of choice with X/Open's XA
  interface.

I apologize if this topic has been beaten to death already!  If it has,
please send me a pointer to where I can get the information.

Posted as well as e-mail responses are welcome.

Thanks,

prabakar
Newsgroups: comp.databases,comp.sys.ibm.pc,comp.sys.misc,comp.os.os2.networking,comp.os.ms-windows.apps,comp.os.ms-windows.programmer.tools,comp.os.ms-windows.programmer.misc,comp.windows.x.apps,comp.sys.ibm.ps2
From: jeb@eos.ncsu.edu (Jeff E. Byrd)
Subject: Ungermann-Bass Net/One ethernet card driver for LAN Workplace
Organization: NCSU Project Eos
Date: Thu, 30 Jul 1992 13:15:11 GMT

I'm trying to install Novell's LAN Workplace for DOS on an IBM PS/2 Model 80
but I haven't been able to find a driver for my Ungermann-Bass Net/One
Ethernet card.  If anyone knows where I could download a driver from I would
be profoundly appreciative!  Please reply by email.

				Thanks in advance,

				Jeff Byrd
				jeb@ecemw6.ncsu.edu

Newsgroups: comp.databases
From: usenet@inesc.pt (USENET News System)
Subject: distributed application
Organization: INESC - Inst. Eng. Sistemas e Computadores, LISBOA, PORTUGAL
Date: Thu, 30 Jul 1992 13:21:47 GMT

Hello,

I need a distributed application to test the
distributed capabilities of several RDBMS (Ingres, Oracle, Sybase...)
and OODBMS (Ontos). I am not interested, in a first approach, in a 
CAD/CAM application.

I would appreciate if someone could give me some ideas for such an 
application. I would also like to hear from people who have already
tried to use those DBMS in a distributed environment.

Thanks
Helena

e-mail: hig@tutor.inesc.pt
From: beh@lhcdd.csb (Earl Henderson)
Newsgroups: comp.databases
Subject: Re: UniSQL
Date: 23 Jul 92 21:41:07 GMT
Reply-To: beh@lhcdd.csb
Organization: National Library of Medicine

>Does anybody have information about a new OODBMS called UniSQL? Any email
>address of the company, which is also called UniSQL?

UniSQL, Inc.
9390 Research II, Suite 220
Austin, Texas 78759-6544
Telephone: (512) 343-7297
Facsimilie: (512) 343-7383

I am looking into it myself, sorry but I can't tell you any more about it than the
above at this time.

Earl Henderson
Xref: sparky comp.databases:5816 comp.databases.ingres:1013
From: rule@apple.com (Jeff Rule)
Newsgroups: comp.databases,comp.databases.ingres
Subject: Re: Looking for a USABLE database
Date: 28 Jul 92 22:21:19 GMT
Organization: Apple Computer

In article <4352@disuns2.epfl.ch>, baechler@liasun7.epfl.ch (Emmanuel Baechler) writes:
> _ The INGMENU environnemnt is a true horror to use. It is incredibly rigid
>   and poorly designed. Several menu levels do not even contain an abort
>   option (and when it exists, it is not displayed in the menu), which leaves
>   the ^C as the only option to cancel when you made the wrong choice in some
>   cases!
> 

This is generally true of any character-cell based query tool.  What you are longing for
is a GUI interface to the database.

> _ there's no environnment allowing "standard users", like lab people or doctors,
>   to to their searches and requests in a simple and intuitive way, what they find
>   on much simpler tools, like FileMaker on a MacIntosh
> 
>

For Ad-hoc queries there are a couple of really good tools that can be used to access a DB
from the Mac.  They will hide the ugly command line interface of the DBMS.  One
is GQL from Andyne corp.  The other is Clear Access from Fairfield Software

Both tools can use DAL (and a number of other middle-ware solutions SQL*NET, DBlib etc..) 
to access any number of DBMS engines (RDB, DB2, INGRES, Oracle, Sybase etc....) on 
any number of operating systems (VMS, Vax/Unix, AIX, MVS) and multiple transports
(TCP/IP, Local Talk,Token Ring, SNA, Async etc....).  What you will find is that you can plug 
and play most any  DBMS with these tools.  You are going to pay extra for the tools, but 
the are well worth it in user productivity and ease of use when accessing the database.

-Jeff Rule
Apple Computer/Database Resource Management
From: dly@vms.macc.wisc.edu
Newsgroups: comp.databases
Subject: PARADOX, procedure to calculate median
Date: 23 Jul 92 14:56:35 GMT
Organization: University of Wisconsin Academic Computing Center

I am new to PARADOX, and I needed to figure out a way that users could
have a median on a numeric column calculated for them.  I came up with
this procedure which works, but it is very BRUTE force.  If there are 
other users who have ideas on how to streamline this, please let me know.

Thanks!
Debbie Yoshihara
DLY@MACC.WISC.EDU

1) First I set up SHIFT-F1 in a miniscript:
   SETKEY "F11" PLAY "MEDIAN"

2) Then VIEW a table, and TAB to the field where you would like a median
   and press SHIFT-F1

3) The results will be shown in the ANSWER table.

4) Here is the Procedure:

PROC MEDIAN(TBLNAME,FLDNAME)
 IF FIELDTYPE() <> "N" THEN
   MESSAGE "ERROR IN PROCESSING: You must select a numeric field!"
   SLEEP 2000
   RETURN 
 ENDIF
 IF FLDNAME = "#" THEN
   MESSAGE "ERROR IN PROCESSING: You cannot select the # field!"
   SLEEP 2000
   RETURN 
 ENDIF
 SORT TBLNAME ON FLDNAME TO "ZZZTEMP"
 HOWMANY  = CCOUNT("ZZZTEMP",FLDNAME)
 MIDPLACE = HOWMANY/2
 MODVAL   = MOD(HOWMANY,2)
 EDIT "ZZZTEMP"
 MOVETO RECORD MIDPLACE
 MOVETO FIELD FLDNAME
 VALUE1 = []
 MOVETO RECORD MIDPLACE+1
 MOVETO FIELD FLDNAME
 VALUE2 = []
 DO_IT!
 DELETE "ZZZTEMP"
 DO_IT!
 NEWFLD =  "MEDIAN OF " + FLDNAME
 CREATE "ANSWER" NEWFLD : "N"
 EDIT "ANSWER"
 MOVETO FIELD NEWFLD
 IF MODVAL=0 THEN
   [ANSWER -> ] = (VALUE1+VALUE2)/2
 ELSE
   [ANSWER -> ] = VALUE1 
 ENDIF
 DO_IT!
 RETURN 
ENDPROC

TBLNAME = TABLE()
FLDNAME = FIELD()
MEDIAN(TBLNAME,FLDNAME)
Newsgroups: comp.databases
From: glenn@welchgate.welch.jhu.edu (Glenn M. Mason)
Subject: PC client apps -> Sybase SQL server
Organization: Johns Hopkins Univ. Welch Medical Library
Date: Wed, 22 Jul 1992 20:54:35 GMT



We are currently running Sybase SQL server on a networked Sun SPARC platform.
I am currently interested in developing database front-end applications on
the PC platform running under DOS and possibly Microsoft Windows that access
a Sybase SQL server on a Unix server. I am particularly interested in develop-
ing front-end apps using FoxPro 2.0. Does anyone out there have Sybase SQL
servers running on Unix boxes and are writing PC front-end applications to
access the Sybase SQL server? If so I would be very interested in hearing
from you to find out what kinds of tools you are using, any difficulties
encountered, recommendations, etc. I am also interested to hear from anyone
who is using a PC dbms such as Paradox or SQLWindows and has used the module
that links these packages to other SQL servers (such as Sybase) and how this
is accomplished, what software is needed, licensing issues, etc.


Thanks for any info,
Glenn


glenn@welch.jhu.edu
(410)955-9658
From: baechler@liasun7.epfl.ch (Emmanuel Baechler)
Newsgroups: comp.databases
Subject: Re: Looking for a USABLE database
Date: 30 Jul 92 17:32:22 GMT
Organization: Ecole Polytechnique Federale de Lausanne

In article <1992Jul28.140922.8573@sdf.lonestar.org>, abledsoe@sdf.lonestar.org (Al Bledsoe) writes:

|> 
|> >  this is totally unacceptable: labs frequently add new tests, or add COMBINED
|> >  tests (based on existing ones), and this means the addition of new columns.
|> 
|> Uh, have you read anything about relational database theory?

I am definitely not an expert about relational database theory (my own field is
AI) but I have read quite a bit about that. The fact is that the doctors  and the
people of the labs regulary create new analyses and want to integrate them in
their result sheets, period. They did not hear anything about relational
databases, they don't want to hear anything about that, they want to be able
to enter new columns on their result sheets and these result sheets are represented by tables in most of the labs.

|> I've worked in the health field here in Texas since 1975,  doctors are not
|> standard users!!

Maybe yours have a different attitude, that's happy for you. A few of our doctors
are quite educated about computers, but this is definitely not the case of the
majority.

|> The ANSI MUMPS database/language has for years and years accomplished your
|> task in a very efficient manner.  The U.S. VA laboratory system was written
|> with MUMPS (see DEC's DSM product info).  I now work for a laboratory vendor
|> that uses PICK or UniVerse's PICKeese running on UNIX servers such as
|> Sequent or IBM's RS/6000 or HP's 9000/857's etc.
|> 
|> These database vendors are just now discovering the Open world as they
|> emerge from their vertical niches.  Intersystems is a MUMPS vendor that
|> markets a product called M/SQL, hiding the name MUMPS and flouting
|> their 4GL-like frontend.  UniVerse 7.0 by Vmark is doing the same thing
|> by embedding SQL and creating a global dictionary to the relational
|> world.
|> 
|> So,  there is no lack for tools to create efficient and well interfaced
|> applications for the medical community.   Byte magazine May 1992 gives
|> credibilty to the view that RDBMS's have had their chance.  Combining
|> what was learned through them with what has been demonstrated through
|> such DBMS's as MUMPS and PICK will find new functional products from
|> vendors that address the real world of weird users like doctors.
|> 
|> Hint:  try Advanced Revelation in a client/server design with UniVerse.

Thank you very much for yourt answer and sorry for the delay of my answer.

-- 
Emmanuel Baechler.                        | Tel.: ++41-21-693-2732
Laboratoire d'Intelligence Artificielle   | e-mail: baechler@lia.di.epfl.ch
Ecole Polytechnique Federale de Lausanne  |     or: baechler@liasun6.epfl.ch
MA-Ecublens                               | Standard Disclaimer
CH-1015 Lausanne	Switzerland

Ban the bomb. Save the world for conventional warfare.
From: ALANB@OWGVM0.VNET.IBM.COM (Alan Beal)
Date: Thu, 30 Jul 92 07:36:32 EDT
Newsgroups: comp.databases
Subject: Re: ISBN for book
Organization: Federal Systems Company (IBM)

Could someone post the ISBN for:
   Transaction Processing: Concepts and Techniques
      by Jim Gray and Andreas Reuter
Any other publisher information would be appreciated.

Alan Beal         alanb@owgvm0.vnet.ibm.com
                  (607)751-2026
From: lindsey@tincup.enet.dec.com (Randy Lindsey)
Newsgroups: comp.databases
Subject: Re: Can A FoxPro App Contain An Editor?
Date: 30 Jul 92 23:17:58 GMT
Organization: Colorado Software Solutions, Inc.


In article <7=pmv##.westes@netcom.com>, westes@netcom.com (Will Estes) writes...
>I'm trying to determine if an existing application written in C could be
>easily re-written as a FoxPro application.
> 
>The part of the application that is in question is an editor and
>form-letter generator.  Essentially, the application contains a list of
>form letters.  If the user selects one of these letters, he is brought
>into an editor, and he is able to edit the text of the letter as well as
>insert and delete fields of the database within the letter.
> 
>Can the above be handled elegantly within a FoxPro application?  Would
>it require interfacing to a C program for the editor/mail-merge
>functions?
> 
>Thanks,
>Will Estes         Internet: westes@netcom.com

I've heard of people implementing their own editors in Foxpro.  I know it
has parameters for setting which editor it calls, and you can plug in your
own.  Haven't done it though.  I know that some of the Compuserve Foxpro
users have done this, that's where I heard about it.  I think maybe someone
even posted their editor for downloading.

Randy
Xref: sparky comp.databases:5842 comp.lang.c++:11796
From: nziring@afterlife.ncsc.mil (Neal Ziring)
Newsgroups: comp.databases,comp.lang.c++
Subject: Ontos C++ OODBMS -- Info? Experiences?
Keywords: c++ oodbms object-oriented
Date: 30 Jul 92 15:24:34 GMT
Followup-To: comp.databases
Distribution: usa
Organization: The Great Beyond

Does anybody out there have any personal information or experiences
to report on use of Ontos's C++ database system?  There is a person
in my organization looking for a dbms to support a special-purpose
hyper-linked information retrieval system, requirements to include
handling of text, BLOBS, images, etc..  Anybody know if Ontos's 
product would be good for this sort of thing?  

Anyhow, please reply to  nziring@afterlife.ncsc.mil, and if the
responses are of interest I'll summarize to comp.databases.
Thanks in advance...

-- 
...nziring  (Neal Ziring  @  Afterlife, Nat'l Computer Security Center)
From: jdr@starflight.Corp.Sun.COM (Jon Roland)
Newsgroups: comp.databases
Subject: Re: Progress Info Wanted
Date: 24 Jul 92 03:59:14 GMT
Reply-To: jdr@starflight.Corp.Sun.COM
Distribution: world
Organization: Sun Microsystems, Inc.
NNTP-Posting-Host: starflight.corp.sun.com

In article 27010@homebase.vistachrome.com, howard@homebase.vistachrome.com (Howard Kennedy) writes:
>	We are currently using Oracle.  We are considering using Progress at least
>	for one of our projects. ...
>	We would also like to hear from sites that have converted from
>	Oracle to Progress.

I have helped clients convert from several popular DBMSs to Progress. I have
never found anyone who wanted or needed to convert in the other direction.
The only things some clients have complained about has been lack of support
for objects, such as BLOBs, graphics, or sound. Today at the ObjectWorld
show I saw Progress being used with an OODBMS engine, ObjectStore, being 
used to provide non-text data. The combination, due out in the 4th quarter
of 1992, looks like it is going to be a winner.

My advice: Convert to Progress asap. You'll never regret it.

---

jdr@starflight.corp.sun.com, starflt@uunet.uu.net
Jon Roland
Starflight Corporation, 1755 E Bayshore Rd #9A,
Redwood City, CA 94063-4142, 415/361-8141
From: lindsey@tincup.enet.dec.com (Randy Lindsey)
Newsgroups: comp.databases
Subject: Re: Query Question:
Date: 30 Jul 92 23:02:37 GMT
Organization: Colorado Software Solutions, Inc.


In article <BryqL8.4AF@acsu.buffalo.edu>, v125qmam@ubvmsb.cc.buffalo.edu (Ami R Pflugrad) writes...
> 
>	Under Foxpro 2.0, If The User makes a change to a record
>	in a cursor.  What is the best/fastest way to make the
>	change in the original database?  I Tried re-selecting the
>	original database and seeking on the indexed expression, but
>	since it is no longer unique, It is not always returning to 
>	the correct one.
> 
>Thanks.
> 
>Ami

Try to include the record number from the original database into the field
list of your select statement.  I haven't tried this, but perhaps use
RECNO() in the SELECT statement?  Anyway, that gets you back to the
original record quickly and reliably.  You can even SET RELATION on that,
so you don't have to GOTO the record, Foxpro does it for you.

Good luck,
Randy
Newsgroups: comp.databases,comp.databases.ingres,comp.databases.theory
From: luu@quark.ansto.gov.au (Liem Luu)
Subject: Superscript and Subscript characters in Ingres
Keywords: Superscrip, Subscript
Organization: Australian Nuclear Science and Technology Organisation
Date: Wed, 29 Jul 1992 05:31:27 GMT

Hi Ingres Gurus,

I am going to develop an application using Ingres 4GL, I would like to be able
to enter the search criteria in Subscript and Superscript e.g.
H2O as H then subscript 2 then O rather than string H2O. Ingres then
retrieve rows and columns and display results as Subscript and Superscript
strings on the screen (character-based terminals). It must be WYSIWYG i.e 
H2O must be displayed as H then subscript 2 then O in the column or field.     

Has anyone done this before in anyway or form ? 

Is there a 3rd Party Package out there we can use as a front end to Ingres
which supports Superscript and Subscript ? 

Do we need a graphics-based terminal to display the Superscript and
Subscript characters? 

We are using Ingres 6.4 (No Windows) on Pyramid UNIX platform. All suggestions 
or comments are welcome.

Thanks



-- 
Liem Luu                                     e-mail: luu@nucleus.ansto.gov.au
ANSTO 
Australian Nuclear Science                   phone : +61 2 717 3092
& Technology Organisation		     Fax   : +61 2 717 9273
From: bob@iowegia.uucp (Bob Powers)
Newsgroups: comp.databases.oracle
Subject: Deleting Duplicates
Date: Tue, 21 Jul 92 16:24:42 CDT
Distribution: world
Organization: Iowegia Waffle BBS, Clive IA USA, +1 515 226 2156

How can I delete duplicate rows in a table using SQL*PLUS.  This is
an unindexed table and I would like to keep it that way.
From: hans@iris.mincom.oz.au (Hans Plambeck)
Newsgroups: comp.databases.oracle
Subject: Re: Oracle Backup
Date: 22 Jul 92 21:36:01 GMT
Organization: Mincom, Brisbane, Australia
X-Newsreader: Tin 1.1 PL4

: |> 1) How do you back up Oracle databases today?
: Oracle backups are usually done using using exports of the database.

Excuse me, that might be valid with a scott/tiger database, but not
something in production, big and 24 hours available.

The DBA guide shows you how to do online backups of your tablespaces,
    an export to /dev/null from time to time will show you that
    the database is still valid.

-- 
Hans-J Plambeck   Mincom Pty Ltd       hans@mincom.oz.au  +61 (7) 364 9999
From: wkaufman@us.oracle.com (William Kaufman)
Newsgroups: comp.databases.oracle
Subject: Re: SQL*FORM: highlighted field
Date: 24 Jul 92 15:38:44 GMT
Article-I.D.: oracle.1992Jul24.153844.15331
Organization: Oracle Corporation, Redwood Shores CA
X-Disclaimer: This message was written by an unauthenticated user
              at Oracle Corporation.  The opinions expressed are those
              of the user and not necessarily those of Oracle.

In article <14099@borg.cs.unc.edu> chia@hatteras.cs.unc.edu (Mr. Chia) writes:
] In sql*form/image/painter, the field/column of a table is always highlighted.
] I want to turn this attribute off. I tried display_field(:test.a, inverse).
] sql*form doesn;t accept "inverse". Can somebody tell me what I can do?

    SQL*Forms is actually expecting a "logical" attribute, what
_SQL*Forms_ calls the attribute.  That's things like "Normal" or
"Field-current", as opposed to "None" or "Inverse".

    What you probably want to do is to change the attribute mapping
listed in the terminal resource file, rather than resetting the
attribute at run-time.  You can do that by using Oracle*Terminal: open
your oraterm.res; choose the "RUNFORM" or "SQLFORMS" product and your
terminal; and dive into the [Mappings]/[Attributes] menu choice.  Check
under the [Device]/[Attributes] section for what attribute names you can
use.

                                           -- Bill K.

Bill Kaufman           | "Hush my darling / Be still my darling /
                       |  The lion's on the phone,..."
wkaufman@us.oracle.com |              -- "The Guitar", They Might Be Giants
Newsgroups: comp.databases.oracle
From: kjou@us.oracle.com (Kathy Jou)
Subject: Re: Deleting Duplicates
Followup-To: kjou@oracle.com
Organization: Oracle Corporation, Redwood Shores CA 94065
Date: Wed, 22 Jul 1992 18:00:57 GMT
X-Disclaimer: This message was written by an unauthenticated user
              at Oracle Corporation.  The opinions expressed are those
              of the user and not necessarily those of Oracle.

In article <VN70NB1w165w@iowegia.uucp> bob@iowegia.uucp (Bob Powers) writes:
>How can I delete duplicate rows in a table using SQL*PLUS.  This is
>an unindexed table and I would like to keep it that way.

delete from table_name
where rowid = any (select rowid from table_name
		   minus
		   select min(rowid) from table_name
		   group by column_name);

Column_name should be the primary key of the table.

 
Kathy Jou
Oracle Corporation

Newsgroups: comp.databases.oracle