Archives of the TeradataForum
Message Posted: Sun, 25 Oct 1999 @ 01:09:24 GMT
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.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|