How to Export DML statement results to a file in BTEQ

Tools
Enthusiast

How to Export DML statement results to a file in BTEQ

Hi All,

I have a script which contains Select,Delete ,update and insert statements.
To export the result of a select statement in BTEQ i can give as

.export report file =filename
sel * from table;
.export reset

But how can i export the result (number of records)of a delete/insert/update statement in BTEQ:

For eg:

delete from table where column1=1;

I want the number of records deleted to be exported to a file.

Thanks in Advance
2 REPLIES
Enthusiast

Re: How to Export DML statement results to a file in BTEQ


Any suggestions please
Enthusiast

Re: How to Export DML statement results to a file in BTEQ

Hi,
save the script to file, call the BTEQ from command line and redirect the standard output to file. As some symbols are difficult to write here, pls see attached sample files. You may also look at topic http://www.teradata.com/teradataforum/Topic14096-10-1.aspx#bm14141
brgds

Petr