i have a mainframe file that has spaces in the last column , these spaces needs to be loaded to the teradata table decimal column Decimal(15,6). The mainframe job uses Fload , the fload is failing , all records are being loaded to the ERR1
,GPWE15_LOC_CURR_A (DECIMAL(15,6)) --> spaces
DECIMAL is a data type that requires values in the proper format.
"spaces" are not valid data bytes for a DECIMAL column.