scrollable resultset

[RMuthuKumaran]

When we are trying to execute scrollable resultset APIs (rs.last etc.,) we get the following error. (Database version: UDB 7. on Windows. Driver: Type 4.)
This method should only be called on ResultSet objects that are scrollable(type TYPE_SCROLL_SEN SITIVE or TYPE_SCROLL_INS ENSITIVE).

But the same(scrollable resultset) works on DB2 Version 7.1 on DB2 z/OS version.

Can anyone help in solving for the issue in scrollable resultset in UDB 7. on Windows. Driver: Type 4.

Thanks in Advance,

[r035198x]

When we are trying to execute scrollable resultset APIs (rs.last etc.,) we get the following error. (Database version: UDB 7. on Windows. Driver: Type 4.)
This method should only be called on ResultSet objects that are scrollable(type TYPE_SCROLL_SEN SITIVE or TYPE_SCROLL_INS ENSITIVE).

But the same(scrollable resultset) works on DB2 Version 7.1 on DB2 z/OS version.

Can anyone help in solving for the issue in scrollable resultset in UDB 7. on Windows. Driver: Type 4.

Thanks in Advance,

Apparently there is a restriction on the scrollable resultset. See here.

[RMuthuKumaran]

Apparently there is a restriction on the scrollable resultset. See here.

Thanks for the reply.
I seen the mentioned URL and confirmed that the datatype we use, does not match with any of the mentioned restricted data type. One thing i want to confirm is, can the scrollable resultset be used on windows version UDB 7 with type 4 driver

[r035198x]

Thanks for the reply.
I seen the mentioned URL and confirmed that the datatype we use, does not match with any of the mentioned restricted data type. One thing i want to confirm is, can the scrollable resultset be used on windows version UDB 7 with type 4 driver

This does not seem to be containing the details for the type 4 too. I'll keep checking. Let me know when you get any other info on the problem.