Generating sequence numbers using Stage variables
Moderators: chulett, rschirm, roy
-
- Premium Member
- Posts: 729
- Joined: Tue Apr 28, 2009 10:49 pm
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Too slow. The DSLinkCount macro has to begin an interrogation of the repository for every row processed. The link row count is already available in @OUTROWNUM (or @INROWNUM if an input link).
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.
-
- Premium Member
- Posts: 729
- Joined: Tue Apr 28, 2009 10:49 pm
Why go back and query the repository every record, which is what the macro does, when you've already got the value you need in a system variable local to the transformer?
(if it starts with '@' it is a system variable, check the online help)
(if it starts with '@' it is a system variable, check the online help)
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers