DSXchange

hi,

Is there any stage is there in datastage by which we can retrive record/file/table from other server.
Please advice .
Thanks

Maybe you need to include more details of what you want.

For file, you can use ftp.

Relational databases generally allow their own networking mechanism to be 'visible' across servers, generally using 'TCP/IP'.

suppose i need file from another network, so in datstage job where i will define ftp name ,location so that it connect to that particular network.
Please advice

What have you tried so far ?

Sainath.Srinivasan wrote:What have you tried so far ? ...

Hi,

i have to create one job,which will store file from take file from one server and store it in other server .
Please advice me how i can do this.

Is the other server visible? That is, is the directory where the file to be transferred mounted (or mountable) on the DataStage server? If so, you can access it directly. If not use FTP - either a script to transfer the file or an FTP stage to transfer its data.

Two alternatives.

Use FTP stage for getting the file from the remote machine onto the drive which is visible to your DataStage.

Ask somebody to periodically send the required file to a place that is accessible to DataStage.

Many regards,