Re: Can someone please help "tune" this script?

From: mgumbs <mgumbsNOmgSPAM_at_hotmail.com.invalid>
Date: 2000/04/13
Message-ID: <092c7bb0.ae4003d6@usw-ex0106-047.remarq.com>#1/1

you could try creating a pl/sqll loop to do it for you like below (needs editing to your requirements)

DECLARE    CURSOR c1 IS

      SELECT 	<primary key>, b.charged$, b.remit,
		b.batch, b.paid_weight, b.audit_reason_code
      FROM frt.mpay_working
      WHERE ?????;

BEGIN
   FOR rec IN c1 LOOP

     UPDATE frt.freight
     SET charged$ = rec.charged$,
         remit = rec.remit,
         batch = rec.batch,
         paid_weight = rec.paid_weight,
         audit_reason_code = rec.audit_reason_code
     WHERE <primary key> = rec.<primary key>;

     COMMIT;

   END LOOP;
END; HTH M

• Sent from RemarQ http://www.remarq.com The Internet's Discussion Network * The fastest and easiest way to search and participate in Usenet - Free!

Received on Thu Apr 13 2000 - 00:00:00 CDT