×
The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.
See the Retrieve Thread Attribute (QWTRTVTA) API at
http://publib.boulder.ibm.com/infocenter/iseries/v5r4/topic/apis/qwtrtvta.htm.
In particular look at key 326 - Client IP address - IPv4 or IPv6. The
description of this key field is:
**
*Client IP address - IPv4 or IPv6.* The IPv4 or IPv6 address of the client
for which the specified thread of this server most recently communicated
with over sockets. If this field is requested for a job, the value from the
initial thread of the job will be returned. If a sockets connection has not
been established in the initial thread, this field will be blank. An IPv4
address is expressed in standard dotted-decimal form www.xxx.yyy.zzz (for
example, 130.99.128.1). An IPv6 address always has at least one occurrence
of a colon (':') in the format. Some possible IPv6 address formats would
be: ::x (for example, ::1) or ::w.xxx.y.zzz (for example, ::9.130.4.169).
For further IPv6 examples and explanation, refer to the Usage Notes section
in the Convert IPv4 and IPv6 Addresses Between Text and Binary Form
(inet_pton) API<
http://publib.boulder.ibm.com/infocenter/iseries/v5r4/topic/apis/inet_pton.htm>.
This field is implicitly set by the operating system.
which sounds like what you want. I haven't used this within a stored
procedure so SQL runtime may (or may not) do "something funny" in terms of
your environment.
Bruce Vining
On Mon, Nov 19, 2012 at 7:39 AM, Hockchai Lim <lim.hock-chai@xxxxxxxxxxxxxxx
wrote:
hello all,
I've a stored-procedure that could possibly be called from a remote iseries
(the client). The stored-procedure is an external RPG type
stored-procedure. In the RPG export procedure that the stored-procedure
points to, is there a way to find the client ip?
--
This is the RPG programming on the IBM i / System i (RPG400-L) mailing list
To post a message email: RPG400-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/rpg400-l.
midrange.com
