By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
437,851 Members | 1,729 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 437,851 IT Pros & Developers. It's quick & easy.

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

P: 1
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
Share this Question
Share on Google+
1 Reply


P: 5
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.