Re: DDS ALIAS keyword

["Peter Dow" <pcdow@xxxxxxxxx>]

Hi Buck,

You can do it when you create a table:

CREATE TABLE MyTable (LongFieldName1 FOR COLUMN ShortName1 CHAR (4))

The LongFieldName1 is the alias, the ShortName1 is the system name which
must be 10 characters or less.


You can use

    LABEL ON TABLE MyTable IS 'This is the file object text, 50 char max'

    LABEL ON COLUMN MyTable (
     LongFieldName1 TEXT IS 'The 50-char max field text')

    LABEL ON COLUMN MyTable (
     LongFieldName1 IS 'ColHdg line1........ColHdg line2........ColHdg
line3........')

instead of

    CHGPF FILE(MYTABLE) TEXT('This is the file object text, 50 char max')

    MyTable DDS:
        A        ShortName1            TEXT('The 50-char max field text')

        A                              COLHDG('ColHdg line1........+
                                               ColHdg line2........+
                                               ColHdg line3........')


hth,
Peter Dow
Dow Software Services, Inc.
909 425-0194 voice
909 425-0196 fax


----- Original Message -----
From: "Buck Calabro" <Buck.Calabro@commsoft.net>
To: <midrange-l@midrange.com>
Sent: Thursday, August 23, 2001 1:45 PM
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
> _______________________________________________
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
list
> To post a message email: MIDRANGE-L@midrange.com
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/cgi-bin/listinfo/midrange-l
> or email: MIDRANGE-L-request@midrange.com


_________________________________________________________
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com