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
Saradhi:
SELECT * FROM sysmaster:syssqlhosts;
Art
Art S. Kagel, President and Principal Consultant
ASK Database Management
Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on the IIUG, nor any other organization with which I am associated either explicitly, implicitly, or by inference. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves.