DSXchange

Orc files? Ah... some kind of Big Data / Hadoop thing like Hive or Pig or Saruman.

I didn't ask about partitioning, I asked about locking. You ask about both, actually. :wink: What level of locking (transaction isolation) are you using? How are your data partitioned? And the fact that it runs fine on a single node still smells like a partitioning issue to me, the details of which...

Sounds to me like you're not hashing properly. What are your hash key(s)?

Wrapped stage.

Gonna need much more information before anyone can help. Guessing when you say you are able to "retrieve in UNIX" that it works properly when you call it from the command line, yes? You'd have to show us how you set up the Wrapped stage, I would imagine, plus consider on your side under wh...

Right, definitely not a single quote / apostrophe but rather some flavor of "smart quote" as noted. Had planned on mentioning that earlier but forgot.

Thanks for posting your resolution.

I'm going to mark this as Resolved for the moment. If you need more information or are looking for alternatives, please feel free to open this back up and let us know.

No clue why you decided to post this AGAIN, here is the original. If anything else needs to be added, it will happen over there.

Confirmation would have to come from IBM, not me, I'm afraid. Or perhaps others here, people actually using Sybase and your release. I personally would not recommend using the DRS stage unless you actually understand and need the "dynamic" aspect of it. If you're going the ODBC route I wou...

Ah... the SMP notes would have been good to know up top. As to your last question, isn't that all up to the operating system, not DataStage? And aren't you worrying about the "additional free resources" so that performance improves?

You could use either, I suppose, but isn't there still a Sybase Enterprise stage in your release?

Still curious if this formatting is actually causing a problem for whatever is consuming the file...

I would imagine you do use istool for that nowadays. Have you tried it, had any luck? Edited to add: And... according to this post the answer is no. Command line choices for importing from dsx files do exist, including dsjob, dscmdimport and dsimport. Scratching dsjob off the list, however. And I do...

Thanks, just wanted to confirm before I moved you out of the General forum to a job type specific one. As noted, use the Complex Flat File stage for this. Do you have the FD that describes the file layout? The CFF stage is a bit daunting at first but is what you would need to learn to consume that k...