I have a DB2 query that takes date parameter as input. for some reason, it throws error saying Numeric Value out of range. Date value - 2018-05-21 17:33:56.2463440 little bit of query - Snapshot from SSIS
" SELECT LPAD(i.abc, 13, '0') AS abc,
LPAD(i.abc,9,'0') AS abc,
b.abc,
i.abc,
i.abc,
i.abc,
i.abc,
i.abc,
i.abc,
i.abc,
i.abc,
sd.abc
FROM abc.abci LEFT OUTER JOIN abc.abc b
ON i.abc= b.abc,
abc.abc f
INNER JOIN abc.abc v ON
i.abc= v.abc
,abc.abc md,
abc.abc sd
WHERE
i.abc= 'A'
AND i.abc= 'N'
AND i.abc= 'Y'
AND i.abc= f.abc
AND i.abc= f.abc
AND i.abc= f.abc
AND i.abc=f.abc
AND i.abc= v.abc
AND i.last_update_ts > ? "
last_update_ts - datatype is - timestamp(6) in source.
the above query works when we hard code the date as
i.last_update_ts > '2018-05-21 17:33:56.2463440'
But, it is throwing an error when it is passing through a parameter.
