Sign missing

Marcus426 · Post by **Marcus426** » Tue Sep 22, 2009 2:15 pm

HI all,

I have a source file. I am reading the file using seqential stage,one of the columns has a datatype double and contains amounts with '+' or '-' signs. when i view the data it is showing fine, but after sorting the file using a sort stage based on a different key column, in the output the '+' and '-' are missing. Can anyone help me out what might be the reason( the target field is also set to double with size same as the input).

Thanks!

chulett · Post by **chulett** » Tue Sep 22, 2009 2:44 pm

The target is what - another sequential file, database table? And the signs are leading or trailing signs? Also, are you sure they are all "missing" or is it just the plus signs?

Marcus426 · Post by **Marcus426** » Tue Sep 22, 2009 3:01 pm

chulett wrote:The target is what - another sequential file, database table? And the signs are leading or trailing signs? Also, are you sure they are all "missing" or is it just the plus signs? ...

The target is sequential file. The signs are leading. only the signs are missing.

Sainath.Srinivasan · Post by **Sainath.Srinivasan** » Tue Sep 22, 2009 3:18 pm

By default DataStage provides blank for +ve and a minus (hyphen) for -ve.

As Craig raised, do you see either -ve or not ?

What is the datatype of the target field ?

Marcus426 · Post by **Marcus426** » Tue Sep 22, 2009 3:30 pm

sorry guys! I was a little blind. The negatives were there but some how slipped past my eyes. Once again thanks a lot for your time.