Topic
  • No replies
MauricioAssis
MauricioAssis
3 Posts

Pinned topic Removing rows from an archived file (Optim 7.3.1)

‏2013-05-27T20:32:41Z | selcrit

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.

e.g.

PSTDIR OPTIMDIR
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')
ONERROR CONTINUE
RETAINORIGINAL NO
RUN REMOVEROWS

 

when:

// SIEBEL.S_SRV_REQ - main table

// SIEBEL.S_SRV_REQ_BU - joined table

 

Thanks,

 

Mauricio