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


Chapter 3 Defining TDS, EES, SES, and TEM Tables : Task A: Define Table Properties

Task A: Define Table Properties
Purpose of this Task
In this task you:
Use the table identification segment of the screen for this task.
Table Identification Segment
The following example illustrates the fields used to identify the table:

 
Table: @EMPLOYEES Type TDS Unit: DOCEXMPLS IDgen: N

 
Table, Type, Unit, and IDgen Fields
The information for the Table, Type, Unit, and IDgen fields appears by default. You can modify the Table and Unit fields, if necessary. You cannot modify the Type field if data already exists in the table. For valid values, press PF1.
The table name displayed in the Table field is the one you specified when invoking the Table Definer. To save the definition of an existing table under a new name, type in a new name. For more information on how to copy TIBCO Object Service Broker objects, refer to TIBCO Object Service Broker Shareable Tools.
The type indicates how data is stored in the table or how data can be accessed from a table. If the table is new, a default value of TDS is supplied. You can change it to one of the allowed table types by typing in a valid value or pressing PF1 and selecting from the supplied list.
Refer to Available Table Types to determine the appropriate table type to define for your application requirements.
The unit indicates that the table belongs to a particular application or logical unit such as utilities, accounting, or network control.
The IDgen field determines whether TIBCO Object Service Broker should generate values for the primary key field. The default of N means that users who insert data into the table must enter a unique value for the primary key of each occurrence. A value of Y means that the system generates the value for the primary key of each occurrence. You must then use rules to populate the table with data. For more information, refer to Chapter 6, Manipulating Data in a Table.
If the table contains data and the IDgen field is set to Y, you can modify the field; however, if the field is set to N, you cannot modify the field.

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