DB2 Conversion (Integer)

Hi,

We try to load data from a text file onto a DB2 database. In this specific case the data we load is identified as INTEGER on DB2, but in the text file we have 10 digits / characters.

Is there a routine to load these digits into a DB2 column with INTEGER format? We understand that the an INTEGER can hold up to 10 digits, but whenever we try to load the data, the result we see in DB2 is not what we had in the text file. We also understand that there is some compression going on, but we do not know when and where.

Could you please let us know, if there is any routine for loading such data?

Thanks a lot,
Andrea