ANR2934E The result data type of a CASE expression can not be determined; at least one
non-null THEN or ELSE expression must be specified.
Explanation: The result data type of a CASE expression can not be determined
because all of the THEN expressions and the ELSE expression (if present) specifies
the NULL key word.
SystemAction: The SQL query is terminated.
User Response: None.
ANR2935E The date-time field field is not present in the expression ’expression’(data type
data type).
Explanation: The specified date-time field (YEAR, MONTH, DAY,HOUR,
MINUTE, or SECOND) is not contained in the data type of the expression.
SystemAction: The SQL query is terminated.
User Response: None.
ANR2936E The SQLaggregate function function can not be nested within another
aggregate function.
Explanation: One of the aggregate functions COUNT,MAX, MIN, SUM, AVG,
VARIANCE,or STDDEV was found nested within another aggregate expression.
SystemAction: The SQL query is terminated.
User Response: None.
ANR2937E An SQLsubquery expression can not be nested within an aggregate function.
Explanation: An expression containing a subquery was found nested within one of
the aggregate functions COUNT,MAX, MIN, SUM, AVG, VARIANCE,or
STDDEV.
SystemAction: The SQL query is terminated.
User Response: None.
ANR2938E The column ’column’ is not allowed in this context; it must either be named in
the GROUPBY clause or be nested within an aggregate function.
Explanation: Acolumn reference was specified that is neither a column specified
in a GROUP BYclause nor is a column nested in one of the aggregate functions
COUNT,MAX, MIN, SUM, AVG, VARIANCE,or STDDEV. The use of the
421
Tivoli Storage Manager Messages
3. Common and Platform
Specfic Messages