Data Extaction and Cleansing as/400

15 pts.
Tags:
as/400 data
AS/400 Data File
AS/400 Transfer
What is the best way to extract and clean data from AS/400 dbase?  We are planning to replace legacy systems with an integrated package that may have a different dbase.  Is there a good product / service?

Software/Hardware used:
as/400
ASKED: November 13, 2009  8:46 PM
UPDATED: November 16, 2009  2:50 PM

Answer Wiki

Thanks. We'll let you know when a new response is added.

Unless your file descriptions for both systems and the field names care exactly the same, a tool is not going to be found that can do this.
You need to define all your fields in the legacy system and the files they are comming from.
Then do the same with the target system.
Most likely you will have some fields that do not map and you to make a determineation for each one.

Discuss This Question: 2  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • Dataextract
    Can you please clarify for non-techie. I assume we are left with a multi-step process like: 1. writing SQL to pull data from DB2/400 2. create file for input into utility or excel etc for cleaning 3. update new dbase (from cleansed file) with import program that should exist with new application. Thanks
    15 pointsBadges:
    report
  • CharlieBrowne
    Yes, that's about it. The hardest part is field mapping. On your current system, you may have a data file with a data element called CODE. It may have a value of A, B, or C. You will need to know what to do with those codes. Are they still needed? Do you need to write values to different files depending on the code? If you have CODE = A, does that mean the you have to have values in other files? The point here is you need to understand all the data elements on the current system and then be able to map them to data elements on the new system.
    39,815 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following