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!
Custom SQL Statement too long?
Moderators: chulett, rschirm, roy
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.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers