![]() |
Copyright © TIBCO Software Inc. All Rights Reserved |
Developer’s workbench Type BATCHUNLD_CARDS (unload_source) <Enter> Type EX BATCHUNLD_CARDS (unload_source) <Enter>
• DATABASE - If you are preparing control cards for the S6BBRULH/hrnbrulh or S6BBRULB/hrnbrulb utilities.
• ARCHIVE - If you are preparing control cards for the S6BBRULA/hrnbrula utility.BATCHUNLD_CARDS helps you define the control cards required by the Batch Unload utilities. There are three Batch Unload utilities:
• S6BBRULH/hrnbrulh (Batch Unload while TIBCO Object Service Broker is running and the segment is online)
• S6BBRULB/hrnbrulb (Batch Unload while TIBCO Object Service Broker is shut down or the segment is offline)BATCHUNLD_CARDS displays a screen for you to specify the table or tables to unload, and if the table is parameterized, you can choose table instances. The utility then defines control cards and selection criteria in two separate files.If you are using FTP to transfer unloaded data between z/OS and Windows, Solaris, or UNIX, it is no longer mandatory to use the S6BBRFRU z/OS utility before the data can be used by TIBCO Object Service Broker. Refer to TIBCO Object Service Broker for z/OS Utilities for more information about S6BBRFRU.See TIBCO Object Service Broker for z/OS Utilities or TIBCO Object Service Broker for Open Systems Utilities for information on the method used by the unload utilities to preserve null values in the unload file. The unload utilities use specific field values to represent nulls in the unload file.On z/OS systems, before you can use BATCHUNLD_CARDS, you must allocate a file for the control cards, and if you are going to specify table instances, also allocate a file for the selection criteria. The file attributes are as follows:
• CNTRL - The control card file specifies the definition of the table to be unloaded. The CNTRL file should be defined as fixed block, record length 80.
• SELECT - [Optional] The selection criteria file contains criteria for selecting table instances from a parameterized table set. If a SELECT file is required, it should be defined as fixed block, record length 530.
See TIBCO Object Service Broker Parameters for information on the DSBIFTYPE Execution Environment parameter.where unload_source is one of the following:
• DATABASE if you intend to use S6BBRULH/hrnbrulh or S6BBRULB/hrnbrulb
Task B Supply field values
The file (and its member name if the file is a z/OS partitioned data set) to contain the BATCHUNLD_CARDS output. You can change the filename by typing over it. Selection Criteria File The file (and its member name if the file is a z/OS partitioned data set) to contain the selection criteria, if you are selecting table instances of a parameterized table. The TDS table to be unloaded. You can specify only one table for S6BBRULH/hrnbrulh or S6BBRULB/hrnbrulb and up to 999 for S6BBRULA/hrnbrula.If you want to select table instances of a parameterized table for inclusion in the unload file, specify selection criteria for each data parameter. The selection criteria are subject to the following constraints:
• You must make a selection for each data parameter and join the parameters with the AND (&) logical operator. For example, if the EMPLOYEE table had REGION and CITY data parameters, you must specify both REGION and CITY:
• You must use the same operator for each parameter specification in one selection. Operators you can use are:
• You can make more than one selection, but you can use only one of the following operators on a table:
After specifying the table and any table instances to be unloaded, press PF3 to write the control cards and selection file to your files. The control cards definition is then complete.
![]() |
Copyright © TIBCO Software Inc. All Rights Reserved |