HDTenEightyP/NetNews huggingface dataset:
From: Gavin Trigg <gavin@asis.unimelb.EDU.AU>
Subject: Re: Database Procedure
Organization: National Radio Astronomy Observatory
Date: Mon, 7 Sep 1992 14:53:05 GMT

> 
> 
> Sorry for not giving specific details  to the problem. Here is the excerpt
> from the errlog.log file after trying to add the database procedure 
> via sql.
> 
>       ::[1036            , 00ABA040]: Wed Sep  2 18:17:47 1992 E_PS0F02_MEMORY_FULL	There is no more available memory. Try again later.
>       ::[1036            , 00744CE0]: Wed Sep  2 18:19:22 1992 E_PS0F02_MEMORY_FULL	There is no more available memory. Try again later.
>       ::[1036            , 00ABCE40]: Wed Sep  2 18:22:04 1992 E_PS0F02_MEMORY_FULL	There is no more available memory. Try again later.
>       ::[1036            , 00A920C0]: Wed Sep  2 18:25:07 1992 E_PS0F02_MEMORY_FULL	There is no more available memory. Try again later.
>       ::[1036            , 00A920C0]: Wed Sep  2 18:26:08 1992 E_PS0F02_MEMORY_FULL	There is no more available memory. Try again later.
> 
> chou@csd.hku.hk
> 
Dear Chou Sui Lin,

You need to increase the amount of space given to the parser.  The parameter
you need to set is -psf.memory in the server.  You could start by doubling the
size by using the formula 2 * default_size * active_sessions to get a new
value.  Having increased the parser size be prepared to come up against
limitations of the optimizer and query storage facility.  By the way, our
developers have found that the largest procedure they can get to work is about
16Kb.

-- 
Gavin Trigg	Internet: gavin@asis.unimelb.EDU.AU
		Telephone: +61 3 344 6003 	Fax +61 3 347 4803
Data Base Administrator, Information Technology Services (ASIS),
The University of Melbourne, Parkville, Australia.  3052.
Newsgroups: comp.databases
From: brentw@coopsol.com (Brent Williams)
Subject: Re: dBase to Ingres conversion
Organization: Cooperative Solutions, Inc.
Date: Fri, 11 Sep 92 16:52:01 GMT

joser@gfimda.uucp (Joe Rodriguez) writes:

>I intend to do the same thing as you are
>except in the other direction.  I have data in an INGRES table which I want
>to fill into a dbase file.


You might see if Ingres still sells a product called PC Link.  This was 
a DOS-based query tool that could download information from Ingres and 
put it into a variety of formats.  I don't recall, but .DBF may have 
been supported.  I know at least several formats of spreadsheet data 
were supported.  PC Link seemed to work pretty well, although it's not 
up to the slick graphical standards that everyone expects nowadays.

-brent


-- 
Brent Williams/Cooperative Solutions Inc., San Jose CA   (408) 377-0300
brentw@coopsol.com
Cooperative Solutions makes Ellipse, a development environment for
industrial strength graphical client/server business applications.
From: lindsey@tincup.enet.dec.com (Randy Lindsey)
Newsgroups: comp.databases
Subject: Re: Foxpro 2.0 Question
Date: 9 Sep 92 00:20:20 GMT
Organization: Colorado Software Solutions, Inc.


In article <brendaa.59@MCES.MsState.Edu>, brendaa@MCES.MsState.Edu (Brenda Arnsdorff) writes...
>When I run an EXE file created in Foxpro 2.0, I get an error "Unable to 
>create printer Driver".  It doesn't happen when I run an APP, only an EXE.  
>Anybody got any ideas?

I'm not sure, but perhaps one of these applies:
1. When you say run an APP, are you using the run-time Foxpro to run it,
   or your development version?  I would hope the run-time would act the
   same whether you are using the App support or the Exe support...
2. Perhaps the run-time doesn't support creating printer drivers?  If so,
   you'd want to create one in your development system and include it into
   your project.
3. Getting tangled up in read-only stuff that's included in the EXE rather
   than being excluded like your databases probably are.  I'm not sure if
   this applies at all...

