DSXchange: DataStage and IBM Websphere Data Integration Forum
View next topic
View previous topic
Add To Favorites
Author Message
slevin4356
Participant



Joined: 15 May 2010
Posts: 1

Points: 18

Post Posted: Sat May 15, 2010 10:17 am Reply with quote    Back to top    

DataStage® Release: 8x
Job Type: TX
OS: Windows
Additional info: should modify the script to get only specified files from FT
can any one help me modify the script or any other suggestion:

i have a script that moves all the files(4 files) from the FTP server to the local server and translates the flat file to csv file i need to modify the script such that it gets 3 files into one system and the other files needs to be processed and send to JDE system this is the present script i have

SETLOCAL
SET PGM=WTX
SET SYSNAME=G1234W
SET TRANSET=PS
SET Fltr="TLUS*.*"
.
.
IF [%PGM%]==[WTX] (
SET LPath="%LDrv%\WTXDTA\\DAT\ZIP\"
SET APath="%LDrv%\WTXDTA_ARC\DAT\ZIP\"
SET TPath=!LPath:"=!

.
.
.
.
.
>"%ScriptFull1:"=%" (ECHO open %FtpSite%)
>>"%ScriptFull1:"=%" (ECHO %FtpUser%)
>>"%ScriptFull1:"=%" (ECHO %FtpPass%)
>>"%ScriptFull1:"=%" (ECHO type binary)
>>"%ScriptFull1:"=%" (ECHO lcd "%TPath:~0,-1%")
>>"%ScriptFull1:"=%" (ECHO cd "%RPath:"=%")
>>"%ScriptFull1:"=%" (ECHO dir %Fltr:"=% "%DrFull:"=%")
>>"%ScriptFull1:"=%" (ECHO ls %Fltr:"=% "%LsFull:"=%")
>>"%ScriptFull1:"=%" (ECHO mget %Fltr:"=%)
>>"%ScriptFull1:"=%" (ECHO quit)

now i want the files that start with TLUS2*.*,TLUS3*.* and TLUS4*.* and leave TLUS5*.*

AND IS THERE ANY OTHER ALTERNATIVE OTHER THEN USING THE SCRIPT TO GET THE FILES TO WTX?
Display posts from previous:       

Add To Favorites
View next topic
View previous topic
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum



Powered by phpBB © 2001, 2002 phpBB Group
Theme & Graphics by Daz :: Portal by Smartor
All times are GMT - 6 Hours