unload / load data

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Pedro HT - 24 Feb 2005 12:33 GMT

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

Reply to this Message

SteFetS - 24 Feb 2005 13:56 GMT

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

Reply to this Message