Unanswered: sybase stored proceduer returns only 100 sometimes through java resultset
I've a sybase stored procedure and it has 3000+ records BUT it returns only 100 sometimes through java resultset, callable statement. Stored procedure has only one query like select * from A, B where A.i=B.i, it has nothing very straight forward. Not sure where the issue is.
Could you please someone help me on this. Thanks in advance.