|
Archives of the TeradataForumMessage 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. 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
| ||||||||||||||||||||||||||||||||||||||||||||||||
| ||||||||||||||||||||||||||||||||||||||||||||||||
Copyright 2016 - All Rights Reserved | ||||||||||||||||||||||||||||||||||||||||||||||||
Last Modified: 15 Jun 2023 | ||||||||||||||||||||||||||||||||||||||||||||||||