DSXchange

Welcome aboard. Fastest answer is usually obtained via Search (in menu at top) - others have usually encountered any problem, and may even have solved it. You are correct that CLOB is not a data type supported by DataStage; most solutions treat these columns as if they were large VarChar data types.

Not only logic and volume, but also hardware, resources and competing demand.

Overkill. Why not just allow relevant fields to be nullable and test for null? (Tip: test a key column from the outer input for null - it can never genuinely be null in its table because it's a key.)

Internally integers (int32) require four bytes each.

This is one I use at nearly every engagement. So I took the trouble to create a function. It's a server routine (I use it mainly in Routine activities from sequences) but should be able to be adapted readily as a parallel routine. First, the long description: Input Arguments SourceString - String fr...

What is the business rule here? If "2008-04" is a calendar date, what fiscal year is it in? Fiscal year is different between countries, even between companies. That's the main reason it has to be a user-defined function. That said, it's not a difficult one for which to develop the logic.

The REJECTED variables are always set. Take a look at the code generated for the Transformer stage, in the RT_BPnnn directory in the project directory on the server.

Looks like we need that RMM stage back on the enhancement wish list...

"Poor" is a value judgment. The Merge stage has to read two files; it does not have input links.

No, it means you have renamed your StartLoop activity and not re-linked the EndLoop activity to it.

There's a filter, by default set to the most recent 100 entries. Use Ctrl-T to open the filter dialog.

You can not open RT_LOGnnn in Notepad successfully, because RT_LOGnnnn is a directory containing a dynamic hashed file. Nor can you open its subfiles in Notepad successfully.

Use two jobs?

Execute Command -> User Variables -> Start Loop -> whatever -> End Loop Trim the final field mark from the command's output and convert the other field marks to a printable delimiter in the user variable, and use a reference to the user variable in your Start Loop activity as the "list of thing...

Thanks, Ernie

No rush, as I have the information I require from version 8.0 manuals.

The chapter on DataStage Developer Kit (Job Control Interfaces) appears no longer to be in the Server Job Developer's Guide (or in the Parallel Job Advanced Developer's Guide) in version 8.1.

It was there in version 8.0 manuals.

Does anyone know where it is in the 8.1 manual set?