DSXchange

Not PAL, but I do have DataStage server routines that perform this task, if that's any use to you.

Have you tried it without the floating position specifier? Assuming you mean !\: would not that identify only that the first character is not a colon? Similarly, *!\: will search for any character that is not a colon and stop as soon as one is found. Neither of these satisfies "does not contai...

Create a preliminary job that reads the header file and creates a schema file (so that the Sequential File stage can use RCP to read the file) and also creates a Modify stage specification to translate from today's columns to the "official" job columns. Provide the Modify stage specificati...

OK, so you need the DataStage API function DSGetLinkRowCount() and DSSendMail().
You can find examples of the latter under \Routines\Built-In\Utilities in Designer.

That's the why. What do you actually want to do with them? Write to file? Send email? Something else?

Welcome aboard.

You could create an after-job subroutine that uses DataStage API functions to retrieve the link row counts.

What do you want to do with these counts?

This warning has been around for a long, long time. Easiest solution is to set the value of PWD. For convenience I set it globally for DataStage users to have the value "." (current directory).

Basically you need new configuration file(s), and to ensure that anything that all nodes need to access are accessible from all nodes. Particularly the parallel execution engine needs to be accessible from all nodes.

Welcome aboard.

At current version the answer is "no".

There is no limit in DataStage. File contents are streamed through DataStage.

There may, however, be operating system limits on the size of a file, for example 2GB on a 32-bit file system.

You can join the Oracle Connector stage directly to the Data Set stage. A Copy stage that does nothing will be optimized out of the design when the job is run unless you prevent this behaviour (prove this by examining the score). A Transformer stage will waste a small quantity of resources at run ti...

Based on the information you have provided, you are not correct. All three invocations will run. The fact that they can have invocation IDs already tells us that they are configured for multi-instance running. However, the design itself may cause failure. For example, if all three try to write to th...

Here is a function for adding intervals. They are expected to be in HH:MM or HH:MM:SS or HH:MM:SS.ssss format. It makes great use of the typeless environment available in server routines. Adapt as required. FUNCTION AddInterval(aInterval1, aInterval2) $COPYRIGHT "Copyright (c) 2006 Ray Wurlod. ...

Otherwise create a script that loops through the result of dsjob -ljobs command.