Archives of the TeradataForum
Message Posted: Wed, 07 May 2008 @ 20:47:07 GMT
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.
.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;
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
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|