HDTenEightyP/NetNews huggingface dataset:
From: cm@ariel.its.unimelb.EDU.AU (Charles Meo)
Newsgroups: comp.databases.oracle
Subject: Re: orasrv: server already running: Address already in use
Date: 7 Oct 92 12:23:11 GMT
Organization: Solbourne Computer Australia

In <7iy7RB2w165w@netlink.cts.com> tumidity@netlink.cts.com (Joel Garry) writes:
>If you are on a unix machine, run ipcs to find out what semaphores and
>shared memory areas are being used.  Run ipcrm to remove them.  Then

You could go further and use ipcs to find the shared memory resources
associated with your instance every time you start it up. That way, if something
nasty happens, you can immediately know which resources to remove without 
having to think about it--very helpful if you have lots of instances plus
pressure or fatigue.

Of course you would store this valuable info in some sort of log file using
methods in keeping with your personal tastes and enthusiasm for this sort of
stuff....have fun!

NB I don't know whether the latest releases of oracle do this for you anyway--
I haven't used it for a while. It was certainly a good idea 6 months ago.

Chuck
-- 
Chuck Meo
Solbourne Computer Australia
cm@ariel.ucs.unimelb.edu.au
'SYS5R4: I am Your Density'
Newsgroups: comp.databases
From: durai@ORTTA (Appadurai V.)
Subject: Re: Foxpro - help with radio button objects
Organization: U of Mn
Date: Fri, 9 Oct 1992 12:59:29 GMT

In article <1992Oct7.021550.33333@datamark.co.nz> david@datamark.co.nz (David Rowland) writes:

>In article <fragante.718321710@unixg.ubc.ca> fragante@unixg.ubc.ca (Gv Fragante) writes:

>>Also, is there a command/functions similar to OBJNUM() and _CUROBJ that can
>>tell me the type of control (i.e. - radio, push button, pop-up list) that
>>a field is using ?
>>

>If you are using a function i.e. VALID <fnctn>, add a parameter to the
>function which contains the type of control.

>i.e.  @ x, y GET abc ;
>             FUNCTION "*R ..." ;
>             VALID valid_function("R", ....) ;
>             WHEN  When_function("R", ...)

>      FUNCTION valid_function
>      PARAMETER contrl_type, ....
>-- 
>+-------------------+--------------------------------------------------+
>| David Rowland     | The British are using New Zealanders.  They must |
>| Datamark Intl Ltd | really mean bussiness !                          |
>| Wellington        |      -  General Rommel During Northern African   |


One problem with using valid function is, you will never know the type of 
control until you perform some action with the object.. if you have to know 
before even doing something with the object, imho, when is better.  Or how 
about passing the control type, with the previous object ?
From: shm@syl.syl.nj.nec.com (Shailendra Majmundar)
Newsgroups: comp.databases
Subject: Wanted: FoxPro 2.0 book
Date: 13 Oct 92 19:42:03 GMT
Reply-To: shm@syl.nj.nec.com
Distribution: na
Organization: NEC Systems Laboratory, Inc.

I want to buy a FoxPro 2.0 book. If anyone wants to sell or have
a suggestion for a good book, please contact me at shm@syl.nj.nec.com.

TIA,
Sam
Newsgroups: comp.databases
From: ifenton@crc.ac.uk (I. Fenton)
Subject: Re: Clipper Windows Version
Organization: MRC Human Genome Resource Centre
Date: Tue, 13 Oct 1992 10:58:05 GMT

In article <1992Oct12.133816@axion.bt.co.uk> jpennell@axion.bt.co.uk (John Pennell) writes:
>
>
>I'm not sure, but isn't ASPEN (clipper for windows?) been purchased outright by Computer Associates???
>
>Jon

