Re: SQL statements through JDBC causing QPSRVDMP's

[Pete Helgren <Pete@xxxxxxxxxx>]

Thanks.  I'll see if I can get them a bit more current at V5R4M0.  I was 
hoping to test it on the 270 we have here at the office but we are only 
running V5R3M0 so the row_number() over() syntax forces an error before 
it even gets to return data.

I checked the archives and it looks like this will be a tough on to 
"fix" on V5R3M0.  I am search for UDF's that might approximate the 
function right now.  If I come up dry on a search, I post here.

Pete


rob@xxxxxxxxx wrote:
> I did a search of ptf cover letters for "row_number".  Apparently there 
> were some hits at 540, 545 generating nasty MCH* genre of messages.
> Didn't see any ptf cover letters for 530,535 mentioning "row_number".
>
> http://www-912.ibm.com/a_dir/as4ptf.nsf/$$search?openform
>
>
> Rob Berendt
>