I am developing a Java Web service allow paging when fetching big data set from a DB2 Database on a IBM Mid Range Machine (AS400). 

For example; if there are 10000 records in a data set, I want to fetch them in 1000 blocks at a time.

I found this [article](https://www.ibm.com/developerworks/community/blogs/SQLTips4DB2LUW/entry/limit_offset?lang=en) that explains that I can use LIMIT, and OFFSET. But I need to set the `DB2_COMPATIBILITY_VECTOR` variable to `MYS`.

Now I have been googling and saw you can use the `db2set` to set this variable. But I have not been able to find out where to type this command in?

I am developing on a windows machine, and I have the iSeries installed, and I have access to the IBM Mid Range Machine via the iSeries 5250 emulator.

I know this must be a real noob question, but How do I go about changing `DB2_COMPATIBILITY_VECTOR` variable to `MYS`?