Page 1 of 1
Posted: Mon Jan 19, 2009 3:18 pm
by ray.wurlod
Split your data into two streams based on batch ID (Transformer stage).
The txnID value on each output link is given by the system variable @OUTROWNUM.
Done.
Posted: Tue Jan 20, 2009 8:14 pm
by ushasribandaru
[quote="ray.wurlod"]Split your data into two streams based on batch ID (Transformer stage).
The txnID value on each output link is given by the system variable @OUTROWNUM.
Done. ...[/quote]
I am using the Websphere datastageTX(Transfermation extender),I dont have the option to use the OUTROWNUM function here.
I am trying in this way,
F_Cnt(NUMBERTOTEXT(COUNT(EXTRACT(DebitAccNo Field:Transaction:Payment:PbtIn,DebitAccNo Field:Transaction:Payment:PbtIn="6548798277"))),INDEX($))
The number here i have asssigned is one of the account number(6548798277),
Insted of passing the account number i to want pass one variable(s),which contails all unique
account numbers but the loop is not working as i expected(as per my requirement).
I would appricieate if have any suggestions.
Posted: Tue Jan 20, 2009 8:24 pm
by ray.wurlod
In that case you should have posted in the TX forum.
Posted: Wed Jan 21, 2009 8:53 am
by chulett
And not marked your "job type" as Server.
Posted: Wed Jan 21, 2009 11:48 am
by ray.wurlod
chulett wrote:And not marked your "job type" as Server.
Alas there's no choice on that; TX is not one of the options.
Posted: Wed Jan 21, 2009 11:55 am
by chulett
Sure there is.