- Trying to get the IPAddress of a connection using connection_property('NodeAddress') through an event with the type Connect which itself calls a procedure.
- This is the sampe code:
create procedure ipcheck
INSERT INTO ipcheck VALUES (getdate(),SUSER_NAME(), connection_property('NodeAddress'))
create event ipcheck
- This property returns NA if the request that is currently executing is part of an event handler as it is documented in SAP IQ 16.0 SP04 Reference: Building Blocks, Tables, and Procedures > System Functions > Properties Available for the Server> List of connection properties
- How do we get the IPAddress logged through an event?
- Is it possible to put this IPAddress to the .iqmsg file through a message command?
SAP IQ 16.0
ClientNodeAddress, AppInfo, login, procedure , KBA , BC-SYB-IQ , Sybase IQ , How To
About this pageThis is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP ONE Support launchpad (Login required).
Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.