I have a question regarding sybase 12.5 capabilities in handling xml data and integration with mail server.
My queries are,
1. How can we read xml data from a file?
2. How can we store the data in xml format?
3. How can we integrate sybase ASE 12.5 with mail server?
Actually our requirement is to read mails from a specified mail box, process them and move the processed mails to different folder in the mail box. The mails will contain the xml data. Our ASE 12.5 servers are located on sunsolaris flavour.
All the above processes has to be scheduled jobs, which will execute once in a day. I want to know the possibilities and work arounds if any for the above.