You forgot a comma after SYSTEM!
Regards
Ian

--- In firebird-support@yahoogroups.com, Stefan Heymann <lists@...> wrote:
>
> > 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
>