HDTenEightyP/NetNews huggingface dataset:
From: alan@curta.cc.columbia.edu (Alan Crosswell)
Newsgroups: comp.databases.ingres
Subject: "Table xxx is either not a view or its definition is unavailable"
Date: 1 Oct 92 13:31:44 GMT
Organization: Columbia University

Oh good.  I restored a database with rollforwarddb, dropped a couple tables,
and now find that views based on those tables are still laying around and
are undroppable! 

help view person1write\g
Executing . . .

Table person1write is either not a view or its definition is unavailable


continue
* drop view person1write\g
Executing . . .

E_US1265 Database reorganization activity has rendered the query plan
    invalid.  Try again after the db activity is complete.  In case of dynamic
    SQL, the statement must be prepared again. 
    (Thu Oct  1 09:13:26 1992)

Maybe I should admit that this is after ingres failed hard with:

      ::[1136            , 00A13C00]: Tue Sep 29 10:52:41 1992  
E_RD000C_USER_INTR       User interrupts while requesting DMF function.
      ::[1136            , 00A13C00]: Tue Sep 29 10:52:41 1992  
E_DM0065_USER_INTR       User interrupt forced DMF operation abort.
      ::[1136            , 00668CE0]: Tue Sep 29 11:01:56 1992  
E_RD000C_USER_INTR       User interrupts while requesting DMF function.
      ::[1136            , 00668CE0]: Tue Sep 29 11:01:56 1992  
E_DM0065_USER_INTR       User interrupt forced DMF operation abort.
      ::[1136            , 006A2040]: Tue Sep 29 11:01:57 1992  
E_RD0034_RELEASE_SEMAPHORE       Error releasing ULH semaphore
      ::[1136            , 006A2040]: Tue Sep 29 11:01:57 1992  
E_SC0028_SEMAPHORE_DUPLICATE     Attempt to set a semaphore which is currently  
set by requester.
      ::[1136            , 006A2040]: Tue Sep 29 11:01:57 1992  
E_SC0024_INTERNAL_ERROR  Internal SCF coding error.

The above is because things seemed to get hung due to a bunch of frontends
interacting badly so we killed off the frontends. Things stayed hung, so
we tried to iishutdown but iidbms was not responding so we had to eventually
resort to a "simulated hardware failure" (kill -9 of the iidbms process).
The archiver, etc. did seem to shut down cleanly.

I was experimenting with cloning this database prior to this happening too, so  
I can conclude that I certainly got what I deserved.

I don't really know exactly what I did to break things, but I would have  
expected the rollforward to have saved me.

Versions are SunOS 4.1.2 on a SS2 and INGRES SunOS Version 6.4/01 (su4.u42/01).

And no, I don't have a support contract so I don't really expect help
from ASK/Ingres although anybody with pointers on how to get back to a
consistent state will gladly be listened to!  Thanks.

/a
Newsgroups: comp.databases.ingres
From: michaelh@g2syd.genasys.com.au (Michael Haldey)
Subject: Re: Embedded SQL
Keywords: C
Organization: Genasys II, Sydney, Australia
Date: Mon, 5 Oct 1992 13:11:53 GMT

In article <s1110238.718108025@giaeb> s1110238@giaeb.cc.monash.edu.au (Lee Hollingworth) writes:
>As a computer science student I have been given an assignment requiring embedded
>SQL using either Cobol or C as the host language.
>
>We have been given some sample code for use with Cobol, but nothing has been
>made available yet for C.  Being an impatient soul, I was wondering if some
>kind Ingres programmer could e-mail a "typical" example of some C code with
>embedded SQL.
>
>I am a reasonable C programmer, but need advise regarding the actual includes
>(if required) and the EXEC SQL statements...
>
>Lee Hollingworth
>s1110238@giaeb.cc.monash.edu.au

The INGRES  esql/C companion guide contains 3 examples. (Addendum A,B,C)

michael
-- 
Michael Haldey  |  Genasys II Pty Ltd
                |  13th Level, 33 Berry St, North Sydney, NSW, Australia
                |  Phone:    +61-2-954-2878 (-9930 FAX)
                |  Internet: michaelh@g2syd.genasys.com.au
Newsgroups: comp.databases.ingres
From: walraven@athena.research.ptt.nl (Walraven H.G.)
Subject: Destroydb and checkpoints warning
Summary: Destroydb destroys your checkpoint too
Keywords: checkpoint, destroydb
Organization: PTT Research
Date: Fri, 2 Oct 1992 08:48:53 GMT


For your information,

I am using the Ingres checkpointing mechanism for database backup.
Because my databases are not very big (< 50 Mb) I do my checkpointing
to another disk instead of tape.

