Hi,
I have a below requirement in one of my integration.
> Input is a file with File name and Folder name. It has multiple records.
> I have to read each record in this file and connect to a source system, get the file based on the folder and file name and place it to the target.
> the file is in Binary and doesn't require any content modification/validation.
Please let me know if there is any option in DataStage to achieve this.
Thanks,
Yugee
Help with FTP Multiple Files in DataStage
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 251
- Joined: Mon Jun 09, 2008 5:52 am
I don't mean to be sarcastic, but a sequence job with a loop is actually the best solution for this, and sequence jobs not allowed is much like being asked to run but being ordered to shoot yourself in one foot first.
One way I've seen: read each file name and path in sequential mode, and write it to a generic FTP script, then use some method to run each script. The script for each FTP is your output file, not an execution call.
One way I've seen: read each file name and path in sequential mode, and write it to a generic FTP script, then use some method to run each script. The script for each FTP is your output file, not an execution call.
Franklin Evans
"Shared pain is lessened, shared joy increased. Thus do we refute entropy." -- Spider Robinson
Using mainframe data FAQ: viewtopic.php?t=143596 Using CFF FAQ: viewtopic.php?t=157872
"Shared pain is lessened, shared joy increased. Thus do we refute entropy." -- Spider Robinson
Using mainframe data FAQ: viewtopic.php?t=143596 Using CFF FAQ: viewtopic.php?t=157872