Subject What is this query?
Author Jeff Jones
I have been running an application that uses Firebird 1.5 on the back
end with the UIBMonitor utility to look at all the SQL statements run
against the database. A query that I do not recognize has started
popping up very frequently that looks like this:

Select F.RDB$COMPUTED_BLR, F.RDB$DEFAULT_VALUE from
RDB$RELATION_FIELDS R, RDB$FIELDS F where R.RDB$RELATION_NAME =
'PS_P_GET_EMP_EFF_DT' and R.RDB$FIELD_SOURCE = F.RDB$FIELD_NAME and
R.RDB$FIELD_NAME = 'RESULT'

I know that this is querying the system tables for information about a
stored procedure named PS_P_GET_EMP_EFF_DT, and one of the output
parameters named RESULT, but I don't understand why this query would
be needed. I did not include it in any of my procedures, but it may
be coming from a component in the Delphi front end.

In any case, does anyone recognize this kind of query? What does it
do? Why would it appear in the monitor now? And, most importantly,
how can I get it to stop?

Any help will be appreciated.

Jeff Jones