Hello Brian, the method you suggested is very promising. Thanks a lot!
I did it to a test table that has the following DDL:

db2 "describe table test"

Column                         Type      Type
name                           schema    name               Length
Scale Nulls
------------------------------ --------- ------------------ --------
----- ------
COL1                           SYSIBM    SMALLINT                  2
0 Yes
COL2                           SYSIBM    VARCHAR                   5
0 Yes
COL3                           SYSIBM    VARCHAR                   5
0 Yes

db2 "export to test.del of del modified by chardel'' coldel; decpt,
select col1, 'col1    ', col2, 'col2    ', col3, 'col3    ' from test"

The export was successful, and here is the content in test.del:
1;'col1    ';'test1';'col2    ';'val1';'col3    '
2;'col1    ';'test2';'col2    ';'val2';'col3    '
3;'col1    ';'test3';'col2    ';'val3';'col3    '

I added the blanks in the column names so the users can spot each pair
of value/column-name easily. When there are lots of columns in the
table, the above would wrap around to next lines and made it hard to
read, though. Do you know any way of formatting it like the following?

1;'col1    ';
'test1';'col2    ';
'val1';'col3    '

2;'col1    ';
'test2';'col2    ';
'val2';'col3    '

3;'col1    ';
'test3';
'col2    ';
'val3';'col3    '
I need to set up a daily cron job to do such a file, so I need to do
everything automatically. I guess I can always write a PERL script to
separate the pairs, but wonder if there is yet another easy way to do
it.
Thanks again.