Re: Copying records from table to table? HOW?

> > Does anyone know how I can achieve copying selected records from a > table to another table in the easiest and fastest way? Depending on the type of engine you have and whether you are using transaction logging and the number of rows in your table the following example is one way of accomplishing this. insert into new_table select *[any selected columns you desire] from norm_table where[condition you desire]; you can also go across stars and inets using insert insert into database@system:new_table select * database@system:norm_table; Depending on your intended application there are many ways to accomplish this request. > > Do I need to write 4gl programs to acheive this? > > I am now using Informix Online 5.01 with 4gl, forms, menus, esql. > > Thank you in advance. > > Davin Boo > Systems Administrator RS/6000 > National Computer Board, Singapore > Ministry of Finance > email : davinboo@ncb.gov.sg -- Mikea