get the batchid and transaction id for each transaction

ray.wurlod · Post by **ray.wurlod** » Mon Jan 19, 2009 3:18 pm

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.

ushasribandaru · Post by **ushasribandaru** » Tue Jan 20, 2009 8:14 pm

[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.

ray.wurlod · Post by **ray.wurlod** » Tue Jan 20, 2009 8:24 pm

In that case you should have posted in the TX forum.

chulett · Post by **chulett** » Wed Jan 21, 2009 8:53 am

And not marked your "job type" as Server.

ray.wurlod · Post by **ray.wurlod** » Wed Jan 21, 2009 11:48 am

chulett wrote:And not marked your "job type" as Server.

Alas there's no choice on that; TX is not one of the options.

chulett · Post by **chulett** » Wed Jan 21, 2009 11:55 am

Sure there is.