HDTenEightyP/NetNews huggingface dataset:
From: mikes@Ingres.COM (Mike Schilling)
Subject: Re: problem with "DESC" as column name in Windows4GL
Distribution: comp
Date: 8 Jan 93 17:48:34 GMT

From article <FRANKS.93Jan8155235@ntrc27.ntrc.ntu.ac.sg>, by franks@ntrc27.ntrc.ntu.ac.sg (Frank Siebenlist):
> 
> 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
> ---------------------------------------------------

'desc' is an SQL keyword; in the ORDER BY clause on a SELECT, you
can order by ascending (ASC) or descending (DESC). The Windows4GL compiler
is unhappy about a field whose name is an SQL keyword.

Actually, the example code you show gives me a different error:

	select :my_field = desc from a;
			    ^
	%% Error at line 8
	E_W400F0 Syntax error.  The last symbol read was 'desc'.


It's if you call the field 'desc' that you get:
	E_W40118 The symbol 'desc' is undefined.
	etc.

Solution:
1. call the field something other than desc (you control the field name).
2. Write the select as:

	select :my_field = 'desc' from a;

Mike	
----------------------------------------------------------------------------
mikes@ingres.com = Mike Schilling, INGRES, An ASK Group Company, Alameda, CA
Just machines that make big decisions,
Programmed by fellows with compassion and vision.	-- Donald Fagen, "IGY"
Newsgroups: comp.databases.ingres
From: sfc@tpghq.com (Steve Caswell)
Subject: Re: Q: How to get dates as DD/MM/YYYY?
Organization: Palmer & Associates, Inc., Norcross, GA
Date: Tue, 12 Jan 1993 14:35:05 GMT

In article <C0pLpE.DBx@demon.co.uk> Tom Davies <tomd@horse.demon.co.uk> writes:
>Is there any way of getting values from a date column in the format 
>'dd/mm/yyyy', i.e. *with* the century, without messing around with 
>date-part?
>Thanks,
>	Tom
>---------------------------------------------------------------------
>        Tom Davies - 14 Rotterdam Drive, London E14 3JA, 071 987 0392
>                   - tomd@horse.demon.co.uk
>
> -----PGP 2.0 PUBLIC KEY AVAILABLE-----
>---------------------------------------------------------------------

The answer depends on what you mean by "get".  You can easily display dates in
this format (really in just about any format).  On a VIFRED form, create a 
field with datatype of date, and display format of "03/02/1901".  The VIFRED
Reference Manual explains this format.  To get this into a program variable
via a select, you will have to play with the date_part function.  You should
be able to use date_part to get the various pieces of the date (hopefully
the centry also, but I can't guarantee it) and then put them back together.

-- 

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: RVBAAL@kub.nl (Reinier van Baal)
Subject: Ignore my previous posting
Date: Wed, 06 Jan 93 08:22:24 GMT
Organization: Tilburg University (KUB)
X-News-Reader: VMS NEWS 1.22

Hello fellow netters,

Please ignore my previous posting (RE: DB-admin tools), which has nothing
to do with the original problem of Rob McNicholas nor the recommandations
from Bill Coffin. I mixep up two different questions.

My apologies for having wasted your time by an erroneous posting.
 
 ----------------------------------------------------------------------
 Reinier van Baal,                             
 Tilburg University, Holland                   internet: rvbaal@kub.nl    
 (Katholieke Universiteit Brabant)             phone: +31 (0)13-66 2459   
Newsgroups: comp.databases.ingres
From: djk@sei.cmu.edu (David Kaplan)
Subject: Transaction Log File
Organization: The Software Engineering Institute
Date: Thu, 7 Jan 1993 14:55:32 EST


I'm having some intermittent problems with the Trasaction Log File.  Or,
rather, it's having trouble with me?  In either case, the following error
occurs when running a rather long set of queries:

**** ERROR: E_US1262 Your transaction has been aborted due to the transaction
    log file having reached one of the limits set by the system administrator.
    These limits are log_full, force_abort, and 90 percent of force_abort
    when using the fast_commit option to start DBMS servers.
   (Thu Jan  7 12:21:39 1993)

What's this all about.  I mentioned intermittent because some days I get the
error, and other days I don't?!  There are commits after each query (all
creation and insertion commands), and the queries are broken up just about as
far as we can get them.

