DSXchange

This is the parallel forum. You can create your own Custom stage to invoke NDM. Go for it!

Small correction.

To create a pointer to a hashed file in a directory you need SETFILE (without a dot), not SET.FILE. SET.FILE is a different command.

Why not use an Exception Handler in the sequence to trigger a Notification activity?

Chances are that there's more than one Registry entry that needs to be removed. DataStage has always been profligate in its use of the Registry.

Have you searched the forum for "2 2"? From memory this is either "cannot create shared memory segment" (meaning that SHMMAX or one of the other shared memory kernel parameters is too small, or that you've configured structures too large in uvconfig) or that your license has expired. I don't have DS...

Just intercept the job status and feed either 0 or a non-zero value to the exit command in your script.

arsheshadri wrote:Now I have to manage the jobs in unix by writing some shell scripts.

Why? Your three questions indicate that you lack fundamental understanding of how DataStage works and/or that you have not read the documentation for dsjob in the manual. May I suggest you find and attend a training class?

If I m using BigInt or Integer(64) The preecing zeros seems to dissapear for Numeric field. Leading zeroes are not relevant for integer data types. Your original question made no mention of any need to preserve leading zeroes. You can add leading zeroes later, but I can not think of any way to pres...

Is this a parallel job question or a TX question?

Is it for server (as suggested by Oconv) or parallel (as designated in the original post), or is it actually a TX question?

I don't worry about targets in that way. I'll just go on responding to posts. Maybe I'll count the actual per-day figure. But I can't see 3000 in six months being likely, even with the popularity of the DSXchange.

Off the top of my head: FUNCTION DayOfMonth(Year, Month, Day, WhichOne) Ans = @NULL DayList = "SUNDAY|MONDAY|TUESDAY|WEDNESDAY|THURSDAY|FRIDAY|SATURDAY" Convert "|" To @FM In DayList Msg = "" * Calculate date of first of month MonthFirst = Iconv(Year : "...

The dot may not actually be there. It may be an artifact of the data browser. Does the dot get through to your target? If so, convert its data type to int64 or uint64 and the dot will vanish.

It depends on what's in the file. A Sequential File stage may be enough, otherwise a Complex Flat File stage can manage almost anything a mainframe application can generate.

Manager client.