multiple lines JDBC queries to IBM UniVerse failing?

[peterivanick]

Hola -

So, we've got JDBC access to UniVerse 10.1.4 working on CFMX7.1, but have
found that a multiple line query fails although the exact same query works fine
if it is entirely on a single line (which of course makes it more difficult to
read/debug). Is this expected behavior or have we run into an odd case? Any
workarounds if it is? This is our first foray into jdbc so perhaps this is a
standard jdbc issue I'm unaware of, any help gratefully received & much
appreciated, thanks very mcuh.

[kwoes]

I have the same issue with JDBC & Universe. I just decided to leave the query on a single line.

[Borg]

OK, here is what I have seen in the past with carriage return/line feeds
between CF and Universe. My initial guess, would be the the crlf is forcing UV
to interpret the query with a field mark(chr(253)),and throwing your for a
loop. I have seen odd behavior in the past with textarea HTML tags and records
getting all jacked up because the crlf was interpreted by UV as a field mark,
and moving data down instead of storing in the the proper field in the file.