HDTenEightyP/NetNews huggingface dataset:
From: Email and Systems Consulting <CONSULTING@macc.wisc.edu>
Subject: test message
Organization: National Radio Astronomy Observatory
Date: Fri, 20 Nov 1992 14:26:00 GMT

Test message, please ignore.
--------------------------------------------------------------------------------
EMail & Systems Consulting  Monday - Friday   Internet: consulting@macc.wisc.edu
1210 W. Dayton St.          10:00 - 4:30      Bitnet:   consulting@wiscmacc
Madison, WI 53706           262-6886/Rm 1153  Decnet:   wircs3::consulting
MADISON ACADEMIC COMPUTING CENTER (MACC), UNIVERSITY OF WISCONSIN - MADISON
Newsgroups: comp.databases.ingres
From: CS_PAUL@GSBVAX.uchicago.edu (Paul Ford 312/702-0335)
Subject: re: Frequently Used Procedures
Organization: National Radio Astronomy Observatory
Date: Tue, 17 Nov 1992 22:11:41 GMT

From:	SMTP%"tjb@MATH.AMS.ORG" 17-NOV-1992 06:26:01.05
To:	info-ingres@MATH.AMS.ORG
CC:	
Subj:	Frequently Used Procedures

Date: 17 Nov 1992 04:02:53 +0000 (GMT)
From: mjm@gdwb.oz.au (Michael McGarrigle)
Subject: Frequently Used Procedures
To: info-ingres@MATH.AMS.ORG
Errors-to: tjb@MATH.AMS.ORG
Message-id: <3400@peking.gdwb.oz.au>
Content-transfer-encoding: 7BIT
Path:
 cv3.cv.nrao.edu!uvaarpa!darwin.sura.net!zaphod.mps.ohio-state.edu!rpi!batcomputer!munnari.oz.au!sol.deakin.OZ.AU!gdwb.oz.au!mjm

Does anybody out there know of a way that commonly used
routines can be stored in one place but accessed by
several databases.

i.e. We have an error handling routine that is called after 
every database access (To check for deadlock, etc) but it
seems cumbersome to have to recreate this procedure for
every database that we create.

I am probably showing my ignorance but any ideas would be
appreciated.

Thanks in advance.

-- 
Michael McGarrigle   		Information Systems Division        
Email: mjm@gdwb.OZ.AU		Geelong & District Water Board
Phone: +61 52 262326		61-67 Ryrie St Geelong
Fax:   +61 52 218236		Victoria 3220 Australia
From: richard@asis.unimelb.edu.au (Richard Begg)
Newsgroups: comp.databases.ingres
Subject: Re: Field Templates
Date: 20 Nov 1992 02:50:54 GMT
Organization: University of Melbourne
NNTP-Posting-Host: mulgulgum.asis.unimelb.edu.au

brunette@sju.edu (Glenn M. Brunette, Jr.) writes:


|Is there any way using the Ingres VIFRED program to make field templates?
|I am specifically looking for things like the following:
| 
|   One numeric only field: X
|   When displayed/modified field looks like: __-__-__
|      where the "-" are actual characters that show up and the text
|      moves around them.  I would like to keep it one numeric field for
|      simplicity reasons, but would like to have the seperation as described.

A format like "nn\-nn\-nn" should do what you want.


--
Richard Begg (richard@asis.unimelb.edu.au)
Admin Systems and Info Services - University of Melbourne.
Newsgroups: comp.databases.ingres
From: ash@ulysses.mr.ams.com (Alan Harder)
Subject: Re: Problem installing Ingres 6.4/02 under SunOS 4.1.3
Organization: American Math. Society
Date: Mon, 16 Nov 1992 16:07:04 GMT

