DSXchange

I have tried with executable then the problem occurs. But when I took the DSX without executable then it imported properly. I guess it is the problem with the DSX itself.

It hung for almost 45 mins. And I have tried several time by compiling the job and taking DSX and then try to deploy that DSX.I'm taking about only one job here. A single DSX for a single job.

DSX file was not edited and I also tried for several time to compile the job and then take the DSX then deploy.But the same thing happens every time,after certain part of import it got hanged.

I'm importing one DSX(with executable) from one environment to another environment. But the job didn't import,after a particular state it hangs. But when I tried without executable and import then it imports properly. Is there any problem with the DSX itself,but the other job with executable importe...

Extract from queue and stored the xml into a single field in a dataset.Perform this into an single job. You can read the message in delete mode.

Then in next job you can use the dataset for xml parsing and transformation. If any abortion occur in this job then xml will be as it is in the dataset.

You need to parse the XML first by giving the xpath.Then only you will be able to view the XML data

I didn't get your point.Can you explain it briefly

Increase the size of the following two variables to a bigger value
APT_PHYSICAL_DATASET_BLOCK_SIZE,
APT_DEFAULT_TRANSPORT_BLOCK_SIZE

I have a job with the following design. From dataset I have one copy stage and from that copy stage one link goes to aggregator stage and another link goes to rdup stage.Then the output of aggregation of rdup is join.The aggregator keys ,rdup keys and join keys are same.And I have mentioned the part...

Thanks Eric.
I have load the dataset into a DB2 table. But it has loaded as space not as empty.I think it is one kind of issue with dataatsge

prepare a shell script with that query.Put the output of the sql into an variable.And then echo it.Now using a user activity stage in sequence job you can retrieve the result.Now you can pass that as a parameter.Hope this will work.

Is your maximum length of that particular is fixed?

My target datatype is VARCHAR(4).

Hi Ray,

If I write only that field in dataset after trim then one space comes.But if I write any other field along with that field after trim then it comes as empty.I am getting confused in this scenario.

I am facing one peculiar problem.In my source I have fixed length file.In a transformer I have taking out the various fields with proper length. Now let say I have taking out one column and it is space.Now if I apply trim and write only that field in a dataset then one space is there instead of empt...