Re: Stored Procedure Question
On 13 Nov 96 at 22:58, Ron Frank wrote:
> Does anyone know how to get the number of rows affected by an
> update statement executed in a stored procedure from within the
> stored procedure?
This is fragment from my SP:
UPDATE Dealing_payments SET stopped = passed, passed = 0
WHERE payment_id = pay_id
AND passed > 0; LET result = DBINFO( 'sqlca.sqlerrd2' );
It works on OnLine 6.00.UE2, in SCO 3.2v4.2
Best regards,
Julian.
--
Julian S. Zalutsky
MIS, "Brestcombank"
Brest, Republic of Belarus
-- E-mail: julian@martcom.belpak.brest.by