DSXchange: DataStage and IBM Websphere Data Integration Forum
Search found 13 matches
Author Message
Resolved
 Topic: Need help to build logic in Transformer / Server Routine
rinky0707

Replies: 6
Views: 415

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Thu Dec 07, 2017 9:32 am   Subject: Need help to build logic in Transformer / Server Routine
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 ...
Resolved
 Topic: Need help to build logic in Transformer / Server Routine
rinky0707

Replies: 6
Views: 415

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Thu Dec 07, 2017 4:37 am   Subject: Need help to build logic in Transformer / Server Routine
Thank you for your reply.

Thanks & Regards,
Resolved
 Topic: Need help to build logic in Transformer / Server Routine
rinky0707

Replies: 6
Views: 415

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Thu Dec 07, 2017 12:33 am   Subject: Need help to build logic in Transformer / Server Routine
DataStage® Release: 11x
Job Type: Parallel
OS: Unix
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 ever ...
Resolved
 Topic: ABAP Extract Stage Issue
rinky0707

Replies: 7
Views: 2210

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Wed Oct 15, 2014 4:38 am   Subject: ABAP Extract Stage Issue
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. Very Happy Very Happy
Resolved
 Topic: ABAP Extract Stage Issue
rinky0707

Replies: 7
Views: 2210

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Tue Oct 14, 2014 7:33 am   Subject: ABAP Extract Stage Issue
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.
Resolved
 Topic: ABAP Extract Stage Issue
rinky0707

Replies: 7
Views: 2210

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Tue Oct 14, 2014 6:29 am   Subject: ABAP Extract Stage Issue
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 ...
Resolved
 Topic: ABAP Extract Stage Issue
rinky0707

Replies: 7
Views: 2210

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Tue Oct 14, 2014 4:13 am   Subject: ABAP Extract Stage Issue
DataStage® Release: 8x
Job Type: Parallel
OS: Unix
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 t ...
 Topic: Directories Created on Project Creation
rinky0707

Replies: 4
Views: 1098

PostForum: General   Posted: Thu Aug 21, 2014 4:37 am   Subject: Directories Created on Project Creation
DataStage® Release: 8x
Job Type: Parallel
OS: Unix
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_C ...
 Topic: Send mail Error
rinky0707

Replies: 3
Views: 1468

PostForum: General   Posted: Mon Aug 11, 2014 9:41 am   Subject: Send mail Error
DataStage® Release: 8x
Job Type: Parallel
OS: Unix
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 ...
Resolved
 Topic: Error : Unix command for "repUnkownUTF8" + DataSta
rinky0707

Replies: 6
Views: 2058

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Wed Jul 30, 2014 8:28 am   Subject: Error : Unix command for "repUnkownUTF8" + DataSta
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 ...
Resolved
 Topic: Error : Unix command for "repUnkownUTF8" + DataSta
rinky0707

Replies: 6
Views: 2058

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Tue Jul 29, 2014 8:16 am   Subject: Error : Unix command for "repUnkownUTF8" + DataSta
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 repUn ...
Resolved
 Topic: Error : Unix command for "repUnkownUTF8" + DataSta
rinky0707

Replies: 6
Views: 2058

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Tue Jul 29, 2014 1:18 am   Subject: Error : Unix command for "repUnkownUTF8" + DataSta
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 ...
Resolved
 Topic: Error : Unix command for "repUnkownUTF8" + DataSta
rinky0707

Replies: 6
Views: 2058

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Mon Jul 28, 2014 5:03 am   Subject: Error : Unix command for "repUnkownUTF8" + DataSta
DataStage® Release: 8x
Job Type: Parallel
OS: Unix
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 ...
 

 Jump to:   



Powered by phpBB © 2001, 2002 phpBB Group
Theme & Graphics by Daz :: Portal by Smartor
All times are GMT - 6 Hours