Two Simultaneous SQL Query Problem !!

[Luckyman1]

Hi, I'm doing SQL in Informix but I have a problem.

I want to commit both of these SQL updates, on two separate tables, with one query. Both SQL updates, using Bea workshop weblogic, in jcx, work individually but not together.

So how can I use these together? I’ve spent lot of time and cant figure solution. Thanks here it is that I want to happen together, one query.

UPDATE trn_question_dtl
SET question_desc = "What is counselor"
WHERE question_nbr = 3

UPDATE training_Question
SET question_type_code = 04
WHERE question_nbr = 3

 

[mrdenny]

Wrap them within a transaction.

I haven't looked at Informix in years, but I think it's just the standard begin transaction commit transaction statements.

BEGIN TRANSACTION
UPDATE trn_question_dtl
SET question_desc = "What is counselor"
WHERE question_nbr = 3

UPDATE training_Question
SET question_type_code = 04
WHERE question_nbr = 3
COMMIT TRANSACTION

That will commit them at the same time.

Denny

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

(My very old site)

 

[swampBoogie]

BEGIN TRANSACTION

That's not standard SQL.

start

is