Need to get file from another Server

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

syeed
Participant
Posts: 19
Joined: Fri Jan 19, 2007 12:35 am
Location: bangalore

Post by syeed »

Please touch base with your system admin.
Syed
---------
Wait and Watch
chanaka
Premium Member
Premium Member
Posts: 96
Joined: Tue Sep 15, 2009 4:06 am
Location: United States

Post by chanaka »

What is the source system OS & the DS server OS. How big is the file? Do you need to do this repeatedly?

Cheers!
Chanaka Wagoda
gssr
Participant
Posts: 243
Joined: Fri Jan 09, 2009 12:51 am
Location: India

Post by gssr »

Hi,
The Source System OS is Windows, and the DS Os is Aix unix,
The file size is huge of 3 GB. Its a one time run only

Let me know if you need anyother details,

Thanks,
RAJ
chanaka
Premium Member
Premium Member
Posts: 96
Joined: Tue Sep 15, 2009 4:06 am
Location: United States

Post by chanaka »

you need to do it using a DS job? or an alternative way?
Chanaka Wagoda
gssr
Participant
Posts: 243
Joined: Fri Jan 09, 2009 12:51 am
Location: India

Post by gssr »

I need to query the txt file and filter the records as per the constraints..
Do you have anyother idea in resolvimng this!!?

Thanks in advance,
RAJ
varaprasad
Premium Member
Premium Member
Posts: 34
Joined: Fri May 16, 2008 6:24 am

Post by varaprasad »

Try to split the file before the FTP. I am not able to recollect, but there is a FTP command which can split and transfer the file. Do a websearch for that command and try.
chanaka
Premium Member
Premium Member
Posts: 96
Joined: Tue Sep 15, 2009 4:06 am
Location: United States

Post by chanaka »

Check with your SA whether you have Large File support enabled.

http://publib.boulder.ibm.com/infocente ... tune35.htm
Chanaka Wagoda
chanaka
Premium Member
Premium Member
Posts: 96
Joined: Tue Sep 15, 2009 4:06 am
Location: United States

Post by chanaka »

If not use a simple java code given in the below page to split it. and use the sequential file stage in wild card mode to perform your task.

http://www.go4expert.com/forums/showthread.php?t=236
Chanaka Wagoda
Post Reply