Hi
Can we read a OS390 VSAM file via DataStage PX version in an UNIX env?
Do we need to install the Mainframe version of DataStage tool to do this work?
VSAM file to UNIX base
Moderators: chulett, rschirm, roy
VSAM file to UNIX base
Looking forward to get some ans...
Thanks,
TryMe
Thanks,
TryMe
-
- Participant
- Posts: 3337
- Joined: Mon Jan 17, 2005 4:49 am
- Location: United Kingdom
Where are the files residing ? How is it extracted from Mainframe ? Is there any link between the Mainframe and your DataStage server ? Are you using any VSAM ODBC driver to connect to mainframe ?
Without knowing these, it is difficult to answer.
If the file resides in Mainframe and is standalone, you need DS/390 to extract data using the COBOL code produced.
If the file resides in Unix or you have ODBC drivers, you can use the default DataStage PX (aka InfoSphere).
Without knowing these, it is difficult to answer.
If the file resides in Mainframe and is standalone, you need DS/390 to extract data using the COBOL code produced.
If the file resides in Unix or you have ODBC drivers, you can use the default DataStage PX (aka InfoSphere).
Partial answer
I explored this from a different angle recently, and found that CFF must have DS/mainframe installed for direct access between the Unix processes and the mainframe datasets (of any format, including VSAM).
I am using FTP Enterprise to get sequential dataset data. I would very much like to see how that could work with VSAM.
I am using FTP Enterprise to get sequential dataset data. I would very much like to see how that could work with VSAM.