![]() |
Copyright © TIBCO Software Inc. All Rights Reserved |
You use this task to define the external export and internal TIBCO Object Service Broker attributes for the primary key fields and non-key fields of a table.
--------- EXP ------|---------- Metadata Definition ------
Field Name Xsyn Xlen Xdec Offset Key Typ Syn Len Dec Rqd Default
---------------- ---- ---- -- ----- - - -- ---- -- - --------------
_
_
_
_
_
• When defining fields, you can type in external export 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.
• If LRECL is not specified in the DCB information at runtime, the position of the last byte of the right-most field (as specified in the external field definition) is used to calculate the LRECL.The following fields are used to specify the external export attributes. Use PF1 for valid values for each field:
This field contains the name of the export field within the table definition. You can use the same name as a field in any other table. If you are moving data between this table and another table, giving fields the same names simplifies the process. This field contains the external syntax for the export field. If not specified, the Xsyn field defaults to the specified TIBCO Object Service Broker syntax (Syn field). On Open Systems, numeric external syntaxes are treated as C or V for TEXT files. For information on external syntax, refer to Appendix A, Mapping Data Types. This field contains the external length for the export field. If not specified, the Xlen field defaults to the specified TIBCO Object Service Broker length (Len field). For information on external lengths, refer to Appendix A, Mapping Data Types.On the Open Systems platforms, the Xlen field is ignored for TEXT files with a field separator character defined. This field indicates the external number of decimal places for the export field. If not specified, the Xdec field defaults to the specified TIBCO Object Service Broker decimal place (Dec field). This field specifies the offset of the export field relative to the start of the external record. The origin is zero. You do not need to define fillers, since the offset can be used to skip undefined locations in the row. You can specify offsets in one of three ways:On the Open Systems platforms, the Offset field is ignored for TEXT files with a field separator character defined.The following fields are used to specify the internal TIBCO Object Service Broker attributes. Use PF1 for valid values for each field. To view additional fields, use PF11:
This field indicates if the export fields are to be used in the primary key. You can select any field as the primary key using the P line command, without respect to uniqueness of data. You can select up to 16 contiguous fields for a composite primary key, to a total maximum length of 127 bytes. This field contains the TIBCO Object Service Broker semantic data type of the export 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. For valid combinations, refer to TIBCO Object Service Broker Programming in Rules. This field contains the TIBCO Object Service Broker syntax of the export field. You can specify any valid TIBCO Object Service Broker semantic type and syntax combination supported for the external syntax. For valid combinations, refer to TIBCO Object Service Broker Programming in Rules. If a syntax is not specified, the Syn field defaults to an appropriate syntax based on the external syntax and length (Xsyn and Xlen fields). For more information on external syntax, refer to Appendix A, Mapping Data Types. This field indicates the length of the export field. The data is padded or truncated as necessary. If a length is not specified, the Len field defaults to an appropriate length based on the external syntax and length (Xsyn and Xlen fields). This field specifies the number of digits to appear to the right of the decimal point. The data is padded or truncated as necessary. If not specified, the Dec field defaults to the specified external number of decimal places (Xdec field).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 indicates the order (ascending or descending) in which the occurrences in this field are sorted. The default value of null returns occurrences unsorted. 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.Ordering is not permitted for fields of syntax F (float), RD (raw data) or UN (Unicode). This field indicates whether the user is required to provide a value for each occurrence in the table. The default is null (not required). This field contains the default value for the field when it appears. If no data is available, the value provided in this field is used. For example, if you specify a dot (.) as the default, it appears for a field that does not have any values. If you do not specify anything, a blank space appears.For numeric fields of Q or C, specify a value such as 0.00 if arithmetic operations are to be performed on the field; arithmetic operations cannot be performed on data containing null values. 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 Managing Data for information on global fields.TIBCO Object Service Broker Parameters for more information about the CTABLESIZE Data Object Broker parameter.
![]() |
Copyright © TIBCO Software Inc. All Rights Reserved |