DSXchange

As with most things DataStage, there are multiple ways to solve this.

Have you verified where this data is being 'truncated'? Meaning, if you check the COLB outside of DataStage, say with Toad or something similar, is it whole in the database. Also a bit curious why it's not being stored as an XMLTYPE...

An exact search here for JOBTYPEIND will turn up discussion of the solution Ray mentioned.

In your shoes, I'd be in contact with support while you wait to see if anyone here has the experience needed to help you.

I for one would be curious what you've tried so far. Did any of the things you've tried involve concatenating into a stage variable and a Remove Duplicates stage, perhaps? Or sorting and a KeyChange column?

Or... something else entirely?

We'll have to wait for someone else to answer that.

Doesn't that connector only support the WebSphere MQ server?

Just as an FYI, they don't work because the forum software doesn't recognize them as valid image links, pretty sure they have to end in something more like .png/jpg/gif and the like. Took off the tags so people can click on them... they still don't work for me here but they block a ton of sites at w...

I've done this back in the day both automated and manually and commented on this topic before, echoing much of what is already here. Hope it helps. FWIW I always found the dsx version easier to work with and you save all the behind the scenes shenanigans where every XML import needs to be converted ...

Not quite sure what "thrm on earlier rrleases" or "the most advanced rcp-capanle omd" might be... are you posting from your phone again Ernie?

What have you tried? What kind of Oracle "timestamp" are we talking about, there are at least three from what I recall... can you post the actual, full data type from the table? Just want to confirm what you're dealing with...

LOL Thanks. The only example I saw had an input value more like "20090213233130" for that date (which is a little brain-dead) but running your example through that epoch converter site outputs the same external value as in the example, so good. 8) Just be aware that that is GMT rather than...

Meaning, not using DataStage? Have you tried an internet search? I would imagine it would turn up whatever your options are.

It's not about the runtime and wouldn't affect the "parallelism". I'm just suggesting a few seconds difference in the launch time for the three simultaneous instances of Job2 so they all don't try to start at once, make them a teeny bit less... simultaneous. This so the "startup"...

Not even close to the same thing.

That is an ISO timestamp string with a "T" between the date and time. An epoch date is the number of (milli)seconds since 01/01/1970.