Simple SQL failing to parse

Teradata Studio
Senior Supporter

Simple SQL failing to parse

Hi,

I'm using 15.10.0.3 and whilst most SQL requests run fine the following generates a message "Parse error splitting statement" and will not run. It runs fine using SQLA through a dot net connection.

SELECT eid, ename, jobdur (FORMAT  'YYYY-MM-DD')

FROM emp22

WHERE eid = 1001

ORDER BY jobdur;

It seems to be the 'ORDER BY' clause / line which is causing the problem because I can run the sql if that line is ommitted.

All help gratefully received.

Cheers,

Dave

Ward Analytics Ltd - information in motion
www: http://www.ward-analytics.com
2 REPLIES
Teradata Employee

Re: Simple SQL failing to parse

I copied the SELECT statement and pasted it into the SQL Editor in 15.10.00.03 and I see no parse errors. Did you perhaps have some invalid, non-printing characters in the text when you encountered the parse error?

When you get the message about not being able to split statements, you can still run them by selecting the Execute All option. That does not use the parser to find individual statements.

Senior Supporter

Re: Simple SQL failing to parse

Hi Chuckbert,

Thanks for pointing out the 'execute all' option, I had missed that it didn't use the parser.

I think you may be correct in having 'non printing' characters as I trie dthis again today and the query worked fine. Ho hum...

Cheers,

Dave

Ward Analytics Ltd - information in motion
www: http://www.ward-analytics.com