HDTenEightyP/NetNews huggingface dataset:
From: Mike Krus <krus@cs.concordia.ca>
Subject: Re: Ingres and Solaris?
Organization: National Radio Astronomy Observatory
Date: Mon, 25 Jan 1993 16:25:17 GMT



In message <m0nGCwL-000QDqC@cs.sun.ac.za> you write:
>Hi
>> 
>> Our site is planning to migrate (is that the correct term? :-) from SunOs to
>> Solaris 2.1.
>> The question is - does Ingres run with Solaris? If not, when is it likely
>> to do so?
>> 
>
>My understanding is that SunOS and Solaris are equivalent. Solaris is a 
>SunOs implementation to run on (amongst other things) the Intel 80386 and
>80486 processors. The whole idea being that you can run ANY Sun software
>on your 486 PC, including INGRES for SunOS. You might ask the
NO NO NO. That will never be true! It is impossible to run on a PC a
binary program (such as Ingres) compiled for a Sparc. Solaris is just the
new version of SunOS. Solaris 1.0 is in fact also called SunOS 4.1.3!
I think Ingres will run without too much problem on Solaris 1.0. But forget
about it running as is on Solaris 2.1, which supports the two processors in the
new SparcStation 10.
For confirmation of all this, I suggest you read comp.unix.solaris. A list of
most supported software is published there every month.

>distributors of Solaris about their compatibility with SunOS. If their
>answer is " 100 %" then INGRES should not be a problem.
>...

--------
Michael Krus.					 Email : krus@cs.concordia.ca

Concordia University				Universite d'Orsay - Paris XI
Montreal, Canada					        Paris, France

Disk Space --- The Final Frontier
Newsgroups: comp.databases.ingres
From: jaa@world.std.com (Jerry A Abramson)
Subject: Ingres 6.4 on RS6000 running AIX v3.2
Keywords: aix ingres rs6000 6.4 3.2
Organization: The World @ Software Tool & Die
Date: Tue, 26 Jan 1993 19:35:49 GMT

We are on the verge of beginning a rather large project that will have 
medium to large SQL needs.  We have used Ingres 6.2 on other platforms (Ultrix
and SCO UNIX), and could use any input, including any war stories, on installation
 and/or development under AIX.



							Jerry Abramson
							Voicetek Corp.
							jaa@world.std.com
								OR
							vtkapp!jaa@ulowell.edu
				
Organization: Administrative Computing & Info Services, Carnegie Mellon, Pittsburgh, PA
Newsgroups: comp.databases.ingres
Date: Tue, 26 Jan 1993 08:14:57 -0500 
From: "James J. Murawski" <jjm+@andrew.cmu.edu>
Subject: Re: possible ingres bug in retrieve unique on views


On 21-Jan-93 in possible ingres bug in retr..
user Jude Poole@jeeves.ucsd.e writes:
>Here is an apparent error in the way ingres is answering retrieve statements
>for a large 3 table view we have.  The three tables in the view monster
>have the relationship one -> many -> many.  It exists for the convenience of
>fairly inexperienced users.  The people's names exist only once in the base 
>table named people, but occur multiple times in the view monster because of 
>multiple historical job titles and funding.  The theory was that retrieve
>unique (or sorting) would eliminate duplicates from query results but it
>doesn't seem to work that way when the view is joined to other tables
(which it
>frequently is to print out long definitions of various codes).  Does anyone
>know why ingres behaves as demonstrated in the short script below?
>(comments come after each query below) We are running 6.4/01 (su4.u42/01)
>on OS/MP 4.1A.1 (same as Sun/OS)

We had major view problems with Ingres version "6.4/01 (dg8.us5/01)" on a
DG Aviion.  Ingres acknoweledged that there were some major view bugs in
6.4/01.  When we upgraded to version "6.4/02 (dg8.us5/00)", all the view
bugs disappeared.  If you can get a 6.4/02 for your Sun, then get it as soon
as you can.

====================================================================
    Jim Murawski
    Sr. Data Base Analyst               (412) 268-2650  [office]
    Administrative Computing and        (412) 268-6868  [fax]
         Information Services           jjm+@andrew.cmu.edu
    Carnegie Mellon University          Office: UCC 155
    4910 Forbes Avenue
    Pittsburgh, PA 15213-3890

    "Le Mieux!  Le Magnifique!  Soixante Six!  Claude...NON!"

