Insert values into a table B based on a flag on table A

msanthoshkumar

I am totally new to db2 scripting.

I have a doubt. Please help
We have DB2 on our AIX machine. I have two tables (A and B). Table A has a column 'ACTIVE'. There are like 200 rows of data in this Table A. If column 'ACTIVE' =true, then i have to insert few rows of 'Table A' and some other constants in 'Table B'.

Can anyone please provide some sample code to do this.

Appreiciate your help in advance.

Thanks
Sam

Aug 8 '07 #1

Hevan

Insert into tableb (select col1, col2 from tablea where column = 'active');

Aug 8 '07 #2

Motoma

Insert into tableb (select col1, col2 from tablea where column = 'active');

Thanks for the help Hevan!

Aug 9 '07 #3

r035198x

Insert into tableb (select col1, col2 from tablea where column = 'active');

I rather think they were looking for

Aug 10 '07 #4