HDTenEightyP/NetNews huggingface dataset:
From: gnb@duke.bby.com.au (Gregory N. Bond)
Subject: Bug in esqlc connect stmt
Organization: Burdett, Buckeridge & Young, Melbourne, Australia
Date: Wed, 14 Oct 1992 03:55:05 GMT

[Ingres 6.4/02 Su4.u42/00]

I just spent most of a morning tracking down why the group membership
wasn't working on one of our applications.  It turns out that there is
a bug in the esqlc compiler that means it accepts invalid code when it
shouldn't. 

I had written
	exec sql connect :dbname with options = :opts;
This was accepted by esql and compiled and linked OK.  However, the
proper syntax is
	exec sql connect :dbname options = :opts;
(note the missing "with").

The first version was accepted by esqlc, and actually translated into
some II function calls, but the specified options were actually being
ignored.  Removing the "with" produced a different set of function
calls that actually worked as expected.

Grrrrr.

Greg.
--
Gregory Bond <gnb@bby.com.au> Burdett Buckeridge & Young Ltd Melbourne Australia
``USL has never sold long distance.  You're going after the wrong men in black 
  hats.  (Or, in the case of Plan 9, black space suits)'' - Tom Limoncelli
From: michel@cwi.nl (M.F.N de Boer)
Newsgroups: comp.databases.ingres
Subject: dbmsinfo() function
Date: 13 Oct 92 09:35:17 GMT
Organization: CWI, Amsterdam


Hi,

I'm assessing the performance of query evaluation
in Ingres. For this task I use the information
returned by the dbmsinfo() function. This function
returns a count for the number of direct and buffered
I/O requests. Can anybody tell me what exactly a direct
and buffered I/O request is.
Another thing I like to know is what the cost estimations
for Disk I/O and Cpu resources in a QEP mean. The cost
estimation for Disk I/O of a select-query approximately
equals the number of direct I/O's needed to evaluate that
query. But for a create table ... as select-query the
estimation is much higher than the number of direct I/O's.
Can anybody help me with this.

Thanks for any help,
Michel
Newsgroups: comp.databases.ingres
From: YODZIS@CDHF1.GSFC.NASA.GOV (JOHN YODZIS (310)286-5069)
Subject: INGRES mail list
Organization: National Radio Astronomy Observatory
Date: Wed, 7 Oct 1992 04:56:25 GMT

To whom it may concern,

     I've heard about the international INGRES mailing list and would like
to know how to get on to it.  Someone from my work gave me this address and
any information you could give me on it would be great.


Thank you,
John Yodzis
From: tdunbar@vttcf.cc.vt.edu (Thomas Dunbar)
Newsgroups: comp.databases.ingres
Subject: compat of free University Ingres 8.9 and Commercial INGRES
Date: 8 Oct 92 11:09:39 GMT
Organization: Virginia Tech, Blacksburg, VA


 i'm running the free University Ingres (v 8.9) on Linux (a free unixlike 
posix system) and wonder how compatible/similar it is to current 
commercial INGRES packages?
 thomas (tdunbar@vttcf.cc.vt.edu)
Newsgroups: comp.databases.ingres
From: sfc@tpghq.com (Steve Caswell)
Subject: Re: Help ......
Organization: Palmer & Associates, Inc.
Date: Sat, 10 Oct 1992 18:51:48 GMT

Using the tid is a dangerous thing to do, especially if you store it as data
in another table.  The problem is that if the row moves in the table, the
tid will be different, and your relation will no longer match the new tid in
the base table.  Rows can move for a variety of reasons, including primary key
update and rebuilding of the primary index (using the modify command).  You
would be well advised to find some other way of representing rows from the
two tables, such as a unique logical key value.  If there is no unique logical
key, you could add a surrogate key to each table and use the surrogate key of
each in your association table.

-- 

