var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Who knows the best way to Unload Clob and Load again
This is a real task from my practice:
I have a table:
Every month I have to delete old records from this table, using MSG_TMS.
But before delete I have to save deleted rows in a sequential file(s).
I have to archive this information fo 12 month.
But by user request I have to restore information in a table for any of saved months.
Give me your advises.
which platform? If LUW, then simply export the data (export to bla.ixf of ixf lobs to <PATH> ...). Afterwards you could also compress the data...
If requested you can import/load the data again...
Platform is z/os. I need JCL. Actually I know 3 ways, but I am looking for the best one.
Originally Posted by nvk@vhv