#DateForumTypeThreadPost
605 Feb 2015 @ 12:06 PSTDatabaseReplyError: Syntax error: expected something between the word 'a' and '.'Hi Dieter. Thanks again.  it fixed the issue.    
505 Feb 2015 @ 09:40 PSTDatabaseReply[Teradata Database] Numeric overflow occurred during computation.Unable to get catalog string. Connection StringThanks Vanderberg I have tried casting it but it is still erroring cast(count(a.userid) as bigint) UserCount there are only 468 records in the table  
405 Feb 2015 @ 06:50 PSTDatabaseTopic[Teradata Database] Numeric overflow occurred during computation.Unable to get catalog string. Connection StringHi Guys [Teradata Database] Numeric overflow occurred during computation.Unable to get catalog string. Connection String I am getting the above error when trying to runthe following sql has anyo...
304 Feb 2015 @ 01:50 PSTDatabaseReplyError: Syntax error: expected something between the word 'a' and '.'thanks a million Dieter. I will test it tomorrow and let you know how it went.  
204 Feb 2015 @ 01:11 PSTDatabaseTopic expected something between the word 'xx' and ','.Unable to get.. select a12.xx  xx,  a12.bb  bb from (select a11.zz zz,  CASE WHEN substring(a11.zz ,2,1)  between '0' and '9' THEN substring(a11.zz,1,1)  ELSE sub...
104 Feb 2015 @ 12:06 PSTDatabaseReplyError: Syntax error: expected something between the word 'a' and '.' select a12.xx  xx,  a12.bb  bb from (select a11.zz zz,  CASE WHEN substring(a11.zz ,2,1)  between '0' and '9' THEN substring(a11.zz,1,1)  ELSE sub...