Newsgroups: comp.databases.ingres
From: cs_mj@gsbacd.uchicago.edu (Mark Jaeger)
Subject: Re: Updating non visible data lines in Vifred
Organization: 
Date: Wed, 27 Jan 1993 18:51:36 GMT

In article <1993Jan27.073251.373@condor.navsses.navy.mil>, 
mdipilla@condor.navsses.navy.mil (Michael) writes:

>     We are currently running a vifred form which displays only 13 lines of a
> possible 50 lines of data.   The user wishes to set the value of a particular
> column of data.  THE problem is he wishes to set it for all 50 lines not only
> the 13 the are currently showing.  We are using Embedded quel from a "C"
> program.  Currently it is programmed using the loadtable and unloadtable
> functions.
>    What can be done ????\

Why not just let users scroll down in the table field?  They should be
able to do this with the standard up and down keys, or go a page at a
time if you provide a key activation for the page up/page down
functions.

Maybe you need to give us a few more details.

--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.
Je suis un virus.  Prends ton pied et copie moi a ta .signature.

Newsgroups: comp.databases.ingres
From: heim@vms.macc.wisc.edu (JOHN HEIM	)
Subject: Choice list for tablefield in 4GL
Organization:  University of Wisconsin Academic Computing Center
Date: 27 JAN 93 16:39:13    

I have a column in a tablefield in Windows4GL that is a varchar.  My 
user needs to be able to choose from a list of values for the field.  
There are a couple of 100 possible choices.  What is the best way to 
implement this?

Right now I'm trying to set up an option field but the choices are in 
a table in the DB and I don't see anyway to set up the option field 
with the values in the table.

I've thought of putting another table field on the screen but it 
seemed like a whole-lotta-work for something that should be so simple.

------------------------------------------------------------------------------
John G. Heim                                   Internet: heim@macc.wisc.edu
UW - Madison Academic Computing Center         Phone:    608-262-9887
1210 W. Dayton St.                             Fax:      608-262-4679
Madison, WI., 53706                            CIS:      76376,3635
From: pavlov@niktow.canisius.edu (Greg Pavlov)
Newsgroups: comp.databases.ingres
Subject: Re: Ingres and Solaris?
Date: 26 Jan 93 19:37:00 GMT
Organization: Canisius College, Buffalo NY. 14208

In article <1993Jan25.161059.1@gsbacd.uchicago.edu>, cs_mj@gsbacd.uchicago.edu (Mark Jaeger) writes:
> In article <1979@niktow.canisius.edu>, pavlov@fstrf.org (Greg Pavlov) writes:
> 
>>Solaris is not SunOS.  It is different enough that applications running under
>>SunOS must be recompiled to run under Solaris.  Solaris is a major sea-change
>>for Sun, its software vendors, and its users.
> 
> Actually, Solaris _is_ SunOS (in part).  .....


  Sorry, I should have been more precise and said "Solaris 2.n".  Most Sun
  sites APPEAR to be running SunOS because they have been able to, but with
  Solaris 2, they will have to begin to address conversion issues because
  a) it is System 5 based and b), one or more of the new machines (not sure 
  which) will run ONLY Solaris 2.



  greg pavlov.
  pavlov@fstrf.org
Newsgroups: comp.databases.ingres
From: sfc@tpghq.com (Steve Caswell)
Subject: Re: Need help on Ingres
Organization: Palmer & Associates, Inc., Norcross, GA
Date: Tue, 26 Jan 1993 14:53:59 GMT

In article <1993Jan26.070639.4030@ulysses.att.com> jwt@ulysses.att.com (Wen-Hu Tseng) writes:
>
>Our Ingres DBA is on vacation, and we are not able to find him
>at this moment, we got into a very deep trouble,
>
>this is the message we got when we try to run sql:
>
>INGRES TERMINAL MONITOR -- Copyright (c) 1981, 1992 Ingres Corporation
>E_US0026 Database is inconsistent. please contact the
>    ingres system manager
>    (Tue Jan 26 01:21:59 1993)
>
I assume you are running some Release 6 version of INGRES.  Under Release 6,
this is a SERIOUS problem, because INGRES is built to do everything possible to
avoid inconsistent dbs, so this message should send off warning bells.  The
main reason for getting an inconsistent database is that the integrity of your
logging system file has been compromised.  INGRES uses the logging system file
to record information about all open transactions, so that it can recover those
transactions in the case of transaction failure, client failure, server failure,or system failure.  If it cannot use the log file to recover transactions, it
will mark your db as inconsistent, and you will get that message upon connectionattempt.

