HDTenEightyP/NetNews huggingface dataset:
From: camidei@Ingres.COM (Chris Amidei)
Subject: Re: Encryption
Organization: Ingres, an ASK Company, Alameda CA 94501
X-Newsreader: Tin 1.1 PL3
Date: 12 Jan 93 16:51:44 GMT

crb@advtech.uswest.com (Chris Renck) writes:
: We are developing a application which is going to contain salary information,
: and I was wondering if anyone has any suggestions on how the salary field
:  can be encrypted or secure so only authorized people can see it.  Our Human 
: Resources Dept does not even wants us (the Ingres developers) to be able to
: see what data is in this field.
: 

How about taking a queue from Unix and the Shadow Password concept.  User
information that is viewable is stored in one file that everyone can read
while other information that should not be viewable by everyone (ie. passwords)
is stored in another file only readable by those who need the information.

With Ingres, the same can be done.  One table contains globably viewable 
information, the other would contain salary information that is viewable only
by those who should.  Create database procedures to add, remove and modify
employees, thus helping to ensure integrity.

For Applications, make the salary display field 'invisible' to those who should
not see the information.

Or, you could create a view through which most users access data through.
This view would NOT contain the salary column.

--
The last thing the bungee jumper heard: Gee, I thought I was next?
------------------------------------------------------------------------
Chris Amidei		| E-mail: camidei@ingres.com
Instructor        	|  Phone: (510)748-3261 - my desk
Ingres, an Ask Company	|       : (510)769-1400 - main line
Newsgroups: comp.databases.ingres
From: sethg@dcatlas.dot.gov (Seth Grimes)
Subject: Re: Ingres and TCP/IP
Organization: U.S Dept. of Transportation
Date: Fri, 8 Jan 1993 07:53:50 GMT

david@ittpub.nl (David P. Morgan) writes:

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

Do CMUTEK have a Wollongong emulation mode?  TGV/Multinet does, and that's
how you can use it with Ingres/Net.

Seth, grimes@oecd.fr 
Newsgroups: comp.databases.ingres
From: levanon@browneyes.ucs.indiana.edu (Jacob Levanon)
Subject: Help Facility with embedded SQL 
Keywords: help, Embedded SQL 
Reply-To: levanon@browneyes.ucs.indiana.edu (Jacob Levanon)
Organization: University Computing Services/Indiana University
Date: Thu, 7 Jan 1993 16:42:58 GMT


--
Greetings:
	I am looking for a public domain software that provides a help
facility (something equivalent to the help facility in the monitor or
isql) implemented using embedded SQL (preferably Dynamic SQL).

Thanks.

 /====================================================================\
|| Jacob Levanon                   /\            Network Applications ||
|| University Computing Services   ||             levanon@indiana.edu ||
|| Indiana University              ||                  (812) 855-2598 ||
|| 750 N. State Road 46-Bypass     ||  ...reserved for                ||
|| Bloomington, IN  47405          \/                   future use... ||
 \====================================================================/

Newsgroups: comp.databases.ingres
From: mmitchel@elm.Berkeley.EDU (Michael Mitchel)
Subject: Re: problem with "DESC" as column name in Windows4GL
Reply-To: mmitchel@elm.Berkeley.EDU (Michael Mitchel)
Organization: Bull HN Information Systems Inc., Phoenix Product Division
Distribution: comp
Date: Fri, 08 Jan 93 15:42:54 GMT

