User Guide : Map Connectors : Source and Target Map Connectors : Binary Line Sequential
 
Share this page                  
Binary Line Sequential
The Binary Line Sequential connector connects to binary files with variable length records. The integration platform then determines the record length by finding the record separator. The integration platform can both read and write to Binary Line Sequential files.
Connector-Specific Notes
If the alternate field or record separator is not listed
1. Highlight the default separator.
2. Enter the separator in binary or hex.
• ASCII: Enter the appropriate character code.
For example, if the separator is a line feed, enter LF.
• Hex: Enter a backslash, an "x", and the hex value for the separator.
For example, if the separator is a line feed, enter \x0a.
Property Options
You can set the following source (S) and target (T) properties.
Property
S/T
Description
CodePage
ST
This translation table determines which encoding to use for reading and writing data. The default is ANSI, the standard in the US.
MaxRecordLength
S
Maximum record length of the data. The default is 32700 bytes.
OccursPad
S
When using COBOL files, you may have fields of variable lengths. If so, you may select one of the following to specify how to fill the field with pads to a fixed length:
• None (the default) – leaves the fields uneven.
• End of Record – fills the remainder of the record with your specified pad character.
• Within Group – fills the field with your specified pad character.
RecordSeparator
ST
Specifies what sort of character is used to mark the end of a record. The default record separator is carriage return-line feed. To use other characters for a record separator, click the RecordSeparator cell and click once. Then click the arrow to the right of the box and click the desired record separator in the list box. The list box choices are carriage return-line feed (default), line feed, carriage return, line feed-carriage return, form feed, empty line, and no record separator.
ShortLastRecord
S
If set to true, short reads are ignored on the last record of the file. In other words, the last record is processed even if the End of File (EOF) is reached before reading the end of the record. The default is false.
StartOffset
S
If your source data file starts with characters that need to be excluded from the transformation, set the StartOffset option to specify at which byte of the file to begin. The default value is zero. The correct value may be determined by using the Hex Browser.
Note:  This property is set in number of bytes, not characters.
Data Types
The following data types are available:
• 16-bit binary
• 16-bit logical
• 24-bit binary
• 32-bit binary
• 32-bit IEEE floating-point
• 32-bit TEC binary
• 32-bit VAX floating-point
• 64-bit binary
• 64-bit IEEE floating point
• 64-bit VAX floating-point
• 8-bit binary
• 80-bit Intel floating-point
• AccPac 41-bit binary
• Binary
• Boolean
• Btrieve date
• Btrieve time
• Column binary alpha-numeric
• Column binary multi-punch
• Column binary numeric
• Comp
• Comp-1
• Comp-2
• Comp-3
• Comp-5
• Comp-6
• Comp-X
• Complex
• Cray floating-point
• Date
• DateTime
• dBASE Numeric
• Display
• Display Boolean
• Display Date
• Display Date/Time
• Display justified
• Display sign leading
• Display sign leading separate
• Display sign trailing
• Display sign trailing separate
• Display Time
• Magic PC Date
• Magic PC Extended
• Magic PC Number
• Magic PC Real
• Magic PC Time
• Microsoft BASIC double
• Microsoft BASIC float
• Name
• Null-terminated C string
• Packed decimal
• Pascal 48-bit real
• Pascal string (1 byte)
• Pascal string (2 bytes)
• Sales Ally date
• Sales Ally time-1
• Text
• Time
• Time (minutes past midnight)
• Union
• Variable length IBM float
• Zoned decimal