DSXchange

No, it is a shell command on both operating systems, it will not work in the DataStage TCL.

Sean, although you've done a great job of describing what is happening, we still need some information on your exact error. You are writing to a hashed file and later on you are reading from it. The other information about stages doesn't affect this. When you write to the hashed file, what is your k...

Have you tried "orchadmin check" from the command line?

Rafidwh,

you don't have a data contents problem, just a representation issue. I don't know where you are displaying these values - the "view data" will not necessarily be correct. The data is loaded correctly into your Oracle database (those decimal conversions, if necessary, are implicit).

Why are you repeating this thread? You already posted this question yesterday in this thread

It would seem that your UNIX script returns a non-standard error code. If you look at your command stage you will see that you have several options with the triggers. You can use and display the "return value" in the triggers to see which code you are actually getting back from your script.

The RTI flag is in column number 82 of the record.

I often just use (In.ColumnName + 0) to force a conversion from string to integer; or you can explicitly use TRIM(In.ColumnName,'0','L') or any number of format statements, such as FMT(In.ColumnName,'Z')

akrzy, this question is far too broad to answer effectively. There are just too many factors involved to make any response useful. Generally it is best to separate the DataStage server machine from the machine that runs the database. A PX configuration is also highly dependant upon both the hardware...

When you have several users working in a project you need to make sure that they belong to the same primary group and you have to ensure that the umask is set correctly. Setting a umask of 002 means that new files created have the protection attributes of 775 set (XOR of value given). I assume that ...

Edwin, how can the issue be urgent if it is working correctly but producing warnings? If you've read any of the previous posts, you will have realized that by using "urgent" you will most likely have delayed getting any quick response. The quickest response will be if you use the forum's search func...

From UNIX, enter the command "orchadmin check"

Your job seems to be calling the DRS plugin, but you haven't installed it.

Ray, thanks for the post, I had already implemented a routine that gets this value from field 8 of the DS_JOBOBJECTS file record "J\{JobNo}\ROOT" (and the RTI switch is at column 82 [originally incorrectly posted as 56] (I think, I'm not at my work monitor now). But the issue is that this an undocum...