JDBC Data Source: "Test Load 20 Records" Does Not Limit The SQL Query to Bring Back Only 20 RecordsDescriptionYou have a JDBC data source that sets the Query value to "All Rows from Table" or has it set to "Specific SQL" with this example SQL: SELECT * FROM Employee If you select "Test Load 20 Records" or select "Load All Records" from the Related Links the SQL query sent is the same for both options. In other words selecting "Test Load 20 Records" does not send SQL that limits the number of records to be returned to 20. When selecting "Test Load 20 Records" the system just loads the first 20 records into the import set table, but the SQL query is the same as when selecting "Load All Records" Using the example of Query = "Specific SQL": SELECT * FROM Employee If selecting "Test Load 20 Records" or "Load All Records" and the mid server agent log is checked the query will be the same (SELECT * FROM Employee): 04/23/20 14:19:03 (581) Worker-Standard:JDBCProbe-d23246e61b5c1c5055ca64a6bc4bcbe9 Worker starting: JDBCProbe source: b82c25784f02260061d96bd18110c76504/23/20 14:19:03 (914) Worker-Standard:JDBCProbe-d23246e61b5c1c5055ca64a6bc4bcbe9 Waiting for connection semaphore04/23/20 14:19:03 (914) Worker-Standard:JDBCProbe-d23246e61b5c1c5055ca64a6bc4bcbe9 Obtained connection semaphore04/23/20 14:19:03 (914) Worker-Standard:JDBCProbe-d23246e61b5c1c5055ca64a6bc4bcbe9 SELECT * FROM Employee04/23/20 14:19:03 (918) Worker-Standard:JDBCProbe-d23246e61b5c1c5055ca64a6bc4bcbe9 Enqueuing: /u01/mid_server/agent/work/monitors/ECCSender/output_s/ecc_queue.171a8e888eb0000001.xml04/23/20 14:19:03 (924) Worker-Standard:JDBCProbe-d23246e61b5c1c5055ca64a6bc4bcbe9 Enqueuing: /u01/mid_server/agent/work/monitors/ECCSender/output_s/ecc_queue.171a8e888ef0000001.xml04/23/20 14:19:03 (925) Worker-Standard:JDBCProbe-d23246e61b5c1c5055ca64a6bc4bcbe9 Worker completed: JDBCProbe source: b82c25784f02260061d96bd18110c765 time: 0:00:00.33404/23/20 14:19:03 (956) ECCSender.1 Sending ecc_queue.171a8e888eb0000001.xml04/23/20 14:19:04 (126) ECCSender.1 Sending ecc_queue.171a8e888ef0000001.xml If you want to place a limit on how many rows are returned it will be necessary to set Query = "Specific SQL" and modify the SQL to only return a limited number of rows based on the syntax of the database type being queried.Release or EnvironmentApplies to any release.