Provides a one-call interface to the table space container query data. The query data for all containers in a table space, or for all containers in all table spaces, is returned in an array.
In a partitioned database environment, only the table spaces on the current database partition are listed.
Database
sqlutil.h
SQL_API_RC SQL_API_FN
sqlbtcq (
struct sqlca * pSqlca,
sqluint32 TablespaceId,
sqluint32 * pNumContainers,
struct SQLB_TBSCONTQRY_DATA ** ppContainerData);
SQL_API_RC SQL_API_FN
sqlgtcq (
struct sqlca * pSqlca,
sqluint32 TablespaceId,
sqluint32 * pNumContainers,
struct SQLB_TBSCONTQRY_DATA ** ppContainerData);
If sufficient memory is available, this function returns the number of containers, and a pointer to the memory location of the table space container query data. It is the user's responsibility to free this memory with a call to sqlefmem. If sufficient memory is not available, this function simply returns the number of containers, and no memory is allocated. If this should happen, use sqlbotcq, sqlbftcq, and sqlbctcq to fetch less than the whole list at once.