HEADING Information 1

[fastwallie]

In Oracle I frequently use the set command to set the heading off. I'am looking for this functionality in the DB2 client (commandcenter) but can find it ?

In the example below I only want to see the result : 427114
How can i do that ?

db2 => select max(organisatieid) from organisatie where organisatieid < '429555'

1
---------------
427114

1 record(s) selected.

 

[gregsimpson]

fastwallie,

not sure about the command centre. You can turn it off in the command line interface using the -x option. The following link shows all the options for the clp but I'm not sure whether that's really going to help you.

http://publib.boulder.ibm.com/infoc...?topic=/com.ibm.db2.udb.doc/core/r0010410.htm

Cheers
Greg

 

[MarcLodge]

fastwallie
If you were really desperate you could try:

select max(organisatieid)as ' ' from organisatie where organisatieid < '429555'

Marc