Re: Ok, where is it?

[Raul A Jager <raul@xxxxxxxxxx>]

It does work, but the field renamed looses the "column headings".

Joe Pluta wrote:

> > From: Raul A Jager
> >
> > Using SQL you can do something similar to the "field reference file" The
> > way to do it is to:
> >
> > CREATE TABLE AS (SELECT x1, x2, x3, ..., etc. FROM FLDREF) DEFINITION ONLY
> >    
>
> This is very nice, Raul.  How about this:
>
> CREATE TABLE AS (SELECT x1 as y1, x2, ... FROM FLDREF) DEFINITION ONLY
>
> Is this possible (to rename the fields when you are creating the table)?
>
> Joe
>
> _______________________________________________
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
> To post a message email: MIDRANGE-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/midrange-l.
>