HDTenEightyP/NetNews huggingface dataset:
From: marcusen@oodis01.af.mil (Contractor Chad Marcusen)
Newsgroups: comp.databases.ingres
Subject: QBF won't accept quel permits
Date: 19 Aug 92 16:49:32 GMT
Organization: Hill AFB, Utah
X-Newsreader: Tin 1.1 PL4


The QBF interface in 6.3 appears to run only sql underneath.  So when I
implement quel permissions that cannot be converted to sql, because they have
a "where" clause, I get an error.  For example if I use the permissions listed
at the bottom of this note, start up with "qbf ima6 -t people" as the user
okimoto, and run a blank query I get the following error message:
 ____________________

	SELECT on table people: no GRANT or GRANT compatible permit exists.
	(E_US0DAE)

 ____________________


I want QBF to use quel so that more complex permissions can be implemented. 
^^^^^^^^^^^^^^^^^^^^^^

Does anyone know how to force QBF to use QUEL rather than SQL underneath?

... II_DML_DEF works for ABF and RBF but not QBF
... ING_SET_DBNAME won't allow anything but set commands

I have a table with the following permissions and fields:

vvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvv

/* This is a QUEL script. */

create people(
	roffice=c6 not null with default,
	lastname=c15 not null with default,
	firstname=c12 not null with default,
	ssan=c9 not null with default,
	grade=c5 not null with default,
	afsc=c20 not null with default,
	topsecret=c1 not null with default,
	secret=c1 not null with default,
	hmaddress=c70 not null with default,
	hm_phone=c12 not null with default,
	wk_phone=c12 not null with default,
	emaddress=c8 not null with default
)
with noduplicates,
location = (ii_database)
\p\g
copy people () from "/user5/ima/imaadm/people.ima"
\p\g
\quel
range of people is people
define permit  all on people to lipscomb where people.roffice = "SC*"
\p\g
\quel
range of people is people
define permit   all on people to okimoto where people.roffice = "SC*"
\p\g
Newsgroups: comp.databases.ingres
From: leath@atlas.cs.upei.ca (Stephen Leath)
Subject: Aggregates Updates in SQL ?
Originator: leath@atlas.cs.upei.ca
Organization: University of Prince Edward Island
Date: Tue, 18 Aug 1992 13:51:02 GMT


How does one update a table with an aggregate function and a group by clause
in sql ? I would like to sum a column in one table by another column and
update a table with the result. 

In quel it would be:
          replace table_1(x=sum(table_2.y by table_2.z 
                            where table_1.z = table_2.z)) 
            where table_1.z = table_2.z

In oracle sql :
           update table_1 a
               set x = (select sum(y) 
                           from table_2 b
                           where a.z = b.z
                           group by z);

Thanks in advance 
Steve
leath@upei.ca
From: dwolfe@halcon.lerc.nasa.gov (Dana Wolfe)
Newsgroups: comp.databases.ingres
Subject: Full log file while doing deletes ?
Date: 20 Aug 92 14:20:18 GMT
Organization: NASA/LeRC


	I have several large tables (  > 60MB ) from which I would 
	like to delete about 15% of the rows. I continue to get the log
	file full error, and was wondering if there is a way aound this.
	The manual suggests increasing the size of the log file but,
	if I understand the instructions,  the size of the resulting log 
	file seems unacceptable. 

	Thanks. 

-- 
----------------------------------------------------------------------
Dana Wolfe,  MS 142-1		voice: 	  (216) 433-8270
NASA Lewis Research Center	fax:   	  (216) 433-8000 
21000 Brookpark Rd		internet: dwolfe@halcon.lerc.nasa.gov
Cleveland, OH  44135			   
----------------------------------------------------------------------
Newsgroups: comp.databases.ingres
From: jrawles@leland.Stanford.EDU (jody rawles)
Subject: ingres vs postgres vs university ingres ?
Organization: DSG, Stanford University, CA 94305, USA
Distribution: ca
Date: Thu, 13 Aug 92 01:12:56 GMT

I need to set up a small relational database on a Sun 670 MP (10-20 users).
I was wondering if anyone could briefly explain the differences between
postgres, ingres, and university ingres.  I would be nice if it had a GUI
that worked under OpenWindows 3.0, but it is  not necessary.

To anyone who might have responded to my most recent postings
plese accept my apologies for reposting but all mail sent to 
this address in the last two weeks got lost in a forwarding loop.

Thanks for responses, double thanks if this is your second time
replying to this request.