Good luck,
Randy Lindsey
From: co@swbull.bull.se (Christian Olsson)
Newsgroups: comp.databases
Subject: Pro IV ?
Date: 11 Sep 92 11:22:07 GMT
Distribution: comp.databases
Organization: Bull AB.


Hello out there ...

Does anyone know something about Pro IV ?

Especially if it's ported to RS6000 (AIX 3.2),
and if so where to find info ?

Any help would be appreciated.

-----------======-------------
Christian Olsson
co@swbull.bull.se
Newsgroups: comp.databases
From: gheim@eng.auburn.edu (Greg Heim)
Subject: Any UNIFY users?
Organization: Alabama Department of Tourism (NOT!)
Date: Fri, 11 Sep 1992 16:43:50 GMT


Are there any UNIFY people out there?  I haven't seen any posts that 
give that indication.

We just started using ACCELL/SQL 1.3 on our development machine.  It
turns out you can only run one manager at a time with 1.3 because of a
non-unique error file (called "/tmp/err") created.  So much for high
speed development work!  To top it off you still have to manually
remove the file when done with the manager in order to start one up on
another database.  Our techie there is supposed to call and tell us how
to run everything from the command line to get around the bug ... gee
thanks dude.

Anyone else had this problem and/or know a workaround?


Thanks,

Greg


                    /~~~~~~~~~~~~~~~~~~~~~~~~~~\                A/~~\A
                    |    WELCOME TO ALABAMA    |               ((o  o))___    
                    |  Set  your  watch  back  |                 \  /     ~~~
                    |  an hour . . . set your  |  #              (--)\    #  
Greg Heim    --x---x|  calendar back 30 years  |--#---x---x---x---x---x---#---
USENET Junkie       \--------------------------/  #                    \  i_
gheim@eng.auburn.edu --| |--#---x---x---x-| |--x--#---x---x---x---x---x---#---
Sig. Copyright(c) 1991 | | )#(//  \\)(/  \| |(// \#(//  \|/   \\)|(/   \|)#(/
Newsgroups: comp.databases
From: sobczak@tplab.enet.dec.com (Piotr Sobczak)
Subject: Re: sql2-standard
Reply-To: sobczak@tplab.enet.dec.com (Piotr Sobczak)
Organization: Digital Equipment Corporation
Date: Wed, 9 Sep 1992 17:15:57 GMT


In article <7160241458-35099@exaib>, kaiser@exaib ( Alexander Kaiser) writes:
|> Path: uvo.dec.com!rdg.dec.com!news.crl.dec.com!deccrl!decwrl!spool.mu.edu!darwin.sura.net!haven.umd.edu!uunet!nestroy.wu-wien.ac.at!exaib!kaiser
|> From: kaiser@exaib ( Alexander Kaiser)
|> Newsgroups: comp.databases
|> Subject: sql2-standard
|> Date: Wed, 9 Sep 92 09:35:45 MESZ
|> Organization: WU-Wien
|> Lines: 15
|> Distribution: world
|> Message-ID: <7160241458-35099@exaib>
|> NNTP-Posting-Host: exaib.wu-wien.ac.at
|> 
|> 
|> 
|> We want to buy the SQL2 Standard.
|> Who can tell me an adress (if possible in Europe) to which we can send our order.
|> 
|> Alexander Kaiser
|> University of Economics and business administration
|> Department of Applied Computer Science
|> 
|> Augasse 2-6  1090 Vienna/Austria/Europa
|> 
|> e-mail: kaiser@exaib.wu-wien.ac.at
|> fax +43-1-31336/740
|>  phone +43-1-31336/4969
|> 
|> 

Of the addresses that I have, Germany seems to be the closest one to you.
There might be a member body in Austria too, you should check that. Anyway, here is the German address :

  Deutsches Institut fr Normung (DIN)
  Burggrafenstrasse 6
  Postfach 1107
  D-1000 Berling 30
  Germany

  Phone: +49.30.26.01-1
  Fax:   +49.30.260.1231
