DSXchange

There are also quite a number of good books available on the subject. Search a site like Amazon and check the reviews to see which ones people find worthy.

Humor fail.

As noted, normal resource constraints - i.e. memory, etc. DataStage won't care, your server will at some point.

They can tell you.

Usually easier to reverse the sort and take the first X records, you could always resort it back afterwards.

Not "limit" per se with looking up to the same hashed file from multiple jobs simultaneously, your normal resource constraints would apply just as if they were X different hashed files. This is a way to enable (don't recall the exact name) system level caching of hashed files such that one...

Still too generic. Have they told you what exactly this "mainframe data" looks like? Given you a copybook / FD? If it is EBCDIC and/or has packed fields, then yes to using the CFF stage and having to import the FD.

Ask whomever you got this from what is in their ".dat" file. That extension is way too generic and could hold anything.

Why in the world did you start a new thread when you've already got one where this very thing is being discussed?

viewtopic.php?t=138683

It could also be permissions on that repository table.

This is an exact duplicate of your previous post on the subject:

viewtopic.php?p=389591

I'm locking this one as it's in the wrong forum, anyone who can help please respond in the original thread noted above.

First suggestion, post in the correct forum based on your job type. I guessed PX, 8.x and UNIX so moved it here. If that's not right please go back and edit your post so that it is correct.

That seems odd to me as setting $APT_NO_SORT_INSERTION to FALSE is typically the same as not even including it in the job... unless your Project level default is TRUE for some reason. :? I'm also thinking that the statement "You can also use a ORDER BY statement in the sql" is incomplete. ...

Thk u!

Well... it was a 'bump' to add more information, not something we should really mind. In my humble opinion.