×
The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.
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
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2025 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact
[javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.