External Data Accesses

Copyright © Cloud Software Group, Inc. All Rights Reserved

Chapter 1 Introducing External Data Interfaces : External Data Accesses

External Data Accesses

Accesses to import, export and most VSAM data sets are included with the base TIBCO Object Service Broker product. These are described in the following sections. Access to Adabas and VSAM LDS data are described in the TIBCO Service Gateway for Files SDK User’s Guide.

IMP (Import)

You use IMP tables to read (import) external files directly into TIBCO Object Service Broker. Depending on the operating system and type of organization, external files can be sequential data sets or members of partitioned data sets (z/OS), or a file or files within a directory (Windows or Solaris).

You use the Table Definer to define an IMP table. At execution time, you specify the file to import and access the data either online or in batch mode.

For more information on IMP tables, refer to Chapter 3, Managing IMP Data Definitions, and to Chapter 5, Manipulating Import Data Using TIBCO Object Service Broker.

EXP (Export)

You use EXP tables to write (export) TIBCO Object Service Broker tables directly to external files. Depending on the operating system and type of organization, external files can be sequential data sets or members of partitioned data sets (z/OS), or a file or files within a directory (Windows or Solaris).

You use the Table Definer to define an EXP table and insert data into the table using TIBCO Object Service Broker tools. After data is inserted into the table, you access the data outside of TIBCO Object Service Broker. At execution time, specify the target export file and export this data either online or in batch mode.

For more information on EXP tables, refer to Chapter 6, Managing EXP Data Definitions, and Chapter 7, Processing External Data Using TIBCO Object Service Broker.

VSM (VSAM)

You use VSM tables to access data in a VSAM file. You use the Table Definer to define a VSM table and use TIBCO Object Service Broker tools to access the data. For more information on VSM tables, refer to Chapter 8, Managing VSAM Data Definitions, and to Chapter 10, Processing VSAM Data Using TIBCO Object Service Broker.