Re: How to get the current sid !

Posted in 1998

Topics: Storage & Space Management, Stored Procedures & SPL, Platform-Specific Issues

Mahesh G — Thu, 4 Jun 1998 14:32:54 +0530 — source: Informix-list mailing list archive (1991-1998)

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

Related threads

Glossary

dbspace