Reading the Multiple XML file names

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
shilpa79
Participant
Posts: 131
Joined: Thu Jan 20, 2005 5:59 pm
Location: Virginia

Reading the Multiple XML file names

Post by shilpa79 »

Hi all,

My file name is : " <Interface name>_<0>_20060501_192056.xml "
My design is I have to pull the files from diff server and get the ftp filesand drop in ds server and process files one by one.

In the file '<0>' and the '<Interaface name>' will be the same except the timestamp.
I am not able to read the files without the *.xml chracter from the shell script.

Can anyone let me know whats the best solution to solve this issue.
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

A job sequence with a "list of things" loop. Execute Command activity to initiate FTP script then Job activity to process the file.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Sreedhar
Participant
Posts: 187
Joined: Mon Oct 30, 2006 12:16 am

Post by Sreedhar »

Not very sure of about the FTP, but if i have understood your requirement right then, you can use a SCP command.

What does SCP do?

SCP - secure copy....


It transmit the file from one server to the other in a most secure form(internally it uses some algorithm to encrypt the file and send it to the destination.)


The syntax for the same is as follows

Witn in a singel command you can transmit all the files in a particuler direct

scp <source server name > <destination server name>
Regards,
Shree
785-816-0728
Post Reply