How to print message in ISQL / IBExpert Sql tool?

Question

I know that in SQL Server we can print message via operator PRINT, but PRINT doesn't work in IBExpert, and command OUTPUT too. Can someone help me?

I have this error when I run previous code:

Answer 1

Firebird has no such feature. It is not possible to "print" or "output" messages in this way (nor does Firebird have a statement called OUTPUT¹).

The only option you have in stored procedures is to return the message as the value of a return column. For triggers, there is no real option, though you could write things to a global temporary table and explicitly select from that GTT before transaction commit or something similar. However, that requires explicit action on your part to get the output.

---

^{1. The Firebird query tool ISQL has a command called OUTPUT, but that is purely for redirecting output of ISQL itself to a file.}