DSXchange

Than that's not the problem. Why not post your actual failure message, see what people can tell from that?

Typically, the later versions include the earlier versions, but you can go back and install 1.1 without hurting your 2.0 installation.

Can you show us how you are mapping that column into the stored procedure? That error actually says you have columns in the stage that are not being bound into the proc.

You'd have to be a wee bit more specific regarding what the nature of your problem running a PX job is.

The square brackets "[]" are the substring operators in both products, for whatever reason I never use the function.

Or use a BASIC Transformer? Does that not also work? Never had a chance to actually try that out...

In other words, the same way one would without DataStage.

I'm not aware of a definitive test to determine that, perhaps others might know. Can you not ask whomever purchased it for or installed it on your system?

It might be hard to know what to search for, but it is out there and has been discussed quite a number of times. Perhaps a search for "group change detection" would turn something up? Let me see...

Yup, for example:

viewtopic.php?t=131838

If it is not in that "branded_odbc" folder with the other drivers, then it seems to me you need to contact your official support provider and see what they need to do to get that to you... a patch, perhaps?

Yes, stage variables are local to a transformer. Perhaps a search for USERSTATUS would help? They can be accessed and transferred at the workflow... err, Sequence job level between jobs easily, especially if you use a Server job to stash that value.

Ray just meant you missed a "d" in the name you grepped for, so you should correct the spelling and try again to be certain.

This really doesn't have anything to do with IBM MetaData Workbench, does it?

Rather than 'sed' change the 'Data Element' to XML so it knows it is already XML and will not convert those characters in your output.

Sorry, looks like I missed the example in the original post.