DSXchange

You should check your database DDL, not (only) the DataStage definition.

Yes (normal lookup loaded into RAM)
Yes (specify normal or sparse lookup in the source DB stage)

I would fix the nullability issue first. Your "field1" is declared as nullable in your database - check your table DDL to confirm. Once you handle the null then you can attack the second problem, if it still exists.

The short answer is that you cannot check the row count for 0 in the transform stage, as processing doesn't go there. There are several methods commonly used to do this, but this depends upon the nature and type of your source data. With database tables as sources, an external "SELECT COUNT(*)&...

A "normal" lookup will read all of the reference data into memory to speed up subsequent lookups. A "sparse" lookup will perform a read of the reference for each data row. The latter is best when there are a large number of reference rows and just a few data rows, or where the re...

From the path information, this is in the server side of the product, not the client side; I am assuming that both are on the same machine. I don't know the Windows command to see which process has a given program or library open, but one option might be to stop the DataStage server prior to install...

If "getconf ARG_MAX" doesn't work, please tell us your shell and UNIX type.

Right at the top of the code are the comments

Each partition is only aware of its own data, so there will be 4 stage variables on a 4-node configuration. You can get a unique number by using the following derivation:

svUniqueNumber = @PARTITIONNUM + ( @NUMPARTITIONS * ( @INROWNUM -1 ) ) + 1

There will be an entry in the director log after running the job for the PEEK stage, double-click on that to see the data for the stage.

I've used RCP quite a bit and for such things as generic containes and jobs it is a powerful and useful tool. I keep that checkbox turned off and then explicitly set RCP on for those jobs/stages where I use it to avoid the confusion that you've mentioned - which is not limited to beginners.

You probably have a parallel configuration file with 2 nodes.

Perhaps you have RCP enabled on the transform stage output, thus implicitly passing the column on.

Please post your query, that would assist in any debugging.

The command you would need to use from cron is dsjob, the options are detailed in the documentation.