Re: Add a unique key field to view without redefining table

Rob,

That's what my steps laid out...
"existing logicals, pointing them to the new table with an explicit field
list that leaves off the new identity column."

I thought you were suggesting leaving more than just the new column off.

Charles

On Wed, Dec 14, 2016 at 5:14 AM, Rob Berendt <rob@xxxxxxxxx> wrote:

Let me clarify then Charles. Add the new column to the PF. Recreate all
the LF's only selecting the old columns.

That is, if you feel you need a new column and that the old examples on
how to find duplicate rows and pin them down by RRN or some such thing,
won't work.


Rob Berendt
--
IBM Certified System Administrator - IBM i 6.1
Group Dekko
Dept 1600
Mail to: 2505 Dekko Drive
Garrett, IN 46738
Ship to: Dock 108
6928N 400E
Kendallville, IN 46755
http://www.dekko.com





From: Charles Wilt <charles.wilt@xxxxxxxxx>
To: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>
Date: 12/13/2016 12:22 PM
Subject: Re: Add a unique key field to view without redefining
table
Sent by: "MIDRANGE-L" <midrange-l-bounces@xxxxxxxxxxxx>



That's not a bad idea to consider for new logicals....

but the existing programs expect to see all the current fields. You can't
leave any off without having to recompile...which is what we are trying to
avoid. ;)

Charles

On Tue, Dec 13, 2016 at 9:41 AM, Rob Berendt <rob@xxxxxxxxx> wrote:

I'm away from my computer but you may want to consider not selecting all
columns in your logical files. This should keep your format id the same.

Sent from Lotus Traveler


Charles Wilt --- Re: Add a unique key field to view without

redefining

table ---
From:"Charles Wilt" <charles.wilt@xxxxxxxxx>To:"Midrange Systems
Technical Discussion" <midrange-l@xxxxxxxxxxxx>Date:Tue, Dec 13, 2016
11:18 AMSubject:Re: Add a unique key field to view without redefining

table

On Tue, Dec 13, 2016 at 8:54 AM, Dan wrote: > Doable, but a

maintenance

nightmare. > ​Not really, no. The idea is that the LFs will never

change.

And once you build the first field list, it's a simple matter to copy

and

past to the other logicals. If at some point you add a new field that a
program needs, then you create a new logical, with an explicit field

list

that includes that new field and change the program to use the new

logical.

As long as the​ new logical has the same key as an existing, there's no
extra overhead beyond a few bytes of DASD for the object definition. The
concept's been around a while, programs only access data via logical

file

with an explicit and unchanging format. But the DB2 modernization
whitepaper/redbook outlines the technique as a method to move from DDS

--

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. Please contact
support@xxxxxxxxxxxx for any subscription related questions. Help

support

midrange.com by shopping at amazon.com with our affiliate link:
http://amzn.to/2dEadiD
--
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.

Please contact support@xxxxxxxxxxxx for any subscription related
questions.

Help support midrange.com by shopping at amazon.com with our affiliate
link: http://amzn.to/2dEadiD

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

Please contact support@xxxxxxxxxxxx for any subscription related
questions.

Help support midrange.com by shopping at amazon.com with our affiliate
link: http://amzn.to/2dEadiD



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

Please contact support@xxxxxxxxxxxx for any subscription related
questions.

Help support midrange.com by shopping at amazon.com with our affiliate
link: http://amzn.to/2dEadiD