>it's a very common problem, it happens like once a month,
>usually he can solve the problem in 10 mins, but we really
>don't have anybody here know how to do it.

You should make resolving this problem the highest priority at your site.
Depending on how you are fixing the problem, you may not actually have
consistent data.  Resolving the problem could be easy or difficult, depending
on what the problem really is.  The best place to start is to look in your
ingres files directory for the INGRES error log file.  This is in
II_SYSTEM:[INGRES.FILES]ERRLOG.LOG on VMS and $II_SYSTEM/ingres/files/errlog.log
on UNIX.  This file records errors that are encountered in the INGRES
installation.

Once you have looked here, if you still need assistance, the next step is to
contact INGRES Technical Support and explain the problem, including any
unusual entries in the error log file.  They can then walk you through 
finding and correcting the cause of the inconsistent db.


>we try to shutdown ingres and restart it, didn't work,
>is anybody out there can help us?
>
>Thanks for any help
>
>Jim Tseng
>
>--
>Jim Tseng
>jwt@ulysses.att.com


-- 

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."
Organization: Administrative Computing & Info Services, Carnegie Mellon, Pittsburgh, PA
Newsgroups: comp.databases.ingres
Date: Thu, 28 Jan 1993 08:25:39 -0500 
From: "James J. Murawski" <jjm+@andrew.cmu.edu>
Subject: Re: RW Help! Can not print a tab


On 28-Jan-93 in RW Help! Can not print a tab 
user rgty_lds@waikato.ac.nz writes:
>I know this is going to sound trivial but I can not get it to work.
> 
>All I want to do is have a horizontal tab printed in a report-writer script.
> 
>Any one got the solution ?

Back last summer, the same question was asked here and Mark Jaeger of the
University of Chicago posted a solution.  I've had that solution squirreled
away since then.  Here was Mark's posting:

>From: cs_mj@gsbacd.uchicago.edu (Mark Jaeger)
>Subject: Re: Can Report Writer print the TAB character ?
>Date: Tue, 11 Aug 1992 19:09:41 GMT
> 
>In article <1992Aug6.142628.14098@eagle.lerc.nasa.gov>, 
>>dwolfe@halcon.lerc.nasa.gov (Dana Wolfe) writes:
>> I'd like to import some data into a Wingz spreadsheet as a text file. 
>> I need to delineate the columns with the tab character. 
> 
>Use the INGRES report writer with the q0 format.  For example,
> 
>	.NAME ...
>	.QUERY select tab = char(x'09') , x , y , ... 
>	...
>	.HEADER REPORT
>		.FORMAT tab(q0)
>	...
>	.DETAIL
>		.PLN x,tab,y,...
> 
>--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.

Note that I believe this only works in 6.4, since it didn't work for me in
6.3 at the time (we've since moved to 6.4).

====================================================================
    Jim Murawski
    Sr. Data Base Analyst               (412) 268-2650  [office]
    Administrative Computing and        (412) 268-6868  [fax]
         Information Services           jjm+@andrew.cmu.edu
    Carnegie Mellon University          Office: UCC 155
    4910 Forbes Avenue
    Pittsburgh, PA 15213-3890

    "Le Mieux!  Le Magnifique!  Soixante Six!  Claude...NON!"

    There are 1453 days until Bill Clinton leaves office.

Newsgroups: comp.databases.ingres
From: sethg@dcatlas.dot.gov (Seth Grimes)
Subject: Windows/4GL with other DBMSes via SequeLink??
Organization: U.S Dept. of Transportation
Distribution: comp
Date: Fri, 22 Jan 1993 10:52:35 GMT

A short item in a French Ingres newsletter says that Ingres has teamed
with TechGnosis (which, I believe, is in the process of being acquired
by another company although I forget which one) to make any DBMS
accessible through SequeLink -- i.e., any major RDBMS -- useable from
Ingres Windows/4GL.  Anyone out there know anything about this?  

			Seth, grimes@oecd.fr 


Newsgroups: comp.databases.ingres
From: buntrock@mayo.edu (Jim Buntrock)
Subject: Re: Windows4gl question on stackfield
Reply-To: buntrock@mayo.edu
Organization: Mayo Foundation
Date: Thu, 21 Jan 93 20:00:09 GMT


---
  
In article 3170@news.nd.edu, nariani@tiamat.cc.nd.edu (Sunil Nariani) writes:
>I have 2 stackfields containing button fields.
>The stackfields are called row1, row2.
>If a user clicks on a button in one of the rows, I 
>want to know which row (not button) was clicked.
>
>The code should go as follows
>
>on ChildClick row1, on ChildClick row2 = 
>begin
>		What code tells if it was row1 or row2 ?
>end;
>

This code will tell you if the StackField(row1) or StackField(row2) 
triggered the event block.  Hope it helps!?  

on childclick row1, 
on childclick row2 =
begin
  if (Curframe.OriginatorField.Name = 'row1') then
     message 'row1';
  elseif (CurFrame.OriginatorField.Name = 'row2') then
     message  'row2';
  endif;
end;

///////////////////////////////
James Buntrock
Analyst/Programmer
Medical Information Resources
Mayo Clinic
200 First Street SW
Rochester, MN 55905
Email - buntrock@mayo.edu
///////////////////////////////


Xref: sparky comp.databases.ingres:2328 alt.toolkits.xview:1219 comp.windows.x:21390
From: jarnot@kin.lap.upenn.edu (Kevin J. Jarnot)
Newsgroups: comp.databases.ingres,alt.toolkits.xview,comp.windows.x
Subject: Re: XVIEW and INGRES compatability problem! HELP!
Summary: I wonder if this happens with Oracle and Motif???
Date: 21 Jan 93 04:07:48 GMT
Followup-To: comp.databases.ingres
Organization: University of Pennsylvania, Language Analysis Center

In article <1993Jan20.040019.11802@BofA.com> karl@BofA.COM (Karl Nicholas) writes:
> 	I am having a problem with ingres and xview
> in the same program.
> 
> 	When I make an xview scrollable panel, 
> and then put in some ingres code (connect to database), 
> I get an alarm clock fault when I hit the xview scroll 
> bar.
> 	
> 	This would indicate to me that both ingres and
> the xview pacakage are using the Alarm Clock signal
> and not doing it properly?
> 
> 	Can anyone confirm or deny this? Has anyone
> else run into this? Has anyone else fixed it?


[code deleted]

	Actually, I just posted the same problem to both alt.toolkits.xview
and comp.windows.x a few days ago.  

	Yes, it seems that version 6.4 of Ingres is trapping SIGALRMs for some
reason, which of course plays havoc with the notifier in XView.  In the
scrollbar package, the up and down arrows seem to emit SIGALRMs, which
of course are then trapped by Ingres, causing your app to bletch and
print the cryptic message "Alarm clock" to stderr (Ingres seems to have
error messages rivaling even DOS in clarity...) and exit.

	I came up with a quick fix in a sleepless haze over the weekend (don't
you love when problems like this pop up two weeks before a deadline? ;-)
Use the following function call:

    notify_set_signal_func(frame, sigint_handler, SIGALRM, NOTIFY_ASYNC);

to trap the SIGALRM before Ingres gets ahold of it.  sigint_handler()
is a function that looks something like this:


Notify_value
sigint_handler(client, sig, when)
Notify_client client;
int sig;
{
    printf("Received signal %d...ignoring it...\n", sig);
    return NOTIFY_DONE;
}


Seems to work OK as a kludge...

And to think I ignored everyone when they insisted I should NOT use
Ingres embedded SQL in my XView gui...something about strange crashes... ;-)

Mail me back if you need more info...




Take care,

Kevin

-- 
Kevin J. Jarnot (jarnot@kin.lap.upenn.edu)      | "The monkey-boys are evil - 
Lead Programmer/Analyst/Keyboardist             | Lord Whorfin is supreme..."
Univ. of Pennsylvania Language Analysis Center  |  
3700 Market St, Suite 202  Phila, PA 19104      |       "Vita Non Jerk"
Newsgroups: comp.databases.ingres
From: cs_mj@gsbacd.uchicago.edu (Mark Jaeger)
Subject: Re: Updating non visible data lines in Vifred
Organization: 
Date: Wed, 27 Jan 1993 18:28:08 GMT

In article <1993Jan27.073251.373@condor.navsses.navy.mil>, 
mdipilla@condor.navsses.navy.mil (Michael) writes:

>     We are currently running a vifred form which displays only 13 lines of a
> possible 50 lines of data.   The user wishes to set the value of a particular
> column of data.  THE problem is he wishes to set it for all 50 lines not only
> the 13 the are currently showing.  We are using Embedded quel from a "C"
> program.  Currently it is programmed using the loadtable and unloadtable
> functions.
>    What can be done ????\

