The type of data that you are processing determines whether you must use single quotation marks (' ') to delimit the data. In general, string literals require quotation marks and numeric literals do not. The following sections describe the usage of quotation marks and compound delimiters containing the quotation mark.
If your processing operation uses a string literal, you must delimit the value with opening and closing single quotation marks, for example, when specifying a parameter value for a table, as in:
Because in Unicode literals the slash (/) is treated as an escape character to enable exact specification of a Unicode character (for example, U
'/20AC' is the euro sign), you need a way to place a displaying slash within a Unicode literal. To do this, use two slashes. For example: U
'I//O' represents the value I/O.
TIBCO Object Service Broker objects, rules arguments, and local variables are not considered to be string literals and therefore are not enclosed in quotation marks. The only exception to this is when an object is being passed as an absolute value. For example:
Except for some special cases with primary keys described in Exceptions when Accessing Primary Key Fields, numeric literals do not require quotation marks. Since TIBCO Object Service Broker does not permit identifier names to begin with a digit, these literals can be recognized by their totally numeric composition.
Because primary key values are not stored in a compressed state, when referring to a primary key with syntax C or V and with a value that has leading zeros, you must specify the value within quotation marks. For example, if a primary key field of MONTH is defined with syntax C or V and has a value of 01, a GET statement with
MONTH='01' is correct but
MONTH=1 or
MONTH=01 is incorrect.