The compute.c sample program demonstrates processing of compute results and performs the following:
It sends a canned query to the server using a language command.
It processes the results using the standard ct_results while loop.
It binds the column values to program variables.
It fetches and displays the rows in the standard ct_fetch while loop.
Following is the canned query:
select type, price from titles
where type like "%cook"
order by type, price
compute sum(price) by type
compute sum(price)
This query returns both regular rows and compute rows. The
compute rows are generated by the two compute
clauses:
The first compute
clause
generates a compute row each time the value of type changes:
compute sum(price) by type
The second compute
clause
generates one compute row, which is the last to be returned:
compute sum(price)
For more information about this program, see the leading comments in the example source file.
This sample program requires the pubs2 database.