Newsgroups: comp.databases
From: lawrence@combdyn.portal.com (Lawrence *The Dreamer* Chen)
Subject: Re: HELP! db_Vista needed!!
Organization: Combustion Dynamics Ltd.
Date: Fri, 11 Sep 1992 15:13:40 GMT

In article <1992Sep11.010305.1532@omrongw.wg.omron.co.jp> tnishi@lsa.ncl.omron.co.jp writes:
>	Does ANYONE know about db_Vista?  It's my understanding
>that db_Vista is "free software" but no one here at my office has
>ever heard of it...
>
>	If it IS free and someone has the source to this, I would 
>appreciate it if it could be e-mailed to me...also, any information 
>about it would be helpful.
>
>	If this isn't the right group, could someone please tell me 
>where I could find out about this?
>
db_Vista has been renamed to "Raima Data Manager", and it is definitely
a commerical product....distributed by Raima Corporation.  Applications
built in Raima Data Manager can be distributed royalty-free, providing
you meet the terms of their license....like don't port to different
UNIX systems than the one your developing on. 

"I'm sorry Mr. Defense Department...we can't give you a copy of our software
unless you buy us a CRAY to develop it on first....and pay for a developer
license from Raima for the CRAY too...."

ALL STANDARD DISCLAIMERS APPLY


-- 
                                __
 :    _        _  _     _  _   :        _     Combustion Dynamics Ltd.
 :   :_: :   ::_::_ :\::  :_   :   :_: :_ :\: +1 403 529 2162
 :__ : : :/:/ : \:_ : ::_ :_   :__ : : :_ : : +1 403 529 2516 FAX
 EMAIL: lawrence@combdyn.portal.com || dreamer@lhaven.uumh.ab.ca
From: ramirez@IASTATE.EDU (Richard G Ramirez)
Newsgroups: comp.databases
Subject: FoxPro SQL
Date: 15 Sep 92 15:21:37 GMT
Reply-To: ramirez@IASTATE.EDU (Richard G Ramirez)
Organization: Iowa State University

FoxPro SQHas anyone had experience with FoxPro's SQL?
Can it be used from C or other language?

We use Oracle version 5 on a PC and decided not to
upgrade to version 6 because of excessive requirements.
We would like standard SQL, meaning as close to
DB2 or Oracle as possible.
Newsgroups: comp.databases
From: sgccsns@citec.oz.au (Shane Noel Smith 2245702)
Subject: GOSIP
Organization: CITEC
Date: Wed, 9 Sep 1992 05:28:09 GMT

Hello,


I am trying to find out some information regarding the implementation
of the OSI  transport layer 4 being available for Ingres*Net and
if anyone has a commitment from Ingres to GOSIP standards of any country.



-------------------------------------------------------------
|  Shayne Smith          |  Department of Family Services,  |
|                        |  Aboriginal and Islander Affairs |
|  sgccsns@citec.oz.au   |  Queensland AUSTRALIA            |
|------------------------|-----------------------------------
|  GPO Box 806           | These are my personal views only |
|  Brisbane              | My employer doesn't pay me       |
|  Qld, AUSTRALIA 4001   | enough to think fo them          |
-------------------------------------------------------------
From: reiner@ksr.com (David Reiner)
Newsgroups: comp.databases
Subject: OODBMS oppt'y, Boston, KSR
Date: 14 Sep 92 17:55:49 EDT
Distribution: na
Organization: Kendall Square Research Corp.

Kendall Square Research is looking for a creative software designer to
adapt, enhance, and tune third-party object-oriented DBMSs (OODBMSs) and
associated object-oriented development environments for the KSR parallel
machine. 

Areas of focus include large objectbase support, parallel objectbase
processing, and integration of OO development environments/languages with
OODBMSs. 

Essential knowledge: Current OO development environments including OODBMS
internals, with both hands-on experience and theoretical grounding.  Important
skills: Unix, C, and C++.  A significant plus: experience with relational DBMS
internals, parallel machines, performance tuning, software porting, or large
commercial database/objectbase applications.  MSCS in Computer Science 
preferred, or equivalent experience.

The ideal candidate has 5+ years of experience with a track record of design,
implementation, or porting OO products.  S/he is a creative software designer,
a strong, hands-on implementor, a team player able to work independently as
well, and a good communicator.  S/he welcomes challenge and complexity in a
very focused professional environment.

