Copyright © TIBCO Software Inc. All Rights Reserved
Copyright © TIBCO Software Inc. All Rights Reserved


Chapter 3 Tools : BATCHUNLD_CARDS

BATCHUNLD_CARDS
Defines the control cards required by the Batch Unload utilities. (E)
Invocation
Do one of the following:
Type BATCHUNLD_CARDS (unload_source) <Enter>
Type EX BATCHUNLD_CARDS (unload_source) <Enter>
Where:
DATABASE - If you are preparing control cards for the S6BBRULH/hrnbrulh or S6BBRULB/hrnbrulb utilities.
Usage Notes
BATCHUNLD_CARDS helps you define the control cards required by the Batch Unload utilities. There are three Batch Unload utilities:
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.
Preparation
Allocate 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.
Specify the File Type
On non-z/OS systems, set the DSBIFTYPE Execution Environment parameter to TEXT.
See TIBCO Object Service Broker Parameters for information on the DSBIFTYPE Execution Environment parameter.
Procedure to Invoke the Control Card Preparation Facility
To invoke the control card preparation facility, complete the following tasks:
1.
2.
3.
These tasks are described here.
 
Task A Run BATCHUNLD_CARDS from the workbench
EX execute rule ==> BATCHUNLD_CARDS(unload_source)
where unload_source is one of the following:
The screen displayed is illustrated with sample input as follows:

 
CONTROL CARD SPECIFICATION FOR BATCH UNLOAD FROM DATABASE
Control Card File
USR01.BATCH.CNTLCARD(JAN2000)
Selection Criteria File
USR01.BATCH.SELECT(JAN2000)
Tables Selection of table instances for parameterized table set
---------------- --------------------------------------------------------
_ EMPLOYEE REGION = 'MIDWEST'
_ EMPLOYEE REGION = 'SOUTHWEST'
_
 
 
 
 
 
PFKEYS: 1=HELP 3=SAVE 12=CANCEL

 
Task B Supply field values
Supply values for the following fields:
 
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.
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.
Task C Select table instances for a parameterized table
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:
REGION = 'MIDWEST' & CITY = 'CHICAGO'
For example, a correct use of operator for two parameters is:
REGION = 'MIDWEST' & CITY = 'CHICAGO'
For example, valid selection criteria are:
REGION = 'MIDWEST' & CITY = 'CHICAGO'
REGION = 'SOUTHWEST' & CITY = 'DALLAS'
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.
Review the Output File
A sample output file containing the control cards is shown here:

 
H 000 T EMPLOYEE 001 014
H 000 P REGION I C 016 000
H 000 F EMPNO I P 003 000
H 000 F LNAME S C 022 000
H 000 F POSITION S C 014 000
H 000 F MGR# I P 003 000
H 000 F DEPTNO I B 002 000
H 000 F SALARY Q P 004 002
H 000 F HIREDATE S C 009 000
H 000 F ADDRESS S V 038 000
H 000 F CITY S C 020 000
H 000 F STATE_PROV S C 004 000
H 000 F ZP_CODE S C 007 000
H 000 F BIRTHDATE S C 010 000
H 000 F SEC_GROUP I C 016 000
H 000 F ACCESSTYPE S C 001 000
H 000 R

 
An example of a selection criteria file is shown here:

 
**************** 0002
EMPLOYEE I=MIDWEST
EMPLOYEE I=SOUTHWEST

 

Copyright © TIBCO Software Inc. All Rights Reserved
Copyright © TIBCO Software Inc. All Rights Reserved