HDTenEightyP/NetNews huggingface dataset:
From: map@sequent.com (Michael Perry)
Newsgroups: comp.databases,comp.databases.theory,comp.databases.oracle
Subject: Re: Is this a bug or a limitation of the SQL language
Date: 25 Aug 92 20:58:11 GMT
Article-I.D.: sequent.1992Aug25.205811.13135
Organization: Sequent Computer Systems Inc.

In article <JOEY.92Aug24091348@elysium.berkeley.edu> joey@berkeley.edu (Joe Hellerstein) writes:
>In article <1992Aug24.100941.24827@dk.oracle.com> bengsig@dk.oracle.com (Bjorn Engsig) writes:
>
>>   Article <1992Aug23.074048.16681@prism.poly.edu> by sjha@prism.poly.edu
>>   (Salil Kumar Jha) asks why this is illegal SQL:
>>   |
>>   |select * from emp 
>>   |where salary between
>>   |(select salary from emp where ename = 'Larry')
>>   |and
>>   |(select salary from emp where ename = 'John')
>>   |
>>   The problem is that SQL is a poorly defined laguage.  Read Date's
>>   "Critique Of The SQL Language".  There are numerous examples like yours.
>>   -- 
>>   Bjorn Engsig,		Internet: bengsig@oracle.com
>>   ORACLE Corporation.	BANG-net: uunet!oracle!bengsig
>>			   Private : bjorn@login.dkuug.dk.
>
>Well *that's* not too helpful!  No, SQL isn't great.  But there's a
>better way of expressing the query, which is what the original poster
>was after.
>
>You want to avoid subqueries whenever possible.  To get what you need,
>try the following:
>
>select distinct e1.* 
>  from emp e1, emp laremp, emp johnemp
> where laremp.ename = 'Larry'
>   and johnemp.ename = 'John'
>   and e1.salary between laremp.salary and johnemp.salary;
>
>(That's assuming I've got the "between" syntax right, which I'm not
>sure about.)
>
>This version of the query uses joins instead of subqueries, allowing
>for more join orders and join methods.  The added Distinct is just
>there to avoid having lots of dups in the output.  This might run
>marginally slower than your query (because of the sort for distinct),
>but is quite likely to run a whole lot faster (due to more join
>options for the optimizer.)
>
>If you want technical discussion of this issue, see
>"Extensible/Rule-Based Query Rewrite Optimization in Starburst" in
>SIGMOD '92.
>
>Joe Hellerstein

Actually, the reason the query won't work is that the sub-queries
can return MULTIPLE values [employees named Larry] and the main
query has to have ONE value for each end of the between.

Mike
Newsgroups: comp.databases
From: sethg@dcatlas.dot.gov (Seth Grimes)
Subject: Re: dBase to Ingres conversion
Organization: U.S Dept. of Transportation
Date: Fri, 4 Sep 1992 02:16:34 GMT

jwd@rivm.nl (Jan Diesel) writes:

>I'm posting this for a colleague who expects to receive several
>dBase III+ tables on a regular basis in the near future. Each
>shipment consists of exactly one dBase III+ table.
>We need to convert the dBase data to Ingres so we're looking for
>software that creates and fills an Ingres table from the original
>dBase data.
>Does anyone know if something like this exists ?

Ingres has (or at least used to) a "dBase gateway" that could read
dBase data as if it were stored in Ingres tables.  This would answer
the requirements, although it might be overkill.

Seth Grimes, dcatlas!sethg@uunet.uu.net
From: green@rwja.umdnj.edu (Cliff Green)
Newsgroups: comp.databases
Subject: Re: Help with Clipper5.01!!
Keywords: Clipper, Read
Date: 31 Aug 92 18:22:27 GMT
Organization: Robert Wood Johnson Medical School, Piscataway NJ

cslib@cc.newcastle.edu.au (DOUGLAS SCOTT) writes:


>  Example:    @ 1,1 SAY "Enter first variable:" COLOR "w+/b"
>	      @ 1,20 GET M->var1 PICTURE "XXXX" COLOR "bg+/b"
>	      
>	      IF M->var1 == "TEST"
>	         @ 2,1 SAY "Enter second variable:" COLOR "w+/b"
>	         @ 2,20 GET M->var2 PICTURE "9999" COLOR "bg+/b"
>              ENDIF
>	      READ

>	All I want to do is to be able to check each variable as it is entered
>  in the respective field. Is there an easy way?

I haven't actually tried it, but isn't that what the WHEN clause is for?
(e.g., @ x,y say "Blah" get blah when m->fubar =="TEST")

