Archives of the TeradataForum

Message Posted: Wed, 06 Aug 2008 @ 19:56:11 GMT

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

Hi Olaf,

I had something similar to this a few months ago. In this case we used Cognos which was producing a huge SQL.

Victor gave me some hints, but in the end we had to work with a view which covers some of the SQL to narrow down the size of the SQL which will be send to the Database.

Teradata seems to have 2 limits:

1. SQL which will be send from any kind of Application with a limit of 64k (at least till 6.2)

2. SQL which will be generated by the ODBC Driver with a limit of 1MB

This means even though your SQL is not exceeding the limit of 64k, OBDBC can generate such a huge SQL that your limit will exceed anyway.

In addition to the view disabled parsing and preparation on the ODBC Driver, this could also help you to shrink down the SQL at least on the ODBC side.

Hope this helps.

Regards

Joerg

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