DSXchange

Why not use the Surrogate Key stage? The problem with increasing by 1 is that you will generate duplicate key values as soon as you start using more than one processing node. Search the forum for alternatives (driven, for example, by the partition number). In the Enterprise stage change the SQL so t...

Yes. Add any legal form of null handling.

may i know what is RTFM???

Refer to the <<insert participle here>> manual.

You're building another millstone for performance. To be brutal, I don't think you really want to do this, particularly if you're planning to invoke this routine for every row processed in some other job. Use DSGetParamInfo with DSJ.ME as the first argument to interrogate the values of parameters. U...

Import the table definition(s) from DB2 using the plug-in stage. Whatever is imported must be correct. Use that.

The message suggests that "Decimal" is not recognized as a data type in version 1.1 of the stage type - maybe "Numeric" is required instead.

Don't fill in the precision or scale column when the SQL data type is Date.

As a general rule, BASIC functions aren't available efficiently in parallel jobs.

Sure does. When compiling routines for example, a full usage analysis is performed. When retrieving jobs, it should be able to retrieve just the currently selected Category (unless, of course, view categories is disabled in Director) using the CATEGORY index on DS_JOBS. For each job it needs to refe...

Yep

Maybe you need a new contract where you're paid by the hour to wait for these usage analyses!

The most common cause of this error is using a stage variable in row number 1 in a stage variable derivation expression, where the stage variable is not given an initial value. You should always give stage variables an initial value, even if it's just "" or 0 or @FALSE. RT_BP439/JOB.869753927.DT.134...

The 3MB record was a similar but different story - they got the syntax of CREATE.FILE wrong and created the hashed file as static with modulo 1. Yuk. The slow deterioration in performance was a bit of a giveaway. Having ramped up the performance immensely, they wanted us to come back six months late...

These (Funnel and Remove Duplicates) are parallel stage types, not available in server jobs.

That sounds like XP's way of handling an access violation error. You could try re-building the job sequence from scratch, without making the incorrect assignment of a default job parameter value. Not sure why the pointer would run away like that. Did you try clicking CANCEL to debug the program and,...

My guess is that you have a crowded project (lots of jobs, sequences and routines). That is, I agree with your conclusion. Part of compiling or deleting a routine is a complete usage analysis so that you can be warned that other components use the routine. The check has to be done whether or not thi...

By itself that does not give sufficient information, unless one can deduce that someone has killed a process associated with the operator for player 2. You can work out which process this is by examining the generated OSH. Look in the job log for surrounding warning messages. Reset the job in Direct...