import mysql.connector #Import the Z Open Automation Utilities libraries we need from zoautil_py import MVSCmd, Datasets, Jobs from zoautil_py.types import DDStatement # Import datetime, needed so we can format the report from datetime import datetime # Import os, needed to get the environment variables import os import string import time #Take the contents of this data set and read it into content variables USERID = os.getenv('USER') hlq = Datasets.hlq() print("running jobs for ", hlq) damember = "%s.OUTPUT.SDSFDAS" % hlq da_contents = Datasets.read(damember) #ckmember="%s.OUTPUT.SDSFCKS" % hlq #hc_contents = Datasets.read(ckmember) now = datetime.now() formatted_date = now.strftime('%Y-%m-%d %H:%M:%S') #Submit the job jclmember = "%s.JCL(SDSFJCL)" % hlq jobid = Jobs.submit(dataset=jclmember) while True: js = Jobs.list(job_id=jobid)[0] if (js["return"] != "?"): break else: print(js)
#Import the Z Open Automation Utilities libraries we need from zoautil_py import MVSCmd, Datasets from zoautil_py.types import DDStatement # Import datetime, needed so we can format the report from datetime import datetime # Import os, needed to get the environment variables import os #Take the contents of this data set and read it into cc_contents cc_contents = Datasets.read("MTM2020.PUBLIC.CUST16") USERID = os.getenv("USER") output_dataset = USERID + ".OUTPUT.CCINVALD" #Delete the output dataset if it already exists if Datasets.exists(output_dataset): Datasets.delete(output_dataset) Datasets.create(output_dataset, "SEQ") # Create a new SEQUENTIAL DATA SET with the name of output_dataset #A function that checks to see if the number passed to it is even. Returns True or False (Boolean) def is_even(num_to_check ): # this is a function. num_to_check is what gets sent to it if ((num_to_check % 2) == 0): # a simple check to see if num_to_check is even. result = True # We set result to True return result # and then return it. else: # if it isn't result = False # set return to False
# Delete datasets if already exist Datasets.delete("USR.MVSCMD.DFSORT.*") # Create datasets Datasets.create("USR.MVSCMD.DFSORT.MASTER", type="SEQ") Datasets.create("USR.MVSCMD.DFSORT.NEW", type="SEQ") Datasets.create("USR.MVSCMD.DFSORT.CMD", type="SEQ") Datasets.create("USR.MVSCMD.DFSORT.MERGE", type="SEQ") # Write command to USR.MVSCMD.DFSORT.CMD Datasets.write("USR.MVSCMD.DFSORT.CMD", " MERGE FORMAT=CH,FIELDS=(1,9,A)") # Write example text to USR.MVSCMD.DFSORT.MASTER Datasets.write("USR.MVSCMD.DFSORT.MASTER", "Chang Joe 278 232 6043") Datasets.write("USR.MVSCMD.DFSORT.MASTER", "DeBeer Jo 348 132 6023", append=True) Datasets.write("USR.MVSCMD.DFSORT.MASTER", "White Belinda 178 222 5043", append=True) # Write example text to USR.MVSCMD.DFSORT.NEW Datasets.write("USR.MVSCMD.DFSORT.NEW", "Doe Jane 878 222 5043") Datasets.write("USR.MVSCMD.DFSORT.NEW", "Smith Joe 778 232 6043", append=True) Datasets.write("USR.MVSCMD.DFSORT.NEW", "Smyth Jo 748 132 6023", append=True) rc = MVSCmd.execute(pgm="sort", args="MSGPRT=CRITICAL,LIST", dds=dd_statements) if rc == 0: print(Datasets.read("USR.MVSCMD.DFSORT.MERGE"))