I discovered that the destroydb command to destroy an entire database
does not only destroy your database but your checkpoints too!

So accidentally destroying the wrong database is a large problem
because you lost your backups too.

I hope you use this to your advantage.

I think this is the case for all Ingres release on al operating systems, but
I am using Ingres rel. 6.4 on VAX/VMS 5.5.

Eric Walraven
DBA, PTT Research, The Netherlands
From: alan@curta.cc.columbia.edu (Alan Crosswell)
Newsgroups: comp.databases.ingres
Subject: SQL TM \nocontinue
Date: 26 Sep 92 18:46:05 GMT
Organization: Columbia University

Am I doing something wrong, misunderstanding something, or does \nocontinue
not actually work as documented in the SQL terminal monitor:

DAG# sql sid                         
INGRES TERMINAL MONITOR -- Copyright (c) 1981, 1992 Ingres Corporation
INGRES SunOS Version 6.4/01 (su4.u42/01) login Sat Sep 26 14:44:14 1992

continue
* \nocontinue
go
* xxx\g
Executing . . .

E_US09C4 Syntax error on line 1.  Last symbol read was: 'xxx'.
    (Sat Sep 26 14:44:21 1992)

continue
* select count(*) from todosteps\g
Executing . . .


+-------------+
|col1         |
+-------------+
|            5|
+-------------+
(1 row)
continue
* \q
Your SQL statement(s) have been committed.

INGRES Version 6.4/01 (su4.u42/01) logout
Sat Sep 26 14:44:33 1992

I got the same behavior setting II_TM_ON_ERROR=terminate.

/a
Newsgroups: comp.databases.ingres
From: sfc@tpghq.com (Steve Caswell)
Subject: Re: Ingres Null Indicator Un-documented Feature
Organization: Palmer & Associates, Inc.
Date: Wed, 30 Sep 1992 13:14:27 GMT

Undocumented? I don't think so.  Try page 3-15 of the INGRES/SQL Reference
Manual, Release 6.4, December 1991, and I quote:

"When INGRES retrieves a character string into a host variable too small to
hodl the string, INGRES truncates the data.  (If the data was retrieved from
the database, INGRES sets the sqlwarn1 field to 'W').  If the host variable
has an associated indicator variable, then the indicator is set to the
original length of the data.  For example, the following statement will set
the variable char_ind to 6 because it is attempting to retrieve a 6-character
string into a 3-byte host variable, char_3:

   exec sql select 'abcdef' into :char_3:char_ind;"

-- 

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: cs_mj@gsbacd.uchicago.edu (Mark Jaeger)
Subject: Re: Problem with $ckpdb in 6.4/02/00
Organization: 
Date: Mon, 28 Sep 1992 22:37:57 GMT

In article <543*white@arc.ab.ca>, Lloyd White <white@arc.ab.ca> writes:
> After upgrade to INGRES 6.4/02/00 (on VMS 5.4-2) all datbases successfully.
> 
> $ckpdb -l -u$ingres iidbdb 
> 
> fails with the following errors (same in errlog.log)
> 
> II_JSP...E_DM1100_CPP_BAD_LOCATION	
>          Error checkpoint database, unusable location found.
> II_JSP...E_DM110B_CPP_FAILED	
>          Error occurred checkpointing the database.
> 
> INGRES account has lots of quota, and $ingres doesn't exist 
> 
> Looks like its now checking for diskquota on the checkpoint volume

Here are some suggestions that may help.

Don't forget that when you run ckpdb, you create files in three
locations: checkpoint, journal, and dump locations for the database.  In
the case of "iidbdb", these are ii_checkpoint, ii_journal, and ii_dump. 
These can point to different devices, each with their own quota.

Try running with "set verify" turned on.  You may be able to see where
it gets hung up.

Since the "$ingres" username doesn't exist, INGRES has to make up a user
to own the files.  If you ran this from the "ingres" account, then
presumably the files are owned by "ingres".  I always use "-s" instead
of "-u", because I can never remember who the dba is for any given
database, and I'm too lazy to look it up in iidatabase.

> Quick solution $set proc/priv=exquota, each time you do iidbdb

Depending where the problem happens, you might be able to put this in
ii_system:[ingres.files.checkpoint]ckp_to_disk.com.

> Also for those that normally checkpoint to tape, they had to be
> set up with a quota. Could put exquota on DMFJSP in iistartup.com.

This may be because of the ii_journal or ii_dump devices.

