DSXchange

Hi,I have a problem with installing ds6.01 server edition on hp-unix. When i tried to install ds6 server on hp-unix, the following error appears. After stoped other services like SAP BW on this machine, install failed again with the same error message. ...... uvregen: reconfiguration complete, disk ...

Thanks Hulett
I'll try again

I want to change precision of digits lager, so I stop the server, chang the EXACTNUMERIC from 15 to 30 in the uvconfig, uvregen command ,and then restart the server . I check the system using smat -t, the result showed EXACTNUMERIC still 15. Is there something i forget to do ? How to make the number...

We can get process id for routines in Director using clean up resources option. i have done that many times. There are two kind of list form in Jobs Resources window-----"processes" and "locks". click "show all" in locks, you can find all the locked routines and jobs na...

Try show all locks and get the pid# of your routine in job resources window, and then show all processes , find your pid#, log out it.

The Problem solved!! Thanks All!!

i change the command to In DSExecute: it works!!

Michael, you mean you can get the same output in DSExecute as in terminal? My problem is it works well in terminal but not in DSExecute.
Ray, i didn't use "$" in my routine. i used it to explain the shell command in last post . Is the problem of double quotation marks or pipe operator?

sorry, i didn't explain clearly. i know that the output in the Output argument. i using DSLogInfo in my routine call DSLogInfo("*** Output from the command was: ":Output, RoutineName) i got only one blank space in Output. if the command like this : 'echo 9999' ,the Output return "9999...

hi, i want to get the 36 base decimal through the unix shell like bellows, $echo "obase=36;99999999999"|bc in DataStage routine using InputArg = 'echo "obase=36;' InputArg = InputArg : LongNum: '"|bc' Call DSExecute("UNIX",InputArg,Output,SystemReturnCode) But i can not...

I have checked UVTEMP parameter in the uvconfig file. it is /tmp same as the output of the administrator command CONFIG DATA

Thanks Ray

thanks Roy,

i've checked the /tmp, it's 434544 free allocated Kb, and tested only one row from the OracleOci, also got the same error message.

At last we add sequential file stage between transformer and collector, we have a lot of design like this, feel so bad.

I have a job contains Ora9i-----> tansfomer (four output links)======>collector----->sequential file. The job run aborted with the error message as below, ---- CorpCurrAct040915..Link_Collector_MasterData.Attributes: ds_ipcopen() - Error in mmap(/tmp/Sap_Edt.CorpCurrAct040915..Transformer_MasterData...

So kind of Ray.

I've try anothe way using UniChar function, converting 4digits decimal to one unicode , but i don't know how to set the NLS.

If it is impossible to use UniChar in routine, the client wish i can write a routine to do this.

Thanks

Ray, i have tried this way and Dtx(), but DataStage output is Dword(32bit) , so the results are not unique, for example Oconv(2313682943,"MX") the same reult "89E7FFFF", the output loops at interval of 2,147,483,647 * 2. how to generate a Qword(64bit) result. Do i explain clear? ...

Thanks Ray and Roy. Ray, I am sorry for my bad expression. The 13 length target column is character. I've written a routine before ,but i don't know how to large the precision of the number, so it can not handle the larger number bigger than 10digits. How to make it do the 19digits number? FUNCTION ...