RUNSQLSTM not valid for current release

[dacust]

Since no has answered, yet, I'll take a stab. 1) I am on 5.1 so I can't verify anything, but I would be surprised if RUNSQLSTM has actually been dropped. I'd guess you have lost an object. If I'm wrong, though.... 2) I'm fairly certain QM (Query Management) is included in the base OS, so try CRTQMQRY and RUNQMQRY and/or STRQM. Also CRTQMPRC (you'll need to look at the IBM site for manuals on how to write a QM procedure) and CRTQMFORM (if you're into S&M). There are 2 ideas, but maybe someone else will drop by with a more definate answer.

[Guest.Visitor]

The RUNSQLSTM command exists in QSYS on our V5R2 systems. Maybe product 5722ST1 didn't install correctly?

[Guest.Visitor]

I'm confused, all the books I see to create stored procedures use RUNSQLSTM to create them. This doesn't seem to be supported in V5R2M0. After finding the RUNSQLSTM in library QSYSV5R1M0 and adding it to my library list i get "RUNSQLSTM not valid for current release". I'm just now beginning to play with stored procedures and would prefer not to use a 3rd party product to create them. What is the prefered way to create stored procedures in V5R2M0. Thanks for any help you can provide. Randy

[Guest.Visitor]

Thanks for the help guys. I appreciate it.