ghorne@novavax.UUCP (Greg Horne) (02/04/86)
As a newcomer to Ingres, I have a few questions for anyone out there who
can help. We are running RTI version 3.0/17 on a VAX 11/780 under VMS.
We also have RTI version 2.1/15VE.03 on a VAX 11/780 under BSD4.2, but are
not using it extensively at this time.
1. Does anyone know how to rename a table? For example:
range of x is oldtablename
retrieve into newtablename (x.all)
destroy oldtablename
This works, but takes up space. How about the "relation" and
"attribute" tables? Could they be altered without making a
physical copy of "oldtable"?
2. Let's say we have two tables named tableA and tableB. Each table
has two attributes named column1 and column2. These attributes
have exactly the same names, data types and lengths in each table.
What is wanted is a subset of tableA. The subset would consist of
all of the rows in tableA which do NOT have a matching row in tableB.
We merely want to print these rows on the terminal. One way to do
this is as follows:
range of a is tableA
range of b is tableB
retrieve into tableC (a.all)
range of c is tableC
delete c where (
c.column1 = b.column1 and
c.column2 = b.column2)
print tableC
Does anyone know of a different or more efficient way of extracting
this subset of data?
3. Does anyone know a way to extract the name of the database in use
during an Ingres session? Is there a constant like #usercode etc.?
4. Can anyone recommend a list of useful books and/or papers on Ingres?
The areas I am most interested in are application development (ABF,
OSL, EQUEL/C) and Ingres internals.
Any help or ideas you can provide will be greatly appreciated!
Thanks,
Greg Horne
Nova University Computer Center
3301 College Avenue
Fort Lauderdale, FL 33314
...{allegra, ucf-cs, neoucom}!novavax!ghorne