I'm having troubles with my Filter Stage. Here is the situation
Sequence:
StartLoop -----> Job ---->
^ |
| |
| V
--------------------EndLoop
Job:
Sequential File ---> Filter --->
The file contains more records than the target can handle at a time. That's why I need to split up the sequential file in different pieces.
In an early job of the sequence I make up the number of records of the sequential file and divide it by the number what the target can handle at a time (10 in this example).
I loop the job the number of times it needs and within the filter I do this:
(ROWID > ((#loopcounter#*10)-10)) and (ROWID < ((#loopcounter#*10)+1))
The #loopcounter# is StartLoop.$counter.
The error messages I get are:
- Filter: Error occurred during initializeFromArgs().
- Filter: Parse error: Expected field or literal after comparison operator,got: "("
Parse error: Expected boolean operator (and, or) got: "("
Parse error: Expected 'is' statement ('is true', 'is false') or boolean operator (and, or) got: "-10".
Would anyone mind helping me? Thanks in advance!
![Smile :)](./images/smilies/icon_smile.gif)
Peter Veenis