Dear All
I am trying to set row limit for a job. I am writing code in
Job(Job_UsingColumnGenerator) --> Job properties --> JobControl Tab.
Code:
-------
Job_handle=DSAttachJob("Job_UsingColumnGenerator",DSJ.ERRWARN)
LimitErr = DSSetJobLimit(Job_handle,DSJ.LIMITROWS,5)
Deterr = DSDetachJob(Job_handle)
My job keeps running and does not show any further errors or getting completed,I have to clean up job resource for killing it. Is it correct to do so.
DSSetJobLimit in Job control tab.
Moderators: chulett, rschirm, roy
DSSetJobLimit in Job control tab.
Thanks, BK
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
You are thinking like a server job developer.
For parallel jobs there is no way to set a row limit with the job compiled normally. If you compile the job in trace mode, only then can you set a row limit. And it's a row limit per node.
For parallel jobs there is no way to set a row limit with the job compiled normally. If you compile the job in trace mode, only then can you set a row limit. And it's a row limit per node.
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:
As stated, there is no way to set a row limit for a parallel job (unless it is compiled in trace mode, which carries its own penalties and is only intended for diagnostic purposes) without designing one in. For example you could compare the row number in a Transformer stage with a job parameter's value.
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.