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
