DSXchange

How are you calling the stored procedure - using the Stored Procedure stage? If so did you import the metadata from the procedure into the stage?

Should be in each project directory, I would imagine.

So... not a DataStage question. There are plenty of resources out there on how to use the RANK analytical function in Oracle at sites dedicated to supporting Oracle and/or SQL, search and ye shall find.

31538 is the main one. They're all listed in the Planning, Installation and Configuration Guide.

eostic wrote:Probably someone should move this to a new thread....

That's my cue! Away we go...

I've done something very similar with the "need to stop" polling for a file that Ray mentioned... but it was every 5 minutes. No problems with the sequence job's log. The job you run "80 times in one day" will have 80 opportunities a day to purge itself.

Option c is not valid. Enter xlc for list of valid options. Did you try doing as it suggested to get a list of valid options? The post you linked to stated their problem turned out to be they only had the runtime libraries installed but not the full compiler. Looks to me like you may be in the same...

So... they are a decimal 160 which is A0 in hex and 240 in octal. I don't believe your "\240" is valid, seems to me you would want to use "\xA0" or "\d160" or "\o240" so it knows what base to use.

sachin.lakka wrote:I believe, this is extended ascii character.

You can use Oracle's dump function in a select to see exactly what those are.

Try an exact search here for "Incompatible connection", looks like some other people have posted about that error. Perhaps one of them will help.

I would involve your official support provider, if you haven't already.

OK, that helps. Details are good. :wink: Does the job's log show the command that was issued? Not just the problem but what exactly it was it attempted to execute? I don't recall if it behaves like the Execute Command stage does. I'd also be curious if you have a shell issue. What shell does the job...

OK, good. Then as long as when you use pipes in the wrapper you use them in a "normal" (for lack of a better word) manner then you should be safe. Or "pipe-safe", I guess I should say.

I'd first be curious if you understand the concept of pipes themselves? From searching (or at least attempting to) I get the impression that they've made up the term but have also explained what they mean by it. Also out of curiosity, are you just learning about the Wrapper stage or do you have a us...

Welcome aboard. There are several ways a job can be triggered but one of them is not "on its own" I'm afraid. Something out there is telling it to run, could be from the command line via dsjob or it could have been scheduled in the Director by a user you are not aware of. Unless things hav...