bteq supress messages 1

[nachos]

Hi.

I am trying to build a bteq script which will generate
the multiload syntax by reading the dbc tables.
The problems is that the output from bteq keeps
appearing between selects.

Does anyone know how to suppress the messages from bteq ? messages like:

*** Finished at input row 4 at Wed Mar 27 13:34:56 2002
*** Total number of statements: 4, Accepted : 4, Rejected : 0

*** Total elapsed time was 1 second.

*** Total requests sent to the DBC = 4


Thanks.

Nach

 

[tdgulbra]

Those messages don't appear in a:
.export report file=filename

By doing this, you can then use the multiload syntax:
.run filename

Tony

 

[dnoeth]

if you export in report mode you still have headers in your output. The easiest way to get rid of it is to use
.EXPORT DATA FILE = bla
.SET RECORDMODE OFF

Dieter

 

[tdgulbra]

I agree Dieter, but I've always had problems with data mode and trying to read it with anything.

If you

.set TITLEDASHES off

and use the title modifier as follows:

sel blahblah (title'');

and then export in record mode, the file is readable by anything, including MS applications.

Just my 2 cents.

Tony