Sequential File Connector > Data type reference > Sequential file and transformation data types
  

Sequential file and transformation data types

When Data Integration reads source data, it converts the native data types to the comparable transformation data types before transforming the data. When Data Integration writes to a target, it converts the transformation data types to the comparable native data types.
The following table lists the sequential file data types that Data Integration supports and the corresponding transformation data types:
PowerExchange Datatype
Precision
Transformation Datatype
Range
BIN
10
Binary
1 to 104,857,600 bytes
You can pass binary data from a source to a target, but you cannot perform transformations on binary data. PowerCenter does not support binary data for COBOL or flat file sources.
CHAR
10
String
1 to 104,857,600 characters
Fixed-length or varying-length string.
DATE
10
Date/Time
Jan 1, 0001 A.D. to Dec 31, 9999 A.D.
Combined date/time value, with precision to the nanosecond.
DOUBLE
18
Double
Precision of 15 digits
Double-precision floating-point numeric value.
FLOAT
7
Double
Precision of 15 digits
Double-precision floating-point numeric value.
NUM8
3
Small Integer
Precision of 5 and scale of 0
Integer value.
NUM8U
3
Small Integer
Precision of 5 and scale of 0
Integer value.
NUM16
5
Small Integer
Precision of 5 and scale of 0
Integer value.
NUM16U
5
Integer
Precision of 10 and scale of 0
Integer value.
NUM32
10
Integer
Precision of 10 and scale of 0
Integer value.
NUM32U
10
Double
Precision of 15 digits
Double-precision floating-point numeric value.
NUM64
19
Decimal
Precision 1 to 28 digits, scale 0 to 28
Decimal value with declared precision and scale. Scale must be less than or equal to precision. If you pass a value with negative scale or declared precision greater than 28, the PowerCenter Integration Service converts it to a double.
NUM64U
19
Decimal
Precision 1 to 28 digits, scale 0 to 28
Decimal value with declared precision and scale. Scale must be less than or equal to precision. If you pass a value with negative scale or declared precision greater than 28, the PowerCenter Integration Service converts it to a double.
NUMCHAR
-
String
1 to 104,857,600 characters
Fixed-length or varying-length string.
PACKED
15
Decimal
Precision 1 to 28 digits, scale 0 to 28
Decimal value with declared precision and scale. Scale must be less than or equal to precision. If you pass a value with negative scale or declared precision greater than 28, the PowerCenter Integration Service converts it to a double.
TIME
5
Date/Time
Jan 1, 0001 A.D. to Dec 31, 9999 A.D.
Combined date/time value, with precision to the nanosecond.
TIMESTAMP
5
Date/Time
Jan 1, 0001 A.D. to Dec 31, 9999 A.D.
Combined date/time value, with precision to the nanosecond.
UPACKED
15
Decimal
Precision 1 to 28 digits, scale 0 to 28
Decimal value with declared precision and scale. Scale must be less than or equal to precision. If you pass a value with negative scale or declared precision greater than 28, the PowerCenter Integration Service converts it to a double.
UZONED
15
Decimal
Precision 1 to 28 digits, scale 0 to 28
Decimal value with declared precision and scale. Scale must be less than or equal to precision. If you pass a value with negative scale or declared precision greater than 28, the PowerCenter Integration Service converts it to a double.
VARBIN
10
Binary
1 to 104,857,600 bytes
You can pass binary data from a source to a target, but you cannot perform transformations on binary data. PowerCenter does not support binary data for COBOL or flat file sources.
VARCHAR
10
String
1 to 104,857,600 characters
Fixed-length or varying-length string.
ZONED
15
Decimal
Precision 1 to 28 digits, scale 0 to 28
Decimal value with declared precision and scale. Scale must be less than or equal to precision. If you pass a value with negative scale or declared precision greater than 28, the PowerCenter Integration Service converts it to a double.