Data Transformation Engine Functions and Expressions Reference Guide

Chapter 3 - Function Reference UNZONE
Functions and Expressions Reference Guide
217
Uses
Use
UNPACK to do arithmetic with a packed decimal number or to move a
packed decimal value into a numeric item.
Note You can define items as having a packed decimal number presentation. Then,
when mapping to or from these items, the conversion to and from packed
decimal is automatically performed as needed.
Related Function
PACK
UNZONE
The UNZONE function converts a text item that can be interpreted as a number
with a super-imposed sign in the rightmost byte (called zoned or signed data) to a
signed integer item.
Syntax
UNZONE ( single-text-expression )
Meaning
UNZONE ( text_to_unzone )
Returns
This function returns a single-integer.
Returns a signed integer representing the value text_to_unzone that is an
integer in zoned (signed) format. If the text_to_unzone cannot be interpreted
as a valid zoned number,
UNZONE evaluates to NONE.