I use spufi to execute sql select statements to access catalog tables to pull table info and generate ddl statements. Does anyone know how to generate multiple line results instead of concatenating all on one line?

See if the script 'Describe Table' in http://www.db2click.com/scripts.htm serve your purpose

Cheers
Sathyaram