DSXchange

DSguru2B wrote:Look at Craig's 3'rd reply in thispost.

Actually, keep on going and read Ray's reply to my post. That was before I knew I should be using the DataStage constants like DSJS.RUNOK rather than the numeric equivalents like a '1'.

Ok, missed the WebService Transformer in the middle - for some reason I thought it was the XML Transformer. Doh! Take the WS out of the picture. Copy the job and just leave in the Oracle and XML Output stages. Run the job until the output you get is actually what the WS is expecting and that it is '...

If that has solved your problem, please mark the thread as 'Resolved'. If not, let us know what other questions you have on the subject.

Welcome, Jewel. :D You can't change the value of Job Parameter inside your job, it's not allowed. You can, however, derive a new variable from it - perhaps as a Stage Variable or in the Transformer derivation itself, for example. Perhaps a little more information about what exactly you are trying to...

That's good, one less thing to panic over. And you did not need to quote my entire message just to reply to it. FYI.

What do you mean by "the parameter values need to be prompts"?

You have to know what values to use from the command line, there's no 'prompting' there. And you only need to pass in values that need to be overridden, otherwise they will take their default values.

That was your first problem - I never run Server jobs with the warning limit set to 'no limit'. Never. Your log is at the very least HUGE and at worst case corrupted. As Ken noted, you also stand an excellent chance of something like that filling up the disk where DataStage is installed to disastrou...

ayoga wrote:For Chulett, some people might say that this version of 7.5x2 is little bit 'buggy' ?? Is that true ?

You'd have to ask those 'some people'. I don't have any first hand experience with it, so can't comment on it.

Why don't you let us know what you are trying to achieve, rather than asking such generic questions?

An interview question. And a trick one if used in the context of a Server job.

Define "can't view the logs". What happens when you try - an error, a hang, what? If I had to guess I would wonder if they are large and will take some time to view. Did you run your job with 'unlimited' warnings? As noted - You set the timeout via the Administrator. It's at the bottom of the Genera...

Remember way back up there when I said we were missing a critical piece of information? Well, here it is: i got this warning issue resolved. i have a execute command stage at the end in my main sequence. this says /apps/etl/Ascential/DataStage/DSEngine/bin/dsjob -run -mode NORMAL -warn 0 jobname&...

No worries, we figure we'll get back to it when you get back to it. Let's start with this: post the actual errors that you get. No summaries, no approximations, no 'it was something like' - the actual errors pasted from the logs. We've chased too many wild gooses when someone doesn't do that. And I'...

On the subject of hints - just be careful how you are using them. More 'generic' hints, for lack of a better term, can be fine but it's hard to make a 'generic' rule about their use. Sometimes specifying a particular table join order or 'nested loops' can be fine. But forcing a level of parallelism ...

Doh! Interesting point about the 'Relationship' tab. Guess it pays to poke around more - in all honesty, I'd never looked there as I know the relationships for all of the tables I deal with, never mind the fact that I have other tools specifically for that kind of information. I import the metadata...