c








-- 
Clifford Green               Internet:   green@rwja.umdnj.edu
Academic Computing Services     voice:   908-463-4436
UMDNJ-RWJMS                       fax:   908-463-5252
#include <fineprint.h>
Newsgroups: comp.databases
From: chris@hawkesbury.uws.EDU.AU (Chris Thompson)
Subject: Mosaix new Language Development OOP's graphical GUI
Summary: Mosaix NEW
Keywords: language database access GUI 
Organization: University of Western Sydney
Date: Fri, 28 Aug 1992 02:21:56 GMT



				MOSAIX

I have heard of a product which has not got much press - seems OK
It's called 'Mosaix' from

Mosaix Marketing Pty Ltd
Attn Bill Dalgliesh
L1, 170 Pacific Hwy
Greenwich NSW 2065
Australia
(61)02-9013199
(61)02-9013493 Fax


Abstract:

The Mosaix ADL, ( Application Development Language) is a high  level language
designed to enable rapid development of graphics based applications in an X-
windows environment using object oriented methodologies. Mosaix provides a
graphical user interface toolkit, links to proprietary databases, integration of
raster and vector data, multimedia support and real time event handling.

Comment:
	Seems to offer a reasonable runtime price and for Uni's a reasonable
price for development. Would suit Sun environment. Language is written in 'C'
with its own syntax and lots of inheritable goodies.

Please contact  Bill Dalgliesh for further info.

Kind Regards
c.thompson@uws.edu.au
Newsgroups: comp.databases
From: edwards@world.std.com (Jonathan Edwards)
Subject: Re: Hot Standby DBMS's
Organization: IntraNet, Inc.
Date: Fri, 28 Aug 1992 19:28:02 GMT

In article <1992Aug25.063147.2764@anasaz> briand@anasaz (Brian Douglass) writes:
>>As journal data is received and written at the remote system, it is
>>asynchronously being recovered there, just like a normal journal (roll-forward)
>>recovery. Thus the remote system can recover and take over in a few minutes
>>from the production system.
>
>I think a difference lies in that while I suggest transactions
>are processed as they are received on the remote system, Mr. Edwards system
>seems to roll forward only upon primary failure, or I suppose nightly.  If
>I am wrong in this, please clarify.
No, the remote system is recovering (rolling forward) on the fly.
That's what the HOT in Remote Hot Standby means.

>What type/size systems is this operation implemented on?  If you can say.
>Large Unix OLTP operations are still a rarity compared traditional mainframe
>solutions, and I love to hear what others are doing.

VAX/VMS - the whole size range. The database itself is written in VAX
assembler and mostly runs in kernel mode to pull off some nice stuff.
The basic code is 10 years old, though it has evolved considerably.
By modern standards it is a white elephant, but will still blow the doors
off anything else. But it seems the market is willing to buy 10 times as
much hardware (literally!) in order to get a relational solution...



-- 
Jonathan Edwards				edwards@intranet.com
IntraNet, Inc					617-527-7020
Newsgroups: comp.databases
From: mccon@ssdd475a.erim.org (Joe McConnell)
Subject: Re: FoxPro2 & Paradox 3.5 questions -
In-reply-to: joet@dcatlas.dot.gov's message of Fri, 28 Aug 1992 13:50:05 GMT
Organization: Environmental Research Institute of Michigan, Ann Arbor, Michigan
Date: 28 Aug 92 13:43:06

Just a semantic point -- Paradox does not "include" add-ons like the
Paradox Engine (a library of C and Pascal routines) or the run-time
version.  They have to be licensed separately.  

Other than that, I agree -- the Engine, especially, is a nice-to-have
capability, since it lets you write little C routines that you can
call from within a PAL script -- there are some things that are much
faster done that way.
--
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: jjfink@skcla.monsanto.com
Newsgroups: comp.databases
Subject: Re: Simple Question on Paradox
Date: 27 Aug 92 11:15:32 GMT
Organization: Searle, Skokie, IL
Nntp-Posting-User: jjfink

In article <6717@tekig7.PEN.TEK.COM>, naren@tekig5.pen.tek.com (Naren Bala) writes:
> For those of you who are experts at using paradox, I had a simple question.
> I have started using paradox. Can anyone tell me how to merge 2 tables into
> one table ?  Any help will be appreciated. 
> Thanks
> 
> ** Naren **
> email: naren@tekig5.pen.tek.com

If the tables have the same format, you can use {Tools} {More} {Add} to
append one to the other.

