How is this any different that what you had with DDS?
On Tue, Oct 30, 2012 at 11:40 AM, Birgitta Hauser
But the reference is not stored in the table.
If you have to modify your reference field you have to update all your
Mit freundlichen Grüßen / Best regards
"Shoot for the moon, even if you miss, you'll land among the stars." (Les
"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!"
[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
IBM Certified Systems Expert — eServer i5 iSeries