HDTenEightyP/NetNews huggingface dataset:
From: cs_mj@gsbacd.uchicago.edu (Mark Jaeger)
Newsgroups: comp.databases.ingres
Subject: Re: Carriage Returns.
Date: 15 Oct 92 21:04:01 GMT

In article <12815@hardy.rl.ac.uk>, kml@wan.inf.rl.ac.uk (Kevin Lewis) writes:
> I have been asked a question by a prospective ingres user.
> 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

Yes.  The INGRES (ANSI) datatypes "char" and "varchar" will both accept
carriage returns and store them as part of the value in a column.

> b/ the bulk loading facilities in ingres ie, the 'copy'
>    command can be used to get the data in and out of files.

Yes, I think.  The "copy table" statement allows you to read and write
binary data (as opposed to text).  It's probably about the same level of
difficulty of writing FORTRAN code to deal with the same data.

> c/ the fields containing carriage returns can be displayed
>    sensibly in reports, application forms etc.

I'm not entirely sure.  I know that a simple field on a form in FRS with
a format like c200.20 will handle _newline_ characters (i.e., ^J) and do
the right thing, so I suspect that other parts of FRS might work.  I'm
not sure what it would do with carriage returns.  You'd have to try it.

> 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.

--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: tdunbar@vttcf.cc.vt.edu (Thomas Dunbar)
Newsgroups: comp.databases.ingres
Subject: Re: Ingres. What is it?
Date: 12 Oct 92 11:25:08 GMT
Organization: Virginia Tech, Blacksburg, VA


 yes, there is a commercial Ingres, but there is also a ftp version:
Ingres v 8.9, sometimes called University Ingres, i believe. the free
version has quel and the equel (quel to C preprocessor) interface. i
use the free version as the standard workstation db in our office. 
 i know nothing of the commercial version, i assume it's faster and has
various extra development gadgets. However, the free version has everything
i need given that one can write C programs to link with ingres. 
 thomas
From: salnick@dejavu.spk.wa.us (There is no substitute for displacement...)
Newsgroups: comp.databases.ingres
Subject: Re: Ingres 6.4/02 experience?
Date: 9 Oct 92 01:32:49 GMT
Organization: Not Organized

In article <1992Oct8.125054.22428@sei.cmu.edu> ask@sei.cmu.edu (Alan Koch) writes:
>
>We are contemplating upgrading from Ingres 6.4/01 to 6.4/02.  
>(We run Ingres on a Sun4.)
>
>If you have any experience with this new version (good OR bad), 
>please send me mail.

... thought this would be better as a posting...

I upgraded all 25 + of our Ingres nodes to 6.4/02 without difficulty, and 
have experienced no problems since the upgrade, nor during it when we 
were running cross-version connections.

We are a VMS shop, so I am not sure how germain this imnformation is to 
you ...

READ THE YELLOW SHEET THAT COMES WITH THE PACKAGE.  IIbuild.com is broken 
in this version, and the sheet tells what you need to do to fix it.

bob

--
RW Salnick, Spokane,WA  |  Home: salnick@dejavu.spk.wa.us
  Amiga 1000, WB 1.3    |  Work: mfgsys!salnick@kaiser.spk.wa.us
      WA9BVE            |
Newsgroups: comp.databases.ingres
From: mazzucch@ghost.dsi.unimi.it (massimo mazzucchi)
Subject: ClipperScanner
Keywords: info
Organization: Computer Science Dep. - Milan University
Date: Wed, 14 Oct 1992 12:14:24 GMT


Hi

I am a programmer with CLIPPER
i want know

- what is the library that permit to use image with scanner
  with clipper

  - what is the bbs where i can have to access to get
    this librAry


    Thanks for your help

    My address is mazzucch@ghost.sm.dsi.unimi.it


    Bye
From: vorwerk@mailhost.cs.utwente.nl (Manfred Vorwerk)
Subject: Re: dbmsinfo() function
Organization: University of Twente, Dept. of Computer Science
Date: Tue, 13 Oct 1992 16:32:11 GMT


Hello Michel,

Recently I've researched the optimizer of INGRES version 6.3/???.
During this research I've looked into the paramaters that are mentioned
the QEP (Query Execution Plan).

You're right when you say that the number x in the "Dx Cy" equals the
number of ESTIMATED direct IO's. This information is also contained in
the manuals of INGRES.
The number y in "Dx Cy' is more difficult. The INGRES-manuals state that
the number y is related to cpu-utilization.
In fact, and I've found this during my research, the number y is actually
the estimated number of tuple-comparisions for a given query divided by 100.

