Thanks Rob and Vern, that's what I was afraid of.

Joel
http://www.rpgnext.com

> message: 3
> date: Tue, 9 Mar 2004 14:32:39 -0500
> from: rob@xxxxxxxxx
> subject: Re: SQL Create Question...
> 
> 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

> ------------------------------
> 
> message: 5
> date: Tue, 09 Mar 2004 13:41:07 -0600
> from: Vern Hamberg <vhamberg@xxxxxxxxxxxxxxxxxxxxxxxxx>
> subject: Re: SQL Create Question...
> 
> Nope. You could try a RUNSQLSTM script, which can have multiple statements 
> in it.
> 
> HTH
> Vern
> 



As an Amazon Associate we earn from qualifying purchases.

This thread ...


Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2022 by midrange.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 on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.