DSXchange

Shouldn't it be an 'S' rather than a '+'?

Andy Sorrell posted about the document, didn't realize that was over 1.5 years ago at this point. Next to last post in this thread is where he mentions it. No guarantees he's still in a sharing mood.

D'oh... that's true. Only need to check specifically for things not included there, such as the ulimit during a job session.

ray.wurlod wrote:From memory Oracle's is also 31 characters

30, actually. For the record.

Well... obviously it's not set for the job. And what you can do from the command line isn't all that relevant. Try running 'set' during a job session and see what's captured.

pravin1581 wrote:I am new to DataStage SOA,i have been assigned with a responsibility of comparing SOA with PX, but as the software is not available i am not able to acces any online help.

Interesting... I'm curious how anyone could expect you to be able to accomplish anything like this.

You have the appropriate PATH statement in the running user's .profile? Not sure, I don't rely on anything being preset, I script things like that and ensure it sets whatever it needs.

Fully path the dsjob executable.

Abhijeet1980 wrote:What if the no of parameters are more ...Say about 20 - 25 odd.

And you can't let any of them default?

As Kim notes, you can script this. Or use something like Ken Bland's Job Control Utilities.

That's basically correct but you'll need to bind all of your columns into the call. It would also help if you posted the actual syntax error.

You could always tick the 'Generate procedure call' option and the stage will do it for you.

Thank you Uncle Ernie.

Why are they still distributing it if it is 'obsolete'?

gaurav_shukla wrote:the thing is when that specific conditon fails then job does not create sequential file and it directly aborts.

What 'specific condition'? What abort? Not a whole heck of a lot to go on.

bcarlson wrote:So, in a effort to understand where they are coming from, can someone help me understand why they would be suggesting these options

Why not ask them directly the 'why' of the 'what' they are suggesting? Surely they must be able to back these up.

'Metaverse' was coined by Neal Stepheson in his novel 'Snow Crash' way back in '92. Things like 'Second Life' are trying to emulate that vision today.

Umm... wow.

ds_is_fun wrote:If Oracle is on a difft server then you need to config your Oracle wire protocol for ODBC stage.

Or install an Oracle client on your DataStage server and use OCI.