DSXchange

According to you if your input value is 06053FDL7.X.OLD then derivation
Field(UpCase(06053FDL7.X.OLD),".OLD",1) should be 06053FDL7 (as you have mention) but I am getting value 06053FDL7.X as my output and this is what I am excepting

Let me know if any issue with this.

Hi All, Thanks for your valuable input. I think I have resolve this, after doing a long effort I find a simple solution. As I have mention that .OLD will be at the end of the string and can be more then once, so with help of field function I fix this issue. Field(UpCase(input.column_1),".OLD&qu...

Hi, I came to know that the sub-string OLD will appear at the end of the string and it will come with . append to it at front (.OLD) but it can be appear one time or more time. giving you some example 06053FOL7.OLD => 06053FOL7 06053FDL7.X.OLD => 06053FDL7.X 06053FLD7.X.OLD.OLD => 06053FLD7.X 06053F...

Sorry for a late response. I was busy with some production task. Yes, you Guru's are correct and I have also came across some example. So Convert is not going to help me. I think I have to go for the parallel routine pxEreplace(), but which one is question. Can I get a link to the correct version am...

Hi Not sure how it is, but convert seems t be working. I have tried to replace replace string with "" and I can see the changes, looks like correct replacement is happening. .old. old .oldold old. old.old I will keep this issue open for few more days, because I am going to implement this f...

Thanks Ray and Prasson, You are correct Ray convert work basically character replacement function not word. So can not be a option for my case. Ereplace can be but the job is a parallel job and is already running in production, the changes I am doing is a patch to the code and as you know ereplace w...

Hi All, I have around 130 job which writes to table, it may be insert or update. The database is Oracle and in some job I am using Oracle connector stage and in some jobs I am using Oracle Enterprise stage. Now my task is to create a common routine/script which will execute (may be after each job co...

Hi All, Thanks a lot for all your effort and suggestions on my issue. The issue is resolved. Actually it is still not happening for me, however the same job is working fine at my client end. The issue is with accessing datastage. The way I am access datastage (VDI- Virtual Desk top) is different fro...

Hi,

I am doing the same. Now after all unsuccessful try I am creating a fresh jon in my test environment. Once done I will let you know.

Regards

Hi, Yes the same job is working good in Dev, but when I export it from Dev and import it in Test it is not working. I am not testing the job with a separate input file the file from Test and Dev job are same. I have ftped the file from dev to test. Here are few error message from Director. First Fat...

Hi, Last time I have not checked include dependent items check box while exporting, but this time I exported the job with include dependent items but the result is same. you told " If they are both the same release and same fix pack level" . But how I will check whether they are same or no...

Thought to cross verify the dsx, so what I did is; I renamed my original job is dev and import the same dsx that i have created for test. After import I compile the job and ran it in dev and it completed successfully.

What can be the issue. Please help.

Regards,

Hi, This xsd issue is resolved. My client has given me tool (xsd.exe) which is creating the correct XSD fle and my job is now loading the all the records to the target. Now i have another issue, As I said my job is working fine in dev now i have to move the code to test. I exported the job (as i do ...

Hi I have gone to the link, the web link says Download zip http://www.thaiopensource.com/download/ and extract it where you want There are more than one zip file in the directory, is there any specific file that I need to extract or all the zip file. dtdinst-20030619.zip jing-20030619-win32-bin.zip ...

Hi, Thanks for your replay, The XML message I posted here has two records but when i run the xml message with the new XML stage and xsd that i have also posted; it inserts only one record (first one). I did a search in web but not able to understand where I need to add that maxOccurs="unbounded...