Re: Is there a system value that will give me the system name?

On Wed, Jan 24, 2024 at 3:42 PM Jose Perez <joseenocperez.jp@xxxxxxxxx> wrote:

you can do

Exec sql
Values Current Server Into : Server
it retrieves the same value
RTVNETA does in CL

That's not true. It could happen to match, but you can't count on
that. My experience matches Jonathan Ball's, which is that the values
typically do NOT match.

or you can do
SELECT LOCAL_HOST_NAME FROM QSYS2.TCPIP_INFO

I had tried this one too, before Jonathan Ball pointed out the correct
places to look. This also does not give you the same information as
RTVNETA SYSNAME.

The correct views are

- SYSTEM_STATUS_INFO
- SYSTEM_STATUS_INFO_BASIC
- NETWORK_ATTRIBUTE_INFO

I'll add *slightly* more value here, which is that
NETWORK_ATTRIBUTE_INFO is the newest of those, and may not be
available on your machine if it is behind on updates. It's not
available at all for 7.3 or earlier.

SYSTEM_STATUS_INFO is the oldest, and thus most likely to be
available; but if you have SYSTEM_STATUS_INFO_BASIC, that's going to
be noticeably faster.

John Y.