DBCS Character Functions

DBCS character functions DCTRAN, DEDIT, DPART, DSTRIP, and DSUBSTR have been added to DataMigrator. These functions support operations on double-byte character data.

Functions

Arguments

Description

DCTRAN
(length, source_string, decimal, decvalue, output_format)

Translates a single-byte or double-byte character within a character string to another character based on its decimal value.

DEDIT
(length, source_string, mask_length, 'mask', output_format)

Extracts characters from or adds characters to a string when the server is configured to use a DBCS code page.

DPART
(date, 'component', output_format)

Retrieves a date component as a numeric value.

DSTRIP
(length, source_string, char, output_format)

Removes all occurrences of a specific single-byte or double-byte character from a string.

DSUBSTR
(length, source_string, start, end, sublength, output_format)

Extracts a substring based on its length and position in the parent string when the server is configured to use a DBCS code page.


WebFOCUS