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
Enter selection criteria to select CUSTOMERS with a Customer ID number greater than 1234.
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
PR0CMND /R @c:\temp\STATS.TXT OUTPUT=NEWSTATS.TXT