Skip to Content
0
Former Member
May 19, 2010 at 02:54 PM

JDBC receiver SELECT Structure

305 Views

Hi All,

I faced this kind situation when i create the my JDBC SELECT structure statement.

source structure coming from Database.

My source XML structure:

<?xml version="1.0" encoding="utf-8" ?> 
- <ns:POCA0013_SCMDB_REQUESTTOKANLOG_MT xmlns:ns="urn:pg-com:POCA0013:sample">
   <row>
     <DATE>14 Mar 2010</DATE> 
     <PROJECT_ID>IND</PROJECT_ID> 
   </row>
   <row>
      <DATE>14 Mar 2010</DATE> 
      <PROJECT_ID>USA</PROJECT_ID> 
   </row>
   <row>
      <DATE>14 Mar 2010</DATE> 
      <PROJECT_ID>UK</PROJECT_ID> 
   </row>
   <row>
      <DATE>14 Mar 2010</DATE> 
      <PROJECT_ID>GER</PROJECT_ID> 
   </row>
</ns:POCA0013_SCMDB_REQUESTTOKANLOG_MT>

in above structure DATE is same for every row,that means DATE having only one record,in second field having PROJECT_ID is

different for every row,That means i have 4 project's ID.

my target system is also Databases system, my requirement is XI Select the records from target database system based upon condition

the 'Date' filed check to the 3 coloumns in the target table (my condition is Date1>=Date or Date2>=Date or Date3>=Date) and PROJECT_ID is check to the only one coloumn in the same table (conditon is PROJECTIONID = PROJECT_ID)

But PROJECT_ID have four values like IND,USA,UK,GER

Based upon this Source Data,How i can create the SELECT target structure?

i allready created my SELECT using normal condition.But in this situation i am not aware.

Kindly provide your valuble points about this structure.

Thank you very much.

Sateesh

Thank you very much.

Edited by: sateesh kumar .N on May 19, 2010 4:55 PM