how to run batch sql scripts on OS400

[ddiamond]

If you want to run sql interactively on the OS400, you can use strsql. How would you go about running them in batch mode instead?

 

[Mercury2]

Easy buddy. Insert the sql statements in a source member then use runsqlstm over this member. You can NOT pass any parameters to the member though.
The best way is to create this little sqlrpgle as shown at my page below :

http://www.psoriano.freesurf.fr/modele/utsql.htm

Note. If you can not read french, go to babelfish to get a so so page translation and request it to translate it:

http://babelfish.altavista.com/

The pgm code will bunch up but all of the text is now
readable in English, but I think it useless since there's not much text to read.

You can then use any sql stm (except "straight" select) using a normal call or callp or making your own command, in interactive and batch mode.

 

[ddiamond]

Thanks. Unfortunately, our network security is blocking the website

http://babelfish.altavista.com/.

I'll have to take a look at this when I get home.