Kbase P40668: How to clear the temp-table of an SDO ?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
05/09/2003 |
|
Status: Unverified
GOAL:
How to clear the temp-table of an SDO ?
GOAL:
Having an SDO built on a temp-table, how to clear the temp-table ?
FACT(s) (Environment):
Progress 9.1x
FIX:
Define an internal procedure in the SDO, something like:
procedure ClearTempTable:
FOR EACH temp-table NO-LOCK :
DELETE temp-table.
END.
/* update rowObject table */
DYNAMIC-FUNCTION( 'openQuery' ).
END PROCEDURE.
and call it from the container of the SDO or any other object linked to the SDO
with:
RUN ClearTempTable IN h_SDO .
where h_SDO is the handle of the SDO .