What is the DB2 utility to select SQL from a JCL?

dharmendra_kp · New User Joined: 10 Mar 2005 Posts: 33 Location: Lewiston

I used to run DB2 select SQL queries against standard db2 utility form a JCL for generating report, similar to unload utility DSNUPROC. But during last two years I have completely forgotten the utility name and syntax.

Please help me by giving any info link, that you can.

Thanks & regards
Dharmendra

Gnanas N · Posted: Thu Nov 27, 2008 5:12 pm

Hi Dharmendra,

Are you referring DSNTEP2 or DSNTEP4?

This is the link
publib.boulder.ibm.com/infocenter/dzichelp/v2r2/index.jsp?topic=/com.ibm.db29.doc.apsg/db2z_dsntep24.htm

Anyway, please check it with the peers or support to get sample JCLs with your standards.

dharmendra_kp · New User Joined: 10 Mar 2005 Posts: 33 Location: Lewiston

Thanks Gannas,
I got the utility that I was looking for. Its DB2HPU. But unfortunetely its not available in my current shop. So I have just looked into manuals for DSNTEP2. I think this will serve the purpose. I wil keep you posted on my progress.

Anuj Dhawan · Posted: Mon Dec 01, 2008 3:03 pm

Hi,

If you explain a little more about what you are actually looking for, hopefully, some one will be around. So far, the description from your side does not give us much to help you out.

dharmendra_kp · New User Joined: 10 Mar 2005 Posts: 33 Location: Lewiston

Hi All,
I had a requirement to automate a set of reports. Hitherto these report were generated by running adhoc SPUFI. So I had two option
1. Use DB2 utility to run the SQL or
2. write a program

Since this query is fairly dynamic, I mean the requirements of the report changes frequently. So writing a program means overhead. So I started looking for suitable utility and found that earlier I used DB2HPU. This is a standard utility to run all DML and select SQL query. Here you can give HEADER <report header>. also. But this is not available in my shop.

So I successfully used productivity-aid sample program DSNTIAUL.
This program, which is written in assembler language, is a simple alternative to the UNLOAD utility. It unloads some or all rows from up to 100 DB2 tables. With DSNTIAUL, you can unload data of any DB2 built-in data type or distinct type. You can unload up to 32 KB of data from a LOB column. DSNTIAUL unloads the rows in a form that is compatible with the LOAD utility and generates utility control statements for LOAD. DSNTIAUL also lets you execute any SQL non-SELECT statement that can be executed dynamically.

Thanks and regards
Dharmendra