In article <1e6oe6INNcrr@ariel.ucs.unimelb.EDU.AU> richard@ariel.ucs.unimelb.EDU.AU (Richard Begg) writes:

   jstewart@alfred.carleton.ca (John Stewart) writes:

  >|I just installed Ingres 6.4/02 on a Sparcstation 10 running SunOS 4.1.3 but
  >|when it tries to start up it fails with the following error

  >|---------------------- RESOURCE CHECKING COMPLETE -----------------------


  >|Allocating 401408 bytes of shared memory...

  >|!shmat for id 201 at address F4000000 fails
  >|!errno = 22
  >|!Can't map locking segment into memory at address FFFFFFFF
  >|!Check or adjust the value of II_LG_MAP_ADDR
  >|Could not create the system segment, does your kernel have enough
  >|shared memory or has this program already been run?

  >|-----------------------------------------------------------------------------

  >|Has anyone seen this problem before?  I'm not entirely surprised since
  >|the release notes only guarantee that it works under 4.1.1 or 4.1.2.

  > This problem is due to a lack of shared memory configured in the Kernel
  > rather than a OS version problem.  The fix is to add more shared memory
  > with a line something like this in your kernel config file.  e.g.

  > options         SHMSIZE=2000	# allocate 2MB of shared memory

  > I trust you have all the sysV IPC stuff turned on as well (semaphores etc).

Actually, there is a problem running 6.4/02 on 4.1.3 on the MP class
machines which causes this error.


I found the following on Ingres Advisor:

>Abstract:
>OS_CONFIG:  Ingres 6.4 is not certified against SunOS 4.
>1.3. However if you do use this combination, one action
>you need to take before you can startup Ingres on this unsupported
>OS follows.


>Expert note:
>You will encounter some problem starting up Ingres if you try to run
>Ingres on SunOS 4.1.3, which is not yet certified.

>The problem resides in the way Ingres attach the LG/LK shared segment
>through csinstall; we use an adress as a parameter to shmat (0xf4000000)
>that worked on SunOS 4.1.2 and doesn't work anymore on SunOS 4.1.3.
>Fortunately, we can set II_LG_MAP_ADDR to the value 0x10000000
>(ingsetenv II_LG_MAP_ADDR 10000000). SunOS 4.1.3 will accept to attach
>your segment there.

>These tests were done using a SPARC 10 Model 30.
>There were no other problem reported; tests were done with a database
>and disks from a SPARC 2 (!). Performance ratio between SPARC 2 and
>SPARC 10 was not measured but the customer was more than happy. SPARC
>10 behaves as its competitors RS6000 and HP9000/7x0 for graphics and
>seems to run Ingres server better.

>NOTE: Remember we have not yet certified on SunOS 4.1.3 and this
>environment variable is UNSUPPORTED.


>Releases affected:  6.4/01(su4.u42) -   Releases not affected:
>Errors:
>Bugs/SIRS:


Well, the document is wrong, because 6.4/02 is now certified for use
with 4.1.3.  The rest of it is right, though.  The above fix worked
for us.




-Alan Harder
 
These opinions are mine.  You can't have them.  Stop, thief!
From: OLIVIERI@ICHCMNS.CMNS.MNEGRI.IT (Marco Olivieri)
Newsgroups: comp.databases.ingres
Subject: What is the best method to backup Ingres DataBase ?
Date: 18 Nov 92 14:05:00 GMT
Organization: National Radio Astronomy Observatory

Hi, 

  I have a question for you.

  1) What is the best method to backup Ingres DataBase ?

We  work with  microVax 3600,  VMS 5.5-1  & 6.4/01  (vax.vms/01) and SUN/UNIX.
Now the System Manager of the VAX does not BACKUP ingres DataBase,and I do the 
CHECKPOINT on tape (TK70 - I checkpoint only 3 small DataBase) but not for all
DataBase, now I would like  to change the Backup Method, in  order to obtain a 
total security for data.

What do you suggest ?

Thanks in advance

  Marco Olivieri
Newsgroups: comp.databases.ingres
From: reid@UPEI.CA (Mike Reid)
Subject: Re: Auditdb on old journals?
Keywords: auditdb,journal
Organization: University of Prince Edward Island, CANADA
Date: Mon, 23 Nov 1992 17:02:35 GMT

