Art:
The Connection menu option of dbaccess does not use the query:
SELECT * FROM sysmaster:syssqlhosts;
The connection menu option uses the sqlhosts file since there is no connection yet at that point. Once you establish a connection(SID and TID), you can use an SQL query that will be analyzed by the sqlexec parser.
You need to first have a session in the SCB and a thread in the TCB in order for the sqlexec thread to execute an SQL instruction. The connection menu option always reads the sqlhosts file directly. Even if you do not have the sysmaster:syssqlhosts pseudo table (possible sometimes if the sysmaster is not there), the connection menu option works and lists the contents of the sqlhosts file.
It is true that the SELECT * FROM sysmaster:syssqlhosts; reads the contents of the sqlhosts file after the connection is performed
-- Khaled Bentebal Email: khaled.bentebal@consult-ix.fr Site Web: www.consult-ix.fr