-- 
Jody M. Rawles					
Department of Psychiatry 		email: jrawles@leland.stanford.edu
Stanford University School of Medicine	voice: (415) 858-3914
Stanford, CA 94305 USA			fax:   (415) 493-4901
Newsgroups: comp.databases.ingres
From: kasvand@ccrs.emr.ca (Tony Kasvand)
Subject:  Ownership problem. ABF application  
Organization: Canada Centre for Remote Sensing, Ottawa
Date: Thu, 20 Aug 1992 16:11:18 GMT


  I have an image (and running executable) application which won't let other 
users execute and use this program. They keep receiving this error at the
beginning:  

xlqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqk
xx SELECT on table special_users_table: no GRANT or GRANT compatible permit   x
xx exists. (E_US0DAE)                                                         x
xx (Tue Aug 18 09:02:21 1992)                                                 x
xx                                                        [PRESS RETURN]      x
xmqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqj


  I want my application to be open to everyone. My database says it is a 
public database and the ownership is under my name.
  Since I am "owner" the database, I don't run into this problem.

  I am using ABF/4GL Ingres 6.4 . 

  OK, so I try to grant privileges to my database. I put this command into 
the Default Frame ABF/4GL code (is it correct to do this? ...apparenty not)..

grant db_admin on database tonis_ccrs_database to public;

    The error I receive is:

qqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqk
 x You cannot GRANT or REVOKE database or installation privileges             x
 x  while in session with this database.                                      x
 x  Ensure your session is connected to the iidbdb database. (E_US188A)       x
 x (Tue Aug 18 08:59:52 1992)                                                 x
 x                                                        [PRESS RETURN]      x
 mqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqj

 I don't know where to find iidbdb .



     While in ABF/4GL menus editing the application, i've tried to unlock  
the database in menu options Utilities.LockStatus by using Delete which
should unlock the database (at least that what the Help says) but :


qqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqk
 x You may not delete your own session.                                       x
 x  The row you are positioned on is the one corresponding to your own edit   x
 x session.  You may not delete locks corresponding to that session.          x
 x (E_AB00A6)                                                                 x
 x                                                        [PRESS RETURN]      x
 mqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqj



      Does someone have some words of wisdom on how to solve my problem?


THANK YOU IN ADVANCE.







-- 
Tonis Kasvand      | " The only Canadian secret the world may be interested  
Ottawa, Canada     | to discover... How can Canadians party all night and   
kasvand@ccrs.emr.ca| still function in the morning! "    
                                  - The Royal Canadian Air Farce  
Newsgroups: comp.databases.ingres
From: alan@curta.cc.columbia.edu (Alan Crosswell)
Subject: Re: ESQL Bug
Organization: Columbia University
Date: Thu, 20 Aug 1992 21:30:16 GMT

Following up on Marg Jaeger's comment, if you do find that you are
filling the log, try throwing a commit in every few hundred rows.
Here's a code segment that I find useful (note that commit closes
any open cursor so you have to reopen it):

 exec sql declare s cursor for
    select xstud.* from xstud,xstudtodo
      where xstudtodo.studpid = xstud.studpid
        and stepcompleted < :mystep;
  for (n=0; 1; n++) {
    if (n%100 == 0) {
      exec sql commit;
      exec sql open s for readonly;
      printf("\r%8d students done.",n);
      fflush(stdout);
    }
    exec sql fetch s into :xstud;
    BREAK_NOT_FOUND;
    ...
    exec sql update xstudtodo
        set stepcompleted = :mystep
          where studpid = :xstud.studpid;
  }

