01 var1 pic s9(9)v99.
01 var2 pic x(30).
procedure division.
move 12345.99 to var1.
move12345.99 to var2.
display var1.
display var2.
what is the output?
i have a table like this. i want to output like this
c1 c2 c1 c2
1 10 1 10
2 20 2 30
3 30 3 60
4 40 4 100
5 5 5 105
c1 and c2 are columns in a table .i want output like this
c2 values are 10,10+20,10+20+30,10+20+30+40.10+20+30+40+5.
write a sql query.pls help this
i want urgent.