DSXchange

To summarize, formal regular expressions can NOT be used in derivation expressions. These must be "pure BASIC" in server Transformer stages. However, if using the Derivation Substitution tool, in which you are performing global changes of derivation expressions, then formal regular expressions are a...

I'd always advocate a separate job. Of course, you may need to detect and trap error information in the job itself, for such is the nature of these things, but simply redirect the error information into a file. The row counts and started/stopped times can be obtained subsequently. Use the times from...

Doesn't count - you already went with Oconv().

A batch is created in Director and has the string "Batch::" prefixed to its name. A job sequence is created in Designer and uses a GUI. Both end up creating a job control routine. A job control routine can also be created manually in the job properties dialog of a server job.

By "reject" do you mean "duplicate"?

When's the interview?

As a matter of principle we do not provide answers to interview questions.

How much research have you done in the manuals or by searching the forum?

When's the interview?

As a matter of principle we do not provide answers to interview questions.

How much research have you done in the manuals or by searching the forum?

You never want to do it IN the job.

Do it afterwards, so that you don't slow the job itself.

SMP is "share everything". Because every node is on the same machine, restricting a stage to operate in a particular node pool does not really affect the resources upon which it can call. Every processing node can, potentially, "see" the entire machine.

You don't understand DSSetUserStatus() function. It must be executed from within a job. Also, there's nothing in your code to run Job1.

Welcome aboard. :D

Using binary mode rather than ASCII mode FTP should prevent the line terminators, unless your job design is generating them.

A parallel routine (a C function) does NOT have a main() entrypoint.

Not possible from a script. Only jobs have a user status area.

Whta data types are specified? What null representations have been specified? Try a record schema with five VarChar fields.

The most efficient function to use is but no-one has thought to use it.