HDTenEightyP/NetNews huggingface dataset:
From: wjanis@biostats.hmc.psu.edu (Wayne Janis)
Subject: Passing table field rows to an ABF frame
Organization: National Radio Astronomy Observatory
Date: Fri, 24 Jul 1992 13:28:45 GMT


We are running INGRES 6.4 on a Sun.  I have a tablefield defined in an
ABF application frame which I pass to another frame like this:
	callframe modproc (modproc := emptable.all);
Emptable has two fields, empnum and empname.  The called frame
"modproc" has two simple fields also called empnum and empname.  I
would like the user to simply be able to change those fields.  However,
if the fields are changed, when the user returns to the calling frame,
the table fields HAVE NOT CHANGED.  I can't figure out what I'm doing
wrong.  The manual says that I'm passing the table field row by
reference, so you'd think that it would be changed.

What gives here?  Please E-mail me directly; I'm not on this list.

	Wayne Janis (wjanis@biostats.hmc.psu.edu)
	Hershey Medical Center
	Hershey, PA 17033
Newsgroups: comp.databases.ingres
From: Gavin Trigg <gavin@asis.unimelb.EDU.AU>
Subject: Re: Q: nested group by
Organization: National Radio Astronomy Observatory
Date: Tue, 21 Jul 1992 22:27:02 GMT

Stephen,

There were a number of problems with views and group by in 6.3.  A lot were
fixed in 6.4 but some new ones were created.  We discovered one recently!

We've been getting around the problem by using tables rather than views.  Use
of SAVE and VERIFYDB may help with cleaning up of old temporary tables.

What you have is an Ingres bug.  Although you might not get a patch because you
don't have Technical Support you should at least report the problem so that
Ingres can address it and fix it in a future release.

-- 
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.ingres
From: leath@atlas.cs.upei.ca (Stephen Leath)
Subject: Re: Natural Language users?
Organization: University of Prince Edward Island
Date: Tue, 21 Jul 1992 12:07:32 GMT

In article <1992Jul17.114412.5036@dcatlas.dot.gov> sethg@dcatlas.dot.gov (Seth Grimes) writes:
>jm5h+@andrew.cmu.edu (Joyce Moore) writes:
>
>>Is anyone out there using Natural Language (users ask questions in
>>English and NL writes and executes SQL to get the answers from your
>>relational database)?  We don't have any specific problems or questions,
>>but would like to know if there is a forum like this available.
>
>Yes, the Federal Aviation Administration, which I support as a contractor,
>uses Natural Language on a DECSystem 5100 against Ingres databases on a
>VAXcluster.  The networking link is made by running Ingres/Net over 
>DECnet between the DECSystem and the VAXcluster.  We do not have any
>Ingres products except Ingres/Net (except something we don't use -- the
>run-time Ultix SQL (Ingres) that is bundled with  Ultrix) on the DECSystem;
>with Ingres/Net you do get the SQL terminal monitor and can send SQL
>queries to your database servers elsewhere.
>
>Seth Grimes, Automated Sciences Group (U.S. Dept. of Transportation)

You don't mention which natural language product you use. We have been
searching for a NL product which would run on a PC and parse freeform
english language and querry an Ingress and or Oracle database. We
thought our search was over about a year ago when we came across NLQ a NL
product designed by Battelle a non profit scientific organization, they
were selling it for $200 per PC. The beauty of the product was that it did
not not have a VAX part it just ran on the PC and querried the database on
the VAX. It allowed the user to enter a a freeform english language querry
and if it did not totally understand (which seemed hard to do) it would
querry the user to understand the querry and in this way it would build a
thesaurus type dictionary of synonyms to understand future querries. The
problem, however was that they were not up to ingres version 6 at the time,
then they decided to sell the product rights and as yet it is still in limbo.

Steve Leath, UPEI Computer Services.

Newsgroups: comp.databases.ingres
From: salnick@dejavu.spk.wa.us (There is no substitute for displacement...)
Newsgroups: comp.databases.ingres
Subject: Re: What will ingres run on ?
Date: 23 Jul 92 05:52:55 GMT
Distribution: comp.databases.ingres
Organization: Not Organized

In article <1992Jul22.100205.13112@msuinfo.cl.msu.edu> rjs@crs.cl.msu.edu (Robert J. Stanton) writes:
>I have been looking for a database that will run on SCO UNIX,
>which is most like SysV.  Does ingres run on anything other than
>a VAX ?
>
>rjs@crs.cl.msu.edu

