DSXchange

The Sybase driver is a wire driver and so does not need the client. You would need it installed for the Sybase stage however.

Hey, I said it first - but y'all probably thought I was joking. As noted, I too would push back hard on whomever decided this was a 'good' approach to take.

We use Control-M here internally, when I need help with something related to that I go to the people charged with supporting it. Do you not have access to your 'AutoSys people'?

laknar wrote:How to execute a script in Batch Jobs

Or use DSExecute to run your script.

No SAP experience here, so no - other than to suggest you take this to your Support provider.

The key question is - how many records are in your incoming data set? How many records exist in the table you need to lookup against is irrelevant.

Been discussed here quite a bit, which a search for "ParamValue/Limitvalue is not appropriate" would reveal.

Maybe your Oracle date picture is set up to require an alphabetic month. There really is no such thing. An Oracle date is just a date stored in internal format and never requires any particular format. You just need to be able to tell it what format your data is in, that's what the TO_DATE function...

AFAIK, connecting pooling is transparent to the 'poolie'. So, any application, DataStage included, will just connect and Oracle will manage the pool.

dsjob will give you that:

Let's work this the other way 'round. I've seen some odd issues with VC trying to promote Shared Containers at the same time as the job that uses them. To work around this, I do two things: 1) Promote the shared containers in a separate step. Always. 2) When promoting a job that includes a shared co...

We patched up just after this and have been running without issue since. Guess it's time to mark this as resolved.

And, a sample from anyone will not help you since the db connections won't be valid at your end. Infact, what you are totally ignoring is that this is one of the most simple things to do. So just give it a try and if it doesn't work, we will walk you through it. Adjusting the db connection is easy,...

So... this has got nothing to do with 'auto purging' but rather you are looking for some schedulable way to manually purge your job logs? What about the Auto Purge functionality isn't working for you? As noted, you can get your hands on Ken Bland's utilities from his website and one of them will all...

Schedule "an entire Project"? Besides that fact that you don't really do that from a UNIX script, I'm not really sure what that means - and I can't imagine anyone needing to do that if I'm guessing right. How about you explain what exactly it is you think you need to do? Take a little more time to l...