DSXchange

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?

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...

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...

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...

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 ...

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.

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...

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 ...

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...

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...

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...

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 to REST call though not successful. Waiting for the support tream to get back on the logs.

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...

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...

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...