DSXchange

Hi All, I am having a strange issue with my main sequence which was running fine before suddenly started aborting at different points whenever restarted. At some point I get error/warnings like SEQ_dev_tables..JobControl (@Account_Detail): Job SEQ_Accnt_summary.Account_Detail did not finish OK, stat...

It was simple.......my bad

Craig I just need the 6. I dont need any substring I just want the position of second '_' from right hand side.

It is giving 5 now instead of 6.

Thanks Craig and sainath for your suggestions. Let me elaborate my requirement If my data contains the value "ABC 12345_10_19" then I want the location of second '_' from right hand side which will be 6. When I use the code provided by craig it is givinig me the occurance of second '_' fro...

Yes I tried running with single node but still the same issue.

Yes Craig I just need the second occurance location of the substring but counting from right side, currently its giving me the location counting from left hand side. Is there any way i can make index read the string from right hand side and get me the location of the second occurance of the substrin...

I just tried INDEX and it worked good.

In one of my scenario I want to read the data from right side and get the location of the substring. I tried with Right() but it dint work.

Datastage and oracle are on same server.

I am not sure but i tried using nolock in my query but it dint work.

I want to get the location of a substring in a string in datastage just like INSTR() in sql.

I tried playing with some functions in datastage transformer but nothing helped.

Any help will be appreciated.

I am running a job with two Oracle stages where it extracts the Key of table A and in second stage deletes some record from table A based on some conditions. In the target I am using user define query for delete rows. like DELETE FROM TABLE A where KEY in (........ The job starts fine and it even de...

Yes Mike you were right. Its working fine now after using root.

Thanks a lot for your help Mike.

How does the rescheduling of sequence work in director after the sequence is edited? I had one scheduled sequence in production, we made some changes in development and deployed the new version to production replacing the old one but we didn't reschedule it. Now when it ran on scheduled time it proc...

Thank Mike.

We did restart on Development server and its working fine now, but doing the same on production server gave some file permission issues though we used dsadm userid

I found out that it was rebooted yesterday and this issue is in effect after that.