If the formats are different, you can create a query with INSERT under the
table name as follows:

THISYR | Name   |  Address  |  Purchases |
       | _1     |  _2       |  _3        |

ALLYRS | Who    |  Total    |  Where     |
INSERT | _1     |  _3       |  _2        |

The _1's mean press the Example key (F5), then 1.
You do not have to fill in all fields in the INSERT table, nor use all
fields from the source table.  You can also calculate items (_1+_2, for
example), or type in constants in the INSERT table.  You can limit which
records in the source table by entering criteria, but you may not check off any
fields.

Joel
-- 
jjfink@skcla.monsanto.com
------------------------------------------------------------------------------
"Portions of the preceding were recorded.  As for the rest, I quite fear that
 it was all in your mind" -- Alfred Hitchcock
From: jjfink@skcla.monsanto.com
Newsgroups: comp.databases
Subject: Re: FoxPro vs Paradox
Date: 27 Aug 92 11:05:55 GMT
Organization: Searle, Skokie, IL
Nntp-Posting-User: jjfink

In article <1992Aug24.190545.28971@elroy.jpl.nasa.gov>, baalke@kelvin.jpl.nasa.gov (Ron Baalke) writes:
> I've justed received from Borland an offer for Paradox 4.0 for $200.
> It will retail for $795.  They also included literature saying how
> much better and faster Paradox 4.0 is over FoxPro 2.0.  I would like
> to see a comparison of these two products from a more objective source.
> Anyone care to comment?

Paradox and FoxPro use COMPLETELY different programming paradigms.
It's kind of an apples to oranges situation.

This graph may help.  The X axis is complexity of the project you need to
create on your database system, the Y axis is the amount of work.
               xx
|            xx
|          xx        oooo     x = Paradox
|         x      oooo         o = FoxPro
|        x   oooo
|       xoooo
|    oooo
|oooo  x
|     x
|xxxxx
|
+------------------------
   a   b     c

Paradox seems much easier to get a simple database together, including
relations, multiuser access, complex forms, etc.  This would be region (a)
above.  Region (c) is where things get out of hand with Paradox.  Past the
level where you can do everything with their forms and reports, you've got a
LOT of work to do.  I've not had a chance to do anything with 4.0, but if the
standard keyboard handling is not enough in version 3.5, you must handle
everything yourself (their DEToolkit is a steop in the right direction, but
very cumbersome).

Advantages for Paradox:
	Complex forms involving multiple tables are easier, so long as there
	is only a single level of link:  I.e. customer to PO, customer to
	salesperson and customer to store can all be done on one form, but
	customer to store to region can't be shown easily.

	Forms with multiple records per screen are easier in Paradox.  You
	have the option of scrolling areas with multiple lines per record,
	which is impossible in Fox.  In Fox you must use BROWSE windows,
	which are spreadsheet-like, with only one line per record.

	Paradox handles keyboard activity for navigating around your records.
	There is no such default in FoxPro

Advantages for FoxPRO
	The SELECT and FILTER statements let you limit the data you are working
	with on-screen, without generating sub-tables, as in Paradox.

	The SET RELATION command allows more flexible linking between
	relations.  Paradox does not permit on-screen (Form) relations except
	by entire fields.  You can not use a calculation or variable to link 
	relations in Paradox, without creating a query and a subtable.

	The Report Writer is more easily controlled by programming.

If you switch from one to the other, you will find things you love and things
you hate.  There are ways around just about everything, but you have to be able
to think differently.

Joel
--
jjfink@skcla.monsanto.com
------------------------------------------------------------------------------
"Portions of the preceding were recorded.  As for the rest, I quite fear that
 it was all in your mind" -- Alfred Hitchcock
From: bogart@bpb.it (Max Lanfranconi - R and D)
Newsgroups: comp.databases
Subject: Any mailing-list regarding Oracle?
Date: 28 Aug 92 13:13:26 GMT
Reply-To: bogart@bpb.it

First of all apologies if I'm not behaving as "netiquette" would suggest but I
just don't know where else I could ask:

