Extract, Insert, Load, and Convert Process Syntax

Use the following syntax for command line processing:

General


PR0CMND /R   
   { JOB=jobname | @parameterfilename 
   TYPE=requesttype  REQUEST= identifier.name  
   [ OUTPUT=filename ] [ QUIET{ + | - } ] [ MONITOR{ + | - } ] 
    [ P { + | - } ]
    [ FREQUENCY=nnnn] 

   [ STOP={ N | I | W | F } ] [ SERVER=servername ] 
   [ PST=pstdirectory] [ OV={ overridefilename | * } ] }

Note: The argument for the OV keyword must be a text file name (OV=overridefilename) when used on the command line. If command-line parameters are defined in a parameter file, the OV keyword can be a text file name, or an asterisk to indicate the parameters follow (OV=*). See Override Keywords for additional information.

Overrides - Extract Process


      [ ADNAME identifier.adname ] 
      [ DEFQUAL dbalias.creatorid ]
      [ PNSFILE pnsfilename.pns ] 
      [ ROWLIMIT n ] 
      [ SEL [ [ dbalias. ]cid. ]tablename columnname operator value ]
      [ SQL [ [ dbalias. ]cid. ]tablename sqlwhereclause ]
      [ TABEVERYNTH [ [ dbalias. ]cid. ]tablename value ]
      [ TABROWLIM [ [ dbalias. ]cid. ]tablename value ]
      [ STARTTAB [ [ dbalias. ]cid. ]tablename ] 
      [ VAR variablename value ]
      [ XFFILE xffile.xf ]

Overrides - Insert Process


      [ XFFILE  xffile.xf ] 
      [ CFFILE  cffile.cf ] 
      [ TMNAME  identifier.tablemapname ] 
      [ COMMFREQ  n ] 
      [ PROCTYPE  { INS | UPDINS } ] 
      [ LOCKTABS  { Y | N }] 
      [ DISROWLIM  n ] 
      [ COLMAPID  identifier ] 
      [ COLMAP  [ [ dbalias. ]cid. ]tablename [ identifier.] colmap ] 
      [ DESTQUAL dbalias.creatorid ] 
      [ DESTTABNAME  srctabname [ [ dbalias. ]cid. 
]desttablename]

Overrides - Load Process


      [ XFFILE  xffile.xf} ] 
      [ CFFILE  cffile.cf ] 
      [ TMNAME  identifier.tablemapname ] 
      [ COLMAPID  identifier ] 
      [ COLMAP  [ [ dbalias. ]cid. ]tablename [ identifier. ]colmap ] 
      [ DESTQUAL dbalias.creatorid ]
      [ DESTTABNAME  srctabname [ [ dbalias. ]cid. 
]desttablename]
      [ MODE  dbalias mode ] 
      [ PERFLOAD  dbalias { Y | N } ] 
      [ DELONSUCCESS dbalias { Y | N } ]
      [ DELONFAILURE dbalias { Y | N } ] 
      [ WORKPATH dbalias path ] 
      [ SERVPATH dbalias path ] 

[DESTDELIMITER dbalias  X'FF']
[SOURCEEMPTY dbalias  { Y | N } ]
[COMMITFREQ dbalias n

Overrides - Convert Process


      [ SRCXFFILE  xffile.xf ] 
      [ DSTXFFILE  xffile.xf ] 
      [ CFFILE  cffile.cf ] 
      [ TMNAME  identifier.tablemapname ] 
      [ DISROWLIM  n ] 
      [ COLMAPID  identifier ] 
      [ COLMAP  [ [ dbalias. ]cid. ]tablename [identifier. ]colmap ] 
      [ DESTQUAL dbalias.creatorid ] 
      [ DESTTABNAME  srctabname [ [ dbalias. ]cid. 
]desttablename]