DSXchange

Hi

i have data in the sequential file with signed numeric data type in 4 out of 20 columns. Could you please let me know the correct data type which i have to declare in the sequential file stage for those columns with signed numeric data.Thanks in advance

Regards,
Pavan

Decimal or Integer, depending on whether or not you have integer values or not. Are the signs leading, trailing and are there spaces in the values?

if the data contains no decimal , use integer , if it contains decimal values , use decimal or double , but i prefere double because it doesn't preserve space for the datatype like decimal , it preserve space for the value it contains , so use double without specifying size or precision

Can use varchar datatype to read it through the sequential file and then use type conversion which is relevant to your requirement..