In article <FRANKS.93Jan8155235@ntrc27.ntrc.ntu.ac.sg>, franks@ntrc27.ntrc.ntu.ac.sg (Frank Siebenlist) writes:
|> 
|> If a column name of "DESC" is used,
|> then it seems "difficult" to access that column within Windows4GL.
|> 
|> For example a script containing:
|> 
|> 	select :my_field = desc
|> 	from my_table;
|> 
|> yields compilation errors like:
|> 
|> E_W40118 The symbol 'desc' is undefined.
|> 
|> E_PW0005 Can't create variable for desc.
|>     A variable couldn't be declared for the ENTRYFIELD desc.  A subsequent
|>     error should give more information about why it couldn't be created.
|> 
|> E_SY0010 Reserved word used as name.
|>     A variable (or other kind of object) was given the name `desc' which is
|>     a reserved word.  You can not use a reserved word to name an object.
|> 
|> This is too bad, but it becomes worse if:
|> 
|> 		:my_field = my_table.desc
|> 
|> yields the same error.
|> 
|> As far as I know, DESC is not a reserved word for column names.
|> Also, other ingres programs like isql have no problem with: 
|> 	select desc from my_table;
|> 
|> Is Windows4GL too restrictive? Is this a feature or bug?
|> 
|> Is there a workaround?
|> 
|> Please don't tell me to rename my column names!
|> (They are predefined by other existing applications.)
|> 
|> Regards, Frank.
|> 
|> --
|> ---------------------------------------------------
|> Frank Siebenlist                 <franks@ntu.ac.sg>
|> Senior Research Fellow
|> GINTIC Institute of Manufacturing Technology (GIMT)
|> Nanyang Technological University (NTU)
|> Nanyang Avenue
|> Singapore 2263
|> Tel: (65) 799-1356               Fax: (65) 791-2927
|> ---------------------------------------------------

The keyword DESC is short for DESCending which is used in the ORDER BY
clause.  I would expect it to generate errors such as you have described
above.  Better use another name if you can.  By the way, you can find a
list of keywords in appendix A of the Ingres 6.4 SQL Reference Manual.

Mike Mitchell
Bull HN, Phoenix
Newsgroups: comp.databases.ingres
From: mmr@asgserver.canberra.edu.au (Micheal Rainford-Watson)
Subject: Re: DB admin tools 
Organization: University of Canberra
Date: Wed, 13 Jan 93 00:24:35 GMT

In article <726579736snz@panache.demon.co.uk> raph@panache.demon.co.uk writes:
>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.
Please send me a copy of your DB unload/restructure program:

Thankyou


-- 
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^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
Newsgroups: comp.databases.ingres
From: thomasl@mtl.mit.edu (Thomas J Lohman)
Subject: Re: Running Ingres using Unix Cron
Keywords: Ingres Cron
Organization: MIT Microsystems Technology Laboratories
Date: Tue, 12 Jan 1993 20:51:00 GMT

In article <1993Jan12.163830.17691@zia.aoc.nrao.edu> 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.

What OS are you running?  And what (if any) output is being produced?
Make sure that all output to stderr, and stdout is being redirected
somewhere so you can see what is happening.  Also, does the program
have to be run by Ingres or can it be executed by any ordinary user?


--tom
Newsgroups: comp.databases.ingres
From: dhubb@sierras.com (David B. Hubbell)
Subject: SunDBE and Ingres 6.4/02
Organization: Sierra Software, Friant, CA
Date: Mon, 11 Jan 93 18:12:59 GMT

Has anybody used SunDBE 1.3 with Ingres 6.4/02?  What performance improvements,
if any, did you see?
-- 

  /\/\ David B. Hubbell                                 VOICE: 209.822.2770
 /~/\~\ Advovcate Systems/Sierra Software                 FAX: 209.822.2768
/____\_\ dhubb@sierras.com
Newsgroups: comp.databases.ingres
From: leath@UPEI.CA (Steve Leath)
Subject: Re: DB admin tools
Organization: University of Prince Edward Island, CANADA
Date: Tue, 5 Jan 1993 12:18:22 GMT


>Both Paul Neal of Ingres and Fred Domke of NRAO mentioned schemadef_II
>in the sig directory of 6.4/02.  I'm using 6.4/02 under VMS, and find no
>such thing.  Maybe it's only available under Sun.
>
Mark, we are using 6.4/02 under VMS and schemadef_II is in our sig directory,
in fact I have just made some changes to it (it seems to be a bit sloppy). 
Actually, versions have been included in other releases aswell.

Steve leath@upei.ca
Newsgroups: comp.databases.ingres
From: billc@Ingres.COM (Bill Coffin)
Subject: Re: DB admin tools
Reply-To: billc@ingres.com
Organization: Ingres, An ASK Company, Alameda CA
Date: 5 Jan 93 19:03:38 GMT

In article <1993Jan5.004315.1@gsbacd.uchicago.edu>, cs_mj@gsbacd.uchicago.edu (Mark Jaeger) writes [edited]:
>
>Once I went so far as to try to write a version of copydb myself that
>would do what I really want: namely, create a script that will allow me
>to drop a table, modify its definition, and then recreate _all_ database
>objects that depend on that table.  It turns out to be pretty hard. 
>
>I tried hacking the iidbdepends system catalog, but found that this is
>not all that easy.  
>Unfortunately, I don't have any documentation for the iidbdepends system
>catalog.  

iidbdepends isn't really a System Catalog, and so it is not supported
on all gateways or in STAR.  Also, we don't guarantee that it won't
change, the way we guarantee catalogs like iitables.  So you can use
iidbdepends, but without connectivity and without guaranteed backward
compatibility.

Yes, the full-dependencies problem is hard, and we know that it's a
very popular request.  Unfortunately, I believe that schemadef_II
only does the easy part, and doesn't handle "deeper" dependencies
like database procedures, events, rules, and so on.

My reccomendation to Rob McNicholas, the original poster, would be to
use views liberally while developing the applications.  You can use
many tricks to avoid the necessity of redefining tables.  You will,
of course, pay a performance penalty, but that may be acceptable in
your Beta phase.

-- 
Bill Coffin, at Ingres, An ASK Company, Alameda CA 
billc@ingres.com	510.748.3387
<standard_disclaimer> <gratuitous_witticism> <obscure_quote> <annoying_graphic>
From: reddy@tiger.vill.edu (Shami Reddy)
Newsgroups: comp.databases.ingres
Subject: Project Suggestions
Date: 4 Jan 93 13:53:09 GMT
Organization: Villanova University
Originator: reddy@tiger.vill.edu

I am a graduate student in Computer Science and have just started using ingres.
I am thinking about doing my independent study on Relational databases using
ingres, but am unable to think of an interesting project. I would be really 
grateful for any suggestions that anyone might have.

Replies can be posted or email-ed to me at : reddy@tiger.vill.edu

Thanks in advance,
_Shami 
Newsgroups: comp.databases.ingres
From: jmj@antwrp.antwrp.gsfc.nasa.gov (Agent Snagnorf)
Subject: University Ingres
Organization: Compton Gamma Ray Observatory Science Support Center
Date: Wed, 6 Jan 1993 18:25:00 GMT


Greetings!

Does anyone know of a contact point for University Ingres?  Also, does
anyone know if it can use SQL as a query language?

Thanks

--Jim
jmj@enemy.gsfc.nasa.gov

EOM
Newsgroups: comp.databases.ingres
From: brunette@sju.edu (Glenn M. Brunette, Jr.)
Subject: Changing Default Printer
Keywords: abf printer default 
Organization: St. Joseph's University
Date: Fri, 8 Jan 1993 01:56:20 GMT


Please excuse this probably simple question, but...

Is there any way to instruct ABF to use a different printer other
than lp in a Report Frame?  Essentially, for one application, I need
"printer" to be directed to a printer other than "lp", but for that
application only.

Any ideas?

Thanks in advance,
Glenn

-- 
Glenn M. Brunette, Jr.                             Internet  : brunette@sju.edu
Assistant Network Manager                              UUCP  : sjuphil!brunette
Network Services & Academic Computing              Telephone : (215) 660-1524  
Saint Joseph's University                                Fax : (215) 660 1536
Newsgroups: comp.databases.ingres
From: macdonal@westford.ccur.com (Steve MacDonald)
Subject: Project Management Database Frame
Organization: Concurrent Computer Corp.  Westford, MA
Distribution: usa
Date: Thu, 7 Jan 1993 19:57:01 GMT


	I have a question concerning the project management database frame as
shown in the INGRES 4GL CODE for the sample application. I am developing a 
database application, and the majority of its users will have vt100 or WYSE
terminals from which to access it. I had an idea that it would be desirable to
have a menu application, similar to the application in the documentation to 
which I alluded previously. The manner in which to begin coding an application  
such as this, with popups and all, is not entirely clear from the coding 
example in the documentation. Has anyone out there had any experience with
coding a menu-driven application such as this? I guess the question I have is
in regards to the window that the example shows in which a letter is entered 
and a particular database application is selected. How is this window created?
Where was it created, in FORMS OR APPLICATIONS?  My question might be vague, but
that's because I'm a little lost on this one. At this point, all I think I need
is a little direction.


					Thanks,
					Steve MacDonald


Newsgroups: comp.databases.ingres
From: franks@ntrc27.ntrc.ntu.ac.sg (Frank Siebenlist)
Newsgroups: comp.databases.ingres
Subject: problem with "DESC" as column name in Windows4GL
Date: 8 Jan 93 07:52:35 GMT
Distribution: comp
Organization: /home/franks/.organization


If a column name of "DESC" is used,
then it seems "difficult" to access that column within Windows4GL.

For example a script containing:

	select :my_field = desc
	from my_table;

yields compilation errors like:

E_W40118 The symbol 'desc' is undefined.

E_PW0005 Can't create variable for desc.
    A variable couldn't be declared for the ENTRYFIELD desc.  A subsequent
    error should give more information about why it couldn't be created.

E_SY0010 Reserved word used as name.
    A variable (or other kind of object) was given the name `desc' which is
    a reserved word.  You can not use a reserved word to name an object.

