DSXchange

The most commonly used method, as far as I am aware, is to use a "fork join" - split the data stream into two and, on one of them, count each group. Downstream of that join the count back on to the original rows. You can use the count to determine the duplicates - the rows having the count greater t...

The first two bytes of the magic number can be anything (hexadecimal), particularly if an -itag installation was done. The default up to current versions is, indeed, "acef".

Has anyone thought to switch on Server Side Tracing to see what there is to see?

There is a Search facility in Director. You can also disable the view of categories and sort by job name in Director status view.

Iconv("03307", "D2JY") should convert to internal format. Then use Oconv() to achieve any desired external format. For example:

The problem is not solved, it is only delayed until you want to install your 1000th CPU.

Any career in IT should be predicated upon good communication skills, which includes written communication. We frown, here, upon usage such as "u", "plz" and "waz" when there are correct equivalents such as "you", "please" and "was".

It was a +2 error code (not -2), and it came from the include file for operating system errors (ERRD.H from memory). Never encountered -9 from STATUS() before; it's not in the UniVerse manuals, so maybe it's something Glenn H sneaked into DataStage BASIC. Further research (maybe on DeveloperWorks) i...

Check the log of the job sequence to see whether the Execute Command activity actually executed. What kind of trigger do you have on the Job activity?

If my memory serves, the mandatory argument (the DSX name) should be last on the command line. Try moving the /V switch to a position earlier in the command.

Algorithm design: Find current status ( DSGetJobInfo(hJob, DSJ.JOBSTATUS) ). If "Finished OK" ( DSJS.RUNOK ) then do the remainder. Find start of current run ( DSGetJobInfo(hJob,DSJ.JOBSTARTTIMESTAMP) ). Find newest "job finished" message prior to that timestamp ( EventNo = DSGetNewestLogId(hJob,......

It's a server job, so there are no data types. All you have to do is to count the decimal placeholder characters. Or InLink.TheField Matches "1N0N" would do it. Or Index(InLink.TheField, ".", 1) also. I thought of five other possibilities in about one second, but will leave off for now. Essentially ...

No, if the question is "will MetaStage 7.5.2 work with the version 8.0 repository?", which I believe it was.

Anyway, there's nothing to stop you complying with their request to create an Operator role.

That it can't do anything is not your fault once you've explained the ramifications.

I can't see why the base name alone wouldn't work from a job sequence or from dsjob, but also have not tested it. Released jobs... shudder!!