Problem description & analysis
There is a data table persons in MySQL, as shown below:
There is a data table orders in Oracle, as shown below:
We are trying to list all people and all orders in a corresponding way. Below is the desired result:
Solution
Write the following script p1.dfx in esProc:
Explanation:
A1 Connect to MySQL database.
A2 Get data from persons table.
A3 Connect to Oracle database.
A4 Get data from orders table.
A5 Perform a full join on A2 and A4 by id_p to list all desired data.
Read How to Call an SPL Script in Java to learn how to integrate the script code into a Java program.
Top comments (0)