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


Chapter 3 Managing IMP Data Definitions : Task B: Identify the Data

Task B: Identify the Data
You can use this task to specify the data you want to import and the name of external routines if you want to manipulate the data at its source before importing.
Data Identification Segment
The following example illustrates the fields used to identify the data:

 
File: USR40.EMPLOYEE.IMPORT
DDname: External Routine Name:
Server ID:

 
File Field
The File field contains the name of the data set or file that contains the data you want to import. The maximum record size is 31,744 bytes for all platforms. The record length for fixed-length files must be at least equal to the total length of the fields. The record length for variable-length files must be at least four more than the total length of the fields.
The External Routine Name field, which is valid only for the z/OS platform, contains the name of an external routine that you can use to manipulate data in the source file before importing it into TIBCO Object Service Broker. This routine is a load module resulting from an assembler program and resides in a data set that is concatenated to the external utilities data set. For more information, refer to External Routines (Pre-processing the Data).
Notes on the File
z/OS: Under CICS, you do not have to define the data set in a Destination Control Table (DCT) but the CICS region must have external security access to the data set.
Open Systems: To specify the format of the data in external files to be processed by TIBCO Object Service Broker, use the DSIXFTYPE Execution Environment parameter. For more information on the DSIXFTYPE Execution Environment parameter, refer to TIBCO Object Service Broker Parameters.
Open Systems: This filename maps to an entry in the filespec.dsn file. This file describes the absolute path name through which this file can be accessed. Refer to Appendix B, Mapping File Names for Open Systems for more information about this file.
If you use FTP to transfer a variable-length import table file between z/OS and Windows or Solaris, you must reformat the file using the TIBCO Object Service Broker z/OS utility S6BBRFRU. If the import file is fixed length, you do not need to reformat the file.
If you use FTP to transfer from z/OS to Windows or Solaris, the transfer must be in binary mode with the z/OS FTP LOCSITE subcommand with the NORDW parameter specified.
For parameterized import tables other than those defining a file of multiple record formats, the File field must specify a partitioned data set or a directory. Neither of these have to exist before you define the import table, and must exist before you access the data. Parameter values you provide become the data set member names or the filenames in the directory.
See Also
TIBCO Object Service Broker for z/OS Utilities for more information on S6BBRFRU 
DDname Field
The DDname field points to the file that contains the data you want to import. The DDname can be specified if you want to import from an uncataloged data set (possibly tape), or if you want to change the import file without changing the table definition.
Notes on DDname
z/OS: You must associate DDname with the data set that is the source of the data. To do this, use the DDNAME in your JCL or your TSO ALLOCATE command.
z/OS: To import data from a partitioned data set, specify the member in the DD statement of your JCL or TSO ALLOCATE command.
Open Systems: In the DDname field, specify either the name of the environment variable that contains the fully qualified name of the file, or the name of a DD definition in the filespec.dsn file.
Server ID Field
The Server ID field points to the gateway that is to be used if the table is to be accessed remotely via the Service Gateway for Files. This is an optional specification. The value in this field is determined from the SERVERID Execution Environment parameter.
Refer to Monitoring of Service Gateway for Files for details about the Server ID and the Service Gateway for Files.
See Also
TIBCO Object Service Broker Parameters for information about the SERVERID parameter.
Data Cleansing Field
Specify the data cleansing attributes as described in Appendix C (z/OS only).

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