DSXchange

Ok... did you miss the "as of" part? I don't recall any of the UNIX versions I worked with (pre-9.x) shipping with SQL Server drivers, hence the question as to when 'they' started including them. Or maybe they always did and I just never needed to use them.

Involve support.

Good to know... any idea as of what version?

That's the thing, you can't. To go that route you'd need a script on the UNIX server that would remotely access the SS database and invoke the job. That or perhaps your company could buy / install UNIX ODBC drivers for SQL Server on the DataStage server and then trigger it through a job or script. O...

The first question in my mind will always be "how would you do X outside of DataStage?" - that should give you a good head start on the how of from / inside DataStage. Now I don't do SQL Server but seeing as how it is Windows only then in my mind the question would be "how to call sql...

I was assuming they meant "logic" errors more than actual syntax errors. Since they're, you know... complex.

Not sure how much help you need on this... a gentle nudge in the right direction? Stage variables in a transformer controlling both the set count and doing "group change detection". On the first record in the group increment the counter, for the rest of the group use the current value. And...

mapping table is not suitable for some reason Not really sure what that means. "Mapping table"? Are you talking about rules driven derivations? Regardless, for Server or Sequence jobs it is easy to build a "test harness" - a custom BASIC routine with the derivation logic in it t...

Involve support. I could make a guess based on it having something to do with "allocateOCIHandles" but it would be just that, a guess. Seek professional help.

You really need to start your own topic for this. You're not in the "same situation" unless you also can't connect to server XYZ and they've made no mention of XML.

Please start a new post, let us know your requirements and detail whatever issues / specific errors you are seeing.

Right, you don't "run" the dsenv file, DataStage does.

What do you mean by "client machine"? The Oracle client needs to be installed on the ETL server and should match the "bit-ness" of DataStage. As noted, those should all be detailed in the Configuration Guide, did you find it? They're online as well if you don't have them locally ...

Welcome. It's always best to post your requirements spelled out in words rather than simply posting the input and output and expecting people to puzzle them out for themselves. Having said that... That's still a horizontal pivot of columns to rows. The added wrinkle here is that part of the 'data' a...

Right, you seem to have the two parts backwards.

First off, let's get you out of the FAQ Discussion folder and over to where you belong... there, done. Now, please go back and edit your post to include the bits the other forum didn't require - in particular your Version and O/S flavor. Thanks.