Home Page for the TeradataForum

Archives of the TeradataForum

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

  <Prev Next>  
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' ;


     sample 10;


FastLoad script

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

     player_id   (integer)

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

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

     Insert Into dwprodstage.Fastload_Fast_Export
       ( :Player_ID

     .End Loading;
     .Logoff ;
     exit 0

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