Archives of the TeradataForum

Message Posted: Fri, 24 Jan 2003 @ 23:44:40 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

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.

	<Prev	Next>		<<First	<Prev	Next>	Last>>