This is too bad, but it becomes worse if:

		:my_field = my_table.desc

yields the same error.

As far as I know, DESC is not a reserved word for column names.
Also, other ingres programs like isql have no problem with: 
	select desc from my_table;

Is Windows4GL too restrictive? Is this a feature or bug?

Is there a workaround?

Please don't tell me to rename my column names!
(They are predefined by other existing applications.)

Regards, Frank.

--
---------------------------------------------------
Frank Siebenlist                 <franks@ntu.ac.sg>
Senior Research Fellow
GINTIC Institute of Manufacturing Technology (GIMT)
Nanyang Technological University (NTU)
Nanyang Avenue
Singapore 2263
Tel: (65) 799-1356               Fax: (65) 791-2927
---------------------------------------------------
Newsgroups: comp.databases.ingres
From: crb@advtech.uswest.com (Chris Renck)
Subject: Encryption
Originator: crb@brasil
Organization: U S WEST Advanced Technologies
Date: Fri, 8 Jan 1993 17:09:39 GMT

We are developing a application which is going to contain salary information,
and I was wondering if anyone has any suggestions on how the salary field
 can be encrypted or secure so only authorized people can see it.  Our Human 
Resources Dept does not even wants us (the Ingres developers) to be able to
see what data is in this field.

If anyone has run across this situation and/or has any suggestions, it would
be greatly appreciated.

