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
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