Archives of the TeradataForum

Message Posted: Thu, 31 Oct 2002 @ 21:49:40 GMT

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

Hi,

See the following script used to export to unix....and to load to TD database using Fload.

/*Log table for FastExport */

.LOGTABLE database_name.WAG_CALL_DETAIL_FACT_FLOG;

/* Logon String for Teradata */

.LOGON user_name/password;

.BEGIN EXPORT SESSIONS 4 2;

/* Output File Path and Name */

.EXPORT OUTFILE /dir1/dir2/file.txt FORMAT FASTLOAD MODE RECORD;

/* FastExport SQL Statement */
SELECT  * from table_name;

/* FastExport Ends */

.END EXPORT;

.LOGOFF;

Thanks,

Rajesh

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