nantucket, the people who brought you clipper, were bouhgt outright by big,
bad computer associates.  aspen is the secret (*grin*) research project by
nantucket to succedd  clipper with a platform-independetn, windows-based
database with run-time speed approaching that of pure c-code.  there is no
released product as yet, but one is expected next year, prably first on the
pc-windows platform, then on os/2 and maybe some form of unix.  ca sent out
a 'staement of direction' to all clipper users, which included, for the
first time, screen-shot of the aspen project,.  it looked a little bit like
microsoft's visual-basic !  but with more serious development tools.

i hope this helps.

=============================================================================
IAIN FENTON                             | All errors of spelling, grammar &
Institute of Medical Genetics           | fact are due to a missing <Del> key
University of Wales College of Medicine |====================================
Heath Park                              | "No man should marry until he has
Cardiff  CF4 4XN                        |  studied anatomy and dissected at
U.K.                                    |  least one woman" - de Balzac
=============================================================================
Voice = +44 - 222 - 744049   | In 1912, Jack Johnson, the first black world
Fax   = +44 - 222 - 747603   | heavyweight boxing champion, was refused
Email = fenton@uk.ac.cardiff | permission to board the Titanic because of
   (or) wmgif@uk.ac.cardiff  | his colour.
   (or) ifenton@uk.ac.crc    |
=============================================================================
Newsgroups: comp.databases
Subject: Re: Bullet Proof Network Database Wanted
From: graeme@hart.actrix.gen.nz (Graeme Hart)
Date: 7 Oct 92 8:40:8 GMT
Keywords: network database unix reliable

dlucy@sandr.COM (Douglas Lucy @ S&R Software, Inc.) once wrote....
>In article <1992Oct5.171449.7022@combdyn.CombDynLtd.MedicineHat.AB.CA>
> lawrence@combdyn.CombDynLtd.MedicineHat.AB.CA (Lawrence Chen) writes:
>
>> I'm looking for either a Network Database product or a way to make
>> Raima Data Manager for UNIX that's capable of surviving powerfailures.
>>
>> Our application is in use by the Military which have a requirement that the
>> systems be able to survive random power outages.  Aside from the fact that
>> not having at least one outage a day is considered a miracle.
>>
>> If its not possible to have the database bullet proof to this kind of failure,
>> at least have enough redundancy that its auto-recovery can fix the damage....
>> even if it means losing the current transaction, just as long as the system
>> remains usable.
>
>PROGRESS RDBMS (from Progress Software Corp in Bedford, MASS) has two
>levels of crash protection: the first is an automatic,
>transaction-bounded recovery of the database designed specifically to
>protect against server failure (i.e. powerloss); the second is a
>deeper level of protection that must be specified at the time the
>server is started and needs two separate hard disks to provide
>hardware-level failure recovery. These protections are one of the most
>important features of Progress (for us).
>
>Progress is available for almost all Unix platforms and the weird
>stuff like DOS and VMS and CTOS/BTOS.
>
>I'm sure Oracle and Informix have similar recovery mechanisms.

And InterBase too....

>-- 
>| Doug Lucy        | "I'm just sipping champagne like a good tycoon..."  |
>| S&R Software Inc |                                   -Floyd, Pink      |
>| dlucy@sandr.com  |                                                     |

----
Graeme Hart                                     Telephone:  64 4 3829124  
graeme@hart.actrix.gen.nz                       Snail Mail: PO Box 11865    
                                                            Wellington       
                                                            New Zealand

Newsgroups: comp.databases,comp.os
From: lapworth@mizar.usc.edu (Bill Lapworth)
Newsgroups: comp.databases
Subject: For Sandro De Matteis
Date: 15 Oct 1992 09:44:27 -0700
Organization: University of Southern California, Los Angeles, CA
NNTP-Posting-Host: mizar.usc.edu

Sorry for bandwith waste, my mailer says your address does not exist.
I have response to your Clipper problems, would also like to exchange
code.  Email me, please.
From: allenjm@eng.auburn.edu (John M. Allen)
Newsgroups: comp.databases
Subject: Foxpro 2.0 decompiler?
Date: 7 Oct 92 22:35:32 GMT
Organization: Auburn University Engineering

