unload / load data

Hi everybody, i need to unload and after load a big volume of data(table); I want to know how i can do this job in Informix: - unload data in a short time and use a sql clause like "where trn_data >= (today - 365)". after this load this data. Which tool can i use to do this ?? if its possible give me an example :) Tks Pedro HT

pedrohtr@gmail.com (Pedro HT) wrote in news:4b79c74b.0502240433.48388e01 @posting.google.com: > i need to unload and after load a big volume of data(table); Use the ISQL Tool To unload your datas: Unload to MyData.unl Select * from MyTable To load your datas: Load From myData.unl Insert into MyTable Hope this help Stephane Gagnon