Steve Caswell           |   (404) 448-7727    |  "The opinions expressed are my
Principal Consultant    |   sfc@tpghq.com     |   own.  They may not be perfect,
The Palmer Group        |   uunet!tpghq!sfc   |   but they're all I've got."
From: perl@dwrsun4.UUCP (Robert Perlberg)
Newsgroups: comp.databases.ingres
Subject: Re: Access to iidbdb
Date: 13 Oct 92 21:36:36 GMT
Organization: Dean Witter Reynolds Inc., New York

In article <9210062149.AA04493@bear.cis.ohio-state.edu>, doug@news.cis.ohio-state.edu (Doug Kerr) writes:
> We have just started using Ingres on DECstations.  The documentation
> says that all information about the databases is stored in the iidbdb
> database, which is owned by the user $ingres.  However I am unable to
> access any of those tables even with ingres user privileges.  I can
> access the database, but am told it contains no tables.

Every database has tables called "system catalogs" which are left out
of the help listing, but you can still access them if you know their
names.  All of the tables in iidbdb are system catalogs so none of them
show up in the help listing.  You can list the system catalogs in any
database, including iidbdb, with:

	select table_name from iitables where system_use = 'S'

To modify a system catalog, besides the necessary privileges, you need
to invoke the terminal monitor with the "+U" flag.  Anyone can read the
catalogs.

Robert Perlberg
Dean Witter Reynolds Inc., New York
{murphy | philabs}!dwrsun4!perl
	-- "I am not a language ... I am a free man!"
Newsgroups: comp.databases.ingres
From: DELFT UNIV OF TECHNOLOGY/COMP CENTRE +31 15 784821 <Jan.vanSetten@RC.TUDelft.NL>
Subject: power failures
Organization: National Radio Astronomy Observatory
Date: Thu, 15 Oct 1992 11:06:34 GMT

Hi netters,

How do you think about protection of Ingres data servers against
power failures? Are you using UPS? How many risks, of not?
Thanks, Jan van Setten.
From: tio_on@tac.fi (Ossi Numminen)
Newsgroups: comp.databases.ingres
Subject: Lock_trace output to a file?
Date: 9 Oct 92 13:41:29 +0300
Organization: City of Tampere

I've got a problem with lock_trace output in our Ingres 6.3/03 (VAX/MVS).
How can I get it into a file?

I've got no problems with printqueries. If I say
  def ing_set "set printqry"
the resulting output is to sys$output, and if I say
  def ii_embed_set "set printqry"
the resulting output is to a file called iiprtqry.log

In the DBA guide it is said that ii_embed_set is similar to ing_set,
but diagnostic output is to a file, as can be seen above. Now, if I say
  def ing_set "set lock_trace"
I'll get the result on the normal way, but if I say
  def ii_embed_set "set lock_trace"
there are no resulting files.

