DSXchange

saratha14 - Please read Is there any "best practice" writing a post? which was recommended to you when you joined the forum. Among other things, it touches on the subject of the SEARCH utility. It recommends using search before posting a question, particularly on a subject that you think might have ...

ag_ram, was (1) a question or a statement? Have you thought about taking one of yuor complex jobs and looking into the RT_BPnnn.O directory to confirm or disprove your assumptions? It takes only a couple of minutes to do this. As has been mentioned many times in this thread, you can use the VLIST co...

Check the STATUS() function after an ICONV/OCONV to see if it failed and branch accordingly.

The "@VM" is a "value mark" and is used to store multiple values in a dynamic array (a string). The "<-1>" means "append value to dynamic array", so you would just do a "seq<-1>=resultofaroutine2" to append another value to the seq list.

The two parts of your question have nothing to do with each other. DataStage jobs always need to be explicitly started by one of the standard methods (dsjob.exe, director, scheduler). If you have a job which uses an MQ stage to read messages from a queue it will do so as the messages arrive - but on...

There are no scripts or subroutines or additional include files required in compilation. The compile is very straightforward and converts source routines or programs in the RT_BPnnn into objects in the RT_BPnnn.O there are a large number of routines invoked in order to convert a DataStage job as pre...

Use ICONV on a date using both "DY" to get the year and "DM" to get the numeric month. Do your maths on those 2 numbers and re-convert to a display date using OCONV.

Kumar's suggestion will work for you. It tells Oracle to use that character set as output and it does the NLS translation to UTF8 which is what DataStage would like.
Since you don't have NLS installed in DataStage you cannot use any NLS settings inside the product.

What error did you get when trying "orchadmin cp"? I have it running here with no errors or warnings.

Unfortunately at Version 8 there is one more component, the IIS and it's database, to add to the equation.

Common character sets, i.e. Shift-JIS, have both single and double byte representations of the kana characters. If you want to do this type of conversion it is a simple string manipulation; if you wish to change representations then you have an NLS issue.

I have come to love both RCP and the Bomb.

How about answering the questions first? If you wish to convert from single-byte to double-byte representations within the same character set you will need to use the CONVERT function.

You need to write the truncated output to a 2nd file, then use an after-job routine to call the UNIX "mv -f /path/ext/file2 /path/ext/file1"

Still happens at V8 as well.