optimization of sql statement
0 posts in topic
Flat View  Flat View

Posted By:   salman_zada
Posted On:   Friday, July 27, 2001 02:48 AM

can we define specific number of records say 10 in sql statement like(
select * from fileName where ... first 10 )remember only those sql statement can be run from java which can be run from sql interactive mode of AS/400. i have already use setMaxRow and setFetchSize but both first get the whole data and then filter while we want just come specific data

About | Sitemap | Contact