HDTenEightyP/NetNews huggingface dataset:
From: heim@vms.macc.wisc.edu (JOHN HEIM	)
Subject: Re: Choice list for tablefield in 4GL
Organization:  University of Wisconsin Academic Computing Center
Date: 28 JAN 93 10:02:23    

In article <1993Jan28.145042.23125@pony.Ingres.COM>, jabbate@Ingres.COM (Joe M. Abbate) writes...

>In article <1993Jan27.224636.6022@macc.wisc.edu>, heim@vms.macc.wisc.edu
>(JOH writes...
> 
>>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.
> 
>An option list is a descendant (or subclass) of EnumField, so one
>of its attributes is ValueList, an object of type ChoiceList,
>which is an array of ChoiceItems.  You can add ChoiceItems values
>(EnumText and EnumValue), inside a SELECT loop, either directly (by
>assignment) or by using the AddTextItem method of ChoiceList.
>Remember to call ChoiceItems.Clear() first and UpdChoiceList()
>after the loop (to update the display).  The Language Reference
>Manual has an example in the System Classes chapter, under EnumField,
>and you can also look at the Purchase_order application in appendix D
>of the Application Editor User's Guide.

Yeah, right after I posted the question I saw that the chapter on 
choice lists in the Language Reference Guide directs you to the 
Programmers Guide for an example of dynamic programming.  I haven't 
looked at it yet though.  (The index of the Programmers Guide doesn't 
mention it.)  

Thanks much.

BTW, I guess I should be using a list field (not a option field).  I 
think what you said above still works though, right?

------------------------------------------------------------------------------
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
Newsgroups: comp.databases.ingres
From: amiranda@ariel.aero.org (Ann Miranda)
Subject: Sun Sparc 10/ sun5 keyboard mappings
Keywords: keymaps
Organization: The Aerospace Corporation; El Segundo, CA
Date: Mon, 25 Jan 1993 17:22:21 GMT

	I recently acquired a Sun Sparc 10 model 31 with a 
Sun 5 keyboard.  The problem is the key maps don't work with
Ingres 6.4/01 (su4.u42/01) (both under Motif or OpenWindows 3.0).

	Only one person so far (few weeks ago) had reported a
similar problem to Ingres technical support; unfortunatly it wasn't
much help for me.

	Has anyone run into the same problem, and created the 
Ingres key maps?  (I'm sure if I had lots of time, I could do it,
but, I don't have lots of time)

	I'd appreciate any help I could get!
		Thanks, Ann
From: psu@kalle.impab.se (Per Sundin)
Newsgroups: comp.databases.ingres
Subject: Re: Looking for Large Ingres Sites
Date: 21 Jan 93 16:35:33 GMT
Organization: IM Program AB, Stockholm, Sweden

In article <C1315E.6F7@world.std.com>, epstein@world.std.com (Richard W Epstein) writes:
> My impression is that very few sites are running commercial Ingres
> with a large number of concurrent users.
> 
> I am interested in hearing from any sites running commercial Ingres
> with 40 or more users. I am looking to get a performance feel for
> a site running an application in production with a more than casual
> use. If you are running what you consider a "real" application please
> respond with the hardware and operating system environment, the 
> number of users and a brief description of the application if possible.
> 
> I will post a summary unless asked to keep the information private.
> 

Some people at our company have been involved with developing a pretty big
system for the last few years here in Sweden.

The system is a distributed documenthandling system (export/import-documents)
at The Swedish Customs. It also handles most of the rules for customs clearing.

It's running on a VAX/VMS central cluster and 17 DECSystem/Ultrix local
machines.  A couple of the local machines are actually 2 with one frontend and
one backend machine. The local machines are placed around Sweden.

The central cluster doesn't have any "logged on" user so far but 1 EDI-server,
17 store-and-forward servers plus maybe 30 - 50 TCP/IP-connect (not Ingres/Net) 
users.

The biggest local machines have maybe 60 concurrent users and the smallest
just a few. During busy times it might be a total of around 400 concurrent
users logged in. Each machine also have a store-and-forward server connect
to the local Ingres database.

The data is distributed in the manner that the original is located in a local
machine and copies are held at one or two more machines. The way we have done
this anybody can get hold of a copy of a document with maximum going over to 
one other machine.

-- 

  Per Sundin                        			Tel   : +46-8-6507525
  Technical Manager					Fax   : +46-8-6502870
  IM Program AB						Email : psu@impab.se
  Fleminggatan 56
S-112 45 Stockholm,  Sweden
Newsgroups: comp.databases.ingres
From: drcoles@somnet.sandia.gov (Dwight R Coles)
Subject: RE: How good is Ingres 6.4/01?
Organization: National Radio Astronomy Observatory
Date: Mon, 25 Jan 1993 19:43:15 GMT

 Devender Reddy writes about Version 6.4/01 of Ingres:
 > 
 > I am interested in finding out if there are any serious bugs in this release.
 > Any info is appreciated.
 > 
 You should probably be asking that question about 6.4/03/00, which is 
 the very latest release for major platforms.  As with any Ingres release,
 yes, there are bugs in it 8^).  But you will find 6.4/03 very solid
 and capable of supporting commercial work quite easily, imho.
 
 Dwight Coles       drcoles@sandia.gov
From: pavlov@niktow.canisius.edu (Greg Pavlov)
Newsgroups: comp.databases.ingres
Subject: Re: How good is Ingres 6.4/01?
Date: 26 Jan 93 19:39:08 GMT
Organization: Canisius College, Buffalo NY. 14208

In article <9301251943.AA13048@somnet.Sandia.GOV>, drcoles@somnet.sandia.gov (Dwight R Coles) writes:
> 
>  You should probably be asking that question about 6.4/03/00, which is 
>  the very latest release for major platforms. ......

   For which platforms has it actually been distributed ?  We run DEC MIPS
   systems and have not seen it yet (tho it's no longer a "major platform",
   I suppose...)


   greg pavlov
   pavlov@fstrf.org
Organization: Data Communications, Carnegie Mellon, Pittsburgh, PA
Newsgroups: comp.databases.ingres
Date: Tue, 26 Jan 1993 10:59:11 -0500 
From: Frank Eugene Kietzke <fk03+@andrew.cmu.edu>
Subject: Re: Ingres and Solaris?
	<1993Jan25.161059.1@gsbacd.uchicago.edu>

Actually, Solaris 2.X is a multi-threaded operating system designed to
control multiple CPUs.  To even use the "SunOS compatibility" mode,
there is a long list of "thread safe" practices that the code must use. 
I am not sure what those are, but I was told by a Sun rep that if the
program is of any complexity at all, and was compiled under SunOS,
chances are that a re-compile under Solaris 2.X is the minimum needed. 
I also heard from this same rep that Ask/Ingres had committed to a
Solaris 2.X port sometime this year, but I don't remember the dates.  In
general, this is a "new OS" as far as any software is concerned.

Just my $0.02 

-------------------------------------------------------------------------
|Frank Kietzke               | That was the "stun" setting, this is not.|
|Carnegie-Mellon University  |   Lt. Commander Data,                    |
|Data Communications         |   STTNG, The Ensigns of Command.         |
-------------------------------------------------------------------------
| I can hardly speak for myself, let alone for CMU Data Communications  |
-------------------------------------------------------------------------
From: rgty_lds@waikato.ac.nz
Newsgroups: comp.databases.ingres
Subject: RW Help! Can not print a tab 
Date: 28 Jan 93 16:02:04 +1300
Organization: University of Waikato, Hamilton, New Zealand

	********	H E L P   W A N T E D	******

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 ?

+------------------------------+-------------------------+---------------------+
!Leigh Sherwen                 !Administrative DP Manager!Usual Disclaimer     !
!Phone: 64 7 8384092           !University of Waikato    !Inane Quote          !
!Fax:   64 7 8560135           !Hamilton                 !Sicker Joke          !
!EMail: L.Sherwen@Waikato.ac.NZ!New Zealand              !Empty Thought        !
+------------------------------+-------------------------+---------------------+
From: eaton@pacersoft.com (Mark W. Eaton)
Newsgroups: comp.databases.ingres
Subject: Re: ODBC
Date: 27 Jan 93 22:56:44 GMT
Followup-To: comp.databases.ingres
Organization: Pacer Software, Inc.

In article <1993Jan27.103607.9809@informix.com>, christb@infmuc (Christian
Barmala) wrote:
> 
> Will Ingres support Microsofts ODBC? If so, will they just provide an
> ODBC driver to access their engine or will the tools like W4GL be able
> to talk via ODBC to any database that provides an ODBC driver?
> 
> Regards, Christian Barmala

You certainly will be able to access Ingres from ODBC through DAL.  This is
part
of work already committed as part of the joint Microsoft-Apple ODBC
endeavor.

Mark W Eaton
Pacer Software, Inc.
eaton@pacersoft.com

Disclaimer: I work for Pacer Software, Inc. and develop Unix-based
AppleTalk and DAL products
From: christb@infmuc (Christian Barmala)
Newsgroups: comp.databases.ingres
Subject: ODBC
Date: 27 Jan 93 10:36:07 GMT
Organization: Informix Software, Inc.
X-Newsreader: Tin 1.1 PL3

Will Ingres support Microsofts ODBC? If so, will they just provide an
ODBC driver to access their engine or will the tools like W4GL be able
to talk via ODBC to any database that provides an ODBC driver?

Regards, Christian Barmala
Newsgroups: comp.databases.ingres
From: prs9k@brain.med.virginia.edu (Phil Scarr)
Subject: Re: ingres vs oracle comparison, interop
Organization: Neuroclinical Trials Center, UVa
Distribution: usa
Date: Thu, 28 Jan 1993 13:15:43 GMT

In article <salnick.09y2@dejavu.spk.wa.us> salnick@dejavu.spk.wa.us (There is no substitute for displacement...) writes:
>>
>>cross - network NOS function, Oracle _seems_ capable of working 
>>between tcp/ip, IPX/SPX, and netbios environments.
>
>Ingres works in DECNet, TCP/IP, SNA environments or combinations...  
>not sure about Novell.

Ingres just gave a demo here yesterday.  Here is the poop on Ingres on Novell.
They plan to have an NLM version of Ingres by 4thQ this year but if you
really want to run it in an IPX environment, you can use UnixWare for
Novell which would allow both TCP/IP to Unix access and IPX to Novell
access.  It works quite well, they said.



-- 
PHIL SCARR        \      We are Microsoft...     /          (o) 804.243.0229
 University of    /     OS/2 is irrelevant.      \          (f) 804.243.0290
 Virginia,        \     UNIX is irrelevant.      /        prs9k@Virginia.EDU
 Neurosurgery     /     Openness is futile.      \     prs9k@Virginia.BITNET
 HP-UX is my life!\ Prepare to be assimilated... /   ...uunet!virginia!prs9k
From: Cristyn Emmett <Cristyn.Emmett@newcastle.ac.uk>
Subject: Ingres and Solaris?
Organization: National Radio Astronomy Observatory
Date: Wed, 20 Jan 1993 12:58:02 GMT

We have Ingres 6.3/01 (soon to be upgraded to 6.4/01) on a Sun 4/470 running 
SunOs 4.1.1.
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?

	Cristy

Also known as:       
cristyn.emmett@newcastle.ac.uk
******************************
From: salnick@dejavu.spk.wa.us (There is no substitute for displacement...)
Newsgroups: comp.databases.ingres
Subject: Re: ingres vs oracle comparison, interop
Date: 28 Jan 93 08:38:33 GMT
Distribution: usa
Organization: Not Organized

In article <C1Ipnv.KCx@world.std.com> fw@world.std.com (forrest d whitcher) writes:
>
>Hello all, I hope this isn't an FAQ, I have been evaluating (on trial)
>oracle (os2 - unix - dos) for construction of a network - available
>lab-testing dbms for our R&D labs. Our MIS shop has asked that we look 
>at ingres (we have a very big ask/manman system which _might_ someday
>becom a manman/x - ingres implementation). My requirements are as 
>follows, in order of importance:
>
>end-user access (engineers, technicians) to dbms over net at the 
>application level (we like Pioneer's Q&E tool)

Works fine with Ingres too.

>
>cross - network NOS function, Oracle _seems_ capable of working 
>between tcp/ip, IPX/SPX, and netbios environments.

Ingres works in DECNet, TCP/IP, SNA environments or combinations...  
not sure about Novell.

>
>good 3rd party support
>
>in the long term: good s/w development tools, We are starting without
>forms and 4gl, but will probably want these next year.
>
>also, how well do these two systems exchange data today? Prospects for
>the future?

Ingres and Oracle do not currently exchange data.  They can be persuaded 
to have a "behind the back" conversation tho by doing embedded sql work 
and linking to both libraries (we have done this).  

Since you have had a trial copy of oracle in for evaluation, why don't 
you get a trial copy of Ingres too?  Then you will have an equal basis 
for comparison.  I make this recommendation with some confidence, since I 
think you will choose Ingres in a side-by-side comparison - especially 
when you look at the work that the DBA has to do in both cases.

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: pab@Ingres.COM (Phil Bloemink)
Subject: Re: Windows4gl question on stackfield
Keywords: Windows4gl, stackfield
Reply-To: pab@Ingres.COM (Phil Bloemink)
Organization: Ingres Division, ASK Computer Systems.
Date: 21 Jan 93 18:10:55 GMT

In article <1993Jan21.042018.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;
>
>
>Note: I don't want separate event blocks as in the following code.
>on ChildClick row1 =
>begin
>	...
>end;
>
>on ChildClick row2 =
>begin
>	...
>end;
>
>

If you want to know the name of the stackfield that contains the button
that was clicked on, you can use the following:

stack_name = FORMFIELD(CurFrame.TriggerField).ParentField.Name;

Or, if you just need the reference variable for the StackField
you can use:

stack_ptr = FORMFIELD(CurFrame.TriggerField).ParentField;


Phil Bloemink
INGRES Tech. Support

<standard disclaimer> 		<obscure quote>		<impressive graphic>



Newsgroups: comp.databases.ingres
From: heja@ise.fhg.de (Herbert Jaegle)
Subject: Re: How good is Ingres 6.4/01?
Organization: FhG-ISE - Institute for Solar Energy Systems
Date: Tue, 26 Jan 93 17:55:04 GMT

drcoles@somnet.sandia.gov (Dwight R Coles) writes:

> Devender Reddy writes about Version 6.4/01 of Ingres:
> > 
> > I am interested in finding out if there are any serious bugs in this release.
> > Any info is appreciated.
> > 
> You should probably be asking that question about 6.4/03/00, which is 
> the very latest release for major platforms.  As with any Ingres release,
> yes, there are bugs in it 8^).  But you will find 6.4/03 very solid
> and capable of supporting commercial work quite easily, imho.
> 
> Dwight Coles       drcoles@sandia.gov
> 
We are running INGRES Release 6.4/02 (hp3.us5/00) patch 2483 as the latest
release available in Germany and this has a serious bug in handling
money datatypes under HPUX.

Herbert Jaegle
--
-------------------------------------------------------------------
Herbert Jaegle        Fraunhofer Institute for Solar Energy Systems
DL7GAP               Oltmannsstr. 22, D 7800 Freiburg, West Germany
heja@ise.fhg.de   phone: +49 (761) 4014 126 fax: +49 (761) 4014 200
_  quantum est, quod noscimus  ____________________________________
Newsgroups: comp.databases.ingres
From: cor@cs.sun.ac.za (Cor Winckler)
Subject: Re: Copying Ingres database to another machine?
Organization: National Radio Astronomy Observatory
Date: Thu, 21 Jan 1993 01:01:30 GMT

> >>  FETCH error in ii_id: 40100 (E_OO0018)   [PRESS RETURN] 
> > in via the reload.
> 
> Wow.  That's not supposed to happen.  The error you encountered clearly
> indicates that you have multiple rows in the ii_id frontend system
> catalog.  You can check this yourself:
> 
> I'd sure be interested to hear what else you found out about this
> problem, and if you identified the real cause.

We had this problem once or twice. 

The problem is that some people had ING_SET setup with readlock=nolock
for session. Thus two people could access the ii_id table at the same
time with no protection for concurrent updates. Euraka ! Duplicates.

We fixed it by physically deleting the smallest object_id in ii_id. That
fixed the symptom, but the problem is people not knowing what the
possible consecuences of readlock=nolock could be.

On our site we have applications that were designed to work with
readlock=nolock, thus everyone has it set up in their environment, and
few people realise that they need to undo it before going into ABF or
Vision.

Did something similar happen on your site?

Hope this helps.

-- 
  Cor
 
 Cor Winckler                    | Computer Science Departement             
 Internet: cor@cs.sun.ac.za      | University of Stellenbosch, South Africa
From: anadeem@ampere.bit.listserv.tech-l (Ahmed Nadeem)
Newsgroups: comp.databases.ingres
Subject: Edge Detection And Segmentation Using Khoros And PV-WAVE Software
Date: 27 Jan 93 07:51:43 GMT
Article-I.D.: ampere.ANADEEM.93Jan27005143
Distribution: comp.databases.ingres
Organization: /home/ampere1/anadeem/.organization

Netters,
        I am currently working on a research project that involves generating
solid or geometric models from MRI images. Part of the procedure will require 
me to possibly perform Thresholding & Edge Detection on my MRI images in order
to find out which pixels lie on boundaries between two different regions. 
Thus, I would like to have an Image Processing Software package that has good 
Edge Detection and Classification ( Segmentation ) modules/routines.  
        I have heard a lot about Khoros ( University Of New Mexico) and 
PV-WAVE (Precision Visuals) and was curious if other professionals or students
had any experience on how good they are for the above purposes. Suggestions 
on other software packages are also much welcome.
                                                       Thanks,
                                                              Ahmed Nadeem
From: pavlov@niktow.canisius.edu (Greg Pavlov)
Newsgroups: comp.databases.ingres
Subject: Re: Ingres and Solaris?
Date: 25 Jan 93 10:53:19 GMT
Organization: Canisius College, Buffalo NY. 14208

In article <m0nGCwL-000QDqC@cs.sun.ac.za>, cor@cs.sun.ac.za (Cor Winckler) writes:
> > Our site is planning to migrate (is that the correct term? :-) from SunOs to
> > Solaris 2.1.
> 
> 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. ......

  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.  




  greg pavlov
  pavlov@fstrf.org
Newsgroups: comp.databases.ingres
From: jhallen@world.std.com (Joseph H Allen)
Subject: Re: Public Domain INGRES
Organization: The World Public Access UNIX, Brookline, MA
Date: Fri, 22 Jan 1993 23:18:03 GMT

In article <1993Jan13.000007.2059@netcom.com> zmbenhal@netcom.com (Zeyd M. Ben-Halim) writes:

>Use archie to look for ingres89.tar.Z or use my port to Linux available from
>tsx-11.mit.edu:pub/linux/packages/ingres/*

There might be a bug in your port, but it's also possible that I'm doing
something wrong as I'm inexperienced with ingres.

If in some database you do:

    create foo(x=c8)
    \g
    modify foo to ordered1 on x
    \g

It says: can't link to _SYS234btree... and dies

The problem might be the 14 character file name limit in linux since I
think it's trying to make a
file 'foo         agb' for the file 'foo         ag'  But after
changing 'MAXNAME' from 12 to 11 in 'ingres.h' and in a few other places,
file name matching really broke (files created by dbu commands couldn't be
opened by ingres).

It's really neat though.  University ingres works much better (faster) than
I had originally thought it would.  Now if only it had outer joins, unions
and better ordering...  EQUEL is especially nice.  It think it might be more
powerful than some of the SQL embeded languages since you can give C
variables as parts of QUEL expressions (it's my impression that it's not
possible to do that in SQL, but I could be wrong).
-- 
/*  jhallen@world.std.com (192.74.137.5) */               /* Joseph H. Allen */
int a[1817];main(z,p,q,r){for(p=80;q+p-80;p-=2*a[p])for(z=9;z--;)q=3&(r=time(0)
+r*57)/7,q=q?q-1?q-2?1-p%79?-1:0:p%79-77?1:0:p<1659?79:0:p>158?-79:0,q?!a[p+q*2
]?a[p+=a[p+=q]=q]=q:0:0;for(;q++-1817;)printf(q%79?"%c":"%c\n"," #"[!a[q-1]]);}
Newsgroups: comp.databases.ingres
From: fw@world.std.com (forrest d whitcher)
Subject: ingres vs oracle comparison, interop
Keywords: oracle ingres rdbms sql network
Organization: The World Public Access UNIX, Brookline, MA
Distribution: usa
Date: Wed, 27 Jan 1993 14:59:52 GMT


Hello all, I hope this isn't an FAQ, I have been evaluating (on trial)
oracle (os2 - unix - dos) for construction of a network - available
lab-testing dbms for our R&D labs. Our MIS shop has asked that we look 
at ingres (we have a very big ask/manman system which _might_ someday
becom a manman/x - ingres implementation). My requirements are as 
follows, in order of importance:

end-user access (engineers, technicians) to dbms over net at the 
application level (we like Pioneer's Q&E tool)

cross - network NOS function, Oracle _seems_ capable of working 
between tcp/ip, IPX/SPX, and netbios environments.

good 3rd party support

in the long term: good s/w development tools, We are starting without
forms and 4gl, but will probably want these next year.

also, how well do these two systems exchange data today? Prospects for
the future?

thanks, forrest

please reply to email:         fw@world.std.com



Newsgroups: comp.databases.ingres