DSXchange

Which would mean you would need to apply an offset to your data date in order to get a DataStage Julian date and then you can use the conversion function.

Because the "Julian Date" is not standardized and you posted "55398" as a Julian date but haven't specified what date that is supposed to represent. DataStage PX uses the definition

Parallel Job Developers Guide, p. 62 wrote:A Julian day specifies the date as the number of days from 4713 BCE January 1, 12:00 GMT

Message handlers are stored in {YourPath}\IBM\InformationServer\Server\MsgHandlers and can be copied from one installation to another.

I don't know of any blogs on this rather esoteric subject, but if you search DSXChange you will find many threads that touch upon the differences between Server and Parallel job. By looking at the relevant strengths and weaknesses of the two types of jobs one can easily think of scenarios where one ...

Wasn't there a maintenance mode available as well, or how about just deleting that parameter in the specification? Oracle is the limiting factor here, not DataStage - the "rebuild" option is part of the oracle loader.

This is not a DataStage limitation, but a database one and thus cannot be solved by DataStage.

Is the first character in your file path a "/"? If so, it looks like DataStage is interpreting this file as a statement, not a path. What happens if you put the 1-liner select statement as the "filename"?

With the advent of Version 8 one can use the Websphere web client to identify user client processes quickly and to easily stop them.

Since the sequence is being incremented, your sequence name is being passed correctly as are the connectivity values. For some reason the issue is on the return side, hence my question to you regarding having used sequences before. I can't check right now, but could it be that the surrogate might ne...

What about I would split this derivation into stage variables for efficiency and legibility, though.

There is no corresponding way to do this in server sequential files.

Your assumption that parallel jobs [always] run faster than server jobs is flawed.

No, I haven't seen this type of problem. What is the DB2 datatype of the key and how is it declared in the job? I assume you have no errors or warnings of any type at runtime, is that correct? Have you used the surrogate keys successfully before? Can you try using a flat file as the source in the tr...

I have to admit that I have mixed emotions on this subject. The professional in me shudders to think of the damage caused by documents such as "best practices" being created by neophytes to the product. The consultant in me gloats in the knowledge that activities such as this guarantee my ...

Karthik, the reason for Ray's response and the lack of others is that you've specified a full job sequence design and asked that the forum solve it for you. While the forum exists to help solve problems, the members also want to see that some attempt is made on the part of the poster as well. Take y...