DB2 USER DEFINED SQL
Posted: Thu Oct 12, 2006 1:05 pm
HI ALL,
I AM FACING A PROBLEM IN EXECUTING THE FOLLOWING USERDEFINED SQL WHICH I GAVE IN DB2 STAGE USING CASE EXPRESSION THE SQL IS AS BELOW:
CASE
WHEN
DEP_DATETIME BETWEEN CAST('2006-10-12 00:00:00.000000' AS TIMESTAMP) - 28 DAYS
AND CAST('2006-10-12 00:00:00.000000' AS TIMESTAMP) - 21 DAYS
THEN 'N'
WHEN
DEP_DATETIME BETWEEN CAST('2006-10-12 00:00:00.000000' AS TIMESTAMP) - 35 DAYS
AND CAST('2006-10-12 00:00:00.000000' AS TIMESTAMP) - 28 DAYS
THEN 'U'
ELSE DEP_DATETIME
END INDICATOR_FLAG
I AM GETTING THE ERROR AS
"THE SYNTAX OF THE STRING REPRESENTATION OF DATETIME VALUE IS INCORRECT"
AS WHEN IT SATISFIES THE TWO CONDITIONS THEN IT SHOULD RETURN N OR U ELSE IT SHOIULD RETURN THE SAME DATE WHICH IS IN THE "DEP_DATETIME"COLUMN.
tHANKS FOR UR HELP
I AM FACING A PROBLEM IN EXECUTING THE FOLLOWING USERDEFINED SQL WHICH I GAVE IN DB2 STAGE USING CASE EXPRESSION THE SQL IS AS BELOW:
CASE
WHEN
DEP_DATETIME BETWEEN CAST('2006-10-12 00:00:00.000000' AS TIMESTAMP) - 28 DAYS
AND CAST('2006-10-12 00:00:00.000000' AS TIMESTAMP) - 21 DAYS
THEN 'N'
WHEN
DEP_DATETIME BETWEEN CAST('2006-10-12 00:00:00.000000' AS TIMESTAMP) - 35 DAYS
AND CAST('2006-10-12 00:00:00.000000' AS TIMESTAMP) - 28 DAYS
THEN 'U'
ELSE DEP_DATETIME
END INDICATOR_FLAG
I AM GETTING THE ERROR AS
"THE SYNTAX OF THE STRING REPRESENTATION OF DATETIME VALUE IS INCORRECT"
AS WHEN IT SATISFIES THE TWO CONDITIONS THEN IT SHOULD RETURN N OR U ELSE IT SHOIULD RETURN THE SAME DATE WHICH IS IN THE "DEP_DATETIME"COLUMN.
tHANKS FOR UR HELP