There are multiple ways of checking the SAP IQ database options. You can use one of the following method below,
sp_iqcheckoptions
Depending on the connected user, DBA user will see more options compared to non-DBA users.
call sa_conn_properties
SET
Using SET command in the interactive SQL, type in SET and press execute. You will be prompted with the list of options for the logged user.
SELECT * FROM SYSOPTIONS
