Re: [PERFORM] DB2 feature

2004-12-03 Thread Christopher Browne
Clinging to sanity, [EMAIL PROTECTED] (Pailloncy Jean-Gérard) mumbled into her beard: > I see this article about DB2 > http://www-106.ibm.com/developerworks/db2/library/techarticle/dm > -0411rielau/?ca=dgr-lnxw06SQL-Speed > > The listing 2 example: > 1 SELECT D_TAX, D_NEXT_O_ID > 2 INTO :dist

Re: [PERFORM] DB2 feature

2004-12-03 Thread Pailloncy Jean-Gérard
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

Re: [PERFORM] DB2 feature

2004-12-03 Thread Josh Berkus
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

[PERFORM] DB2 feature

2004-12-03 Thread Pailloncy Jean-Gérard
Hi I see this article about DB2 http://www-106.ibm.com/developerworks/db2/library/techarticle/dm -0411rielau/?ca=dgr-lnxw06SQL-Speed 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_I