I am trying to MLOAD some data from a mainframe file onto a teradata table. I'm entcountering a COMP field which simply doesnt load into the table. It is an amount field and is defined in mainframe as S9(13)V99 and has values of 0.00.
The field in the table as well as the input file definition is defined as DECIMAL (15,2) but when i run the job, I get a MLOAD error 2679 and the rows go into the error table.
Someone help me decide how i should define the field in the input file layout, as I think that is where the key lies.
I did also have the same file layout once. I suppose you cannot load a COMP value in Teradata.
For e.g : a value defined in copybook as S9(9) will be represented as 000D 0070 i.e it will occupy 4 bytes and you cannot define it as DECIMAL(9,0) in your TD table as it will then expect a 5 byte record. Moreover defining the field as DECIMAL(8,0) also is wrong since its a S9(9).
So the best way is to request the source system to change the filed layout to COMP-3 and then you can load it.
But again if there is any way to load the COMP values I am not aware.