Search found 36 matches

by jazzer1
Fri May 05, 2006 8:11 am
Forum: IBM<sup>®</sup> DataStage TX
Topic: How do you string a series of xml records together ?
Replies: 25
Views: 16629

WOW ! That certainly changed the output. That's much closer to my end result. It's amazing what a little help can do.
Thanks tons for your help.
by jazzer1
Fri May 05, 2006 7:46 am
Forum: IBM<sup>®</sup> DataStage TX
Topic: How do you string a series of xml records together ?
Replies: 25
Views: 16629

If I did this the way you said, it didn't have any impact. My input is a group with many records and no delimiters. My output rule is =F_String(PACKAGE(DummyRec:Input01)). The output still comes out like this: <rec>111</rec> <rec>222</rec> <rec>333</rec> <rec>444</rec> <rec>555</rec> Even though my ...
by jazzer1
Thu May 04, 2006 2:21 pm
Forum: IBM<sup>®</sup> DataStage TX
Topic: How do you string a series of xml records together ?
Replies: 25
Views: 16629

How do you string a series of xml records together ?

I have a group of xml records.... <rec>111</rec> <rec>222</rec> <rec>333</rec> <rec>444</rec> <rec>555</rec> I can extract them, but I want to string them together like this.... <rec>111</rec><rec>222</rec><rec>333</rec><rec>444</rec>>rec>555</rec> Any help is appreciated. Thanks.
by jazzer1
Wed May 03, 2006 9:05 am
Forum: IBM<sup>®</sup> DataStage TX
Topic: Handling XML data
Replies: 1
Views: 3058

anytype works for me but I'm using Version 8.0
by jazzer1
Fri Apr 28, 2006 8:27 am
Forum: IBM<sup>®</sup> DataStage TX
Topic: Still looking for TX Training Version 8.0
Replies: 2
Views: 3626

Still looking for TX Training Version 8.0

I'm still trying to find a good TX fundamentals class. The class should include xml and flatfile processing. Any help and/or recommendations
would be greatly appreciated.
by jazzer1
Wed Apr 12, 2006 10:03 am
Forum: IBM<sup>®</sup> DataStage TX
Topic: NACHA Pre-Defined ACH Type Trees in DataStage ?
Replies: 2
Views: 2612

NACHA Pre-Defined ACH Type Trees in DataStage ?

Are they any pre-defined NACHA ACH type trees available thru the DataStage Product Suite ?
Thank You.
by jazzer1
Tue Apr 11, 2006 9:15 am
Forum: IBM<sup>®</sup> DataStage TX
Topic: Unix Shell Script to execute a TX Map
Replies: 1
Views: 2371

Unix Shell Script to execute a TX Map

Would anyone have a sample Unix shell script that executes a TX map ?
The map reads and writes a flat file.
Thank you.
by jazzer1
Tue Apr 11, 2006 7:25 am
Forum: IBM<sup>®</sup> DataStage TX
Topic: OR logic: How do you code for multiple conditions ?
Replies: 2
Views: 2481

This is great. Thanks very much.
by jazzer1
Fri Apr 07, 2006 2:41 pm
Forum: IBM<sup>®</sup> DataStage TX
Topic: OR logic: How do you code for multiple conditions ?
Replies: 2
Views: 2481

OR logic: How do you code for multiple conditions ?

How would you code something like this in TX ?

IF CODE = 1, WRITE A REC
OR IF CODE = 2 WRITE B REC
OR IF CODE = 3 WRITE C REC
OR IF.... ETC
by jazzer1
Fri Apr 07, 2006 7:43 am
Forum: IBM<sup>®</sup> DataStage TX
Topic: Simplest way to identify a bad record ?
Replies: 4
Views: 3452

I have a file that could have (0:s) records, and each record can occur (0:s). For example: 1mmmmmmmmmmmmmmm<CR><LF> 2nnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnn<CR><LF> 2nnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnn<CR><LF> 2nnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnn<CR><LF> Xnnnnnnnnnnnnn<CR><LF> 3xxxxxxxxx2nnnnnnnnnnnnnnnnnnnnn...
by jazzer1
Wed Apr 05, 2006 2:42 pm
Forum: IBM<sup>®</sup> DataStage TX
Topic: Optional field not present but TX doesn't go to nect field
Replies: 6
Views: 4557

YES ! Thank you janhess for your suggestion of specifying spaces in the
type syntax empty parameter. That works.
by jazzer1
Wed Apr 05, 2006 10:46 am
Forum: IBM<sup>®</sup> DataStage TX
Topic: Simplest way to identify a bad record ?
Replies: 4
Views: 3452

Simplest way to identify a bad record ?

I'm reading a 10,000 record file. The validation stops in the middle of the run. What's the simplest method to identify which record is failing the validation ? The trace has all this offset info but is there any way it could give you a record count instead of an object count ? E.G. Record 9299 fail...
by jazzer1
Tue Apr 04, 2006 8:25 am
Forum: IBM<sup>®</sup> DataStage TX
Topic: Read thru Multiple and different records in one file ?
Replies: 5
Views: 3717

Janhess's solution worked ! Thanks very much Janhess.
by jazzer1
Mon Apr 03, 2006 8:50 am
Forum: IBM<sup>®</sup> DataStage TX
Topic: Read thru Multiple and different records in one file ?
Replies: 5
Views: 3717

Let me clarify... the <CR><LF> is defined as a terminator for each group...the '1' rec is an implicit group with terminator <CR><LF>.
The '2' rec is an implicit group with terminator <CR><LF> etc.
by jazzer1
Mon Apr 03, 2006 8:32 am
Forum: IBM<sup>®</sup> DataStage TX
Topic: Read thru Multiple and different records in one file ?
Replies: 5
Views: 3717

The <CR><LF> is at the end of each record. Just the way you see it in the example.
Thanks. Standing by....