Selecting multiple columns into variables (in trigger)

dwouters · #1 (**permalink**) 08-21-08, 03:43

Hey,

I'm starting with DB2 triggers and I'm wondering how I can make a select with multiple columns into variables. Here is what I've been doing to select one column:

Code:

declare myVar smallint;
set myVar = (select colA from myTable where ....);

Now what if I want to select the columns colA and colB from myTable into two variables? Do I have to make two selects, or is there a better way?

Thanks

stolze · #2 (**permalink**) 08-21-08, 05:11

You can use this:

Code:

SET ( myVar1, myVar2 ) = ( SELECT colA, colB FROM myTable WHERE ... );

dwouters · #3 (**permalink**) 08-25-08, 03:37

Perfect, thanks!

Internet Services

Web Development

Digital Marketing

Consumer Tech