DSXchange

Write mode is usually faster. With the "Upsert" method you need to specify both an update and an insert statement, even if you know that the second will never actually be executed, thus both statements can be identical.

Nothing easier than that - use the "DateFromDaysSince" function as described on page 594 of the Parallel Job Developer Guide

All you need to do is to choose a map which has those characters, i.e. UTF-8 or UniCode to name just 2.

Hello Roy - it is good that you found the cause, could you also mark this thread as "resolved" so that people using search can find it and use your solution?

shobhitj - did you end up trying another tool rather than view data and what was the result. This will bring you further towards a solution than begrudging poor Craig his hard-earned DSXChange points.

Don't use "View Data" with NLS to examine the data for incorrect representation. Use a tool which you know works correctly for the character set(s) that you use.

Look at your OS level acess rights to the object file created by the buildop, probably your new user isn't in the "dstage" group or otherwise has no execute access to the buildop.

Nagaraj - I'm sorry for assuming that it was an interview question; usually people wanting to know such information ask "Can you list some differences between them" rather than "List 5 differences"... I'm sure you see the difference in how it comes across.

BIUser - that wasn't a crude answer at all - very elegant!!!!!

Did you try the "0001-01-01 00:00:01" as Ray suggested and did that work? If yes, then the answer is that you cannot represent "0001-01-01 00:00:00".

What is in your project directory/RT_SC501/ directory? I would recommend (force) recompiling the job and to search around for someone who might have deleted files at the UNIX level.

Nasimul, that is an interesting question - I can't think of an easy way to do this in PX as there are no regular expression functions. The cheap way (which I wouldn't recommend) is to call a BASIC transform where this type of pattern matching can be done easily. Can you specify the rule differently,...

Nagaraj wrote:Can you please list 5 differences between them?

If this is an interview question I am surprised that it is in the list, that is like asking "list 5 differences between compiling COBOL and Java". Any answer answer means nothing towards being able to use either compiler, or either Server / PX.

Can you explain your job design in more detail? The hashed-file lookup ordering should not affect the outcome.

I can understand that the job status shows "running". How did you determine that the job finished successfully? Does this error occasionally happen or always happen?