topic Re: Script error (Invalid timestamp in Teradata in QlikView

Script error (Invalid timestamp in Teradata

Wed, 14 May 2014 12:57:03 GMT

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

Re: Script error (Invalid timestamp in Teradata

crusader_ — Wed, 14 May 2014 13:03:24 GMT

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

Re: Script error (Invalid timestamp in Teradata

Wed, 14 May 2014 13:10:31 GMT

There's no difference without it too as i felt TIMESTAMP() would be fine and tried but there's no difference.

Re: Script error (Invalid timestamp in Teradata

crusader_ — Wed, 14 May 2014 13:19:33 GMT

Does you query work without MODIFIED_DATE>= cast ('$(maxDate)' as TIMESTAMP(0) FORMAT 'MM/DD/YYYYBHH:MI:SS')) expression?

Re: Script error (Invalid timestamp in Teradata

Wed, 14 May 2014 13:35:34 GMT

Yes.It's working fine without that statement.

Re: Script error (Invalid timestamp in Teradata

crusader_ — Wed, 14 May 2014 13:41:41 GMT

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