We are using PAM 4.2 SP01.
I am able to fetch max 512 rows from the database using Query DB operator.
Please advise how can I fetch more than 512 rows.
That limitation is by design to prevent performance impacts to PAM because of queries returning large amounts of data. Use where clauses to filter the data and if more that 512 rows are necessary, split the query between multiple operators and design the query appropriately.
Retrieving data ...