Examples

Search and Restore Parameter File Example

To Search and Restore data using a parameter file named SNR.TXT that supplies command-line and override keywords, enter:

PR0CMND /R @C:\TEMP\SNR.TXT

File Format

In this example, the parameter file C:\TEMP\SNR.TXT includes the following:

TYPE=SEARCHANDRESTORE REQUEST=RESTR.MODEL1 OV=*
FILTER FILENAME C:\ACCTS\%.AF
FILTER SERVERNAME SYS_
FILTER GROUP ACCTS
FILTER CREATOR %
FILTER TABLENAME %.TEST.%
GLOCONN OR
GLOSELCRIT %.%.CUSTOMERS CUST_ID > '123'
GLOCOLCONN %.%.CUSTOMERS OR
GLOSQLTEXT %.%.CUSTOMERS CUST_ID< '10' and STATE = 'FL'
SORTORDER Ascending
MAXFILES 5
ONLYFIRST No
DELARES Yes
IGNINACC Yes
CONONERR Yes
CFFILE C:\TEMP\OverSeaInsert.cf
TMNAME pstdoc.PST
COMMFREQ 200
PROCTYPE UpdIns
LOCKTABS No
DISROWLIM 0
COLMAPID L_MSS70
COLMAP CUSTOMERS L_MSS70.CUST
DESTQUAL PSTDOC.PRODCTN
DESTTABNAME CUSTOMERS CUST_RES
END

Search and Restore Override File Example

To Search and Restore data using an override file named SNROVRDS.TXT that supplies overrides, enter:

PR0CMND /R TYPE=SEARCHANDRESTORE REQUEST=RESTR.MODEL2 /OV=SNROVRDS.TXT

File Format

In this example, the override file, SNROVRDS.TXT, includes the following:

FILTER TABLENAME ORA.%.%
FILTER STARTDATE 02/14/2001
FILTER ENDDATE 04/30/2001
SORTORDER Ascending
MAXFILES 100
ONLYFIRST No
IGNINACC Yes
CONONERR Yes
CFFILE C:\TEMP\Loadsear.cf
TMNAME pstdoc.PST
MODE Oracle Append
PERFLOAD Oracle Y
DELONSUCCESS Y
DELONFAILURE N
COLMAP CUSTOMERS L_MSS70.CUST
DESTQUAL PSTDOC.PRODCTN
DESTTABNAME CUSTOMERS CUST_RES
END