ct_compute_info

Description

Retrieve compute result information.

Syntax

CS_RETCODE ct_compute_info(cmd, type, colnum, buffer,
                 buflen, outlen)
 CS_COMMAND      *cmd;
 CS_INT                    type;
 CS_INT                   colnum;
 CS_VOID                *buffer;
 CS_INT                    buflen;
 CS_INT                   *outlen;

Parameters

Returns

ct_compute_info returns the following values:

Examples

Example 1

Assume that the following command has been executed:

select dept, name, year, sales from employee 

           order by dept, name, year 

           compute count(name) by dept, name

1. The call:

   CS_INT      mybuffer;
   

   ct_compute_info(cmd, CS_BYLIST_LEN, CS_UNUSED,
   

           &mybuffer, CS_UNUSED, CS_UNUSED);
   

   sets mybuffer to 2, because there are two items in the bylist.

2. The call:

   CS_SMALLINT    mybuffer[2];
   

    CS_INT         outlength;
   

   ct_compute_info(cmd, CS_COMP_BYLIST, CS_UNUSED,
   

            mybuffer, sizeof(mybuffer), &outlength)
   

   copies the CS_SMALLINT values 1 and 2 into mybuffer[0] and mybuffer[1] to indicate that the bylist is composed of columns 1 and 2 from the select list.

3. The call:

   CS_INT      mybuffer;
   

   ct_compute_info(cmd, CS_COMP_COLID, 1, &mybuffer,
   

           CS_UNUSED,NULL);
   

   sets mybuffer to 2, since name is the second column in the select list.

4. The call:

   CS_INT     mybuffer;
   

   ct_compute_info(cmd, CS_COMP_ID, CS_UNUSED,
   

            &mybuffer, CS_UNUSED, NULL);
   

   sets mybuffer to 1 because there is only a single compute clause in the select statement.

5. The call:

   CS_INT    mybuffer;
   

   ct_compute_info(cmd, CS_COMP_OP, 1, &mybuffer,
   

           CS_UNUSED, NULL);
   

   sets mybuffer to the symbolic value CS_OP_COUNT, since the aggregate operator for the first compute column is a count.

Usage

• Compute rows result from the compute clause of a select statement. A compute clause generates a compute row every time the value of its by column-list changes. A compute row contains one column for each aggregate operator in the compute clause. If a select statement contains multiple compute clauses, separate compute rows are generated by each clause.

  Each compute row returned by the server is considered to be a distinct result set. That is, each result set of type CS_COMPUTE_RESULT will contain exactly one row.

• It is only legal to call ct_compute_info when compute information is available; that is, after ct_results returns CS_COMPUTE_RESULT or CS_COMPUTEFMT.

• Each section below contains information about a particular type of compute result information.

• A select statement’s compute clause may contain the keyword by, followed by a list of columns. This list, known as the bylist, divides the results into subgroups, based on changing values in the specified columns. The compute clause’s aggregate operators are applied to each subgroup, generating a compute row for each subgroup.

• The select-list column ID for a compute column is the position within the select-list of the column from which the compute column derives.

• A SQL select statement can have multiple compute clauses, each of which returns a separate compute row. The compute ID corresponding to the first compute clause in a select statement is 1.

See also