MQSeries.net :: View topic

goldym · Posted: Mon Nov 14, 2005 8:58 am Post subject:

Not sure if this can be done using ESQL but I am trying to prevent duplicate entries into a database. Is it possible to do this in ESQL compare the vaues of incoming data against records in the database. I want to check to see if there is an existing entry into the database for in the incoming dummy message. Currently I insert the ID into IDfield and Date into Datefield into the same record in the database. I want to check incoming to see if an exisitng record has already been inserted for the id and the date. Is it possible to do a select based on two conditions? I think i read in the help that it was not but it was a little unclear to me. I know ESQL syntax below isn't correct but if anyone has any tips?

<Dummy>
<ID>12345</ID>
<Date>11-08-2005</Date>
<Address>509 Parkwood Dr</Address>
</Dummy>

Table

IDFIELD DateFIELD
12345 11-08-2005

ESQL

SET Environment.Variables.ID=InputRoot.XML.Dummy.(XML.Attribute)"ID";
SET Environment.Variables.Date= InputRoot.XML.Dummy.(XML.Attribute)"Date";

IF Select from Database.SRC as T where T.datefield= Environment.Variables.Date and Select from Database.SRC as T where T.idfield= Environment.Variables.ID

Set Environment.Variables.Description = 'Duplicate Message;

ELSE
<do insert>
END If;