Link to home
Start Free TrialLog in
Avatar of mmayan
mmayan

asked on

VSAM,Flat Files & Mainframe DB2 to ASCII Data Text Files with delimiters

Hi,
   My source data are in VSAM,Flat Files & Mainframe DB2.I need to port the data into informix running on AIX unix.If the data file is with delimetrs like "pipe" ,using "dbload" utility i can upload the data into informix database.I need the stpes or technique to convert the data from VSAM,Flat Files & Mainframe DB2 structures to ASCII data text files with delimeters like 'pipe'.

Thanks
Mayan  
Avatar of dbalaski
dbalaski

Hi,

Its been a long time since I've dealt with VSAM  --  and I cannot say I am a DB2 user...
However,  you might consider using an ETL tool to extract and load the data into your system.
 Why go through a manual process when there are tools that do it in a more automated approach.


Iway makes a ETL called Copy Manager (now known as Webfocus ETL)
http://www.ibi.com/products/data_ware/cm_factsheet.html
 (it supports 80+ databases and file-systems  --- VSAM,  Flat Files, DB2 are some of them)

There are others,   but this is just a thought ...

Sincerely,
dB

No comment has been added lately, so it's time to clean up this TA.
I will leave a recommendation in the Cleanup topic area that this question is:
 - PAQ'd and pts removed
Please leave any comments here within the
next seven days.

PLEASE DO NOT ACCEPT THIS COMMENT AS AN ANSWER !

Nic;o)
ASKER CERTIFIED SOLUTION
Avatar of Netminder
Netminder

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial