DSXchange

I have a routine that checks for existence of default names on stages and links, but not much more than that. We have many more standards but I have not given any thought to automatically checking; we normally advocate a process of peer review, because that also involves documentation and unit testi...

Welcome aboard.

No changes to job design will be required.

Why are you migrating to such an old release?

Probably Web Services Transformer stage.

Row width?
Number of nodes?

Try "escaping" every single-quote character in your SQL with a backslash.

I suggest that you read the descriptions of buffering in the Parallel Job Advanced Developer's Guide. Buffering is not a "more is more" situation. You may get less speed with larger buffers, if they're too big already and you don't have enough memory to support your settings. Why have you ...

How are you partitioning your data? Does it work (whatever that means) if you run on a single node configuration?

What does "no luck" mean?

Have you tried Change Capture stage?

What have you tried? What have you thought?

We're more about helping those who have already made an effort to help themselves.

There are some here who are happy to provide solutions; they call this consulting, and it's all billable time.

Not within the rule itself. But you could apply a Filter to the data being profiled.

The error message is not about the function itself, but about the fact that you're trying to apply it to something (a Field() function) that is not an input field. You need to re-work your logic so that you're only testing an input field with IsNotNull().

Why not just use NullToValue() function?

Try &hBB

Won't be able to answer that till I get in front of DataStage Designer next.

Probably, if none of your jobs runs more than two days. You need to be more careful if you use always-running jobs in conjunction with ISD, for example.

Beware, too, that DataStage requires a C++ compiler. When you license xlC_r you need to specify that. The C compiler itself is not required.