DSXchange

Sure... but have some patience, we're not all here online 24x7. This should mean you are having parsing errors. There should be several entries to that effect in the job's log, can you verify that? Perhaps post one or two of them? Usually because your column names don't match up with the XPath expre...

Ok... hard to get too specific with someone new to XML, and I'm not exactly an expert on it. In the 'definitions at the top' are there any 'namespace' or 'xmlns' entries? Did you include that in your metadata import? If so, then you'll need to load that information into the XML Input stage... you ar...

Regarding using a different platform - I am a consultant implementing the product and was issue a new laptop with XP. They are expecting you to implement it completely on a laptop? If that's not the actual end target platform for this implementation, you sure you want to be spending 'the next month...

Who exactly are you chastising, Ray? This is paule's thread, btw.

As a guess, your XPath expressions are wrong. Or you have a namespace problem. Or both. Do you have an xsd for this file? Best thing to do would be to get one and use that to import the metadata into DataStage via the Manager. That process will create the XPath expressions you will need to properly ...

Or something that is stoopid.

I have no idea if 6.x is supported on Win2003. My advice is 'agnostic', for any implementation of DataStage. I guess the biggest question is - is this a new install or an upgrade of an existing installation? If the latter, then I assume you've already got all the 'bits' in place you would need. If n...

Whatever it takes, man... whatever it takes.

The 'before' is simple - backups, as many as you can stand. This can include filesystem level backups and full exports of all projects on the server. In other words, whatever you would need to put the pieces back together if things go badly and you need to fall back to the original release. During, ...

Exactly - presorting in a manner that supports the aggregation being done and properly marking the sort fields in the stage are key to processing large volumes thru that stage.

No, not that I am aware of.

Perhaps a deterrent along the lines of a poke in the eye with a sharp stick would help?

If the only solution to this issue is to remove the IPC stage from all jobs, I will be working on this for the next month or two. Yeesh. Obviously, that's not the only solution. You could also not use WinXP as your Server platform. In spite of the fact that others may be using it 'without issues', ...

It works great now but out of curiosity, is there any reason why I can't use "?" and what's the difference btw using "?" and ":1"? Because you never mentioned your database. Stages like the ODBC stage use the stoopie generic positional question mark parameter marker while Oracle uses the much more ...

Ok... perhaps I am exposing some fundamental lack of knowledge here, but... EDM? That's a new TLA for me.

A search turns up things like Electrical Discharge Machining and Essential Drugs and Medicine. Somehow, I don't think that is correct.

Can someone throw me a bone?

No problem. We've seen the same issue on larger XML files and we've had to do the same thing - hack them up into smaller pieces.

If you do pursue this with Ascential and get another approach from them, please post it back here.