Tivoli Audio Version 3 Release 7 - page 446

User Response: None.
ANR2921E The SQLdata type of expression ’expression’isdatatype; expecting a character
string expression.
Explanation: An SQL expression of character string type CHAR orVARCHAR is
expected.
SystemAction: The SQL query is terminated.
User Response: None.
ANR2922E The SQLdata type of expression ’expression’isdatatype; expecting a date,
timestamp, character string date, character string timestamp, or interval
expression.
Explanation: An SQL expression was expected of one of the types DATE,
TIMESTAMP,CHAR, VARCHAR, or INTERVALas the operand to the EXTRACT
function. 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.
ANR2923E The SQLdata type of expression ’expression’isdatatype; expecting a time,
timestamp, character string time, character string timestamp, or interval
expression.
Explanation: An SQL expression was expected of one of the typesTIME,
TIMESTAMP,CHAR, VARCHAR, or INTERVALas the operand to the EXTRACT
function. In the case of CHAR or VARCHAR,the expression must be a valid
character string representation of a time or a timestamp.
SystemAction: The SQL query is terminated.
User Response: None.
ANR2924E The SQLdata type of expression ’expression’isdatatype; expecting a date or
character string date expression.
Explanation: An SQL expression was expected of one of the types DATE,CHAR,
or VARCHAR.In the case of CHAR or VARCHAR, the expression must be a valid
character string representation of a date.
SystemAction: The SQL query is terminated.
User Response: None.
418 Version 3 Release 7