Can a modify stage be used to add or subtract two fields together into a new value? I'm getting the following error:
main_program: Error parsing modify adapter: Expected ';' or end, got: "-"; input:
trans_dt = trans_dt
;
store_nbr = storenum
;
wrkstatn_nbr = wrkstanum
;
store_id = storenum
;
func_id = functype
;
Prsnl_scnr_used_ind = Handle_Null(IND08, 0)
;
trans_qty = trans_qty
;
sls_amt = TotGrossPos - TotGrossNeg
;
sls_qty = sls_qty
;
obviously the error is related to the sls_amt calculation. Is this an indication that this type of calculation is not allowed in the Modify stage?
Arithmetic with Modify Stage?
Moderators: chulett, rschirm, roy
Arithmetic with Modify Stage?
You can use modify stage for only follwing things
Dropping or Editing Columns
Changing Datatype
Null Handling
I guess it can't be used for Arithmetic Operations.
Regards
Ashwin
Dropping or Editing Columns
Changing Datatype
Null Handling
I guess it can't be used for Arithmetic Operations.
Regards
Ashwin
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Almost nothing with two operands can be accomplished in the Modify stage. About the only exception is handle_null().
Substring is possible; concatenation is not. String length, raw length are possible.
Arithmetic using arithmetic operators is definitely not possible in a Modify stage.
Substring is possible; concatenation is not. String length, raw length are possible.
Arithmetic using arithmetic operators is definitely not possible in a Modify stage.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.