In article <reid.6.722272148@UPEI.CA> reid@UPEI.CA (Mike Reid) writes:
>
>Is there any way to get auditdb to write an audit trail for some previous
>journal file?  The journal file is deleted after each checkpoint but I would
>like to be able to look for particular changes in a journal file restored
>from tape. We are running Ingres 6.4/02 under VMS 5.4. Any suggestions
>would be appreciated.
>
>Thanks
>
>Mike Reid <REID@UPEI.CA>

Shortly after posting this question I got mail from someone at Ingres who
suggested that I rename the journal file that I wanted to look at to the
name of the current journal file WITH NOBODY USING INGRES AT THE TIME and
then run auditdb.  This worked.

Mike Reid
Newsgroups: comp.databases.ingres
From: cs_mj@gsbacd.uchicago.edu (Mark Jaeger)
Subject: Re: Passing a WHERE clause to Report Writer
Organization: 
Date: Fri, 20 Nov 1992 21:11:29 GMT

In article <1992Nov20.021456.903@csc.canberra.edu.au>,
mmr@asgserver.canberra.edu.au (Micheal Rainford-Watson) writes:
> I'm trying to pass a where clause to report writer to establish a
> sort of flexible labels program.
> ...
> Platform is Ingres SunOS Version 6.3/01 (su4.u42/01)

It seems like getting all the quotes right when using the report writer
with UNIX is a complete and total nightmare.  By the time you've
expressed enough redundant ones to satisfy 4GL, you're only left with
enough for the shell to strip off and turn into hash.  It seems to me
that other people in this conference have wrestled with the same
problem, but I have yet to see the definitive solution.

I have but two suggestions.  Add this line to your report writer program:

		.SETUP set printqry ;

Then at least you can see what RW is getting.

Also, try getting the shell to echo what it's doing.  If you use the
Bourne shell, invoke it with the "-vx" switch or add "set -vx"
somewhere; if it's the cshell, use "set verbose; set echo" (maybe in
your .cshrc file).  Then you may be able to see how the parameters are
getting passed in to the report writer.

--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: mjm@gdwb.oz.au (Michael McGarrigle)
Newsgroups: comp.databases.ingres
Subject: Frequently Used Procedures
Date: 17 Nov 92 04:02:53 GMT

Does anybody out there know of a way that commonly used
routines can be stored in one place but accessed by
several databases.

i.e. We have an error handling routine that is called after 
every database access (To check for deadlock, etc) but it
seems cumbersome to have to recreate this procedure for
every database that we create.

I am probably showing my ignorance but any ideas would be
appreciated.

Thanks in advance.

-- 
Michael McGarrigle   		Information Systems Division        
Email: mjm@gdwb.OZ.AU		Geelong & District Water Board
Phone: +61 52 262326		61-67 Ryrie St Geelong
Fax:   +61 52 218236		Victoria 3220 Australia
From: ctremblay@UMASSD.EDU
Newsgroups: comp.databases.ingres
Subject: Re: What is the best method to backup Ingres DataBase ?
Date: 19 Nov 92 14:51:26 GMT
Reply-To: ctremblay@UMASSD.EDU
Organization: UMASS DARTMOUTH, NO. DARTMOUTH, MA.

In article <C324A32A7A7F2003B9@ichcmns.cmns.mnegri.it>, OLIVIERI@ICHCMNS.CMNS.MNEGRI.IT (Marco Olivieri) writes:
>  1) What is the best method to backup Ingres DataBase ?
>
>We  work with  microVax 3600,  VMS 5.5-1  & 6.4/01  (vax.vms/01) and SUN/UNIX.
>Now the System Manager of the VAX does not BACKUP ingres DataBase,and I do the 
>CHECKPOINT on tape (TK70 - I checkpoint only 3 small DataBase) but not for all
>DataBase, now I would like  to change the Backup Method, in  order to obtain a 
>total security for data.
>
>What do you suggest ?
>
>Thanks in advance
>
>  Marco Olivieri
===========================================================================
Marco:
  I've been using the COPYDB instruction.  This instuction produces 2 SQL 
