Search found 2 matches

by acx_dyates
Thu Mar 03, 2011 10:44 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: LastRowInGroup
Replies: 13
Views: 12883

Re: LastRowInGroup

The 8.5 DSParams should have entries like:

[parallelonly-system-variables]
@PARTITIONNUM
@NUMPARTITIONS
@ITERATION\O\!V

...and would also include the function entries that you mentioned uder the section below.

[parallelonly-functions]
by acx_dyates
Thu Mar 03, 2011 10:06 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: LastRowInGroup
Replies: 13
Views: 12883

Re: LastRowInGroup

I have read several threads pertaining to the LastRowInGroup(), LastRow() and LastTwoInGroup() functions. I want to include one of the above functions in the derivation of a staging var, but none seem to be there. Only see the standard functions(Date & Time, Mathematical, Null Handling, String,...