The following examples contain overrides in addition to the process parameters.
For this example, create an override file named CHANGES.TXT that contains the following override keywords and values:
DEFQUAL ORACLE1.TELEM
STARTTAB CUSTOMERS
ROWLIMIT 600
SQL CUSTOMERS ST='NJ' AND ZIP='08540'
To run this request from the command line, specify:
PR0CMND /R TYPE=EXTRACT REQUEST=SALES.CUST OV=CHANGES.TXT
Create a parameter file named C:\temp\LEADS.TXT that contains the following:
TYPE=EXTRACT REQUEST=SALES.CUST OV=*
DEFQUAL ORACLE1.TELEMSTARTTAB CUSTOMERS
ROWLIMIT 600
SEL CUSTOMERS CUST_ID>'12345'
END
To run this request from the command line, specify:
PR0CMND /R @C:\temp\LEADS.TXT
Create a parameter file named C:\temp\STATS.TXT that contains the following:
TYPE=EXTRACT REQUEST=MARKET.SALES STOP=W OV=*
SERVER MKTSERV
XFFILE Y:\XF\APRLDATA.XF
ADNAME LISTS.APR98
DEFQUAL UDB98.TELEM
VAR STATE 'NJ'
//Other variables to use default values
ROWLIMIT 400
END
On the command line, specify:
PR0CMND /R @c:\temp\STATS.TXT
OUTPUT=NEWSTATS.TXT