DSXchange

If you want to get clever, build a job to pull the relevant parameter info out of the extract(s) and load it into a database - then query away!

Export all of your projects then.

If these header names are known in advance, just name your output columns appropriately and ignore them in the data.

Export the project and search the resulting dsx file.

Replacing it with an ODBC stage would be simpler.

And tomorrow we'll tell you that since you are not using 7.5x2 you can develop PX jobs on Windows but not run them.

Basic transformer is a stage in PX just like any other stages like copy,modify.. It is similar in functionality to server edition transfomer. You can call server routines in px just the way you call the server routine in server edition.Please read chapter 17 in parallel job developer guide for more...

Hey,

Why not give Ernie's method a shot? Sounds way more better. And learn to post without nonsensically quoting the previous post for no dang reason.

Ok, now that we've gotten that out of the way - how much XML experience do you have? What XPath Expressions are you using and how were they generated - automagically from an xsd or are you making them up yourself?

Your document structure is invalid.

That really shouldn't matter. What 7.x version are you using? Do you not have the Stored Procedure stage available?

He is saying the override only happens during job execution, not all the time. What are the ulimit settings for root on that box?

Ok, I see you've changed them. Did you stop and restart DataStage after making the change?

The problem is that testing has shown that this is true ONLY if the first link(top most link) into the Oracle stage fails - if the second of third link fails then only that link is rolled back. Are you using Transaction Grouping? That is the only thing I can think of that may cause the behaviour yo...

just4u_sharath wrote:As craig said, what is a flash back

A simple Google will turn up information on the technology, which was introduced in 9i and improved in subsequent releases. Have a chat with your DBA to see if it is something they are willing and/or able to support. One such URL:

Oracle Flashback Technology

Support?

I too predict the word 'lock' will play a large role in the resolution.