Archives of the TeradataForum

Message Posted: Wed, 19 May 2010 @ 10:08:37 GMT

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

Hi. I've never met such problems before (as I understand export data is writing both in log and data files.

I use this script to unload data from Teradata:

     .LOGTABLE dpm_adm_work.LT20100105102135;
     .LOGON <<>>;
     .BEGIN EXPORT; .EXPORT OUTFILE subs10mil.dat FORMAT TEXT MODE RECORD;


     SELECT cast(subscription_Id as char(20))
       FROM dpvm_adm.v_adm_m_subscription_new
       WHERE month_id = 201002
       QUALIFY ROW_NUMBER() OVER(ORDER BY subscription_id) <= 10000000;

     .END EXPORT;

     .LOGOFF;

By the way - I don't see any log file in your script. Can you, please, send sample for your big log and data files.

Best regards,

Dmitriy Boyko

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