The following examples show command line usage for Archive and Restore Processes.
The following examples show how to run a single process from the command line.
To run a process directly from the command line, enter:
PR0CMND /R TYPE=type REQUEST=identifier.name
PR0CMND /R PST=PSTDEMO TYPE=ARCHIVE REQUEST=MARKET.YTD
PR0CMND /R TYPE=ARCHIVE REQUEST=SALES.MONTHLY OUTPUT=PLAN.TXT+
PR0CMND /R TYPE=RESTORE REQUEST=MARKET.REFRESH OUTPUT=RESULTS.TXT QUIET‑
The following examples show how to run one or more processes as a scheduled job from the command line.
You can create scheduled jobs using the Scheduling Editor. Refer to the Common Elements Manual for details.
To run a scheduled job directly from the command line, use:
PR0CMND /R JOB=‘jobname'
PR0CMND /R JOB=‘CUSTDATA' OUTPUT=C:\CUSTOUT.TXT
PR0CMND /R JOB=‘CUSTDATA' OUTPUT=C:\CUSTOUT.TXT QUIET-
PR0CMND /R JOB=‘PAYROLL' OUTPUT=PAY.TXT MONITOR+
The following examples show how to run a process using an override file.
To run an Archive Request named SALES.CUST from the command line, and apply overrides from a file named CHANGES.TXT, enter:
PR0CMND /R TYPE=ARCHIVE REQUEST=SALES.CUST OV=CHANGES.TXT
In this example, CHANGES.TXT includes the following:
DEFQUAL ORACLE1.TELEM STARTTAB CUSTOMERS ROWLIMIT 600 SQL CUSTOMERS ST='NJ' AND ZIP='08540'
The following examples show how to run a process using a parameter file with overrides.
To run an Archive Request named SALES.CUST using a parameter file named LEADS.TXT that supplies command-line and override keywords, enter:
PR0CMND /R @C:\TEMP\LEADS.TXT
In this example, C:\TEMP\LEADS.TXT includes the following:
TYPE=ARCHIVE REQUEST=SALES.CUST OV=* DEFQUAL ORACLE1.TELEM STARTTAB CUSTOMERS ROWLIMIT 600 SEL CUSTOMERS CUST_ID>'1234' END
To run an Archive Request named MARKET.SALES and write the process report to an output file, using a parameter file named STATS.TXT that supplies command-line and override keywords and stops processing if a Warning message results, enter:
PR0CMND /R @C:\TEMP\STATS.TXT /OUTPUT=NEWSTATS.TXT
In this example, the parameter file C:\TEMP\STATS.TXT includes the following:
TYPE=ARCHIVE REQUEST=MARKET.SALES STOP=W OV=* SERVER ARCHIVSERV AFFILE Y:\ARCHV\APRLDATA.AF AFXFILE Y:\ARCHV\APRLDATA.AFX ADNAME LISTS.APR98 DEFQUAL UDB98.TELEM VAR STATE 'NJ' //Other variables to use default values ROWLIMIT 400 END
To restore data from two Archive Files using a parameter file named ORDS.TXT that supplies command-line and override keywords, enter:
PR0CMND /R @C:\TEMP\ORDS.TXT
In this example, the parameter file C:\TEMP\ORDS.TXT includes the following:
TYPE=RESTORE REQUEST=RESTR.ORDERS OV=* DELARES YES CONONERR YES [AF1] SERVER ARCHIVSERV AFFILE Y:\ARCHV\APRLDATA.AF GLOSELSQL NO CFFILE APRIL.CF PROCTYPE UPDINS [AF2] AFID 767 GLOSELSQL YES SUBXFFILE GLOBNJ.XF END