Email resumes to: reiner@ksr.com 

or send via US Mail to:
  Kendall Square Research Corporation
  Attn: Personnel Dept OODSR
  170 Tracer Lane
  Waltham, MA 02154

Kendall Square Research Corporation is an Equal Opportunity Employer.
Xref: sparky comp.databases:6712 comp.databases.oracle:1571 comp.dcom.lans.ethernet:1903 comp.dcom.lans.misc:739
From: jmr@motown.allied.com (John M. Ritter)
Newsgroups: comp.databases,comp.databases.oracle,comp.dcom.lans.ethernet,comp.dcom.lans.misc
Subject: Oracle SQL*Net <==> TCP/IP over Novell IPX/SPX !!??
Date: 13 Sep 92 19:36:57 GMT
Followup-To: comp.databases.oracle
Organization: Allied-Signal Inc., Morristown, NJ


We have Novell networks using Token Ring cards and UNIX machines on an
Ethernet network. One Novell server has both a Token Ring and Ethernet
card. Using the LAN support packet driver, a DOS workstation on the
Novell network can telnet to the UNIX hosts.

Now the problem:

We must set up a machine running Oracle, and the DOS workstations must
use SQL*Net. We prefer a UNIX machine with Oracle, but were told the
only way the connection can be made is to either add an ethernet card
to each DOS workstation or run LAN Workplace for DOS on each
workstation.

Anyone know if this is true? I have a hunch that perhaps Oracle on
UNIX may not be the right decision since this could turn in to a
connection nightmare for the anticipated 200+ machines.

Any thoughts, comments, nightmares or anecdotes would be appreciated!
------------------------------------------------------------------------------
"I enjoy working with human beings, and                         John M. Ritter
have stimulating relationships with them."                  Allied-Signal Inc.
            - HAL 9000                Corporate Information Systems & Services
                                                                (201) 455-6930
jmr@motown.allied.com              {att,bellcore,princeton,rutgers}!motown!jmr
------------------------------------------------------------------------------
Newsgroups: comp.databases
From: dhepner@cup.hp.com (Dan Hepner)
Subject: Re: Hot Standby DBMS's
Date: Wed, 9 Sep 1992 17:40:37 GMT
Organization: Hewlett-Packard
X-Newsreader: Tin 1.1scd1 PL4

From: oytor@teleserve.no (Oystein Torbjornsen)

>By
>introducing an open standard the customer can use DBMS' from different vendors
>for primary and hot standby.

>The two DBMS' is likely to be
>implemented by different people using different languages and different
>mechnisms and therefore have independent failure modes.

This is an intriguing idea, for reasons well stated by Oystein. The 
problem is that to do this requires that the content of those
"standby records" needs to be standardized.  Such standardization
seems unlikely at this time.

Beyond that, what would we make of databases which came to be
out-of-sync?  Which one is right, which wrong?  Should we add
a third, and take a vote?  What if all three disagree?

A fun thing to think about, though.

Dan Hepner
From: chris@yen.imsi.com (Chris Payne)
Newsgroups: comp.databases
Subject: Re: SuperNOVA Dbase Package (NEW)
Date: 10 Sep 92 22:27:58 GMT
Organization: Moore Capital Management
In-reply-to: 2pereira_f@spcvxb.spc.edu's message of 1 Sep 92 14:32:22 GMT
Originator: chris@yen


2pereira_f@spcvxb.spc.edu writes:

   Has anyone heard of SuperNOVA Dbase Package?
   It's is a new object oriented database Package which
   interfaces with 'C' and Teradata, Informix, Oracle Databases.
   I can be run on PC and genaraly used with UNIX Systems.


SuperNOVA is a dog.  For the money, depending on your application,
look at JYACC's Jam & Unify's Uniface.

If 'object oriented' describes SuperNOVA then we're all doomed.

Ask me and I'll tell you more.

