|
Archives of the TeradataForumMessage Posted: Mon, 14 Mar 2005 @ 14:21:34 GMT
hello friends thanks for supporting me... again I have one query I have created table through this query create table t_au ( tid numeric(18) NOT NULL primary key,tname varchar(4)); insert into t_au values( select ZEROIFNULL(MAX(tid))+ 1 from t_au , 'WWW' ); i m finding max no from t_au table and incrementing if it is null then it starts form 1 and inserting into the same table . I got this exception com.ncr.teradata.jdbc_4.util.JDBCException: [NCR] [Teradata DBMS] : Syntax error, expected something like ')' between '(' and the 'select' keyword. is it wrong or teratada is not supporting insert ..select..on same table Thanks in Advance Rajesh Maheshwari
| ||||||||||||||||||||||||||||||||||||||||||||||||
| ||||||||||||||||||||||||||||||||||||||||||||||||
Copyright 2016 - All Rights Reserved | ||||||||||||||||||||||||||||||||||||||||||||||||
Last Modified: 15 Jun 2023 | ||||||||||||||||||||||||||||||||||||||||||||||||