So, any means to get lock_trace output to a file (in a way that end
users do not know what's going on there)?

*******************************
Ossi Numminen
City of Tampere
Dept. of Information Technology
P.O. Box 87
SF-33211 Tampere, Finland
e-mail: tio_on@tac.fi
fax:_-358-31-196044

Newsgroups: comp.databases.ingres
From: barr@hardy.u.washington.edu (David Barr)
Subject: selecting a few rows from huge table
Organization: University of Washington
Date: Fri, 9 Oct 1992 18:24:30 GMT

Here is a problem that I am working on:

At the hospital here, our users want to be able to scroll through the
patient database (which contains approximately 900,000 records) using
our ABF application.  They want to enter the first few letters of a
last name and have the matching names pop up in a table field.  Then
they also want to be able to scroll up and down from there (possibly
to names that don't match their original query).  The table field
should be in order by last name.

The problem is that selecting the entire table into a table field
takes much too long.

One possible solution that I thought of (maybe not a very good one) is
to have a separate table which acts as an index to the patient table.
The only fields which that table would contain are last name and index
number.  This table would contain only every hundredth record or so
(alphabetically).  When the user enters a string to search for, first
we would look it up in the index table, get the name which is closest
to what they entered and use the index number to find out the next and
previous entries in the index table.  This would give us a range for a
much smaller select on the patient table.  In addition, we would still
have the index numbers to get more records if they scrolled out of the
region we originally selected.

This seems like it would work to me, but I still have one question.
When I am selecting from my index table, what is the fastest way to
select a single row which is greater than or equal to a string
alphabetically?  I could use a select loop and only get the first
record.  Is there a faster way?

David
From: john@cutler.com (John E. Babbitt Jr.)
Newsgroups: comp.databases.ingres
Subject: Field Concatenation in RBF
Date: 13 Oct 92 22:10:18 GMT
Organization: Cutler & Company, Inc., Medford OR (503) 770-9000

Hello Ingres Users,

I'll like to generate a list of contact names using RBF.  Let's suppose
that I have three fields: first, middle, and last.  How do I print it on
one line, trimmed and separated by a single space?  For example, it is now
coming out as:

    John            E.          Babbitt, Jr.

and I couldn't find in the document on how to get it to come out as:

    John E. Babbitt, Jr.

I can do it in Report Writer, but I want to have it done in RBF, in a
non-programming way.  Thanks.

Regards,

John E. Babbitt, Jr.        {UUCP: ...hplabs!hp-pcd!orstcs!cutler!john}
Senior Programmer/Analyst   {Internet: john@cutler.com}
Cutler & Company, Inc.      {Phone: 503/770-9000 (voice) 503/770-9014 (tt)}
Medford, Oregon  97504      {Disclaimer: What I say is my personal opinion}
From: julie@cutler.com
Newsgroups: comp.databases.ingres
Subject: Possible bug using LIKE
Date: 9 Oct 92 02:15:09 GMT
Article-I.D.: cutler.1992Oct8.191509.304
Organization: Cutler & Company, Inc., Medford OR (503) 770-9000


	I was wondering if anybody has noticed the following (possible)
bug in Ingres.  We are running 6.3/03 (vax.vms/01) and VMS 5.2-2.

	I wrote a program over a year ago using embedded SQL in Pascal and
the following query used to work with the variable splitcusip being 
either '%' or '00814010 '. 

	SELECT cusip, sharesfactor, exdate, cusiprecieved
	FROM distributions
	WHERE event = 5 AND
	      ABS(sharesfactor) > .000001 AND
	      exdate = :splitdate AND
	      cusip LIKE :splitcusip
	ORDER BY cusip;


	There is no problem with the date, or when the variable splitcusip
is '%', but when I want to get an exact match for cusip (which is by the
way PACKED ARRAY [1..9] OF CHAR) it seems to be losing the last blank 
character in the cusip.  When this happens it can't find a match when one 
really exists.  

	I have tried using  cusip like NOTRIM(:splitcusip) , but when I
use this the case of splitcusip = '%' wont work.  I have also tried making
the variable splitcusip a VARYING [9] OF CHAR and have had the same results.

	Well?????? Does anybody have a clue what's going on?

						Julie Briggs
						Programmer/Analyst
						Cutler and Company Inc.
						Medford, Or
Newsgroups: comp.databases.ingres
From: Dawn Cappelli <dmc@SEI.CMU.EDU>
Subject: UNSUBSCRIBE
Organization: National Radio Astronomy Observatory
Date: Wed, 14 Oct 1992 12:56:11 GMT

Please unsubscribe me.
Xref: sparky comp.databases.ingres:1592 comp.unix.programmer:4950
From: perl@dwrsun4.UUCP (Robert Perlberg)
Newsgroups: comp.databases.ingres,comp.unix.programmer
Subject: Re: Catching division by zero
Date: 13 Oct 92 21:17:00 GMT
Organization: Dean Witter Reynolds Inc., New York

In article <1992Oct1.143522.1@gsbacd.uchicago.edu>, cs_mj@gsbacd.uchicago.edu (Mark Jaeger) writes:
> In article <1992Oct1.085857.5512@visionware.co.uk>, chris@visionware.co.uk 
> (Chris Davies) writes:
> > I'm using C with embedded SQL (Ingres 6.4/01 on Sun4 SunOS 4.1.2).
> > 
> > The problem I've got is that Ingres doesn't warn me when I get an
> > integer division by zero error in a SELECT statement, it just returns
> > 0.  (The floating point stuff returns 0.Inf - an IEEE representation of
> > infinity.  Yuk!)
> Why not just use the signal() call with SIGFPE?  Supposedly this signal
> is generated by arithmetic exceptions, such as divide by zero.

But if the divide is being done within the Ingres code which implements
the select loop, you could have trouble figuring out which row of the
select caused the exception.

I also don't think it would work since the divide is probably being
done in the DBMS server, not in your client process, so you can't trap
it.

Robert Perlberg
Dean Witter Reynolds Inc., New York
{murphy | philabs}!dwrsun4!perl
	-- "I am not a language ... I am a free man!"
Newsgroups: comp.databases.ingres
From: KAPETANAKIS@hra.cc.ucr.gr (UNV.OF CRETE (J.KAPETANAKIS))
Subject: Ingres info mailing list
Organization: National Radio Astronomy Observatory
Date: Wed, 14 Oct 1992 19:12:47 GMT

Please Write me at ingres information list.
My email address is kapetanakis@hra.cc.ucr.gr
thank's for everything
   John Kapetanakis (University Of Crete Presidendship)
From: keesh@cwi.nl (Kees van't Hoff)
Newsgroups: comp.databases.ingres
Subject: Ingres and /etc/passwd and NIS-entries
Date: 8 Oct 92 15:54:09 GMT
Organization: CWI, Amsterdam


Hi,

We are running Ingres 6.3 on SGI's under IRIX 4.0.1.
Now I have encountered the problem that when I have made an embdded program
(quel or sql), when executed, ingres seems to think my username is "nobody".
But applications made by abf(image) do not suffer from this problem.

According to Ingres folks this is because ingres looks whether /etc/passwd
exists and checks the username there, and only if /etc/passwd doesnot exist it
starts looking for a NIS entry.
BTW Our situation is of course that there exists a minimal /etc/passwd and
all the users are NIS entries. "nobody" is an entry in /etc/passwd.

This doesn't really make sense to me. 

Has anyone else encountered this problem?

Thanks in advance.
Kees.
-- 
Kees van 't Hoff, CWI, Amsterdam, the Netherlands.

keesh@cwi.nl
From: peper@hplvec.LVLD.HP.COM (Mike Peper)
Date: Tue, 13 Oct 1992 08:18:17 GMT
Subject: The Clipper 5.01 vs MS-DOS share feud
Organization: Hewlett-Packard Co., Loveland, CO
Newsgroups: comp.databases

I have a somewhat large Clipper 5.01 application that seems not to be
playing nicely with the MS-DOS 'share' utility.  Whenever share is
loaded, some of the databases are just not written to -- resulting in 
client data evaporating and with it my sense of humor.

There are lots of files open (FILES is set to 61), and setting share
up with lots of memory and up to 80 locks (I've tried less too) does
not help.

Anyone know what is going on here?  The code works great every time
with share not installed.

Thanks for any light you can shed on this problem...

--Mike

(P.S. the Clipper code does not issue any explicit LAN directives
like opening files EXCLUSIVE etc, since the manual claims this is
the default condition.  Am I supposed to anyway?)

Newsgroups: comp.databases
From: hsong%asylum.cs.utah.edu@cs.utah.edu (Hwal Song)
Subject: Q:Relational Report Writer(S/W)
Date: 13 Oct 92 15:56:54 MDT
Organization: University of Utah CS Dept
Distribution: usa

I have a question on software made by 'Concentric Data System Inc.'
This company produces a S/W named 'Relational Report Writer'.

 S/W named 'Relational Report Writer'.

Does anyone know the following information?:
- the latest version #
- any book or manual

Please send me an email if you know about this software.
Thank you in advance.
From: rjs@crs.cl.msu.edu (Robert J. Stanton)
Newsgroups: comp.databases
Subject: Data Integrity in Databases
Date: 16 Oct 92 15:46:59 GMT
Distribution: comp
Organization: Michigan State University

I am writing a database in which the information
in the database is very critical. (It is a medical
database).  

Because I ws a UNIX sysadmin in my previous jobs
and have seen numerous instances of file corruption
that was never caught by fsck, I am planning on
using a CRC to verify that the patient data that
I display on screen is the same as the data I received
when the info was written into the database.

Does anyone have knowledge of literature discussing
such a tactic?

I would be interested in any feedback that people
have about this.

rjs@crs.cl.msu.edu
From: exuptr@exu.ericsson.se (Patrick Taylor)
Newsgroups: comp.databases
Subject: Re: Gupta Client Server
Date: 7 Oct 92 14:56:33 GMT
Organization: Ericsson Network Systems, Inc.
X-Disclaimer: This article was posted by a user at Ericsson in North America.
              The opinions expressed are strictly those of the user and
              not necessarily those of Ericsson.

In article <1992Sep29.220138.8289@zip.eecs.umich.edu> srawson@quip.eecs.umich.edu (Stephen Rawson) writes:

>Yes, I have heard some very negative reports about Gupta's tech support.
>We'll see soon enough.  We bought the "Project Starter Kit" which includes
>telephone hot line support.  My experiences with the sales staff and
>others has been a bit disappointing.  There doesn't seem to be a lot
>of communication among the various branches of Gupta.

We, too, have the hot line support.  Now I call it the Chill Mill.  ;-)

>We have made contact with some very good consultants nearby who are
>"Gupta Partners" 

We are Gupta Partners.  Big, fat hairy deal ;-).  Can you tell I'm a
little down on these guys yet?

>and they should be able to help us out if things get
>too impossible (for a price, of course).  Gupta is not very nice to
>their Partners either.  They compete with them on software sales, play 
>one off against the other, etc.

Tell me about it.

 ----------------------------------------------------------------------------
 Looking for a new sig...

  - Patrick Taylor, Ericsson Network Systems
    exuptr@exu.ericsson.se                    "Don't let the .se fool you"
    exuptr@ZGNews.Lonestar.Org  <SLOW!>
From: mtitus@umsa.umd.edu (Marvin A. Titus)
Newsgroups: comp.databases
Subject: dBASE
Keywords: distributed database
Date: 16 Oct 92 18:46:38 GMT
Organization: USA University of Maryland System Administration

How does one disable the <Esc> key while running a program in dBASE?
Because I am not a frequent visiter to this group, please e-mail me a
reply.

Thanks, in advance.
From: jpennell@axion.bt.co.uk (John Pennell)
Newsgroups: comp.databases
Subject: Re: Clipper Windows Version
Date: 12 Oct 92 12:38:16 GMT
Reply-To: jpennell@axion.bt.co.uk (John Pennell)
Organization: British Telecom Research Labs



I'm not sure, but isn't ASPEN (clipper for windows?) been purchased outright by Computer Associates???

Jon
Newsgroups: comp.databases
From: steve@jack.sns.com (J. Steven Harrison)
Subject: Re: Client-Server Information Access Management
Organization: Systems'n'Software
Date: Tue, 13 Oct 92 00:30:04 GMT

In article <2927401359.3.p00058@psilink.com> "Ronald C. Schultz" <p00058@psilink.com> writes:
>I have been tasked with developing an architecture that will allow end 
>users to download 'information' from a 'data warehouse.'  The location 
>and access to the data will be hidden from the end user in a 'Data 
>Access Manager' or 'Rules Manager', while the semantics of the data will 
>be defined in a data dictionary.  Users will request information, (e.g., 
>estimated sales or production volume), which will be received by the 
>Rules Manager and interpreted.  Data will be gathered and procedures 
>executed under the Rules Manager guidance, and the 'information' will 
>then be delivered to the end user in some predefined forms (e.g., ASCII, 
>WKS, .XLS,...).  Does anyone know of a product, or suite of products, 
>that supports such an approach in a heterogeneous environment (multiple 
>hosts running numerous protocols with many types of databases executing, 
>as well as flat files).  In addition, I would be interested in 
>corresponding with anyone currently doing this.  I believe the DoD 
>embarked on a more sophisticated, but similar effort, a while ago called 
>CALS.  I would be interested in any pointers to this research also.  
>
>Thanx.
>
>------------------------------------------------------------------------------
>Ron Schultz 

Ron,

I would contact the folks at ITI for any help you could dream of needing.

Rick Cobb is especially good (510)438-2004


------
____*_  
\  / /  Independence Technologies   	Open Systems Transaction Processing
 \/ /   42705 Lawrence Place        	FAX:   (510) 438-2034
  \/    Fremont, CA 94538           	Voice: (510) 438-2011

I used to work there.


-- 
J. Steven Harrison, PhD.	steve@jack.sns.com
45034 Imnaha Court		Voice:	(510)623-8651
Fremont, CA   94539-6669	Data:	(510)623-8652
Systems'n'Software            	FAX:	(510)623-8656 
Xref: sparky comp.databases:7186 comp.misc:3964 comp.sys.ibm.pc.misc:13613
From: mikey@slic.cts.com (Mike Shirley)
Newsgroups: comp.databases,comp.misc,comp.sys.ibm.pc.misc
Subject: FOXPRO: Is there any E-mail servers or support?
Keywords: Foxpro Database ibm pc relational
Date: Mon, 12 Oct 92 19:52:51 PDT
Reply-To: mikey@slic.cts.com
Followup-To: comp.misc
Organization: Muth Valley Seismic Control District, San Diego, CA / Port2

I've looked around and haven't found an E-mail list for support
of FoxPro or Foxbase.  Do any exist?  If not, is anyone using
Foxpro and would like to join or start an E-Mail group on this
subject?


--
     Mike, WB6WUI   //   INET:  mikey@slic.cts.com   //   GEnie: SLIC
From: rpettrey@uoft02.utoledo.edu
Newsgroups: comp.databases
Subject: HEY! Copy of Dbase for sale!
Date: 13 Oct 92 20:30:57 EST
Reply-To: pettrey@ohio.gov
Keywords: sale, dbase
Distribution: world
Organization: University of Toledo, Computer Services

Hey, doesn't ANYBODY want a copy of Dbase IV, version 1.0?

Will someone either make me an offer, or e-mail me and tell me why I would be
foolish enough to think it is worth something?

Can't anyone use this?

Rob Pettrey
telephone	(419)244-3900 x 107
internet	pettrey@ohio.gov

-------------------------------------------------------------------------------
seen on the john wall		God is dead 		Nietzsche is dead
at Oberlin College:			- Nietzsche		- God
-------------------------------------------------------------------------------


Newsgroups: comp.databases
From: david@datamark.co.nz (David Rowland)
Subject: Re: Foxpro's Dev. Kit & Exe's
Date: Wed, 14 Oct 1992 19:50:26 GMT
Organization: Datamark International Ltd.

In article <Bw2r7B.A7G@acsu.buffalo.edu> v125qmam@ubvmsb.cc.buffalo.edu (Ami R Pflugrad) writes:
>
[Deleted Text]
>
>	one complaint though, is there anyway to avoid getting the
>	startup "credits", ie. "Foxpro Lan2.0/EXE Support Library"
>	and ends with the serial numbers.  I know its just a matter
>	of cosmetics, but its annoying.  Any way to avoid this?
>
Just switch it off!!!  There is an option on the Project menu which
gives you this option.  It is the option which also allows you to
enter Author and Product comment details.

-- 
| 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: nh@cbnewsg.cb.att.com (nicholas.hounsome)
Subject: grammar for SQL please
Organization: AT&T
Date: Thu, 8 Oct 1992 07:12:07 GMT

Does anyone have a grammar for SQL?

I have knocked up an interface to SQL which is pretty sophisticated
but it currently relies on strncmp to spot selects and a few other
commands which it treats specialy rather than just passing through - it
works but it is not very nice.

Nick Hounsome
Newsgroups: comp.databases.theory,comp.databases