Re: Get Diagnostics from Stored Procedure

David Samson wrote: > > Hi All, > > Is it possible to call "GET DIAGNOSTICS" from a stored procedure? I > need to get the error code and the number of rows effected by the > stored proc. > If it is doable, what's the syntax? David, the command GET DIAGNOSTICS is strictly for use in ESQL. However, you shoul whip out you fine manual and look up the SQL built-in function DBINFO() which will give you the exact info you requested, albeit inmultiple calls. Hey, that would would be neat feature - have DBINFO accept multiple parameters and return multiple columns. -- -- Jake (Retrospectively realizes there is no future in hindsight) +------------------------------------------------------------+ | The expedient performance of a task with excessive concern | | regarding its duration-to-completion engenders a virtual | | certainty of diminished benefit therefrom. | | -- Benjamin Franklin (but he said it in 3 words) | +------------------------------------------------------------+