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


Chapter 3 Managing IMP Data Definitions : Task A: Identify the Table

Task A: Identify the Table
This task is used to:
Table Identification Segment
The following example illustrates the fields used to identify the table:

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

 
Table, Type, Unit, and IDgen Fields
The information for the Table, Type, Unit, and IDgen fields is entered by default. You can modify the Table and Unit fields, if necessary.
 
The table name displayed in the Table field is the one you specified when invoking the Table Definer. You can type in a new name to save the definition of an existing table under the new name. Refer to TIBCO Object Service Broker Shareable Tools for more information on the tools you can use to copy tables.
The type indicates how data is stored in the table or how data is to be accessed from a table. This field displays IMP, which you changed in Initial Step for Defining Tables.
The unit marks the table as belonging to a particular application or logical unit such as utilities, accounting, or network control.
The IDgen field determines whether values should be generated for the primary key field.
A value of Y means that the system generates the value for the primary key of each occurrence. Type Y if you are defining an import table for an external file that contains multiple record formats, multiple occurrences, or if you want a unique key for the import table.
 

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