Join this online group to communicate across IBM product users and experts by sharing advice and best practices with peers and staying up to date regarding product enhancements.
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 -
KM
rownum passing it in adapter as a input parameter worked