Rowcount in Transformer

[bhags]

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

[ray.wurlod]

Stage variable svRowCount. Initialize to 0. Derive as something like

Code: Select all

If Mod(@INROWNUM, #ResetCount#) = 0 Then 0 Else svRowCount + 1

[jguerrero]

...just a simple correction

If Mod(@INROWNUM, #ResetCount#) = 0 Then 0 Else Mod(@INROWNUM, #ResetCount#)

[jguerrero]

...just a simple correction

If Mod(@INROWNUM, #ResetCount#) = 0 Then 0 Else Mod(@INROWNUM, #ResetCount#)