ANR2943E The column reference ’column reference’is a duplicate of another SQL column
name in the same list.
Explanation: Aduplicate column reference was specified within the same GROUP
BY or ORDER BYlist of columns.
SystemAction: The SQL query is terminated.
User Response: None.
ANR2944E The reference ’reference’is an unknown SQL scalar function name.
Explanation: The specified function reference is not the name of a valid scalar
function.
SystemAction: The SQL query is terminated.
User Response: None.
ANR2945E Toofew arguments are specified for SQL scalar function function.
Explanation: Toofew function arguments were specified. For example, the
expression LEFT(x) is invalid because the LEFT function requires at least two
arguments.
SystemAction: The SQL query is terminated.
User Response: None.
ANR2946E Toomany arguments are specified for SQL scalar function function.
Explanation: Toomany function arguments were specified. For example, the
expression UPPER(x,y) is invalid because the UPPER function requires exactly one
argument.
SystemAction: The SQL query is terminated.
User Response: None.
ANR2947E Division by zero was detected for operator ’operator’.
Explanation: An attempt to divide by the number zero was detected for the
specified SQL operator.The most likely cause of the problem is that one of the
values of a column is zero, and that column is used in the denominator of a division
operation. Toprotect against this case the NULLIF function can be used. For
example, instead of the expression 1/X, specify 1/NULLIF(X,0), which will set the
expression to null whenever the value if X is zero.
SystemAction: The SQL query is terminated.
423
Tivoli Storage Manager Messages
3. Common and Platform
Specfic Messages