Data Transformation Engine Functions and Expressions Reference Guide

Chapter 3 - Function Reference ZONE
Functions and Expressions Reference Guide
225
ZONE
The ZONE function converts a signed integer item to a text item that can be
interpreted as a number with a superimposed sign in the rightmost byte (called
zoned or signed).
Syntax
ZONE ( single-integer-expression , single-integer-expression )
Meaning
ZONE ( integer_to_convert , sign_indicator )
Returns
This function returns a single-text-item.
Returns a text string that represents a zoned (signed) number representing
integer_to_convert.
Zoned integers have a sequence of digits except for the rightmost byte. The
rightmost byte is a digit with a super-imposed sign. The sign_indicator
specifies whether a super-imposed sign is required for positive integers, where
0 specifies no sign is required and any other value specifies that a sign is
required for positive integers.
The following table shows positive and negative values of the numbers 1230 to
1239, with a sign indicator of 0 (no sign is required for positive values) or a
sign of 1 (include a sign for both positive and negative values) in the rightmost
byte:
Positive Zoned Value
Integer Value sign_indicator = 0 sign_indicator = 1
1230 1230 123{
1231 1231 123A
1232 1232 123B
1233 1233 123C
1234 1234 123D
1235 1235 123E