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 sample program, see the leading comments in the sample source file.
This sample requires the pubs2 database.