How to merge DB Queries to one xml (Part) out put?

Posted by Admin on 10-Aug-2010 16:37

I have few tables say for examples Employee, Department and Salgrade. I am using 3 queries to fetch data and getting 3 different parts. I wanted to do it in parallel. I wanted to merg these data(s) into one XML file. Please let me know how to develop java script to merg the data from 3 parallel quires.


I could able to do it sequentionally but I wanted it parally.


I go through the parallel and for each examples they did not help me with my example.

Each query result part will be as follows.

JOIN_Employee

JOIN_Depatment

JOIN_Salgrade



Thanks in advance.


Regards,


Swaroop Kunduru.

All Replies

Posted by Peter Judge on 11-Aug-2010 07:30

The easiest might be to have a prodataset with the Employee, Department and Salgrade tables in it. Populate them with one or more queries, and call WRITE-XML() or WRITE-JSON() (depending on version). This code is, of course, in ABL, and not JavaScript.

-- peter

Posted by Admin on 11-Aug-2010 14:17

The above example I took for figuring out to deal with parallel process. The queries are complex and may need further process after query. I could not get an Idea how to append the result XML to one XQMessage. If in sequentional order just add part by name but in parallel process i am still lost. Any Idea?

Regards,

Swaroop Kunduru.

This thread is closed