Re: Field Description using Create Table

[rob@xxxxxxxxx]

>From one of our productions RUNSQLSTM source members:

Create table GDWEB/FTPUSEROP
       (
       LOGIN character varying(100) not null,

       FTPOPER integer
        constraint FTPUSEROP_InvalidAllowedOperation check(
         (FTPOPER between 0 and 9) or (FTPOPER=999)),

       FTPPARM char (999) not null
        constraint FTPUSEROP_InvalidParameter check(FTPPARM<>' '),

        constraint FTPUSEROP_DuplicateUserAllowedOperations
         Primary key(LOGIN, FTPOPER, FTPPARM),

        constraint FTPUSEROP_InvalidUser
         Foreign key (LOGIN)
         References GDWEB/FTPUSER (LOGIN)
       );


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';

Rob Berendt
-- 
"They that can give up essential liberty to obtain a little temporary 
safety deserve neither liberty nor safety." 
Benjamin Franklin 




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

_______________________________________________
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.