How Do You Run an Update Statement in DB2?

rockdave35 · #1 (**permalink**) 09-02-09, 16:43

I've only done this in SQL, and not even show my code is right for SQL. I'm trying to wipe out value in a field so it is empty. I wrote this:

Code:


BEGIN TRANSACTION
update DSNP.PR01_T_USER_TRAN
set user_q_cd = NUll
where user_id_cd = 3881
and user_tran_cd = 'PR41'
ROLLBACK TRANSACTION

Does this look right? It fails with an error

An EXECUTE IMMEDIATE statement contains a SELECT or VALUES statement.

Thanks.

aflorin27 · #2 (**permalink**) 09-03-09, 03:13

Your code looks like MS SQL Server, because:
BEGIN TRANSACTION does not exist in DB2 (as DB2 automatically starts a transaction when it has to)
ROLLBACK TRANSACTION is not a valid DB2 statement - DB2 has ROLLBACK

Internet Services

Web Development

Digital Marketing

Consumer Tech