On 09-Aug-2014 11:49 -0500, DeLong, Eric wrote:
Going from memory, but I think there's an SQL stored proc (maybe a
udtf?) in qsys2 named tcpip_info or something like...

I think a select * from qsys2/tcpip_info gets you a row of
connection details.

The above SELECT is a correct syntax; correct, because the name TCPIP_INFO identifies a VIEW rather than a SQL routine, neither as a UDF nor as a Stored Procedure.

IBM i Technology Updates ->‎ IBM i Technology Updates ->‎ DB2 for i - Technology Updates ->‎ DB2 for i - Services ->‎ QSYS2.TCPIP_INFO view
" The TCPIP_INFO view contains TCP/IP information for the current host connection.

Note: this support does not cover when TELNET is used to form the connection

The following table describes the columns in the view. The schema is QSYS2

Table 1. TCPIP_INFO view


Had the object name been a User Defined (Table) Function (UDTF), then the table-reference in the FROM clause might be specified in the SELECT as such:

Had the object name been a Procedure [routine; e.g. producing a result set] then the invocation would not be a SELECT, but a CALL:

Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2015 by MIDRANGE dot COM and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available here. If you have questions about this, please contact