DSXchange

Thank You

Thank You

How to trim a set of characters from a field. I tried using Trim(Field,"WORD","A"), but it is trimming the first character W.

I need to trim "WORD" from the field.


"ksksWORDWORKWORD"

expected value: 'ksksWORK"

Thanks

you mean, you want all 22 matches in 22 columns of the same record.

you can use a join stage to get all matching records otherwise in the lookup stage use the option return multiple rows from the link you want to get all matches

Our admin raised a ticket with IBM and we are waiting for their reply.

temporarily, we restored the old OSH file in development and everything is working fine. But we donot have a clue how OSH file was changed.

Thank You

Thank You DSGuru, our admin is raising a ticket with IBM. I will update once its been resolved

Travis is also working with us, he doenot know that we had this issue in all the environments. DSGuru can you explore little bit about the files in /bin and /lib of the same parent directory. osh is in /bin osh.o is in /lib osh in bin should refer osh.o in lib right, but osh.o is not changed and it ...

But osh is an executable file, how could this be changed by someone.

I noticed that the same was changed in development at 4:55AM, TEST at 4:57AM and PROD at 5:09 AM.

I believe we cannot change thse executables right.

I noticed that osh changed today morning and we are facing the problems after that. /opt/Ascential/DataStage/PXEngine.751.2/bin]ls -l total 3904 -rwxr-xr-x 1 dsadm dsstage 57646 Mar 22 2005 aptsev2.612 -rwxr-xr-x 1 dsadm dsstage 30262 Mar 22 2005 aptsev2.8.2 -rwxr-xr-x 1 dsadm dsstage 215187 Mar 22 ...

i verified orchsort.o,orchgeneral.o,orchstats.o in lib folder of PXEngine. /opt/Ascential/DataStage/PXEngine.751.2/lib But these were not changed recently. lrwxrwxrwx 1 dsadm dsstage 10 Apr 17 2006 liborchio64aix3.so -> orchio64.o lrwxrwxrwx 1 dsadm dsstage 13 Apr 17 2006 liborchmonitoraix3.so -> or...

We are having the same issue in all the environments, i tried running a different job in development, but we are having the same issue.

we are using AIX server

look like LIBPATH changed. The order changed, but dsenv didnot changed recently. Prior Version : LIBPATH=/opt/Ascential/DataStage/Projects/mercybi/RT_BP2975.O:/opt/Ascential/DataStage/Projects/mercybi/buildop:/opt/Ascential/DataStage/DSCAPIOp:/opt/Ascential/DataStage/RTIOperators:/opt/Ascential/Data...

We have been using PX for the past one year, but this is the first time we are facing this problem. This happened in Prod, i will request our support guy to check $APT_ORCHHOME.