DSXchange

What happens when you need to take a backup?

... which still requires a BASIC Transformer stage because of the Fold() function. Further, Convert() is a more lightweight function than Ereplace().

It's not an @ symbol for NULL, it's ^@ (which is notation for Crtl-@ which, in turn, is Char(0) which is one way to represent an empty string).
Numeric fields are passed in binary format, so you would expect to see bytes of any value. For example ^D is 4 and ^H is 8.

Is it just your client machine, or is it other clients at your site as well that exhibit this symptom? Can you still open the stage property editors when they appear as black boxes? Has someone changed or tightened the protection on the folder in which the stage type images are stored on the client?...

NEVER use kill -9 as the first choice to terminate DataStage processes.

True, but it's still locked, which means that no-one else can change it while it's open.

Is the question really "can we make a job read-only in 8.0?"

You can always use the "short" (sometimes called "8+3") names in a pathname to avoid using special characters.

I am not a premium member. can you post your code once again? Premium membership is one of the ways that the hosting and bandwidth costs incurred by DSXchange are defrayed. Do consider taking one - they're not expensive, at less than 30c (Rs12) per day. Without such sources of funding DSXchange wou...

What's the data type of CATEGORY? In particular, is it CHAR and is it nullable?

The UNIX administrator needs to set you up in two files (cron.allow and at.allow) before you can use the operating system schedulers.

Have you nominated a repeating element?

Use a BASIC Transformer stage and the following expression: or this one:

Change Capture, Difference and Compare stages do not require additional licensing.

I think you're confusing these with IBM's Change Data Capture (CDC)technology. There is a stage to interact with CDC but you do need to have CDC separately licensed. After all, it's a separate product.