ANR2925E The SQLdata type of expression ’expression’isdatatype; expecting a time or
character string time expression.
Explanation: An SQL expression was expected of one of the typesTIME, CHAR,
or VARCHAR.In the case of CHAR or VARCHAR, the expression must be a valid
character string representation of a time.
SystemAction: The SQL query is terminated.
User Response: None.
ANR2926E The SQLdata type of expression ’expression’isdatatype; 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.
SystemAction: The SQL query is terminated.
User Response: None.
ANR2927E The SQLdata type of expression ’expression’isdatatype; expecting an interval
containing a single date-time field.
Explanation: An SQL expression was expected of data type INTERVALYEAR,
INTERVALMONTH, INTERVALDAY, INTERVALHOUR, INTERVALMINUTE,
or INTERVALSECOND, all of which contain a single date-time field. Multi-field
interval types (for example, INTERVALDAYTO SECOND) are not allowed.
SystemAction: The SQL query is terminated.
User Response: None.
ANR2928E Anumber 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,
INTERVALDAYTO SECOND). Only the single-field interval types INTERVAL
YEAR, INTERVALMONTH, INTERVALDAY, INTERVALHOUR, INTERVAL
MINUTE, or INTERVALSECOND can be specified.
SystemAction: The SQL query is terminated.
User Response: None.
419
Tivoli Storage Manager Messages
3. Common and Platform
Specfic Messages