By: Quinn Wildman
Abstract: All request are converted to BLR. Here you learn how to see the BLR under the covers.
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';
Trial Download Week!
Click here to download a free 30-day trial of InterBase XE3 Server or ToGo editions. Or download a free non-expiring Developer Edition >
More InterBase Info
InterBase XE3 Product Info
Free Developer Edition download
InterBase on Google+
Follow @InterBase_ on Twitter
Server Response from: ETNASC02