When I do a select last_name from employees where dept = ‘123’, I expect 2000 rows to return.
Given that dept is a descriptor in Adabas, I trust I will see an S1 followed by a whole bunch of L1.
The questions are:
- Is the S1 issued to Adabas by the CONNX JDBC Service or the Adabas SQL Gateway component?
- After the S1, who issue all the subsequent L1? Are all the L1 issued by the CONNX JDBC service or the Gateway?
- When I have where dept = ‘123’ and name is not null in the where caluse, which component is resolving the ‘name is not null’ clause? The ‘name is not null’ does not show up in the Adabas search buffer.
We are revisiting our CONNX architecture design and want to know how far all these commands have to travel through the network.