Archives of the TeradataForum

Message Posted: Tue, 26 Dec 2006 @ 12:13:39 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

Hello Suhail,

Yes, you can use more than one .Export command in the single bteq script,and the script will create that much separate files. For example:

     .Export Data file=employee_data.txt
     Select * from employee;
     .Export reset;
     .Export Data file=department_data.txt
     Select * from department;
     .Export reset;

The above sample script will create 2 files employee_data.txt & department_data.txt

I hope I answered your question !!

Regards,

RahulKumar Gadodia

	<Prev	Next>		<<First	<Prev	Next>	Last>>