Splitter Table

The Splitter Table (Splitter_tb) contains a record for every splitter entry defined in Sterling Gentran:Server®.

Each splitter entry contains the parameters that are necessary for the system to identify and split interchanges for received data.

Table 1. Splitter Table field information
Field Name Type Size Use
Type number (integer) 2 Type of splitter entry.
  • Fixed - The splitter entry expects a defined set of delimiters in the EDI data. (default)
  • Fixed Position - The splitter entry expects delimiters at defined positions in the EDI data so the system can determine what the delimiter is.
  • Variable - The splitter entry expects defined interchange start and end segments, element delimiter position (so the system can determine what the delimiter is), number of elements in the start segment, maximum length of the start segment, maximum length of the last element in the start segment, and maximum length of the end segment.
StartTag string 50 Start segment of the interchange.
EndTag string 50 End segment of the interchange.
EleDelim string 1 Value depends on the standard:
  • For the Fixed type, contains the element separator.
  • For the Fixed Position type, contains the position of the first element separator in the interchange.
  • For the Variable type, contains the position of the first element delimiter in the interchange.
TagDelim string 1 Value depends on the standard:
  • For the Fixed type, contains the tag separator.
  • For the Fixed Position type, contains the position of the tag separator in the interchange.
EndDelim string 1 Value depends on the standard:
  • For the Fixed type, contains the element separator.
  • For the Fixed Position type, contains the position of the first element separator in the interchange.
  • For the Variable type, contains the position of the first element delimiter in the interchange.
RelDelim string 1 Value depends on the standard:
  • For the Fixed type, contains the release indicator.
  • For the Fixed Position type, contains the position of the first release indicator in the interchange.
SubDelim string 1 Value depends on the standard:
  • For the Fixed type, contains the subelement separator.
  • For the Fixed Position type, contains the position of the first subelement separator in the interchange.
DecChar string 1 Value depends on the standard:
  • For the Fixed type, contains the decimal point notation.
  • For the Fixed Position type, contains either a comma (,) or period (.) to indicate the decimal point in a numeric field.
  • For the Variable type, contains either a comma (,) or period (.) to indicate the decimal point in a numeric field.
EleDelimPosn number (integer) 2 Position of the element delimiter.
TagDelimPosn number (integer) 2 Position of the tag delimiter.
EndDelimPosn number (integer) 2 Position of the end delimiter.
RelDelimPosn number (integer) 2 Position of the release delimiter.
SubDelimPosn number (integer) 2 Position of the subelement delimiter.
DecCharPosn number (integer) 2 Position of the decimal character delimiter.
NumHdrSeg number (integer) 2 Number of elements in the interchange start segment.
HdrMaxLen number (integer) 2 Maximum length of the interchange start segment.
HdrLastEleLen number (integer) 2 Maximum length of the last element in the interchange start segment.
EndMaxLen number (integer) 2 Maximum length of the interchange end segment.
InterchangeBreak string 40 Interchange break translation object used to break the interchange.
GroupBreak string 40 Functional group break translation object used to break the functional groups in the interchange.
TransactionBreak string 40 Transaction set break translation object used to break the transaction sets in the interchange.
FAExtract string 40 Functional acknowledgement break translation object used to extract interchange level functional acknowledgements from the interchange.
RepeatingElement Delim string 1 Delimiter for repeating elements.
RepeatingElement DelimPosn number (integer) 2 Location of the repeating element delimiter in the data.
BinarySegment string 50 Name of the binary segment for which the system should search in the data.