HDTenEightyP/NetNews huggingface dataset:
From: "Anthony J. Rzepela" <rzepela@hal.hahnemann.edu>
Subject: Q: .RW spec finds no rows w/sent BETWEEN/IN clause
Organization: National Radio Astronomy Observatory
Date: Wed, 6 Jan 1993 15:18:21 GMT

If someone could please help, it would be appreciated.  My patience
is paper-thin at this point. 

setup: 		Version 6.3/03 on VMS 5.4-2 (MicroVAX 3500)

Tool:   	Report Writer

Statement:	seems that where clauses that use such predicates
        	as 'between' and 'in (itema,itemb,...)', while they work 
        	perfectly fine as a part of the .RW spec, bomb when the 
        	WHERE clause is sent as a replaceable parameter. 

Behaviour:      * No rows are found when a "WHERE column-name in 
                  ('itema','itemb')" is sent to the report writer to be 
                  substituted.
                * No rows are found when a "WHERE column-name between 
                  itema and itemb" is sent to the report writer to be 
                  substituted in the .QUERY statement. 

                In *BOTH* cases, rows are found when the *same exact* 
                string, quotes and all, is embedded as part of the original 
                spec. 

Parameters:     Report has been attempted from both the CALL REPORT in 4GL, 
                or opsys command REPORT, with the clauses on the command
                line. 
	
did u check:

* quote stripping? 
	
     Yes.  I used the flag to force a report header to be printed on 
     case of empty queries, and to print out what is sent as the 
     WHERE clause.  There, staring me in the face, is my beautifully 
     and carefully built clause, a clone of how it appears in my 
     clause-inclusive version, but not finding a single f*cking row.   

* presence of data?
 
     Of course.

Sorry for the obscenity (or near-obscenity) but I tore out a lot of hair 
and did a lot of revamping on the assumption that *I* was doing something
wrong.  The only positive experience was that in the process of RTFM I 
came across a Release Note on something unrelated that solved a different
problem. 

If anything in the statement is unclear, please let me know.  I need this 
problem resolved ASAP, and I made my ABF code such a mess in the 
diagnostic process, I can't hand over the problem to even my best brain here. 

----------------------------------------------
Anthony Rzepela    <rzepela@cvi.hahnemann.edu>
"What IS this fascination with Axl Rose? He looks so...unhealthy."  M.L.C. 1991
-------------------
From: salnick@dejavu.spk.wa.us (There is no substitute for displacement...)
Newsgroups: comp.databases.ingres
Subject: Re:  Help - ABF/4GL questions.
Date: 7 Jan 93 13:52:58 GMT
Organization: Not Organized

In article <1993Jan7.044714.10382@csc.canberra.edu.au> mmr@asgserver.canberra.edu.au (Micheal Rainford-Watson) writes:
>In article <00966285.BBAC44C0.3043@hal.hahnemann.edu> "Anthony J. Rzepela" <rzepela@hal.hahnemann.edu> writes:
>>In response to a messy locking situation where the user
>>GOLD@ILP.MIT.EDU (Mark D. Gold) wanted to avoid deadlock on 
>>a shared resource (a temporary table), it was pointed out 
>>by Mark Jaeger <cs_mj@gsbvax.uchicago.edu> that
>>
>>1> ABF has a neat lock detection and deletion feature.
>>
>>2> User-interrupts are not easily handled in the 4GL. 
>>

It seems that several people have missed a key issue here:  These 
temporary tables will be crerated in each of the users's contexts.  As a 
consequence, they will be PRIVATE tables.  No locking is required, since 
the tables are visible only to their creators, even if they all have the 
same name.

If they are created in the context of the DBA, then I have to ask "Why is 
it being done this way???"

bob

