DSXchange

I'd say you ran out of space. Where are your 'temp' records going during the sort? You should redirect that out to someplace with plenty o' space, I think that is the -t option - check the man pages.

What kind of values does the routine return? Anything other than a zero is considered to be a failure, so you have to take that fact into account when designing the triggers or error handling.

"here the Target is the same sequential file"----> By that i mean that both the target stages refer to the same Sequentail file. Sorry, still a Bad Idea to have two processes writing to the same sequential file simultaneously, if that is what you are truly doing. Results will be... unpredictable at...

Peoples - please use the Code tags when posting ascii art job designs so they don't all slump over to the left and become even more incomprehensible. That and the 'Preview' option so you know what it will look like after you submit it. Thanks. Can this be done in Single Transformer? Don't see why n...

ArndW wrote:I am not 100% sure that the sequential file is actually closed when you enter the after-job routine; but you will find out soon enough when you test this solution.

It is.

Technically, in the "If your answer is YES" paragraph, what is being described is CDD - Change Data Detection - not CDC. CDC is tightly coupled to the source system and is a process that can capture both both and after images of changed records, inserted records and even deleted records - only sendi...

Nope, sorry.

What does this mean?

I did build a new job like this job and it works, the issue should be resolved as the job is in production and can not import this new job to production.

It sounds like you solved your problem. Why can't you "import this new job to production"?

AHA! Good idea... I tend to forget about those little fellers.

Have you run the job yet? Were records sent down the link to the OCI stage? Have you checked the Director log for this job?

That's the DB2 part. From what I've read on the forum (I'm an 'Oracle Guy') DB2 requires the date to be sent to it in internal format, so that number represents the number of days past some zero point. Search the forum for something like 'DB2' and 'internal'. I know Ken has mentioned this 'gotcha' m...

It's not a "COBOL date format". It's a date, yes. It's from a COBOL program, yes. But it's nothing magical. WS_DATE_CCYYMMDD is just a variable name from Working Storage. It implies that the format of the date would be 8 digits in YYYYMMDD format. The 'CC' just stands for 'Century'. So, as an exampl...

Sure it will - if you tell it to.

There's a -WAIT and a -JOBSTATUS option, depending on what you want passed back when it is done.

This works well but the question I have is to do with the logs in Director; the value being passed out via Ans is non-zero so I get a warning message written to the log. This should mean that you have the 'automatically handle failures' option enabled and a non-zero return from a routine equates to...

Or stop thinking of it as a problem and just think of it as How It Works. I'm not bothered by this behaviour. The important thing is the fact that, when you promote it to other projects, it will have the 'correct' Category associated with it. FYI, you can't delete anything from VC. You can mark it a...

Exactly. With hash files - Metadata Matters.