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


Chapter 3 Managing IMP Data Definitions : Accessing External Data from TIBCO Object Service Broker

Accessing External Data from TIBCO Object Service Broker
To read external data directly from TIBCO Object Service Broker, you must define a TIBCO Object Service Broker table of type IMP. An import table can have one or more fields, up to 16 fields in a composite primary key (to a total maximum length of 127 bytes), and optional data and location parameters. The table can also contain multiple record formats.
Table Definer Screen for an Import Table

f
COMMAND==> TABLE DEFINITION

Table: EMPLOYEE_IMP Type: IMP Unit: USR40 IDgen: N

File:
DDname: External Routine Name:
Server ID:
Parameter Name Typ Syn Len Dec Class Src ' Event Rule Typ Acc
---------------- - -- --- -- - - ' ---------------- - -
_ LOCATION I C 16 0 L ' _
_ ' _
------- IMP --------|--------- Metadata Definition ------
Field Name Xsyn Xlen Xdec Offset Key Typ Syn Len Dec Ord Rqd Default
---------------- ---- ----- -- ----- - - -- ----- --- - - ----------
_
_
_
_
_
_
_
_
PFKEYS: 3=END 12=CANCEL 22=DELETE 13=PRT 14=FIELDS 6=OFFSET 21=DATA 2=DOC

 
Using a Copybook as the Source for the Definition
When you create a table in the TIBCO Object Service Broker UI, you can use a copybook as the source for its definition. You can then have TIBCO Object Service Broker monitor changes to the copybook. For more information, refer to Using Data Discovery.
Steps Required to Define an Import Table
After invoking the Table Definer (refer to Initial Step for Defining Tables for information on invoking the Table Definer), complete the following tasks to define an import table:
     Task

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