|
Al wrote: > One of the reasons that System/38 databases > were so solid was the existence of the DDS REF keyword, so that you could > create a field reference file, and make all of the fields refer to each > other. I do agree. But, you can now with SQL V5R2 exploit a similar technique, using an other file as reference. Something like: CREATE TABLE name_it AS (SELECT column1, column2, ...etc FROM your_reference_file) WITH NO DATA INCLUDING COLUMN DEFAULTS It's even possible to alter the column names (SELECT column1_from column1_to, column2_from column2_to, ...etc). BTW, as of V5R1, you can also generate the DDLs (CREATE TABLE, VIEW, ...etc) directly from the existing PFs/LFs, thru OpsNav or API QSQGNDDL. HTH Richard THEIS iSeries Education, France
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2024 by midrange.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 on our policy page. If you have questions about this, please contact [javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.