Через ODBС с Informatica хочу выбрать данные по фильтру даты и не получается. как верное его задать?
По всем этим условиям ошибка всегда:
timestamp> cast('2012-11-10' as date)
timestamp> '2012-11-10'
timestamp> to_date('2012-11-10','YYYY-MM-DD')


Thread: READER_1_1_1
Process ID: 12737
Message Code: RR_4035
Message: SQL Error [
FnName: Prepare -- [Cache ODBC][State : 37000][Native Code 4]
[libcacheodbc.so]
[SQLCODE: <-4>:<A term expected, beginning with one of the following: identifier, constant, aggregate, %ALPHAUP, %EXACT, %MVR, %SQLSTRING, %SQLUPPER, %STRING, %UPPER, $$, :, +, -, (, NOT, EXISTS, or FOR>]
[Location: <Prepare>]
[%msg: < A term expected, beginning with either of: (, NOT, EXISTS, or FOR^SELECT DBO . IAPPLICATIONSTAT . TIMESTAMP , DBO . IAPPLICATIONSTAT . APPLICATIONID , DBO . IAPPLICATIONSTAT . APPLICATION , DBO . IAPPLICATIONST].

как же верно его задать?

Так как правильно задать фильтр в PC Informatica ?
Как не задаю ошибка:

SQ instance [SQ_IAPPLICATIONSTAT] SQL Query [SELECT DBO.IAPPLICATIONSTAT.TIMESTAMP, DBO.IAPPLICATIONSTAT.APPLICATIONID, DBO.IAPPLICATIONSTAT.APPLICATION, DBO.IAPPLICATIONSTAT.CALLSABANDONED, DBO.IAPPLICATIONSTAT.CALLSABANDONEDAFTTHRESHOLD, DBO.IAPPLICATIONSTAT.CALLSABANDONEDDELAY, DBO.IAPPLICATIONSTAT.CALLSANSWERED, DBO.IAPPLICATIONSTAT.CALLSANSWEREDAFTTHRESHOLD, DBO.IAPPLICATIONSTAT.CALLSANSWEREDDELAY, DBO.IAPPLICATIONSTAT.CALLSANSWEREDDELAYATSKILLSET, DBO.IAPPLICATIONSTAT.CALLSCONFERENCEDIN, DBO.IAPPLICATIONSTAT.CALLSCONFERENCEDOUT, DBO.IAPPLICATIONSTAT.CALLSGIVENBROADCAST, DBO.IAPPLICATIONSTAT.CALLSGIVENDEFAULT, DBO.IAPPLICATIONSTAT.CALLSGIVENFORCEBUSY, DBO.IAPPLICATIONSTAT.CALLSGIVENFORCEDISCONNECT, DBO.IAPPLICATIONSTAT.CALLSGIVENFORCEOVERFLOW, DBO.IAPPLICATIONSTAT.CALLSGIVENHOSTLOOKUP, DBO.IAPPLICATIONSTAT.CALLSGIVENIVR, DBO.IAPPLICATIONSTAT.CALLSGIVENMUSIC, DBO.IAPPLICATIONSTAT.CALLSGIVENNACD, DBO.IAPPLICATIONSTAT.CALLSGIVENRAN, DBO.IAPPLICATIONSTAT.CALLSGIVENROUTETO, DBO.IAPPLICATIONSTAT.CALLSNACDOUT, DBO.IAPPLICATIONSTAT.CALLSOFFERED, DBO.IAPPLICATIONSTAT.CALLSTRANSFERREDIN, DBO.IAPPLICATIONSTAT.CALLSTRANSFERREDOUT, DBO.IAPPLICATIONSTAT.IVRABANDONED, DBO.IAPPLICATIONSTAT.IVRTERMINATED, DBO.IAPPLICATIONSTAT.IVRTRANSFERRED, DBO.IAPPLICATIONSTAT.MAXCALLSABANDONEDDELAY, DBO.IAPPLICATIONSTAT.MAXCALLSANSDELAY, DBO.IAPPLICATIONSTAT.MAXCALLSANSDELAYATSKILLSET, DBO.IAPPLICATIONSTAT.MAXNETOUTCALLSABANDONEDDELAY, DBO.IAPPLICATIONSTAT.MAXNETOUTCALLSANSWEREDDELAY, DBO.IAPPLICATIONSTAT.NETOUTCALLS, DBO.IAPPLICATIONSTAT.NETOUTCALLSABANDONED, DBO.IAPPLICATIONSTAT.NETOUTCALLSABANDONEDDELAY, DBO.IAPPLICATIONSTAT.NETOUTCALLSANSWERED, DBO.IAPPLICATIONSTAT.NETOUTCALLSANSWEREDDELAY, DBO.IAPPLICATIONSTAT.NETOUTCALLSREACHNONISDN, DBO.IAPPLICATIONSTAT.TIMEBEFOREDEFAULT, DBO.IAPPLICATIONSTAT.TIMEBEFOREFORCEBUSY, DBO.IAPPLICATIONSTAT.TIMEBEFOREFORCEDISCONNECT, DBO.IAPPLICATIONSTAT.TIMEBEFOREFORCEOVERFLOW, DBO.IAPPLICATIONSTAT.TIMEBEFOREINTERFLOW, DBO.IAPPLICATIONSTAT.TIMEBEFOREIVRTRANSFERRED, DBO.IAPPLICATIONSTAT.TIMEBEFORENACDOUT, DBO.IAPPLICATIONSTAT.TIMEBEFORENETOUT, DBO.IAPPLICATIONSTAT.TIMEBEFOREREACHNONISDN, DBO.IAPPLICATIONSTAT.TIMEBEFOREROUTETO, DBO.IAPPLICATIONSTAT.POSTCALLPROCESSINGTIME, DBO.IAPPLICATIONSTAT.TALKTIME, DBO.IAPPLICATIONSTAT.WAITTIME, DBO.IAPPLICATIONSTAT.DNOUTEXTCALLSTALKTIME, DBO.IAPPLICATIONSTAT.DNOUTINTCALLSTALKTIME, DBO.IAPPLICATIONSTAT.ABDDELAY2, DBO.IAPPLICATIONSTAT.ABDDELAY4, DBO.IAPPLICATIONSTAT.ABDDELAY6, DBO.IAPPLICATIONSTAT.ABDDELAY8, DBO.IAPPLICATIONSTAT.ABDDELAY10, DBO.IAPPLICATIONSTAT.ABDDELAY12, DBO.IAPPLICATIONSTAT.ABDDELAY14, DBO.IAPPLICATIONSTAT.ABDDELAY16, DBO.IAPPLICATIONSTAT.ABDDELAY18, DBO.IAPPLICATIONSTAT.ABDDELAY20, DBO.IAPPLICATIONSTAT.ABDDELAY22, DBO.IAPPLICATIONSTAT.ABDDELAY24, DBO.IAPPLICATIONSTAT.ABDDELAY26, DBO.IAPPLICATIONSTAT.ABDDELAY28, DBO.IAPPLICATIONSTAT.ABDDELAY30, DBO.IAPPLICATIONSTAT.ABDDELAY32, DBO.IAPPLICATIONSTAT.ABDDELAY34, DBO.IAPPLICATIONSTAT.ABDDELAY36, DBO.IAPPLICATIONSTAT.ABDDELAY38, DBO.IAPPLICATIONSTAT.ABDDELAY40, DBO.IAPPLICATIONSTAT.ABDDELAY42, DBO.IAPPLICATIONSTAT.ABDDELAY44, DBO.IAPPLICATIONSTAT.ABDDELAY46, DBO.IAPPLICATIONSTAT.ABDDELAY48, DBO.IAPPLICATIONSTAT.ABDDELAY50, DBO.IAPPLICATIONSTAT.ABDDELAY52, DBO.IAPPLICATIONSTAT.ABDDELAY54, DBO.IAPPLICATIONSTAT.ABDDELAY56, DBO.IAPPLICATIONSTAT.ABDDELAY58, DBO.IAPPLICATIONSTAT.ABDDELAY60, DBO.IAPPLICATIONSTAT.ABDDELAY70, DBO.IAPPLICATIONSTAT.ABDDELAY80, DBO.IAPPLICATIONSTAT.ABDDELAY90, DBO.IAPPLICATIONSTAT.ABDDELAY100, DBO.IAPPLICATIONSTAT.ABDDELAY110, DBO.IAPPLICATIONSTAT.ABDDELAY120, DBO.IAPPLICATIONSTAT.ABDDELAY130, DBO.IAPPLICATIONSTAT.ABDDELAY140, DBO.IAPPLICATIONSTAT.ABDDELAY150, DBO.IAPPLICATIONSTAT.ABDDELAY160, DBO.IAPPLICATIONSTAT.ABDDELAY170, DBO.IAPPLICATIONSTAT.ABDDELAY180, DBO.IAPPLICATIONSTAT.ABDDELAY190, DBO.IAPPLICATIONSTAT.ABDDELAY200, DBO.IAPPLICATIONSTAT.ABDDELAY210, DBO.IAPPLICATIONSTAT.ABDDELAY220, DBO.IAPPLICATIONSTAT.ABDDELAY230, DBO.IAPPLICATIONSTAT.ABDDELAY240, DBO.IAPPLICATIONSTAT.ABDDELAY250, DBO.IAPPLICATIONSTAT.ABDDELAY260, DBO.IAPPLICATIONSTAT.ABDDELAY270, DBO.IAPPLICATIONSTAT.ABDDELAY280, DBO.IAPPLICATIONSTAT.ABDDELAY290, DBO.IAPPLICATIONSTAT.ABDDELAY300, DBO.IAPPLICATIONSTAT.ABDDELAY360, DBO.IAPPLICATIONSTAT.ABDDELAY420, DBO.IAPPLICATIONSTAT.ABDDELAY480, DBO.IAPPLICATIONSTAT.ABDDELAY540, DBO.IAPPLICATIONSTAT.ABDDELAY600, DBO.IAPPLICATIONSTAT.ABDDELAYBEYOND, DBO.IAPPLICATIONSTAT.ANSDELAY2, DBO.IAPPLICATIONSTAT.ANSDELAY4, DBO.IAPPLICATIONSTAT.ANSDELAY6, DBO.IAPPLICATIONSTAT.ANSDELAY8, DBO.IAPPLICATIONSTAT.ANSDELAY10, DBO.IAPPLICATIONSTAT.ANSDELAY12, DBO.IAPPLICATIONSTAT.ANSDELAY14, DBO.IAPPLICATIONSTAT.ANSDELAY16, DBO.IAPPLICATIONSTAT.ANSDELAY18, DBO.IAPPLICATIONSTAT.ANSDELAY20, DBO.IAPPLICATIONSTAT.ANSDELAY22, DBO.IAPPLICATIONSTAT.ANSDELAY24, DBO.IAPPLICATIONSTAT.ANSDELAY26, DBO.IAPPLICATIONSTAT.ANSDELAY28, DBO.IAPPLICATIONSTAT.ANSDELAY30, DBO.IAPPLICATIONSTAT.ANSDELAY32, DBO.IAPPLICATIONSTAT.ANSDELAY34, DBO.IAPPLICATIONSTAT.ANSDELAY36, DBO.IAPPLICATIONSTAT.ANSDELAY38, DBO.IAPPLICATIONSTAT.ANSDELAY40, DBO.IAPPLICATIONSTAT.ANSDELAY42, DBO.IAPPLICATIONSTAT.ANSDELAY44, DBO.IAPPLICATIONSTAT.ANSDELAY46, DBO.IAPPLICATIONSTAT.ANSDELAY48, DBO.IAPPLICATIONSTAT.ANSDELAY50, DBO.IAPPLICATIONSTAT.ANSDELAY52, DBO.IAPPLICATIONSTAT.ANSDELAY54, DBO.IAPPLICATIONSTAT.ANSDELAY56, DBO.IAPPLICATIONSTAT.ANSDELAY58, DBO.IAPPLICATIONSTAT.ANSDELAY60, DBO.IAPPLICATIONSTAT.ANSDELAY70, DBO.IAPPLICATIONSTAT.ANSDELAY80, DBO.IAPPLICATIONSTAT.ANSDELAY90, DBO.IAPPLICATIONSTAT.ANSDELAY100, DBO.IAPPLICATIONSTAT.ANSDELAY110, DBO.IAPPLICATIONSTAT.ANSDELAY120, DBO.IAPPLICATIONSTAT.ANSDELAY130, DBO.IAPPLICATIONSTAT.ANSDELAY140, DBO.IAPPLICATIONSTAT.ANSDELAY150, DBO.IAPPLICATIONSTAT.ANSDELAY160, DBO.IAPPLICATIONSTAT.ANSDELAY170, DBO.IAPPLICATIONSTAT.ANSDELAY180, DBO.IAPPLICATIONSTAT.ANSDELAY190, DBO.IAPPLICATIONSTAT.ANSDELAY200, DBO.IAPPLICATIONSTAT.ANSDELAY210, DBO.IAPPLICATIONSTAT.ANSDELAY220, DBO.IAPPLICATIONSTAT.ANSDELAY230, DBO.IAPPLICATIONSTAT.ANSDELAY240, DBO.IAPPLICATIONSTAT.ANSDELAY250, DBO.IAPPLICATIONSTAT.ANSDELAY260, DBO.IAPPLICATIONSTAT.ANSDELAY270, DBO.IAPPLICATIONSTAT.ANSDELAY280, DBO.IAPPLICATIONSTAT.ANSDELAY290, DBO.IAPPLICATIONSTAT.ANSDELAY300, DBO.IAPPLICATIONSTAT.ANSDELAY360, DBO.IAPPLICATIONSTAT.ANSDELAY420, DBO.IAPPLICATIONSTAT.ANSDELAY480, DBO.IAPPLICATIONSTAT.ANSDELAY540, DBO.IAPPLICATIONSTAT.ANSDELAY600, DBO.IAPPLICATIONSTAT.ANSDELAYBEYOND, DBO.IAPPLICATIONSTAT.TIME, DBO.IAPPLICATIONSTAT.SITEID, DBO.IAPPLICATIONSTAT.SITE, DBO.IAPPLICATIONSTAT.CONTACTTYPE FROM DBO.IAPPLICATIONSTAT WHERE timestamp> cast( {d '2012-11-10'} as date)]


Thread: READER_1_1_1
Process ID: 1824
Message Code: RR_4049
Message: RR_4049 SQL Query issued to database : (Tue Nov 13 11:06:30 2012)

Thread: READER_1_1_1
Process ID: 1824
Message Code: RR_4035
Message: SQL Error [
FnName: Prepare -- [Cache ODBC][State : 37000][Native Code 4]
[libcacheodbc.so]
[SQLCODE: <-4>:<A term expected, beginning with one of the following: identifier, constant, aggregate, %ALPHAUP, %EXACT, %MVR, %SQLSTRING, %SQLUPPER, %STRING, %UPPER, $$, :, +, -, (, NOT, EXISTS, or FOR>]
[Location: <Prepare>]
[%msg: < A term expected, beginning with either of: (, NOT, EXISTS, or FOR^SELECT DBO . IAPPLICATIONSTAT . TIMESTAMP , DBO . IAPPLICATIONSTAT . APPLICATIONID , DBO . IAPPLICATIONSTAT . APPLICATION , DBO . IAPPLICATIONST].

Как же задать?

Полная выборка работает.
Фильтр по полю where applicationid=10006 тоже отработало без ошибок.

В Oracle, поле которое я фильтрую выглядит так: 13.11.12 02:00:00,000000

WHERE TIMESTAMP> {d '2012-13-10'}]
При таком фильтре ошибка:

SQL Error [
FnName: Prepare -- [Cache ODBC][State : 37000][Native Code 4]
[libcacheodbc.so]
[SQLCODE: <-4>:<A term expected, beginning with one of the following: identifier, constant, aggregate, %ALPHAUP, %EXACT, %MVR, %SQLSTRING, %SQLUPPER, %STRING, %UPPER, $$, :, +, -, (, NOT, EXISTS, or FOR>]
[Location: <Prepare>]
[%msg: < A term expected, beginning with either of: (, NOT, EXISTS, or FOR^SELECT DBO . IAPPLICATIONSTAT . TIMESTAMP , DBO . IAPPLICATIONSTAT . APPLICATIONID , DBO . IAPPLICATIONSTAT . APPLICATION , DBO . IAPPLICATIONST].

Может там нужно задавать с определенными настройками сессии?

Спасибо огромное за помощь!

WHERE IAPPLICATIONSTAT.TIMESTAMP>'2012-11-10' - вот так получилось!

получается нужно было определить TIMESTAMP.