I am new at OS/400 and DB2. I want to write one small progarm which inserts records in one table based on another table. I don't know weather to write it into C program or DB2 procedure. Can anyone pl. guide me on this. Is there any site where I can look for some examples so that I can write my code. Pl. help

regards

Ash

Ash,
You can check out this site for all kinds of DB2 sample code:

http://www.developer.ibm.com/tech/sampdb2.html

HTH

Andy