Search found 268 matches

by nkln@you
Mon Mar 17, 2008 5:55 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Delete file after FTP
Replies: 48
Views: 9868

Your wonderful invisible friend again? Port 23 (the telnet port) is one of the ones that is typically disabled when a site is "secured" and, yes, this means that port 22 (SSH - the "secure" equivalent of telnet) is the appropriate protocol to use. But, as Craig asks, why are you...
by nkln@you
Mon Mar 17, 2008 3:58 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Delete file after FTP
Replies: 48
Views: 9868

Are you not ftp'ing these files somewhere else meaning some other server? If so, why try to telnet to the DataStage server? :? You need the telnet prompts and credentials from the remote server. I just heard from my friend that its not possible to telnet a secure server. You can only do secure ftp ...
by nkln@you
Mon Mar 10, 2008 2:26 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Delete file after FTP
Replies: 48
Views: 9868

Okay, I'm done arguing. :cry: You win. I thought you needed to send multiple files. I'm obviously confused. :( Well You are not wrong. But my multiple files are in different folders and the picking time of all files are different. So i cant do everything in one shell script. This was the reason I w...
by nkln@you
Mon Mar 10, 2008 1:40 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Delete file after FTP
Replies: 48
Views: 9868

You're asking about doing things that the FTP stage can't possibly do. Your only solution to getting all of the But FTP stage does all the operations I want it to do. It can take the backup of the file before doing the FTP. then it has rollback transaction command where i can restore the backup fil...
by nkln@you
Mon Mar 10, 2008 12:24 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Delete file after FTP
Replies: 48
Views: 9868

ArndW wrote:You can use scp in a server job. But as there is no stage to do this, you will need to shell out.
So it comes back to FTP stage where I can do all the operations without writing shell script.
by nkln@you
Mon Mar 10, 2008 12:04 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Delete file after FTP
Replies: 48
Views: 9868

Please research on your own about scp and ssh. I've already posted enough about them to describe their benefits. Please let me know if its possible to use Scp in a server job or not. and if using Scp is possible in a server job, then without going for shell script, is it possible to do the same ope...
by nkln@you
Mon Mar 10, 2008 11:55 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Delete file after FTP
Replies: 48
Views: 9868

A before/after subroutine is just going to execute ftp, so I'm just saying you should use scp and ssh instead. That's a fairly great recommendation. As for the FTP stage you take on a whole lot of other issues as it reads the file and requires highly structured and conforming data with the metadata...
by nkln@you
Mon Mar 10, 2008 10:47 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Delete file after FTP
Replies: 48
Views: 9868

Did you checkout using scp and ssh? Why use the FTP stage to do something so simple? I didnt understand the checkout using SCP And SSH. The only thing is I dont want to create a shell script when the same functionality is achievable in DS. So was wondering if its possible to do using FTP stage or j...
by nkln@you
Fri Feb 29, 2008 5:07 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Delete file after FTP
Replies: 48
Views: 9868

Hi All, I can do that in shell script but i am passing multiple files to a ftp location. And that would mean creating multiple shell script which I want to avoid. Thats the reason I am thinking of using FTP stage to do this work. Is there any approach to do the same like doing everything in the Afte...
by nkln@you
Thu Feb 28, 2008 8:54 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Delete file after FTP
Replies: 48
Views: 9868

And how to find whats the prompt the telnet session is expecting? You manually issue the telnet command from the command line and note the prompts that you get, then make the stage match. When I issued the telnet command, no prompt came at all. Instead a new blank screen opened up. Can you Please g...
by nkln@you
Thu Feb 28, 2008 4:51 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Delete file after FTP
Replies: 48
Views: 9868

ray.wurlod wrote:I just read that gays cause earthquakes. Is it true? (It was in the Hobart Mercury (newspaper - one of Rupert Murdoch's) so it must be true.)
:) got the point... So coming back to the problem.. which server telnet port number i need to provide and how to find the telnet login prompt?
by nkln@you
Thu Feb 28, 2008 2:29 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Delete file after FTP
Replies: 48
Views: 9868

I just read that Telnet is insecure and ssh should be used to transfer the files. is this correct? If yes then how can I do this using DS? Shell Script?
by nkln@you
Thu Feb 28, 2008 2:04 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Delete file after FTP
Replies: 48
Views: 9868

Is the prompt perhaps "login: " rather than "login"? I tried "login:" but it didnt work either. But I have a basic doubt. Please clear the same. Datastage is installed in Server A and the path where I am trying to do Ftp is server B. So in the telnet user/password, I h...
by nkln@you
Thu Feb 28, 2008 1:27 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Delete file after FTP
Replies: 48
Views: 9868

First suggestion would be to start your own post. If you really feel the need to include this one in the conversation, link to it. Second suggestion would be to correct your 'Telnet prompt' value. The default in the stage isn't always appropriate, you'll need to correct it to match what your telnet...
by nkln@you
Wed Feb 27, 2008 9:10 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Delete file after FTP
Replies: 48
Views: 9868

Hi All, Even I am trying the same approach. I am ftping a file from one server to another server and when the ftp completes, want to delete the old file present. So I am using ftp stage and the ftp is happening perfectly but the removal of file is not happening. Its giving the error Bytes returned f...