Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Mon, 16 May 2005 @ 20:20:48 GMT

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

Subj:   Re: Is there a DD view to check if a table is being loaded? Error 2652
From:   David Wellman

Hi Don,

No, there is no view which will show you this info. This error happens if the table is currently being Fastloaded or Multiloaded or if the last script for either of these utilities failed.

I'm guessing that what you're trying to achieve is:

- empty the table

- IF the "being loaded" flag is still set (probably due to a previous error)

            drop the table
            create it

- ...carry on with rest of processing

If that's correct, what I normally do in a Bteq script is:

     delete from db.tbl;
     .if errorcode = 0 then .goto emptytbl;    <== all has worked, table is
     not being loaded
     .if errorcode <> 2652 then .quit 8;       <== unknown error, get out of

     create table db.tbl.....

     .label emptytbl;
     ...continue processing

How does that sound ?



  <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: 15 Jun 2023