DSXchange: DataStage and IBM Websphere Data Integration Forum
Search found 12 matches
Author Message
Resolved
 Topic: Replace Strings in a text file
sandhya.budhi

Replies: 14
Views: 739

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Wed May 09, 2018 1:00 pm   Subject: Replace Strings in a text file
Hi Frank,

I removed the control characters and everything worked well. Using the Field Mark in the user variable stage and data is passed correctly. Thanks for all your valuable comments and help.
Resolved
 Topic: Replace Strings in a text file
sandhya.budhi

Replies: 14
Views: 739

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Wed May 02, 2018 10:18 pm   Subject: Replace Strings in a text file
Hi Frank,

Thanks for your comments. I designed my job in the below steps

1. Extract the values thats needs to be substituted in the JCL text file
PLID, PLDSN, PLDATE
2. Start loop
In the loo ...
Resolved
 Topic: Replace Strings in a text file
sandhya.budhi

Replies: 14
Views: 739

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Mon Apr 30, 2018 6:56 pm   Subject: Replace Strings in a text file
I discussed with my architect and said the process will be complicated when using datastage to replace multiple values in a file. But he said to give it a try using Routines in datastage.

I was tr ...
Resolved
 Topic: Replace Strings in a text file
sandhya.budhi

Replies: 14
Views: 739

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Wed Apr 25, 2018 9:05 pm   Subject: Replace Strings in a text file
DataStage® Release: 11x
Job Type: Parallel
OS: Unix
I have a requirement where I have to replace a string with another string in a text file. The string appears in different lines in the text file. I need to replace it in every occurance in the file. ...
 Topic: Import Issues from one region to another
sandhya.budhi

Replies: 2
Views: 207

PostForum: General   Posted: Wed Mar 28, 2018 12:35 pm   Subject: Import Issues from one region to another
DataStage® Release: 11x
Job Type: Parallel
OS: Unix
Additional info: Sequence Job
I am trying to import datastage sequence from one environment to another and it is giving an error when I do the same.

"Not Attached to a job"


After the import when I try to open the sequence ...
 Topic: The REST step found a large input data item
sandhya.budhi

Replies: 2
Views: 587

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Fri Jan 05, 2018 4:11 pm   Subject: The REST step found a large input data item
DataStage® Release: 11x
Job Type: Parallel
OS: Unix
I have a similar issue [url=http://www.dsxchange.com/viewtopic.php?t=156918]to this post when I am trying to make a REST call with 7k records. The data don't have any key and I have to process in the ...
 Topic: Creating JSON Schema from JSON data
sandhya.budhi

Replies: 5
Views: 1058

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Thu Dec 28, 2017 12:53 pm   Subject: Creating JSON Schema from JSON data
I tried logs settings at stage level but it is not capturing the logs as expected. I reached my support team and they are checking at their end. But I worked on the error and I received response back ...
 Topic: Creating JSON Schema from JSON data
sandhya.budhi

Replies: 5
Views: 1058

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Fri Dec 15, 2017 3:59 pm   Subject: Creating JSON Schema from JSON data
Thanks for the response. I managed to get the JSON schema correct for JSON payload.

Is there any way I can verify the REST call made through Heirarchical stage and how it passes the arguments to RE ...
 Topic: Creating JSON Schema from JSON data
sandhya.budhi

Replies: 5
Views: 1058

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Thu Dec 14, 2017 4:42 pm   Subject: Creating JSON Schema from JSON data
DataStage® Release: 11x
Job Type: Parallel
OS: Unix
I wanted to do a REST call using a JSON file. The REST call should be made using the below JSON payload

"Queue":[
{
"YYYYYYYY",
"AA",
...
 Topic: Webservice call from datastage
sandhya.budhi

Replies: 4
Views: 765

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Fri Nov 17, 2017 9:12 am   Subject: Webservice call from datastage
I am using Hierarchical stage for create REST calls using JSON payload. I need to create a JSON file before doing a REST call. In the Hierarchical stage we have JSON composer which creates the JSON fi ...
 Topic: Webservice call from datastage
sandhya.budhi

Replies: 4
Views: 765

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Wed Nov 15, 2017 2:04 pm   Subject: Webservice call from datastage
Hi eostic,

The datastage version is 11.3 and I think REST is supported in the Hierarchical stage. I will try using it. Thanks
 Topic: Webservice call from datastage
sandhya.budhi

Replies: 4
Views: 765

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Wed Nov 15, 2017 12:48 pm   Subject: Webservice call from datastage
DataStage® Release: 11x
Job Type: Parallel
OS: Unix
Hi,

I am looking for some guidance to invoke a JSON web service call using WST stage. The existing DS job calls an XML web service (SOAP) to push items onto the SharePoint hosted queue. The Job has ...
 

 Jump to:   



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