Summary of Import Parameters by File Format

Restriction: This topic applies to Windows environments only.

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