2358586 - How to get the IPAddress logged through an event - SAP IQ 16.0

• 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
as
begin
   INSERT INTO ipcheck VALUES (getdate(),SUSER_NAME(), connection_property('NodeAddress'))
END
go
 
create event ipcheck
type Connect
HANDLER
BEGIN
   Call ipcheck();
END
go

• 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