Changeset 3301

Show
Ignore:
Timestamp:
01/27/08 18:21:00 (16 years ago)
Author:
jerome
Message:

Found the solution to missing "LIMIT" SQL statement under DB2.
Noted it as part of a TODO comment.

Files:
1 modified

Legend:

Unmodified
Added
Removed
  • pykota/trunk/pykota/storages/sql.py

    r3294 r3301  
    827827        query += " ORDER BY jobhistory.id DESC" 
    828828        if limit : 
    829             query += " LIMIT %s" % self.doQuote(int(limit)) # TODO : LIMIT is not supported under DB2. 
     829            # TODO : LIMIT is not supported under DB2. 
     830            # TODO : so we must use something like " FETCH FIRST %i ROWS ONLY" % self.doQuote(int(limit)) 
     831            query += " LIMIT %s" % self.doQuote(int(limit))  
    830832        jobs = []     
    831833        result = self.doSearch(query)