I have come across the same error 'Received exception with message ‘DB2 SQL Error: SQLCODE=-104, SQLSTATE=42601, SQLERRMC=LIMIT;;FETCH FIRST <n> ROWS ONLY, DRIVER=3.69.78' which occurs because of the incorrect delegation. In order to resolve this error, I had performed the following steps:
* Open your data source.
* Navigate to Source Configuration.
* Set the option 'Delegate FETCH clause' to 'No'.
* Save the change.
This fixed the issue.
For more information, you can have a look at the section [Data Source Configuration Properties](https://community.denodo.com/docs/html/browse/latest/vdp/administration/creating_data_sources_and_base_views/data_source_configuration_properties/data_source_configuration_properties#data-source-configuration-properties) of the Virtual DataPort Administration Guide.
Additionally, If you have more questions and if you are a valid support user, I would suggest you to raise a support ticket in the Denodo Support Site so that our support team can help you.
Hope this helps!