--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: ossbb@.abg (Bernd Beisel)
Newsgroups: comp.databases.ingres
Subject: Grammar for Ingres SQL
Date: 5 Oct 92 13:32:09 GMT
Organization: PSI Boschweg 6 8750 Aschaffenburg


For my undergraduade project work, a "Pretty Printer for C sources with
enbedded SQL", I require a BNF-Grammar of Ingres SQL for inclusion in YACC.

----------------------------------------------------------------------------
  PSI                      e-mail:  ossbb@oss1.abg.psi.DE
  Bernd Beisel             Fax   :  49 - 6021/492-112
  Boschweg 6               Phone :  49 - 6021/492-589
  8750 Aschaffenburg
----------------------------------------------------------------------------
Newsgroups: comp.databases.ingres
From: mevans@Ingres.COM (Mike Evans)
Subject: Re: Windows4gl question on \n
Date: 30 Sep 92 15:50:16 GMT

Sunil,
    There are several system constants to support both printable and
non-printable characters in the Appendix of the Language Reference Manual.

    HC_DOUBLEQUOTE
    HC_QUOTE
    HC_SPACE

    HC_FORMFEED
    HC_TAB
    HC_NEWLINE

    The last constant is the one you're interested in.
    To build up a varchar variable from variables, string literals, and
some of the constants above, you might use the following 4GL:

    strinvar = 'This is the 1st line' + HC_NEWLINE + 'This is the 2nd line' +
		HC_NEWLINE + 'The value of some variable = ' + varchar(somevar);

    The other system constants listed above would be used the same way
as HC_NEWLINE in the example.

> This is a rather elementary question but I can't find any relevant
> documentation. In Windows4gl, how can I represent a newline
> in a varchar variable?
> 
> I did a find a roundabout way of reading a \n from a file
> into a stringobject and then into a varchar. But it ought to
> be more straightforward than that.
> --
> -------------------------------------------------------------
> 
> The only safe generalization: All generalizations are unsafe.
> 
> Sunil Nariani
> Network Analyst
> G008	OUC             My opinions are exactly that, MY opinions.
> Univ of Notre Dame.
> (219) 239-8575
> (219) 271-1514
> 
> --------------------------------------------------------------
Newsgroups: comp.databases.ingres
From: dhubb@sierras.com (David Hubbell)
Subject: Windows4GL 2.0
Organization: Sierra Software, Friant, CA
Distribution: usa
Date: Tue, 6 Oct 92 22:34:27 GMT

Ingres has announced Windows4GL Version 2.0.  Does anybody know what the
expected _ship_ date is?
-- 
  /\/\ David B. Hubbell                          VOICE/FAX: 209.822.2768
 /~/\~\ Advovcate Systems/Sierra Software         INTERNET: dhubb@sierras.com
/____\_\ PO Box 347 3950 East Marcus St., Friant, CA 93626-0347
Xref: sparky comp.databases.ingres:1481 comp.databases.theory:497
From: mxy6045@hertz.njit.edu (Madhumathi Sudhakar)
Newsgroups: comp.databases.ingres,comp.databases.theory
Subject: INGRES TERMINAL SETTINGS; AT&T 630
Date: 29 Sep 92 02:23:10 GMT
Organization: New Jersey Institute of Technology, Newark, N.J.
Originator: mxy6045@hertz.njit.edu

Newsgroups: comp.database.ingres
Subject: TERMINAL SETTING FOR INGRES ON AT&T 630 TERMINAL
Followup-To: 
Distribution: world
Organization: New Jersey Institute of Technology
Keywords: 

Hi,
	I would like to know how I should set my terminal (which is
an AT&T 630) to access the INGRES menu and utilities?


	Any help will be highly appreciated.


	Please direct all replies to me or to  sxc1625@hertz.njit.edu. 

Thanks in advance,
Madhumathi Sudhakar
Xref: sparky comp.databases.ingres:1513 comp.unix.programmer:4849
From: chris@visionware.co.uk (Chris Davies)
Newsgroups: comp.databases.ingres,comp.unix.programmer
Subject: Re: Catching division by zero
Date: 2 Oct 92 08:12:45 GMT
Organization: VisionWare Ltd., Leeds, UK
X-Newsreader: Tin 1.1 PL5

Yesterday I asked if anyone could help me track down a problem with
Ingres 6.4 ignoring division by zero errors.

For example, "SELECT 1/0" returns 0 rather than <error>.

The answer was supplied by Chris Amidei of ASK/Ingres who pointed out
that the '-xw' options could also be supplied on the EXEC SQL CONNECT
line, viz

	EXEC SQL CONNECT :dbname OPTIONS = '-xw';

Many thanks Chris.  I've summarised here because I thought the rest of
you might like to know too.

