This may or may not be a code bug...

According to the INGRES 10 manual the -S option will:

"Runs the Terminal Monitor in silent mode, which shows query output only, and suppresses headers, footers, column titles, separators, lines, and row counts. This allows simple reports to be created as SQL scripts and then runwithout having to edit the output."

However on ingres10 I find...
sql -S iidbdb <<HERE
select name,own from iidatabase order by 2,1\g
\q
HERE

WILL produce column titles.

This behaviour is consistent with the \silent command.

It appears the only way I can remove titles is to use the \notitles command..

Is this a code bug or a documentation bug?

Marty

Hi Marty,

It looks like it is behaving as implemented based on the examples
showing how the feature should work on the project development page at
'Terminal Monitor Silent Mode - Ingres Community Wiki'
(http://community.ingres.com/wiki/Ter...or_Silent_Mode)

Example taken from the project page:

Here is the output with "-S"

$ sql -S demodb < t.sql | cat
ct_id ct_cod
229 GB
201 ZA
39 CA
$


Regards,
Teresa


--
teresa

It's bug 125167. Contact Support for a patch if you need one. As you say
the work-around in \notitles



From: info-ingres-bounces (AT) kettleriver...ting (DOT) com
[mailto:info-ingres-bounces (AT) kettleriverconsulting (DOT) com] On Behalf Of
Martin Bowes
Sent: 10 June 2011 13:50
To: Ingres and related product discussion forum
Subject: [Info-Ingres] sql -S option



This may or may not be a code bug...



According to the INGRES 10 manual the -S option will:



"Runs the Terminal Monitor in silent mode, which shows query output
only, and suppresses headers, footers, column titles, separators, lines,
and row counts. This allows simple reports to be created as SQL scripts
and then run without having to edit the output."



However on ingres10 I find...

sql -S iidbdb <<HERE

select name,own from iidatabase order by 2,1\g

\q

HERE



WILL produce column titles.



This behaviour is consistent with the \silent command.



It appears the only way I can remove titles is to use the \notitles
command.



Is this a code bug or a documentation bug?



Marty

Thanks Paul,

The workaround is good enough for us.

Marty

From: Paul Mason [mailto:Paul.Mason (AT) ingres (DOT) com]
Sent: 10 June 2011 14:15
To: Ingres and related product discussion forum
Subject: Re: [Info-Ingres] sql -S option

It's bug 125167. Contact Support for a patch if you need one. As you say the work-around in \notitles

From: info-ingres-bounces (AT) kettleriver...ting (DOT) com [mailto:info-ingres-bounces (AT) kettleriverconsulting (DOT) com] On Behalf Of Martin Bowes
Sent: 10 June 2011 13:50
To: Ingres and related product discussion forum
Subject: [Info-Ingres] sql -S option

This may or may not be a code bug...

According to the INGRES 10 manual the -S option will:

"Runs the Terminal Monitor in silent mode, which shows query output only, and suppresses headers, footers, column titles, separators, lines, and row counts. This allows simple reports to be created as SQL scripts and then runwithout having to edit the output."

However on ingres10 I find...
sql -S iidbdb <<HERE
select name,own from iidatabase order by 2,1\g
\q
HERE

WILL produce column titles.

This behaviour is consistent with the \silent command.

It appears the only way I can remove titles is to use the \notitles command..

Is this a code bug or a documentation bug?

Marty