Sanjeeb Sounds like you already have created a UniVerse file called INV.XML. The D_INV.XML is the file dictionary - that's a binary formatted file that is unreadable. The reason you saw the XML on screen is that it could not create a new Windows file named INV.XML.
Change the INV.XML to something that ISN'T an existing UniVerse file and it should work. Also, since writing that article IBM have added a clause to the SELECT statement to direct the XML to a file without having to use the DIVERT.OUT syntax. This creates a new file named INV.XML in the &XML& directory: SELECT ITEM_CODE, DESCRIPTION FROM INVENTORY.T TOXML ELEMENTS TO 'INV'; Regards, Brian PS Please address these questions to the user list, not to me directly :) > >Hi Brian, > I took the following block of code and executed. > >PA >DIVERT.OUT ON &UFD& INV.XML TTY.OFF >SELECT ITEM_CODE, DESCRIPTION FROM INVENTORY.T TOXML ELEMENTS; >DIVERT.OUT OFF TTY.ON > >After executing it, I am able to see the XML output in the screen. It is >also creating an empty folder "INV.XML" and a file "D_INV.XML" in the >location C:\IBM\UV. When I opened the file "D_INV.XML" it it gave the >following error. > >The XML page cannot be displayed >Cannot view XML input using style sheet. Please correct the error and then >click the Refresh button, or try again later. >--------------------------------------------------------------------------- >An invalid character was found in text content. Error processing resource >'file:///C:/IBM/UV/D_INV.XML'. Line 1, Position 3 > >How do we handle this error ? >Is it storing the output XML inside the file INV.XML. If so then how can I >view that INV.XML file ? > >Sanjeeb >=====-----=====-----===== >Notice: The information contained in this e-mail >message and/or attachments to it may contain >confidential or privileged information. If you are >not the intended recipient, any dissemination, use, >review, distribution, printing or copying of the >information contained in this e-mail message >and/or attachments to it are strictly prohibited. If >you have received this communication in error, >please notify us by reply e-mail or telephone and >immediately and permanently delete the message >and any attachments. Thank you ------- u2-users mailing list [email protected] To unsubscribe please visit http://listserver.u2ug.org/
