DSXchange

HI Rodriguez,

I tried with functions like AsInteger(), AsFloat() and AsDouble(). Nothing is working as they expect numeric string But we have arithmetic operators in the input string given to above functions.

No..it varies..Somewhere we have one operator and somewhere it's more than one..max no of operator is 5.

Thanks a lot, qt_ky. If i need to evaluate multiple columns having arithmetic expressions then do i need to use that many no of external filter stages?

HI Chulett, Thanks for your response. Actaully we are getting 30k records on a daily basis and there are 20 fields like this which we need to evaluate..

HI All,

I have an input column which holds arithmetic expressions e.g. [(20*5)+9], [(30/5)+4]. I need to evaluate them and send the final value to target system. Any way to achieve this ?

But my ultimate aim is to run the OshScript generated by datastage to extract the desired output. Give. It. Up. :roll: I know you couldn't read all of Ray's response but you are basically wasting your time. Just run the dang job. Yes, Finally i could able to run the osh script with desired output.....

ArndW wrote:You need to give an absolute path to the OshScript.osh ...

OshScript.osh is present in current directory from where i am executing the OshExecuter.sh script. So no need to give absolute path...Only name of the script is suffice.

export LIBPATH=$APT_ORHHOME/lib:$LIBPATH should be export LIBPATH=$APT_ORCHHOME/lib:$LIBPATH ... Arndw, At last i am able to run orchadmin check command.. But my ultimate aim is to run the OshScript generated by datastage to extract the desired output.. Now i am executing the following command to r...

ArndW wrote:

goutam wrote:export LIBPATH=$APT_ORHHOME/lib:$LIBPATH

should be

Code: Select all

export LIBPATH=$APT_ORCHHOME/lib:$LIBPATH 

...

..sorry it's a typo error while replying the post...Actually i am executing correct command i.e LIBPATH=$APT_ORCHHOME/lib:$LIBPATH

source the $DSHOME/dsenv script and the libraries will be set up correctly to execute the orchestrate commands. ... Arndw, I have followed the below steps before executing any orchestarte command.. . /IBM/InformationServer/Server/DSEngine/dsenv export PATH=$PATH:$APT_ORCHHOME/bin export LIBPATH=$AP...

I guess, one can see the real performance diff betwen 1 node and 2 node if lookup stage will be replaced by join stage.

In current situation , most of the execution time is spent on lookup stage , no matter which config file is used...

Can you run "orchadmin check" after executing the dsenv file? ... Arndw, no, i could not run "orchadmin check" after executing dsenv file. it is showing the following error. exec(): 0509-036 Cannot load program orchadmin because of the following errors: 0509-150 Dependent module...

... and when I said you could run it, I in no way meant to imply it was the right thing to do or that it stood any chance of working correctly. Just, it's a script and scripts can be run "from the UNIX server". Again, as noted - use dsjob. Arndw, I had run the OshExecuter script after set...

Oh, I'm sure it's possible, a script is a script after all and that's where they run. I just don't see the point in worrying too much about it. That was probably how it was all done in the Old Days when Torrent Systems marketed Orchestrate, which is the product Ascential bought that is now the para...

Sorry, I was being somewhat facetious and serious at the same time. You "run the script" by running the job and the job runs the script along with everything else that it does. Why are you thinking you have a need to call just an OSH script? :? No..I am just asking is it possible or not??...