![]() |
Copyright © TIBCO Software Inc. All Rights Reserved |
Each data element of an expression has a syntax. The syntax of a value, local variable, or field describes how the data is stored. The syntax and length of a field are specified in the table definition. The syntax for a local variable is determined when a value is assigned to it. The syntax of a literal is determined by its content.The following table describes the valid syntaxes, their permitted lengths, and additional information to help you in their use:
A length of 2 supports values ‑32,768 to 32,767.A length of 4 supports values of ‑2,147,483,648 to 2,147,483,647.A length of 12 supports values of -39,614,081,257,132,168,796,771,975,168 to 39,614,081,257,132,168,796,771,975,167 Fixed‑length character string 1 to the maximum length for an occurrence - 2. 2Maximum total length for up to 16 fields in a composite primary key: 127.Maximum total length for all data parameters: 240. 24, 56, and 112 binary digits of precision for the mantissa.Approximate range: 5.4 x 10 -79 to 7.2 x 1075. 3 Should not be used when exact comparisons or exact values are required. Packed decimal Consists of a 4‑byte length followed by data.Not valid for key fields. Not valid for parameters except for SUB tables with a source table of DB2 or SLK type.Does not support default values in the Table Definer.Not valid for Service Gateway for Datacom, Service Gateway for IDMS/DB, and Service Gateway for IMS/DB. 2 to the maximum length for an occurrence - 2. b Not valid for key fields. Not valid for parameters except for SUB tables with a source table of DB2 or SLK type.Does not support default values in the Table Definer.Not valid for Service Gateway for Datacom, Service Gateway for IDMS/DB, and Service Gateway for IMS/DB. Variable‑length character string 1 to the maximum length for an occurrence - 2.bMaximum total length for up to 16 fields in a composite primary key: 127. Uppercase and lowercase alphanumerics.Not valid for parameters except for SUB tables with a source table of DB2 or SLK type. Double-byte or single-byte character string Uppercase and lowercase alphanumerics.Valid for z/OS only.
The maximum length of a field is limited by the maximum length of an occurrence for a table type. Refer to Maximum Occurrence Length. The length calculation for a table occurrence includes all of the table fields and parameters and is 17 + sum(short field length + 1) + sum(long field length + 2) + sum(data parameter +1). A short field length is <= 127 and a long field length is > 127.
In Open Systems, if you need to get results from arithmetic on floating-point data that are identical to what you would obtain with pre-Release 4.0 TIBCO Object Service Broker, use the NOIBMFLOAT Execution Environment parameter. For more detail, refer to TIBCO Object Service Broker Parameters.
Byte length=half-byte for each decimal digit plus half-byte for sign. Round up to the nearest whole byte. Specify the number of digits after the decimal separator in the Table Definer.
A single display position can display a single-byte character; however, you need two display positions to display a double-byte character.
Maximum Occurrence Length in Bytes TIBCO Object Service Broker ADABAS table. TIBCO Object Service Broker CA-Datacom table. TIBCO Object Service Broker DB2 table. TIBCO Object Service Broker CA-IDMS table. TIBCO Object Service Broker IMS table. TIBCO Object Service Broker SLK table. TIBCO Object Service Broker VSAM table. TIBCO Object Service Broker Managing Data about defining TIBCO Object Service Broker tables.
![]() |
Copyright © TIBCO Software Inc. All Rights Reserved |