(BREAK_NOT_FOUND is a #define of if (sqlca.sqlcode == 100) break)

Note that I update the table the cursor is over so that it won't
get the same rows next time it is opened.

I can control-C this sucker anytime during its processing of my 36,000
row table and restart it with no problems.  At worst, only 100  
transactions will get rolled back which doesn't take too long.  What's
really a pain about filling the transaction log file is waiting for it
to get rolled back when the transaction gets aborted. Putting a commit
each time through the loop is too slow.  Putting it every N times
where you pick whatever N makes you happy means when the system crashes
after your job has been running for 3 hours, you only loose a few minutes
work instead of all of it.
/a
From: waetzig@bcstec.ca.boeing.com (Todd Waetzig)
Newsgroups: comp.databases.ingres
Subject: Re: SQL 'like' command with case insensitivity?
Summary: If you are always comparing to a constant as in your example try using
	 the following
	 select * from tablea where col like '%\[Yy\]\[Ee\]\[Ss\]%' escape '\'
Date: 12 Aug 92 18:11:37 GMT
Organization: Boeing Computer Services, Seattle

In article <1992Aug12.002043.1970@candle.uucp>, root@candle.uucp (Bruce Momjian) writes:
> I need to do an SQL statement where I need pattern matching that is
> case-insensitive.  In both SQL and 4GL, this statement is illegal:
> 
> 	select *
> 	from tablea
> 	where uppercase(col) like '%YES%';
> 

-- 
Todd Waetzig		Programmer/Analyst 	Boeing Computer Services
T. Wa. :=>					 waetzig@bcstec.boeing.com
From: ron@sigyn.cs.athabascau.ca (Ron Haukenfrers)
Newsgroups: comp.databases.ingres
Subject: Re: Dynamic FRS
Date: 19 Aug 92 04:20:30 GMT


Thanks for all the tips.  The best solution that I could work out was to 
disect the ingres "FRAME" structure and mess around with pointers and such
at the C level before handing the structure to ADDFORM.  If there is enough
interest, I will post my solution to the net when I get back from vacation
in September....(Also gives staff a chance to find some more of the bugs :-)


Thanks Again


Ron
--
Ron Haukenfrers		VE6RWH				     *********
ron@sigyn.cs.athabascau.ca				    **********
							   .      ****
Athabasca University 	Educational Computing Services	  ..      ****
P.O. Box 10 000						 ....     ****
Athabasca, AB CANADA	(403)675-6332			..........****
Newsgroups: comp.databases.ingres
From: sfc@tpghq.com (Steve Caswell)
Subject: Re: how to add a new location ?
Organization: Palmer & Associates, Inc.
Date: Mon, 17 Aug 1992 22:30:30 GMT


>Hi All,
  >I've tried to add a new db location using the AccessDb utility.
  >But it didn't add a new location despite all my attempts.
  >How do you add a new location ?
  >I'm using ingres version 6 under ultrix 4.3 on a DecStation 5000.
  >I'd appreciate any help.

         >Thanks in advance,
              >Ofer Reshef. (ofer@chen.bgu.ac.il)

If you could include the errors you are getting from accessdb, that would help
diagnose the problem.  Some things to keep in mind when adding a location:

   1.  Be sure you create the directories correctly.  You have to get the
       directory path correct or INGRES cannot use the location.  There are
       actually two ways to create an alternate location under UNIX.  The
       first is to create the path under an existing path.  Or you can create
       a brand new path as the alternate directory.  In either case, you must 
       name the paths correctly.

   2.  You must also set the correct protections on the directory path you
       create.  If either of these items is incorrect, the location might not
       be created.
Check the Installation and Operations Guide for the exact details on creating
the directory and setting protections.  I apologize for not giving more details,
but I am traveling and I don't have an I&O Guide with me.

Hope this helps.



-- 

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: Gavin Trigg <gavin@asis.unimelb.EDU.AU>
Subject: Re: SQL 'like' command with case insensitivity?
Organization: National Radio Astronomy Observatory
Date: Thu, 13 Aug 1992 15:29:47 GMT

> 
> I need to do an SQL statement where I need pattern matching that is
> case-insensitive.  In both SQL and 4GL, this statement is illegal:
> 
> 	select *
> 	from tablea
> 	where uppercase(col) like '%YES%';
> 
> It complains about the 'like'.  I have called Ingres.  The tech first
> thought it was an easy solution, then he talked to some people and
> basically says it's a limitation.
> 
> The only two workarounds I can think of are to add another column that
> always has 'col' as uppercase, or in 4GL to attach a block of code to
> the select and for every row, uppercase the field, and then compare with
> a select.
> 
> In QUEL, it was easy, but that's another topic.
> -- 
> Bruce Momjian                      |  830 Blythe Avenue
> root%candle.uucp@bts.com           |  Drexel Hill, Pennsylvania 19026 
>                                    |  (215) 353-9879(w)  853-3000(h)
> 
Bruce,

Another alternative is to create view of tablea with col as uppercase(col).

-- 
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: billc@Ingres.COM (Bill Coffin)
Subject: Re: IPM (and thanks)
Reply-To: billc@ingres.com
Organization: Ingres, An ASK Company, Alameda CA
Date: 18 Aug 92 21:56:03 GMT

In article <AA22211.199208171653.ttyB3@turing.ncl.ac.uk> Cristyn Emmett  
<Cristyn.Emmett@newcastle.ac.uk> writes:
> I have said to several people that we don't have IPM here with our
> Ingres 6.3/01.
> Well, I have recently discovered that we do (all the help files are
> empty, but the executable is there) so all I have to do now is sit
> down with the documentation and try to understand it :-)