e.g.
Suppose there's a table containing 12000 tupels. 
Also suppose that there're NO secundairies.
The following query will be executed:
   SELECT *
   FROM table_1
   WHERE attr_1 = 'something';

This query will lead to a FTS (Full Table Scan), for each tuple the attribute
'attr_1' has to be compared to the string 'something'. So there will be 12000
comparisions. The actual number y should be 120. (12000 / 100)

It is possibly to change the factor (100) by changing a system_paramater.
I don't recall the name of this parameter, but if you need it I'll look it up
for you.

I hope that I've answered your question to your satisfaction.

If you have any more questions about the optimizer of INGRES, or some 
detailed information on the different storagestructures, you can email.

Greetings Manfred Vorwerk

Email : vorwerk@cs.utwente.nl
From: amandla@dcs.qmw.ac.uk (Jackie Saul)
Newsgroups: comp.databases.ingres
Subject: Tabbing on a read-only form?
Date: 9 Oct 92 12:39:52 GMT
Organization: Computer Science Dept, QMW, University of London

Can anyone enlighten me please. I have a form and have used the command
set_forms form (mode = 'read'); in my abf code.
However, when I do this the user can not tab between fields and they need to 
do this as the form is longer than the window size. Is there any way of making 
the form read only but also allowing tabbing/movement between fields?
Any help would be appreciated.
--
Jackie Saul

UUCP:      amandla@qmw-dcs.uucp  | Dept. of Computer Science
Internet:  amandla@dcs.qmw.ac.uk | Queen Mary & Westfield College
JANET:     amandla@uk.ac.qmw.dcs | University of London
Tel: +44(0)71 975 5250           | Mile End Road
Fax: +44(0)81 980 6533           | London E1 4NS
From: astinus+@pitt.edu (Mark E Porterfield)
Newsgroups: comp.databases.ingres
Subject: Re: Help abf
Keywords: abf
Date: 15 Oct 92 12:38:10 GMT
Organization: Pittsburgh Supercomputing Center
X-disclaimer: I said it...they didn't...any questions?

>In article <1992Oct14.104448.28191@dcs.qmw.ac.uk>, amandla@dcs.qmw.ac.uk 
>(Jackie Saul) writes:
>> 1. I have an abf application and have built an executable image. I only want 
>> my users to be able to access the database through the application and not to 
>> be able to change things in tables from other routes of access. Is there any 
>> way that I can set the access to the database to be only through the 
>> application?
>

Here's what we do...(we have a small userbase mind you - 50 users):
We utilize a DS5000/200 running ULTRIX and AFS.  When a user logs in we force
him to run his .login out on AFS (not local) and this in turn runs a setup
file giving access to the appropriate INGRES functions (QBF etc.) based on the
person.  We use a combination of alias and system protections and groups.  Not
to mention table permissions to insure data security.  As for ctrl C and others
try this.

                call system 'stty intr ""';
                call system 'stty susp ""';
                call system 'stty dsusp ""';

I am fairly sure this will keep people from willingly exiting non-gracefully.

-------------------------------------------------------------------------------
Mark E. Porterfield               INERNET: porterfi@psc.edu
ISA                               FLAMENET: /dev/null
Phg. Supercomputing Ctr.          The Buccos are still #1...Go Blue Jays!!!!
Newsgroups: comp.databases.ingres
From: grover@mighty-joe.isri.unlv.edu (Kevin Grover)
Subject: Re: Need help from SQL wizards out there!
Reply-To: grover@isri.unlv.edu
Organization: Information Science Research Institute (UNLV-ISRI)
Date: Thu, 15 Oct 92 20:58:39 GMT

In article <salnick.00f6@dejavu.spk.wa.us>, salnick@dejavu.spk.wa.us (There is no substitute for displacement...) writes:
) >
) >select BIO.SSNUM
) >from   BIO,EMP
) >where 	   BIO.SSNUM=EMP.SSNUM
) >      and  BIO.SSNUM not in (select DON.SSNUM
) >                             from   DON);
) >
) 
) This looks logical to me too.  Real Dumb Question:  are you sure that 
) there is data in DON, BIO and EMP which satisfies the criteria you are 
) posing?  In other workds, is it possible that an empty list is the 
) correct answer?
) 

