How to capture remote server response during FTP

Post questions here relative to DataStage Server Edition for such areas as Server job design, DS Basic, Routines, Job Sequences, etc.

Moderators: chulett, rschirm, roy

Post Reply
sprasad55
Participant
Posts: 11
Joined: Thu Dec 28, 2006 4:16 pm

How to capture remote server response during FTP

Post by sprasad55 »

I am FTPing files by invoking batch script through Data Stage, I am able to capture all the commands that i have placed in the batch script but not able to get the remote server response like "226 Transfer complete" . Any idea how to capture it through data stage.

cmd = "ftp -i -d -s:U:\DataStageProd\ndw\jobcontrol\batchscripts\VIP_Ftp.parm >> U:\DataStageProd\ndw\work\staging\VIP_Log\VIPLOG"

CALL DSExecute("NT", cmd, ScreenOutput, SystemReturnCode)

Thanks
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

Have you looked to see what's in your ScreenOutput variable?
-craig

"You can never have too many knives" -- Logan Nine Fingers
sprasad55
Participant
Posts: 11
Joined: Thu Dec 28, 2006 4:16 pm

Post by sprasad55 »

Yes and nothing is there in ScreenOutput Variable -

cmd = "ftp -i -d -s:U:\DataStageProd\ndw\jobcontrol\batchscripts\VIP_Ftp.parm >> U:\DataStageProd\ndw\work\staging\VIP_Log\VIPLOG"

*----------------------------------------------------------
CALL DSExecute("NT", cmd, ScreenOutput, SystemReturnCode)
*----------------------------------------------------------
CALL DSLogInfo("SQL CMD = ":cmd,"Command")

CALL DSLogInfo("Screenoutput = ":ScreenOutput,"INFO")

CALL DSLogInfo(SystemReturnCode,"INFO")

O/P
VIPWrapper.60.JobControl (INFO): Screenoutput =
Post Reply