ISQL does not return agregate column headers as dialect 3 client

By: Quinn Wildman

Abstract: SUM, COUNT, AVG, MAX, MIN do not return column headers in ISQL when ISQL is connected as dialect 3

When the agregate functions SUM, COUNT, AVG, MAX and MIN are run from ISQL when connected as dialect 3, a column header is not displayed.

Example 1 (column header shown for dialect 1):
SQL> set sql dialect 1;
SQL> select sum(f1) from foo;

          SUM
============

          21

Example 2 (column header not shown for dialect 1):
SQL> set sql dialect 3;
SQL> select sum(f1) from foo;

=====================

                   21

Server Response from: ETNASC03