>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.
This mailing list archive is Copyright 1997-2014 by MIDRANGE dot COM and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available here. If you have questions about this, please contact