Your assessment of the situation is pretty much on spot. While you can combine some things in SQL that require totally separate processes in DDS, like CRTPF/ADDPFCST vs the all-in-one SQL statement to cover it, there are some that you cannot. However, when you do have to break this up into multiple steps, it can still be all stored in one source member that can be executed with RUNSQLSTM: CREATE TABLE ROB/COCHRAN (MYCHAR CHAR (10 ) NOT NULL WITH DEFAULT); LABEL ON TABLE ROB/COCHRAN IS 'Delete me'; LABEL ON COLUMN ROB/COCHRAN (MYCHAR IS 'Sample Field'); Rob Berendt -- Group Dekko Services, LLC Dept 01.073 PO Box 2000 Dock 108 6928N 400E Kendallville, IN 46755 http://www.dekko.com Joel Cochran <jrc@xxxxxxxxxx> Sent by: midrange-l-bounces@xxxxxxxxxxxx 03/09/2004 09:04 AM Please respond to Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx> To midrange-l@xxxxxxxxxxxx cc Subject SQL Create Question... If I create a table on the 400 with SQL, how do I mimic the COLHDG feature of DDS at Create time? I've found that I can apply the "Label On ..." statement after the fact, but is there no way to embed this into the Create Table command? Joel http://www.rpgnext.com _______________________________________________ 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.
As an Amazon Associate we earn from qualifying purchases.
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.