When I run the parallel job , the job aborts with a fatal error
main_program: Syntax error: Error in "leftouterjoin" operator: Error in output redirection: Error in output parameters: Error in modify adapter: Error in binding: Could not find type: "subrec", line 5391
Could not locate where exactly the issue is.
Anyone who know about this or faced this issue can help.
Fatal error: syntax error in "leftouterjoin" opera
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Can you please capture and post the score from this job?
Errors from "main program" are usually from inserted operators or operators (usually the modify operator) that have been optimized onto links.
Errors from "main program" are usually from inserted operators or operators (usually the modify operator) that have been optimized onto links.
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.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
That makes sense if you understand what has to happen when there's a level number higher than 01. There's an intrinsic left outer join with the lowest level columns and the higher level columns.
The moral of the story seems to be not to include level numbers where they're not required.
The moral of the story seems to be not to include level numbers where they're not required.
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.