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.
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 one or more processes using a parameter file.
To run one or more processes from a file, use:
PR0CMND /R @filename
For example, to run processes in a parameter file named STATS.TXT, enter:
PR0CMND /R @C:\STATS.TXT
In this example, STATS.TXT includes the following:
TYPE=ARCHIVE REQUEST=MONTHLY.SALES STOP=WARNING
TYPE=ARCHIVE REQUEST=MONTHLY.QUOTAS
TYPE=ARCHIVE REQUEST=SALES.YTD STOP=FATAL
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