Home Page for the TeradataForum

Archives of the TeradataForum

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

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

Subj:   Re: Signed numeric data
From:   David Roth


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.


  <Prev Next>   <<First <Prev Next> Last>>  
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 15 Jun 2023