DSXchange

While we install the SAS stages, will the required executables automatically get installed or do we need to purachase any license and install them later For the two questions wrapped around the "or" - no, yes. With the SAS stages in DataStage, just like any other add-on you get the abilit...

I would think you'd be better off adding all of the $APT variables that would help diagnose issues like this... unless you've already done so. Don't have a list of them handy but I'm sure someone does. Perhaps a silly question, but any chance there is a 'before job' process associated with these job...

You might want to start by clarifying what exactly it is you mean by "run the osh".

What kind of help are you looking for? The warning is perfectly valid - any idea if all of your integer values are small enough to fit in that smallint field? If so you could demote the warning, otherwise you'd need to alter your target field.

What kind of 'details' are you looking for? You could certainly script something that leverages dsjob for this, looping thru projects then jobs to see which are running.

Sorry, I honestly have no idea but can tell you that there isn't any kind of LDAP specific stage.

Well... let me see what I might have. I know I've got a heavily augmented version that I've been using with my clients but that's not something I could share. However, I may still have the original recipe version somewhere... let me see if I can find and dig that up over the weekend.

I don't recall if they were actually available for download from Ken's site, it's been way too many years since I got my hands on them. I do remember that you have to register at the site and then (perhaps) request a copy from Ken?

And I have no clue if his site is still active...

In your shoes, I would start by contacting my official support provider.

You're correct Phil except for the stored procedure part. In DataStage it is a licensed option called "Balanced Optimization" and is basically equivalent to what Informatica calls "Push Down Optimization". There is a mention of it here with the full whammy here.

Are you using the Connector? It is one of the "LOB-aware" stages in 8.5 and I don't see why that would have changed in the 8.7 release. Every release has "its own issues" and it sounds like this is one... please let us know what support has to say.

Keep in mind the fact that the Redbook mentioned was written in 2008 for the 8.1 release. Not that that invalidates the quotes, just... things can change. Actual hands-on experience helps when in doubt.

Perhaps this might help:

http://www-01.ibm.com/support/docview.w ... wg21499421

What are your rules for this "amendment"? How do you know what to amend the input parameter with... is it always just something you do with "EU" or are there others that need the same treatment?

You shouldn't need to escape the quotes any more. Check this technote to see how to allow them to be retained.