Re: How to fix invalid DBCS data?

sjl wrote:

We are in the process of migrating historical data from a
Japanese subsidiary into our JDE system, and we have found
that some of their files have invalid data in some of the
fields. I would like to be able to write a program that
can identify which fields in which records have
potentially invalid DBCS data.

The files in question are CCSID 930.

Invalid in what sense? Some examples might be helpful. What error(s), and under what circumstances?

If the /invalid/ implies a data mapping error occurs for some data conversion\map operation, then the mapping error should identify the row in error. A CPYF or a SQL query which maps the column\data to a compatible data type & CCSID could record the mapping errors with relative row number. By review of record number causing the error, update those rows with the expected\valid data. The mapping could be defined in an LF instead of a query, that LF accessed by a program for RLA, could enable another way. Note that there can be no selection on the column if there is a mapping error evaluating the criteria, because the database can not conclude if the data should be omitted or included; i.e. any result set based on an inconclusive selection test would be inherently incorrect.

Regards, Chuck