Why not just let users scroll down in the table field?  They should be
able to do this with the standard up and down keys, or go a page at a
time if you provide a key activation for the page up/page down
functions.

Maybe you need to give us a few more details.

--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.
Je suis un virus.  Prends ton pied et copie moi a ta .signature.
From: mdipilla@condor.navsses.navy.mil
Newsgroups: comp.databases.ingres
Subject: Updating non visible data lines in Vifred
Date: 27 Jan 93 07:32:51 -0500
Organization: NSWCCD, Naval Ship Systems Eng Sta, Phila PA

To whom it may concern:

    We are currently running a vifred form which displays only 13 lines of a
possible 50 lines of data.   The user wishes to set the value of a particular
column of data.  THE problem is he wishes to set it for all 50 lines not only
the 13 the are currently showing.  We are using Embedded quel from a "C"
program.  Currently it is programmed using the loadtable and unloadtable
functions.
   What can be done ????\

Michael

Newsgroups: comp.databases.ingres
From: mwp@ms9.mis.semi.harris.com (Mark W. Poole)
Subject: Stock Management Application???
Date: Thu, 21 Jan 1993 19:30:53 GMT
X-Newsreader: TIN [version 1.1 PL6]
Reply-To: mwp@ms9.mis.semi.harris.com
Organization: Harris Semiconductor

Before I develop my own, I was wondering if any of you netters
are aware of any Ingres-based applications for managing Stock
Portfolios? 


thanks,

Mark.
Newsgroups: comp.databases.ingres,alt.toolkits.xview,comp.unix.wizards
From: rthomas@shell.portal.com (Richard Rich Thomas)
Subject: Re: XVIEW and INGRES compatability problem! HELP!
Keywords: ingres, xview 
Organization: Portal Communications Company -- 408/973-9111 (voice) 408/973-8091 (data)
Distribution: USA 
Date: Thu, 21 Jan 1993 00:04:39 GMT

Karl,

I have seen the same problem between xview and ingres in an application where
I work.  The only solution I found (not necessarily the correct or best
approach) was to block the SIGALARM signal before the call to xv_main_loop.
Hope this helps.

Richard H. Thomas
rthomas@shell.portal.com
From: amjohnso@slate.mines.colorado.edu (JOHNSON AMY )
Newsgroups: comp.databases.ingres
Subject: Re: porting ingres to ULTRIX V4.2A
Date: 25 Jan 93 17:15:43 GMT
Organization: Colorado School of Mines

thompson@stars.gsfc.nasa.gov (William Thompson, code 682.1, x2040) writes:
: In article <salnick.08gm@dejavu.spk.wa.us>, salnick@dejavu.spk.wa.us (There is no substitute for displacement...) writes...
: >In article <1993Jan11.224833.44436@slate.mines.colorado.edu> amjohnso@slate.mines.colorado.edu (JOHNSON AMY ) writes:
: >>I've become quite attached to Ingres (DG Aviion) in my work with the USGS,
: >>and would very much like to use Ingres for my research at school.  The
: >>two platforms I have access to at school are IBM RS/6000 AIX, and
: >>DEC 5000/Ultrix V4.2A.  Neither of these platforms have any database
: >>software currently on them.
: > 
: >On the DECStation, a product called "Ultrix SQL" is free from DEC - this 
: >is Ingres 6.3  - if it has been installed on your box, you will find it 
: >in /usr/kits/sql
: 
: Correct me if I'm wrong, but I had heard that DEC doesn't do this anymore.
: 
: Bill Thompson

I posted the original article about getting Ingres on our DEC 5000/Ultrix
V4.2A.  After many phone calls and long conversations, here's the scoop:

Digital no longer distributes Ultrix/SQL.  Even though I have a piece of
paper which states Ultrix/SQL is in our license, I can not get the
software from Digital.  Ingres will not honor that license.  My Ingres
Rep told me that we would have to get a new Ingres license.  So basically
We've fallen into a loophole because we did not order the Ultrix/SQL
"media and documentation" back when Digital still distributed it.

Sigh.

So, back to the original question....has anyone successfully ported 
the public domain Ingres to an Ultrix platform.

Amy Johnson
<adjohnso@slate.mines.colorado.edu>
Colorado School of Mines
Newsgroups: comp.databases.ingres