Symptom
- 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?
Read more...
Environment
SAP IQ 16.0
Product
SAP IQ 16.0
Keywords
ClientNodeAddress, AppInfo, login, procedure , KBA , BC-SYB-IQ , Sybase IQ , How To
About this page
This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.