RE: Retrieve source ip address in signin exit program

Something like this?

mysqlstmt = 'SELECT remote_address, remote_port, local_address, local_port, ' +
'COALESCE(authorization_name, '' '' ) ' +
'FROM QSYS2.NETSTAT_JOB_INFO ' +
'where job_name = (' +
'select job_name ' +
'from table(active_job_info(JOB_NAME_FILTER => ''*'')))';

Don't know about performance.....

Api QUSRJOBI with format JOBI0600 will also return the client ipaddress

Best regards

Stefan