Constant Column Mode

Constant Column Mode is an advanced property that is hidden by default. For information on how to display this property, see Viewing and Changing Advanced VLDB Properties.

Constant Column Mode allows you to choose whether or not to use a GROUP BY and how the GROUP BY should be constructed when working with a column that is a constant. The GROUP BY can be constructed with the column, alias, position numbers, or column expression. Most users do not need to change this setting. It is available to be used with the new Generic DBMS object and if you want to use a different GROUP BY method when working with constant columns.

Levels at Which You Can Set This

Database instance, report, and template

Pure select, no GROUP BY (default)

Copy

insert into ZZTP00 
select a11.QUARTER_ID QUARTER_ID, 0 XKYCGT, 
sum(a11.REG_SLS_DLR) WJXBFS1 
from SALES_Q1_2002 a11 
group by a11.QUARTER_ID 
insert into ZZTP00 
select a11.QUARTER_ID QUARTER_ID, 1 XKYCGT, 
sum(a11.REG_SLS_DLR) WJXBFS1 
from SALES_Q2_2002 a11 
group by a11.QUARTER_ID

Use max, no GROUP BY

Copy

insert into ZZTP00 
select a11.QUARTER_ID QUARTER_ID, MAX(0) XKYCGT, 
sum(a11.REG_SLS_DLR) WJXBFS1 
from SALES_Q1_2002 a11 
group by a11.QUARTER_ID 
insert into ZZTP00 
select a11.QUARTER_ID QUARTER_ID, MAX(1) XKYCGT, 
sum(a11.REG_SLS_DLR) WJXBFS1 
from SALES_Q2_2002 a11 
group by a11.QUARTER_ID

GROUP BY column (expression)

Copy

insert into ZZTP00 
select a11.QUARTER_ID QUARTER_ID, 0 XKYCGT, 
sum(a11.REG_SLS_DLR) WJXBFS1 
from SALES_Q1_2002 a11 
group by a11.QUARTER_ID, 0 
insert into ZZTP00 
select a11.QUARTER_ID QUARTER_ID, 1 XKYCGT, 
sum(a11.REG_SLS_DLR) WJXBFS1 
from SALES_Q2_2002 a11 
group by a11.QUARTER_ID, 1

GROUP BY alias

Copy

insert into ZZTP00 
select a11.QUARTER_ID QUARTER_ID, 0 XKYCGT, 
sum(a11.REG_SLS_DLR) WJXBFS1 
from SALES_Q1_2002 a11 
group by a11.QUARTER_ID, XKYCGT 
insert into ZZTP00 
select a11.QUARTER_ID QUARTER_ID, 1 XKYCGT, 
sum(a11.REG_SLS_DLR) WJXBFS1 
from SALES_Q2_2002 a11 
group by a11.QUARTER_ID, XKYCGT

GROUP BY position

Copy

insert into ZZTP00 
select a11.QUARTER_ID QUARTER_ID, 0 XKYCGT, 
sum(a11.REG_SLS_DLR) WJXBFS1 
from SALES_Q1_2002 a11 
group by a11.QUARTER_ID, 2 
insert into ZZTP00 
select a11.QUARTER_ID QUARTER_ID, 1 XKYCGT, 
sum(a11.REG_SLS_DLR) WJXBFS1 
from SALES_Q2_2002 a11 
group by a11.QUARTER_ID, 2