![]() |
Copyright © TIBCO Software Inc. All Rights Reserved |
This task is used to define the external MAP attributes and internal TIBCO Object Service Broker attributes for the primary key fields and data fields of the table.
• When defining fields, you can type in external attributes and the TIBCO Object Service Broker attributes default to the external values, or vice versa.
• The number of fields you can access is dependent upon the Data Object Broker parameter CTABLESIZE. You can use the ESTIMATETBLDFN tool to estimate the size of this parameter.
This field contains the name of the primary key or data field you are creating. This name must be unique within the table. You can use a name already used for as a field in any other table; if you are moving data between this table and another table, giving fields the same name simplifies the process. This field contains the external syntax for the field. The external syntaxes E and J are not valid for OSB for z/OS. For more information on external syntaxes, refer to Mapping Data Types for MAP Table Definitions. This field contains the external number of decimal places for the field. This field contains the external offset of the field based on the length of the field. The offset is calculated from the start of the row (field) the cursor is on to the end of the defined fields in the TIBCO Object Service Broker MAP table definition. Overlaps of fields are allowed. You can specify offsets in one of three ways:
• The key field does not participate in offset calculations; the first non-key field has offset 0 by default.The following fields are used to specify the internal TIBCO Object Service Broker attributes. Use PF11 to view additional fields. For valid values, use PF1.
This field indicates if the MAP fields are to be used as a primary key. This field must be the first one in the definition and must have syntax B and length 4. Only a single key field can be specified. This field contains the TIBCO Object Service Broker semantic data type of the field. The default is null. You can specify any valid TIBCO Object Service Broker semantic data type and syntax combination supported for the external syntax. Valid combinations are described in TIBCO Object Service Broker Programming in Rules. This field contains the TIBCO Object Service Broker syntax of the field. You can specify any valid TIBCO Object Service Broker semantic data type and syntax combination supported for the external syntax. Valid combinations are described in TIBCO Object Service Broker Programming in Rules. If not specified, this field defaults to an appropriate syntax based on the external syntax and length (Xsyn and Xlen fields). This field contains the length of the field. The default is 0. If not specified, this field defaults to an appropriate length based on external syntax and length (Xsyn and Xlen fields). This field contains the number of digits to appear to the right of the decimal point. The default is 0. The data is padded or truncated as necessary. Depending on the syntax specified in the Syn field, define this field as follows:
• For syntax P, the number of decimal places must be smaller than twice the length of the entire field.
• For syntaxes B, C, F, RD, UN, and V, the number of decimal places must be 0. This field contains a value that determines whether a user is required to provide a value in this field for each occurrence in the table (for example, a primary key). The default is null (not required). This field contains the default value for the field. If no data is available, the value provided in this field is used. For example, if you specify a dot (.) as the default, it is used for an occurrence that has no value assigned to it.Default values are not permitted for fields of syntax F (float), RD (raw data) or UN (Unicode). Globalfield Name This field displays the name of the global field if you used PF14 to select a field from the global field dictionary.
• TIBCO Object Service Broker Shareable Tools for information on the ESTIMATETBLDFN tool.
• TIBCO Object Service Broker Parameters for more information about the CTABLESIZE Data Object Broker parameter.
![]() |
Copyright © TIBCO Software Inc. All Rights Reserved |