DSXchange

It takes 12 years to get 12 years worth of experience. Begin by reading the manuals and online help. Then ask specific questions. DSXchange (ignoring the soon-to-be-announced Learning Center) is not a source for general training. Take a class or three.

How are you trying to do this? A proper column analysis should investigate all rows. There is the capability to work from a sample, but not - as far as I am aware - any capacity to select rows.

Disk full?

You haven't really given us much to go on!

Get it via a Lookup stage whose reference link is fed with the query SELECT MAX(keyvalue) + 1 FROM targettable and which is partitioned Entire. Downstream of that use a column generator to add a sequence column beginning at the partitionnumber and incrementing by the partitioncount, and use either a...

My solution works in parallel mode. The Aggregator counts the members of each group. The filter stage only passes rows for which the count is greater than 1. ----> Copy ---------------------> Join -----> Copy -----> RemDups -----> | ^ | +-------> Aggregator -------+ +----------> Filter ----->

No, because IBM don't document that. We know there must be a limit because we're software engineers, and there's no such thing as unlimited memory - you always design maximum sizes for things. Years later, you wonder why you thought so small - was it not a young Bill Gates who asserted that 640KB is...

If you are using server jobs (which one can assume from the forum in which you posted your question) you can use Oconv() to determine the current time zone.

Typically the database server will establish the result set and the DataStage job will establish a cursor into the result set, fetching an array of rows at a time. There are variations on this theme, but in no case (in server jobs) does DataStage cache the entire data set in memory.

Which particular user name and password? There are at least three now. One for the deployment domain, one for DataStage, and one for Oracle.

If you right mouse on the expression field does a menu appear? If so, is "Edit Derivation" on that menu? If so, what happens when you select that option?

Is the first character a space or some non-printing character? It's possible that, if it's a space, it's been trimmed. I know that's not correct (and would be a bug), but that's my guess.

No. The whole point of premium memberships is to fund this site's bandwidth costs. Shell out - it's less than 30c per day. There's no point providing a long answer to your question at this time. On the other hand, if you want to purchase customized training, then please consult my website for offeri...

Please post the record schema associated with the Data Set, as reported using the Data Set Management tool in Manager (or orchadmin command).

newcolumn:nullable datatype = function[options](inputcolumn)

IBM are very specific about this.
For IBM Information Server the only choices are:

DB2 version 9

Oracle version 10g

SQL Server 2003