ITEM_SEPARATOR
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 File Processor Framework).
Â
Â