Archives of the TeradataForum

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

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

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>>