A friend of mine explained to me how to post to a newsgroup by mail as I haven't
access yet to news :-{.

Here is my question:

Is there a mailing list about Oracle ? If yes how may I subscribe?

Please, please, please answer by e-mail to bogart@bpb.it as i *CAN'T* read news.

Thank you very much in advance and once more excuse me if this is an unappro-
priate posting.

--Max



*******************************************************************************
* Massimo Lanfranconi               Internet:  bogart@bpb.it                  *
* Organizzazione e S.I.  R & D      UUnet:     ...!uunet!bpb!bogart           *
* Banca Popolare di Bergamo-C.V.    Telephone: +39 35 392 528                 *
* Piazza V. Veneto 8                Fax:       +39 35 392 133                 *
* I-24122 Bergamo ITALY             Telex:     300410 BPBDIR                  *
*		                                                              *
*         I wish I were what I was when I wished I were what I am.            *
*                         					Anonymous     *
*******************************************************************************
Newsgroups: comp.databases
From: keltner@tetons (John Keltner)
Subject: Seeking information on ARCHI
Reply-To: keltner@tetons.igis.uiuc.edu
Organization: University of Illinois at Urbana
Date: Tue, 25 Aug 1992 22:59:04 GMT

Can anyone give me some information on a database program named ARCHI? Is
it relational, flat-file, what? Who distributes it? Is it any good?
Thanks.

Send replies to keltner@tetons.igis.uiuc.edu
Xref: sparky comp.databases:6332 de.comp.databases:80
From: joet@dcatlas.dot.gov (Joe Trott)
Subject: Re: FoxPro2 & Paradox 3.5 questions -
Organization: U.S Dept. of Transportation
Date: Fri, 28 Aug 1992 13:50:05 GMT

sandyc@elroy (Sandy Cox ) writes:


>		I would appreciate any one who has had experience
>	With FoxProx (2.0) and Paradox (3.5)  answering some questions
>	for me.  My company is researching both Database products.

>  	3) In FoxPro documentation it seems fairly easy to create screens and
>	menus.  I can't see anywhere in Paradox documentation how one would
>	create a screen ( not a form) and if you have a way could you please
>	give a straight forward example..?

In a Paradox script, the keywords TEXT and ENDTEXT delimit literal information
that will be put on the screen (at the current cursor position).  You can
then use @ and ACCEPT to read in variables.
Menus are created with SHOWMENU.  It is very clearly explained in the manual,
with code fragments.

>	4)  What are the pros and cons of one database package over another?
>	I mean when one gets into the nitty gritty development, which one
> 	is better?  and faster to develop in...

I'm not qualified to give an analysis of FoxPro, but I've used Paradox for
a couple of years now and I like it.  It has its anomalies, like Form
Locking (above and beyond WL, PWL, FL, and PFL) which can make multi user
programming "interesting"; you'll need to use suboptimal algorithms in some
places where full locking is not practical (e.g. SCANing a table in Form
View to make global changes), but it works.  I'm looking forward to getting
my copy of 4.0.  Paradox also includes a lot of development add-ons, such
as the Paradox Runtime and the Paradox Engine (for interface to C and Pascal).
Of course, FoxPro is Xbase, and there's a lot out there for that too, like
custom form and screen designers. 
Paradox interfaces to Quattro Pro too.

-JTT
From: michaelh@g2syd.genasys.com.au (Michael Haldey)
Newsgroups: comp.databases
Subject: Re: dbf format
Date: 31 Aug 92 05:45:25 GMT
Organization: Genasys II, Sydney, Australia

In article <PPOH.92Aug28171027@amethyst.tcs.tufts.edu> ppoh@amethyst.tcs.tufts.edu (Paul B. Poh) writes:
>
>I wondering if there is a paper or book that describes the dBASE database
>and index format. Since there are multiple vendors offering products that
>claim to be compatible with the dBASE dbf format, am I correct in assuming
>that the file format is public domain. Or do all these folks just reverse
>engineer the stuff.
>
>Any thing that describes Clipper or Foxpro index format would also be great.
>
>--
>Paul Poh                        Unix Systems Programmer
>ppoh@amethyst.tcs.tufts.edu     Computer Services, Tufts University

R. Spence Programming in Clipper 5. Chapter 11 (dbf, ndx, dbt formats).

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
From: fr@compu.com (Fred Rump from home)
Newsgroups: comp.databases
Subject: Re: FoxPro 2.5
Date: 25 Aug 92 15:29:01 GMT
Organization: CompuData Inc.

timk@tdkcs.waterloo.on.ca (Tim Kuehn) writes:


>In a recent advertisement in PC Mag, Microsoft said anyone who's running
>any other dbase language could get a copy of Foxpro for $199 US, and the
>next version (2.5) for free.

>Any word on what kind of offer those of us who've had Fox SW for eons and
>have paid all the upgrade fees/etc. will have to pay to get Foxpro 2.5?

If I can give you an example of what Borland is doing this may help. Got a 
blurp in the mail for the new Paradox 4.0 for $199.95 IE if you ever bought 
any borland product before you're elegible and if you just call you are too.

