Re: SQL Create Question...

[Joel Cochran <jrc@xxxxxxxxxx>]

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
>