Re: convert dds to ddl

Dennis,

Given the following:
A UNIQUE
A R TESTTBLR
A MYKEY 10A
A MYFLD 100A
A K MYKEY

This SQL defined table will have the same record format ID.
create table TESTTBLR (
mykey char(10) not null with default,
myfld char(100) not null with default,
primary key (mykey));

rename table TESTTBLR
to system name TESTTBL;


In fact, you can even take advantage of long names:
create table C1162332/TESTTBLR (
my_long_key_field for mykey
char(10) not null with default,
my_long_field for myfld
char(100) not null with default,
primary key (my_long_key_field));

rename table C1162332/TESTTBLR
to MY_TEST_TABLE;

rename table C1162332/MY_TEST_TABLE
to system name TESTTBL;


The key prior to v5r4's addition of the RCDFMT keyword is to initially
create the table with the record format name (TESTTBLR) as the table
name.

HTH,
Charles


On Fri, Aug 6, 2010 at 2:27 PM, Dennis Lovelady <iseries@xxxxxxxxxxxx> wrote:

For tables?!?!  Sparked my curiosity!  Is this done via after-the-fact
RNMOBJ or something else?  Do tell!

Dennis Lovelady
http://www.linkedin.com/in/dennislovelady
--
“...Yes, the lectures are optional.  Graduation is also optional.”
       -- Professor Brian Quinn

Point of fact...you've _always_ been able to get a DDL created table
to have a record format ID of a DDS created physical.

With the addition of the RCDFMT clause in v5r4, it became easier.  But
it could be done before.