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


Chapter 8 Using Expressions and Operators : Syntax of Data Elements

Syntax of Data Elements
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.
Valid Syntaxes
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
Maximum total length for up to 16 fields in a composite primary key: 127.
24, 56, and 112 binary digits of precision for the mantissa.
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.
Not valid for Service Gateway for Datacom, Service Gateway for IDMS/DB, and Service Gateway for IMS/DB.
Not valid for key fields. Not valid for parameters except for SUB tables with a source table of DB2 or SLK type.
Not valid for Service Gateway for Datacom, Service Gateway for IDMS/DB, and Service Gateway for IMS/DB.
Variable‑length character string
Maximum total length for up to 16 fields in a composite primary key: 127.
Not valid for parameters except for SUB tables with a source table of DB2 or SLK type.
Double-byte or single-byte character string
Valid for z/OS only.

1
Table parameters are limited to binaries of length 2 and 4 and packed decimals of length 1 to 8.

2
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.

3
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.

4
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.

5
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
 
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.
See Also
TIBCO Object Service Broker Managing Data about defining TIBCO Object Service Broker tables.

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