User Guide : Map Connectors : Source and Target Map Connectors : Variable Sequential (Record-V UniKix)
 
Share this page             
Variable Sequential (Record-V UniKix)
Variable Sequential (Record-V UniKix) is a storage format for data downloaded from a mainframe. Variable Sequential (Record-V UniKix) has a Record Descriptor Word (RDW) in the form of a four byte signed integer field at the beginning of each record and records of various lengths within the file. With this connector, the integration platform pads all the records to the maximum record length. Information in a Variable Sequential (Record-V UniKix) can be stored in EBCDIC or ASCII format. Variable Sequential (Record-V UniKix) files have no headers.
Connector-Specific Notes
Truncation Error Trapping
This connector does not support truncation error trapping. If the target field size is too small for the data written to it, the offending record may be skipped or incomplete data may be written to the target. The transformation does not stop due to a truncation error.
Property Options
You can set the following source (S) and target (T) properties.
Property
S/T
Description
MaxRecordLength
S
This specifies the maximum record length of the data. The default is 32700 bytes.
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. For a list of the 256 standard and extended ASCII characters, search for "hex values" in the documentation.
Note:  This property is set in number of bytes, not characters.
OccursPad
S
When using COBOL files, you may have fields of variable length. If so, you may specify how to fill the field with pads to a fixed length. The default is None.
The following options are available:
None (which leaves the fields uneven) – Default
End of Record (which fills the remainder of the record with your specified pad character)
Within Group (which fills the field with your specified pad character)
CodePage
ST
This translation table determines which encoding to use for reading and writing data. The default is ANSI, the standard in the US.
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 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