RE: DDS to DDL

Gerry,

The SQL equivalent isn't what you'd expect from a true FRF. Maybe FRF
functionality isn't particularly beneficial in a true SQL environment, but in an
environment where your RPG programs are compiled over a specific record format
and where your legacy documentation tools are specifically looking for the
'REFFLD' attribute, FRFs are something I'll miss.

See thread below for more info on UDTs;
http://archive.midrange.com/midrange-l/200803/msg00000.html

JK


On Mon 08/07/14 14:44 , 'Wilt, Charles' sent:

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/sql
p/rbafyuddt.htm orhttp://tinyurl.com/6f7f7w

HTH,

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

wiltc@Cintas
.com

-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx [mailto:midrange-l-> bounces@

midrange.com] On Behalf Of GKern@
toledoclinic.com> Sent: Monday, July 14, 2008 3:52 PM

To: midra

nge-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

---- Msg sent via Internet America Webmail - www.internetamerica.com