But I nearly made it working on our environment.
I try to implement some needed schema functionnalities for ActiveRecord needs.
The one I'm on is the LIMIT sql function.
Unfortunately, DB2 has no support or integrated function to manage limit offsets. So, I have to modify the Find SQL query in order to make GridView working, for instance.
I need to add a column to the query and modify the query condition too...
SELECT * from (SELECT p.*,row_number() over() as rn from products as p) as col where rn between 1 and 20
I don't know the whole Yii Framework and I want to reuse some existing functions avoiding to write so much code.
The first solution in my mind was to rewrite (by class extension) the applyLimit() CDbCommandBuilder class function. But it could be hard to modify the whole sql query text.
The second could be writing modifications in createFindCommand() function directly.
If someone can give me the way to the light...