scripts: 1) to copy the data out, 2) to allow the data to be copied back
into the database along with the supporting views and grants. 
  The data and scripts are then copied to backup tapes as other flat 
files/tables are. The COPYDB command has several options available so that 
you can tailor it to your needs.
  Hope this helps. 
                 Claire Tremblay
Newsgroups: comp.databases.ingres
From: sfc@tpghq.com (Steve Caswell)
Subject: Re: 6.4/02 or 6.4/01, which version is the one available on SUN
Organization: Palmer & Associates, Inc., Norcross, GA
Date: Sat, 14 Nov 1992 16:52:48 GMT

In article <C7F1FB044DDF202E38@ichcmns.cmns.mnegri.it> OLIVIERI@ICHCMNS.CMNS.MNEGRI.IT (Marco Olivieri) writes:
>Hello, 
>
>I have a question for Ingres Users on SUN/UNIX.
>
>-    What was the previous version of 6.4/02 ?
>-    Was it the 6.3/02 ?
>-    Otherwise has any of you the version 6.4/01 ?
>
>The "ASK-ITALY" answered my request to switch from Ingres Version 6.3/02 to
>Ingres Version 6.4  saying  that the  distribution of  6.4/02 has begun in
>September and that version 6.4/01 is available not on SUN/UNIX, but only on
>VAX/VMS. 
>As a matter of fact, I have had the Ingres 6.4/01 since february on VAX/VMS,
>and it seems bizarre that 6.4/01 is not yet available on SUN.
>
>thank
>
>  Marco O.

There is in fact a 6.4/01 version available for SUN.  The version previous to
6.4/01 on the SUN was 6.3/02.

I think the confusion may have resulted from the fact that there was a
6.3/03 release for VMS that was not available on UNIX.

-- 

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: civil8@itakura.nuee.nagoya-u.ac.jp (Ito Labolatory(Civil. Eng.))
Newsgroups: comp.databases.ingres
Subject: Re : INGRES
Date: 15 Nov 92 23:49:22 GMT
Distribution: comp
Organization: Itakura Lab., Dept. of Elec. Eng., Nagoya Univ.