The 6.3 IPM is in the SIG directory, and has some bugs.  In 6.4,
IPM became a fully supported Ingres product and was moved to the
bin directory.  Also, as of 6.4 there is a real IPM Manual, help files,
far fewer bugs, and many improvements.

We've had some bug reports on IPM, and it (almost) always turns out 
to be a case of someone running the 6.3 IPM against a 6.4 server.
IPM is very sensitive to server version, even the 6.3/02 IPM crashed 
when running against a 6.3/01 server.

Anyway, 6.4 is a great release, and IPM is just one more motivation
for upgrading.
From: gavin@asis.unimelb.EDU.AU (Gavin Trigg)
Newsgroups: comp.databases.ingres
Subject: Re: how to add a new location ?
Date: 18 Aug 92 15:02:37 GMT
Organization: National Radio Astronomy Observatory

> 
> Hi All,
>   I've tried to add a new db location using the AccessDb utility.
>   But it didn't add a new location despite all my attempts.
>   How do you add a new location ?
>   I'm using ingres version 6 under ultrix 4.3 on a DecStation 5000.
>   I'd appreciate any help.
> 
>          Thanks in advance,
>               Ofer Reshef. (ofer@chen.bgu.ac.il)
> 
This is all documented in Chapter 4 of the Database Administrator's Guide.
I used it for the first time recently with no problem to create locations
ii_database_2 and ii_checkpoint_2.

What *PRECISELY* didn't work?  Did Accessdb say all was okay?  If not, which
step failed?

-- 
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: cs_mj@gsbacd.uchicago.edu (Mark Jaeger)
Subject: Re: automatically compressing your checkpoints
Organization: 
Date: Tue, 18 Aug 1992 20:38:51 GMT

In article <1992Aug17.190721.1934@news.columbia.edu>, 
alan@curta.cc.columbia.edu (Alan Crosswell) writes:
> I thought some of you running Ingres 6.x under Unix might be interested
> in my version of cktmpl.def:

Thanks, Alan!

After reading this it occurred to me that some of you VMS 5.x and INGRES
6.x users might be interested in my version of ckp_to_disk.com (located
in ii_system:[ingres.files.checkpoint]), which I have attached.  

The most significant change is the addition of the "set rms_default"
command.  The change in block_count improved the speed of disk
checkpoints _very_ significantly (by a factor of 2 or 3).  The change in
extend_quantity also gives a significant improvement.  At our site:

	wall time		30-35%
	cpu time		~25%
	direct i/o count	30-35%

It cuts down on the number of i/o operations it takes to create a really
big save set (e.g., 400 megabytes), which has to be extended a bunch of
times.  The down side is that the save set can be temporarily allocated
to a size 65,535 VMS disk blocks larger than its ultimate size, so you
need more free space on the disk.  This temporary over-allocation is
released when the operation is completed and the destination save set is
closed.  If you don't have enough free space, then you can adjust the
value downward and still get a benefit.

Credit for these ideas goes to Robert Spatz, who works in the Center for
Research in Security Prices.

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

================================================================================
$!  CKP_TO_DISK.COM -	Script to copy a database directory to disk for
$!			a checkpoint.
$!
$!	p1 = database directory to be copied
$!	p2 = full pathname of checkpoint file to be written
$!
$!  ===========================================================================
$!
$ show time
$ set rms_default /block_count = 127 /extend_quantity = 65535
$ show rms_default
$!
$ show status
$ backup 'p1'*.* 'p2'/save/prot=(s:rwed,o:rwed,g,w)/nocrc/group=0
$ backup$status = $status
$ show symbol backup$status
$ show status
$!
$ set rms_default /block_count = 0 /extend_quantity = 0
$ show rms_default
$!
$ exit backup$status ! ckp_to_disk.com

Newsgroups: comp.databases.ingres
From: pneal@ingres.com (Calgary (Kal-gree), (403) 262-8119)
Subject: RE: how to add a new location ?
Organization: National Radio Astronomy Observatory
Date: Mon, 17 Aug 1992 21:08:08 GMT

New locations for extending a database across multiple locations, are definitely
done via accessdb.  The only confusing part is that the complete Ingres path
must be set up first!

ie: to create a new location data2 on /data2 the following path would have to be
    set up ...  /data2/ingres/data/default

    make sure the .../data directory has permissions set to 700

Cheers,

Paul

