MIDRANGE dot COM Mailing List Archive



Home » MIDRANGE-L » October 2012

AW: DDS field reference equivalent in SQL



fixed

In DDS I only had to execute an CHGPF and my references are updated without
any modification of the DDS.

Mit freundlichen Grüßen / Best regards

Birgitta Hauser

"Shoot for the moon, even if you miss, you'll land among the stars." (Les
Brown)
"If you think education is expensive, try ignorance." (Derek Bok)
"What is worse than training your staff and losing them? Not training them
and keeping them!"


-----Ursprüngliche Nachricht-----
Von: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] Im Auftrag von Charles Wilt
Gesendet: Tuesday, 30.10 2012 16:43
An: Midrange Systems Technical Discussion
Betreff: Re: DDS field reference equivalent in SQL

How is this any different that what you had with DDS?

Charles

On Tue, Oct 30, 2012 at 11:40 AM, Birgitta Hauser <Hauser@xxxxxxxxxxxxxxx>
wrote:
But the reference is not stored in the table.
If you have to modify your reference field you have to update all your
files/tables manually!

Mit freundlichen Grüßen / Best regards

Birgitta Hauser

"Shoot for the moon, even if you miss, you'll land among the stars."
(Les
Brown)
"If you think education is expensive, try ignorance." (Derek Bok)
"What is worse than training your staff and losing them? Not training
them and keeping them!"


-----Ursprüngliche Nachricht-----
Von: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] Im Auftrag von Luis Rodriguez
Gesendet: Tuesday, 30.10 2012 16:21
An: Midrange Systems Technical Discussion
Betreff: Re: DDS field reference equivalent in SQL

A little longer answer would be (*maybe*) : Yes and No...

In some of our projects we have used a very big reference table where
we specify the columns we need. Each individual table is then created with
a:

CREATE TABLE mylib/myfile AS(
SELECT COL1, COL2, COLN FROM mylib/myreftable) WITH NO DATA


HTH,


Luis Rodriguez
IBM Certified Systems Expert ? eServer i5 iSeries
--




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







Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2014 by MIDRANGE dot COM and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available here. If you have questions about this, please contact