<div>
What database is this? &nbsp;If it is Oracle9i, you CAN do update and insert in one query. &nbsp;Otherwise, chambers777 is right, you need separate statements.
</div>


What database is this?  If it is Oracle9i, you CAN do update and insert in one query.  Otherwise, chambers777 is right, you need separate statements.

<div>
How about<br />
<br />
if not exists (select * from myTable where id = recordId)<br />
begin insert into myTable values (value1, value2, ....) end<br />
else<br />
begin update myTable set field1=value1 where id = recordId end
</div>


How about

if not exists (select * from myTable where id = recordId)
begin insert into myTable values (value1, value2, ....) end
else
begin update myTable set field1=value1 where id = recordId end

<div>
I get this error:<br />
&nbsp;[IBM][CLI Driver][DB2/6000] SQL0104N &nbsp;An unexpected token &quot;exists&quot; was found following &quot;if not &quot;. &nbsp;Expected tokens may include: &nbsp;&quot;JOIN&quot;. &nbsp;SQLSTATE=42601
</div>


I get this error:
 [IBM][CLI Driver][DB2/6000] SQL0104N  An unexpected token "exists" was found following "if not ".  Expected tokens may include:  "JOIN".  SQLSTATE=42601

<div>
<div class="content wysiwyg-content">
How to do I create a query that will update a record if it exists and insert it if the record does not?<br />
LC
</div>
</div>


How to do I create a query that will update a record if it exists and insert it if the record does not?
LC

QUERY to update if exists and insert otherwise

Databases are organized collections of data, most commonly accessed through management systems including schemas, tables, queries and processes that allow users to enter and manipulate the information or utilize it in other fashions, such as with web applications or for reporting purposes.