Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I'm hitting an error in Teradata as invalid timestamp (SqlState: S1000, ErrorCode: 4294960536, ErrorMsg: [Teradata][ODBC Teradata Driver][Teradata Database] Invalid timestamp.)
Below is the script.
Max:
load *;
SQL select
Max(MODIFIED_DATE) AS A
from TABLE1 WHERE ACTIVE_FLAG='N';
let maxDate= Timestamp(Peek('Max',0,'A'));
Drop Table Max;
TBL:
Load*,
Sql select
Field1,
Field2,
Field3
from TABLE1 WHERE ACTIVE_FLAG='Y' OR (ACTIVE_FLAG='N' AND MODIFIED_DATE>= cast ('$(maxDate)' as TIMESTAMP(0) FORMAT 'MM/DD/YYYYBHH:MI:SS')) AND MANUAL_FLAG='Y';
Please suggest what's going wrong here.
Thanks in advance
Hi,
Are you sure that
cast ('$(maxDate)' as TIMESTAMP(0) FORMAT 'MM/DD/YYYYBHH:MI:SS'))
is valid SQL expression?
Edit:
As I rememeber you are not allowed use Qliikview variables in SQL statement.
Kind regards,
Andrei
There's no difference without it too as i felt TIMESTAMP() would be fine and tried but there's no difference.
Does you query work without MODIFIED_DATE>= cast ('$(maxDate)' as TIMESTAMP(0) FORMAT 'MM/DD/YYYYBHH:MI:SS')) expression?
Yes.It's working fine without that statement.
The problem in using Qlikview variable in SQL statement.
Just load data without this condition, than Reload table using this condition.
Hope this helps.
Andrei