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
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
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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