Groups
ITEM_SEPARATOR
| Col # | Column Name | Data Type | Field Length | Not Null? | Data Def. | Comments |
|---|---|---|---|---|---|---|
| 1 | ID | NUMBER | 22 | N | Primary key | |
| 2 | NAME | VARCHAR2 | 250 | Y | ||
| 3 | CODE | VARCHAR2 | 250 | Y | ||
| 4 | DESCRIPTION | VARCHAR2 | 250 | Y | ||
| 5 | SEPARATOR | VARCHAR2 | 100 | Y | Defines the separator itself. | |
| 6 | START_INDEX | NUMBER | 22 | Y | Defines the start index for Indexed fields delimiters (Non-indexed delimiters will have a value of -1). | |
| 7 | END_INDEX | NUMBER | 22 | Y | Defines the end index of the first field for indexed delimiters (Non-indexed delimiters will have a value of -1). | |
| 8 | MAX_LENGTH | NUMBER | 22 | Y | Maximum length of first field. Used by Indexed fields delimiters. | |
| 9 | START_QUALIFIER | VARCHAR2 | 20 | Y | A symbol to indicate the start of a field. | |
| 10 | END_QUALIFIER | VARCHAR2 | 20 | Y | A symbol to indicate the end of a field . It is not mandatory. |
Contains various separator definitions for use with file processor engines (see /wiki/spaces/Integration/pages/119155850).