Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi im wondering what the sql code would be if i wanted to make a field negative (-) based on a flag. Because by default all values in the database are positive (+).
The conditions are if DRCR_FLG = -1 then the OSBASE_AMT should be negative, if DRCR_FLG = 1 then the OSBASE_AMT should be positive.
Currently my load script looks like the following:
-----------
TRANSACTIONS:
Load
DRCR_FLG,
OSBASE_AMT,
SQL SELECT * FROM ALI.TRX;
----------------
Regards
Jason
Try:
TRANSACTIONS:
Load
DRCR_FLG * OSBASE_AMT as OSBASE_AMT
SQL SELECT * FROM ALI.TRX;
Try:
TRANSACTIONS:
Load
DRCR_FLG * OSBASE_AMT as OSBASE_AMT
SQL SELECT * FROM ALI.TRX;
ihave the same concept of prob
instead of flag field
i use the code value of the field for determining
this is my prob