How to fetch more than 50 rows for a SQL request in TIBCO Data Virtualization Studio?
Article ID: KB0071769
Updated On:
| Products | Versions |
|---|---|
| TIBCO Data Virtualization | All supported versions |
Description
By default, the number of rows returned for a SQL query in TDV Studio is 50 records. Though this number is optimal there may be requirements to get more data for such SQL requests.
Issue/Introduction
How to fetch more than 50 rows for a SQL request in TIBCO Data Virtualization Studio?
Environment
All supported environments
Resolution
This configuration can be altered by changing the "Fetch Row Size" setting in TDV Studio, by navigating to Administration > Configuration >> Studio > Data > Fetch Row Size.
Feedback
Yes
No
Powered by
