Examples of INFILE Syntax

The following list shows different ways you can specify INFILE syntax:

• Data contained in the control file itself:

  INFILE  *
  

• Data contained in a file named sample with a default extension of .dat:

  INFILE  sample
  

• Data contained in a file named datafile.dat with a full path specified:

  INFILE 'c:/topdir/subdir/datafile.dat' 
  

  Note:

  File names that include spaces or punctuation marks must be enclosed in single quotation marks.

• Data contained in any file of type .dat whose name begins with emp:

  INFILE 'emp*.dat'
  

• Data contained in any file of type .dat whose name begins with m, followed by any other single character, and ending in emp. For example, a file named myemp.dat would be included in the following:

  INFILE 'm?emp.dat'