User Response: None.
ANR2952E The value ’value’ (data type data type) is not a valid character string
representation of an SQLdate or a timestamp for operator ’operator’.
Explanation: An invalid character string representation of a DATEor
TIMESTAMPwas specified. For example, the string ’abc’ is neither a valid date nor
a timestamp.
SystemAction: The SQL query is terminated.
User Response: None.
ANR2953E The value ’value’ (data type data type) is not a valid character string
representation of an SQLtime or a timestamp for operator ’operator’.
Explanation: An invalid character string representation of a TIME or
TIMESTAMPwas specified. For example, the string ’g pm’ is neither a valid time
nor a timestamp.
SystemAction: The SQL query is terminated.
User Response: None.
ANR2954E An SQLsubquery used in a scalar expression must yield a table that contains
at most one row.
Explanation: This error results when a subquery used in a scalar expression
returns multiple rows, thereby making it ambiguous as to which value should be
returned.
SystemAction: The SQL query is terminated.
User Response: Respecify the subquery (for example, using the WHERE clause)
so that the subquery returns at most one row.
ANR2955E The SQLcharacter string expression ’expression’ must return a single
character.
Explanation: Asingle-character character string was expected for the ESCAPE
clause of the LIKE operator, for the trim character of theTRIM operator, or for the
pad character of the LEFT or RIGHT function. For example, the string ’Hello’ is
invalid because it contains multiple characters.
SystemAction: The SQL query is terminated.
User Response: None.
425
Tivoli Storage Manager Messages
3. Common and Platform
Specfic Messages