Hi there,


any way to get rid of column name in

select 'drop procedure ' || rdb$procedure_name || ';' from rdb$procedures
where rdb$procedure_name like 'REP_%';

so that we can run dynamic scripts as we used to in interbase?

e.g.:

set list on;
output tmp.sql;
select 'drop procedure ' || rdb$procedure_name || ';' from rdb$procedures
where rdb$procedure_name like 'REP_%';
output;
input tmp.sql;

any other way to do dynamic scripts in firebird? (would be nice to have
single script for both database engines though)


Thanks,

Paulius