Chris
--
            VISIONWARE LTD, 57 Cardigan Lane, LEEDS LS4 2LE, England
  Tel +44 532 788858 x238.  Fax +44 532 304676.  Email chris@visionware.co.uk
---------- "VisionWare:   The home of DOS/SQL/UNIX/X/VMS integration" ---------
From: richard@asis.unimelb.EDU.AU (Richard Begg)
Newsgroups: comp.databases.ingres
Subject: Reportwriter parameters
Keywords: reportwriter
Date: 29 Sep 92 07:08:20 GMT

We appear to have hit an undocumented limit on the length of parameters
passed into reportwriter.  Everything is fine up to 256 characters per
parameter, after that it starts truncating.

Has anyone else noticed this?  Any other ideas for passing paramers?

In case anyone is interested, what we are passing (amongst other things) is
a dynamically constructed where clause from a query screen.

--
Richard Begg (richard@asis.unimelb.edu.au)
Admin Systems and Info Services - University of Melbourne.
Newsgroups: comp.databases.ingres
From: nariani@zen.cc.nd.edu (Sunil Nariani)
Subject: Windows4gl question on \n
Reply-To: nariani@zen.cc.nd.edu (Sunil Nariani)
Organization: University of Notre Dame, Notre Dame
Date: Sun, 27 Sep 1992 07:13:21 GMT

This is a rather elementary question but I can't find any relevant
documentation. In Windows4gl, how can I represent a newline
in a varchar variable?

I did a find a roundabout way of reading a \n from a file
into a stringobject and then into a varchar. But it ought to
be more straightforward than that.
-- 
-------------------------------------------------------------

The only safe generalization: All generalizations are unsafe.

Sunil Nariani
Network Analyst
G008	OUC             My opinions are exactly that, MY opinions.
Univ of Notre Dame.
(219) 239-8575
(219) 271-1514

--------------------------------------------------------------
Newsgroups: comp.databases.ingres
From: cs_mj@gsbacd.uchicago.edu (Mark Jaeger)
Subject: Re: SQL TM \nocontinue
Organization: 
Date: Mon, 28 Sep 1992 22:09:15 GMT

In article <1992Sep26.184605.113@news.columbia.edu>,
alan@curta.cc.columbia.edu (Alan Crosswell) writes:
> Am I doing something wrong, misunderstanding something, or does \nocontinue
> not actually work as documented in the SQL terminal monitor?

I had exactly the same reaction you did.  The problem came in
understanding exactly what \nocontinue actually means.  As near as I can
figure, it means that the TM will not continue executing across SQL
statements in the same buffer, after an error.  However, execution
continues for the next statement after the \go.

If you have two SQL statements separated by a semicolon and the first
one gives an error, then the second won't get executed.  Once you
have done \go and entered a new statement, the buffer has been cleared
and the error status of the previous statement has been forgotten.

If you want _real_ error handling, then you'll have to write a program.
Either that, or you'll have to put _all_ your SQL statements in one
query execution buffer (no \go directives), with one \go at the end.
I guess Ingres wants to sell more ABF and precompilers.  8^)

I've attached a test program and an extract of the output.  Notice that
in the first case (\nocontinue), only the first statement runs; in the
second case (\continue), both statements run, even though we still see
the error.

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

================================================================================
$ sql iidbdb
\nocontinue
xxx ; select count(*) from iidbconstants \g
\continue
xxx ; select count(*) from iidbconstants \g

================================================================================
\nocontinue
* go
xxx ; select count(*) from iidbconstants \g
* Executing . . .

E_US09C4 Syntax error on line 1.  Last symbol read was: 'xxx'.

continue
\continue
* go
xxx ; select count(*) from iidbconstants \g
* Executing . . .

E_US09C4 Syntax error on line 1.  Last symbol read was: 'xxx'.

+-------------+
|col1         |
+-------------+
|            1|
+-------------+
(1 row)
continue

Newsgroups: comp.databases.ingres
From: sfc@tpghq.com (Steve Caswell)
Subject: Re: Ingres Null Indicator Un-documented Feature
Organization: Palmer & Associates, Inc.
Date: Thu, 1 Oct 1992 13:33:09 GMT

>In article <1992Sep30.131427.8180@tpghq.com>, sfc@tpghq.com (Steve Caswell) 
>writes:
>> Undocumented? I don't think so.  Try page 3-15 of the INGRES/SQL Reference
>> Manual, Release 6.4, December 1991, and I quote:
>> 
>> "When INGRES retrieves a character string into a host variable too small to
>> hold the string, INGRES truncates the data.  ... If the host variable
>> has an associated indicator variable, then the indicator is set to the
>> original length of the data.
>
>Granted it's there if you read far enough, but see also p. 3-13 of the
>same manual:
>
    >If the value retrieved is not a null, then the indicator variable is
    >set to 0 and the value is assigned to the host variable.
