Re: RUNSQLSTM in V6R1

[R Bruce Hoffman <bruce.hoffman@xxxxxxxxxxxxxxxxx>]

My personal preference is to operate in *SQL naming for DDL. The first 
thing I usually do is create an owner profile, named the same as the 
schema. Logon as that user, run the creation script. Poof.

Then, if we need another schema (library) with those same DDL created 
objects, create a new profile, logon, run... poof... copy number 2.


Mike Cunningham wrote:
> Is there any support in V6R1 that would allow parameters to be passed to the  RUNSQLSTM command that could be used in the SQL source as variables?
> Say you have a source file with a "CREATE VIEW PRODUCTION/VIEW..." command but sometimes you need to create that view in a development library and you want the command to be "CREATE VIEW DEVELOPMENT/VIEW..." It would be nice to be able to do a RUNSQLSTM PARM(DEVELOPMENT) and have the source "CREATE VIEW &LIBRARY/VIEW..."
>
> Or is the solution to just code "CREATE VIEW VIEW..." and make sure your current library is set to where you want the object created?
>