UPDATE_INSERT action in Receiver JDBC

[Former Member]

Hi All,

I have a requirement where the data comign from a file has to be updated to a JDBC if the record exists or insert a new ecord if the data does not exist

So I have designed the receiver data type as follows :

<?xml version="1.0" encoding="UTF-8"?>

<ns0:MT_FILE_JDBC_TGT xmlns:ns0="urn:test:File">

   <StatementName>

      <dbTableName action="UPDATE_INSERT">

         <table>Table1</table>

         <access>

            <SERVICECODE/>

            <SERVICENAME/>

            <SERVICETYPECODE/>

            <SERVICEGROUPCODE/>

         </access>

         <key>

            <SERVICECODE/>

         </key>

      </dbTableName>

   </StatementName>

</ns0:MT_FILE_JDBC_TGT>

But everytime it is creatign a new row in the table... ther eis no updation of previous record... only insert...

Can u please let me know...

Regards,

Teja

[MichalKrawczyk · Accepted solution]

Hi,

that might mean that update cannot be done so insert is happening (as update is always first with this statement)

can you check the data once more ?

Regards,

Michal Krawczyk

[Former Member · Accepted solution]

Thanks Michael...

There was no constraint on the DB side... so it kept creatign new records every time I sent data...

I went thru all links on sdn... but never gave gave this a thought...

Thanks a ton...