> If you are using Firebird 2.0, then use the RDB$GET_CONTEXT system
> function with the SYSTEM namespace. Works like a treat, even in PSQL. ;-)

I just tried
select rdb$get_context ('SYSTEM, 'DB_NAME') from rdb$database

and get this error:
335544569
Dynamic SQL Error
SQL error code = -104
Token unknown - line 2, char 35
DB_NAME

The same thing happens for NETWORK_PROTOCOL and CLIENT_ADDRESS.

Firebird 2.0.0 final, logged in as SYSDBA, OSD 11 (database created
under FB2).

Do you know what I am doing wrong here?


Best Regards

Stefan


--
Stefan Heymann
www.destructor.de/firebird