It used to SHIP with SCO (but doesn't now, I understand).  Ingres runs on 
all KINDS of systems, including Vax running VMS and VAX running Ultrix.  
Ask your local sales person for more info...

bob
--
Bob 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: adamsm@woods.ulowell.edu
Subject: ABF/VIFRED How to expand field length?
Organization: University of Lowell
Date: Thu, 23 Jul 1992 17:48:59 GMT

HELP!!  I'm running Ingres 5.0 under VMS 6.3 and have encountered a problem
with ABF that I just cant seem to shake.  A previous version of our database
used the fields STREET1 and STREET2, both being of type C22.  After
demonstrating that this length was not enough, we upgrade the referencing
table and screen to type C32, allowing us 10 more spaces in the street fields. 
All appeared well when saving the Vifred screen after being altered to reflect
the changed street fields.  The new table was created, with respective changes,
and the old data moved into it.  The new table was checked through QFB that it
could indeed hold street lengths of C32.  The whole thing compiled without a
problem and appreared to work as flawlessly as before.  The only hitch was that
the VIFRED screen, showing that it was changed to allow C32 street names, when
the application was accually run, would allow all 32 to be entered but would
only update as if it were only C22 long (It would accually overwrite the
following city fields with the 10 character overflow).  Except for this
problem, the entire application works normally.  The previous table was deleted
and I have verified that the one referenced actually contains the C32 fields
(verified by QBF updates).  The frame code has been recompiled although it has
no reference in the code to field length.  All I can think of is that there is
some code in the application that is not being updated.  I've changed and
verified the table, the frame code, and the VIFRED screen.  What else is
there?  Maybe I could do a force compile of the entire application to update
any stray code that is not being changed, but I don't yet know how to do this?
Anyone out there have any ideas?  Even guesses are appreciated at this point.
I thank you in advance for any help rendered as this seemingly simple change
dosnt seen so simple any more....

   -- Michael Adams (U Lowell, Alumni Database Ingres Programmer)
 
Newsgroups: comp.databases.ingres
From: horn@schaefer.math.wisc.edu (Jeffrey Horn)
Subject: Too much detail reported in ABF "Go"
Organization: Univ. of Wisconsin Dept. of Mathematics
Date: Thu, 30 Jul 92 18:30:48 GMT

Generally, I think that the amount of detail reported by ABF after one
hits "Go" is much better than it used to be.  However, I often work remotely
from sites in the middle of nowhere (I work for an Agricultural company).
The highest communications speed I can get is 9600 baud, and sometimes as
bad as 2400 baud.  When I am working remotely, the detail reported really 
gets in the way.  The compilation would only a few seconds if done by
itself, but since ABF has to report every frame, procedure, etc. whether
changes have been made to it or not, the communication makes the compilation
take minutes.  I would like it if ABF would either:

   - Report compilation events only for files that have changed since
     the last compilation

   - Report only compilation events that result in errors/warnings.

Is there any way to make ABF behave this way?

Jeff Horn
Newsgroups: comp.databases.ingres
From: RASCH@C-H.BWH.HARVARD.EDU
Subject: Is there an appropriate job hunt forum?
Organization: National Radio Astronomy Observatory
Date: Sat, 25 Jul 1992 00:05:59 GMT

Does anyone on this list know any listing of Ingres-related job postings?  I 
seem to live in a part of the US (Mass.) that doesn't have a lot of Ingres 
sites. 

It's probably best to reply to me privately, but I will relay info to anyone 
interested.

Thanks   Joan Rasch   Rasch@c-h.bwh.harvard.edu
Newsgroups: comp.databases.ingres
From: sfc%tpghq@uunet.UU.NET (Steve Caswell)
Subject: Re: one rule or many???
Organization: National Radio Astronomy Observatory
Date: Tue, 28 Jul 1992 20:56:11 GMT

> 
> From: horn@schaefer.math.wisc.edu (Jeffrey Horn)
> Subject: One rule or many???
> 
> Suppose that you want to use rules to implement two or more foreign-key
> checks on columns in a table.  Say columns a, b, c, ... of table X.  
> Is it better to implement one large rule that checks all the constraints, 
> or many small rules that each check one constraint?  That is should one
> have one rule
> 
> create rule Xkahuna after update of X execute procedrue Xbigproc;
> 
> or many rules
> 
> create rule Xa after update of X(a) execute procedure Xaproc;
> create rule Xb after update of X(b) execute procedure Xbproc;
> .
> .
> .
> 
> If there is no "best" method, what are the advantages of each method?  What
> about if one is running on a parallel architechture?
> 
> Thanks for your input, 
> 
> Jeffrey Horn
> 
> 
We have done this by implementing one rule and checking within the procedure
to decide which columns have changed.  This requires us to pass in 48 arguments
to the rule, but this does not seem to be excessive.  I don't know if there is
a limit to the number of arguments that can be passed in.

One factor in your decision making is that INGRES caches rules and procedures
into the Query Storage Facility cache, so that it doesn't need to go back and
read the rule/procedure from disk every time it is executed.  When INGRES
first brings in the procedure, it looks for a chunk of QSF memory large enough
to hold the procedure.  If it cannot find a chunk of memory, it kicks out a
least recently used query (I would guess another procedure or a repeated query).
Smaller procedures would have a better chance of fitting into the QSF if they
were being brought in after holes had been created in memory.  On the other
hand, one large procedure would be less likely to be kicked out of the cache
by another query if were being accessed frequently (calling one procedure many
times would avoid the least recently used algorithm).  If you have lots of
memory and can allocate it to the QSF then these issues are moot.

I'd be interested to hear from you what method you choose and how it works out
(either here on the group or in an e-mail).

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."
Newsgroups: comp.databases.ingres
From: sfc%tpghq@uunet.UU.NET (Steve Caswell)
Subject: problem posting to the newsgroup
Organization: National Radio Astronomy Observatory
Date: Tue, 28 Jul 1992 20:59:37 GMT

I posted this query a few months back, but I have not been able to work out the
problem yet, so I'll give it another try.

I am using the readnews to read news.  When I try to post to the newsgroup from
the readnews reader, the posting never gets to the group.  This and other
postings are being sent via e-mail to info-ingres.  I would like very much to
post directly from readnews (you would groan at the gyrations I go through now).
Can anyone tell me where to go looking for the problem?  I don't speak much
unix so directions need to be explicit.

Thanks in advance for assistance.


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: jm5h+@andrew.cmu.edu (Joyce Moore)
Newsgroups: comp.databases.ingres
Subject: Re: Natural Language users?
Date: 27 Jul 92 05:30:30 GMT
Article-I.D.: andrew.weQzdqa00Uh781g65G
	<1992Jul23.120955.18591@dcatlas.dot.gov>
Organization: Administrative Systems, Carnegie Mellon, Pittsburgh, PA

Natural Language, from Natural Language Inc., is the same product
Carnegie Mellon University is using for the Development/Alumni Ingres
database.

Joyce
From: rjs@crs.cl.msu.edu (Robert J. Stanton)
Newsgroups: comp.databases.ingres
Subject: What will ingres run on ?
Date: 22 Jul 92 10:02:05 GMT
Distribution: comp.databases.ingres
Organization: Michigan State University

I have been looking for a database that will run on SCO UNIX,
which is most like SysV.  Does ingres run on anything other than
a VAX ?

rjs@crs.cl.msu.edu
From: bouton@gertrude.cms.udel.edu (Katherine Bouton)
Newsgroups: comp.databases.ingres
Subject: vision application defaults
Date: 23 Jul 92 13:26:26 GMT
Reply-To: bouton@gertrude.cms.udel.edu
Organization: U of Delaware, College of Marine Studies / Lewes

We are developing an application in VISION and want to rename the keys e.g TopFrame=MainMenu.
How do we do this for the whole application at once without going into each osq?
Also... how do we make List Choices menu item come up on a frame ONLY when there is
a list choices option? I hate hiting listChoices to get that error message - sorry, no list choices,
field-c20 etc...
thanks
Katherine
Newsgroups: comp.databases.ingres,comp.dcom.lans.ethernet
From: doc@magna.com (Matthew J. D'Errico)
Subject: INGRES/Net DLL's ??
Organization: Magna Software Corporation
Date: Thu, 23 Jul 1992 21:47:28 GMT

I'm trying to run the sample program which comes with the INGRES/NET
Windows supplemental disks on a TCP/IP LanManager LAN...

Running from DOS, I set the NETU "protocol" to TCP-LMX, and everything
works just fine and dandy...  Running under Windows, it tells me
that the "iilmx.dll" is not present (which it isn't)...  The only
DLL that was there was the "iiwol.dll", so I tried that and it tells
me that the "sock???.dll" (I forgot the exact file name) is missing...

When I tried to check the INGRES BBS, the phones don't answer...

Does anyone know where to obtain these missing .DLL's ?
 (or does anyone have any other ideas ?)...

Thanx !

-- Doc
+-------------------------------+---------------------------------------+
|    Matthew J. D'Errico	| DOMAIN:	mderrico@magna.com	|
| Magna Software Corporation	| uucp:		uunet!magna!mderrico	|
|     275 Seventh Avenue	| CompuServe:	70744,3405		|
|	 20th Floor		+---------------------------------------+
|    New York, NY   10001	|	Voice	: 212 / 727 - 6737	|
|	    USA			|	Fax	: 212 / 691 - 1968	|
+-------------------------------+---------------------------------------+
Newsgroups: comp.databases.ingres
From: r mistry <mistry@leicester-poly.ac.uk> (med sys)
Subject: Ingres Windows4GL - Tolerencing Mouse Clicks
Organization: National Radio Astronomy Observatory
Date: Tue, 21 Jul 1992 14:07:47 GMT

I have the following problem when using Ingres-Windows4GL with Ingres v6.3
on HP 9000/700 Workstations

Outline : I am using an Imagefield in a windows form into which is loaded
          an image from the unix filesystem.
          (The image is not stored in Ingres)
          - The image is in SUN raster format,
            is 256x256 pixels and greyscaled.

I have a script associated with the imagefield which is activated each time
the mouse is clicked in the image field.

What I want to do now is to read the mouse position when the button was clicked,
place an 'X' at that point, and redisplay the image.

Problem (1).
  I cannot perform this in straight Ingres because Windows4GL places the
  image in the 'foreground' and any drawn attributes in the background, so
  they cannot be seen.
  ... What I do to try to get around this is to edit the sun raster file
      and physically put an 'X' in and then reload and redisplay the image.

  Unfortunately ... I can't read the mouse position accurately enough, and
  convert it to pixels rather than in thousands of an inch or whatever Ingres
  returns in the Curframe.XStart and Curframe.YStart variables.

(2)
  I physically set the size of the imagefield (in the script) to 2560x2560 by
  setting the width and height attributes of the imagefield, but when I read
  back the points I get when clicking in the TopLeft and BottomRight corners of
  the image field I get (22,88) - TopLeft, and (2516,2588) - BottomRight.
  In addition when I check FIELD().Width and Height I get Width = 2560, and
  Height = 2555, wheras I have set them previously to 2560x2560, also I have
  set the Imagefield to resize the image (width and height) to fit the field.

The outcome of these problems is that the 'X' is not placed at the position
where the mouse was clicked, this is important because subsequently I want to
be able to click on the 'X' and store information in Ingres spacifically about
that point on the image.

Can anybody Help ???

-------------------------------------------------------------------------
   Rajesh Mistry                            Email:  mistry@leicp.ac.uk
   Computing and Mathematical Sciences Research Unit,
   De Montfort University,
   The Gateway,
   Leicester, LE1 9BH,
   England.
-------------------------------------------------------------------------
Newsgroups: comp.databases.ingres
From: alan@curta.cc.columbia.edu (Alan Crosswell)
Subject: Re: Control of Ingres software development on unix
Organization: Columbia University
Date: Wed, 29 Jul 1992 20:46:08 GMT

In article <12375@ecs.soton.ac.uk> mk@ecs.soton.ac.uk (Mike Kellaway)  
writes:
> 
> CONTROL OF INGRES SOFTWARE DEVELOPMENT ON UNIX
> 
> We have to develop our applications on the same unix box as
> we run them live.
> 
> What we are looking for is the best way of setting up the live and
> development environments so that it is easy to control the development
> environment and to move a new version to live.
> 
> Source code control can only cover part of an application. e.g. not
> forms control.    Also we seem to be forced to use absolute pathnames.
> e.g. help files.
> 
> We have tried using different database names and owners for live and
> development but this causes problems,.
> 
> How do other people do it?
> Recommended reading and suggestions welcome.
> 
> Mike Kellaway
>                  JANET           mmk@uk.ac.soton.mail
>                  EARN/BITNET     mmk@mail.soton.ac.uk
> FULL INTERNET ADDRESS      mmk%mail.soton.ac.uk@nfsnet-relay.ac.uk

Usually we are out of control and just put up new stuff on the live
system and then take advantage of auditdb to repair our mistakes:-).
But, in those rare moments when we are in control, we use separate  
databases and all our programs take the dbname as an optional argument.
Then we use copydb, copyform, unloaddb or whatever to move stuff from
the test to live database.  Absolute pathnames are a problem, usually
solved by not using those pieces of ingres that require them.  One of
our apps has the names of all programs it execs in a table itself, so
that putting up a test version of a subprogram is a simple matter of
a table change.  Another unix trick for quel/sql scripts is to use 
Unix "here documents" to rewrite the absolute pathnames used by stuff
like copy:

#!/bin/sh
wd=`pwd`
ingres foodb <<XXX
copy abc() from "$pwd/abc.xxx"\\p\\g
XXX

Also, in the past, we've been able to trick parts of ingres with relative
pathnames, but only parts.  For example, we did a
	ingsetenv ING_ABFDIR ./abf
So ABF would use the abf subdirectory under the current connected 
directory rather than the global and world-writable ~ingres/abf. I'm
not sure if this trick still works under 6.x (we used it under 5).

Another trick that occurs to me that would be difficult to set up but
might be worth it is to use the chroot(2) system call so that even
absolute pathnames can be made to point elsewhere.  Using chroot is
trickey though as you have to make sure you can still get to all the other
stuff you need.  Perhaps chroot'ing production and having development
under the real root would be a reasonable thing since presumably the
production environment is more limited (e.g. not needing access to all
the Unix commands, etc.).
/a
Newsgroups: comp.databases.ingres
From: sethg@dcatlas.dot.gov (Seth Grimes)
Subject: Re: Is there an appropriate job hunt forum?
Organization: U.S Dept. of Transportation
Date: Sat, 25 Jul 1992 17:24:51 GMT

RASCH@C-H.BWH.HARVARD.EDU writes:

>Does anyone on this list know any listing of Ingres-related job postings?  I 
>seem to live in a part of the US (Mass.) that doesn't have a lot of Ingres 
>sites. 

>It's probably best to reply to me privately, but I will relay info to anyone 
>interested.

>Thanks   Joan Rasch   Rasch@c-h.bwh.harvard.edu

I, personally, think that comp.databases.ingres is a fine place for job
postings, although I'd rather be spared job requests and resumes.  There's
also Usenet's misc.jobs.offered and misc.jobs.resumes. 

You could also try your local Ingres Users' Group if you're looking for a 
job -- try asking others there, that is.  Plus, I know of at least 2 headhunters
who specialize in Ingres and other DBMSes (although headhunters don't usually
deal with entry level people); e-mail me at dcatlas!sethg@uunet.uu.net if you
want contact info.

			Seth Grimes
From: klkarp@remus.rutgers.edu (klk)
Newsgroups: comp.databases.ingres
Subject: images
Date: 29 Jul 92 21:50:27 GMT
Organization: Rutgers Univ., New Brunswick, N.J.


Does anyone know how to create images -- that is executable
applications?

I keep getting linking errors when I try.

Please send any suggestions to klkarp@remus.rutgers.edu

Thanks
From: kerry@Ingres.COM (Kerry Kurasaki)
Newsgroups: comp.databases.ingres
Subject: Re: Sorting on multiple locations ?
Date: 24 Jul 92 16:53:08 GMT
Reply-To: kerry@Ingres.COM (Kerry Kurasaki)
Organization: Ask Computer Systems Inc., Ingres Division, Alameda CA 94501

In article <1992Jul24.162411.22586@jupiter.sun.csd.unb.ca> leath@atlas.cs.upei.ca (Stephen Leath) writes:
>We are trying to setup ingres so that sorts will sort over multiple
>locations, but, have had no luck so far. We having trouble understanding
>the use and setting of the ingres logical II_WORKDIR_XX_NN. Has anyone
>accomplished this and if so, is there anything else to do besides setting
>the logical ?
>

The "XX" in the WORKDIR logical is the installation id and is
case sensitive.  e.g. if II_INSTALLATION is set to "pk", then you
want to set II_WORKDIR_pk_1, II_WORKDIR_pk_2, etc.

The WORKDIR variable need to be pointed to the top of an INGRES tree.
On UNIX, this will look like:  .../ingres/work/default

The II_WORKDIR variable is read only as startup time, so you will have
to restart the server whenever you decide to change sort locations.

Hope this helps.

Kerry