DSXchange

A stored function is selected in a query just like a table column and DataStage doesn't change how any of that works. For your particular function, get whatever syntax you need from whomever you work with, your DBA for instance.

kurics40 wrote:Sorry that I hijacked this thread but it is not clear how it could work.

There's a simple solution - don't hijack threads. Start your own thread and link to the other one, something I've done for you here. That way you are in full control of its destiny.

"Fork join" design. Count the number of occurances per key and put that in a hashed file. Stream in the raw data, do the lookup and constrain to the appropriate link based on the looked-up count being 1 or >1.

All that means is your script did not return success, a zero status. What else are you doing in the script besides this ssh command? Have you tried adding any debugging statements to it?

Why not ask IBM? Not sure how anyone here would know...

Talk to your SysAdmins about having them add the 'execute' permissions to dsjob your user seems to be missing. Are you sure it's just a permissions problem?

It's not a Server job if you are getting that error. What does your job design look like?

Shouldn't be all that hard to find, somewhere under 'Tools / Options' from what I recall.

I don't have access to my notes right now, let me see... one sec... here, this should help: viewtopic.php?t=145303

Ask your DBA.

Why is it aborting when you use a parameter? Does the sql include quotes and does it look like the quotes are being stripped out? If so, there's an APT environment variable that may help...

ps. While I'm sure there's a limit, 400 wouldn't be anywhere near it, so the size should be a non-issue.

That's exactly what I've been trying to avoid OK, I'll bite... why would that be? In my opinion, this kind of thing is preceisely what one would take to official product supprt, DataStage or otherwise, rather than try and puzzle it out for yourself. I know you are looking to see if anyone has seen ...

Really too much like an interview question to be simply answered by anyone here but since Ray has already handled an identical question in the past, I'll link to it:

viewtopic.php?t=126751

Do an exact search here for both dscmdexport and dsexport, they serve different purposes and have been discussed here a fair bit. One example of such a conversation is here. FWIW, I don't see any mention of the either in a search of the 7.x documentation that I have, while both are discussed in my 8...

No clue and obviously not something documented either. Have you asked your official support provider?