DSXchange

I don't know that there's an advantage one over the other. It's really driven by the business requirement - do you need to keep ranges of keys contiguous? If not, prefer hash or modulus for a key-based partitioning algorithm; there's no pre-processing required for either of these.

No.

Welcome aboard.

There are explicit conversion functions in parallel jobs, such as StringToDecimal() or StringToFloat(). I doubt that any of these has the ability to handle a 500-digit number without loss of precision, however.

You can write custom routines to do whatever you like. Go to the Routines branch of the repository and create a new server routine. There are zillions of encryption algorithms, and you can write your own.

It's not at the top of my priority list. The project I'm being paid to work on is nearing a deadline.

Range partitioning requires that the data be pre-processed so that the ranges can be determined. The algorithm attempts to distribute rows as equally as possible over the number of partitions, and to identify those values in the key column(s) that will yield that best distribution. Those values are ...

No.

You can install on XP Pro but even that's not officially a supported platform.

Currently there is no support at all for Vista.

A Join does not generate any "rejects", either in SQL or in DataStage.

I'm not a moderator in these forums, so I go "off color" (to Dark Red) when making these points.

I must have been tired to miss the delinquencies in the initial post.

That doesn't look particularly safe to me. Yes i thought so... that's why i have not tested delete query in UniVerse Database. :D I have just asked....whether this can be implemented (by using multiple(sub-queries) joins with other "DS" tables in UniVerse..... By searching in this forum i have foun...

Yes, TMPDIR is the third option for scratch space in parallel jobs. UVTEMP is scratch space used by server jobs. Custom stages may use either, at the whim of their author.

It's my understanding that line terminators are required. You'll need to pre-process your file - perhaps using DataStage - to add them.

Why don't you Search for an answer? For this very question has been answered previously on DSXchange. It can not be done with a Remove Duplicates stage, which - as its name suggests - removes duplicates.

dsjob is the way to obtain information externally. It has families of options, one for getting information from the log (all of the form -logxxxx) and one for getting information about the job and its components (all of the forum -xxxxinfo). Deployment is really about making sure that the engine is...

Welcome aboard.

The best solution to all these kinds of questions is to have a time dimension table against which you can perform a lookup.