![]() |
Copyright © TIBCO Software Inc. All Rights Reserved |
In this task you define the non-key fields for your table. Non-key fields are defined in the field segment of the Table Definer screen.The following example illustrates the fields you use to define the fields of your table. To view additional fields, press PF11.
For information about how to use fields with predefined attributes, refer to Selecting Global Fields.To define a new non-key field type information in the following fields in any order, after the primary key fields. For valid values, press PF1.
Field Name Enter the semantic data type of the field. For an explanation and valid values, refer to TIBCO Object Service Broker Programming in Rules. Enter the syntax of the field. For an explanation and valid values, refer to TIBCO Object Service Broker Programming in Rules. Specify the length of the field. The value is in bytes and valid values are determined by the syntax of the field. For valid lengths, refer to TIBCO Object Service Broker Programming in Rules. Specify the number of digits to the right of the decimal point. In most cases this is optional. It is relevant only for syntax P. Specify the ordering of the field (this is optional). The default value of null returns occurrences in ascending order by primary key. When an ordering option is explicitly specified it takes precedence over the default. When ordering is specified for more than one field, the sort precedence is determined by the order of the fields as they are listed in the table.Specifying a value in this field incurs sorting overhead, which can be significant in tables with a large number of occurrences. Specify the name of a reference table (this is optional). Specify a value only if a table is to be referenced when a user is inserting or replacing a value in the field. You then ensure that the user enters valid values for the field. The reference table must be non-parameterized. If the new value does not exist as a primary key value in the referenced table, the action fails validation.
![]() |
Copyright © TIBCO Software Inc. All Rights Reserved |