>
>I agree with Steve that it's unfair to say that the behavior is
>completely undocumented, but I think it's also _fair_ to say that the
>documenation could be beefed up somewhat.  E.g., make an explicit
>statement about how to test for null versus not null (indicator is -1
>versus not -1); or add a section call "How to Use Null Indicators in
>Applications".  
>
>I also think it's misleading to call it an "indicator" variable.  I was
>certainly misled at first and failed to realize that this "indicator"
>could take on more than just two different values.
>
>--Mark Jaeger				internet: cs_mj@gsbvax.uchicago.edu
>Graduate School of Business		yellnet:  (312) 702-0328
>University of Chicago			faxnet:   (312) 702-0233
>
Good points from Mark.  The most disappointing aspect of all of this is that
Technical Support apparently didn't know that this feature was already
documented and logged a doc bug.

-- 

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: alan@curta.cc.columbia.edu (Alan Crosswell)
Newsgroups: comp.databases.ingres
Subject: cloning a database
Date: 29 Sep 92 13:54:01 GMT
Article-I.D.: news.1992Sep29.135401.7778
Organization: Columbia University

Is there any way to use a checkpoint of a database to clone it?  I want to
avoid having to do an unloaddb and reload of a large database which I want
to clone into a test copy.  Given that I've already taken a checkpoint of
my db, it seems natural to want to just use that tar file to populate the clone
rather than copying all those tables out again....
/a
Newsgroups: comp.databases.ingres
From: chris@visionware.co.uk (Chris Davies)
Subject: Catching division by zero
Organization: VisionWare Ltd., Leeds, UK
Date: Thu, 1 Oct 1992 09:04:12 GMT


I'm using C with embedded SQL (Ingres 6.4/01 on Sun4 SunOS 4.1.2).

The problem I've got is that Ingres doesn't warn me when I get an
integer division by zero error in a SELECT statement, it just returns
0.  (The floating point stuff returns 0.Inf - an IEEE representation of
infinity.  Yuk!)

For example, "SELECT 1/0" shows this problem (you can try it in sql or
isql too).

After speaking with a member of Ingres Technical Support, who logged an
enhancement request for me, they pointed out the '-xw' flag for the sql
and isql terminal monitor applications.  (This flag terminates queries
with /0 and generates an error - just like I would have expected in the
first place.)

Now for the question.  Can anyone explain to me _how this flag works,
and if so, how could I go about implementing this kind of error
handling in my code?

Ta,
Chris
--
            VISIONWARE LTD, 57 Cardigan Lane, LEEDS LS4 2LE, England
  Tel +44 532 788858 x238.  Fax +44 532 304676.  Email chris@visionware.co.uk
---------- "VisionWare:   The home of DOS/SQL/UNIX/X/VMS integration" ---------
Newsgroups: comp.databases.ingres
From: horst@faui63.informatik.uni-erlangen.de (Horst Luehrsen)
Subject: Re: Suche Ingres/Windows4GL Programmierer in Dortmund
Organization: CSD., University of Erlangen, Germany
Date: Fri, 2 Oct 1992 09:09:13 GMT

mdchaney@fractal.ucs.indiana.edu (M Darrin Chaney) writes:

> Raghu=Ram%Supplier%IM=Hou@bangate.compaq.com writes:
> >Could someone translate this posting so that many of us who could 
> >not comprehend, try to help the desparate soul if he / she is 
> >really in need of something urgently !!

> I think you're just curious :)

> Seriously, though, if the desparate soul was that desparate, don't you think
> he'd have had someone translate it into English, also?  He's looking for a
> Ingres/W4GL programmer.  I assume that it's in German because he'd like
> someone who knows German.
[...Jede Menge Kram geloescht...]
> Oh well, I don't know much German, but you get the drift.
Gar nicht so schlecht, die Uebersetzung - selten so gelacht!

> 	Darrin
> -- 

> mdchaney@iubacs mdchaney@bronze.ucs.indiana.edu mdchaney@rose.ucs.indiana.edu

> "This is a .signature."
Prima! Beste .signature der Woche!

	Horst

 Horst Luehrsen <luehrsen@informatik.uni-erlangen.de> |
 Martensstrasse 3, W-8520 Erlangen                    | Kein Spruch
 Tel: +49-9131-857884  Fax:+49-9131-32090             |
Newsgroups: comp.databases.ingres