Fastload Script without Drop and Create table

Tools & Utilities
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.