Also, be weary of NULLable fields.  That tend to kill queries like
this.  I can remeber why, but I remember something similar happened to
me a while back...

--------------------------------------------------------------------------
 Kevin O. Grover      | UNLV Computer Science and Electrical Engineering
 grover@isri.unlv.edu | ISRI - Information Science Research Institute
 CServe: [73627,1677] | 4505 S. Maryland Parkway, Las Vegas NV 89154-1017
Newsgroups: comp.databases.ingres
From: alan@curta.cc.columbia.edu (Alan Crosswell)
Subject: Request for repost: looping in the optimizer
Organization: Columbia University
Date: Thu, 8 Oct 1992 15:14:31 GMT

A short while ago, there was a flurry of postings about known bugs in the
query optimizer where it would loop infinitely.  It had something to do with
optimizedb.  I know find that we are seeing this problem here and would
appreciate a repost of the problem and workarounds.  Thanks.
/a
Newsgroups: comp.databases.ingres
From: ghica@fig.citib.com (Renato Ghica)
Subject: Re: Access to iidbdb
Originator: ghica@duck
Organization: Citibank IBISM
Date: Wed, 7 Oct 1992 18:30:19 GMT


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.
|> 
|>  Douglas S. Kerr, Department of Computer and Information Science
|>  The Ohio State University; 2036 Neil Ave. Columbus OH USA 43210-1277
|>  doug@cis.ohio-state.edu                    614/292-1519

The system catalog tables are for use by the INGRES programs only.
The primary interface to some of this data is available via accessdb.
Ordinarily one has to create a user (add user), a adatabase (createdb)
and then a couple of tables (create table).

Not much more than that unless you're worried about auditing, recovery,
performance, integrity etc etc.

-- 

"I am a brain, Watson."
"These views are my own. / Mail me or Flame me"

Newsgroups: comp.databases.ingres
From: ricky@citr.uq.oz.au (Ricky Leung)
Subject: Re: Need help from SQL wizards out there!
Organization: Prentice Centre, University of Queensland
Date: Fri, 16 Oct 1992 03:27:15 GMT

adamsm@woods.ulowell.edu writes:

>I have a simple question for all you SQL wizards out there as I haven't the
>experience as yet to solve this problem.  I have three tables BIO,EMP,DON all
>indexed by unique social secutity number (SSNUM).  How can I select the records
>that are in BIO where there exists the same SSNUM in EMP but not include the
>records that have the same SSNUM in DON.  I tried:

>select BIO.SSNUM
>from   BIO,EMP
>where 	   BIO.SSNUM=EMP.SSNUM
>      and  BIO.SSNUM not in (select DON.SSNUM
>                             from   DON);

>This looks logial but dosn't seem to work as it always produces an empty list.

>help

>-Mike Adams (University of lowell, Massachusettes)
>                             
The direct translation of your requirement into SQL is:

select	SSNUM
from	BIO B
where	EXISTS (SELECT * FROM EMP
		WHERE SSNUM = B.SSNUM)
and NOT EXISTS (SELECT * FROM DON
		WHERE SSNUM = B.SSNUM)

--
Ricky Leung				    
Centre for Information Technology Research   Phone: +61 7 365-4321
The University of Queensland		     Fax:   +61 7 365-4399
Queensland  4072, Australia		     Email: ricky@citr.uq.oz.au
From: arzt@dccs.upenn.edu (Noam H. Arzt)
Newsgroups: comp.databases.ingres
Subject: Re: Windows4GL 2.0
Date: 9 Oct 92 13:41:13 GMT
Distribution: usa

In article <1992Oct6.223427.1419@sierras.com> dhubb@sierras.com (David Hubbell)  
writes:
> Ingres has announced Windows4GL Version 2.0.  Does anybody know what the
> expected _ship_ date is?
> -- 

I can confirm delivery to my site of Windows/4GL 2.0 under VMS, SunOS, and I  
expect imminent delivery under DEC/Ultrix.

--
Mr. Noam Arzt                            215/898-3029 (voice)
Director, Special Projects               215/898-9348 (FAX)
University of Pennsylvania               arzt@dccs.upenn.edu
Data Communications & Computing Services (NeXTmail is OK)
Suite 221A, 3401 Walnut Street, Philadelphia, PA 19104
From: rolinger@staff.tc.umn.edu
Newsgroups: comp.databases.ingres
Subject: Re: Access to iidbdb
Date: 16 Oct 92 05:34:15 GMT
Organization: University of Minnesota

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.
>

