RE: How can I retrieve the TCP/IP host name?

Birgitta,

I was unfamiliar with the Table( ) function until just now.
Thanks for sharing.
(I had a heck of a time finding it in the reference manual )

Paul

-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Birgitta Hauser
Sent: Tuesday, July 17, 2012 11:31 PM
To: 'Midrange Systems Technical Discussion'
Subject: AW: How can I retrieve the TCP/IP host name?

You may want to check if the UDTF TCPIP_INFO provided in schema/library
QSYS2 will return the information you need.
select * from Table(tcpip_info()) x;

Mit freundlichen Grüßen / Best regards

Birgitta Hauser

"Shoot for the moon, even if you miss, you'll land among the stars." (Les
Brown)
"If you think education is expensive, try ignorance." (Derek Bok) "What is worse than training your staff and losing them? Not training them and keeping them!"

-----Ursprüngliche Nachricht-----
Von: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] Im Auftrag von Darryl Freinkel
Gesendet: Tuesday, 17.7 2012 19:30
An: midrange-l@xxxxxxxxxxxx
Betreff: How can I retrieve the TCP/IP host name?

Can anyone help with how I could retrieve the non-fully qualified host name of a system? I am trying to retrieve the systems IP host name example
server1 and not server1@xxxxxxxxxx.



TIA

Darryl Freinkel | Assignment 400 Group, Inc.



--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list To post a message email: MIDRANGE-L@xxxxxxxxxxxx To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx Before posting, please take a moment to review the archives at http://archive.midrange.com/midrange-l.


--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list To post a message email: MIDRANGE-L@xxxxxxxxxxxx To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx Before posting, please take a moment to review the archives at http://archive.midrange.com/midrange-l.