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!
"Unrecognized SQL statement" - UNION ALL
Moderators: chulett, rschirm, roy
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?
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
-
- Participant
- Posts: 3337
- Joined: Mon Jan 17, 2005 4:49 am
- Location: United Kingdom