Re: CRTDUPOBJ vs SQL CREATE TABLE LIKE

I even tried it with
CREATE TABLE workfile as (Select * from ARLEEN) WITH DATA RCDFMT ARLEENR   
 
to even get the same record format name.  File level ID I wouldn't be so 
concerned with.  It's that record format id that would concern me more. 
However they were still different.
I even tried this:

CREATE TABLE ROB/JEFF1 (MYCHAR CHAR (15 ) NOT NULL WITH DEFAULT,
MYDEC DECIMAL (9 , 2) NOT NULL WITH DEFAULT) 

CREATE TABLE JEFF2    as (Select * from JEFF1) WITH DATA RCDFMT JEFF1

And their record formats were different.

Rob Berendt