You already have tools on zOS DB2 to do this ...
SELECT LASTNAME, X'05',
FIRSTNAME, X'05'
DEPARTMENT, X'05'
STATUSDATE
using SPUFI
Use multiple SPUFI jobs.
One to list the columns of the tables you're interested in; REXX to reformat
that output in to more SELECT statements with tabs or double quotes as need...
or use DSNTIAUL https://ibmmainframes.com/about9681-0.html
here are some other suggestions: https://ibmmainframes.com/about62292.html
Good luck ...
----------------------------------------------------------------------
For IBM-MAIN subscribe / signoff / archive access instructions,
send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN
