DSXchange

What have you tried? Are you able to read the XML at all? If you can, then it seems just a pivot after that would do the trick. However, what role does the ID field play here?

That's a Teradata message, take the issue to your DBA.

Never mind the fact that there is an extreme lack of detail here so not sure how anyone could help straight away. Are you getting errors / warnings in your log that you can post? Can you describe your job design? Any other information you can provide that may help people help you would be appreciated.

It's your first post here so you may not be aware of the nature of the support provided here. And I'll save Ray some time and say this for him: We don't do ASAP. If you need a rapid response, sign up for priority service with your official support provider and learn just how much "urgent" ...

Please describe your job design, particularly how you are feeding the files to be processed to your XML Input stage. I'd also be curious where your XPath Expressions came from - for example, did you have an xsd that you used with the Metadata Importer?

Can you post the complete contents of the "Controller problem" log entry, please?

jwiles wrote:The documentation you were pointed to is specific to the InfoSphere Balanced Optimization Tool only and not to DataStage in general. Unless you are using the Balanced Optimization tool, ignore that bit of advice as it's not relevant to your situation.

Ah... was wondering where that came from.

We were tring to convert in transformer using StringToTimestamp function as StringToTimestamp(LNK_SRC.CREATED_DATE,'%YYYY-%MM-%DD %hh:%nn:%ss) but geting error as invalid Month expectin an integer Make sure you understand that the format mask you use in that function describes the incoming string's...

Took me a minute but the difference is the "2" that was added at the end of this part for the month:

So... this "Controller problem: Unhandled failure" message is coming from a Sequence job, yes? And you've searched for that phrase in the forums and found that it comes from the "Automatically handle" compiler option as well I assume when the process being controlled returns anyt...

Do you have 7.5.3 in your hands? When you do, the 'readme' it includes will detail all of that - fixes and issues plus any new features added by release.

Uncheck the 'Formatted Output' option.

You had at least one short record. It was expecting it to be 80 bytes long and only found 14.

True dat.

"Create file" in the Hashed File stage opens a dialog in which you can specify tuning parameters when the job creates the Hashed File. If Create File is not checked then no attempt is made to create the hashed file. If "Delete before Create" is not checked, then no attempt is ma...