DSXchange

So you asked those questions of IBM Support?

That function is the equivalent of the -warn option from the command line, for use by BASIC job control code - i.e. when using DSRunJob(). Which you are not.

1. Just that session. 2. From what I recall, you can set the Director's default to unlimited but it's still just for you. 3. Not that I am aware of... and I'm firmly in the That Would Be A Bad Idea camp. 4. The Director limits are not applicable at the command line. I don't recall if the default of ...

I'm going to agree with Shane's first question if you feel the need to use SQL to 'do transformations'. Has your company considered bringing in someone to review your job designs and ETL methodologies? Seems like it might be a prudent investment before spending time and money on an alternate plan wh...

If sorting large files is something you need to do a lot and the DataStage sort doesn't seem fast enough for you, you could look into leveraging a 3rd party "high speed" sort package like SyncSort or CoSORT. From what I recall the latter has a DataStage module.

BSG1 wrote:Lookup can't help.

Why is that?

Thanks for posting your resolution.

Also note that there's nothing really magical about the Balanced Optimizer per se, meaning it doesn't add functionality to the product that it or you couldn't already do or have - it just does it for you. "It" as in rewriting jobs to push processing up into the source and down into the tar...

Describe your job.

udayk_2007 wrote:Sorry the previous post had smiles enabled

FYI - You could have edited it rather than reposted it.

udayk_2007 also wrote:Does varchar and varchar2 cause any difference ?

No.

:idea: If you want people to be able to help you, you'll need to be more forthcoming with details of the issues you have. Saying "it failed" doesn't really help anyone help you... so failed how? What was the error message? It would also be helpful to respond to all points brought up, for e...

maks475 wrote:when I ran this directly from command prompt it is working fine

Did you do this using the same user that executes the job?

vamsi.4a6 wrote:Could anybody please reply on it

Could somebody learn a little patience please? You waited what - not even two hours - before deciding you needed to stir the pot? And this at a time that was smack in the middle of the night for quite a number of people.

Sheesh.

Yay, still not clear.

So you're ok with it aborting if it needs to but if it does you don't want it to log the 'Run stopped' message?

How can you avoid what "that", exactly?

ps. It's not "for Craig".