There is an SQL equivalent...
Create table customers as (select name as CustomerName,
With no data
Including identity column attributes
Including column defaults
The last two lines are optional.....
Additionally, you can make use of SQL user defined types (UDT)...
Create distinct type t_Name as char(30) with comparisons
Create table customers
There's lots of power in UDTs, but a bit more work upfront.
CINTAS Corporation - IT 92B
-----Original Message-----midrange.com] On Behalf Of GKern@
From: midrange-l-bounces@xxxxxxxxxxxx [mailto:midrange-l-> bounces@
toledoclinic.com> Sent: Monday, July 14, 2008 3:52 PM
To: midrange-l@xxxxxxxxxxxx> Subject: DDS to DDL
Access redbook> because I want to learn how to, as recently mentioned
I'm reading the Modernizing iSeries Application Data
in WEB400-L "> ...separate the screen I/O and application control
logic, from the> business rules and database I/O,...".
has good> description of converting DDS to DDL, and creating I/O
This redbook seems to be a good guide for doing so, and
modules to access> SQL objects via stored procedures. We recently acquired
a web based tool> that supports stored procedures for accessing our
modules and prototyped> stuff but most of those objects are married to
traditional RPG stuff and> aren't designed for use as services.
doesn't mention> anything resembling an SQL based data dictionary. Is
But the thought just occurred to me that this redbook
there such a thing? A> repository of some sorts? I've been an advocate of
field reference files> and we currently don't have one in my shop. Are FRF's
still a good thing> or have they been replaced with another methodology? Is
there an SQL> equivalent?
This mailing list archive is Copyright 1997-2013 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