We are currently migrating from IQ 15 on Solaris to 16 on RedHat. We have hundreds of existing scripts that are executed in batch mode using dbisqlc. Since dbisqlc is deprecated we have been revisiting dbisql. One feature of dbisqlc that has proven very helpful in troubleshooting, in addition to echoing the sql statements, is a line like:
% select time including I/O 5.5 seconds - current time 07:12:34
which appears after every sql statement or block.
Can dbisql deliver statement execution time and current time like this? Going to the srvlog or iqmsg to get the information is a pain.