Dynamic SQL is Truncating

Hello All,

With toad data point, I am executing a procedure using Netezza ODBC drive which prints lengthy sql statements however sql statement is truncating in Message tab. When same proc running in “Aginity Workbentch for Netezza” , the printed sql statement is not truncated. Is there a limit on sql statement message size for “Toad Data Point”? is there a way to increase it? If not, is there any workaround?

Hi,

It looks like you already contactacted Debbie with the issue. She created task QAT-9822 to investigate and fix it.

Thanks

Aleksey

This is now fixed and in the current Beta. 4.2.0.603