DSXchange

It was a limitation(100 MB) the company setup while installing datastage. That was the reason, why the datastage couldnt handle more than 100 MB?
thanks

thanxs.

i saw the thread which was started today. The error still exists. The way the convert function was used in the thread doesnt solve the problem. I tried to look at the tutorials also, couldnt find anything that will replace period to space. The information i am finding is changing hexadecimal to nume...

Hi, I am taking a code from an xml file using xml reader. Then i use a transformer to modify the hexadecimal values. Then load it in the xml writer. From xml writer i send it to the sequential file. Where i load this file back as .xml file with tags. Basically what i want to do is: Get an xml file ,...

what is the correct syntax for convert because if i use
convert(onconv("string",'MCP')) it fails. I tried like this also
convert(onconv("string",'MCP'),' ')

thanks

thanxs for replying. But the company i am working with everyone has a opion that it fails after 100 MB. As i am new to datastage. So is there any other reason like Server capacity or anything else that may be the reason that it fails. Is there any datastage official site which explains the capacity ...

thanxs for replying,
i couldnt find the thread with this information. i am using the oconv functions, it works fine. But it leaves a period. Is there a way to convert a period to a space.
thanks
shivan

Hi,
I am using xslt to divide the big xml file into 6 parts. But is there any way, i can use datastage to divide the xml into 6 parts and then get the data from there and load it in the tables.
thanks
shivan

HI All,
Is there any function in datastage that can be used to search a strange character that is ( ) in a string and then replace it with a space.

thanks
shivan

Hi All,
Does DataStage has a limitation of handling files. Because whenever the feed is more than 100 MB, it fails.

Thanks
shivan

Hi All, I am trying to read an xml file. The way it should read is like that: If the column name is there in the tag and there is no value, then it should consider as an empty string.Where as if there is no column name in the tag, then the value should be taken as null. But in my case, when i am try...

There was an error in the transformer. There was an indicator which sets to N when date is null. In transformer, the coding was "N " instead of "N". Thats why it was giving an error. we are running this job for almost two weeks, never got any error. I think this is the only time ...

The whole row is rejected. It works for other rows. It could be the reason that it may interprets the data in different way. But what should i do now? I need to find its solution, because the job is in production now.

shivan

i tried that, it looks ok in the sequential file. Even i looked at the source data. It looks fine there also. But only in db2, it is reading differently. The way the whole process run is like this. I get the data in xml format, then load it in sql server. Now i m loading the data from sql server to ...

The main problem is:
It is showing extra data on the right side of the date column, and i dont understand from where it is coming from. Because it is not there in the source also.

I hope this helps u