Summary of Import Parameters by File Format

The following table shows which import parameters are required for each file format.

Import Parameters Batch Keyword Free ASCII Fixed ASCII DSNTIAUL
Source File Name FILENAME Required Required Required
Fld names in 1st row? HEADING Required Required  
Field delimiter FLD_DELIMITER Required    
End of rec delimiter REC_DELIMITER Required    
Values in quotes? QUOTE Required    
How many fields?     Required  
Insert Null as blank? INS_NULL Required Required Required
XDB Server Table name TABLE Required Required Required
If table exists:        
  Append or Replace REPLACE Required Required Required
If table does not exist:        
  Name FIELDS Required Required Required
  Type TYPES Required Required Required
  Length LENGTH Required Required Required
  Null? NULL_PERM Required Required Required
  PIC? USE_PIC Required Required Required
Source Offset OFFSETS   Required  
Source Length SRC_LENS   Required  
Source File type FORMAT Required Required Required
Convert EBCDIC values to ASCII EBCDIC_TO_ASCII     Required
Code Page EBCDIC_CODEPAGE     Required
  ASCII_CODEPAGE      
Insert Mode INSERT_MODE Required Required Required
Commit Interval COMMIT_INTERVAL Required Required Required
Log Errors ERR_LOG_FILE Required Required Required
On Error ON_ERROR Required Required Required