If you access the iidbdb with the username $ingres, you can get alittle
more info from the tables and (shudder) modify them.  I can't think of
an reason to modify them, but what the hell.  Live Dangerously!!!

To access as the user $ingres, use the -u qualifier from the sql 
command line.  You will probably have to escape the $ sign since sh or csh
will try to interpret it.

sql -u\$ingres +U iidbdb   #this should get you in.

Use at your own risk.

Randy
-- 
Opinions expressed are not necessarily my own.  They are probably those of
my employer, educational institution, broadcasting network, or the stockholders
thereof.   So there.
From: salnick@dejavu.spk.wa.us (There is no substitute for displacement...)
Newsgroups: comp.databases.ingres
Subject: Re: Need help from SQL wizards out there!
Date: 15 Oct 92 12:47:52 GMT
Organization: Not Organized

In article <1992Oct14.170643.1@woods.ulowell.edu> adamsm@woods.ulowell.edu writes:
>I have a simple question for all you SQL wizards out there as I haven't the
>experience as yet to solve this problem.  I have three tables BIO,EMP,DON all
>indexed by unique social secutity number (SSNUM).  How can I select the records
>that are in BIO where there exists the same SSNUM in EMP but not include the
>records that have the same SSNUM in DON.  I tried:
>
>select BIO.SSNUM
>from   BIO,EMP
>where 	   BIO.SSNUM=EMP.SSNUM
>      and  BIO.SSNUM not in (select DON.SSNUM
>                             from   DON);
>
>This looks logial but dosn't seem to work as it always produces an empty list.

Mike -

This looks logical to me too.  Real Dumb Question:  are you sure that 
there is data in DON, BIO and EMP which satisfies the criteria you are 
posing?  In other workds, is it possible that an empty list is the 
correct answer?

bob
--
RW Salnick, Spokane,WA  |  Home: salnick@dejavu.spk.wa.us
  Amiga 1000, WB 1.3    |  Work: mfgsys!salnick@kaiser.spk.wa.us
      WA9BVE            |
Newsgroups: comp.databases.ingres
From: janw@fwi.uva.nl (Jan Wortelboer)
Subject: Re: Need help from SQL wizards out there!
Organization: FWI, University of Amsterdam
Date: Thu, 15 Oct 1992 07:48:07 GMT

adamsm@woods.ulowell.edu writes:

>I have a simple question for all you SQL wizards out there as I haven't the
>experience as yet to solve this problem.  I have three tables BIO,EMP,DON all
>indexed by unique social secutity number (SSNUM).  How can I select the records
>that are in BIO where there exists the same SSNUM in EMP but not include the
>records that have the same SSNUM in DON.  I tried:

>select BIO.SSNUM
>from   BIO,EMP
>where 	   BIO.SSNUM=EMP.SSNUM
>      and  BIO.SSNUM not in (select DON.SSNUM
>                             from   DON);

>This looks logial but dosn't seem to work as it always produces an empty list.

I can't see why, but when it would work it's still is a
extensive query..


I would try something like

select BIO.SSNUM from   BIO,EMP where     BIO.SSNUM=EMP.SSNUM
minus 
       select SSNUM from DON

jan.
        

P.S. We don't work with sql, so i didn't had a manual to check..
-- 
Jan Wortelboer,  University of Amsterdam
                 Computer Science Department  Email: janw@fwi.uva.nl
Unix             Kruislaan 403 Kamer F003     Phone: +31 20 525 7501
systems manager  1098 SJ AMSTERDAM            Fax  : +31 20 525 7490
Newsgroups: comp.databases.ingres
From: sethg@dcatlas.dot.gov (Seth Grimes)
Subject: Re: Ingres. What is it?
Organization: U.S Dept. of Transportation
Date: Mon, 12 Oct 1992 00:54:22 GMT

jremer@ub.d.umn.edu (Jeremy Remer) writes:

>Is there a FAQ telling exectly what Ingres is, what it does, how it works,
>ect.?

>All I know, at this point, is that Ingres is a database, of some kind.  I
>would be interested in learning Ingres possibly and would like to also know
>of any ftp sites that have a tutorial (under PC DOS or Unix fine)  that could
>help me out.

>All the input I can get would be a great.  

>Jeremy

