Signed numeric

pavan31081980 · Post by **pavan31081980** » Tue Oct 27, 2009 2:44 am

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

ArndW · Post by **ArndW** » Tue Oct 27, 2009 2:49 am

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?

mgendy · Post by **mgendy** » Tue Oct 27, 2009 4:01 am

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

gssr · Post by **gssr** » Tue Oct 27, 2009 4:05 am

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