MQSeries.net :: View topic - About two different files at same value get it and put indb

eejar · Posted: Sat Sep 24, 2011 9:57 am Post subject:

About two different files at same value get it and put in data base tabel.
eg: *.txt file & *.xml file , in these files the message like

name raj rollno 253 lang english - its is text file

<name> raj</name>
<rollno> 253 </rollno> - its is xml file

so in this both tables i want roll no. matches in the both files and insert in the database table like table : rollno., file1 , file2

253 y y

so like this no. of names in txt file like

name raj rollno 253 lang english
name siv rollno 256 lang english
name sap rollno 253 lang english

its in only in one txt file.

tell me how to solve this.

i did it. but i want best solution.