DSXchange

Thank you Ernie. Your blog helped me a lot in getting to where I am now. I got it working in serial too.

I tried all you had mentioned and and it still did not work.

Then... I force compiled the job. Now it works!

Hello, I have been trying to process an XML file with a varying degree of success (mostly failure). I have managed to create the following parallel job which works fine: sequential file -> xml input -> sequential file. I used Record type=implicit and Delimiter=none in the sequential file stage to re...

Hi Ray,
Thanks a lot for the suggestion. It works fine.

Hi, I have been trying to put in validation checks for a few decimal fields. I saw in one of the forums (http://www.dsxchange.com/viewtopic.php?t=125952&highlight=for+schema+type+%5C%22decimal%5C%22) that IsValid("Decimal"...) will give the following warning if the number has no precis...

I had the same issue and did not find (for a change) anything else on this on dsxchange.

I had this problem when I tried to do a type conversion on a field after dividing it with zero. A business user entered 0 as the USD GBP exchange rate

It uses both...
dsjob -run -jobstatus -wait ...

We are trying to run a sequence from shell script. It seems to be running fine from development environment but in UAT, the script is exiting with the return code 127. I have never seen this before and not sure what this means. I think it is an issue with wrong parameters but was curious what the er...

Hi,
Please could you tell me what does the dsjob return code 127 stand for?


Thanks,
Rager

chulett wrote:You can also script the same thing using dsjob from the command line. FYI. ...

Cool thanks Craig. This is exactly what I was looking for.

dsjob -linkinfo Project_Name Job_Name Stage_Name Link_Name

Apologies for getting all panicky and jumping the gun before I have read the company guideline.

Guideline states that MQ plugin is a seperate install per project.

Apologies!

Hi,
The MQ stage is missing from one project (not present in Customization -> Customize -> Default Palette Groups and shortcut Items). It is present in all the other projects on the same machine.

Could you please tell me how to add it to this particular project?

Thanks,

Hi,
I am getting the following warning in the aggregator stage.

Aggregator_128,1: Hash table has grown to 16384 entries.


I tried searching the forum could not find anything.

Any leads please?

Thanks,

I raised a case with IBM and they have just confirmed the same.

Thanks for your responses.

I raised a case with IBM and they have just confirmed the same.

You would only be able to read this file successfully, without errors, if the you know the length of the empno and deptno field and it is fixed.
I would suggest changing the format of the file.