dbaccess vs column headers

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

KStahl - 20 Mar 2008 21:54 GMT

When using dbaccess from the command line to run a query, is there any
way to tell it to omit column headers?

Also, is there any way to only return data and trim out blank lines?

Reply to this Message

Michael Krzepkowski - 20 Mar 2008 22:52 GMT

> When using dbaccess from the command line to run a query, is there any
> way to tell it to omit column headers?
>
> Also, is there any way to only return data and trim out blank lines?

Look for "output to pipe 'sed ....' without headings".

sed can remove empty lines. If you use M$ Windoze you can get Unix
utilities for Windows too.

HTH

Michael

Reply to this Message

Art S. Kagel (Oninit) - 20 Mar 2008 23:24 GMT

> When using dbaccess from the command line to run a query, is there any
> way to tell it to omit column headers?
>
> Also, is there any way to only return data and trim out blank lines?

OUTPUT TO <file|pipe> WITHOUT HEADINGS SELECT....;
-or-
UNLOAD TO <file|pipe> DELIMITER '<TAB>' SELECT...;

Art S. Kagel
Oninit

===========================================================================================
Please access the attached hyperlink for an important electronic communications disclaimer:

http://www.oninit.com/home/disclaimer.php

===========================================================================================

Reply to this Message

Claus Samuelsen - 27 Mar 2008 08:29 GMT

> When using dbaccess from the command line to run a query, is there any
> way to tell it to omit column headers?
>
> Also, is there any way to only return data and trim out blank lines?

Maybe you would be much better off using Jonathan Leffler's sqlcmd
downloadbale from iiug.org

Reply to this Message