dbaltlen

Description

Return the maximum length of the data for a particular compute column.

Syntax

DBINT dbaltlen(dbproc, computeid, column)
 
DBPROCESS      *dbproc;
int                         computeid;
int                         column;

Parameters

dbproc

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.

computeid

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.

column

The number of the column of interest. The first column is number 1.

Returns

The maximum length, in bytes, possible for the data in a particular compute column. dbaltlen returns -1 if there is no such column or compute clause.

Usage

This routine returns the maximum length for a column in a compute row. In the case of variable length data, this is not necessarily the actual length of the data, but rather the maximum length. For the actual data length, use dbadlen.

For example, given the SQL statement:

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

the call dbaltlen(dbproc, 1, 1) returns 4 because counts are of SYBINT4 type, which is 4 bytes long.

See also

dbadata, dbadlen, dbalttype, dbgetrow, dbnextrow, dbnumalts