Skip to Content

Default language.

Information
Space announcement The Using section of the MainView for DB2 documentation is now available in Japanese. The displayed language is dependent on your browser language. You can switch languages from the Language menu.

Specifying JCL options in batch mode

When you run a job in batch mode, the Batch Job panel is displayed. Use this panel to specify JCL options before executing a job in batch mode.

PSSPB000 ----------------------- Batch Job ------------------------------------
Command ===>                                                                   
                                                                               
JCL Data Set . . . 'RDAKNN.SQLXPLR.CNTL(SQLX####)'                             
Current Counter    37    (Replaces #### in member name, then incremented)      
                                                                               
Set JCL Options    N     (Y/N - Change options for creating JCL)                  
Build Job  . . . . Y     (Y/N - Create JCL, save in JCL data set)                 
Edit Data Set  . . Y     (Y/N - Edit JCL data set)                                
Submit . . . . . . N     (Y/N - Submit JCL data set)

To specify batch JCL options

  1. In the JCL Data Set field, specify the data set to which SQL Explorer writes the generated JCL.You can type the name of a partitioned or sequential file, or you can specify the TEMP keyword. If you specify TEMP, SQL Explorer uses the data set specified in ZTEMPF.

    Warning

    Note

    If the Allocate Data Set panel is displayed during this procedure, provide allocation information as discussed in Allocating-a-data-set-for-a-specific-job.

  2. In the Current Counter field, enter any value from 1 through 9999 to replace the '####' suffix in the PDS member name.If needed, SQL Exploreradds leading zeros to fill the four-digit suffix.
  3. (optional) In the Set JCL Options field, specify Y to review or change options for creating JCL.

  4. In the Build Job field, specify whether to generate the JCL into the data set that you specified in the JCL Data Set field.

    Warning

    Note

    After you build and edit the JCL the first time, an asterisk (*) is shown in both the Build Job and Edit Data Set fields to ensure that you do not accidentally regenerate and write over your existing JCL.

  5. In the Edit Data Set field, specify whether to edit the data set online.If you specify Y, the JCL is displayed in an ISPF edit session.
  6. In the Submit field, specify whether to submit the JCL for execution.BMC recommends that you specify N the first time the Batch Job panel is displayed. After SQL Explorergenerates the JCL, make any necessary changes to your data set. When the Batch Job panel is displayed again, specify Y in the Submit field to execute the JCL.
  7. Press Enter to complete the actions that you specified.

Related topic

Explaining-SQL-Statements



 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*

MainView for DB2 6.1