Re: Changing database to SQL from DDS

["Richard Theis" <theis_richard@xxxxxxxxxx>]

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