Batch script issue

Formally known as "Mercator Inside Integrator 6.7", DataStage TX enables high-volume, complex transactions without the need for additional coding.

Moderators: chulett, rschirm

Post Reply
slevin4356
Participant
Posts: 1
Joined: Sat May 15, 2010 10:08 am

Batch script issue

Post by slevin4356 »

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?
Post Reply