DSXchange

Here's another question where a Search would have found your answer immediately. I recommend that you do so, then post any specific question that you need to complete your understanding.

What stage types are you using, particularly for reading from Oracle? How exactly have you set it up, in particular read mode and Runtime Column Propagation?

It can NOT be cached unless you have set up public caching (there is a separate manual that describes this), whether or not you have set "lock for update". You should set lock for update, as this sets an exclusive lock for the key that you've just failed to read and which you expect to wri...

Error writing to named pipe most usually occurs because the reader (in your case the DB2 process) either failed to start or could not keep up with the speed at which data were being written to the pipe. Engage your DBA to investigate how this process may be speeded. Otherwise abandon the named pipe ...

Will the country ever be different for the same value of ID?

its very urgent. as mentioned in other posts for the same error ... please reply as soon as possible. DSXchange is not a substitute for your support provider. We don't, indeed can't, do "urgent". We're all volunteers who post as and when we can. If you require urgent assistance, sign up w...

The system variables @INROWNUM and @OUTROWNUM begin from 1 each time the job is run.

If that's not what you want, investigate the SDK key management functions, which use persistent storage of the next available key value.

While that is correct as far as it goes, the If expression is not complete until it has both a Then clause and an Else clause. This is because it is a value-producing expression; it must produce a value whether the test condition is true or false. If there is any possibility that any value in the te...

You can open the log of the main job sequence, and obtain the start times and end times from there. Director includes a Print option under the Project menu and this, in turn, includes a print to file choice. You could then create a simple job to read that file and write the desired information to yo...

It would seem that there's an additional ten characters in the data record that your metadata don't take into account (or 26 based on your "additional info" field). Look at the file using something outside of DataStage, preferably one that has a ruler so it's easy to determine the column n...

Ernie spoke of version 8.1 (not version 8.0.1). They have done a lot of work in version 8.1 to make Metadata Workbench a tool that one would like to use. Version 8.0 (including 8.0.1) is acknowledged to be a bit "flaky".

When's the interview?

The answer from hamzaqk pretty much says it all.

Let me begin by reminding everyone that you do NOT release DataStage locks unless it is safe to do so, usually because the lock is owned by a now-defunct process. The answer to the question is "yes", but precisely how depends on which of the unlocking commands you want to use. I am going t...