Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Section
Column
width33%

Groups

Wiki Markup
{float:left|width=200px|background=lightgrey|border=solid blue 2px|margin=1px|padding=0px}
{children:page=Rator DB ER Diagram Navigator|depth=1|excerpt=trueindent=1px}
{float}
Column
width33%

ITEM_SEPARATOR

Col #Column NameData TypeField LengthNot 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 fixed-length separatorthe start index for Indexed fields delimiters (Non-indexed delimiters will have a value of -1).
7

END_INDEX

NUMBER

22

Y

 Defines fixed-length separatorthe end index of the first field for indexed delimiters (Non-indexed delimiters will have a value of -1).
8

MAX_LENGTH

NUMBER

22

Y

 Defines fixed-length separatorMaximum 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.
Column
width33%

Contains various separator definitions for use with file processor engines (see /wiki/spaces/Integration/pages/119155850).