DSXchange

There's no single function. Use If..Then..Else to test whether the rightmost character is the one you want to change then, if it is, concatenate the replacement character to the string without its original rightmost character. If Right(InLink.TheString,1) = "X" Then Left(InLink.TheString,L...

OEL Linux is not a supported operating system. Only Red Hat and SuSe are supported Linux variants.

Learn about the UNIX umask command. Put umask 002 (recommended) or umask 000 (to give 777 permission, but not recommended) into the dsenv script. The preferred approach, however, is to create a group for the project, and to add authorized users to that group. In this way, the whole world does not re...

The files .operator.adm and .developer.adm are not created until a group is given access to the project via the Administrator client.

In Pune when the original query was from Singapore?

There is a base charge (per component) levied once, and an ongoing annual fee (expressed as a percentage of the base charge) for maintenance (which gives you access to support, upgrades, etc.) There is no usage charge for Information Server or for any of its component products. Other products from I...

Check that the file has more than two lines before even attempting to process it. Add a reject link to the Sequential File stage to handle attempt to read empty file (that does not match metadata).

Welcome aboard.

"First line is column names" is incompatible with reading multiple files. You could, of course, use a Filter command to ignore the first line of each file before streaming the resulting lines into your job design.

Sequence.

Execute Command activity to read the file, with a custom trigger based on the command's output leading to a Notification or Routine activity.

Review just the errors (marked with ##E). Your answer is there.

My guess is that D_CRT is not nullable and has no default value, so that when an upsert statement (particularly an insert statement) affects it, null is attempted to be used as the default value, which is illegal.

You've illegally specified one or more identifier names containing more than 30 characters, directly or indirectly. Note that it may be in a different table, for example the Teradata sync table.

... but does not necessarily delete the third row from the table.

Even if it doesn't annoy moderators, it will definitely annoy me!

It may be more beneficial to search for part or all of the exact error message.

This requires a classic fork-join design (though, once you're on version 8.5, you may be able to use looping constructs in the Transformer stage).
One side of the fork (Copy stage) leads to an Aggregator stage that performs the required calculation. The two streams are then united using a Join stage.