DBPROP_GROUPBY

Property group: Data Source Information

Property set: DBPROPSET_DATASOURCEINFO

Type: VT_I4

Typical R/W: R

Description: GROUP BY Support

Indicates the relationship between the columns in a GROUP BY clause and the nonaggregated columns in the select list. One of the following:

• DBPROPVAL_GB_EQUALS_SELECT—The GROUP BY clause must contain all nonaggregated columns in the select list. It cannot contain any other columns—for example, SELECT DEPT, MAX(SALARY) FROM EMPLOYEE GROUP BY DEPT.
• DBPROPVAL_GB_COLLATE—A COLLATE clause can be specified at the end of each grouping column.
• DBPROPVAL_GB_CONTAINS_SELECT—The GROUP BY clause must contain all nonaggregated columns in the select list. It can contain columns that are not in the select list—for example, SELECT DEPT, MAX(SALARY) FROM EMPLOYEE GROUP BY DEPT, AGE.
• DBPROPVAL_GB_NO_RELATION—The columns in the GROUP BY clause and the select list are not related. The meaning of nongrouped, nonaggregated columns in the select list is data source object–dependent—for example, SELECT DEPT, SALARY FROM EMPLOYEE GROUP BY DEPT, AGE.