Re: How to get the current sid !
Mahesh G schrieb in Nachricht <6l5nnl$8ms$1@schbbs.mot.com>...
>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
>
>
Here is another one without V. > 7.2
Run this SQL-Statments immediately after your DB-Connect !
select sid from sysmaster:syssessions
where connected = (
select max ( connected) from sysmaster:syssessions
);
or better
select sid from sysmaster:syssessions
where connected = (
select max ( connected) from sysmaster:syssessions
where username = "USERNAME"
);
I think it will work's fine.