Home Page for the TeradataForum

Archives of the TeradataForum

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

  <Prev Next>  
Next> Last>>  

Subj:   Issue while creating and inserting in teradata tables through java
From:   Anindita Dey

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] [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>  
Next> Last>>  
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 28 Jun 2020