DSXchange

If the installation/update was successful you (they) can archive those files with impunity.

What partitioning are you using? No, really using? Unless you can guarantee absolutely even distribution you will always see holes in the sequence. The only way that you can guarantee absolutely even distribution is (a) to specify Round Robin as the partitioning algorithm and (b) to have a number of...

My guess is that you need single quotes around the value TEST_11DEC For example, and assuming that this is a value for the second parameter in the Insert statement (jobname): QueryCmd = "db2 -mv " : "'Insert into STG.JOB_CNTL(CDC_STG_BATCH_ID, JOB_NAME, STATUS) Values ( ":v_Batch...

Add an artificial grouping column that has a constant value.

The name of the function in Modify stage is string_trim() - you can research the rest.

Use a Modify or Transformer stage and use an explicit function to effect the truncation, and the warning should go away.

DataStage detects the exit status. You can generate a fake exit status of 0 to prevent the warning. But... what do you then want DataStage to do in the case that the file does not exist?

Check that your Oracle port (1521) is not blocked by a firewall and that the host machine on which Oracle is running is accepting connections.

It doesn't really matter where it happens, there's just no way to shoehorn seven characters into a Char(5) column.

My guess would be that it happens in DataStage - you could check that easily enough by changing the target (or adding a second target) that is a text file.

Or use Pivot stage and discard the NULLs subsequently.

Can't be done this way. You have to search for each preposition separately. Use Transformer stage looping.

There's a check box in the Notification activity. Uncheck it and the job status report will not be attached.

Make sure all dates have eight characters, so that they match the format string.

Version 9.1 does have Ereplace() function.
In version 8.x you can use Transformer stage looping in conjunction with Index() function to find the location of the string and substring techniques with Upcase() function to build the replacement string.

If you double click on the job sequence name in the Job activity you should be able to access the expression editor. You should then be able to enter "FRED" as a String.