i am passing values to start loop from a comma delimited file.
it runs well till the last value and aborts while processing last value.
any thought on this
passing values to start loop activity
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
job sequence design looks like this
command activity -->start loop-->job1-->end loop
i have a filelist.txt --> file1.txt,file2.txt,file3.txt\n
in command activity ---> cat filelist.txt
start loop activity mapped to command output
job1 input is mapped ---> start loop counter
file1, file2 processes fine but when it comes to third iteration file3 it fails with the following error
<sequence_name>..JobControl (@<job1_stage_name>): Controller problem: Error calling DSSetParam(<input_file_paramter_name_of_job1>), code=-4
[ParamValue/Limitvalue is not appropriate]
sorry for not putting a proper readable code
command activity -->start loop-->job1-->end loop
i have a filelist.txt --> file1.txt,file2.txt,file3.txt\n
in command activity ---> cat filelist.txt
start loop activity mapped to command output
job1 input is mapped ---> start loop counter
file1, file2 processes fine but when it comes to third iteration file3 it fails with the following error
<sequence_name>..JobControl (@<job1_stage_name>): Controller problem: Error calling DSSetParam(<input_file_paramter_name_of_job1>), code=-4
[ParamValue/Limitvalue is not appropriate]
sorry for not putting a proper readable code
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
You've specfied comma as the delimiter, and DataStage is finding \n character. You can not have the \n character here. Or have all \n characters; specify it as the delimiter, and use ls -1 to get the list of file names.
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.