Examples

This section contains syntax examples for various command line processes.

Browse a Compare File

To start the Browse Utility from the command line, enter:


PR0CMND /X C:\SALESCON.CMP

To run a process directly from the command line, specify:


PR0CMND /R TYPE=type  REQUEST=identifier.name

To run a Compare Request named SALES.COMPR and display results, enter:
```
PR0CMND /R  TYPE=COMPARE
REQUEST=SALES.COMPR
```
To run an Extract Request named SALES.MONTHLY and add the results to an existing output file named PLAN.TXT, enter:
```
PR0CMND /R TYPE=EXTRACT
REQUEST=SALES.MONTHLY OUTPUT=PLAN.TXT+
```
To run a Compare Request named MARKET.TRENDS, display prompts and error dialogs during the process, and write results to an output file named RESULTS.TXT, enter:
```
PR0CMND /R TYPE=COMPARE
REQUEST=MARKET.TRENDS OUTPUT=RESULTS.TXT
QUIET‑
```

To run a scheduled job directly from the command line, use:

You can create scheduled jobs using the Scheduling Editor. Refer to the Common Elements Manual for details.


PR0CMND /R JOB=‘jobname'

To run a job named CUSTDATA and write the results to an output file named CUSTOUT.TXT, specify:
```
PR0CMND /R JOB=‘CUSTDATA'
OUTPUT=C:\CUSTOUT.TXT
```
To run the same job and display prompts and error dialogs during the process, specify:
```
PR0CMND /R JOB=‘CUSTDATA'
OUTPUT=C:\CUSTOUT.TXT QUIET-
```
To run a job named PAYROLL and display information dialogs during the process, specify:
```
PR0CMND /R  JOB=‘PAYROLL' OUTPUT=PAY.TXT
MONITOR+
```

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=EXTRACT REQUEST=MONTHLY.SALES
TYPE=EXTRACT REQUEST=MONTHLY.QUOTAS
TYPE=COMPARE REQUEST=SALES.YTD STOP=FATAL

Following are examples of command line processing when overrides are specified in a parameter file:

To run an Extract process in a parameter file named LEADS.TXT, enter:


PR0CMND /R @C:\temp\LEADS.TXT

In this example, LEADS.TXT includes the following:


TYPE=EXTRACT REQUEST=SALES.CUST OV=*
DEFQUAL ORACLE1.TELEM
STARTTAB CUSTOMERS
ROWLIMIT 600
SEL CUSTOMERS CUST_ID>'12345'
END

To run a Compare process in a parameter file named COMP.TXT, enter:


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

In this example, COMP.TXT includes the following:


TYPE=COMPARE REQUEST=CMPR.ORDERS OV=*
XFFILE1 APRIL.XF
XFFILE2 MAY.XF
END

Following are examples of command line processes that use override files:

To run an Extract Request named SALES.MTHLY from the command line, and apply overrides from a file named CHANGES.TXT, enter:


PR0CMND /R TYPE=EXTRACT
REQUEST=SALES.MTHLY 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'