Tivoli Audio Version 3 Release 7 Portable Media Storage User Manual


  Open as PDF
of 1473
 
ANR2943E The column reference column reference is a duplicate of another SQL column
name in the same list.
Explanation: A duplicate column reference was specified within the same GROUP
BY or ORDER BY list of columns.
System Action: 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.
System Action: The SQL query is terminated.
User Response: None.
ANR2945E Too few arguments are specified for SQL scalar function function.
Explanation: Too few function arguments were specified. For example, the
expression LEFT(x) is invalid because the LEFT function requires at least two
arguments.
System Action: The SQL query is terminated.
User Response: None.
ANR2946E Too many arguments are specified for SQL scalar function function.
Explanation: Too many function arguments were specified. For example, the
expression UPPER(x,y) is invalid because the UPPER function requires exactly one
argument.
System Action: 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. To protect 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.
System Action: The SQL query is terminated.
423
Tivoli Storage Manager Messages
3. Common and Platform
Specfic Messages