DSXchange

Are you sorting the same keys, and in the same order, as required by (specified in) the Remove Duplicates stage?

One of the fundamental tenets of database operation is that physical storage of rows (and, indeed, of columns) is irrelevant to the end user.

The database management system is sole arbiter of where things are stored.

Don't worry about it.

Changing the permissions on the $DSHOME directory and its subdirectories is only looking for trouble. In most cases it will prevent things from working. For example, there are some files in bin that must be owned by root and have the setuid bit set. There is a script $DSHOME/scripts/DSEresetperms.sh...

Is 1155 the correct port number in your QA environment?

There is no equivalent of dsenv on Windows. You can, of course, set environment variables through the System applet in Control Panel. When you installed DataStage server, did you select the Oracle plug-in stage types? If not, try installing them now using the Package Installer on the server. (In fac...

Lose the job design.

Design it using a job sequence, which you should have done from the outset.

Odd behaviour! Sounds like a bug: there's no good reason to treat it as a literal string. Have you involved your support provider?

Then again, ORCHESTRATE.KEYFLD is not a value - it's a reference to a property. So maybe you do need to build the comparison string upstream.

I suspect that your "lookup failed" rule is set to "Fail" (its default value).

Click on the second tool from the left to open the rules grid. The lookup failed rule is on the right hand end.

Press F1 with that dialog open to get an explanation of what each of the four possible settings does.

When you invoke your ftp script, redirect its output or pipe its output through the tee -acommand.

See Parallel Job Developer's Guide (version 7.5) page 12-7. The section is headed "Handling Special Characters (# and $)".

Kim is going through an avuncular phase.

No more than I threw on the original problem. It seems to be an issue when using the FTP (background) method. I have not investigated any further.

Actually I meant "%dd-%mmm-%2000yy"

See Parallel Job Developer's Guide Appendix A.

My job run fine but end up with this error. What's wrong with this statement? Use the score to determine which operators are involved in this particular combination, or disable combination to determine in which operator the error was reported. This will help you to narrow the focus of your detectiv...

Do you happen to know the eCase number?
If so could you post it here please?