Archives of the TeradataForum

Message Posted: Sun, 25 Oct 1999 @ 01:09:24 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

Mike,

If you have the option, format the Bull output using a -99999 format, that will force the sign to the first character as plus or minus.

If the other mentioned format 99999S doesn't work (I haven't tried that) the long workaround is to process the field as two fields; I have seen that solution done before, i.e. field one as 99999 and field two as X. Use field two value to modify field one value as in if A then field one plus 1, if J then field one plus 1 times -1. It's long and nasty, but works if no other choice. Better now that we have CASE statements.

Dave

	<Prev	Next>		<<First	<Prev	Next>	Last>>