A MultiValue internal-to-external conversion function for dynamic arrays.
||A MultiValue dynamic array, each element of which specifies a value in internal (storage) format.
||A character code, specified as a quoted string, that specifies the type of conversion to perform. Conversion is from internal format to external format.
function is a MultiValue conversion function used to convert the element values in a MultiValue dynamic array from internal (storage) format to external (output) format. The type of conversion is specified by a character code
string that is specific to the type of data to be converted.
is a Caché SQL extension and is intended for MultiValue data compatibility. It is functionally identical to the MultiValue OCONVS
function, as described in the Caché MVBasic Reference
. Refer to OCONVS
for further information.
The following types of conversions are supported:
Character conversions: character-to-code, code-to-character.
Numeric conversions: decimal-to-hex, hex-to-decimal, masked decimal conversion, range extraction.
String conversions: case conversion, Soundex conversion, string length conversion, uniform string length adjustment, delimited substring extraction, pattern match extraction, string extraction by length.
Time and Date conversions: time internal-to-display format, date internal-to-display format, date display-to-internal format, date element extraction, date day-of-week, day-of-year, and quarter calculation.
function converts dynamic array elements from internal format to external format. The $MVICONVS
function converts dynamic array elements from external format to internal format. You can use the $MVOCONV
function to convert a string from internal format to external format.