Output from dbaccess

What do I modify/set to get dbaccess to output in a "long column list" format instead of the "individually labeled record" format, i.e., col1_name col2_name record1val1 record1val2 record2val1 record2val2 instead of: col1_name record1val1 col2_name record1val2 col1_name record2val1 col2_name record2val2 I have one instance which outputs one way and another which outputs the other. Thanks!

The only alternative to using sqlcmd involves post processing the dbaccess output or having dbaccess output using UNLOAD TO and post process that. There are scripts on the IIUG Web Site that can do this, but sqlcmd is a better choice. Art S. Kagel Bryan Osborne wrote: > > What do I modify/set to get dbaccess to output in a "long column list" > format instead of the "individually labeled record" format, i.e., > > col1_name col2_name > record1val1 record1val2 > record2val1 record2val2 > > instead of: > > col1_name record1val1 > col2_name record1val2 > > col1_name record2val1 > col2_name record2val2 > > I have one instance which outputs one way and another which outputs the > other. > > Thanks!