Translating with DrWatson… this can take a few seconds the first time.
This is a genuine, complex translation. DrWatson protects commands, error codes, and log output while naturally translating the surrounding text. It’s translated once and saved.
Mark D. Stock — — source: Informix-list mailing list archive (1991-1998)
Drazen Kozic wrote:
>
> Server
> OS: SCO OpenServer 5.0.4
> DBMS:IDS 7.1
>
> Client
> MS Windows 95
> MS Access 97
> Informix Cli 2.x
>
> How can I find out the value of serial field of just inserted row. Is there
> something like SQLCA record in I4GL?
Try something like:
SELECT DBINFO('sqlca.sqlerrd1')
FROM systables
WHERE tabid = 1
Or any valid SELECT to return the result of DBINFO.
Hope that helps,
--
Mark.
+----------------------------------------------------------+-----------+
|Mark D. Stock - Informix SA http://www.informix.com |//////// /|
|mailto:mdstock@informix.com http://www.informix.com/idn |///// / //|
|http://www.iiug.org +-----------------------------------+//// / ///|
| Tel: +27 11 807 0313 |If it's slow, the users complain. |/// / ////|
| Fax: +27 838250 2325 |If it's fast, the users keep quiet.|// / /////|
|Cell: +27 83 250 2325 |Therefore, "No news: travels fast"!|/ ////////|
+----------------------+-----------------------------------+-----------+
We use strictly necessary cookies to make this site work. With your
consent we’d also use optional cookies for analytics and marketing. You can accept all,
reject all, or choose. Read our Cookie Policy.