RE: DDS to DDL

There is an SQL equivalent...

Create table customers as (select name as CustomerName, <...>
from MyFieldReferenceTable)
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
CustomerName t_Name,
<...>


There's lots of power in UDTs, but a bit more work upfront.
http://publib.boulder.ibm.com/infocenter/iseries/v5r4/topic/sqlp/rbafyuddt.htm or
http://tinyurl.com/6f7f7w


HTH,

Charles Wilt
--
Software Engineer
CINTAS Corporation - IT 92B
513.701.1307

wiltc@xxxxxxxxxx

-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx [mailto:midrange-l-
bounces@xxxxxxxxxxxx] On Behalf Of GKern@xxxxxxxxxxxxxxxx
Sent: Monday, July 14, 2008 3:52 PM
To: midrange-l@xxxxxxxxxxxx
Subject: DDS to DDL

I'm reading the Modernizing iSeries Application Data Access redbook
because I want to learn how to, as recently mentioned in WEB400-L "
...separate the screen I/O and application control logic, from the
business rules and database I/O,...".

This redbook seems to be a good guide for doing so, and has good
description of converting DDS to DDL, and creating I/O 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.

But the thought just occurred to me that this redbook doesn't mention
anything resembling an SQL based data dictionary. Is 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?

Thanks!

Regards, Jerry

Gerald Kern - MIS Project Leader
Lotus Notes/Domino Administrator
IBM Certified RPG IV Developer
The Toledo Clinic, Inc.
4235 Secor Road
Toledo, OH 43623-4299
Phone 419-479-5535
gkern@xxxxxxxxxxxxxxxx


This e-mail message, including any attachments, is for the sole use of the
intended recipient(s) and may contain confidential and privileged
information. Any unauthorized use, disclosure or distribution is
prohibited. If you are not the intended recipient, please inform the
sender by reply e-mail and destroy this and all copies of this message.
--
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.

This e-mail transmission contains information that is intended to be confidential and privileged. If you receive this e-mail and you are not a named addressee you are hereby notified that you are not authorized to read, print, retain, copy or disseminate this communication without the consent of the sender and that doing so is prohibited and may be unlawful. Please reply to the message immediately by informing the sender that the message was misdirected. After replying, please delete and otherwise erase it and any attachments from your computer system. Your assistance in correcting this error is appreciated.