db2 BIND FROM A REXX EXEC

[oregon999]

Hello all. I am try to write a rexx exec that will perform a db2 plan bind in a mvs/os390 environment. I have the bind input built and tested in batch. How do I get the BIND control statement to run in TSO?

 

[rexxhead]

Generally such tasks are handled by queueing the control statements and then activating the program that uses them. When the program wakes up it starts reading from the available input, the queue. So you would

queue blah blah blah
queue more blah
queue end (or quit or whatever)
address TSO "CRANKO"

Frank Clarke
Tampa Area REXX Programmers' Alliance
REXX Language Assn Listmaster

 

[stevexff]

This info may be a few years out of date, but I seem to remember that you can't run DSNC from REXX, but it does work from CLIST. Something to do with authorisation, I think.