Jean-Gerard, > The listing 2 example: > 1 SELECT D_TAX, D_NEXT_O_ID > 2 INTO :dist_tax , :next_o_id > 3 FROM OLD TABLE ( UPDATE DISTRICT > 4 SET D_NEXT_O_ID = D_NEXT_O_ID + 1 > 5 WHERE D_W_ID = :w_id > 6 AND D_ID = :d_id > 7 ) AS OT
A lot of this is non-standard SQL, so I can't really tell what DB2 is doing here. Can you explain it? -- --Josh Josh Berkus Aglio Database Solutions San Francisco ---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings