Forums Register Login

importing data from a VSAM file

+Pie Number of slices to send: Send
So we have some Data in a Mainframe, that is in VSAM files. And we need to be able to import the data into a DB2 Database using Java. Any ideas ?

One that I was thinking about was converting the VSAM data to a flat file CSV and then going from there. Anyone know how to convert VSAM files to CSV ? Any other approaches?
+Pie Number of slices to send: Send
You can use a COBOL program or file utility (maybe FileAide?) to export from VSAM to fixed length fields in flat text, and then read that in Java. Substring out the fields using from and length information.

CSV is a bit trickier write and read because you have to escape commas and quotes and such.

Do fixed-length records sound like something you could try?
A feeble attempt to tell you about our stuff that makes us money
a bit of art, as a gift, the permaculture playing cards
https://gardener-gift.com


reply
reply
This thread has been viewed 3305 times.
Similar Threads
Correct Generated File Extensions from Action
text styling in csv
Java Batch program - CSV/XML input file
CSV File Reader
Approach to validate objects in list
More...

All times above are in ranch (not your local) time.
The current ranch time is
Mar 28, 2024 09:37:43.