We are using Optim 7.3.1 as our archive solution (for Siebel), and I'm trying to use the command line interface (PR0CMND /AFMF) to selectively remove rows from a registered Archive File, using date as criteria.
We tried several SQL syntaxes to use the date in SELCRIT. without success.
AF SERVER001 '/opdata/archive/AARSRVREQ_TEST.AF'
SELCRIT OPTIMDB.SIEBEL.S_SRV_REQ CREATED <= (CURRENT TIMESTAMP -7 YEARS)
Any idea to manipulate the date without use hardcode?