Archives of the TeradataForum

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

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

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)

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

     create table db.tbl.....

     .label emptytbl;
     ...continue processing

How does that sound ?

Cheers,

Dave

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