DSXchange

yes i am using the websphere Transformation extender and the vesion is 8.2.

Thanks a lot.

Hi all, Please advice how to split MT940 message if the message size is more than some 1000 characters and need to take care of opening and closing balaces. Tag:60F: Opening balance Tag:62F: closing balance Tag61: will have the Transaction Amount Caliculation is: Opening Blance + or - Transaction am...

Hi , Can u please advice how to search for a chinies charecter in the files using the CHINIES KEY word. I tried as below 1. IF( (FIND("公对私",TRIMRIGHT(TRIMLEFT(PayDetLine1 Field:Detail_Trans:TxnDetails))+TRIMRIGHT(TRIMLEFT(PayDetLine2 Field:Detail_Trans:TxnDetails))+TRIMRIGHT(TRIMLEFT(PayDe...

Hi All, What all things we need to consider while migrating the DataStage TX from HP UNIX to AIX server. - We have already installed the DataStage TX in AIX mechine - we have aix platform supported compiled maps and msl 's - What all changes we need to do?? We are not able to start the services in A...

Yes ..that's correct I have one file with header and message body If(Field_header="aaa",call(map1),If(Field_header!="aaa",If(condition,call(map2)) and If(condition),call(map3)) From your condition IF(field="Y", RUN("MAP2", PACKAGE(DATA), IF(field="Z"...

Hi all, Please any one help to suggest me on the looping. Here is the requirement. IF(Condition,RUN map1,IF(Condtition, IF(condition,RUN( map2)&IF(condition,RUN(map3))))) If the first If is true,it will call the map1.no need to check for the remaining conditions. If the second If is true,then i ...

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

[quote="ray.wurlod"][color=darkred]Is this a question about WebSphere Transformation Extender (formerly but no longer known as DataStage TX) or about DataStage technique? If the latter, please re-post in the DataStage server forum.[/color][/quote] DataStage Technique only.. Thanks for you ...

[quote="ray.wurlod"][url=http://www-01.ibm.com/software/data/inf ... litystage/]Search[/url] worked for me, were you not able to search for some reason? ...[/quote]

Thank you very much,I got it

[quote="kandyshandy"]Where from you are getting source data? From a table or a file? If it is from a table, add a ORDER BY ACC NO in your SELECT SQL. If it is from a sequential file, tell us your job design... i.e what is your source stage, target stage, processing stages in between etc. B...

[quote="ray.wurlod"]I would.

Or, if I needed probabilistic rather than deterministic matching, I'd use QualityStage. ...[/quote]

I am not aware of this QualityStage, can u help me to explain me in detail

Thank You

[quote="chulett"]Wouldn't you just... sort... them? [/quote]


Even it's not working in my scenario,insted the repeted records getting increased

Hi, I have recrds some thing like below AGD U20081120AGDCPF Consolidated Unprocessed Payment Report AGD Acc_No, CCY, Value_Date, Total, PROD 706155031,EUR,081124,1752.96,FTI 706155031,USD,081124,1752.96,FTI 38365029,SGD,081124,700,FTI 38365029,GBP,081124,381.88,FTI 706155078,EUR,081124,1752.96,FTI 7...