Field Description using Create Table

Thanks to all who responded. I was not aware of the Label On statement,
works like a breeze. Unfortunate though that this facility cannot be
prompted on the Create table statement itself.

       Rgds


Label on table GDWEB/FTPUSEROP is
         'FTP: User defaults';
Label on column GDWEB/FTPUSEROP.LOGIN is
         'Login               Name  ';
Label on column GDWEB/FTPUSEROP.FTPOPER is
         'Operation           Allowed ';
Label on column GDWEB/FTPUSEROP.FTPPARM is
         'Operational         Parameters';


DAhKow@xxxxxxxxxxxxx
Sent by: midrange-l-bounces@xxxxxxxxxxxx
04/02/2003 04:45 AM
Please respond to Midrange Systems Technical Discussion

        To:     midrange-l@xxxxxxxxxxxx
        cc:
        Fax to:
        Subject:        Field Description using Create Table






Hello group,
      I prefer using the CREATE TABLE statement rather than using a DDS
and compiling to create files. However is there a possibility to add also
the field description. When prompting Create Table in an interactive SQL
session, I cannot see any way the system would allow this.

Thanks