Fastload Script without Drop and Create table

Tools
Enthusiast

Fastload Script without Drop and Create table

Hi,
In our fastload script, actually we are dropping the Table and again creating it.
Sample :
.logon tdpid/tduser,tdpassword
Drop table dbname.tblname
Drop table dbname.errtblname1
Drop table dbname.errtblname2
Create table dbname.tblname

Is it possible to write a fastload script without dropping the Table and then re-creating it? And instead can we use delete statement to make the Table empty.

Thanks,
Vinay.
1 REPLY
Junior Contributor

Re: Fastload Script without Drop and Create table

You can DELETE the target table if the previous load was successful.

Otherwise it will return a 2652, table being loaded.

If the error tables still exist, the previous load didn't finish, you must either finish it or drop the error tables.