DSXchange

Not sure about exact version, but you can reference to universe user reference in http://www-306.ibm.com/software/data/u2/pubs/library/.

At least you need to rule-set for handling particular language. Thus if you want to handle chinese then rule-set for chinese, thai for rule-set for thai and so on.

Suppose you have one columen specified char (5). The data shoud be like below.
XXXXX/n
but the actual data is XXXXX_..... (_is blank ) so operator find blank rather than /n it shoud be.

What exactly do you want to do against data? Do you want to change code page? Do you want to substring/concatenate data in some fields? What you want to do is just transform, say Field A in source to Field B in target, and suppose your target database is utf-8, non-nls setting seems like work since ...

1. Will I have to increase my field sizes where non-ASCII characters are expected? e.g. if a field is varchar(50) and I expect Chinese characters, do I have to allot atleast 150 bytes for it? I think it depends on DB implementation, some DB specifys length in byte, the other is charactor length. You...

It would be good idea to confirm your environment variable setting is correct by using env command with ExecDos in job before routine.

Oh, yes. Thanks roy,

it is necessary to check at least phantom and dsapi_slave process, are the y all to check?

If above procedure for new licence to update does not work, it is worth to try unix level back-up for the project directory, then installing new DataStage in new box. Next creating a project with same name as previous one, then replace entire project directory wich back-up. I am not sure it always w...

I have got similar message after importing job from the dev box to production box. It is caused by different version of C++ compiler between dev and prod box. After compiling job, it become ok.

It would be good idea to insert check logic for ds process rather than waiting for 30 second. bin/uv -admin -stop (wait 30 seconds) bin/uv -admin -start the above script become like this. bin/uv -admin -stop ps -ef | grep phantom > temp.ps ps -ef | grep dsapi or dsslave >> temp.ps << count the recor...