Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Wed, 07 May 2008 @ 20:47:07 GMT


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


Subj:   Fastexport a file then fastload the file
 
From:   Diane Wilson

Can anyone help pls as I'm a bit rusty on TD utilities these days.

I'm currently upgrade testing TTU8.2 and wish to run an extremely simple fastexport and fastload script purely so I can tick my tested fastexport / fastload box.

The fastexports is extracting a sample of 10 player_ids ( stored on td as an integer) onto a file.

I then want to fastload that file to a table containing 1 column player_id ( Integer).

Simple I know, but as I say its purely for testing TTU8.2 purposes.

I have encountered every possible error while trying to do this and I am now completely stumped.

If anyone can help I will be eternally grateful.

FastExport script

     .LOGTABLE dwproderrors.Fexport_Upgrade_Test_log;
     .logon tdp1/dbadmin,xxxxx;
     .begin export
     sessions 12;
     .export outfile  't:\BTEQ\Files\fast_export.dat' ;

     SELECT
       Player_ID

     FROM DwProdviewsetl.DAILY_PLAYER_CLASS_SUMMARY
     sample 10;

     .END EXPORT;
     .LOGOFF;

FastLoad script

     Sessions 20;
     Errlimit 25;
     .logon tdp1/dbadmin,xxxxx;

     Define
     player_id   (integer)

     FILE = t:\ BTEQ\Files\fast_export.dat;

     BEGIN LOADING dwprodstage.Fastload_Fast_Export
     ErrorFiles    dwproderrorS.Fastload_Fast_Export_ERR1,
                    dwproderrorS.Fastload_Fast_Export_ERR2
     CHECKPOINT    10000;

     Insert Into dwprodstage.Fastload_Fast_Export
       Values
       ( :Player_ID
       )
     ;

     .End Loading;
     .Logoff ;
     exit 0


     
  <Prev Next>  
<<First
<Prev
Next> Last>>  
 
 
 
 
 
 
 
 
  
  Top Home Privacy Feedback  
 
 
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 27 Dec 2016