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.
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.