JR45592: ICONV("SA","S") IS RETURNING ?00 IN THE DATASTAGE IF THE 1ST CHARACTER IS NOT BETWEEN A-Z OR A-Z.
Fixes are available
Closed as program error.
ICONV("ﾏsa","S") is returning ?00 in the DataStage job if the 1st character is not between A-Z or a-z.
In DataStage server jobs, the SOUNDEX and ICONV with S code functions in BASIC transformer stages can return unmappable strings when the first character in the data is not between A-Z or a-z.
Introduced an environment variable DSE_SOUNDEX_BEHAVIOR. When set to 1, an empty string will be returned from soundex if the first character is not A-Z or a-z.
Reported component name
Reported component ID
Last modified date
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
Fixed component name
Fixed component ID
Applicable component levels