Example 4 - Use Overrides in Addition to the Process Parameters

The following examples contain overrides in addition to the process parameters.

• Run an Extract Request named SALES.CUST from the command line, but apply the following overrides:
  • Change the default qualifier to ORACLE1.TELEM.
  • Change the Start table to CUSTOMERS.
  • Assign a row limit of 600 rows.
  • Enter an SQL WHERE statement to select only rows containing a particular state and zip code.

  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
  

• Specify command-line and override keywords in a parameter file named LEADS.TXT, to run an Extract Request named SALES.CUST from the command line, but apply the following overrides:
  • Change the default qualifier to ORACLE1.TELEM.
  • Change the Start table to CUSTOMERS.
  • Assign a row limit of 600 rows.
  • 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.TELEM
  STARTTAB  CUSTOMERS
  ROWLIMIT  600
  SEL  CUSTOMERS  CUST_ID>'12345'
  END
  

  To run this request from the command line, specify:

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

• Specify command-line and override keywords in a parameter file named STATS.TXT to run an Extract Request named MARKET.SALES from the command line, stop processing if a Warning message results, write the process report to an output file named NEWSTATS.TXT, and apply the following overrides:
  • Run the request on a server named MKTSERV.
  • Change the Extract File name to Y:\XF\APRLDATA.XF.
  • Change the Access Definition to LISTS.APR98.
  • Change the default qualifier in the Access Definition to UDB.TELEM.
  • Enter the value ‘New Jersey' for a variable named STATE defined in the Access Definition.
  • Assign a row limit of 400 rows.

    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