I don’t believe that MAXRECORDS is part of the “SQL Standard”. I know a few databases (big ones included) have implemented it, but it’s not a part of DB2. I believe it can be set as a property on OLE and ADO DB providers.
Your automatic generator doesn’t generate standard SQL. It generates a proprietary extension that is appropriate only to certain DBMSs and can’t be used cross-platform. Get a different tool.