Archives of the TeradataForum
Message Posted: Fri, 24 Jan 2003 @ 23:44:40 GMT
Subj: | | Business Objects SQL Parsing |
|
From: | | Mark Buckley |
We utilize Business Objects against Teradata and we often modify the SQL generated by Business Objects.
The problem is that BO sends the SQL to Teradata to parse and adds a false condition where 1=0. Oracle recognizes this false condition
and does not try and execute the SQL but just runs it through the parsing engine. Teradata actually runs the query which can result in a
long delay if it is a large query.
Has anyone come across this and found a way of getting either Business Objects to parse it locally or get teradata to parse it without
running it?
Teradata has confirmed that this is the way Teradata works and it would require a significant change to their parsing engine.
|