Delete file after FTP
Moderators: chulett, rschirm, roy
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 session is actually seeing.
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 session is actually seeing.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
Sorry for continuing in the same link but i dont know how to link it.chulett wrote: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 session is actually seeing.
Regarding the telnet prompt, below are the settings in my job.
Number of Telnet Promps: 2
Telnet Prompt 1: login
Telnet Reply 1: dsadm
Telnet Prompt 2: password
Telnet Reply 2: dsadm
here dsadm is the user name we are using to login in DS and dsadm is the password as well. Please let me know if I need to change any settings.
And how to find whats the prompt the telnet session is expecting?
Aim high
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
I tried "login:" but it didnt work either. But I have a basic doubt. Please clear the same.ray.wurlod wrote:Is the prompt perhaps "login: " rather than "login"?
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 have given the user/password which I use to login to connect to DS. Also in the parameter "Remote telnet Port" , I have given the telnet port number of DS Server(A). Is this correct?
Also the FTP connection mode is set to Passive. Should i set it to Active?
Aim high
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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.)
Come on, attribute your sources. None of this "I heard" or "my invisible friend told me" please!
Come on, attribute your sources. None of this "I heard" or "my invisible friend told me" please!
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
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?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.)
Aim high
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Come on... a link is a URL to the post in question. You get that from the Forum view or the address bar in your brower and then you paste it into your post. It's not rocket science.nkln@you wrote:Sorry for continuing in the same link but i dont know how to link it.
You manually issue the telnet command from the command line and note the prompts that you get, then make the stage match.nkln@you then wrote:Regarding the telnet prompt, below are the settings in my job.
Number of Telnet Promps: 2
Telnet Prompt 1: login
Telnet Reply 1: dsadm
Telnet Prompt 2: password
Telnet Reply 2: dsadm
here dsadm is the user name we are using to login in DS and dsadm is the password as well. Please let me know if I need to change any settings.
And how to find whats the prompt the telnet session is expecting?
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
When I issued the telnet command, no prompt came at all. Instead a new blank screen opened up. Can you Please guide on this.chulett wrote: 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.
Aim high
Re: Delete file after FTP
Hi,srimitta wrote:Hi,
I have a job which pulls data from unix box using DataSatge ftp stage, and on sucessful run I need to delete source file.
Source file is on different Unix box and my DataStage server is on different Unix box.
Any thoughts........
Thanks
Mitta
we can do in many ways, it is very simple if you wirte a shall script . IN that shall script , first grep the status , then if you want move or can delete file. Call that script in Datastage job(after subroutine).
ftp is so 90's. You need to use scp. You setup an RSA secured key one time between two machines. Then, ssh and scp work without any password prompts. You use scp just like cp, except you denote the file location/destination with a server hostname in the filename. It even uses wildcards! Checkitout....
Kenneth Bland
Rank: Sempai
Belt: First degree black
Fight name: Captain Hook
Signature knockout: right upper cut followed by left hook
Signature submission: Crucifix combined with leg triangle
Rank: Sempai
Belt: First degree black
Fight name: Captain Hook
Signature knockout: right upper cut followed by left hook
Signature submission: Crucifix combined with leg triangle