Hello, I use OJB with the PB API and DB2.
I want to add "FETCH x ROWS ONLY" to a query to limit the number of rows returned (I know i could do this with setEndAtIndex(x) too, but "FETCH x ROWS ONLY" is faster). What is missing is an addSql() method on the query to add free form sql to the query the same way addOrderBy()... works. There is auch a addSql() method for criteria. Is there any reason why i can't add free form sql to a query, or is there some other way to do this ? Thanks, Michael --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]