Return the column ID for a compute column.
int dbaltcolid(dbproc, computeid, column) DBPROCESS *dbproc; int computeid; int column;
A pointer to the DBPROCESS structure that provides the connection for a particular front end/server process. It contains all the information that DB-Library uses to manage communications and data between the front end and server.
The ID that identifies the particular compute row of interest. A SQL select statement may have multiple compute clauses, each of which returns a separate compute row. The computeid corresponding to the first compute clause in a select is 1. The computeid is returned by dbnextrow or dbgetrow.
The number of the compute column of interest. The first column in a select list is 1.
The select list ID for the compute column. The first column in a select list is 1. If either the computeid or the column value is invalid, dbaltcolid returns -1.
This routine returns the select list ID for a compute column. For example, given the SQL statement:
select dept, name from employee
order by dept, name
compute count(name) by dept
the call dbaltcolid(dbproc, 1, 1) will return 2, since “name” is the second column in the select list.
dbadata, dbadlen, dbaltlen, dbgetrow, dbnextrow, dbnumalts, dbprtype
