The American Programmer

Books on TSO, ISPF

Manuals on TSO

SQL in Batch

You may want to execute some SQL in a batch job. You may want to do a SELECT to display data. You may want to do other SQL commands, such as INSERT, UPDATE or DELETE.

By submitting your job to batch you will free up your terminal and possibly use less CPU time than you would on-line. In addition, if your batch job appears to go into a loop, you can easily cancel it from your terminal.

//*THIS WILL EXECUTE SQL IN BATCH with the utility.
//*YOU NEED TO KNOW YOUR DB2-SUBSYSTEM NAME
//*FILL IT IN BELOW
//*
//*THIS CAN EXECUTE > 1 QUERY - SEPARATE THEM WITH SEMICOLON
//*
//*
//RUNSQL EXEC PGM=IKJEFT1A
//SYSTSPRT DD SYSOUT=*
//SYSPRINT DD SYSOUT=*
//SYSUDUMP DD SYSOUT=T
//SYSTSIN DD *
DSN SYSTEM(db2-subsystem)
RUN PROGRAM(DSNTEP2) PLAN(DSNTEP2)
END
//SYSIN DD *
SELECT * FROM Q.STAFF;
/*