467,179 Members | 1,263 Online
Bytes | Developer Community
Ask Question

Home New Posts Topics Members FAQ

Post your question to a community of 467,179 developers. It's quick & easy.

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

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
  • viewed: 1005
Share:
1 Reply
Use a UNION ALL where you select constants (the header) from SYSIBM.SYSDUMMY1 in front of the actual table SELECT.
Jul 31 '07 #2

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

23 posts views Thread by Mat | last post: by
2 posts views Thread by Lin Ma | last post: by
2 posts views Thread by Susan Bricker | last post: by
2 posts views Thread by joan.edington@btopenworld.com | last post: by
1 post views Thread by Donald Calloway | last post: by
1 post views Thread by vikjohn | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.