DSXchange

.... a guy who is IBM consultant gave this suggestion that we should keep the orchestrate definition while reading from Oracle and in the rest of the job divide by 4. And I have recommended otherwise. I am not an IBM consultant, but work often with multi-byte data. Similar behaviour is seen with Or...

The phrase "for u r understand" is not good English on so many levels! We strive for a professional standard of written English here on DSXchange, believing this to be the easiest way to have the most people, even those whose first language is not English, comprehend what is being said.

So you can use a Hashed File stage (or UniVerse stage) if you know the job number. Point the stage at RT_CONFIGnnn (where nnn is the job number), and set up a table definition that supports multi-valued fields (so that you get the Position, Depth and Association columns in the Columns grid). In the ...

I have no idea whatsoever what "virtual concept" means in a DataStage (or even ETL) context.

A Google search did not enlighten me.

Though this quote was amusing:

LEGO Star Wars: The Complete Saga. Reality is just a virtual concept.

Somewhere in your design there is a VarChar(50) - that is, string[max=50]. Be consistent with VarChar(200) throughout to "match" what is in Oracle.

hostname is a command, not an environment variable.

It exists on Windows machines here that do not run DataStage or MKS Toolkit.

What do you mean by "virtualisation" or "virtual concept"?

Does any other version of DataStage support it? If so, please give details, and we'll indicate whether 7.5x2 has the same functionality.

Without writing a routine there is no way you can achieve what you ask in a server job. This is because the Transformer stage executes in a separate process to the job process (which executes the before-job subroutine). You need to "park" the value somewhere - maybe a file, maybe the job's user stat...

Looks like, first, %WINNT_ROOT%\System32 is not in your PATH; System32 is the location of the hostname command. Second, you need to determine what the machine name actually is and/or to create an entry in the hosts file for the machine name. An ipconfig command will tell you which IP address to use....

That's fine, use one of the VarChar fields to test whether the lookup was successful or not. Ideally use a field that is not null in the reference source, so that you can be confident that, if it is null on the output, this is because the lookup failed.

All DataStage jobs run as background processes on the server. Historically the name for a background process is a "phantom". The engine preserves this terminology. You can ignore the word "phantom". You can not, however, ignore the word "error" - something has gone wrong in one of your jobs; look in...

The second approach would not be accurate. On the other hand, there's nothing out of the box that satisfies the requirement. Therefore I recommend that you create a routine that decomposes the dates into year, month and day components and performs the correct arithmetic. That way you can satisfy you...

It is not possible to specify data type Char without a length (precision).

Join stage would seem to be what you need. Either one Join stage with three inputs or two cascaded two-input Join stages. Include a source indicator (such as file name) in a full outer join so that you know from which source the row came.

That depends entirely on what you mean by "performance".