Re: SQL RCDFMT

[Loyd Goodbar <loyd@xxxxxxxxxxxxxx>]

What I have done before is create the table as the record format name, then
rename to the table name:
create table mytabr as...;
rename mytabr to mytab;

In V5R4+, you can do:
create mytab as (...) rcdfmt mytabr;

HTH,
Loyd

On Mon, Jan 11, 2010 at 1:21 PM, CRPence <CRPbottle@xxxxxxxxx> wrote:

>   Not sure why that specifically-SQL question is asked here; much
> more appropriate on Midrange-L.?  Regardless, the answer is "No."
> IIRC the CREATE TABLE statement supports RCDFMT for both clauses AS
> subquery and LIKE table|view name; not to imply they are generally
> acceptable to replace an ALTER, but may be for a single TABLE.
>
>   However the easiest and possibly most functional manner to change
> the record format name is to use CREATE VIEW with the RCDFMT clause.
>  Then refer to the VIEW instead of the TABLE.
>
> Regards, Chuck
>
> TAllen@xxxxxxxxxxxx wrote:
> > Is it possible to set the RCDFMT on a DB2 i database table
> > with the SQL ALTER TABLE command?