DSXchange

Hmm.... If I understand the issue, it would appear to simply be that the first XMLOutput Stage is creating a fully valid and normal document, and then the next XMLOutput Stage is "wrapping it" again inside of another normal document...... If that's the problem, look at the settings in you...

Following is the sample of one of my XML "<?xml version="1.0" encoding="UTF-8" ?>" - <defns:CCP_Trigger xmlns:defns="http://schemas.xyz.com/CCP/Standards/Common/Messaging/CCP_Trigger_v1_0/" xmlns:wsdl="http://schemas.xmlsoap.org/wsdl/" xmlns:soapenc=...

Hi All, I am having a small problem with XML, which after reading all the posts, I am still not able to solve. the problem description is as follows: - I am having data where I need to send a message on MQ. The data is being read from tables then transformed and then it is converted to XML and then ...

1 - No setting exists to change the TRIM behaviour 2 - When reading CHAR fields DataStage performs no modifiction of the data, if you have Char(10) then you will get the 10 character that are in th ... Ok for my first question response, the Trim() function removes the extra spaces in between the st...

Hi All, My question is divided in two parts because of a weird issue: - Problem Desc1: We know that the Trim function on the Char or Varchar fields remove the inbetween extra spaces between two strings for e.g. "ABC DEF" becomes "ABC DEF". The only workaround is to use other vari...

Worst case you could build a lookup with the 20 values to substitute for the last character and do all that while it's still a string. The link I posted showed you that a 'P' would be a -7 as the last digit. You'll probably want to handle the signage separately and multiply the result by -1 for the...

ray.wurlod wrote:Can you please advise the patch number? ...

I'll definitely get back to you after confirming the patch number from my DS admin. I'll post it tomorrow EST.

Ohh Man, Lots of great suggestions here. 1. Well, the field is a char with unicode extended while extracting. after which I make it only char in the transformer. I am not able to remove unicode in extraction OCI stage as it throws warning in DS8.1. But I suspect that this is not the problem. 2. I ca...

chulett wrote:Your linked post shows your answer as well. Not sure what else anyone could add. ...

Good news, IBM came back saying its a bug in Oracle Enterprise stage in DS8.1.

They sent the patch and it worked fine now.

Hi All, I am having a weird problem here: - I am getting a file ftp'ed to the DataStage 8.1 server in binary format. using the cobol copybook I imported the layout. Now when I am trying to view the data, the binary field is coming with "-ve" sign and also the length of the value is more t...

I having a weird problem here, While inserting the data in an Oracle table, the control characters are getting attached with the unique key colum which is having a data type of Char(14). I checked in DS job, instead of inserting it to a table, I populated the data in a File and opened the file in Te...

Hi All, I am having a weird problem here: - I am getting a file ftp'ed to the DataStage 8.1 server in binary format. using the cobol copybook I imported the layout. Now when I am trying to view the data, the binary field is coming with "-ve" sign and also the length of the value is more th...

What O/S? It sounds like you've hit a kernel parameter limit with regards to the number of open files. ... This is not related to th kernel limit for number of files:- Even if I change the ulimit value then as well it gives the problem...as also said here: - http://www.dsxchange.com/viewtopic.php?t...

After going through all the posts in forum. I found out that my issue is with Oracle enterprise stage which was never present in DS8.0. Here is the scenario: - I am using DS 8.1. I am using Oracle Enterprise stage to load the data in target table in Oracle 10g. The problem is the target table has 38...

We have 2 situations in our project where these are causing severe problems. We have DS 8.1. The config file has 3 nodes and all are having different fastnames. When we are running a job havin 5 million records then it is getting aborted by giving an error that says, unable to write on (fd 3), can n...