Page 1 of 1

Subquery in INSERT statement

PostPosted: Fri May 13, 2011 7:04 pm
by unique
Hi

I am trying to insert a row into table with below sql

INSERT INTO OWNER.TABLEA VALUES (VALUE1, VALUE2, VALUE3, SELECT COLUMN1 FROM OWNER.TABLEB)
i am getting the following error. Can you guys help me out?

Can an insert statement consist of both values and subquery?

SNT408I SQLCODE = -104, ERROR:  ILLEGAL SYMBOL "COLUMN1". SOME SYMBOLS   
        THAT MIGHT BE LEGAL ARE: CONCAT || / MICROSECONDS MICROSECOND SECONDS 
        SECOND MINUTES                                                         
SNT418I SQLSTATE   = 42601 SQLSTATE RETURN CODE                               
SNT415I SQLERRP    = DSNHPARS SQL PROCEDURE DETECTING ERROR                   
SNT416I SQLERRD    = 3 0  0  -1  94  502 SQL DIAGNOSTIC INFORMATION           
SNT416I SQLERRD    = X'00000003'  X'00000000'  X'00000000'  X'FFFFFFFF'       
        X'0000005E'  X'000001F6' SQL DIAGNOSTIC INFORMATION                   


Thanks

Re: Subquery in INSERT statement

PostPosted: Fri May 13, 2011 8:21 pm
by GuyC
the answer is NO.

But you can always put values in a select :

INSERT INTO OWNER.TABLEA VALUES (SELECT VALUE1, VALUE2, VALUE3, COLUMN1 FROM OWNER.TABLEB)