The application is on Windows 4GL(2.0/01-su4.u42/00) and we are running it on a Sun 4/490 (SUN OS 4.1.1)i



Thanks!

Chris Renck
Systems Engineer
U S WEST Advanced Technologies
Boulder, Colorado
303-541-6612
-- 
=====================================================

            ,_             ___@            __@
       ,______\@          _`__\-'         / /\__
Newsgroups: comp.databases.ingres
From: cbignell@zia.aoc.nrao.edu (Carl Bignell)
Subject: Running Ingres using Unix Cron
Followup-To: Carl Bignell
Summary: Problem of running Ingres programs automatically
Keywords: Ingres Cron
Organization: National Radio Astronomy Observatory, Socorro NM
Date: Tue, 12 Jan 93 16:38:30 GMT

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.

Carl Bignell



Newsgroups: comp.databases.ingres
From: leath@UPEI.CA (Steve Leath)
Subject: Re: Help Facility with embedded SQL 
Keywords: help, Embedded SQL 
Organization: University of Prince Edward Island, CANADA
Date: Fri, 8 Jan 1993 17:39:39 GMT


>Have you tried the two help facilities that INGRES provides for Embedded SQL?
>One of them is basically the same as you get in isql.  One is called HELPFILE
>and is executed by the EXEC SQL HELPFILE subject filename command.  The other
>is HELP_FRS and is executed by the EXEC FRS HELP_FRS(SUBJECT=subject,
>FILE=filename) command.  Either of these provide nice help interfaces (we
>use them exclusively in our application development).
>
>-- 
>
>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."

I set up a help facility that uses the message or prompt functions. The help 
text are stored in files and when called for are loaded into a temp table 
and displayed through the message or prompt functions. By using these 
functions one gets away from Ingres's full screen only help (the user can 
not read the help and see the form at the same time). The length of the 
message and prompt boxes are sized dynamicaly by ingres and the width can be 
controlled by the help facility. I encode parameters at the end of the help 
file for width, placement and continuation (more pages to come, used with 
prompt). In addition a VMS logical can be used to flag the facililty to open 
the file with an editor before displaying it, this allows the programmers to 
create help files while running the application. The facilty is no slower 
than the ingres facility.  The facility is written in 4gl but could be 
written in 3gl with no problem.

Steve Leath   leath@upei.ca
Newsgroups: comp.databases.ingres
From: leath@UPEI.CA (Steve Leath)
Subject: Re: problem with "DESC" as column name in Windows4GL
Organization: University of Prince Edward Island, CANADA
Distribution: comp
Date: Fri, 8 Jan 1993 17:50:54 GMT

In article <FRANKS.93Jan8155235@ntrc27.ntrc.ntu.ac.sg> franks@ntrc27.ntrc.ntu.ac.sg (Frank Siebenlist) writes:
>From: franks@ntrc27.ntrc.ntu.ac.sg (Frank Siebenlist)
>Subject: problem with "DESC" as column name in Windows4GL
>Date: Fri, 8 Jan 1993 07:52:35 GMT
>
>If a column name of "DESC" is used,
>then it seems "difficult" to access that column within Windows4GL.
>
>For example a script containing:
>
>	select :my_field = desc
>	from my_table;
>
>yields compilation errors like:
>
>E_W40118 The symbol 'desc' is undefined.
>
>E_PW0005 Can't create variable for desc.
>    A variable couldn't be declared for the ENTRYFIELD desc.  A subsequent
>    error should give more information about why it couldn't be created.
>
>E_SY0010 Reserved word used as name.
>    A variable (or other kind of object) was given the name `desc' which is
>    a reserved word.  You can not use a reserved word to name an object.
>
>This is too bad, but it becomes worse if:
>
>		:my_field = my_table.desc
>
>yields the same error.
>
>As far as I know, DESC is not a reserved word for column names.
>Also, other ingres programs like isql have no problem with: 
>	select desc from my_table;
>
>Is Windows4GL too restrictive? Is this a feature or bug?
>
>Is there a workaround?
>
>Please don't tell me to rename my column names!
>(They are predefined by other existing applications.)
>
>Regards, Frank.
>
>--
>---------------------------------------------------
>Frank Siebenlist                 <franks@ntu.ac.sg>
>Senior Research Fellow
>GINTIC Institute of Manufacturing Technology (GIMT)
>Nanyang Technological University (NTU)
>Nanyang Avenue
>Singapore 2263
>Tel: (65) 799-1356               Fax: (65) 791-2927
>---------------------------------------------------

We had this problem when the base language changed from quel to sql. We had 
a lot of instances of "desc". we had to change them all, both in the 
database and applications. 

steve
Newsgroups: comp.databases.ingres