"Unrecognized SQL statement" - UNION ALL

[SBSA_DW2]

Hi there

Is there a known issue when using UNION ALL in the teradata API stage? We have a piece of code:

SELECT BLAH, BLAH2 UNION ALL
SELECT BLAH3, BLAH4 UNION ALL...
(45 UNION ALL statements)

that returns a fatal error "Unrecognized SQL statement". We've removed the UNION ALL statements (leaving us with a bland looking SELECT statement and it works.

Any known issues with the Teradata API (Or any API for that matter), and UNION ALL?

Thanks!

[chulett]

You'd probably have to contact your official support provider to see if there are any known issues. Could it be something I've seen before in other stages, a 'length' issue where some of the sql is getting truncated thus making it invalid? How long is your combined union?

[Sainath.Srinivasan]

What happens if you have only one UNION ALL ? Did you try UNION ?

You can see loads of hits for terdata union all. Google for information.

[SBSA_DW2]

turns out there was a syntax error or something that caused the error to appear!