Re: Stored Procedure Update Return?

Posted in 1999

Bashar Chalabi — Thu, 5 Aug 1999 15:12:58 +0100 — source: Informix-list mailing list archive (1991-1998)

DBINFO('sqlca.sqlerrd2') returns the number of rows affected. -- Bashar Chalabi CTL, London Ryan Tanaka wrote in message <0H4q3.278$aY1.8393@client>... >Hi All! > >I'm pretty new to Informix and am looking for a way in a stored procedure, >to find out if an UPDATE statement actually updated any rows (don't really >care how many). > >Is there a way to do this directly in a Stored Procedure? MS SQL Server has >a Rowcount system variable that tells you this info. Any help would be >greatly appreciated. > >Ryan > >