Page 2 of 2

Posted: Thu Nov 26, 2009 12:52 am
by syeed
Please touch base with your system admin.

Posted: Thu Nov 26, 2009 4:29 am
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!

Posted: Thu Nov 26, 2009 5:34 am
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,

Posted: Thu Nov 26, 2009 5:37 am
by chanaka
you need to do it using a DS job? or an alternative way?

Posted: Thu Nov 26, 2009 5:39 am
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,

Posted: Thu Nov 26, 2009 5:48 am
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.

Posted: Thu Nov 26, 2009 6:03 am
by chanaka
Check with your SA whether you have Large File support enabled.

http://publib.boulder.ibm.com/infocente ... tune35.htm

Posted: Thu Nov 26, 2009 6:07 am
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