hi all,
is there anyway of displaying the results without column header in aselect query
example
db2 => select * from test
name age
xxxxx 29
yyyy 35
zzzz 23

into
db2 => select * from test

xxxxx 29
yyyy 35
zzzz 23

cheers
Melb

Yes there is a parameter that can be set to do that. I am too lazy to look it up for you, so check the Command Reference manual.

Thanks marcus.
But I can't find it in the manual. would you mind posting the exact syntax.

cheers

If you go to the thread called Useful DB2 Stuff, you can find the link to download the DB2 manuals. You need the Command Reference. Look in the chapter that deals with the Command Line Processor (CLP). If you are dealing with jdbc or some other interface, you might check out the applciation development manual.

You can find the info you want, plus a few other command line options at
http://www.db2click.com/scribble.htm

Cheers
Sathyaram

db2 -x "select ....."
will not produce the headings but just the column(s) desired.
Ruby