Ingres is a commercial product.  Call the company and ask for brochures.
1-800-4-ingres is the number.  If your school has a license, I'd also 
guess that you have documentation.
Newsgroups: comp.databases.ingres
From: thomasl@mtl.mit.edu (Thomas J Lohman)
Subject: Adding new users 
Organization: MIT Microsystems Technology Laboratories
Distribution: usa
Date: Wed, 7 Oct 1992 18:51:32 GMT

I'm currently updating a program which we have used to add new users
to our system, which includes adding them as Ingres users.  It appears
the Ingres part dies now, most likely due to the upgrade into 6.3/6.4
territory.  

What I was wondering, does anyone know the most straightforward way to 
add Ingres users through a C program?  Is it possible?  If so, is it
anywhere in the documentation?  If it isn't possible, then is accessdb
the only way to add users to Ingres?

thanks for any information,


--tom


Newsgroups: comp.databases.ingres
From: sethg@dcatlas.dot.gov (Seth Grimes)
Subject: Re: Windows4GL 2.0
Organization: U.S Dept. of Transportation
Distribution: usa
Date: Wed, 7 Oct 1992 13:17:38 GMT

dhubb@sierras.com (David Hubbell) writes:

>Ingres has announced Windows4GL Version 2.0.  Does anybody know what the
>expected _ship_ date is?

No, but it should be noted that this announcement is just for Unix/X and
not for Microsoft Windows.

Seth Grimes, dcatlas!sethg@uunet.uu.net
From: cs_mj@gsbacd.uchicago.edu (Mark Jaeger)
Newsgroups: comp.databases.ingres
Subject: Re: dbmsinfo() function
Date: 14 Oct 92 22:12:39 GMT
Article-I.D.: gsbacd.1992Oct14.161239.1

In article <1992Oct14.152729.29070@u.washington.edu>,
ingersol@stein.u.washington.edu (Steve Ingersoll) writes:
> In article <7548@charon.cwi.nl> michel@cwi.nl (M.F.N de Boer) writes:
>>...
>>Can anybody tell me what exactly a direct
>>and buffered I/O request is.
>
> ...
> Dbmsinfo(_dio_cnt) will return the number of direct i/o requests that the DBMS
> makes; not the actual direct i/os which are completed.  ^^^^^^^^
> Each time the DBMS  queues an i/o request (QIO) we increment a
> counter.  It is this counter which is read for the _dio_cnt value.
> _Dio_cnt is not a good means to track the number of completed direct i/os,
> to do this you would need to rely on vms tracking or io_trace.
>
> 	I then asked Ingres to explain how a direct I/O request can not
> actually do an I/O operation. They have not responded to this as of yet
> (its been 2 weeks since I made the call).

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.
Newsgroups: comp.databases.ingres
From: gfowler@javelin.sim.es.com (Gary Fowler)
Subject: termcap vs terminfo
Organization: Evans & Sutherland Computer Corporation
Date: Fri, 16 Oct 1992 18:55:50 GMT

Is there any way to get Ingres 5 or 6 to look at the terminfo database
instead of it's private termcap file?  I thought termcap was supposed
to be going away in UNIX.

********************************************************************************
*     Gary Fowler                     *     The storm starts when the drops    *
*     gfowler@esunix.sim.es.com       *     start dropping.  When the drops    *
*     Evans & Sutherland              *     stop dropping then the storm       *
*     600 Komas Drive                 *     starts stopping.                   *
*     Salt Lake City, UT              *     -Dr. Seuss                         *
********************************************************************************
From: robm@ataraxia.Berkeley.EDU (Rob McNicholas)
Newsgroups: comp.databases.ingres
Subject: help with: "E_US0C1C Query requires too many range variables."
Date: 15 Oct 92 17:06:13
Organization: Technical and Computing Services, U.C. Berkeley, Berkeley, CA
Distribution: world
NNTP-Posting-Host: ataraxia.berkeley.edu

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.  I'd really rather not redesign my database
right now, and I'd rather not play games with incrementally building
temporary tables.  So, I ask you all:

Is there a server option I can set that will allow more range
variables?  I tried increasing the optimizer's memory, but that didn't
help.

[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.]

Thanks for any suggestions,

-Rob
--
Rob McNicholas		    Technical & Computing Services, EECS, U.C. Berkeley
robm@eecs.berkeley.edu	    Voice: 510/642-8633  FAX: 510/643-7846
Newsgroups: comp.databases.ingres