Add fields to physical file without exclusive lock _ formerly Re: Stupid question of the century

Hi Scott
Understood
However I find that I tend to still read the body of the e_mail irrespective of the subject line
This message was sent from my BlackBerry
My BlackBerry number is 631 880 8640


----- Original Message -----
From: Scott Klement [midrange-l@xxxxxxxxxxxxxxxx]
Sent: 05/09/2009 02:49 PM EST
To: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>
Subject: Re: Stupid question of the century



Dear Alan and everyone else,

It would help me greatly if you would please use meaningful subject
lines on threads posted here. I'd like to be able to read the subject
of the message and know what the discussion will be about.

Something like "Add fields to PF without exclusive lock" would've been a
good one for this thread.

It's not useful to know that you are asking a question. Virtually every
message posted asks a question in some fashion or another. I need to
know what the question is about, not merely that it's a question. It's
also not useful to know that you view the question as "stupid".
Especially since this question *wasn't* stupid.

Please help me out and use a meaningful subject line! Thanks in
advance for your help.


Alan Shore wrote:

Hi guys
I've just been asked the following question by my boss's boss
Is there anyway to add new fields (columns) "on the fly" to an existing
file, without having an exclusive lock on that file.
In other words, the file is still being used while the field is added
I know that chgpf is out of the question (unless someone proves me wrong).
I know that SQL is also out of the question (ALTER TABLE x ADD EXTRAFIELD
DEC(7, 2) NOT NULL DEFAULT 0) - again unless someone proves me wrong
If anyone knows of any way, any language, any procedure, any function to
achieve this, please drop me a line.

Thanks in advance


Alan Shore
Programmer/Analyst, Distribution
E:AShore@xxxxxxxxxxx
P:(631) 200-5019
C:(631) 880-8640
"If you're going through Hell, keep going" - Winston Churchill

--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.