I have to handle multiple files to be loaded into an oracle.Has there is job dependencies , I designed a sequencer to handle multiple files. But for some reason the designed sequencer is not working for multiple files.
Files Type: YUR30120070607.001, YUR30120070619.003 etc.
Sequencer design::
1) Execute Command stage:
Command: cd
parameter: /path/ && ls -1m YUR301*
Trigger: len(EX1.$CommandOutput) > 1
2) Start loop:
Delimiter value: #EX1.$CommandOutput#
Delimiter: Comma.
Trigger: Unconditional.
3) DS job to execute : JOB1
4) Stop loop:
Trigger: Unconditional.
Sequencer error:
The sequencer is able to handle only one file and when the job runs for second file I am getting the above error.Error calling DSSetParam(FILE), code=-4
[ParamValue/Limitvalue is not appropriate]
Job error:
I am not understanding where exactly I am doing wrong.Failed to open YUR30120070619.003 in directory
STATUS = -1.|
Thanks in advance....