DSXchange

Thanks Guys for the replies. I have .csv file only so i can put it out on Unix and can read it in my source file as an sequential file. However it is going to be a problem if that has comma or semi colen as a data. I am just going to seperate by tab. I will check the document chapter 4 for the detai...

How can i convert data from Excel sheet (.csv file) to XML output? Has anybody done this before? If so can you share details on what stages you used and how you specified your XML tags etc. I appreciate your help.

Thanks

Thanks all for the reply. We are on 7.1 version so I think I will wait for 7.5 before I could use parameters in Notification activity.

Thanks again.
V

kduke wrote:It works.

Can you explain how it works ? I have not been successful with that so far.

Hi I am using notification activity at the end of my sequencer to send email. I do not want to hard code my mail server and email address as it may change. I thought that I could create a parameter in sequencer properties and put that in the mail server name and email address. For e.g. #Mail_Server#...

Thanks kcbland and Ray. I thought that the routine is the only way but then i thought may be there is a way and I don't know. So i asked here and you guys confirmed that that is the best way. I will go ahead with routines only. Again thanks for your help.

I am reading a data from DB2 and need to put into Oracle. My design is DB2 ->Transform Stage -> Oracle. Once i read the data from DB2 I need to remove certain words from the row. For e.g. Let's say I have following rows. 1. XYZ Fund. 2. XYZ Variable Life Insurance Fund. 3. XYZ Variable Income fund. ...