opfgm.blogg.se

Free program runsqlstm in cl program examples
Free program runsqlstm in cl program examples










free program runsqlstm in cl program examples

Most source-code editors I’ve used are for interactive editing, but batch editors do exist, although they’re rare. It may be worth the effort to write an RPG, COBOL, or C program that will build or update a source member for you.Īnother option is to use Qshell’s stream editor, sed. What you want is the ability to put placeholders in the SQL source and specify replacement arguments on the RUNSQLSTM command, as you can do with the Start Query Management Query (STRQMQRY) command. Tomorrow I might want it to select company 007.

free program runsqlstm in cl program examples

Can I pass parameters to an SQL statement in a source member before executing the Run SQL Statement (RUNSQLSTM) command? I’m sure there must be a simple way, but I’ve never seen any examples of this.įor example, today I might like to have the SQL statement select company 005.












Free program runsqlstm in cl program examples