Custom SQL Statement too long?

actiview · Post by **actiview** » Sun Jan 04, 2009 9:07 am

Hi everyone,

I ran into a strange problem, upgrading from 7.5 to 8.1:
When I run a 40-row lng, complex custom SQL statement I receive an Abnormal Termination. When I cut down the query length (by deleting some CR/LFs), it magically works fine!

This never happened in 7.5, only in 8.1.

An ideas why this happens and how to fix this?

Thanks!

chulett · Post by **chulett** » Sun Jan 04, 2009 9:15 am

I've seen extra CRs cause the same problem in 7.x as well as 'too long' sqls. Sometimes the fix is to remove all of the CRs so it's one long statement, sometimes you need to create a view from the sql and then leverage the view in DataStage.