--

 --  $@L>8E20Bg3X(J $@>pJs9)3X2J(J $@HDAR8&5f<<(J  --  $@3aED(J $@>-;J(J (M2)
  
Newsgroups: comp.databases.ingres,comp.databases.sybase,comp.databases
From: cs_mj@gsbacd.uchicago.edu (Mark Jaeger)
Subject: re: Validating data imported from text files.
Organization: 
Date: Thu, 19 Nov 1992 19:42:18 GMT

In <18NOV199217192059@stars.gsfc.nasa.gov>, thompson@stars.gsfc.nasa.gov
(William Thompson, code 682.1, x2040) writes:

> I was just told something startling.  In an E-mail message from Myron China
> <mryo@ind_maroon.gwl.com>, I was told
> 
>    problem with flat file xfers is verifying successful completions of both
>    the dump and the import.  oracle products, for instance, always signal 
>    a 0 return code whether or not it had a problem.  so you end up spooling
>    log files and checking them for errors yourself.  we also check file
>    record layouts for validity before anything goes through.
> 
> That's an astonishing statement to me!  Our current plan calls for *ALL* data
> imported into the database to come from flat ASCII files generated by other
> programs.  Populating the database is supposed to be an automatic process that
> works unattended.  Problems are supposed to be signalled when they occur.
> 
> Is this the same with the other major SQL databases: Ingres, Sybase, Informix?

I can only speak for INGRES.  I think this reflects a bias in relational
databases in general and SQL in particular towards small transactions. 
In INGRES, bulk loads from flat files (using the SQL "copy table"
statement) are optimized for fast operation.  This means that, in
particular, all integrities on the table are ignored.  So you could end
up with data in the table that violates the integrities.  I think that
there are other properties of a table that are ignored by "copy", but
I'm not sure which ones (possibly unique indexes, enforcement of
noduplicates, or triggers and rules).

However, INGRES _is_ smart enough to detect certain kinds of errors, and
has options for (1) aborting the whole operation on the first error, or
after n errors; (2) continuing on errors and writing the bad input
records to another file.  If you choose the abort option (the default),
then I'm pretty sure that the "copy" statement returns an SQL error code
in the SQLCODE if there's an error.

Ingres recommends changing the storage structure of your tables to heap
(no index) before loading them with "copy table", and only _then_
applying indexing, integrities, etc.

If you want the full power of the database for enforcing rigid rules on
the data, then you will have to write a program to load the data one row
at a time, using the SQL "insert" statement instead.  This will give you
full error handling and assurance that what's in the table is what you
expect.  If you use INGRES's repeated queries, or database procedures,
the performance may not be bad either.  It would be interesting to do a
benchmark comparison of these.

--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: cs_mj@gsbacd.uchicago.edu (Mark Jaeger)
Subject: Re: Is it possible to get the first "n" records of a table or view ?
Organization: 
Date: Wed, 18 Nov 1992 19:50:25 GMT

In article <C4A55D13881F2037B8@ichcmns.cmns.mnegri.it>, 
Marco Olivieri <OLIVIERI@ICHCMNS.CMNS.MNEGRI.IT> writes:

> Is it possible to get the first "n" records of a table or view ?
> 
> I have a table with about 230000 records, through query, I want
> to read only the first 50 records, ignoring the other ones.
> Does any SQL function exist ? (I don't thinks, but I'm not sure)

I've attached a similar question and my response.  You can do it
directly in SQL if your table has the necessary design; otherwise, you
can do it in a cursor or select loop in the host language (4GL, C,
FORTRAN, etc.).

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

================================================================================
In article <1992Aug17.142452.24812@itm.uucp>, danny@itm.uucp (Danny Cox) writes:
> We get many requests for the 'top N' rows from
> a table.  How does one accomplish this in SQL?  Sorting is no problem,
> but how does one request the first N rows?  Obviously one could do an
> 'endloop' to stop once N is reached in 4gl/ESQLC, but is there a better way?

You can do this directly in a single SQL statement, if your table has a
column of unique values that defines the order.  I've attached a simple
example.  I won't say it's better, and in fact using a select or cursor
loop will probably give better performance in general.

================================================================================
select * from t order by id ;
+------+
|id    |
+------+
|    10|
|    20|
|    30|
|    40|
|    50|
|    60|
|    70|
|    80|
+------+

select * from t a where 3 >= ( select count(*) from t b where b.id <= a.id ) ;
+------+
|id    |
+------+
|    10|
|    20|
|    30|
+------+

select * from t a where 3 >= ( select count(*) from t b where b.id >= a.id ) ;
+------+
|id    |
+------+
|    60|
|    70|
|    80|
+------+

Newsgroups: comp.databases
From: mikes@vivanet.com (Michael Shea)
Subject: Foxbase app hangs
Organization: VIVATRON Corporation 
Distribution: country
Date: Fri, 20 Nov 1992 00:29:30 GMT
Followup-To: mikes@vivanet.com


I am having a real maalox moment...

This is the strangest thing I have ever seen.... I am writing a 
small app for a client in foxbase+ and it hangs when it Selects an
area.

Overview..
	selects 4 areas, a-d and opens files and indexes in each.
	starts in d and works through it sequentially.
	DO WHILE
		Gets a record from d
		selects a
		locates a record based on record from a
		If found
			opens c
			gets stuff from it
			opens b and writes to it...a new record


			SELECT A     <<< IT HANGS HERE.  dumps a 15 meg core on unix
								and sits and sits on dos.  :-(((

		I am going nutso.  Anyone ever see this before??

		I removed the .dbfs and idx's started clean.  Removed the
		line(s) and even rewrote the bastard twice.  

		I have a deadline on this I will not make if this goes on. :-(

		If some kind hearted net-soul could be of assistance....  :-)


		Thanks in advance.


		Mike Shea
		mikes@vivanet.com


Newsgroups: comp.databases
From: jon@zeus.med.utah.edu (Jonathan Byrd)
Subject: Re: Character supression/FoxPro 2.0
Date: Tue, 17 Nov 1992 17:26:08 GMT
Organization: University of Utah

In article <4f28_im00VQj48ZPJU@andrew.cmu.edu> Brandon Chin <bj+@CMU.EDU> writes:

   I'm using FoxPro 2.0 and I'm implementing a login screen.  The user
   enters a userid and a password.  How do I supress the keyboard echo or
   substitute it with a different character?  I need to do this so the
   user's password doesn't echo onto the screen.  I can't figure out how to
   do this in FoxPro 2.0.

From the FoxPro 2.0 Developer's Guide, page D14-29:
	``The blank (X) color is useful for entry of passwords.''

--
jonathan byrd
jon@apollo.med.utah.edu
Newsgroups: comp.databases,comp.databases.ingres,comp.databases.informix,comp.databases.oracle,comp.databases.sybase
From: thompson@stars.gsfc.nasa.gov (William Thompson, code 682.1, x2040)
Subject: Connectivity between databases
News-Software: VAX/VMS VNEWS 1.4-b1  
Organization: NASA/GSFC-Laboratory for Astronomy and Solar Physics
Distribution: usa
Date: Tue, 17 Nov 1992 21:09:00 GMT

I'm currently in the market for a Unix RDBMS, and the selected software needs
to be able to communicate with other people's databases which will probably be
from other vendors (Oracle and Sybase for certain).  I was looking for insight
as to how this would work, and whether people had any experience of how well
the different database products work with other SQL databases.  I want to hear
from users--I've already talked to the vendors.

What we would be doing would be to compare our databases against other people's
databases.  The database would contain information about our scientific
observations, and we would want to correlate our observations with the
observations of other instruments--e.g. when were we pointed at the same
target, etc.  The users would *not* be storing or updating any data in the
remote database--just looking at it.  In fact, I don't really expect the user's
to be writing to the local databases either, except for temporary tables used
to store the results of queries.

However, the database software will only represent a small fraction of the
activities that will be going on at our site (say 5-10%), so we don't want to
put a lot of manpower into putting together a sophisticated distributed
database.  We have also looked at transaction managers, and have decided that
those would be inappropriate since they require that everything can be
expressed in well-understood and predefined transactions--we want to keep a
lot of flexibility open in the system.

It seems that there are several ways to go about it:

	1.  The local database software could spawn a shell script which starts
	    a session on the remote database which extracts the requested data
	    and writes it to one or more flat ASCII files.  These ASCII files
	    are then imported to temporary tables in the local database and
	    manipulated locally.  This probably would be sufficient for our
	    needs.  Also, if we did this we could probably use any database
	    package, since (I believe) any of them can spawn OS commands, and
	    import/export ASCII text files.  Does anybody have any experience
	    working this way, and can comment on how well it works?

	2.  We could use gateway products from one vendor to another.  I
	    believe this requires buying additional software for at least one
	    of the machines.  I don't know how well these gateways work, and
	    expect that the gateways from one vendor are different from those
	    from another vendor.  I'd be interested in hearing about people's
	    experiences with gateways from Oracle, Ingres, Sybase, Informix,
	    etc., and whether they think one is better than another.

	3.  We could use 3rd party front-ends which have their own gateways.  I
	    don't know much about this either--up to now I've only been
	    studying the problem of the back end.

Thank you in advance,

Bill Thompson