DSXchange

Yes. Look in the manual - search for BLOCK.

I don't think it will. I believe you will need to "keep records" of the $Counter value, and check this upon restart before entering the loop.

No, this rule says to generate INSERT statements only. It will attempt to process all the rows that you send to the stage.

YOU have to organize that only the new rows reach the stage.

Change the Display Width as well as the Char precision to 40.

It is not. It's what's called a "blocking operation" and would interfere with pipeline parallelism, so is forbidden.

Try it. Let us know.

Open Director in status view, disable the display of categories, then print the report from the list view (right-hand panel).

There is no mechanism to run a TCL query from the client machine. You need to remotely execute dssh on the server.

Why don't you ask the author of the article at etl-tools.info?

Yes, provided you have specified accurately how NULL is represented in each of those fields. In fixed-width format they can not actually be empty or null - there will be something in that fixed width.

Oracle is reporting that user id and password are not correct.

There's no way you can get around this other than by providing correct user id and password.

What values have you set for APT_COMPILER, APT_COMPILE_OPTIONS, APT_LINKER and APT_LINKER_OPTIONS environment variables?

Or, if you need all four rows, check the "multiple row return" check box.

You may safely assume from the prolonged silence that nobody has. You can go on posting daily but it will have no effect. People here post as and when they can, but only if they have something to contribute.

Avoid = don't select them in the first place (as DS_SUPPORT suggested). If you still need the rows in which NAME is null, perhaps your query could convert NULL to an in-band value, or you can do this within the job design.