Re: DDS ALIAS keyword

["John Taylor" <jtaylor@xxxxxxxxxxxx>]

Buck,

You can use SQL. The "LABEL ON" statement will do what you're after. ie:


label on MyTable(
    col01 is 'column_one',
    col02 is 'column_two',
    col03 is 'column_three')

Check the SQL Reference for details:

http://as400bks.rochester.ibm.com/pubs/html/as400/v4r5/ic2924/index.htm?info
/db2/rbafzmst02.htm



John Taylor



----- Original Message -----
From: "Buck Calabro" <Buck.Calabro@commsoft.net>
To: <midrange-l@midrange.com>
Sent: Thursday, August 23, 2001 14:45
Subject: DDS ALIAS keyword


> Is there any way except DDS to put an alias on a field?  We want to
"rename"
> Cool:2E fields into something SQL-friendlier so we can write some stored
> procedures...
>
> Buck
> _______________________________________________