DSXchange

Don't hold your breath waiting. Your specification is too vague to give any more than a vague answer, and that has been given. Now create a proper specification; what's in the file, how you plan to read it, what you need to do with its contents, and so on. Post that (in the server forum, not here) a...

If you used Red Brick you could have automatically-maintained aggregate tables. But no, you don't. Are the changes to fully additive facts (totals and counts)? If so, you could update the record with the required delta operation (addition/subtraction). Other than that, unload then reload the summary...

Why do you assume that?

I made it up sitting in an airport lounge. What specific warnings did you get? How did you try to create the routine? Irrespective, if does have some minor errors. Here's a working one. FUNCTION SortList(TheList, TheDelimiter) * Change to undefine to perform unique sort (remove duplicate...

You need a routine. It's not hard; an insert sort will do it. FUNCTION SortList(TheList, Delimiter) * Change to undefine to perform unique sort (remove duplicates). $DEFINE PreserveDuplicates * Validate input arguments. If UnAssigned(TheList) Or UnAssigned(TheDelimiter...

Convert() does not support ranges or octal representation, but you can set up a stage variable containing a string of all the characters to be converted, and a single Convert() function can then be used to replace them with " " from a stage variable containing the same number of space characters as ...

Try it without Char(128) in the mix. Char(128) is (by default) DataStage's internal represntation of NULL, and Microsoft's internal representation of the Euro character. With NLS enabled this is mapped to the private use area. You only need one Convert function. Set up a two stage variables, one con...

Please post the pertinent entries from .odbc.ini and uvodbc.config

It may also be that your DB2 configuration file has something invalid in it.

Execute Command activity to read the file, perhaps using cat command.
Use $CommandOutput activity variable - maybe needing to trim field marks - to supply the job paramter value. Search the forum for details - it's been explained before.

I can not understand your job sequence design. Please wrap it in Code tags, then use Preview to get it right.

With a Data Set (or File Set) you are specifying the name of its control file. This certainly can include job parameter references - it's a regular "pathname". Please note that the name of a Data Set control file must have a suffix of ".ds". Best practice is to allocate a directory (perhaps a subdir...

As you're doing the load perform a lookup against the target (or a copy of same) to determine existence, and set your flag accordingly.

Welcome aboard. Try creating and running a small job to see if the job can access data (the data browser is a different beast).
ODBC -----> Peek

The Char() function requires a decimal argument. Try Char(160).

You need to create an entry in the Routines branch of the Repository - a "new parallel routine". This entry is not actually the routine, it is instructions to DataStage about how and where to find it, the number and types of its arguments (for checking purposes) and so on. Until you have done this, ...