/c (chris@IMSI.COM, chris payne in NYC)
Newsgroups: comp.databases
From: mjducey@rodan.acs.syr.edu (Matthew "The Daddy" Ducey)
Subject: Find data on horse races?! Help.
Originator: mjducey@rodan.acs.syr.edu
Organization: Syracuse University, Syracuse, NY
Date: Mon, 14 Sep 92 10:46:53 EDT




I need to find data on horse races (the results), does anyone know if I
can get this electronicly? If so,where?

Thanks, 
Matthew
Newsgroups: comp.databases,bit.listserv.dbase-l
From: ifenton@crc.ac.uk (I. Fenton)
Subject: Re: Clipper: Backup/Restore routines for BIG files...
Organization: MRC Human Genome Resource Centre
Date: Wed, 2 Sep 1992 10:24:06 GMT

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

a number of points to make here.  dbf files of 2-4 megs ain't HUGE.  my
main app has a dbf of 16 megs.  the index (ntx) files add up to >1 meg.
anyway, i tried splitting it under program code to a floppy(s) by using
ascii delimited format.  but this ended up as beig 10+ floppies.  pain.
so, now using the Overlay library to run a large DOS command.  i then
call a pd squashing program (pkzip etc.) to make the dbf small.  this can
make the file maybe 8 - 10 times smaller, as most dbf files are full of 
empty space.  hope this helps.

IAIN FENTON
Inst of Medical Genetics, Cardiff, UK
From: v510uefs@ubvmsb.cc.buffalo.edu (Kevin Lyda)
Newsgroups: comp.databases
Subject: Advice...
Date: 5 Sep 92 13:55:00 GMT
Organization: University at Buffalo
News-Software: VAX/VMS VNEWS 1.41

