Search found 91 matches

by jvmerc
Wed May 09, 2007 9:47 am
Forum: IBM<sup>®</sup> DataStage TX
Topic: are companiess willing to go for datastage TX ?
Replies: 3
Views: 3602

"can anybody give idea, whether datastage TX is widely used in market? " Well I can tell you that I started using it 6 years ago when it was still Mercator. At that time it was being used by a host of companies a couple that spring to mind are Boeing & Comcast. I also know of a number ...
by jvmerc
Tue Apr 17, 2007 12:27 pm
Forum: IBM<sup>®</sup> DataStage TX
Topic: TX Jobs
Replies: 3
Views: 3454

Not sure if this will help you... To make your decision you'll really need to determine what you are trying to accomplish. "How different is it from Server jobs etc" Can't really say. I used to go to some of the Ascential dev group meeting in the area. It seemed to me that they were very s...
by jvmerc
Fri Apr 13, 2007 9:01 am
Forum: IBM<sup>®</sup> DataStage TX
Topic: How to Find Matching and Unmatching records from two files?
Replies: 4
Views: 6431

I suppose you'd have to own Change Capture and Change Apply Stage first. Then you could figure out if you can execute their code from the TX map. Many ways to do this.... How about merging the files then use the unique function. You could also merge the files, perform a sort and compare current reco...
by jvmerc
Sat Mar 24, 2007 3:24 pm
Forum: IBM<sup>®</sup> DataStage TX
Topic: Commerce Manager 7.6
Replies: 5
Views: 4086

I guess my question was related to -- were you talking about the trace or log file? As far as I'm aware the trace file gives you the best adapter error messages.

Have you googled the error code?
by jvmerc
Thu Mar 22, 2007 6:45 pm
Forum: IBM<sup>®</sup> DataStage TX
Topic: Commerce Manager 7.6
Replies: 5
Views: 4086

I'm not sure. We aren't using MQ. Is it comming up in the log file as a warning or an error?
by jvmerc
Thu Mar 15, 2007 4:18 pm
Forum: IBM<sup>®</sup> DataStage TX
Topic: Commerce Manager 7.6
Replies: 5
Views: 4086

Look at the adapters PDF should be something there.
by jvmerc
Thu Mar 15, 2007 4:15 pm
Forum: IBM<sup>®</sup> DataStage TX
Topic: what is New line character in map?
Replies: 2
Views: 2929

New line in Windows is CR LF or 0D0A. When run on Unix I believe its LF or 0A. So you could use substitute(text, "|", "<NL>") and it should replace the character according to the environment your compiled in. If you want to make sure its alway Line feed do one of the following......
by jvmerc
Mon Mar 05, 2007 4:44 pm
Forum: IBM<sup>®</sup> DataStage TX
Topic: mapping documentation
Replies: 1
Views: 2269

If I understand your question you could write your output to an XL spreadsheet. You'd use ODBC and the DBInterfaceDesigner.

There may be an example with your original install.
by jvmerc
Mon Jan 29, 2007 8:25 am
Forum: IBM<sup>®</sup> DataStage TX
Topic: 1 file - multiple messages to multiple outputs using header
Replies: 4
Views: 3500

should also be able to import your copybooks which will define your outputs. Historically I've still had to go in and assing terminators etc but if you define your input as descrived by janhess and use you cbks for output you should have this done in no time. If create one output card for each outpu...
by jvmerc
Fri Jan 26, 2007 9:29 pm
Forum: IBM<sup>®</sup> DataStage TX
Topic: 1 file - multiple messages to multiple outputs using header
Replies: 4
Views: 3500

Yes, lots of ways to skin this one? Multiple maps, one map multiple outputs....

When you say maps, do you mean run maps or functional maps?

You need to define your type tree(s) appropriately. Think in the terms of loops and initiators.



Just curious, Is the length field/element important?
by jvmerc
Fri Jan 26, 2007 9:17 pm
Forum: IBM<sup>®</sup> DataStage TX
Topic: Trouble with Webservice examples for Datastage TX 7.5
Replies: 1
Views: 2628

Did you try creating a trace file?
by jvmerc
Thu Jan 11, 2007 9:33 pm
Forum: IBM<sup>®</sup> DataStage TX
Topic: Delta logic of jobs
Replies: 4
Views: 3373

TX? question
by jvmerc
Fri Jan 05, 2007 1:58 pm
Forum: IBM<sup>®</sup> DataStage TX
Topic: Description from Restriction list
Replies: 7
Views: 5477

If you only need to map the qualifier the tree solution is a good one and it will minimize code changes. Just update the exclude and recompile.

If you need to do more, though, you still need a good rule. Depending on your needs perhaps a combination of tree and rule is a good option.
by jvmerc
Fri Jan 05, 2007 12:22 am
Forum: IBM<sup>®</sup> DataStage TX
Topic: Description from Restriction list
Replies: 7
Views: 5477

Found this old example from an old 834 map. It converted the larger variety of HIPAA codes to our smaller group of internal relationship codes.... IF (MEMBER (Indiv'lRelationshipCd Element:INS Segment:Input, { "01", "25", "53"}), "2", IF (MEMBER (Indiv'lRelati...
by jvmerc
Fri Jan 05, 2007 12:14 am
Forum: IBM<sup>®</sup> DataStage TX
Topic: Description from Restriction list
Replies: 7
Views: 5477

As far as I know you can't refer to the description. You can refer to the 'include' value that the description defines. Use the member function...... something like if(member(element:with:include_value, {"XX", "ZZ", "30"}), do process, else do whatever) If you bring up ...