Francis,
How to create an XML document from a Retrieve statement is covered in 'Guide to Retrieve' in the section 'Creating an XML document with Reterive'. Can I suggest you read this so that you are aware of all the options available and specifically how to use a XML DTD and a XML Mapping file.
The syntax for the command is as follows.
LIST[DICT|USING[DICT]dictname]filename...[TOXML[ELEMENTS][WITHDTD][WITHSCHEMA|SCHEMAONLY][XMLMAPPINGmapping_file][TOxmlfile]]
If I use a simple version of sending something to a XML file and use the command
LIST CUSTOMER FULLNAME FULLADDR TOXML ELEMENTS TO JDS
Then a record the &XML& directory called JDS.xml is produced as below.
Top of "JDS.xml" in "&XML&", 63 lines, 1,475 characters.
001: <?xml version="1.0" encoding="UTF-8"?>
002: <ROOT>
003: <CUSTOMER>
004: <_ID>2</_ID>
005: <FULLNAME>Ms. Diana Morris</FULLNAME>
006: <FULLADDR>431 Third Ave.</FULLADDR>
007: </CUSTOMER>
008: <CUSTOMER>
009: <_ID>4</_ID>
010: <FULLNAME>Ms. Jill Kahn</FULLNAME>
011: <FULLADDR>12 School St.</FULLADDR>
012: </CUSTOMER>
013: <CUSTOMER>
014: <_ID>6</_ID>
015: <FULLNAME>Ms. Betty Burke</FULLNAME>
016: <FULLADDR>400 Technology Path MS10-27</FULLADDR>
017: </CUSTOMER>
018: <CUSTOMER>
019: <_ID>3</_ID>
020: <FULLNAME>Mr. David Argonne</FULLNAME>
021: <FULLADDR>75 Great Road</FULLADDR>
022: </CUSTOMER>
I again strongly suggest you have a read of the 'Guide to Reterive' and associated manuals to better understanding of the XML capabilites.
------------------------------
Jonathan Smith
UniData ATS and Principal Engineer
Rocket Software
------------------------------
Original Message:
Sent: 04-14-2021 22:03
From: Francis Aquila
Subject: Is there a way I can output to excel in universe retrieve sentence?
Hi Jonathan,
Thanks again.
I have been using TOXML a lot in my reports.
I just need to find how to send the output directly to file as you said.
Thanks alot.
Regards
Francis
------------------------------
Francis Aquila
Core Banking Support Officer
TISA
Papua New Guinea
Original Message:
Sent: 04-14-2021 04:33
From: Jonathan Smith
Subject: Is there a way I can output to excel in universe retrieve sentence?
An simple example of XML is like this
LIST CUSTOMER FULLNAME FULLADDR TOXML
<?xml version="1.0" encoding="UTF-8"?>
<ROOT>
<CUSTOMER _ID = "2" FULLNAME = "Ms. Diana Morris" FULLADDR = "431 Third Ave."/>
<CUSTOMER _ID = "4" FULLNAME = "Ms. Jill Kahn" FULLADDR = "12 School St."/>
<CUSTOMER _ID = "6" FULLNAME = "Ms. Betty Burke" FULLADDR = "400 Technology Path MS10-27"/>
<CUSTOMER _ID = "3" FULLNAME = "Mr. David Argonne" FULLADDR = "75 Great Road"/>
<CUSTOMER _ID = "5" FULLNAME = "Mr. Kenneth Williams" FULLADDR = "837 Ocean Ave."/>
<CUSTOMER _ID = "7" FULLNAME = "Dr. Martha Gill" FULLADDR = "555 Main Street"/>
<CUSTOMER _ID = "10" FULLNAME = "Dr. Andrew McCaig" FULLADDR = "999 Hill Road"/>
<CUSTOMER _ID = "8" FULLNAME = "Mr. Steven Holland" FULLADDR = "4325 Hill Road"/>
<CUSTOMER _ID = "12" FULLNAME = "Mrs. Laurie Patry" FULLADDR = "10 Rustic Trail"/>
<CUSTOMER _ID = "1" FULLNAME = "Mr. Samuel Smith" FULLADDR = "10 Commerical St."/>
<CUSTOMER _ID = "9" FULLNAME = "Ms. Nicole Orlando" FULLADDR = "820 Middlesex Turnpike"/>
<CUSTOMER _ID = "11" FULLNAME = "Mr. Skip Lewis" FULLADDR = "10 Dock Street"/>
</ROOT>
There are more options around xmlmaps and xmlschemas discussed in the manuals along with how to send the output directly to a file.
------------------------------
Jonathan Smith
UniData ATS and Principal Engineer
Rocket Software
Original Message:
Sent: 04-13-2021 22:45
From: Francis Aquila
Subject: Is there a way I can output to excel in universe retrieve sentence?
Hi there,
Our core banking is running on universe 11.2.5 and have written a couple of reports as paragraphs but currently outputting them on screen and to printer using LPTR.
Is there any functions or programs I can send the output straight into excel.
Note I do not want to spool the report. I want as user runs the paragraph or the retrieve sentence it should outputs to excel on the users pc..
Ant help/advise.
Cheers!
------------------------------
Francis Aquila
Core Banking Support Officer
TISA
Papua New Guinea
------------------------------