Re: How to get the current sid !

On Thu, 4 Jun 1998 14:32:54 +0530, "Mahesh G" <ind018@email.mot.com> wrote: >Hi Martin, > >I am using Informix ODS 7.14 on HP-UX 10.01. > >I tried your suggestion, but I got the following error: > >select dbinfo ('sessionid') ># ^ ># 728: Unknown first argument of dbinfo(sessionid). ># >from systables >where tabid = 1 > >Explanation of 728: >-728 Unknown first argument of dbinfo argument-name. > >The valid arguments to the dbinfo() function are the quoted >string `dbspace' followed by the number of a valid >tablespace, or one of the following two values: >`sqlca.sqlerrd1' or `sqlca.sqlerrd2'. Make sure that you have >supplied one of these values, and have enclosed the string >in quotes. > >Any help? Yes, you need to upgrade to do this. 7.14 didn't have the sessionid uption to dbinfo. Nils Myklebust NM Data AS Norway E-mail: Nils.Myklebust@nmdata.com FAQ at: http://www.iiug.org/techinfo/faq/faq_top.html (Now with ODBC info under "Third party products".)