I have a fairly long (50+ lines;) SQL statement within a CASE of a method. It didn't work in the method, but worked when the exact same SQL is copied to a PRG that's called. Easy enough solution, but does anyone know why this is so?
The debugger would stop in the middle of the SQL statement even when that CASE condition was skipped, as if it read something in the SQL that made it think it was the next CASE condition.
TIA