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
  • 0 views
D

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

    D
    • Dominique SacreRocketeer
    • Author
    • Rocketeer
    • 19312 replies
    • October 29, 2018

    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.
    D
    • Dominique SacreRocketeer
    • Author
    • Rocketeer
    • 19312 replies
    • October 29, 2018

    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.
    D
    • Dominique SacreRocketeer
    • Author
    • Rocketeer
    • 19312 replies
    • October 29, 2018

    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.
    D
    • Dominique SacreRocketeer
    • Author
    • Rocketeer
    • 19312 replies
    • October 30, 2018

    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.
    D
    • Dominique SacreRocketeer
    • Author
    • Rocketeer
    • 19312 replies
    • October 30, 2018

    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.
    D
    • Dominique SacreRocketeer
    • Author
    • Rocketeer
    • 19312 replies
    • October 30, 2018

    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.


    Terms & ConditionsAccessibility statement