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 does 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 kept (so that the result is always exactly ten non-blank characters). A zero date field is returned as the string ****/**/**.
• Time fields are converted to the format hh:mm:ss with leading zeros kept (so that the result is always exactly eight non-blank 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 kept (that is, exactly eight non-blank characters, a blank, and eight more non-blank characters). A zero date field is returned as the string **/**/**.
• Hexadecimal fields are returned as is. You can use the C2X function of OPS/REXX to convert these fields to printable format.
• Encoded/encrypted fields are always returned as null strings. As a result, you cannot use OPSECURE to find out passwords.