Cross platform communication with DataStage

satish_valavala · Post by **satish_valavala** » Thu Jun 08, 2006 12:59 pm

Hi All,
How can I access a flat file which is in mainframe environment. DataStage Server is on Windows.

DSguru2B · Post by **DSguru2B** » Thu Jun 08, 2006 1:07 pm

By simply ftp'ing the file onto your datastage server and then connecting to it

satish_valavala · Post by **satish_valavala** » Thu Jun 08, 2006 1:09 pm

Is it the one and only solution?

kcbland · Post by **kcbland** » Thu Jun 08, 2006 1:18 pm

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.

DSguru2B · Post by **DSguru2B** » Thu Jun 08, 2006 1:18 pm

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.

satish_valavala · Post by **satish_valavala** » Thu Jun 08, 2006 1:36 pm

Thanks to All