Test & Set Instruction

[jmeadows7]

Is there a method of testing a flag within the database and setting the value all within one instruction. I want to create a semaphore so two users don't try to the same logical thing in an applicaiton at the same time. While the likelihood of this actually happening are VERY remote, we all know it will happen at some point.

I know I use to use this a log programming IBM 370 3090 systems with Assembly language - the test and set instruciton.

Thanks,

 

[dbomrrsm]

You can use CASE

syntax:
WHEN A THEN B
WHEN B THEN C

See BOL and put in CASE
DBomrrsm

 

[jmeadows7]

Good Call - forgot all about the good ole case statement
I'll give it a shot!
Thanks!