Re: INFORMIX WISH LIST

Jacob Salomon wrote: > > Tim et al, > > here's a couple of feature request I have not seen and which become less > likely to happen as Informix gets deeper into bed with ANSI. But maybe > an ASNI person is reading this... > > I have always felt the SQLCA does not return as much information as it > could. Some items it would like to see added to SQLCA are: > - The ID of the current connection > - The name of the current database > - The statement ID of the statement just executed > - The cursor ID of the most recent FETCH or PUT > - The name of a constraint that was violated The table, column, index or constraint name is in: SQLCA.SQLERRM If the error message denoted by SQLCA.SQLCODE contains the %s for the appropriate name. Cheers, -- Mark. +------------------------------------------------------------------+ |Mark D. Stock - The West Solutions Group http://www.west.co.za | | The Informix FAQ is at http://www.iiug.org | |mailto:marks@west.co.za +-----------------------------------------+ |Tel: +27 11 803 2151 |If it doesn't work, force it! | |Fax: +27 11 803 2189 |If it breaks, it needed replacing anyway!| |Cell: +27 83 250 2325 |Well, that's how I code anyway! | +------------------------+-----------------------------------------+