Select adapter service - Maxrowcount

Hi folks,

Is there a way to pass maxrowcount dynamically during run time to a select adapter service, without hardcoding to a specific value in select adapter service?

I don’t think it’s possible with “Maximum Row”. However, you can use Dynamic SQL adapter, wherein you can use the rownum or limit operators in the query, according to your database type and pass its value as an input variable to the adapter service.

Examples -


1 Like

rownum passing it in adapter as a input parameter worked

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.