How to create a snapshot of a table.

[shigeoka]

Hi

I have a table that contains thousands of rows, and I want to have a "snapshot table" of this big table. I know I can create a view, but what I really want is a table that refresh it data every 2 hours for example or just when I want to refresh it data.

Thanks a lot

Shigeoka

 

[shigeoka]

Hi

While I was waiting for a replay here, I has just opened a case at IBM, there I get the information that I don´t want ). Informix does not do this type of application, what can be done is activate the replication, but that´s not what I want. I just want to share this information whith you.

Best Regards.
Shigeoka

 

[vpshriyan]

Hi,

You may think of introducing a new table with only required fields to be maintained "in sync" using a Trigger. This may not sound good for your requirement but might serve the purpose.

You can download an e-book (pdf) version of Trigger from:

http://publibfi.boulder.ibm.com/epubs/pdf/7230a.pdf

Regards,
Shriyan