From the command line type db2 ? OPTIONS

You get the following
Option Description Default Setting
------ ---------------------------------------- ---------------
-a Display SQLCA OFF
-c Auto-commit ON
-e Display SQLCODE/SQLSTATE OFF
-f Read from input file OFF
-l Log commands in history file OFF
-n Remove new line character OFF
-o Display output ON
-p Display db2 interactive prompt ON
-r Save output report to file OFF
-s Stop execution on command error OFF
-t Set statement termination character OFF
-v Echo current command OFF
-w Display FETCH/SELECT warning messages ON
-x Suppress printing of column headings OFF
-z Save all output to output file OFF

To run a script without seeing columns that is terminated with a ';'
>DB2 -txf someScript.sql

-----Original Message-----
From: Jani Tamminen
[mailto:db2udbdba-ezmlmshield-x11913894.[Email address protected]
Sent: Wednesday, July 21, 2004 6:48 PM
To: LazyDBA Discussion
Subject: formatting SQL query output


How do I format the DB2 UDB sql query output.

I want the output not to print the heading and feed back off.

In oracle SQLplus, I can set set head off feed off etc.

I am looking for a doc with these type of information.



---------------------------------------------------------------------
PLEASE CLICK REPLY-ALL TO SEND A REPLY TO EVERYONE
website: http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
For additional commands, e-mail: db2udbdba-[Email address protected]



The information in this electronic mail message is sender's business
Confidential and may be legally privileged. It is intended solely for the
addressee(s). Access to this Internet electronic mail message by anyone
else is unauthorized. If you are not the intended recipient, any
disclosure, copying, distribution or any action taken or omitted to be taken
in reliance on it is prohibited and may be unlawful.
The sender believes that this E-mail and any attachments were free of any
virus, worm, Trojan horse, and/or malicious code when sent. This message and
its attachments could have been infected during transmission. By reading
the message and opening any attachments, the recipient accepts full
responsibility for taking protective and remedial action about viruses and
other defects. Galileo International is not liable for any loss or damage
arising in any way from this message or its attachments.



DB2 & UDB email list listserv db2-l LazyDBA home page