Trying to ftp more than one file using FTP Stage

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
userds
Participant
Posts: 19
Joined: Mon Feb 14, 2005 1:39 pm

Trying to ftp more than one file using FTP Stage

Post by userds »

I am trying to FTP more than one file using FTP Stage.

It gives the following error:
-------------------------------
FTPJOb..FTP_Plug_in_2: 550 anma022r*.txt: The filename, directory name, or volume label syntax is incorrect.
FTPJOb..FTP_Plug_in_2: Error while trying to open connection for receiving data from the FTP server, FTP command RETR failed

I have specified the filename as anma022r*.txt, which i believe a valid representation.

I would like to know why FTP Stage is erroring out.

Any help will be appreciated.

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

Post by chulett »

The FTP stage doesn't support wildcards or sending more than one file at a time. Go back to good 'ol command line ftp if you really need to do that.
-craig

"You can never have too many knives" -- Logan Nine Fingers
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

Or run a pre-FTP command such as

Code: Select all

cat anma022r*.txt > anma002r.all 
and use that file as the one to stream into your job.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

Assuming it's ok for the output to be one big file on the other end. :wink:
-craig

"You can never have too many knives" -- Logan Nine Fingers
roy
Participant
Posts: 2598
Joined: Wed Jul 30, 2003 2:05 am
Location: Israel

Post by roy »

Hi,
well as I remember command line ftp is also faster.
so I would go with command line ftp with mget <file pattern>.

if you don't want any ftp scripts hanging around you can allways build them on the fly and delete them when your done.

IHTH,
Roy R.
Time is money but when you don't have money time is all you can afford.

Search before posting:)

Join the DataStagers team effort at:
http://www.worldcommunitygrid.org
Image
sachinkc
Participant
Posts: 34
Joined: Sat Apr 17, 2004 11:39 am
Location: USA

Re: Trying to ftp more than one file using FTP Stage

Post by sachinkc »

DS should be used to make things easy and streamlined that you cannot otherwise. If using DS will make it more complex, try not to use it, unless your boss insists.

I would go for OS level ftp, as its reliable, efficient and easy to use and change. I've not used FTPStage myself though, so I'm sorry I'll not be able to answer your direct question.

Just my humble 2 cents
- Sachin
userds wrote:I am trying to FTP more than one file using FTP Stage.

It gives the following error:
-------------------------------
FTPJOb..FTP_Plug_in_2: 550 anma022r*.txt: The filename, directory name, or volume label syntax is incorrect.
FTPJOb..FTP_Plug_in_2: Error while trying to open connection for receiving data from the FTP server, FTP command RETR failed

I have specified the filename as anma022r*.txt, which i believe a valid representation.

I would like to know why FTP Stage is erroring out.

Any help will be appreciated.

TIA.
Rgrds & Cheers!

Sachin
sachin@operamail.com
~Life always finds a way~
Post Reply