Skip to main content

Does any body help me how to execute Db2 query through JCL in Micro focus? Do we have any predefined utility?

  • October 29, 2018
  • 6 replies
  • 11 views
Dominique Sacre
Forum|alt.badge.img+2

I want to execute multiple queries through JCL and XMIT the results to various departments. Do we have any solution for this?


#EnterpriseDeveloper

6 replies

Dominique Sacre
Forum|alt.badge.img+2

I want to execute multiple queries through JCL and XMIT the results to various departments. Do we have any solution for this?


#EnterpriseDeveloper
Yes, the utility SQLTP2 can execute DB2 queries. Refer to "SQLTP2 Utility - Executing Dynamic SQL Statements" in Micro Focus documentation for more details.
Dominique Sacre
Forum|alt.badge.img+2

I want to execute multiple queries through JCL and XMIT the results to various departments. Do we have any solution for this?


#EnterpriseDeveloper
Yes, the utility SQLTP2 can execute DB2 queries. Refer to "SQLTP2 Utility - Executing Dynamic SQL Statements" in Micro Focus documentation for more details.
Dominique Sacre
Forum|alt.badge.img+2

I want to execute multiple queries through JCL and XMIT the results to various departments. Do we have any solution for this?


#EnterpriseDeveloper
Yes, the utility SQLTP2 can execute DB2 queries. Refer to "SQLTP2 Utility - Executing Dynamic SQL Statements" in Micro Focus documentation for more details.
Dominique Sacre
Forum|alt.badge.img+2

I want to execute multiple queries through JCL and XMIT the results to various departments. Do we have any solution for this?


#EnterpriseDeveloper
This utility is not recognising in my system.
Dominique Sacre
Forum|alt.badge.img+2

I want to execute multiple queries through JCL and XMIT the results to various departments. Do we have any solution for this?


#EnterpriseDeveloper
This utility is not recognising in my system.
Dominique Sacre
Forum|alt.badge.img+2

I want to execute multiple queries through JCL and XMIT the results to various departments. Do we have any solution for this?


#EnterpriseDeveloper
What product are you using? What version of product are you using? How's DB2 are you using? What error message are you getting when you run you job? Some of this very basic information should be able to allow us to point you in the right direction? The utility to do this on the mainframe would be DSNTEP2 and should be the program you execute in your JCL. Did you look in the documentation as suggested above. This is supported.
Still scrolling?
Ask a question
Terms & ConditionsAccessibility statement