How can i store the value returned by sql statement in a variable.

svpriyan

Hai,
I have two columns called income and tax in DB2 database . now i wanted to retrieve both two columns using java and do subtraction and store them in a column called net pay.
i got some hint like ,first i have to retrieve 2 columns records and store them in variables and then do calculation. is this way i have to do.
any hints please
priya

debasisdas

try direct subtraction, something like

select income, tax,(income - tax ) as netpay from salary

How can i store the value returned by sql statement in a variable.

re: How can i store the value returned by sql statement in a variable.

Similar DB2 Database bytes

/bytes/development

/bytes/it

/bytes/about