Hi,
	I am looking for a decompiler for foxpro 2.0.  I have just finished a 
database and distributed it in .exe format.  Now that I have finished, the hard
drive flew south for good.  I have the .exe on disk but am missing some of
my source code.
	I saw a post recently referring to Hilco software but I didn't get
the address or phone number.
				-Thanks
					John Allen
Newsgroups: comp.databases
From: alexbr@cs.stanford.edu (Alexander M. Brousilovsky)
Subject: ORACLE cardinality
Organization: CIFE, Stanford University
Distribution: comp
Date: 15 Oct 92 12:58:51


Hello, friends,

Does somebody knows how to find the cardinality of the relation
without actually computing it in ORACLE database?

Thank you.

Alex.


Newsgroups: comp.databases
From: sethg@dcatlas.dot.gov (Seth Grimes)
Subject: Front-end evaluation: Q+E Database Editor
Organization: U.S Dept. of Transportation
Distribution: comp
Date: Thu, 8 Oct 1992 19:17:53 GMT

My office is evaluating a number of DB front-end tools, including
Q+E Database Editor.  Because there have been a number of posts
recently on front-end tools, I thought others would be interested
in comments from my coworker who did the Q+E evaluation:


In case anyone is interested: I finally talked with the Tech Support
people about the Q+E Database Editor product and they confirmed that

1. The only tables that will ever be listed to choose from are those owned
   by the user and not those owned by the DBA. They consider this a bug
   and will fix it in a future release.

2. Joins can only use one column per table. There is no easy way
   around this.


To this I'll add that, **unless there's a better way to do this that
we don't know about**, to join two tables dynamically (i.e., without
first defining a view or joindef) Q+E forces you to retrieve each 
table and _then_ join them.  This can entail significant processing 
and network cost.  One should be able to join tables by displaying
their fields and designating the key fields on which to join without
retrieving any data until you've defined the join.

Seth Grimes, dcatlas!sethg@uunet.uu.net
Newsgroups: comp.databases
Subject: Clipper Windows Version
From: david@datamark.co.nz (David Rowland)
Date: Mon, 12 Oct 1992 03:50:20 GMT
Organization: Datamark International Ltd.

I Read a review about a future product from nantucket which is the
windows version of clipper.  Does anyone know about it (i.e. release
dates etc)???

Thanks in advanced.
-- 
| 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
From: monty@blackhole.lerc.nasa.gov (Monty Andro)
Subject: Foxpro "FOXSWAP.COM" question ?
Organization: NASA Lewis Research Center
Distribution: comp
Date: 13 Oct 92 05:14:05


Hello,

I have just a few questions on the use and the need of FOXSWAP.COM.  I
could not find much in the documentation - maybe I just missed it.
First, what is FOXSWAP.COM used for?  Second, if I build a foxpro
executable, is it necessary to distribute FOXSWAP.COM with my
executable? 

Any help or suggested reading would be greatly appreciated.

Monty
From: hfesh@usho0c.hou281.chevron.com (F.E.Shipley)
Newsgroups: comp.databases
Subject: SQL3 Standards	Document
Keywords: ANSI ISO SQL Standards
Date: 9 Oct 92 12:47:20 GMT
Organization: Chevron

Is the draft spec of SQL3 ftp-able? What is the status of SQL3?
Newsgroups: comp.databases
From: allenjm@eng.auburn.edu (John M. Allen)
Subject: Re: Foxpro "FOXSWAP.COM" question ?
Organization: Auburn University Engineering
Distribution: comp
Date: Wed, 14 Oct 1992 06:21:08 GMT

