Archives of the TeradataForum

Message Posted: Tue, 11 Nov 2008 @ 10:55:32 GMT

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

Hi All,

I have an application under development, coded in Java and Database as Teradata.

The application requires migrating data from Source schema in Teradata to target schema in Teradata.

Some tables in the source are empty. Whenever an empty table is created and then the flow moves to insert data. Since there is no data in source for this table, hence the insert script is not run. The control then moves to create the next empty table. Before creating the next table, a select statement is fired to fetch all the tables present in target schema. I am getting an exception here at this select statement execution saying the following:

[Teradata Database] [TeraJDBC 12.00.00.105] [Error 3932] [SQLState 25000] Only an ET or null statement is legal after a DDL Statement.

I then applied BT and ET before and after DDL statement (Create Table).Still the same exception persists.

Any clue how this can be corrected.

Thanks and Regards

Anindita Dey

Infosys Technologies Limited

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