| output and automate scripts [message #373359] |
Thu, 12 April 2001 09:07 |
sonia
Messages: 22
Registered: March 2001
|
Junior Member |
|
|
Hi,
I'm wanting to run a programme to sum a column total, then update the column and finally to sum the column total again to check that the update has worked. At the moment the scripts are all individual and will need to be run one after the other and the sum values manually entered into Excel. What I am looking for is a way of outputting or capturing the sum value into a file that can then be exported to Excel then going on to update the column and then finally output the 2nd summary again to a file. Does anyone know the best way of automating this? I have provided an example of the individual scripts.
Feel free to comment on improving these as well.
-summary code
select sum (total)
from value a, branch b
where a.dept = b.dept
and b.code = 'SB'
---update code
update value
set total = total*12
where dept in (select dept in branch where code = 'SB'
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
