Thread: AW: GET DIAGNOSTICS (was Re: Open 7.1 items)

AW: GET DIAGNOSTICS (was Re: Open 7.1 items)

From
Zeugswetter Andreas SB
Date:
> 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