DSXchange

Hey Priyadarshi, Thanks a lot. It just worked perfectly. After a little modification in the syntax the below gave the expected substring. left(DSLink42.Col1,Index(DSLink42.Col1,field(trim(convert(convert('1234567890','',DSLink42.Col1),' ',DSLink42.Col1)),' ',1),1)+len(field(trim(convert(convert('123...

Thank you for your reply.

Thanks & Regards,

Hello Everyone, I have a requirement of fetching a substring from a string as mentioned below- If String is ABC101XYZ ; I need subtring ABC101 from this. I need substring after truncating everything that comes after the digits. The input string is of variable length and it is not necessary that firs...

I did some changes like generating the ABAP code again and the job started working fine. Not sure whether the IBM's fix worked or something else. :D :D

ohh Sorry... I missed that.
I run using different dates and every time it returns the same count which is the total count of the tables.

Thanks for the reply SAP Server is on an Intel x86. I just got it checked with SAP guys. Two alternatives to correct the problem: Create a new user defined environment variable called SAPIsOnWin and set it equal to 1 in DataStage Administrator for all projects that connect to the SAP server. OR Add ...

Hi, I have a job in DS 8.1 which is using ABAP Extract Stage as source and outputs it to a Dataset. This job accepts start date and end date as parameters and based on these dates the job returns the records. The job is working as expected. I have got the same job in DS 9.1 but here it always return...

Hi Folks, When I create a new Project in 9.1 environment I see that many directories like RT_CONFIG651 RT_SC35 RT_STATUS83 RT_BP13.O RT_BP555 RT_CONFIG652 RT_SC36 RT_STATUS84 RT_BP14 RT_BP555.O RT_CONFIG653 RT_SC37 RT_STATUS85 RT_BP140 RT_BP556 RT_CONFIG654 RT_SC38 RT_STATUS86 RT_BP140.O RT_BP556.O ...

Hi Folks, I have a very simple Sequence job which use to run fine till a couple of days back. But the same is throwing the below error now. For testing purpose I just checked and the job runs fine if I remove the Notification Activity Stage from the job. sendmail: fatal: parameter inet_interfaces: n...

The issue is resolved. There is a custom parallel stage in repUnkownUTF8 which is getting created in the shared container for replacing specific unicode character-set with an ASCII. Associated files need to be generated through the stage in DataStage and then the files will be created in the server....

Thank for your response Paul. We have a Custom Stage repUnkownUTF8. After exporting the same to new environment as well we get the same error.
Do I need to bring the files that I mentioned like repUnkownUTF8.C from Old ENV to New ENV. If yes, then which file(s)?

Thanks for the reply Ray. I have checked the dsenv files in both the environments and they are similar. Below is what I have. I have compared LD_LIBRARY_PATH as well and they too are similar. I tried searching the file repUnkownUTF8 in both the environments. There are a couple of files in DEV ENV (o...

Hello Everyone, We are migrating the jobs from 8.1 to 9.1. In one applications, the jobs ran fine in Development Environment but after moving them to QA, some specific Jobs are throwing below error - " main_program: PATH search failure: " " main_program: Could not locate operator defi...