Could this error be an indicator that something else is wrong?  The fact that
it is intermittant EVEN when the data being used has not change is what really
has me puzzled.

Any clues appreciated ;-)

Thanks,

-Dave.


---------------------------------------------------------------------------
David J. Kaplan                                             djk@sei.cmu.edu
Software Engineering Institute                         dk3g+@andrew.cmu.edu
Carnegie Mellon University                                   (412) 268-7736
Newsgroups: comp.databases.ingres
From: sfc@tpghq.com (Steve Caswell)
Subject: Re: Encryption
Organization: Palmer & Associates, Inc., Norcross, GA
Date: Mon, 11 Jan 1993 13:05:35 GMT

In article <1993Jan8.170939.9261@advtech.uswest.com> 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.
>
>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
>-- 
>=====================================================
>
>            ,_             ___@            __@
>       ,______\@          _`__\-'         / /\__

I don't know of-hand of a way for INGRES to do encryption, but you can write 
your own datatype that encrypts the data for you.  This is possible using the
Object Management Extension (OME).  With OME, you actually construct the
datatype, including writing code for comparison of two values, adding, 
subtracting, etc., hash key generation, and other things.  For this problem,
you could construct the datatype to perform encryption of input values before
the value is stored to the database.  Whenever the value is needed for output,
comparison, adding/subtracting, etc, then your code would decrypt the value
first.

-- 

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: sfc@tpghq.com (Steve Caswell)
Subject: Re: ABF question
Organization: Palmer & Associates, Inc., Norcross, GA
Date: Fri, 8 Jan 1993 14:30:19 GMT

In article <1993Jan7.170744.71@ittpub.nl> hans@ittpub.nl writes:
>I am using ABF to maintain a tabel of items. The user should be able to add 
>and delete these items, and modify most of the information associated with
>the item.
>
>Each items has a key value. I want to prevent the user from modifying this
>key value. Defining the column DISPLAYONLY is no good, for the user has to be 
>able to specify the value when adding new items. By the time I catch the error
>I cannot change it back, as the original value is lost.
>
>Is there any way I can:
>
>a. Allow creation and deletion of a column in a table field, without also
>   allowing modification?
>b. Have access to the old value, so I can change it back?

You can only get access to the old value if you store that value when loading
the tablefield.  You can accomplish this by adding a hidden column to the
tablefield in the initialize section of the abf source:

initialize
(table.hidden_column = datatype
etc.
)

and then load that column when you load the tablefield.  For example,
table = select key_column
              ,key_column as table.hidden_column
etc.

>
>Or is there any other way of doing what I want?

One solution we employ for this kind of problem is to leave the column in
displayonly mode and keep the tablefield in update mode.  This allows only
updating of rows loaded by the application.  To allow entry of new rows, we
use an Add menuitem which displays a pop-up form to allow entry of new data
values, then use insertrow or loadtable to add the new row to the tablefield
from within the code.

>
>Thanks in advance.
>
>Hans Wieldraaijer, ITT Publitec, Amsterdam, Netherlands.
>E-mail: hans@ittpub.nl


-- 

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: "Kathy Tymoczko (KT) x4280" <KTYMOCZK%ADMIN1@carleton.edu>
Subject: UNSUBSCRIBE
Organization: National Radio Astronomy Observatory
Date: Mon, 4 Jan 1993 14:14:35 GMT

UNSUBSCRIBE

                                Kathy Tymoczko
                                Computer Center, Carleton College
                                Internet: ktymoczk@carleton.edu

Newsgroups: comp.databases.ingres
From: mdchaney@fractal.ucs.indiana.edu (M Darrin Chaney)
Subject: Re: DB admin tools
Organization: Indiana University, Bloomington
Date: Wed, 6 Jan 1993 14:46:20 GMT

In article <1993Jan5.190338.23433@pony.Ingres.COM> billc@ingres.com writes:
>
>Yes, the full-dependencies problem is hard, and we know that it's a
>very popular request.

It must be hard, since unloaddb still can't even handle views correctly.

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

It'd actually work better (for schemadef) if those things just weren't
dropped with the table.

	Darrin
-- 

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

"I want- I need- to live, to see it all..."
Newsgroups: comp.databases.ingres
From: sfc@tpghq.com (Steve Caswell)
Subject: Re: Encryption
Organization: Palmer & Associates, Inc., Norcross, GA
Date: Tue, 12 Jan 1993 14:31:59 GMT

In article <C0pH9r.C1y@usenet.ucs.indiana.edu> mdchaney@fractal.ucs.indiana.edu (M Darrin Chaney) writes:
>In article <1993Jan8.170939.9261@advtech.uswest.com> 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.
>>
>>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
>
>Salary information is open information at most firms.  You should find out
>*why* your human resources department is so worried about you seeing it...

Unless you have worked at "most" firms, how can you make this kind of blanket
statement.  The three companies I have worked for in my illustrious career
did NOT consider salary information to be open information.  A response such
as this (i.e., go change your business) does not fly.  Information systems
must be adequate enough to model business, not the other way around.  Even
if this Human Resources Department is being unreasonable in its restrictions,
as software professionals, we must be intelligent enough to come up with a
solution to the problem, not excuses for why we can't.

>
>	Darrin
>-- 
>
>mdchaney@iubacs mdchaney@bronze.ucs.indiana.edu mdchaney@rose.ucs.indiana.edu
>
>"I want- I need- to live, to see it all..."


-- 

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: rayt@rtsl.demon.co.uk (Ray Turner)
Subject: SUBSCRIBE
Reply-To: rayt@rtsl.demon.co.uk
Organization: National Radio Astronomy Observatory
Date: Tue, 5 Jan 1993 20:10:33 GMT

Please add me to the info-ingres mailing list.
Newsgroups: comp.databases.ingres
From: mikes@Ingres.COM (Mike Schilling)
Subject: Re: ABF question
Date: 8 Jan 93 17:07:49 GMT

From article <1993Jan7.170744.71@ittpub.nl>, by hans@ittpub.nl:
> I am using ABF to maintain a tabel of items. The user should be able to add 
> and delete these items, and modify most of the information associated with
> the item.
> 
> Each items has a key value. I want to prevent the user from modifying this
> key value. Defining the column DISPLAYONLY is no good, for the user has to be 
> able to specify the value when adding new items. By the time I catch the error
> I cannot change it back, as the original value is lost.
> 
> Is there any way I can:
> 
> a. Allow creation and deletion of a column in a table field, without also
>    allowing modification?
> b. Have access to the old value, so I can change it back?
> 
> Or is there any other way of doing what I want?
> 
> Thanks in advance.
> 
> Hans Wieldraaijer, ITT Publitec, Amsterdam, Netherlands.
> E-mail: hans@ittpub.nl
Create the tablefield with a hidden column, and put the key value there
as well as in a visible column.  When unloading the tablefield, you can
catch the change.  (Or you can use a column activation to catch it
immediately.)  If you have Vision available, look at the code it
generates for an update frame; it uses this technique exactly.
----------------------------------------------------------------------------
mikes@ingres.com = Mike Schilling, INGRES, An ASK Group Company, Alameda, CA
Just machines that make big decisions,
Programmed by fellows with compassion and vision.       -- Donald Fagen, "IGY"

Newsgroups: comp.databases.ingres
From: "Anthony J. Rzepela" <rzepela@hal.hahnemann.edu>
Subject: Re: Help - ABF/4GL questions.
Organization: National Radio Astronomy Observatory
Date: Tue, 5 Jan 1993 18:28:22 GMT

In response to a messy locking situation where the user
GOLD@ILP.MIT.EDU (Mark D. Gold) wanted to avoid deadlock on 
a shared resource (a temporary table), it was pointed out 
by Mark Jaeger <cs_mj@gsbvax.uchicago.edu> that

1> ABF has a neat lock detection and deletion feature.

2> User-interrupts are not easily handled in the 4GL. 

In relation to the first matter, I have had the experience where
an interrupted (^Y, ^C) session of ABF still exists as a lock, 
as the locks from these "dead" sessions show up until explicitly 
deleted by the new ABF user.  (I am at 6.3/03 on VMS 5.4-2). 

What would be really slick (and I don't know about feasibility)
would be to include in the application a user-maintined lock system, in which 
the application desiring a resource could check not only for one of these
pseudo-locks, but also, if found, the status of the process that created it.
(Is it still running, in a PFW, etc.?) 

In this manner, "abandoned" locks could be eliminated if and when they 
prevent a new user from accessing some resource.

There are some  methods which would not necessarily require
a hard-coded table name (and hence, avoids all worries about pseudo-locks),
but the original problem description was not specific enough on the 
descriptions of the C procedures called in the 4GL procedure's loops, 
so a definitive answer is still not at hand. 

----------------------------------------------
Anthony Rzepela    <rzepela@cvi.hahnemann.edu>
"What IS this fascination with Axl Rose? He looks so...unhealthy."  M.L.C. 1991
-------------------
From: astinus+@pitt.edu (Mark E Porterfield)
Newsgroups: comp.databases.ingres
Subject: Re: Running Ingres using Unix Cron
Keywords: Ingres Cron
Date: 12 Jan 93 20:04:39 GMT
Organization: University of Pittsburgh

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
>Carl Bignell

We work on a set of DecStation 5000/200's running ULTRIX V4.2 (Rev. 96).
We have cron run c shell scripts as user INGRES that in turn run all our
reports and nightly SQL integrity checks.  It is good pratice to ALWAYS give
CRON or any other script a full pathname.  One nice plus we have seen from
using shell scripts is that we can send reports via mail directly to dept.
heads or some external sites for verification of a code used via e-mail.  Our
users and external sites have really welcomed this functionallity.  They get
their coffee and sit down to read yesterdays reports.  No traversing from
machine to machine or digging through directory structures.  These are, of 
course, for NON-sensitive information only.

Mark E. Porterfield
Newsgroups: comp.databases.ingres
From: raph@panache.demon.co.uk (Raphael mankin)
Subject: Re: SQL where claus limitations 
Distribution: world
Organization: Solvfield Ltd.
Reply-To: raph@panache.demon.co.uk
X-Mailer: Simple NEWS 1.90 (ka9q DIS 1.19)
Date: Fri, 8 Jan 1993 19:54:18 +0000

I had a similar problem a year or so back, but my WHERE was >1Kbytes. Ingres
support told me to set some trace point flag, but I can't now remember which -
I'm at a different site without the old records to hand.
-- 
--------------
Raphael Mankin			Nil taurus excretum
Newsgroups: comp.databases.ingres
From: dtg@wvnvms.wvnet.edu
Newsgroups: comp.databases.ingres
Subject: INGRESS FAQ
Date: 4 Jan 93 15:22:32 GMT
Organization: West Virginia Network for Educational Telecomputing

I was wondering if there is an FTP archive site which contains a FAQ on INGRES. 
Please e-mail me direct to :

grasso@cards.com

Thank you for your time.
dave
Newsgroups: comp.databases.ingres
From: mcj@moose.cccs.umn.edu (Mark C. Jones)
Subject: Dynamic variable evaluation in 4GL?
News-Software: VAX/VMS VNEWS 1.41    
Reply-To: mcj@moose.cccs.umn.edu
Organization: Colon Cancer Control Study, University of Minnesota, Minneapolis
Date: Tue, 5 Jan 1993 16:09:00 GMT


Well, I have scanned the Ingres 6.4 manual and I do not believe it
is possible to take the name of a variable stored in another varchar
variable and extract its value.
i.e.
   xyz=1;
   myvar='xyz';
   abc=value of variable named in myvar which in this case is 1.

Using a select statement like the following does not work:
   select varchar(:myvar) as abc;
This gives the result abc='xyz'.  This is not suprising since the
variable is only evaluated once.


Some other languages provided dereferencing functions to handle this
situation.  Obviously I can use dynamic coding in 3GL but does anyone know
of any tricks to do this while remaining in 4GL.  I think its impossible
but I would be happy to be proven wrong,  maybe there is some new undocumented
6.4 function that I am unaware of.


 ------------------------------------------------------------------ 
 Mark C. Jones (mcj@moose.cccs.umn.edu) 
 CSC Partners
 5500 Wayzata Blvd, Suite 1100
 Minneapolis  MN 55416  USA
 +1 612 593 1122                   
 ------------------------------------------------------------------
From: mcj@moose.cccs.umn.edu (Mark C. Jones)
Newsgroups: comp.databases.ingres
Subject: Re: Q: How to get dates as DD/MM/YYYY?
Date: 12 Jan 93 18:41:00 GMT
Article-I.D.: moose.12JAN199312410846
Reply-To: mcj@moose.cccs.umn.edu
Organization: Colon Cancer Control Study, University of Minnesota, Minneapolis
News-Software: VAX/VMS VNEWS 1.41

In article <C0pLpE.DBx@demon.co.uk> Tom Davies <tomd@horse.demon.co.uk> writes:
>Is there any way of getting values from a date column in the format 
>'dd/mm/yyyy', i.e. *with* the century, without messing around with 
>date-part?
>Thanks,
>	Tom
>---------------------------------------------------------------------
>        Tom Davies - 14 Rotterdam Drive, London E14 3JA, 071 987 0392
>                   - tomd@horse.demon.co.uk
>
> -----PGP 2.0 PUBLIC KEY AVAILABLE-----
>---------------------------------------------------------------------
>  


This is an ugly but effective method that always works!

trim(left(shift(date_gmt( YOUR_DATE ),-5),2))
+'/'+
trim(left(shift(date_gmt( YOUR_DATE ),-8),2))
+'/'+
trim(left(date_gmt( YOUR_DATE ),4))



 ------------------------------------------------------------------ 
 Mark C. Jones (mcj@moose.cccs.umn.edu) 
 CSC Partners
 5500 Wayzata Blvd, Suite 1100
 Minneapolis  MN 55416  USA
 +1 612 593 1122                   
 ------------------------------------------------------------------
From: hans@ittpub.nl
Newsgroups: comp.databases.ingres
Subject: ABF question
Date: 7 Jan 93 17:07:44 WET+0100
Organization: ITT Publitec R+D BV, Amsterdam

I am using ABF to maintain a tabel of items. The user should be able to add 
and delete these items, and modify most of the information associated with
the item.

Each items has a key value. I want to prevent the user from modifying this
key value. Defining the column DISPLAYONLY is no good, for the user has to be 
able to specify the value when adding new items. By the time I catch the error
I cannot change it back, as the original value is lost.

Is there any way I can:

a. Allow creation and deletion of a column in a table field, without also
   allowing modification?
b. Have access to the old value, so I can change it back?

Or is there any other way of doing what I want?

Thanks in advance.

Hans Wieldraaijer, ITT Publitec, Amsterdam, Netherlands.
E-mail: hans@ittpub.nl