ingres@philmtl.philips.ca (Ingres Group) (04/24/89)
Hello:
I am in need of some INGRES help and I was wondering if there is
someone out there who could help me.
I am "in charge" of converting one of our own locally
written utilities (EQUEL/Ingres based) from BSD UNIX 4.1 (which is
running on our old machine) to Ultrix (which is running on our new
machine) and I am having a problem which i can't resolve given the
documentation which came with the version of INGRES on Ultrix.
Our system is a VAX (model 6210) running Ultrix 32 V3.0 (Rev 64).
The version of Ingres we are running on the VAX 6210 (as indicated by the
login prompt from Ingres) is INGRES version 7.10 (10/27/81).
The version of Ingres we are running on our older VAX (as indicated by the
login prompt from Ingres) is INGRES version 7.7 (03/xx/81).
We also wrote a few simple EQUEL/Ingres utilities whose only purpose is
to initialize the database to be manipulated.
All utilities were recompiled without any problems.
The database was created using as indicated in my documentation.
I then run our own "little" utilities to create/initialize the database
relations. These utilities noth ran through to completion without an
error of any kind.
But when I try to run our Ingres database application I get the following
error message on my terminal:
EQUEL ERROR: 3 with parameters: RETRIEVE users
after which, the utility hangs until it is orcefully killed by my
pressing the BREAK key.
Please note that if I invoke Ingres (instead of our Ingres application)
I can successfully retrieve information from the database (names of all
relations, format of relations, content of relations). So my question
is what is going wrong ??
I traced the error down to the following EQUEL statements within my
.q file:
initialize()
##{
## char *u_id;
## long u_group;
## range of u is users
## retrieve (u_group = u.#user_group)
## where u.#user_id = uid
The definition (of the "users" relation) is as follows:
Relation: users
Owner: ingres
Tuple width: 9
Saved until: Fri Jan 1 00:00:00 1999
Number of tuples: 1
Storage structure: paged heap
Relation type: user relation
attribute name type length keyno.
user_id c 8
user_group i 1
Let me also state that:
-----------------------
(1) EQUEL error message was NOT in any of my online documentation.
(2) while following through with the Tutorial some of the error messages
that i got were not as the tutorial said they would be. So, does this
indicate that the version of Ingres that we are running is out of
date ??
Several questions:
------------------
(1) What is the significance of the "3" in the error message ??
- is it refering to the 3rd in the sequence of the 3 lines of the retrieve
operation ??
(2) Where should I look in the on-line documentation for a description
of the error message (perhaps in my search I did not check all the
appropriate files).
If you require any further details please do not hesitate to contact me
at any time.
Thanks in advance for any help you can offer me.
P.S. (you can also reply to users "barry" or "root" on
system ...!uunet!philmtl)
--
Ingres Group: ...!uunet!philmtl!ingres ( ingres@philmtl)
phone: (514) 744-8200
To boldy go where no software has gone before.