For numeric data, the Secure Agent uses the SAS format assigned to the column to determine the right precision and scale values.
For example, if the SAS format of a numeric column is 10.2, the column is represented using 10 positions in total, including a decimal point and two digits after the decimal point. This is translated to a precision of 9 and a scale of 2.
If no format is assigned to a numeric column, the Secure Agent assigns a default precision of 10 and scale of 0. This might not be adequate to hold the data. Adjust the precision and scale manually to get a definition for the column that is adequate to hold the data you expect for the column.