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;


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.
p/rbafyuddt.htm or


Charles Wilt
Software Engineer
CINTAS Corporation - IT 92B

-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx [mailto:midrange-l-> bounces@] On Behalf Of GKern@> 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?


Regards, Jerry

---- Msg sent via Internet America Webmail -

This thread ...


Return to Archive home page | Return to MIDRANGE.COM home page