>>In relation to the first matter, I have had the experience where
>>an interrupted (^Y, ^C) session of ABF still exists as a lock, 
>>as the locks from these "dead" sessions show up until explicitly 
>>deleted by the new ABF user.  (I am at 6.3/03 on VMS 5.4-2). 
>>
>>What would be really slick (and I don't know about feasibility)
>>would be to include in the application a user-maintined lock system, in which 
>>the application desiring a resource could check not only for one of these
>>pseudo-locks, but also, if found, the status of the process that created it.
>>(Is it still running, in a PFW, etc.?) 
>
>... keep going ..
>
>And if the resource is being held by a user (for too long), they are 
>informed that someone is waiting for that resource and they should
>'get on their bike!'.
>
>-- 
>Micheal Rainford-Watson        _--_|\   E-Mail: mmr@asgserver.canberra.edu.au
>Administrative Systems Group  /      \  Phone : +61 6 201 2397
>University of Canberra        \_.--.*/  Mail  : PO Box 1 BELCONNEN ACT 2616
>^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^v^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^

--
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: david@ittpub.nl (David P. Morgan)
Newsgroups: comp.databases.ingres
Subject: Ingres and TCP/IP
Date: 7 Jan 93 18:42:27 WET+0100
Organization: ITT Publitec R+D BV, Amsterdam


We have an Ingres application on VAX/VMS and a database on SunOS. The two
systems communicate via CMUTEK TCP/IP. Except for Ingres.

Does Ingres support CMUTEK ?
They say they are certified for Wollongong but does that preclude CMUTEK ?

Advice and/or hints would be greatly appreciated.

Thanks in advance

--------------------------------------------------------------------------------
David P. Morgan                        Internet: david@ittpub.nl
ITT Publitec R+D BV                    UUCP:     ...!sun4nl!ittpub!david
Hoekenrode 1                           PSI:      020412905761212::DAVID
1102BR Amsterdam                       Phone:    +31-20-5676737
Netherlands                            Fax:      +31-20-6910374
Newsgroups: comp.databases.ingres
From: raph@panache.demon.co.uk (Raphael mankin)
Subject: Re: DB admin tools 
Distribution: world
Organization: Solvfield Ltd.
Reply-To: raph@panache.demon.co.uk
X-Mailer: Simple NEWS 1.90 (ka9q DIS 1.19)
Date: Sat, 9 Jan 1993 11:42:16 +0000

For those who asked me for a copy of my DB unload/restructure program:

If you have not received a copy within then next day or so, please mail me
again with your email address in clear in the body of the message. In some
cases the message header was mangled and I could not reply to you.

--------------
Raphael Mankin			Nil taurus excretum
From: ninab@zucchini.macc.wisc.edu (Nina Boss)
Newsgroups: comp.databases.ingres
Subject: Tech Support
Date: 11 Jan 93 15:14:31 GMT
Organization: University of Wisconsin Academic Computing Center

I'm just wondering is ingres advisor still available by telnet to  
advisor.ingres.com?  Is tech support available this way?  Thanks.

--
Nina Boss
Madison Academic Computing Center-University of Wisconsin 
Internet: ninab@macc.wisc.edu,
NeXTmail w/attachments: ninab@zuchinni.macc.wisc.edu
Newsgroups: comp.databases.ingres
From: hlam@bnr.ca (Hayward Lam)
Subject: NeXT User Group Of Ottawa Meeting on January 7th
Reply-To: hlam@bnr.ca (Hayward Lam)
Organization: Bell-Northern Research Ltd.
Date: Tue, 5 Jan 1993 20:17:19 GMT

NeXT User Group of Ottawa Meeting on January 7th
------------------------------------------------


When : Thursday, 7:00pm
Where: ComputerActive
       21 Antares Dr., Unit 112,
       Ottawa, Ontario, Canada


Topics: 
***  Database on NeXT  ***
Demo and discussion on databases and development tools 
available on NeXT.
Inlcude Parabase, Sybase, Oracle, DBkit, Objective DBtool kit etc.
Topic will be oriented for users and developers alike.
Demo machine is a NeXTcube with NeXTdimension board.

(A guest will talk about their experience with database 
development. Not confirmed yet.)


***  General discussion  ***
CD-ROM drive available for 3.0 upgrade.
Software packages discount for user group members.
NeXTWorld Expo etc.


Please pass the news around to whoever might be interested.
Feel free to contact me if you have any questions.


Regards,
Hayward

phone: 613-763-3663
email: hlam@bnr.ca
From: salnick@dejavu.spk.wa.us (There is no substitute for displacement...)
Newsgroups: comp.databases.ingres
Subject: Re: SQL where claus limitations
Date: 7 Jan 93 13:50:06 GMT
Organization: Not Organized

In article <1993Jan6.220615.2523@bmw.mayo.edu> buntrock@mayo.edu (Jim Buntrock) writes:

I for one would be VERY interested in what Ingres Tech Support said on 
this one...

>I have been writing a retrieval application that generates a dynamic 
>where clause for a select statement.  Depending on complexity of the query
>this where-clause can get quite lengthy.  I know this query
>may be written differently, however, I am working with a dynamic 
>query generator, which may produce thousands of different where-clauses.  The
>following where-clauses are just a few examples:
>
>  1> select *
>  2> from sirsworld s
>  3> where
>  4>        (s.proc = '14.24' and s.diag = '100')
>  5>    or  (s.proc = '14.25' and s.diag = '200')
>  6>    or  (s.proc = '14.26' and s.diag = '300')
>  7>    or  (s.proc = '14.30' and s.diag = '400')
>  8>    or  (s.proc = '14.31' and s.diag = '500')
>  9>    or  (s.proc = '14.32' and s.diag = '600')
> 10>    or  (s.proc = '14.33' and s.diag = '700')
> 11>  order by 1, 2
>E_OP0302 too many boolean
>    factors defined in query - query too complex
>    (Wed Jan  6 10:38:40 1993)
> 
>End of Request - Terminated by Errors
>-----------------------------------------------------------------
>If I add two more conjunctions I get the following error:
> 
>  1> select *
>  2> from sirsworld s
>  3> where
>  4>        (s.proc = '14.24' and s.diag = '100')
>  5>    or  (s.proc = '14.25' and s.diag = '200')
>  6>    or (s.proc = '14.26' and s.diag = '300' )
>  7>    or (s.proc = '14.27' and s.diag = '301' )
>  8>    or (s.proc = '14.28' and s.diag = '302' )
>  9>    or  (s.proc = '14.30' and s.diag = '400')
> 10>    or  (s.proc = '14.31' and s.diag = '500')
> 11>    or  (s.proc = '14.32' and s.diag = '600')
> 12>    or  (s.proc = '14.33' and s.diag = '700')
> 13>  order by 1, 2
>E_OP0002 optimizer ran out of
>    memory before generating execution plan
>    (Wed Jan  6 10:41:01 1993)
> 
>End of Request - Terminated by Errors
>------------------------------------------------------------------- 
>I have tried increasing the memory of the QEP and still run into the
>OUT of memory error.  My concern is with the error of - E_OP0302 too 
>many boolean factors defined in query - query too complex -
>Does anyone know the limit of the number of boolean factors?  Can this 
>be changed?  Is this a finite limitation of Ingres?  Is the limit based
>on conjunctions or disjunctions?  Any suggestions?
>
>///////////////////////////////
>James Buntrock
>Analyst/Programmer
>Medical Information Resources
>Mayo Clinic
>200 First Street SW
>Rochester, MN 55905
>email - buntrock@mayo.edu
>///////////////////////////////
>
>Keywords: 

--
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: thomasl@mtl.mit.edu (Thomas J Lohman)
Subject: Re: Shared Memory Address Bug, Ingres on Sun 4.1.3
Organization: MIT Microsystems Technology Laboratories
Date: Fri, 8 Jan 1993 16:37:17 GMT

In article <9301071943.AA09853@somnet.Sandia.GOV> drcoles@somnet.sandia.gov (Dwight R Coles) writes:

>Ingres (ver 6.4/02/00) fails to iistartup properly on Sun 4.1.3
>due to a bad shared memory address.  This bug popped up at 4.1.3,
>as things were OK under 4.1.2 and earlier.  You will recognize it
>by the following output from the step in iistartup which 
>"allocates shared memory":
>
>To fix this, set the Ingres variable II_LG_MAP_ADDR to 10000000.
>Example:
>
>	ingsetenv II_LG_MAP_ADDR 10000000
>

Just a related question, what is the latest release of Ingres for
SUNOS?  Is this bug fixed in a later release?  We just upgraded our 
production system to 6.4/01 for SUNOS, and will eventually be porting
things over to SUNOS 4.1.3.  I assume, according to Ingres' production
release model that 6.5 should be out within four months or so.

thanks,


--tom
From: candy-gregory@cs.yale.edu (Gregory Candy)
Newsgroups: comp.databases.ingres
Subject: Public Domain INGRES
Date: 12 Jan 1993 09:26:47 -0500
Organization: /homes/graduates/candy/.organization
NNTP-Posting-Host: swan.zoo.cs.yale.edu

Can anyone tell me where I can anonymous-FTP the public domain
version of INGRES.  An earlier posting made reference to 
ingres.tar.Z.  I am also interested in having INGRES locally for
my research.

Thanks in advance,

-- Greg Candy (candy@cs.yale.edu)

Newsgroups: comp.databases.ingres
From: zmbenhal@netcom.com (Zeyd M. Ben-Halim)
Newsgroups: comp.databases.ingres
Subject: Re: Public Domain INGRES
Date: 13 Jan 93 00:00:07 GMT
Article-I.D.: netcom.1993Jan13.000007.2059
Organization: Netcom - Online Communication Services (408 241-9760 guest)

In article <1iukf7INN8cu@SWAN.ZOO.CS.YALE.EDU> candy-gregory@cs.yale.edu (Gregory Candy) writes:
>Can anyone tell me where I can anonymous-FTP the public domain
>version of INGRES.  An earlier posting made reference to 
>ingres.tar.Z.  I am also interested in having INGRES locally for
>my research.

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

>Thanks in advance,
>
>-- Greg Candy (candy@cs.yale.edu)
>


Zeyd
From: richard@asis.unimelb.edu.au (Richard Begg)
Newsgroups: comp.databases.ingres
Subject: Re: Running Ingres using Unix Cron
Date: 13 Jan 1993 02:02:17 GMT
Organization: University of Melbourne
NNTP-Posting-Host: mulgulgum.asis.unimelb.edu.au
Keywords: Ingres Cron

cbignell@zia.aoc.nrao.edu (Carl Bignell) writes:

|I have been trying to run an Ingres report using the unix Cron
|facility so that some report files can be automatically updated on a
|daily basis.  I use the report <database> <reportname> feature of
|ingres inside of an executable unix script.  If I run this script
|manually it works correctly.  If I set this up as a Cron job it does
|not work even when I preface all files with appropriate paths.  Since
|others have had problems making ingres programs (e.g. embedded SQL and
|4GL) run under Cron I wanted to find out if there is a way to make
|this feature work.  If the job cannot be run automatically the
|usefulness of the ingres report writer goes to zero in this
|application.  I would appreciate any help on this matter.  Thankyou.

It might help if you could tell us in what way the report doesn't work.
What, if any, error messages are produced?  What version of Ingres you are
running? What platform etc.

My guess is that the environment is not correct.  All Ingres applications
will require at least the II_SYSTEM variable to be set.  Setting the
PATH variable might also help.  Cron jobs do not supply much of
an environment by themselves.

--
--
Richard Begg (richard@asis.unimelb.edu.au)
Admin Systems and Info Services - University of Melbourne.
Newsgroups: comp.databases.ingres
From: maintadm@zia.aoc.nrao.edu (Maintenance Admin.)
Subject: How to display 132-character lines?
Organization: National Radio Astronomy Observatory, Socorro NM
Date: Fri, 8 Jan 93 17:58:36 GMT

We have a 4GL application which tries to read an ASCII file containing
132-char records using "call system ('less ' + filename);".  For some
reason INGRES wants to display only 80-char lines and folds the
output.  Even when I set the screen width to 132 chars INGRES seems to
intercept the command and displays only 80 chars.
How do I tell INGRES to use 132-char lines?


Newsgroups: comp.databases.ingres
From: raph@panache.demon.co.uk (Raphael mankin)
Subject: Re: DB admin tools 
Distribution: world
Organization: Solvfield Ltd.
Reply-To: raph@panache.demon.co.uk
X-Mailer: Simple NEWS 1.90 (ka9q DIS 1.19)
Date: Wed, 6 Jan 1993 21:15:21 +0000

In article <1993Jan5.004315.1@gsbacd.uchicago.edu> cs_mj@gsbacd.uchicago.edu writes:

>In article <ROBM.92Dec22120335@ishtar.Berkeley.EDU>, 
>robm@ishtar.Berkeley.EDU (Rob McNicholas) writes:
>
>> I'm working on a database which is in a constant state of flux.
>> Necessity dictated that we put it into production before we had really
>> worked out all the problems, so I often find myself dropping and
>> recreating tables to add a new field, or change a field's size or
>> type, etc.  After doing this once or twice, I quickly learned that
>> there are many side effects of these kinds of changes.  For example,
>> dropping a table causes any views, forms, or permits which referred to
>> that table to be destroyed also, so the DBA needs to create scripts to
>> recreate all the different pieces, and remember to update these
>> scripts whenever a change is made anywhere.  Unfortunately, Ingres
>> doesn't seem to provide any tools to help make this kind of change
>> easier.  I've been using unloaddb and then editing the scripts to
>> recreate just the parts i need, but this is tedious, and it doesn't
>> handle forms or views very well.
>> 
>> I've been thinking about writing my own tools that would access the
>> system catalogs and help find all references to a particular table or
>> field, so that these changes would be easier to manage.  But before I
>> do it myself, I ask:
>> 
>> Does anyone have any suggestions for any Public Domain or commercial
>> products which would provide this kind of functionality?
>
I have a program that will unload an Ingres or Oracle 6 database into an SQL
stream. It unloads tables and views (selectively or totally), with or   without
the data. If anyone wants the code I can email it.

Using this prog it is relatively easy to alter the attributes of a table.

-- 
Raphael Mankin			Nil taurus excretum
Newsgroups: comp.databases.ingres
From: leath@UPEI.CA (Steve Leath)
Subject: Re: DB admin tools
Organization: University of Prince Edward Island, CANADA
Date: Tue, 12 Jan 1993 13:33:48 GMT

 The copydb tool has long been inadequate to the
>task, really since version 6, when INGRES first started dropping views
>when you drop a table.
>
>I have attached a query that I wrote to find the dependencies on a given
>table, although I won't vouch for its accuracy.  It only goes one level
>deep, also, so it won't catch a view that is defined on a view.  But
>it's a start.
>
>--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.
>
>
Schemadef_II supplied by Ingres in version 6.4 can add and delete columns 
and modify column formats while saving data, indexes, views, rules , 
permissions and integrities.

Steve  leath@upei.ca
From: anders@cmdsf.UUCP (Anders Nicolausson)
Newsgroups: comp.databases.ingres
Subject: Re: Q: .RW spec finds no rows w/sent BETWEEN/IN clause
Summary: The Quotes!
Date: 9 Jan 93 01:13:42 GMT
Organization: Construction Market Data, Inc.

In article <00966334.5A9D35E0.4200@hal.hahnemann.edu>, rzepela@hal.hahnemann.edu (Anthony J. Rzepela) writes:
> If someone could please help, it would be appreciated.  My patience
> is paper-thin at this point. 
.
... stuff deleted
.
> did u check:
> 
> * quote stripping? 
> 	
>      Yes.  I used the flag to force a report header to be printed on 
>      case of empty queries, and to print out what is sent as the 
>      WHERE clause.  There, staring me in the face, is my beautifully 
>      and carefully built clause, a clone of how it appears in my 
>      clause-inclusive version, but not finding a single f*cking row.   
> 
.
... stuff deleted
.

You still may want to look into the proper quoting of your
parameters. This is actually quite complex, but there is
a document you can obtain from Tech Support called
"How to Pass Complex Parameters in the CALL REPORT statement". 
This doc is almost 10 pages long so there are quite a few things
to say about this.


Anders Nicolausson
CMD, San Francisco
From: amjohnso@slate.mines.colorado.edu (JOHNSON AMY )
Newsgroups: comp.databases.ingres
Subject: porting ingres to ULTRIX V4.2A
Date: 11 Jan 93 22:48:33 GMT
Organization: Colorado School of Mines

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.

So I have ftp'ed the public domain version of ingres "ingres89.tar.Z" .
Has anyone successfully ported this ingres to AIX or Ultrix?  Is it
worth my time?

Thanks,
Amy Johnson
Department of Geological Engineering
Colorado School of Mines
From: salnick@dejavu.spk.wa.us (There is no substitute for displacement...)
Newsgroups: comp.databases.ingres
Subject: Re: Transaction Log File
Date: 8 Jan 93 14:00:35 GMT
Organization: Not Organized

In article <1993Jan7.145532.4404@sei.cmu.edu> djk@sei.cmu.edu (David Kaplan) writes:
>
>I'm having some intermittent problems with the Trasaction Log File.  Or,
>rather, it's having trouble with me?  In either case, the following error
>occurs when running a rather long set of queries:
>
>**** ERROR: E_US1262 Your transaction has been aborted due to the transaction
>    log file having reached one of the limits set by the system administrator.
>    These limits are log_full, force_abort, and 90 percent of force_abort
>    when using the fast_commit option to start DBMS servers.
>   (Thu Jan  7 12:21:39 1993)
>
>What's this all about.  I mentioned intermittent because some days I get the
>error, and other days I don't?!  There are commits after each query (all
>creation and insertion commands), and the queries are broken up just about as
>far as we can get them.
>
>Could this error be an indicator that something else is wrong?  The fact that
>it is intermittant EVEN when the data being used has not change is what really
>has me puzzled.

In an Ingres installation, it is normal for all transactions to be made 
against the log file instead of the actual database (fast commit thread 
moves stuff from the log to the disk).  What this means is that the log 
file has to be large enough to hold everything which is going on 
simultaneously.

The fact that you have an intermittent problem only tells me that you 
have different sets of concurrent users (no surprise there). 

Before anyone could judge whether there is something wrong, it would be 
instructive to know how big your log file is...

BTW, you can change it via the iibuild script.

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