I'm currently working on a database system that needs to have telnet,
PC and Mac access.  I'm wondering if some people could share their
experiences with some database systems in a similar project.
Currently, I'm considering Oracle and DBase.  Are there other DB
systems which operate on PC, Mac and either VMS or SunOS?  I'm
constrained by file locking mechanisms (it can be changed in a telnet
session, with multiple sessions allowed) and disk space (I need to be
able to compile the micro DB's to a floppy).

Thanks in advance!

Kevin
Newsgroups: comp.databases
From: dtodd@titan.ucc.umass.edu (David M. Todd)
Subject: Re: Advanced Revelation Users?
Organization: University of Massachusetts, Amherst
Date: Fri, 11 Sep 1992 16:54:45 GMT

In article <1992Sep10.222454.13692@u.washington.edu> someday@milton.u.washington.edu (Scott Johnson) writes:
>Maybe (hopefully!) AREV traffic here can pick up as people start using
>version 3.0 of AREV.  Should generate lots more feedback from people.
>
The promotional material on 3.0 looks very good.    Speed and interface
improvements should make Advanced Revelation more interesting to a
general audience.  


|/ David M. Todd \ " " " " / Phone:  413/545-0158 \ " " " " /Fax: 413/545-5345\|
|DTodd@Titan.ucc.UMass.EDU [or todd@umass.bitnet or David Todd on UMass/Saturn]|
|Department of Psychology, University of Massachusetts, Amherst, MA 01003   USA|


Newsgroups: comp.databases
From: dhepner@cup.hp.com (Dan Hepner)
Subject: Re: Hot Standby DBMS's
Date: Wed, 9 Sep 1992 02:30:06 GMT
Organization: Hewlett-Packard
X-Newsreader: Tin 1.1scd1 PL4

From: dboyce@hemel.bull.co.uk (David Boyce)


>Interfaces for obtaining journal data from an RM and passing it to an
>standby RM would be needed, as would RM-independent methods of recovery
>and catch-up.  Not beyond the wit of man, I would have thought.
>
>Obviously the database vendors need to be convinced of the need to make
>this interface available. 


Any ideas on how to convince them?  In particular, it needs to be
shown what can be done using this scheme which the DB vendors 
could not do themselves.  Intuitively, one would say "but it's
more open".  In what way does this openness benefit anyone?

Dan Hepner
Newsgroups: comp.databases
From: cdblueth@essex.ecn.uoknor.edu (Chris D Bluethman)
Subject: Gupta Client Server
Date: Wed, 9 Sep 1992 06:07:39 GMT
Organization: Engineering Computer Network, University of Oklahoma, Norman, OK, USA


Is anybody out there using Gupta's DBMS?  Gupta produces
the SQLBase Client Server system with a developement 
environment under Microsoft Windows.  I saw all the Clipper
and Foxbase talk, but no Gupta...


                         Chris Bluethman
Newsgroups: comp.databases
Subject: Learning SQL
From: brent@spss.com (Brent Lambert)
Date: Tue, 8 Sep 1992 16:33:24 GMT
Followup-To: comp.databases
Organization: SPSS, Inc. - portable code group
Keywords: SQL tutorial training learning

I don't recall a FAQ for comp.databases, but if one is ever created,
this is a candidate question:  How should someone go about learning
SQL, and database use in general.

I have a friend who is somewhat familiar with databases and would like
to learn SQL both from books and in a 'hands-on' manner.  Does anyone
have a suggested reading list?  How about suggested free or cheap PC
database software (relational, SQL), preferably with a tutorial, that
can be used at home for hands-on learning?

I know I've seen variations of this question posted often, but this is
the first time I've had any reason to pay attention to the responses.
Sorry to have to do it again.

Posted responses are preferred.

-- 
The above statements are not the opinions or policies of SPSS Inc.
The above statements may not be the opinions of Brent Lambert.
The first disclaimer is a policy of SPSS Inc.
Subsequent disclaimers are probably the opinion of Brent Lambert.
Newsgroups: comp.databases
From: Brennan.J.Murphy.53@nd.edu (Brennan Murphy)
Subject: A Mail/Database question from an amatuer
Followup-To: comp.databases
Organization: University of Notre Dame
Date: Mon, 14 Sep 1992 15:39:24 GMT


Please tell me either how to set up a Eudora like application that would
allow me to compile a large list of email addresses and then send out a
mass mailing to them all at once.  I want to be able to add addresses to
the list with ease.  I am familiar with making a nickname to represent all
of the addresses but I need database capabilities also in the program for
easy changes and for recording mailing addresses.  In short, I would like
the best program to construct a large mailing list of email addresses. 
Maybe someone could send me the address of the guy who designed Eudora? 
Any help or sense of direction would be appreciated.
Thanks,
Brennan
Newsgroups: comp.databases.theory
From: dzik@access.digex.com (Joseph Dzikiewicz)
Subject: Re: What constitutes a 4GL?
Organization: Express Access Online Communications, Greenbelt, MD USA
Date: Wed, 2 Sep 1992 12:05:58 GMT

In article <1992Sep2.025045.9663@cc.uow.edu.au
>
>I read somewhere, that the productivity of programmers has only increased by
>a few per cent since the beginning of computing - if this is true (and I am
>*not* necessarily saying that it is), then it just about throws out the above
>theory.
>

The explanation that I have heard is that programmers will tend to produce
the same number of lines of code per day.  With higher order languages,
a line of code does more.  Therefore, programmers in a higher order language
are more productive not in terms of lines of code per day, but in terms
of functionality produced.

This doesn't explain differences between machine language and
assembler productivity, but would explain 2GL vs 3GL vs 4GL 
productivity.

Joe Dzikiewicz

Newsgroups: comp.databases.theory
From: sgccsns@citec.oz.au (Shane Noel Smith 2245702)
Subject: GOSIP
Organization: CITEC
Date: Wed, 9 Sep 1992 05:21:50 GMT

Hello,


I am trying to find out some information regarding the implementation
of the OSI  transport layer 4 being available for Ingres*Net and
if anyone has a commitment from Ingres to GOSIP standards of any country.



-------------------------------------------------------------
|  Shayne Smith          |  Department of Family Services,  |
|                        |  Aboriginal and Islander Affairs |
|  sgccsns@citec.oz.au   |  Queensland AUSTRALIA            |
|------------------------|-----------------------------------
|  GPO Box 806           | These are my personal views only |
|  Brisbane              | My employer doesn't pay me       |
|  Qld, AUSTRALIA 4001   | enough to think fo them          |
-------------------------------------------------------------

Newsgroups: comp.databases.theory