In article <MONTY.92Oct13051405@blackhole.lerc.nasa.gov> monty@blackhole.lerc.nasa.gov (Monty Andro) writes:
>I have just a few questions on the use and the need of FOXSWAP.COM.  I
>could not find much in the documentation - maybe I just missed it.
>First, what is FOXSWAP.COM used for?  Second, if I build a foxpro
>executable, is it necessary to distribute FOXSWAP.COM with my
>executable? 
>
>Monty

Foxswap.com is a program similar to the run command except I think it removes
as much of foxpro from memory as possible and executes the dos program
specified.  I have noticed on occasion after I have used foxswap.com and
quit foxpro that I am missing about 300K of base memory.
I suppose if you used foxswap.com in an exe you would have to distribute
it since it is an external program.  The linker might link it but I doubt it, I
haven't tried it.
If memory serves me, and it usually doesn't, you may be able to find some
information about foxswap in the online help of foxpro v2.0.  I think it
was somewhere near the beginning of the file.

Hope this helps.

			-John
Newsgroups: comp.databases
From: nelson@paradyne.com (Bill Nelson)
Subject: dbase/clipper help
Organization: AT&T Paradyne, Largo, Florida
Date: Mon, 12 Oct 1992 12:58:09 GMT

Can anyone provide code/comments regarding saving an orginizational chart
in dbase/clipper. 

What I would like to do is save all individuals names and some information
about each one into a dbase record, be able to add/delete/modify each 
record, and list either the entire structure or the structure beneath a
particular individual in some sort of pictoral format - a simple Norton NCD 
type format would be sufficient, i.e.

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)


Thanks,
Bill 
--
| Bill Nelson    | This space intended  | Opinions expressed do not necessarily |
| AT&T Paradyne  | blank!               | reflect those of my employer; in fact,|
| (813) 530-8696 |                      | they may not represent mine either.   |
+----------------+----------------------+---------------------------------------+
Newsgroups: comp.databases.ingres
From: cs_mj@gsbacd.uchicago.edu (Mark Jaeger)
Subject: Re: Table level locking
Organization: 
Date: Thu, 15 Oct 1992 23:05:42 GMT

In article <1992Oct15.101724.1702@tac.fi>, tio_on@tac.fi (Ossi Numminen) writes:
>
> If I have a table which resides on - say - three different
> locations on three different disks and some application
> escalates to table level locking, does Ingres always lock
> all those three locations, or only that one where the data
> actually is?

INGRES's table-level locking is just that--the whole table is locked,
regardless of what location it's on or how many locations it has.