I then said: 'well, since you haven't even opened up the last 3.5 upgrade yet 
you might as just get that upgraded to 4.0 and it must be substantially 
cheaper'. Sorry, $179.95 is the upgrade from 3.5 to 4.0. This will 
automatically qualify you for the upcoming windows upgrade for only $199.95 
more. Somehow I have a fealing we're being ripped off over the short run here.

But I guess that's business. They don't have to produce new products just keep 
updating the old and make bundles of money.  

Somehow I don't think Dell has caught onto this trick yet as they sell the 
entire UNIX upgrade for $195. I guess that's because they're not really in the 
software business yet.

fred
-- 
W. Fred Rump 	office:	   fred@COMPU.COM     'mans feet have grown/so big 
26 Warren St.   home: fred@icdi10.compu.com  that he/forgets his littleness'
Beverly, NJ. 08010                          		Don Marquis 
609-386-6846    bang:uunet!cdin-1!icdi10!fr   
Xref: sparky comp.databases:6458 comp.databases.ingres:1256
Newsgroups: comp.databases,comp.databases.sybase,comp.databases.ingres
Subject: Comparison of Oracle/Ingres/Sybase on a VMS platform
From: sudhir@csc.wcc.govt.nz
Date: Mon, 31 Aug 1992 18:57:28 GMT
Reply-To: sudhir@csc.wcc.govt.nz
Organization: Wellington City Council, Wgtn, NZ


hi netland!

This is a request for information on the following 3 databases 
Oracle, Ingres and Sybase.

We (a local body) work on a 90 VUP VAX cluster of 6 machines and several DECStations
and about a 100Pcs using Pathworks to connect to the cluster and about
a 1000 terminals (500 users logged on at any one time). We use VMS
primarily and there is no plan to move to another platform in the
near future but would still like our chosen database to be portable.

We are starting on a comparative study of these 3 databases (or if someone
can suggest some other one eg Progress, Recital etc) and would like
some experiences of people in the netland. We would like information on

- Performance
- Development tools availability (vendor provided and 3rd party)
- Multi-database access from within applications
- a good API for use in GIS systems to get at the data from a C application
- data types and flexibility in defining and using new ones

Any help will be very useful and will make our task seem a bit easier. We have
until 15th October to submit our report so quick help will be very much
appreciated.

----------------------------------------------------------------------------
Sudhir Motwani, Consultant                              Voice: 64-4- 8013321
Information Technology                                  Fax  : 64-4- 8013020
Wellington City Council                       Domain: sudhir@csc.wcc.govt.nz
P O Box 2199,Wellington                   PSImail: PSI%0530147000090::SUDHIR
New Zealand                      UUCP: ...!munnari!vuwcomp!kosmos!csc!sudhir
----------------------------------------------------------------------------

Newsgroups: comp.databases
From: sethg@dcatlas.dot.gov (Seth Grimes)
Subject: Need SQL Assist contact info
Organization: U.S Dept. of Transportation
Distribution: comp
Date: Wed, 26 Aug 1992 18:05:17 GMT

I need an address and/or phone number for the company that makes
SQL Assist, a query and report generator tool.

Thanks,

Seth Grimes, dcatlas!sethg@uunet.uu.net

Newsgroups: comp.databases
From: marti@nugget.inf.ethz.ch (Robert Marti)
Subject: Re: Is this a bug or a limitation of the SQL language
Organization: Dept. Informatik, Swiss Federal Institute of Technology (ETH), Zurich, CH
Date: Wed, 26 Aug 1992 07:38:27 GMT

In article <87029@netnews.upenn.edu>, limsoon@saul.cis.upenn.edu (Limsoon Wong) writes:
|> >>>   The problem is that SQL is a poorly defined laguage.  Read Date's
|> >>>   "Critique Of The SQL Language".  There are numerous examples like yours.
|> 
|> Can someone kindly supply me a reference to this article?

C.J. Date:  A Critique of the SQL Database Language.  ACM SIGMOD Record
Vol. 14, No. 3 (November 1984).  Reprinted in "Relational Database:
Selected Writings", by C.J. Date, Addison Wesley, 1986.

An annotated version of the paper is

C.J. Date:  An Annotated SQL Critique.  Appendix F of the book "A Guide
to the SQL Standard, 2nd Edition", by C.J. Date, Addison Wesley, 1989.

(I wouldn't be surprised if you could also find reprints in other C.J.
Date books ;-)

--
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     |
Newsgroups: comp.databases