Insert Select From - Not All Columns 1

[dja1]

I would like to INSERT INTO TABLE_A SELECT * FROM TABLE_B, but, put fixed values into the first three columns of the destination table, as follows;
INSERT INTO TABLE_A
VALUES ("VAL1", "VAL2", "VAL3", ((Select X From TABLE_B))

Where "X" is the remaining columns from TABLE_B.

Obviously, this isn't the correct construct, it's just to give some idea of what I want to do.

 

[sathyarams]

insert into table_a select 'val1','val2','val3',x from table_b

For db2 resoruces visit

http://www.db2click.com

More DB2 questions answered at

http://www.dbforums.com/f8

&

http://www.idug.org/user/UserLogin.asp