From:	PONY::"tjb@MATH.AMS.ORG" 16-AUG-1992 22:33:24.80
To:	info-ingres@MATH.AMS.ORG
CC:	
Subj:	how to add a new location ?

Hi All,
  I've tried to add a new db location using the AccessDb utility.
  But it didn't add a new location despite all my attempts.
  How do you add a new location ?
  I'm using ingres version 6 under ultrix 4.3 on a DecStation 5000.
  I'd appreciate any help.

         Thanks in advance,
              Ofer Reshef. (ofer@chen.bgu.ac.il)
From: oen@oms16.cfsat.honeywell.com (Dan Oen)
Newsgroups: comp.databases.ingres
Subject: Where to get a copy of ingperl
Keywords: ingperl
Date: 17 Aug 92 19:19:05 GMT
Distribution: na
Organization: Honeywell Air Transport Systems Division

A while back I saw someone mention a version of Perl that had 
Ingres extensions.  I've looked a a few anonymous ftp sites, and 
have yet to find a copy.  Does anyone know where I can find
it?


-- 
_________________________________________________________________
Daniel Oen             
(602) 436-5085
oen@saifr00.cfsat.honeywell.com        
Newsgroups: comp.databases.ingres
From: A.Hobson@bradford.ac.uk
Subject: Cursors & embedded SQL
Organization: National Radio Astronomy Observatory
Date: Thu, 13 Aug 1992 15:14:01 GMT


			Cursors in C with Embedded SQL
			------------------------------

	I want to create a switch() in C which has approximately 25 cases,
	each with a different DECLARE CURSOR FOR SELECT ....
	But I want to use the same FETCH statement for all the cursors I have
	created as they all produce the same number & type of columns. 

	I've tried using the same cursor name for each DECLARE but ESQLC claims 
	there are multiple declarations. So then I tried substituting a C 
	variable for the cursor, ie. DECLARE :csr[n] CURSOR FOR .....
	and then FETCH :csr[n]. But it still treats all the DECLAREs as the same
	and fails.

	Is there a simple answer ?

	I thought of using dynamic SQL but it looks really tricky.


		Thanks,

			Andy Hobson :-)


	PS. I can supply the chunk of source code if that's of any help !
Newsgroups: comp.databases.ingres
From: J.S.Stephenson@qmw.ac.uk (J.S.Stephenson)
Subject: Re: Ingres on Solaris 2.0
Organization: National Radio Astronomy Observatory
Date: Wed, 19 Aug 1992 23:52:09 GMT

> 
> Does anyone know if Ingres 6.4 runs/will run under Solaris 2.0?
> If not, any idea if/when it will?
> 
> Horace
> horace.bowser@txqis.amd.com
> 
 In theory Ingres 6.4 is available for Solaris 2.0 now, sort of.  At least
 Solaris 2.0 on a SPARC system: I don't know about Intel Solaris 2.0.  This
 is because 6.4/01 is available (and believed to be on its way to us) for
 the ICL/Fujitsu DRS SPARC systems, and the DRS is claimed to be fully
 binary compatible with Solaris 2.0.  The DRS is an odd sort of Sun clone
 in that ICL only sell it with a System V Release 4 operating system, and
 have never been prepared to provide SunOS4 compatibility.  So if the
 manufacturer's claim is true it should be technically possible to install
 the DRS Ingres 6.4 on a Solaris 2.0 Sun with no changes.  Though of course
 something as entwined with the operating system as Ingres would be one of
 the toughest possible tests of binary compatibility.  We're not in a
 position to try it here at present: we can't upgrade our Suns to Solaris
 2.0 because of all the other applications software, apart from Ingres,
 that the suppliers are taking their time over producing Solaris
 implementations of.  But if anyone might be able to try it we'd be
 interested to hear about any problems.  Or even success.
-- 
                                                            Jonathan Stephenson

                                    Telephone: +44 71 739 2089 (direct line)
 Electronic mail:                            | Facsimile: +44 71 975 5500
 J.S.Stephenson@QMW.AC.UK or, if that fails, | Post:
 JANet:                                      | The Computing Services
 J.S.Stephenson@UK.AC.QMW                    | Queen Mary and Westfield College
 Internet:                                   | University of London
 J.S.Stephenson%QMW.AC.UK@NSFNET-RELAY.AC.UK | Mile End Campus
 EARN/BITNET:                                | 327 Mile End Road
 J.S.Stephenson%QMW.AC.UK@UKACRL             | London
 UUCP:                                       | E1 4NS
 ...uknet!qmw!J.S.Stephenson                 | UNITED KINGDOM