sorry, adding free form sql to a query is not supported. please ignore my previous post .
jakob
Michael Schulze wrote:
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]
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
