IDS Forum

RE: dbaccess output display width from cron

Posted By: Danny Wright
Date: Tuesday, 26 April 2005, at 4:37 p.m.

In Response To: dbaccess output display width from cron (Danny Wright)

Thanks for all the input from everyone.

I had already stripped out as much unnecessary stuff that I could think of
and so I went with Jean's 2nd suggestion - unloading to a file and
maniupulating that.

By sheer luck, I happened to notice a utility I had downloaded months ago
and forgotten about called beautify-unl.sh (I'm fairly certain it's from the
IIUG software depository).

beautify-unl.sh lines the columns up, but leaves the delimiter and doing an
unload added a decimal place to the SUM and COUNT aggregate functions in my
sql statement, so after unloading, I run this....

beautify-unl.sh <unload-file> | tr '|' '\t' | sed "s/\.0//g"



I'm a bit curious as to why doing an unload causes 1 decimal place to be
displayed, especially since I'm summing integers, and count should never
return anything but an integer, but that's trivial.




-----Original Message-----
From: ERIEZNIKR@REPSOLYPF.COM [mailto:ERIEZNIKR@REPSOLYPF.COM]
Sent: Tuesday, April 26, 2005 1:03 PM
To: dwright@sherwoodfoods.com; ids@iiug.org
Subject: RE: dbaccess output display width from cron [4812]

Agree with Jean

Consider Perl report features.
Unload to file (unload to foo.bar select ....) then feed your perl report
script. If you need some example on this, just ask!

Or remove innecesary fields :-)

All the best.

-----Mensaje original-----
De: forum.subscriber@iiug.org [mailto:forum.subscriber@iiug.org] En nombre
de Danny Wright Enviado el: Martes, 26 de Abril de 2005 01:06 p.m.
Para: ids@iiug.org
Asunto: dbaccess output display width from cron [4812]

I set up a little shell script to run an sql script via dbaccess and mail
the results out to a few people.

When run from the command line, the output comes out with columns displayed
horizontally.

it looks something like this:

column1 column2 column3 etc.....

data data data..........

But when run from cron (or at), it displays like this:

column1 data
column2 data
column3 data



How can I convince it that my display is wide enough to handle displaying
the data horizontally?

Even though I'm setting my environment the same way I would when I log in,
it seems to recognize that it's not a tty




AVISO LEGAL:

Esta informacion es privada y confidencial y esta dirigida unicamente a su
destinatario. Si usted no es el destinatario original de este mensaje y por
este medio pudo acceder a dicha informacion por favor elimine el mensaje. La
distribucion o copia de este mensaje esta estrictamente prohibida. Esta
comunicacion es solo para propositos de informacion y no debe ser
considerada como propuesta, aceptacion ni como una declaracion de voluntad
oficial de REPSOL YPF S.A. y/o subsidiarias y/o afiliadas. La transmision de
e-mails no garantiza que el correo electronico sea seguro o libre de error.
Por consiguiente, no manifestamos que esta informacion sea completa o
precisa. Toda informacion esta sujeta a alterarse sin previo aviso.

This information is private and confidential and intended for the recipient
only. If you are not the intended recipient of this message you are hereby
notified that any review, dissemination, distribution or copying of this
message is strictly prohibited. This communication is for information
purposes only and shall not be regarded neither as a proposal, acceptance
nor as a statement of will or official statement from REPSOL YPF S.A. and/or
subsidiaries and/or affiliates. Email transmission cannot be guaranteed to
be secure or error-free. Therefore, we do not represent that this
information is complete or accurate and it should not be relied upon as
such. All information is subject to change without notice.

Messages In This Thread

• dbaccess output display width from cron
  Danny Wright -- Tuesday, 26 April 2005, at 12:05 p.m.
  • Re: dbaccess output display width from cron
    Jean Sagi -- Tuesday, 26 April 2005, at 12:26 p.m.
    • RE: dbaccess output display width from cron
      Joe Vidrine -- Tuesday, 26 April 2005, at 2:39 p.m.
      • RE: dbaccess output display width from cron
        Tomchik, Kate -- Tuesday, 26 April 2005, at 4:18 p.m.
        • Re: RE: dbaccess output display width from cron
          Jean Sagi -- Tuesday, 26 April 2005, at 4:58 p.m.
        • RE: dbaccess output display width from cron
          Jonathan Leffler -- Wednesday, 27 April 2005, at 12:33 a.m.
  • Re: dbaccess output display width from cron
    Marco Greco -- Tuesday, 26 April 2005, at 2:52 p.m.
  • RE: dbaccess output display width from cron
    ERIEZNIKR@REPSOLYPF.COM -- Tuesday, 26 April 2005, at 4:08 p.m.
  • RE: dbaccess output display width from cron
    Danny Wright -- Tuesday, 26 April 2005, at 4:37 p.m.
    • Re: RE: dbaccess output display width from cron
      Jean Sagi -- Tuesday, 26 April 2005, at 7:10 p.m.
    • RE: dbaccess output display width from cron
      Danny Wright -- Wednesday, 27 April 2005, at 6:25 p.m.
      • RE: dbaccess output display width from cron
        Jonathan Leffler -- Thursday, 28 April 2005, at 1:00 a.m.

IDS Forum is maintained by Administrator with WebBBS 5.12.