DSXchange

That works only if the job is run (or scheduled) from the Director.

Simple - write jobs that do not generate warnings. Server jobs are not PX jobs - there's no reason they should ever generate warnings. Seriously. We run a couple thousand a night with nary a peep. You'd need to set the warning limit to something else when you start the Sequence, in other words over...

So? Because of that you are completely discounting Ernie's response? Simply substitute 'WSClient' everywhere he said 'WSTransformer', then go try out his suggestion.

What's "not working" about it? Details, please. Also talk to whomever set it up, ensure it has an equivalent smtp email address.

It always helps to mention your database. Which ODBC stage are you referring to, the Enterprise stage I assume? The pdf reference for that stage mentions a dboption of -rowCommitInterval you can use to control that, suggest you give that a read.

Then obviously something is wrong with your 'particular environment' and the Oracle configuration there. Have you checked to ensure $ORACLE_HOME and all of the appropriate PATH values (etc) are setup properly there?

Why is this marked as a TX question?

Hmmm... could swear one is out there somewhere, but my weak search skillz this morning could only turn up this.

http://www.dsxchange.com/viewtopic.php?t=88145

Ray was specifically talking about using a 7.5.1A client to connect to a 7.5x2 Server - the 'special' Windows-enabled PX version. This really shouldn't be a problem in a 'normal' environment. Your confusion about only seeing the Date branch of the sdk is exactly what I mentioned earlier - transforms...

Paste your exact error here (not something 'like' it) and tell us exactly how you 'tried with LongVarchar'. Details, man, details!

You have some work to do. Where did this increase come from, any jobs in particular? Identify the culprits, then you'll know where to concentrate your efforts.

What 'other functions'? Please come back, mark the thread as Resolved and let us know how it was resolved - this helps people right away and future searchers benefit as well.

Odd... you probably need to take this question to your Support provider, looks like some new problem introduced in 8.x?

DataStage does not come with any scheduler, per se. Instead it comes with an interface to the standard scheduling tool on your platform - for UNIX that is 'cron' and 'at' while on Windows it leverages 'at'. Now you can use pretty much any scheduling tool you like, something like Control-M (for examp...

aladap12 wrote:Reply needed Immediately

Why would that be?

aladap12 wrote:This is extention to my previous post about webservices pack

What post would that be?