INGRES locking works similarly to VMS locking.  Locks are taken out on a
resource, which can be a data page, a table, or a whole database (and
other things too, but I don't know what they all are).  You can see lots
of different resources if you look at the locking section of IPM, and
tell it to display _all_ resources (including system/internal ones).  

I don't think that INGRES considers "the portion of a table that lives
on one location" as a resource by itself.

--Mark Jaeger				internet: cs_mj@gsbvax.uchicago.edu
Graduate School of Business		yellnet:  (312) 702-0328
University of Chicago			faxnet:   (312) 702-0233
Disclaimer: My opinions are my own and not those of my employer.
Ich bin ein Virus.  Mach' mit und kopiere mich in Deine .signature.
From: cs_mj@gsbacd.uchicago.edu (Mark Jaeger)
Newsgroups: comp.databases.ingres
Subject: Re: help with: "E_US0C1C Query requires too many range variables."
Date: 16 Oct 92 17:32:43 GMT
Article-I.D.: gsbacd.1992Oct16.113243.1

In article <ROBM.92Oct15170613@ataraxia.Berkeley.EDU>,
robm@ataraxia.Berkeley.EDU (Rob McNicholas) writes:
> Platform: INGRES Version 6.4/01 (ds3.ulx/02)
>           DECsystem 5000/200, Ultrix 4.2
>
> I have a query (in a Report Writer report) built from a union of three
> views.  This worked fine with only two unions, but the third broke the
> camel's back, so to speak.
>
> What I'm doing seems pretty straightforward to me, but in my attempt
> to hide the underlying structure of the database, my views got pretty
> complicated, I guess...
>
> Is there a server option I can set that will allow more range variables?...
>
> [Editorial comment: This seems like a silly limitation of Ingres'.  I
> mean, I have a incredibly fast machine, with close to 100 meg of
> memory, gigabytes of disk space, and still I'm being restricted by
> some internal limit.  Aaargh.]
>
> Rob McNicholas		    Technical & Computing Services, EECS, U.C. Berkeley
> robm@eecs.berkeley.edu	    Voice: 510/642-8633  FAX: 510/643-7846

I strongly doubt whether there is any such server option.  The limit is
probably hard wired in the server source code.

I think you've run up against a fundamental limitation of the server. 
You can have a maximum of 30 tables in the "from" clause of a select
statement.  If you have views built upon views, then there may be more
tables implied in the query than it appears.  

If you think 30 tables is bad, then you should have tried using INGRES
version 5, where the limit was 10.

It strikes me as odd that adding another query to a union caused the
error, assuming that each subselect ran just fine.  I would have
expected that OPF would optimize each subselect independently.  Try
running each one separately in the terminal monitor with "set
optimizeonly" to see if it's just one that breaks it, or the union of
the three.

If you really have that many tables in one query, then maybe your
database design is over normalized.  That sounds like an awful lot of
tables, and it strikes me as questionable whether the server could come
up with a reasonable query plan in a reasonable amount of time for
something that complicated.

--Mark Jaeger				internet: cs_mj@gsbvax.uchicago.edu
Graduate School of Business		yellnet:  (312) 702-0328
University of Chicago			faxnet:   (312) 702-0233
Disclaimer: My opinions are my own and not those of my employer.
Ich bin ein Virus.  Mach' mit und kopiere mich in Deine .signature.
From: ingersol@stein.u.washington.edu (Steve Ingersoll)
Newsgroups: comp.databases.ingres
Subject: Re: dbmsinfo() function
Date: 16 Oct 92 15:15:13 GMT
Article-I.D.: u.1992Oct16.151513.844
Organization: University of Washington, Seattle

In article <1992Oct14.161239.1@gsbacd.uchicago.edu> cs_mj@gsbacd.uchicago.edu (Mark Jaeger) writes:
>Maybe the server counts the requests that QEF makes to the DMF, not i/o
>requests to the OS made by DMF.  The DMF may be able to return to QEF a
>page from its cache without issuing an actual i/o.  This might account
>for the fact that a given query can cost less in dio's (as shown by
>dbmsinfo('_dio_cnt')) the second time when you execute it twice in a
>row.
>
>Just a guess.
>
>--Mark Jaeger				internet: cs_mj@gsbvax.uchicago.edu
>Graduate School of Business		yellnet:  (312) 702-0328
>University of Chicago			faxnet:   (312) 702-0233
>Disclaimer: My opinions are my own and not those of my employer.
>Ich bin ein Virus.  Mach' mit und kopiere mich in Deine .signature.



	At first I had this same thought. I then did some test and could not
explain why the first call would get n number of I/O requests (after the
backend server was restarted) and would get y number of I/O requests on the
second call and z number of I/O requests on the third call. Note that x, y, and
z all had different values. I would have expected the numbers to be the same.


Steve Ingersoll				internet: ingersoll@cac.washington.edu
University Computing Services		phone:	  (206) 685-3371
Newsgroups: comp.databases.ingres
From: lindsay@giaeb.cc.monash.edu.au (lindsay smith)
Subject: SQL Errorcodes
Organization: Monash University, Melb., Australia.
Date: Tue, 13 Oct 1992 01:52:03 GMT


My organisation has recently switched over to using INGRES as a teaching
platform for our DataBase units. Recently a student while running an ESQL
program written in C received an SQLCODE error of -40204. The inquire_sql call
apparently returned a blank message. I have two questions which someone might
be able to help me with

a. what is this particular error triggered by?, and

