We use column text instead of headings and I just grab them from SYSCOLUMNS and export as the first record. I use the SQL ListAgg() function to get a delimited string.
Then *add the data.
Are you planning on three rows of heading or concatenating (potentially) three 20 char fields into one?
Roger Harman
COMMON Certified Application Developer - ILE RPG on IBM i on Power
From: MIDRANGE-L <midrange-l-bounces@xxxxxxxxxxxxxxxxxx> on behalf of Jerry Draper <midrangel@xxxxxxxxxxxxx>
Sent: Tuesday, March 5, 2019 3:38 PM
To: midrange-l@xxxxxxxxxxxxxxxxxx
Subject: export data with column headings
Anyone know of a facility that will export db2 data (tab delimited) with
column headings (from db2 specs) as the first record in the exported file?
Thx,
Jerry
--
Jerry Draper, Trilobyte Software Systems, since 1976
IBMi, Network, and Connectivity Specialists, LAN/WAN/VPN
Representing WinTronix, Synapse, HiT, and others .....
(415) 457-3431 opt-1 . www.trilosoft.com
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit:
https://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives
at
https://archive.midrange.com/midrange-l.
Please contact support@xxxxxxxxxxxx for any subscription related questions.
Help support midrange.com by shopping at amazon.com with our affiliate link:
https://amazon.midrange.com
midrange.com
