I referred the values from the Extended ASCII table.
https://www.ascii-code.com/
I have noticed the values were different in some websites. Is there any way I can validate with any other reference?
Search found 17 matches
- Mon Jun 04, 2018 7:28 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Convert Issue - Non printable characters ÿ and ›
- Replies: 7
- Views: 5774
- Thu May 31, 2018 1:40 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: The REST step is unable to invoke the REST service call
- Replies: 6
- Views: 6837
The issue is resolved by enabling the Proxy in the Hierarchical Stage. Also the Enable SSL option is checked along with the Basic Authentication. The REST call is happening fine and success return code is received from call. Basically the issue was with SSL certificate and once we enable it from Dat...
- Thu May 31, 2018 11:26 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: The REST step is unable to invoke the REST service call
- Replies: 6
- Views: 6837
I tried running the datastage job by giving Optional Argument in Hierarchical Stage as -Djavax.net.debug=SSL The logs showed the below message pool-1-thread-3, WRITE: TLSv1 Handshake, length = 121 pool-1-thread-3, handling exception: java.net.SocketException: Connection reset pool-1-thread-3, IOExce...
- Thu May 31, 2018 9:28 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: The REST step is unable to invoke the REST service call
- Replies: 6
- Views: 6837
I did Google Search and I got the details from IBM troubleshooting saying that we need to upgrade DataStage jdk http://www-01.ibm.com/support/docview.wss?uid=swg22008850 That's why I reached my infrastructure team to check any upgrades have done so there is some issues happening when doing a REST ca...
- Thu May 31, 2018 9:10 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: The REST step is unable to invoke the REST service call
- Replies: 6
- Views: 6837
The REST step is unable to invoke the REST service call
The REST call is failing with the error CDIER0961E: The REST step is unable to invoke the RESTservice, cause=javax.net.ssl.SSLPeerUnverifiedException: peer not authenticated The REST call was successful during previous executions and suddenly we started receiving the above error message as response ...
- Wed May 09, 2018 1:00 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Replace Strings in a text file
- Replies: 14
- Views: 8617
- Wed May 02, 2018 10:18 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Replace Strings in a text file
- Replies: 14
- Views: 8617
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 loop process 3.Execute Command for getting the individual values from the file. Used AWK command to read each val...
- Mon Apr 30, 2018 6:56 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Replace Strings in a text file
- Replies: 14
- Views: 8617
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 trying to use the seq and awk commands in the datastage server routine and I am finding difficult to pass ...
- Wed Apr 25, 2018 9:05 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Replace Strings in a text file
- Replies: 14
- Views: 8617
Replace Strings in a text file
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. The text file is a mainframe JCL template. //XXXXXX &PGMCHAR JOB (A1,xx,A123456),'TEST',REGION=0M...
- Wed Mar 28, 2018 12:35 pm
- Forum: General
- Topic: Import Issues from one region to another
- Replies: 2
- Views: 1880
Import Issues from one region to another
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 it is showing the message "This item has no design time information" I thought the seque...
- Fri Jan 05, 2018 4:11 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: The REST step found a large input data item
- Replies: 1
- Views: 3544
The REST step found a large input data item
I have a similar issue 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 same order received from the source. The REST call is failing with the error CDIER0410E: Error in step=REST, cause=com.ibm.e2.provider.ws.exceptions.REST...
- Thu Dec 28, 2017 12:53 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Creating JSON Schema from JSON data
- Replies: 5
- Views: 6467
- Fri Dec 15, 2017 3:59 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Creating JSON Schema from JSON data
- Replies: 5
- Views: 6467
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 REST API like mentioned below PUT https://example.com HTTP/1.1 Authorization: Basic XXXXXXXXXXXXXXX== con...
- Thu Dec 14, 2017 4:42 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Creating JSON Schema from JSON data
- Replies: 5
- Views: 6467
Creating JSON Schema from JSON data
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", "07", "2017-11-14", false, "2017-11-14", 15.2, "YYYYYYY", false, "SPACER", false, &quo...
- Fri Nov 17, 2017 9:12 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Webservice call from datastage
- Replies: 4
- Views: 4548
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 file. My data is not in XML format to feed in JSON composer. The data is stored in the dataset. Do I n...