For V5R4: CREATE TABLE qtemp/cusmst (cusname CHAR(20), cuszip CHAR(10)) RCDFMT cmfmt CREATE TABLE qtemp/myfile as (select fld1,fld2...fld9 from xyzlib/abcfile) with no data RCDFMT ircd For prior versions RENAME TABLE statement could be used in conjunction with the SQL CREATE TABLE to control the record format name for SQL-created objects
Unconfigured Ad Widget
Collapse
Announcement
Collapse
No announcement yet.
Record Format name in Table
Collapse
X
-
Record Format name in Table
I just heard this from Skip Marchesani at Common in Columbus last week. V5r3 and before creates tables with the same name as the record format. You can change the table name, but not the record format name. For versions prior to v5r4, create the table with the record format name you want to end up with, then change the table name to something different.
Comment
Comment