
> We *do* need to support ROW_COUNT, but allowing
> 
>     GET DIAGNOSTICS Select ROW_COUNT, SQLCODE, OID Into :a,:b:,:c;
> 
> is a lot friendlier than the standard:
> 
>     GET DIAGNOSTICS :a = ROW_COUNT;
>     GET DIAGNOSTICS EXCEPTION 1 :b = SQLCODE;
>     GET DIAGNOSTICS :c = OID;
> 
> (not that we even support SQLCODE at this stage).

Informix does:
	GET DIAGNOSTICS :a = ROW_COUNT, EXCEPTION 1 :b = SQLCODE;

separated with comma, don't know if that is standard, but it sure looks more 
like the standard.

Andreas
	

Mon, 19 Feb 2001 11:23:57 +0100
Zeugswetter Andreas SB  <ZeugswetterA@wien.spardat.at>
AW: GET DIAGNOSTICS (was Re: Open 7.1 items)