Search found 13 matches
- Thu Dec 07, 2017 9:32 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Need help to build logic in Transformer / Server Routine
- Replies: 6
- Views: 5666
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...
- Thu Dec 07, 2017 4:37 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Need help to build logic in Transformer / Server Routine
- Replies: 6
- Views: 5666
- Thu Dec 07, 2017 12:33 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Need help to build logic in Transformer / Server Routine
- Replies: 6
- Views: 5666
Need help to build logic in Transformer / Server Routine
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...
- Wed Oct 15, 2014 4:38 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: ABAP Extract Stage Issue
- Replies: 7
- Views: 4874
- Tue Oct 14, 2014 7:33 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: ABAP Extract Stage Issue
- Replies: 7
- Views: 4874
- Tue Oct 14, 2014 6:29 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: ABAP Extract Stage Issue
- Replies: 7
- Views: 4874
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 ...
- Tue Oct 14, 2014 4:13 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: ABAP Extract Stage Issue
- Replies: 7
- Views: 4874
ABAP Extract Stage Issue
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...
- Thu Aug 21, 2014 4:37 am
- Forum: General
- Topic: Directories Created on Project Creation
- Replies: 4
- Views: 2578
Directories Created on Project Creation
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 ...
- Mon Aug 11, 2014 9:41 am
- Forum: General
- Topic: Send mail Error
- Replies: 3
- Views: 3774
Send mail Error
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...
- Wed Jul 30, 2014 8:28 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Error : Unix command for "repUnkownUTF8" + DataSta
- Replies: 6
- Views: 4047
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....
- Tue Jul 29, 2014 8:16 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Error : Unix command for "repUnkownUTF8" + DataSta
- Replies: 6
- Views: 4047
- Tue Jul 29, 2014 1:18 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Error : Unix command for "repUnkownUTF8" + DataSta
- Replies: 6
- Views: 4047
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...
- Mon Jul 28, 2014 5:03 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Error : Unix command for "repUnkownUTF8" + DataSta
- Replies: 6
- Views: 4047
Error : Unix command for "repUnkownUTF8" + DataSta
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...