DSXchange

Thank you Craig!! :D

The records drop was due to the extra '/CD' in the XML code. I could get the records properly now. Issue resolved!!

Thank you Craig!! :D

The records drop was due to the extra '/CD' in the XML code. I could get the records properly now. Issue resolved!!

Craig, I tried that also. I used 'ls #Path#/cd_catalog.xml' in the external source stage. In the column content i enabled 'URL path'. But, this also not working. I could get only upto 2 records. If i add one more record to the source XML file, none of the records are getting outputted. My entire XML...

Hi Ernie, I tried using External Source stage. But no luck!! My records are getting dropped if my XML files has more than 2 records. My job design is: ExternalSourceStage --> XML Input --> SequentialFileStage I have set the properties as External Source Stage: Source Method: Specific Programs Source...

Thanks Ernie,

I will test my job with the external source stage now and i will post the results. Infact i never used external source stage.

As of now i need to develop my jobs in DS EE so, i cannot test with a Folder stage.

Thank you-

Hi, While outputting my Xml data, i see few records are getting dropped. My Xml layout is as below: <?xml version="1.0" encoding="ISO-8859-1"?> <!-- Edited with XML Spy v2007 (http://www.altova.com) --> <CATALOG> <CD> <TITLE>Eros</TITLE> <ARTIST>Eros Ramazzotti</ARTIST> <COUNTRY>...

nivas,
can you plese brief your requirement with an example?

you are right.
Can you check if you are enclosing all the parameters with '#'.
Even your password parameter should be enclosed with '#'.

knvbabu,

Did a 'space' resolved your issue. If not please post your resolution for others references.

knvbabu,

Did a 'space' resolved your issue. If not please post your resolution for others references.

pravin1581,

Check the connectivity to DB2 from DS for your user. I guess it is not the problem with the pasword. If it was the problem with the password, the error would be different and moreover, your password would have been locked up by now!!

vrishabhsagar,
You don't need to test the code which i have posted previously. Cause, it will do the same thing as yours.Only difference, is that you are taking the exact length of the prefixed Zeros.
If your issue is solved please mark it as 'Resolved'.

sravanthi, Folder stage doesn't exists in DS EE jobs. It is limited only to the server jobs. deesh, U have to use the XMLInput-->XML Transformer-->XML output If you want to read multiple files you can use the sequencial file stage with 'Read Method= File Pattern' and 'Record Type=implicit' in it. In...

please "search" before post. This was also discussed lot many times.
This could help you:
http://dsxchange.com/viewtopic.php?t=11 ... b2be8fd662

sreddy, As ArndW suggested, please search before you post your issues. :) Based on your warning seems, your target output column is made as decimal(8,5) explicitly, whereas you are trying to pass an integer value. You can cast this field to decimal from the source itself and then pass it through the...