Re: How to get the current sid !

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? Advance thanks. Best regards, Mahesh G. ---------------------------------------------------------------------------- ------------------------ Martin Berns wrote in message <3562E2C8.6DFE36@Materna.De>... >Titanic schrieb: >> >> How can I get the current Informix-session-id within an current >> session ? >> >> We use Informix Online 7.2 > >in SQL: >select dbinfo('sessionid') from informix.systables where tabid = 1; > >in SPL: >LET xyz = dbinfo('sessionid'); > >> >> Thanks >> Rene Kursawe > >hth >martin