Need to display the header as the top row in the recordset

seldanny

please let me know how do we disply the header as the top value in the record set, since when I export the data to a file , only the data is displayed and need to know what each data headers are. Tried various methods , help would be really appreciated. Please see below the example as to how the data should be displayed. thanks

Please see below the example.

Name Age Gender
-------------------------------------
Name Age Gender
danny 18 M
kristi 18 F

Jul 30 '07 #1

Chrisk

Use a UNION ALL where you select constants (the header) from SYSIBM.SYSDUMMY1 in front of the actual table SELECT.

Jul 31 '07 #2