b. is there anywhere in the INGRES documentation where these codes are listed?
I have already done a fairly extensive search - but to no avail.

Lindsay.
-- 
Lindsay Smith, Computing Lecturer
Monash University College Gippsland    Internet: lindsay@giaeb.cc.monash.edu.au
Switchback Rd, Churchill, 3842         Phone   : +61 51 226 669
Victoria AUSTRALIA                     Fax     : +61 51 226 738
From: kml@wan.inf.rl.ac.uk (Kevin Lewis)
Newsgroups: comp.databases.ingres
Subject: Carriage Returns.
Date: 8 Oct 92 14:20:09 GMT
Reply-To: kml@wan.inf.rl.ac.uk
Organization: SERC Rutherford Appleton Laboratories

Hello,
I have been asked a question by a prospective ingres user.
He currently has a very large database running on 'Simplify'.
His data currently contains lots of 'carriage returns' within fields, ie not as field separators.

He wishes to know whether- a/ ingres can store his data in the same way
			   b/ the bulk loading facilities in ingres ie, the 'copy'
			   command can be used to get the data in and out of files.
			   c/ the fields containing carriage returns can be displayed
			   sensibly in reports, application forms etc.

I apologise for asking a question for which the answer may be RTFM, but I've not really found a straightforward answer.


---------------
Kevin Lewis				JANET	kml@uk.ac.rl.inf
Informatics Dept,			EARN	kml%uk.ac.rl.inf@rl.ac.uk
Rutherford Appleton Laboratory,		ARPA	kml%uk.ac.rl.vd@ucl.cs.nss.arpa
Chilton, DIDCOT, Oxon.			UUCP	{...!mcvax}!ukc!rlinf!kml
OX11 0QX     UK.
From: cs_mj@gsbacd.uchicago.edu (Mark Jaeger)
Newsgroups: comp.databases.ingres
Subject: Re: Help with Locking and timeout's (Ingres 6.2 on SCO ODT 1.1)
Date: 16 Oct 92 17:13:01 GMT
Article-I.D.: gsbacd.1992Oct16.111301.1

In article <Bw6K00.BIw@world.std.com>, jaa@world.std.com (Jerry A Abramson) 
writes:
> 
> I am having some problems with a process live-locking, (i.e. hanging) when
> trying to gain an IX then an Xlusive lock during DB reads.  I have used
> the LOCKMODE command and set timeout = 10, but I only timeout after the
> other concurrent session finished its current transaction.
> 
> Platform: Ingres 6.2/03p
> O.S:	  Open Desktop 1.1 with Update G and ODT-DATA combined fixes 2

Why not upgrade to 6.4?

It's just my opinion, but I wouldn't touch anything before INGRES
release 6.4 with a ten-foot pole.  We have used INGRES extensively under
VAX/VMS from the earliest releases of version 6, and it was _b_u_g_g_y_. 
Release 6.3/04 wasn't too bad, but everything before that was very shaky
(crashing servers, corrupted data, etc.).

I just hope for your sake that it's available on your platform.

If you're going to stick with this version, then you might try doing
"set lock_trace" in both sessions to see what's happening, and also use
the "lockstat" command to get a snapshot of the locking system (good
luck in tracing through it--it's big and hairy).  I don't think IPM was
available in that version, but if it were, then that might help too.

The other thing you could try is doing this:

	set lockmode session where readlock = exclusive ;

This will prevent the session from escalating from an IX to an X lock. 
Right off the bat, the session grabs the lock it will eventually need
(or wait until it can get it).

--Mark Jaeger				internet: cs_mj@gsbvax.uchicago.edu
Graduate School of Business		yellnet:  (312) 702-0328
University of Chicago			faxnet:   (312) 702-0233
Disclaimer: My opinions are my own and not those of my employer.
Ich bin ein Virus.  Mach' mit und kopiere mich in Deine .signature.
Newsgroups: comp.databases.ingres