Re: Informix JDBC Question

Posted in 1998

Pavel Kazakov — Fri, 10 Jul 1998 12:35:54 -0700 (PDT) — source: Informix-list mailing list archive (1991-1998)

===================== Pavel Kazakov On Fri, 10 Jul 1998, Pavel Kazakov wrote: > > > Vic Siddiqi wrote: > > > Hi all, > > > > I am writing a simple JDBC based application talking with Informix > > database. I have written informix esql based applications in the past > > where I can get the value of a serial field that was generated by > > Informix > > when I did an insert into a column (declared of type seria)l. This was > > done by looking at the sqlcode.sqlerrd variable. > > > > I was wondering if there is something similar in JDBC which will tell me > > > > the auto-generated serial Id?? > > > > Thanks in advance... > > > > Vic > > Hi, > > Fire this "select dbinfo('sqlca.errd1') from table_with_one_row" > and look at ResultSet. > > Regards,Pavel > sorry I saw my mistake think it should be like ResultSet rs=stmt.executeQuery("select dbinfo('sqlca.sqlerr1') from tbl_one_row"); Good luck ,Pavel