Archives of the TeradataForum

Message Posted: Mon, 15 May 2006 @ 09:40:02 GMT

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

Hi,

I need some help regarding usage of BTQMAIN and FASTLOAD.

I am going to create a new table with the help of CREATE TABLE.

After cretaing the new table, we enter the data using FASTLOAD.

In this utility, we generally give DROP TABLE, then we will give BEGIN LOADING statement and error files.

Before creating new table can we search for existing of that table using the IF condition.

IF the table exist, throw some error

Otherwise create the table.

Please let me know, whether we use IF conditions while creating the new tables.

Thanks & Regards,

Suresh

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