Hi All,
How can I access a flat file which is in mainframe environment. DataStage Server is on Windows.
Cross platform communication with DataStage
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 123
- Joined: Wed May 18, 2005 7:41 am
- Location: USA
Cross platform communication with DataStage
Regards
VS
VS
-
- Participant
- Posts: 123
- Joined: Wed May 18, 2005 7:41 am
- Location: USA
Knowing nothing about your mainframe environment, there are some options:
1. Have the mainframe FTP push the file to a server.
2. Have a process FTP pull the file to a server.
3. If you have DB2 mainframe setup, put the file into a mainframe table and use DB2 connect with a DB2/UDB server act as the gateway to the mainframe, then use ODBC or OCI to "talk" to the file using SQL.
1. Have the mainframe FTP push the file to a server.
2. Have a process FTP pull the file to a server.
3. If you have DB2 mainframe setup, put the file into a mainframe table and use DB2 connect with a DB2/UDB server act as the gateway to the mainframe, then use ODBC or OCI to "talk" to the file using SQL.
Kenneth Bland
Rank: Sempai
Belt: First degree black
Fight name: Captain Hook
Signature knockout: right upper cut followed by left hook
Signature submission: Crucifix combined with leg triangle
Rank: Sempai
Belt: First degree black
Fight name: Captain Hook
Signature knockout: right upper cut followed by left hook
Signature submission: Crucifix combined with leg triangle
Well you tell me. Mainframe is remote and absolutely transparent to the datastage server. Either you have to find a way to make mainframe server visible to datastage or get the file you need from mainframe by using one of the many file transfer methods.
I think thats the only way (as per my knowledge). No let me rephrase that, thats the way I have dealt with files present on remote servers. Never bothered any other way.
I think thats the only way (as per my knowledge). No let me rephrase that, thats the way I have dealt with files present on remote servers. Never bothered any other way.
Creativity is allowing yourself to make mistakes. Art is knowing which ones to keep.
-
- Participant
- Posts: 123
- Joined: Wed May 18, 2005 7:41 am
- Location: USA