DSXchange

Oooo, oooo - I don't do DB2 but I can answer one of the questions!

2. Nope!

And 'SEGV' is short for a 'segmentation violation', something else to search for here (or Google).

What 'output'? Where are you writing this, to a sequential file? I'm wondering if a) they are even really there and b) if something you are doing simply puts them back in the output, hence the question about your actual target. Or is that (a target sequential file) where you are using 000 for the qu...

With 'node' being a logical concept there's really nothing tying it to the number of physical CPUs... and certainly no "one to one" standard. As noted, it depends on a number of factors.

That's what I thought as well at first until I double-checked and found that the 'contains' part seemed to have been added by the author of the post to help point out the issue.

I'm not sure there's a stage that will do this in memory, but I'm hardly an expert in any of the more... err, 'exotic' stages. Sounds like what you may need is a Build Op, something in C++ to read that long string in and output individual records... yes/no/maybeso?

Talked through this with the people here and we realized that the "pre-JA" Execute Command stages I was using to "cut" the values out of the string were not needed at all. Removed them and did this: Field(StageName.$Counter,"|",1,1) Field(StageName.$Counter,"|"...

Please take a moment and mark your post as Resolved using the button at the top of the screen. Thanks.

Hard to say... what's actually *in* the .dsx files the cutter created?

Just going by what you posted as your first example:

The format is - StringToDate(trim(svTermDate2,' ','A'),"%yyyy-%mm-%dd")

Yah, nothing like 'standards' that are a) useful and b) rigorously applied.

It's a Server object, so you'd either need to use it in a Server job or a BASIC Transformer.

No, not with that command. You need to run a query on the internal repository against DS_JOB and filter on JOBTYPEIND. An exact search for that keyword would turn up several examples including this one.

I don't see how it would help at all.

Please define "not working" as that is the single most unhelpful thing people can say when they have a problem.