DSXchange

Search the forums here for "OCI has fetched truncated data", it has been discussed here a number of times. Is there a CLOB or other "large object" being loaded in this job? A unbounded NUMBER field? Those are two things I personally have seen cause this problem.

Suggest you spell out your data transformation rules rather than expect everyone to divine them from your example.

Then you don't need RTI or a service, unless your sender is willing to ping the service when they deliver the file. All you need is a polling process, one that kicks off the job when the file arrives. How tightly wound does this need to be? Can you check once a day over the course of the month or do...

A "D_" prefixed file is the "dictionary" entry for the corresponding hashed file associated with it.

Welcome. :D To the best of my knowledge, no, not automatically. I typically trigger different emails based on the job status which have different subject lines but that's probably not the answer you are looking for. Worst case you could always write your own email notification routine and then have ...

Now we start getting into the long answer.

It all comes down to what "waiting for XML from some other system" means. A file? A call to a service?

It's part of the "locale" settings in UNIX, something I can't really explain but have run afoul of. Check here for an example or google around, which is what I did back in the day. I found I needed to add it to make UTF8 "work work" - if you don't have any issues, don't worry about setting it. And y...

Not really a second option, per se, but one of the techniques discussed to implement a vertical pivot in a Server job. And you don't really need any stage variables, simply read and write to the same hashed file concatenating values when you get a hit. Make sure the reference lookup isn't cached!

You sure they existed five years ago?

That would be a pivot, specifically a 'vertical pivot'. Since the Pivot stage is 'horizontal' you'll need to do the dirty work yourself. Search the forums for 'vertical pivot' to find all of the previous conversations on this topic.

Start your own post. You've jumped on the end of a resolved thread about adding milliseconds, which has nothing to do with your issue.

Your DBA. Have a chat with them and then let us know what approach they recommend and we'll see about helping you implement that in DataStage.

Short answer is "yes". And there's no need to shout.

Have you tried... oh, I don't know... searching for that error message? Pretty sure I've seen mention of it here before.

Search the forums for the DSGetLinkInfo function which can be used with the DSJ.LINKROWCOUNT InfoType to get the information you need.