BLR is a reverse-Polish, binary encoded relational language designed for machine generation (e.g. precompiler or interpreter, not to be hand coded by programmers.)

BLR was designed to be extensible and general, so it could be used for inter- program communication regardless of which relational language (QUEL, SQL, Datatrieve, etc.) the client used. It was intended to minimize communication costs, and to be easy for a program to generate and for the server to parse.

The BLR for views, stored procedures and triggers is stored in system tables in your InterBase database. InterBase contains an internal blob filter which allows you to display the textual representation of BLR using any InterBase client which support Blob Filters. One such client is isql.

To turn this blob filter on in isql execute:

set blobdisplay on;

To display the BLR for a particular view execute:

select rdb$view_blr from rdb$relations where rdb$relation_name='YOUR_VIEW_NAME';

To display the BLR for a particular stored procedure execute:

select rdb$procedure_blr from rdb$procedures where rdb$procedure_name='YOUR_PROCEDURE NAME';

To display the BLR for a particular trigger execute:

select rdb$trigger_name from rdb$triggers where rdb$trigger_name='YOUR_TRIGGER_NAME';