OPS/REXX Built-in Functions › OPSECURE Function › Conversion of Retrieved Fields

Conversion of Retrieved Fields

OPSECURE always returns fields as character strings without any leading or trailing blanks. OPS/REXX performs the following conversions depending on field format:

• Binary fields are converted to signed decimal values without leading zeros or blanks. The number zero is returned as 0.
• Character fields are returned as is, possibly truncated to the OPS/REXX-defined maximum valid string length.
• Date fields are converted to the format yyyy/mm/dd with leading zeros retained (so that the result is always exactly ten nonblank characters). A zero date field is returned as the string ****/**/**.
• Time fields are converted to the format hh:mm:ss with leading zeros retained (so that the result is always exactly eight nonblank characters).
• Bit fields are converted to a 0 (FALSE or off) or a 1 (TRUE or on).
• Clock fields are converted to the format yy/mm/dd hh:mm:ss with leading zeros retained. The format contains exactly eight nonblank characters, a blank, and eight more nonblank characters. A zero date field is returned as the string **/**/**.
• Hexadecimal fields are returned as is. Use the C2X function of OPS/REXX to convert these fields to a printable format.
• Encoded/encrypted fields are always returned as null strings. As a result, you cannot use OPSECURE to find out passwords.