dbaltop

Returns the type of aggregate function for a compute column.

Syntax

INT dbaltop (
PDBPROCESS
dbproc,
INT
computeid,
INT
column );

where

dbproc
The DBPROCESS structure that is the handle for a particular workstation/ SQL Server process. It contains all the information that DB-Library uses to manage communications and data between the workstation and SQL Server.
computeid
The ID that identifies the COMPUTE clause. A SELECT statement can have multiple COMPUTE clauses, which can have varying numbers of aggregate operators and aggregate targets. The computeid is returned by dbnextrow or dbgetrow.
column
The number of the column. The first column is number 1.

Returns

The type of aggregate operator for the particular column in the compute. The types are defined as follows:

Type Aggregate operator
SQLAOPSUM SUM
SQLAOPAVG AVG
SQLAOPCNT COUNT
SQLAOPMIN MIN
SQLAOPMAX MAX

Call dbaltop only after dbnextrow or dbgetrow returns a computeid.

If computeid or column is not valid, -1 is returned.

Example

After the following SELECT, calling dbaltop(dbproc, 1, 1) returns the type for COUNT since the first aggregate operator in the first COMPUTE clause is COUNT:

select dept, name from employee
order by dept, name
compute count(name) by dept

To convert the type to a readable string, use dbprtype.

See Also

dbadata, dbadlen, dbaltlen, dbgetrow, dbnextrow, dbnumalts, dbprtype