To define your input file options, follow these steps:
-
To define your input file type, select one of the following:
- If your input file is in an ASCII fixed file format and each record in your input file occupies a fixed number of bytes (no CR/LF at the end of each record), click ASCII for Fixed Input. To define the record length of the records in your input file, enter a number in the range of 1-32,767 in the Record Size field.
- If your input file is in a mainframe fixed file format and each record in your input file occupies a fixed number of bytes (no CR/LF at the end of each record), click MF for Fixed Input. To define the record length of the records in your input file, enter a number in the range of 1-32,767 in the Record Size field.
- If your output file is in a mainframe file format or you want to define an output Record Size, enter a number in the range 1-32,767 in the Record Size Out field.
- If each record in your input file is terminated with a carriage return/line feed (CR/LF) pair, click ASCII CR/LF Input.
-
If the records in your input file are delimited by a specific character called a delimiter
(a character that marks the beginning or end of a unit of data), select one of the following:
- If the records in your input file are delimited by a tab, click Tab.
- If the records in your input file are delimited by a comma, click Comma.
- If the records in your input file are delimited by a specific character, click Character. Specify the delimiter character in the field to the right of Character.
- If the records in your input file are delimited by a hexadecimal value, click Hex value. Specify the delimiter character in the field to the right of Hex value. For example, if you enter 09 in the delimiter field, 09 is the ASCII hexadecimal value for the tab character.
- If your input file is a dBase file, click dBase Input File.