Datastage Server Job (Version
Table(in)----->Transformer---------->Sequential file (Out)
Need to determine the row number in the transformer.
In parallel job we can use @@INROWNUM system variable.I can reset the variable after reading 'n' number of rows and update the data with same set of entries consecutively in a parallel job.
Need to achieve the same logic in server job.Please guide
Rowcount in Transformer
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Stage variable svRowCount. Initialize to 0. Derive as something like
Code: Select all
If Mod(@INROWNUM, #ResetCount#) = 0 Then 0 Else svRowCount + 1
Last edited by ray.wurlod on Wed Jul 04, 2007 3:01 pm, edited 1 time in total.
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.