MQSeries.net :: View topic

sairam1918 · Posted: Thu May 26, 2016 5:24 am Post subject:

Om Sai Ram

hi all,

Input is in XML format in a file.
<Empoyeelist>
<Employee>
<Name>Chandra Sekhar</Name>
<Grade>Developer</Grade>
</Employee>
<Employee>
<Name>raj kumar</Name>
<Grade>Manager</Grade>
</Employee>
<Employee>
<Name>Akash yaram</Name>
<Grade>Manager</Grade>
</Employee>
<Employee>
<Name>Nikita manam</Name>
<Grade>Manager</Grade>
</Employee>
<Employee>
<Name>Manoj Kmumar</Name>
<Grade>Developer</Grade>
</Employee>
<Employee>
<Name>Sai Ram</Name>
<Grade>Manager</Grade>
</Employee>
<Employee>
<Name>Ashish Badal</Name>
<Grade>Developer</Grade>
</Employee>
<Employee>
<Name>Sunil Kumar</Name>
<Grade>Developer</Grade>
</Employee>
<Employee>
<Name>Ravi Kumar</Name>
<Grade>Developer</Grade>
</Employee>
<Employee>
<Name>Suresh Kumar</Name>
<Grade>Developer</Grade>
</Employee>
<Employee>
<Name>Shafi Khan</Name>
<Grade>Developer</Grade>
</Employee>
<Employee>
<Name>Pathikrit Patra</Name>
<Grade>Developer</Grade>
</Employee>
<Employee>
<Name>Karthika Ruby Gopal</Name>
<Grade>Developer</Grade>
</Employee>
<Employee>
<Name>Sarath Parera</Name>
<Grade>Manager</Grade>
</Employee>
<Employee>
<Name>Gayatri Alluri</Name>
<Grade>Developer</Grade>
</Employee>
<Employee>
<Name>Latha Sabbam</Name>
<Grade>Developer</Grade>
</Employee>
<Employee>
<Name>Sravani Uppala</Name>
<Grade>Developer</Grade>
</Employee>
<Employee>
<Name>Priyanka Potala</Name>
<Grade>Developer</Grade>
</Employee>
<Employee>
<Name>Kiranmai Dadi</Name>
<Grade>Developer</Grade>
</Employee>
<Employee>
<Name>Neha Matari</Name>
<Grade>Developer</Grade>
</Employee>
<Employee>
<Name>Hemanth Barate</Name>
<Grade>Developer</Grade>
</Employee>
<Employee>
<Name>Lakan Hake</Name>
<Grade>Developer</Grade>
</Employee>
<Employee>
<Name>Asakthi Panchiyar</Name>
<Grade>Developer</Grade>
</Employee>
<Employee>
<Name>Venkat Rao</Name>
<Grade>Developer</Grade>
</Employee>
<Employee>
<Name>Ahok Kumar</Name>
<Grade>Developer</Grade>
</Employee>
</Empoyeelist>
nodes: Fileinput ,compute and fileoutput

please help me with ESQL code to sort the names in alphabetical order.
Output should be name in alphabetical order along with grade