Filter
Top Products
ANR2925E The SQL data type of expression ’expression’isdata type; expecting a time or
character string time expression.
Explanation: An SQL expression was expected of one of the types TIME, CHAR,
or VARCHAR. In the case of CHAR or VARCHAR, the expression must be a valid
character string representation of a time.
System Action: The SQL query is terminated.
User Response: None.
ANR2926E The SQL data type of expression ’expression’isdata type; expecting a date,
timestamp, character string date, or character string timestamp expression.
Explanation: An SQL expression was expected of one of the types DATE,
TIMESTAMP, CHAR, or VARCHAR. In the case of CHAR or VARCHAR, the
expression must be a valid character string representation of a date or a timestamp.
System Action: The SQL query is terminated.
User Response: None.
ANR2927E The SQL data type of expression ’expression’isdata type; expecting an interval
containing a single date-time field.
Explanation: An SQL expression was expected of data type INTERVAL YEAR,
INTERVAL MONTH, INTERVAL DAY, INTERVAL HOUR, INTERVAL MINUTE,
or INTERVAL SECOND, all of which contain a single date-time field. Multi-field
interval types (for example, INTERVAL DAY TO SECOND) are not allowed.
System Action: The SQL query is terminated.
User Response: None.
ANR2928E A number can not be converted to SQL data type INTERVAL if the interval
contains multiple date-time fields.
Explanation: An attempt was made to convert a number to the data type
INTERVAL, but the target interval contains multiple date-time fields (for example,
INTERVAL DAY TO SECOND). Only the single-field interval types INTERVAL
YEAR, INTERVAL MONTH, INTERVAL DAY, INTERVAL HOUR, INTERVAL
MINUTE, or INTERVAL SECOND can be specified.
System Action: The SQL query is terminated.
User Response: None.
419
Tivoli Storage Manager Messages
3. Common and Platform
Specfic Messages