DSXchange

We can do many things like job design,view data, compile of jobs except running the jobs on windows also. i am not asking about the execution. Atleast to view source data and compile it should work. No - only with the 7.5x2 version of the 7.x releases. Without it, all you can do is compile them.

5) I went into the job menu in the director but clear status file option is not available as the job is still running... No such... it is always available regardless of status, which is why it does the 'Are you really sure you want to do this?' stuff. You have to 'Enable job administration in Direc...

Or a Sequence job with the User Variables and Loop stages.

I have learnt that the -r option checks whether the file is readable by the current process or not. And the -e option checks if the file exists or not. Pardon me, but I'm not able to see the obvious advantage of using -r option over the -e option. Please let me know if I'm missing something. It mig...

Don't worry about any of that, or this message actually. This is a perfectly normal 'warning' that you get whenever you call either of the sdk KeyMgt 'GetNextValue' routines for the first time in a Project. It logs that when it creates the hashed file and then you'll never see it again. Unless that ...

Put transformers between your passive stages so that you have explicit control over the column order.

The input stream to the sort stage reads col_a, col_b, col_c, col_d. However the output stream of the sort stage reads col_d, col_a, col_b, col_c. The input and output columns tab in the sort stage are identical. I find these two statements to be mutually exclusive. You're sure of this? Seems to me...

if it is a DS job then it shows where we went wrong but for store proc there is no info. Of course - any error handling has to happen inside the procedure. All DataStage is doing is running the dang thing. I don't see any exception handling or any mechanism to raise an error. You'd have to enlist t...

Ugg... that was not a request for you to post the procedure code.

How long do you give it before you declare that it is 'hung'?

As noted, not something you should ever see when using the ODBC stage. I'm afraid you're in Support's hands on this one. One suggestion - I've never had a problem doing so, but... don't 'upgrade'. Make backups, export all of your Projects and then completely uninstall the old version. Then do a 'cl...

Right... to use the OCI plug-ins, no 'driver' (per se) is required - that is terminology generally reserved for ODBC. What you need is an Oracle client installed on the DataStage server, and then changes made to your dsenv file so that DataStage knows where everything is. As Ray mentioned, talked to...

I don't see how you can expect anyone to be able to answer that - anyone other than you, that is. We know nothing about your procedures or what may or may not be different or special about this one.

I'm not sure more would help as I doubt you'd find anyone else who has seen that issue. Still... Is this just happening to you or is it happening to everyone? If you, I'd suggest the equivalent of whacking the side of the TV when it gets wonky - reinstall your client. I've also found the debugger ca...

How did we now get to two sql statements? You're pretty much on your own to figure this out. All we can do is point you in the right direction, but since we don't have access to your database... If the sequence were the issue, it should be throwing a different error - ORA-02289 sequence does not exi...

StringFromDate pops into my head as something similar. And there are several posts on PX date handling, this is one that I have 'bookmarked'.