How to obtain the full hostname within a SAP IQ server connection.

[SAPSupport]

On the host housing a SAP IQ environment, when connecting to the SAP IQ server via isql, how do you obtain the full hostname?

On ASE it is select ASEHostName() however there is no equivalent IQHostName in IQ.

I am not asking about the client level command. I am asking what is the server level command to extract the full hostname.

------------------------------------------------------------------------------------------------------------------------------------------------
Learn more about the SAP Support user and program here.

[SAPSupport · Accepted solution]

found KBA 3201049 having the query statement corresponding to "hostname" shell command.

--3201049 - How to find Hostname that IQ server is running by query - SAP IQ
https://me.sap.com/notes/3201049
...
Resolution
Please run following statement:

(DBA)> select Value AS Hostname from sa_eng_properties() where PropName='MachineName'
Hostname
---------
testhost
...