|
|
Archives of the TeradataForum
Message Posted: Fri, 15 Apr 2005 @ 09:35:59 GMT
Subj: | | Export data to flat file using bteq |
|
From: | | Dhanraj Palani |
Hi,
I am using bteq for creating flat files which in turn are used by some application. Following is what i am doing. Please suggest if the
approach is right or i need anything else to do.
.LOGON testdsn/dbc,dbc
.SET FORMAT OFF
.SET NULL AS ''
.SET SEPARATOR 0
.OS del emp.dat
.EXPORT REPORT file=emp.dat
SELECT empno (title ''), ename(title '') FROM emp;
.EXPORT RESET
Regards,
Dhanraj P
| |