Archives of the TeradataForum

Message Posted: Fri, 20 Feb 2004 @ 15:24:01 GMT

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

Well I dont see any problem in this.

 BTEQ -- Enter your DBC/SQL request or BTEQ command:
create table temp1(id1 integer , val1 integer) ;

create table temp1(id1 integer , val1 integer) ;

 *** Table has been created.
 *** Total elapsed time was 1 second.


 BTEQ -- Enter your DBC/SQL request or BTEQ command:
Insert into temp1 (id1,val1) values (1,2);

Insert into temp1 (id1,val1) values (1,2);

 *** Insert completed. One row added.
 *** Total elapsed time was 1 second.


 BTEQ -- Enter your DBC/SQL request or BTEQ command:
Insert into temp1 values (1,3);

Insert into temp1 values (1,3);

 *** Insert completed. One row added.
 *** Total elapsed time was 1 second.


 BTEQ -- Enter your DBC/SQL request or BTEQ command:
Insert into temp1 select 1,21;

Insert into temp1 select 1,21;

 *** Insert completed. One row added.
 *** Total elapsed time was 1 second.

Thanks, Vivek.

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