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.
The basic process is working fine, but we have a requirement to use a "JOIN" or "NESTED SELECT" as part of the SELCRIT. is it possible? I have tried some syntaxes without success.
AF SERVER001 '/opdata/archive/AARSRVREQ_TEST.AF'
SELCRIT OPTIMDB.SIEBEL.S_SRV_REQ ROW_ID IN (OPTIMDB.SIEBEL.S_SRV_REQ_BU BU_ID = '1-3467A')
// SIEBEL.S_SRV_REQ - main table
// SIEBEL.S_SRV_REQ_BU - joined table