Oracle Convertion

etobar · #1 (**permalink**) 02-19-04, 10:00

I need to convert this oracle statement "select userenv( 'sessionid' ) from dual" to DB2
Can Anyone help me ?

jsander · #2 (**permalink**) 02-19-04, 10:47

Hi,

you will need to define userenv('sessionid') as a function. Then you can use the values statement:

values userenv('sessionid')

Johann

Quote:

Originally posted by etobar
I need to convert this oracle statement "select userenv( 'sessionid' ) from dual" to DB2
Can Anyone help me ?

etobar · #3 (**permalink**) 02-19-04, 12:04

Hi Johan
i got your message but i need the db2's session number. The oracle function userenv returns many values ( sessionid, userid, ...), and, in this case i need to know the session id, to identify user and comand.

Thanks

jsander · #4 (**permalink**) 02-20-04, 03:15

Hi etobar,

sorry, no can do. With DB2, you have no such thing as a session id that is available from SQL. The special register CURRENT USER is all you can get. You will need to implement the rest in your application.

Johann

Quote:

Originally posted by etobar
Hi Johan
i got your message but i need the db2's session number. The oracle function userenv returns many values ( sessionid, userid, ...), and, in this case i need to know the session id, to identify user and comand.

Thanks

Internet Services

Web Development

Digital Marketing

Consumer Tech